TECHZEN Zenoss User Community ARCHIVE  

zenoss DB deadlocks

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
>