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) _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
