3 month ago I made upgrade to new version PCX, since this time I have 5 crashes, all of them with the same problem
=====================================
2020-10-09 10:17:12 0x7f5cc3bfb700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 19 seconds
BACKGROUND THREAD
srv_master_thread loops: 22362 srv_active, 0 srv_shutdown, 15344 srv_idle
srv_master_thread log flush and writes: 0
SEMAPHORES
OS WAIT ARRAY INFO: reservation count 77577
–Thread 140041710470912 has waited at trx0undo.ic line 143 for 611 seconds the semaphore:
S-lock on RW-latch at 0x7f65de705048 created in file buf0buf.cc line 783
a writer (thread id 140041757370112) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 143
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/include/trx0undo.ic line 129
–Thread 140041749464832 has waited at row0sel.cc line 3209 for 602 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041715746560 has waited at row0sel.cc line 3209 for 603 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140046403036928 has waited at trx0undo.ic line 143 for 606 seconds the semaphore:
S-lock on RW-latch at 0x7f65de705048 created in file buf0buf.cc line 783
a writer (thread id 140041757370112) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 143
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/include/trx0undo.ic line 129
–Thread 140041742624512 has waited at trx0undo.ic line 143 for 608 seconds the semaphore:
S-lock on RW-latch at 0x7f65de705048 created in file buf0buf.cc line 783
a writer (thread id 140041757370112) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 143
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/include/trx0undo.ic line 129
–Thread 140041775220480 has waited at trx0undo.ic line 143 for 612 seconds the semaphore:
S-lock on RW-latch at 0x7f65de705048 created in file buf0buf.cc line 783
a writer (thread id 140041757370112) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 143
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/include/trx0undo.ic line 129
–Thread 140041758435072 has waited at row0upd.cc line 3291 for 606 seconds the semaphore:
X-lock (wait_ex) on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041709938432 has waited at row0sel.cc line 3209 for 605 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041738929920 has waited at row0sel.cc line 3209 for 598 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041750529792 has waited at row0sel.cc line 3209 for 597 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041711003392 has waited at row0sel.cc line 3209 for 597 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041731557120 has waited at row0sel.cc line 3209 for 596 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140057617622784 has waited at buf0flu.cc line 1330 for 585 seconds the semaphore:
SX-lock on RW-latch at 0x7f5fc79a1fd8 created in file buf0buf.cc line 783
a writer (thread id 140041757370112) 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 /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/include/trx0rseg.ic line 50
–Thread 140041629685504 has waited at row0sel.cc line 3209 for 591 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041603323648 has waited at row0sel.cc line 3209 for 548 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041600694016 has waited at row0sel.cc line 3209 for 545 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041704679168 has waited at row0sel.cc line 3209 for 543 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041596999424 has waited at row0sel.cc line 3209 for 542 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041739462400 has waited at row0sel.cc line 3209 for 541 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
–Thread 140041599112960 has waited at row0sel.cc line 3209 for 537 seconds the semaphore:
S-lock on RW-latch at 0x7f5ef34dfe48 created in file buf0buf.cc line 783
a writer (thread id 140041758435072) has reserved it in mode wait exclusive
number of readers 3, waiters flag 1, lock_word: fffffffffffffffd
Last time read locked in file btr0sea.cc line 954
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-8.0-debian-binary/label_exp/min-stretch-x64/test/percona-xtradb-cluster-8.0.20-11/storage/innobase/row/row0upd.cc line 3291
OS WAIT ARRAY INFO: signal count 731205
RW-shared spins 210759, rounds 243509, OS waits 35209
RW-excl spins 67776, rounds 981722, OS waits 18786
RW-sx spins 20885, rounds 155408, OS waits 220
Spin rounds per wait: 1.16 RW-shared, 14.48 RW-excl, 7.44 RW-sx