Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.41, 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
-
Cloudlinux 7.7
Google Cloud Compute Engine
Description
We are experiencing technical difficulties with the latest MariaDB 10.1.41-MariaDB.
This is only happening on one server while we have more with the same system package versions.
The database is freezing and does not accept new connections.
The error_log shows so much error data eg:
InnoDB: Warning: a long semaphore wait: |
--Thread 140300680931072 has waited at dict0dict.cc line 984 for 241.00 seconds the semaphore: |
Mutex at 0x7f9e26c112e8 '&dict_sys->mutex', lock var 1 |
Last time reserved by thread 140300697716480 in file not yet reserved line 0, waiters flag 1 |
InnoDB: Warning: semaphore wait:
|
--Thread 140300680931072 has waited at dict0dict.cc line 984 for 241.00 seconds the semaphore: |
Mutex at 0x7f9e26c112e8 '&dict_sys->mutex', lock var 1 |
Last time reserved by thread 140300697716480 in file not yet reserved line 0, waiters flag 1 |
We can provide more error log data but not in a public.
Attachments
Issue Links
- causes
-
MDEV-20987 InnoDB fails to start when fts table has FK relation
-
- Closed
-
-
MDEV-23856 fts_optimize_wq accessed after shutdown of FTS Optimize thread
-
- Closed
-
- relates to
-
MDEV-19529 InnoDB hang on DROP FULLTEXT INDEX
-
- Closed
-
Results of RQG testing on bb-10.2-thiru commit 0b91f74906c8dcbcc1dac486fcc66c1e9c0c603a
- > 1500 RQG tests were executed
There was some surprising low fraction of failing tests.
All asserts/crashes are already covered by open bugs in JIRA except one
- mysqld: sql/sql_list.h:684: void ilink::assert_linked(): Assertion `prev != 0 && next != 0' failed.
happening during shutdown of the server
- per Thiru: Unlikely that its caused by the changes in bb-10.3-thiru
- occuring only once == Attempts to replay that on actual 10.2 have a too low chance
https://jira.mariadb.org/browse/MDEV-20843