Semaphore wait has lasted > 600 seconds

Comments

1 comment

  • Avatar
    Dmitry Onishko

    from the logs noticed:

    021-03-28T11:25:00.624358Z 0 [Note] [MY-000000] [Galera] Member 0.0 (pxc-db3) synced with group.

    2021-03-28T12:06:14.847604Z 80579 [ERROR] [MY-000000] [WSREP] Percona-XtraDB-Cluster prohibits use of DML command on a table (database.table) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER

    2021-03-28T13:14:46.811755Z 0 [Warning] [MY-012985] [InnoDB] A long semaphore wait:

    --Thread 140647833044736 has waited at trx0undo.ic line 143 for 241 seconds the semaphore:

    S-lock on RW-latch at 0x7fe86e5c0128 created in file buf0buf.cc line 785

    a writer (thread id 140684676830976) 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/jenkins/workspace/pxc80-autobuild-RELEASE/test/percona-xtradb-cluster-8.0.22-13/storage/innobase/include/trx0undo.ic line 129

    after about an hour the semaphore turned on

    --------------

    ROW OPERATIONS

    --------------

    0 queries inside InnoDB, 0 queries in queue

    23 read views open inside InnoDB

    34 RW transactions active inside InnoDB

    ---OLDEST VIEW---

    Read view low limit trx n:o 66393027

    Trx read view will not see trx with id >= 66393027, sees < 66392831

    Read view individually stored trx ids:

    Read view trx id 66392831

    Read view trx id 66393016

    Read view trx id 66393018

    Read view trx id 66393019

    Read view trx id 66393020

    -----------------

    Process ID=16035, Main thread ID=140627657746176 , state=sleeping

    Number of rows inserted 1033805, updated 12118863, deleted 3435052, read 1511885858

    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.42 reads/s

    Number of system rows inserted 137400, updated 3124, deleted 137411, read 382523

    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

    ----------------------------

    END OF INNODB MONITOR OUTPUT

    ============================

    InnoDB: ###### Diagnostic info printed to the standard error stream

    2021-03-28T13:15:17.812370Z 0 [Warning] [MY-012985] [InnoDB] A long semaphore wait:

    --Thread 140667162797824 has waited at ha_innodb.cc line 3016 for 268 seconds the semaphore:

    S-lock on RW-latch at 0x7ff8c838c230 created in file trx0purge.cc line 228

    a writer (thread id 140627418212096) has reserved it in mode wait exclusive

    number of readers 1, waiters flag 1, lock_word: ffffffffffffffff

    Last time read locked in file ha_innodb.cc line 3016

    Last time write locked in file /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/percona-xtradb-cluster-8.0.22-13/storage/innobase/srv/srv0srv.cc line 3580

    2021-03-28T13:15:17.812466Z 0 [Warning] [MY-012985] [InnoDB] A long semaphore wait:

    --Thread 140665413785344 has waited at ha_innodb.cc line 3016 for 267 seconds the semaphore:

    S-lock on RW-latch at 0x7ff8c838c230 created in file trx0purge.cc line 228

    a writer (thread id 140627418212096) has reserved it in mode wait exclusive

    number of readers 1, waiters flag 1, lock_word: ffffffffffffffff

    Last time read locked in file ha_innodb.cc line 3016

    Last time write locked in file /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/percona-xtradb-cluster-8.0.22-13/storage/innobase/srv/srv0srv.cc line 3580

    2021-03-28T13:15:17.812544Z 0 [Warning] [MY-012985] [InnoDB] A long semaphore wait:

    --Thread 140667162593024 has waited at ha_innodb.cc line 3016 for 268 seconds the semaphore:

    S-lock on RW-latch at 0x7ff8c838c230 created in file trx0purge.cc line 228

    a writer (thread id 140627418212096) has reserved it in mode wait exclusive

    number of readers 1, waiters flag 1, lock_word: ffffffffffffffff

    Last time read locked in file ha_innodb.cc line 3016

    Last time write locked in file /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/percona-xtradb-cluster-8.0.22-13/storage/innobase/srv/srv0srv.cc line 3580

    2021-03-28T13:15:17.812582Z 0 [Warning] [MY-012985] [InnoDB] A long semaphore wait:

    --Thread 140647833044736 has waited at trx0undo.ic line 143 for 272 seconds the semaphore:

    S-lock on RW-latch at 0x7fe86e5c0128 created in file buf0buf.cc line 785

    a writer (thread id 140684676830976) 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/jenkins/workspace/pxc80-autobuild-RELEASE/test/percona-xtradb-cluster-8.0.22-13/storage/innobase/include/trx0undo.ic line 129

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk