![]() |
![]() |
Subject: | zenoss DB deadlocks |
Author: | [Not Specified] |
Posted: | 2014-10-16 11:05 |
InnoDB: transactions deadlock detected, dumping detailed information.
141016 10:56:06
*** (1) TRANSACTION:
TRANSACTION 9495B2, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1248, 2 row lock(s)
MySQL thread id 2, OS thread handle 0x2ac51c091940, query id 275798 localhost 127.0.0.1 zenoss statistics
SELECT event_count,first_seen,last_seen,details_json,status_id,uuid FROM event_summary WHERE fingerprint_hash=x'8B99D7465861E706CF5D5AFC77DA5277CD90CAF6' FOR UPDATE
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 311 page no 2926 n bits 88 index `PRIMARY` of table `zenoss_zep`.`event_summary` trx id 9495B2 lock_mode X locks rec but not gap waiting
*** (2) TRANSACTION:
TRANSACTION 9495B1, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
10 lock struct(s), heap size 3112, 4 row lock(s), undo log entries 5
MySQL thread id 3, OS thread handle 0x2ac51c0da940, query id 275805 localhost 127.0.0.1 zenoss Updating
UPDATE event_summary SET status_id=4,status_change=1413471366459,update_time=1413471366459,cleared_by_event_uuid=x'005056B900BEA4D511E455448E7BC348',fingerprint_hash=x'A
9173A261E34D0EF4362FD1F0969B816B2B70472',audit_json='{"timestamp":1413471366459,"new_status":4}' WHERE uuid=x'005056B900BEA4D511E455444CDA9D80'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 311 page no 2926 n bits 80 index `PRIMARY` of table `zenoss_zep`.`event_summary` trx id 9495B1 lock_mode X locks rec but not gap
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 311 page no 833 n bits 464 index `fingerprint_hash` of table `zenoss_zep`.`event_summary` trx id 9495B1 lock_mode X locks rec but not gap waiting
*** WE ROLL BACK TRANSACTION (1)
InnoDB: transactions deadlock detected, dumping detailed information.
Subject: | something, zenbackup, or |
Author: | Andrew Kirch |
Posted: | 2014-10-20 13:13 |
something, zenbackup, or another backup app is blocking the DB, in mysql
> show processlist;
Andrew Kirch
akirch@gvit.com
Need Zenoss support, consulting or custom development Look no further. Email or PM me!
Ready for Distributed Topology (collectors) for Zenoss 5 Coming May 1st from GoVanguard
Subject: | I suspect that this issue may |
Author: | Andrew Kirch |
Posted: | 2014-10-27 15:14 |
I suspect that this issue may be related to the fact that you're running MariaDB and not MySQL. At this time we don't support MariaDB.
Andrew Kirch
akirch@gvit.com
Need Zenoss support, consulting or custom development Look no further. Email or PM me!
Ready for Distributed Topology (collectors) for Zenoss 5 Coming May 1st from GoVanguard
Subject: | I doubt it. |
Author: | [Not Specified] |
Posted: | 2014-10-28 06:41 |
I doubt it.
< |
Previous Can Zenoss gather events via CORBA? |
Next /Status/Ping |
> |