maria-discuss team mailing list archive

[Daniel Black <daniel.black@xxxxxxxxxxx>]

On 08/12/16 08:51, Jon Foster wrote:
> We are having trouble with MariaDB hanging due to a "semaphore wait". We
> then have to shut MariaDB down as it typically won't recover, unless it
> restarts itself, which happens if we wait long enough. But if its gone
> on long enough MariaDB won't even shutdown, it hangs indefinitely
> waiting for some other internal service. I don't remember the exact name
> and we've been fast enough I haven't seen it in a while.
> 
> We've had the database on two completely different servers and still see
> the problem. Both servers were bought new for this project and are a
> year or less old. They are running all SSD drives, Debian 7 64bit with
> MariaDB 10.1 from the MariaDB APT repository.
> 
> Since the XtraDB engine was usually mentioned in the logged messages we
> switched back to the Oracle InnoDB engine. Although this seems to have
> reduced the frequency it didn't fix it.
> 
> Can anyone give some advice on fixing this. It really seams like a bug
> in MariaDB. I'll try to provide any needed info.
> 
> TIA - Jon
> 

Needed info:
* exact MariaDB version 10.1.X
* mariadb configuration
* what is the entire mysql log from the startup until the "semaphore wait"
* how are you determining "semaphore wait"
* is a SHOW FULL PROCESS LIST possible? if so contents?
* when in a stalled state run on a commmand line (with gdb installed)
gdb --batch --eval-command="thread apply all bt" program $(pidof mysqld)