Bug #112771 MySQL hangs
Submitted: 19 Oct 2023 8:33 Modified: 19 Oct 2023 10:41
Reporter: xiaoyu bai Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.7.29 OS:Any
Assigned to: CPU Architecture:Any

[19 Oct 2023 8:33] xiaoyu bai 
Description:
MYSQL hang and there is a background thread looks like blocked by itself.

--Thread 139907322341120 has waited at srv0srv.cc line 2435 for 4912  seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f48616c9998 created in file dict0dict.cc line 1242
a writer (thread id 139907322341120) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
Last time read locked in file row0undo.cc line 330
Last time write locked in file /mnt/workspace/percona-server-5.7-binaries-release-rocks-new/label_exp/min-stretch-x64/test/percona-server-5.7.29-32/storage/innobase/srv/srv0srv.cc line 2435

How to repeat:
Don't know

Suggested fix:
Don't know
[19 Oct 2023 10:41] MySQL Verification Team 
Hi Mr. bai,

Thank you for your bug report.

However, we must inform you that this is a forum for the bug reports with a fully repeatable test cases.  Your report does not contain such a test case.

Next, we would like to inform you that version 5.7 is not maintained any more. It is no longer supported. Our currently supported versions are 8.0, 8.1 and soon 8.2.

Just for your information, a transaction never waits for itself. It always waits for a lock that is held by some other transaction.

Unsupported.