My pandorafms server has stopped. I found following logs in pandora_server.log. "2014-01-16 22:20:02 myserverxyz.com [V1] [E] 'myserverxyz.com': DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction at /usr/lib/perl5/PandoraFMS/DB.pm line 811. 2014-01-16 22:20:02 myserverxyz.com [V1] Pandora FMS Server 'myserverxyz.com' unhandled error. 2014-01-16 22:20:05 myserverxyz.com [V1] [E] 'myserverxyz.com': DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction at /usr/lib/perl5/PandoraFMS/DB.pm line 811." what is the cause for this issue??
pandorafms server down
helplakmal · 17 ene 2014, 9:04 · 2 mensajes · 57 visitas
- Inicio del debate
Hi This problem usually occurs when there are many events in the database and produce a blockage, a solution in these cases is to reduce the number of days in which the pandora_db.pl delete events. Another solution passes clean indexes from some tables: ALTER TABLE tserver DROP INDEX status; ALTER TABLE tserver DROP INDEX keepalive; ALTER TABLE tevento ADD INDEX `idx_utimestamp` USING BTREE (`utimestamp`); ALTER TABLE tevento DROP INDEX estado; ALTER TABLE tevento DROP INDEX criticity; ALTER TABLE tevento DROP INDEX indice_1; DELETE FROM tsesion_extended WHERE id_sesion NOT IN ( SELECT id_sesion FROM tsesion ); Before this, you need to do a database backup. Regards
Entra en tu cuenta para publicar.
