Pandora 2.1 - MySQL Lock wait timeout exceeded - Pandora FMS Community

Community support

Pandora 2.1 – MySQL Lock wait timeout exceeded

Posted by churria on March 24, 2009 at 03:15

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?

churria replied 15 years, 10 months ago 3 Members · 4 Replies
4 Replies

manu

Member
March 30, 2009 at 01:40

0 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
Try restarting MySQL server and keep an eye on it, let us know if after restarting it keeps saying the same
churria

Member
April 15, 2009 at 01:20

0 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
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”.
Sancho

Administrator
April 17, 2009 at 06:26

2321 Karma points

Community awards: Bright ideas

Community rank: Tentacle Master

Like it
Up
0
Down
Drop it
::
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 ?
churria

Member
April 17, 2009 at 06:50

0 Karma points

Community rank: Tentacle noob

Like it
Up
0
Down
Drop it
::
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

Log In to Reply