Sometime this morning my system status and latest issues in the dashboard went to "...". The detail disappeared. Also my actions stopped notifying me of down systems.
I'm running version 1.5.5.
Looking in the mysql database log I am seeing several entries like:
8935:20080915:150142 Query failed: [update items set nextcheck=1221517900 where itemid in (21700,27100,30700);
update items set nextcheck=1221516400 where itemid in (19600,19900,20800,22600,23200,24400,25300,26200,2 7700,28900,29800,32500,33100,35200,37600,38800,406 00,41800,42100,41200,40000,44800,36100,34300,32800 ,31600,30400,29500,28300,27400,26800,25600,25000,2 4100,23500,22000,21400,20200);
] Deadlock found when trying to get lock; try restarting transaction [1213]
It is always transaction 1213. I have stopped and restarted everything several time, but no change.
I have recently taken this over from an ex employee so I am kind of blundering around here.
I'm running version 1.5.5.
Looking in the mysql database log I am seeing several entries like:
8935:20080915:150142 Query failed: [update items set nextcheck=1221517900 where itemid in (21700,27100,30700);
update items set nextcheck=1221516400 where itemid in (19600,19900,20800,22600,23200,24400,25300,26200,2 7700,28900,29800,32500,33100,35200,37600,38800,406 00,41800,42100,41200,40000,44800,36100,34300,32800 ,31600,30400,29500,28300,27400,26800,25600,25000,2 4100,23500,22000,21400,20200);
] Deadlock found when trying to get lock; try restarting transaction [1213]
It is always transaction 1213. I have stopped and restarted everything several time, but no change.
I have recently taken this over from an ex employee so I am kind of blundering around here.