Not the answer you need?
Register and ask your own question!

Problem after upgrate from PCX 5.7 to PCX 8.0

MirSosMirSos Current User Role Contributor

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

Answers

  • matthewbmatthewb Senior [email protected] Percona Staff Role

    S-lock on RW-latch

    Do you have foreign keys? Shared locks only appear on tables with foreign keys. Ensure that you are not keeping transactions open for extended periods of time and ensure that all tables have a PRIMARY KEY as well.

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.