Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.26, 10.0.32, 10.2.10, 10.3.1, 10.2(EOL)
-
10.2.9-MariaDB-10.2.9+maria~trusty-log
Description
We recently upgraded from 10.1 to 10.2, but unfortunately MariaDB 10.2 becomes unresponsive multiple times every day. This is the log we see:
10.2.9-MariaDB-10.2.9+maria~trusty-log
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140200436983552 has waited at read0read.cc line 579 for 303.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140202383660800 has waited at lock0lock.cc line 7784 for 303.00 seconds the semaphore:
|
Mutex at 0x7f8fceccddc0, Mutex LOCK_SYS created lock0lock.cc:495, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140203085694720 has waited at read0read.cc line 687 for 303.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140200439097088 has waited at read0read.cc line 579 for 303.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140200431699712 has waited at lock0lock.cc line 5075 for 303.00 seconds the semaphore:
|
Mutex at 0x7f8fceccddc0, Mutex LOCK_SYS created lock0lock.cc:495, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140200429586176 has waited at read0read.cc line 579 for 303.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140200443324160 has waited at trx0trx.cc line 664 for 303.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140202384189184 has waited at read0read.cc line 579 for 301.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140200442267392 has waited at read0read.cc line 579 for 299.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140201363072768 has waited at read0read.cc line 579 for 299.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140200430114560 has waited at read0read.cc line 579 for 299.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140201362544384 has waited at trx0trx.cc line 3091 for 286.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140203127658240 has waited at lock0wait.cc line 484 for 282.00 seconds the semaphore:
|
Mutex at 0x7f8fceccddc0, Mutex LOCK_SYS created lock0lock.cc:495, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140203034810112 has waited at trx0trx.cc line 1275 for 242.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
2017-10-03 10:21:11 140203119265536 [Note] InnoDB: A semaphore wait:
|
--Thread 140203110872832 has waited at read0read.cc line 714 for 60.00 seconds the semaphore:
|
Mutex at 0x7f8fced4d2b0, Mutex TRX_SYS created trx0sys.cc:558, lock var 2
|
|
|
....
|
Attachments
Issue Links
- is blocked by
-
MDEV-15135 'show global status' can cause lock contention on LOCK_thread_count
- Closed
- is caused by
-
MDEV-11896 thd_get_error_context_description race condition
- Closed
- is duplicated by
-
MDEV-17371 InnoDB: Warning: a long semaphore wait
- Closed
- relates to
-
MDEV-13196 Remove handler::store_lock()
- Open
-
MDEV-13754 TRANSACTION sometimes stay in "KILLLED' STATE for inifinitve time!
- Closed
-
MDEV-13935 INSERT INTO stuck at state "Unlocking tables"
- Closed
-
MDEV-15135 'show global status' can cause lock contention on LOCK_thread_count
- Closed
-
MDEV-22529 thd_query_safe() isn’t, causing InnoDB to hang
- Closed
-
MDEV-32576 InnoDB deadlock output does not always include the full SQL statement
- Confirmed
-
MDEV-16467 MariaDB crashes because of "long semaphore wait"after migrating from 10.1 to 10.3
- Closed
-
MDEV-20547 mysqld crashes: Semaphore wait has lasted > 60 seconds
- Closed
-
MDEV-21418 [Warning] InnoDB: A long semaphore wait
- Closed