Pandora FMS Community

Pandora 2.1 - MySQL Lock wait timeout exceeded

churria · 24 mar 2009, 3:15 · 5 mensajes · 79 visitas

  1. Inicio del debate

    Hi, Using Pandora FMS since v 1.3 with no problems into a Debian server with MySQL v 5.0.32-7etch8. This is a Pandora dedicated server. But since I upgraded to v 2.1 i get this error in pandora_server.log

    sfri116_Net [V1] ERROR Code: DBD::mysql::db do failed: Lock wait timeout exceeded; try restarting transaction at /usr/local/share/perl/5.8.8/PandoraFMS/DB.pm line 789.

    All process (network, recon, server, etc.) still runing, but in console i can see events thant says all process is stoped. I need to restart all pandora process and it runs fine during 24 hours until next error (aprox.) Anybody knows about this problem?

  2. Try restarting MySQL server and keep an eye on it, let us know if after restarting it keeps saying the same

  3. Restarting MySQL server solves the problem for some time (the same efect restarting only "pandora_server") The problem allways returns I have to restart pandora_server because it stops collecting data from "data_in".

  4. Try to place a monitor to check memory usage on the pandora server. Check also number of Mysql connectins and filehandles, in some systems there is a memleak on some perl libraries. By the way, make a pandora restart on all pandora servers in a programmed cron task everyday night. I suppose you are running the DB maintance script, right ?

  5. DB maintance is running daily I have a pandora restart in cron :-( Im. monitoring whole server (mysql, memory, disks, etc) and nothing seems to be extrange. I have no idea... I'm using Pandore since 1.3, and this problem occurs only with 2.1

Entra en tu cuenta para publicar.