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
-
Activity
Field | Original Value | New Value |
---|---|---|
Labels | crash innodb semaphore | crash innodb need_feedback semaphore |
Attachment | error_mysqld.log [ 45797 ] |
Attachment | gdb_core.64996.txt [ 45878 ] | |
Attachment | gdb_core.180561.txt [ 45879 ] |
Attachment | gdb.180561.txt.gz [ 45884 ] |
Labels | crash innodb need_feedback semaphore | crash innodb semaphore |
Attachment | gdb_short.txt [ 45890 ] |
Fix Version/s | 10.3 [ 22126 ] | |
Assignee | Vladislav Vaintroub [ wlad ] |
Attachment | uniqstack.txt [ 45892 ] |
Link | This issue relates to MDEV-16824 [ MDEV-16824 ] |
Assignee | Vladislav Vaintroub [ wlad ] | Sergey Vojtovich [ svoj ] |
Fix Version/s | 10.4 [ 22408 ] |
Link |
This issue relates to |
Fix Version/s | 10.1.41 [ 23406 ] | |
Fix Version/s | 10.2.25 [ 23408 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Fix Version/s | 10.4.6 [ 23412 ] | |
Fix Version/s | 10.3.16 [ 23410 ] |
Fix Version/s | 10.3.16 [ 23410 ] | |
Fix Version/s | 10.4.6 [ 23412 ] |
Link |
This issue relates to |
Link |
This issue relates to |
Link | This issue relates to MDEV-13196 [ MDEV-13196 ] |
Labels | crash innodb semaphore | ServiceNow crash innodb semaphore |
Labels | ServiceNow crash innodb semaphore | 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z crash innodb semaphore |
Labels | 76qDvLB8Gju6Hs7nk3VY3EX42G795W5z crash innodb semaphore | crash innodb semaphore |
Workflow | MariaDB v3 [ 87791 ] | MariaDB v4 [ 154500 ] |
Zendesk Related Tickets | 201658 | |
Zendesk active tickets | 201658 |