Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3.7
-
Windows 10, 32 GB RAM, SSD
Description
We have a Windows server that has been running MariaDB 10.1 successfully for over a year. The server remains mostly idle for long times with some read access, but occasionally there are transactions that add data (about 500k rows per commit). There can be up to 10 such transactions (one per database) at the same time and during those times the server is under quite some load (the code processing the data resides on the same server as the database).
When trying to use MariaDB 10.3, during those load times the database crashes and logs "[FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung."
I figure it could be related to MariaDB switching from XtraDB to InnoDB and on the mailing list it was suggested to file a bug.
I'm attaching the error log. I cannot attach a minidump as-is because upon inspection it contained sensitive data that I'm not allowed to disclose. If absolutely neccessary, I can try and reproduce the problem with random test data, but this might take a few days.
The mailing list entry mentioned above can be found here: https://lists.launchpad.net/maria-discuss/msg05139.html
Regards,
Tom.
Attachments
Issue Links
- relates to
-
MDEV-13196 Remove handler::store_lock()
- Open
-
MDEV-13983 Mariadb becomes unresponsive
- Closed
-
MDEV-16060 InnoDB: Failing assertion: ut_strcmp(index->name, key->name)
- Closed
-
MDEV-16824 InnoDB should skip MVCC and transaction locking for temporary tables.
- Confirmed
-
MDEV-21418 [Warning] InnoDB: A long semaphore wait
- Closed