Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.34-galera
-
OS: CentOS 6.5 (kernel 2.6.32-431.3.1.el6.x86_64)
Package: MariaDB-Galera-server-5.5.34-1.x86_64 + galera-23.2.7-1.rhel6.x86_64
Description
This problem happend on 3 node MariaDB Galera Server cluster as a backend for zabbix.
Everything was fine until these line appeared on the log.
Log from zabbix-server indicates that around 12:42:07, query execution has stopped
(which matches the time frame from log of mysqld).
140208 21:35:10 [Warning] WSREP: last inactive check more than PT1.5S ago (PT2.30767S), skipping check
|
InnoDB: Warning: a long semaphore wait:
|
--Thread 140414024693504 has waited at row0ins.c line 2087 for 241.00 seconds the semaphore:
|
X-lock (wait_ex) on RW-latch at 0x7fb2a39cbc70 '&block->lock'
|
a writer (thread id 140414024693504) has reserved it in mode wait exclusive
|
number of readers 1, waiters flag 1, lock_word: ffffffffffffffff
|
Last time read locked in file row0sel.c line 3138
|
Last time write locked in file /home/buildbot/buildbot/build/mariadb-5.5.34/storage/xtradb/btr/btr0sea.c line 947
|
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
|
InnoDB: Pending preads 0, pwrites 0
|
|
|
=====================================
|
140209 12:45:53 INNODB MONITOR OUTPUT
|
=====================================
|
:
:
----------------------------
|
END OF INNODB MONITOR OUTPUT
|
============================
|
InnoDB: ###### Diagnostic info printed to the standard error stream
|
InnoDB: Error: semaphore wait has lasted > 600 seconds
|
InnoDB: We intentionally crash the server, because it appears to be hung.
|
For reference, I've attached excerpt of mysqld log.
Please let me know if some other information is needed.