Issue Plesk panel stopped responding

[Bogdan1]

Hi,

I have a problem, plesk panel stopped responding. I can visit page
vps520565.ovh.net but vps520565.ovh.net:8443 can't(it's just loading and loading). I also cannot visit any other page connected to that server => getting error 504 Gateway Time-out.

Reboot didn't help

EDIT(ADDED LOGS):

tail -fn0 /var/log/sw-cp-server/error_log returns nothing
/var/log/syslog is empty
/var/log/plesk/panel.log nothing relevant

/var/log/messages:

Mar 20 15:47:14 vps520565 mysqld: --Thread 140612080392960 has waited at trx0sys.ic line 103 for 241.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: X-lock (wait_ex) on RW-latch at 0x7fe2b37fd318 '&block->lock'
Mar 20 15:47:14 vps520565 mysqld: a writer (thread id 140612080392960) has reserved it in mode  wait exclusive
Mar 20 15:47:14 vps520565 mysqld: number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Mar 20 15:47:14 vps520565 mysqld: Last time read locked in file buf0flu.cc line 1126
Mar 20 15:47:14 vps520565 mysqld: Last time write locked in file trx0sys.ic line 103
Mar 20 15:47:14 vps520565 mysqld: Holder thread 0 file not yet reserved line 0
Mar 20 15:47:14 vps520565 mysqld: InnoDB: Warning: semaphore wait:
Mar 20 15:47:14 vps520565 mysqld: --Thread 140612080392960 has waited at trx0sys.ic line 103 for 241.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: X-lock (wait_ex) on RW-latch at 0x7fe2b37fd318 '&block->lock'
Mar 20 15:47:14 vps520565 mysqld: a writer (thread id 140612080392960) has reserved it in mode  wait exclusive
Mar 20 15:47:14 vps520565 mysqld: number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Mar 20 15:47:14 vps520565 mysqld: Last time read locked in file buf0flu.cc line 1126
Mar 20 15:47:14 vps520565 mysqld: Last time write locked in file trx0sys.ic line 103
Mar 20 15:47:14 vps520565 mysqld: Holder thread 0 file not yet reserved line 0
Mar 20 15:47:14 vps520565 mysqld: InnoDB: Warning: Writer thread is waiting this semaphore:
Mar 20 15:47:14 vps520565 mysqld: --Thread 140612080392960 has waited at trx0sys.ic line 103 for 241.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: X-lock (wait_ex) on RW-latch at 0x7fe2b37fd318 '&block->lock'
Mar 20 15:47:14 vps520565 mysqld: a writer (thread id 140612080392960) has reserved it in mode  wait exclusive
Mar 20 15:47:14 vps520565 mysqld: number of readers 1, waiters flag 0, lock_word: ffffffffffffffff
Mar 20 15:47:14 vps520565 mysqld: Last time read locked in file buf0flu.cc line 1126
Mar 20 15:47:14 vps520565 mysqld: Last time write locked in file trx0sys.ic line 103
Mar 20 15:47:14 vps520565 mysqld: Holder thread 0 file not yet reserved line 0
Mar 20 15:47:14 vps520565 mysqld: InnoDB: Warning: semaphore wait:
Mar 20 15:47:14 vps520565 mysqld: --Thread 140612080700160 has waited at trx0trx.cc line 339 for 194.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: Mutex at 0x7fe2cde83068 '&trx_sys->mutex', lock var 1
Mar 20 15:47:14 vps520565 mysqld: Last time reserved by thread 140612080392960 in file not yet reserved line 0, waiters flag 1
Mar 20 15:47:14 vps520565 mysqld: InnoDB: Warning: semaphore wait:
Mar 20 15:47:14 vps520565 mysqld: --Thread 140612100094720 has waited at trx0trx.cc line 339 for 193.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: Mutex at 0x7fe2cde83068 '&trx_sys->mutex', lock var 1
Mar 20 15:47:14 vps520565 mysqld: Last time reserved by thread 140612080392960 in file not yet reserved line 0, waiters flag 1
Mar 20 15:47:14 vps520565 mysqld: InnoDB: Warning: semaphore wait:
Mar 20 15:47:14 vps520565 mysqld: --Thread 140612081928960 has waited at trx0trx.cc line 339 for 184.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: Mutex at 0x7fe2cde83068 '&trx_sys->mutex', lock var 1
Mar 20 15:47:14 vps520565 mysqld: Last time reserved by thread 140612080392960 in file not yet reserved line 0, waiters flag 1
Mar 20 15:47:14 vps520565 mysqld: InnoDB: Warning: semaphore wait:
Mar 20 15:47:14 vps520565 mysqld: --Thread 140612079778560 has waited at trx0trx.cc line 1055 for 140.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: Mutex at 0x7fe2cde83068 '&trx_sys->mutex', lock var 1
Mar 20 15:47:14 vps520565 mysqld: Last time reserved by thread 140612080392960 in file not yet reserved line 0, waiters flag 1
Mar 20 15:47:14 vps520565 mysqld: InnoDB: Warning: semaphore wait:
Mar 20 15:47:14 vps520565 mysqld: --Thread 140612183681792 has waited at trx0trx.cc line 339 for 137.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: Mutex at 0x7fe2cde83068 '&trx_sys->mutex', lock var 1
Mar 20 15:47:14 vps520565 mysqld: Last time reserved by thread 140612080392960 in file not yet reserved line 0, waiters flag 1
Mar 20 15:47:14 vps520565 mysqld: InnoDB: Warning: semaphore wait:
Mar 20 15:47:14 vps520565 mysqld: --Thread 140612183374592 has waited at trx0trx.cc line 339 for 136.00 seconds the semaphore:
Mar 20 15:47:14 vps520565 mysqld: Mutex at 0x7fe2cde83068 '&trx_sys->mutex', lock var 1
Mar 20 15:47:14 vps520565 mysqld: Last time reserved by thread 140612080392960 in file not yet reserved line 0, waiters flag 1

 

[Bogdan1]

don't know what happened but it started working by itself about an hour after after...

 

[Monty]

Looks like you've hit a MySQL / MariaDB bug:
[MDEV-13983] Mariadb becomes unresponsive - Jira

 

[Bogdan1]

Now it's not working again

Looks like you've hit a MySQL / MariaDB bug:
[MDEV-13983] Mariadb becomes unresponsive - Jira

Ahh.. I see, thanks

 

[Bogdan1]

But what should I do, this bug is there since 2017.