Bug #91515 semaphore wait has lasted > 600 seconds,can't logging,
Submitted: 2 Jul 2018 7:59 Modified: 3 Aug 2018 18:45
Reporter: pino cao Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.7.22 OS:CentOS
Assigned to: MySQL Verification Team CPU Architecture:Any

[2 Jul 2018 7:59] pino cao
Description:
Recently, I upgraded the MySQL server from 5.5.38 to 5.7.22. During the running process, I often crashed, about 1~3 times a week.During this period, logging in to the MySQL server will be stuck. No error message. 

The information in the errorlog is as follows:
===================================== 
2018-07-02 11:14:51 0x7f1e77fff700 INNODB MONITOR OUTPUT 
===================================== 
Per second averages calculated from the last 20 seconds 
----------------- 
BACKGROUND THREAD 
----------------- 
srv_master_thread loops: 114853 srv_active, 0 srv_shutdown, 222898 srv_idle 
srv_master_thread log flush and writes: 337751 
---------- 
SEMAPHORES 
---------- 
OS WAIT ARRAY INFO: reservation count 3448715 
--Thread 139768797050624 has waited at fsp0fsp.cc line 2789 for 808.00 seconds the semaphore: 
X-lock on RW-latch at 0x7f1e523a5638 created in file fil0fil.cc line 1381 
a writer (thread id 139768389551872) has reserved it in mode  exclusive 
number of readers 0, waiters flag 1, lock_word: 0 
Last time read locked in file not yet reserved line 0 
Last time write locked in file /export/home/pb2/build/sb_0-27500212-1520171728.22/mysql-5.7.22/storage/innobase/fsp/fsp0fsp.cc line 3365 
--Thread 139768606086912 has waited at buf0flu.cc line 1209 for 814.00 seconds the semaphore: 
SX-lock on RW-latch at 0x7f1fe9e8a670 created in file buf0buf.cc line 1460 
a writer (thread id 139768389551872) has reserved it in mode  exclusive 
number of readers 0, waiters flag 1, lock_word: 0 
Last time read locked in file row0ins.cc line 2989 
Last time write locked in file /export/home/pb2/build/sb_0-27500212-1520171728.22/mysql-5.7.22/storage/innobase/include/mtr0mtr.ic line 153 
OS WAIT ARRAY INFO: signal count 3459593 
RW-shared spins 0, rounds 316205, OS waits 92637 
RW-excl spins 0, rounds 2028926, OS waits 73448 
RW-sx spins 1578, rounds 18067, OS waits 426 
Spin rounds per wait: 316205.00 RW-shared, 2028926.00 RW-excl, 11.45 RW-sx 
------------ 
TRANSACTIONS 
------------ 
Trx id counter 35163240975 
Purge done for trx's n:o < 35163240898 undo n:o < 0 state: running but idle 
History list length 27 
LIST OF TRANSACTIONS FOR EACH SESSION: 
---TRANSACTION 421252911921088, not started 
mysql tables in use 1, locked 0 
0 lock struct(s), heap size 1136, 0 row lock(s) 
---TRANSACTION 421252911918352, not started 
...
...
...

How to repeat:
unknown
[2 Jul 2018 8:02] pino cao
here is the detail error log

Attachment: err20180702.txt (text/plain), 16.13 KiB.

[2 Jul 2018 8:04] pino cao
All of this happens after the upgrade is completed
[3 Jul 2018 18:45] MySQL Verification Team
Hi,

To make sure I follow up properly, you never had issues before the upgrade and after upgrade you have constant crashes. 

How did you upgrade? In place or?
Did you run mysql_upgrade tool?

Can you please upload the config file too?

all best
Bogdan
[4 Aug 2018 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".