Unhandle error. Pandora db total number of locks exceeded

[daniels]

Hi everybody.

I installed pandora (Pandora FMS v3.1 - Build PC100608) yesterday in a Centos 5.5 from RPM (console) and from tgz (server) after many yum updates and cpan to install all the deps.

I configured just one 3.1 agent to see how the things goes. I saw only one issue ("Out of limits") even with the server, db and agent sync with ntp. I planned to fix this today, but when I arrived at work this morning pandora was offline and I found the error below at pandora.error.log:

2010-08-05 07:04:58 hostname.my.domain [V1] [E] 'hostname.my.domain': DBD::mysql::db do failed: The total number of locks exceeds the lock table size at /usr/lib/perl5/site_perl/5.8.8/PandoraFMS/DB.pm line 316.

I have this same error in my production pandora 3.0, and was hopping to fix this with the 3.1 version... Any ideas? Anyone know if this is a dependency issue or a Centos only problem?

obs: I did not upgrade. I installed 3.1 in a different server with a brand new database.

Thanks in advance.

[daniels]

I'm not sure, but the problem could be the overload of my pandora 3.0 database. It runs in the same server as the new 3.1.

Regards.

[daniels]

I will try to adjust the value of innodb_buffer_pool_size at mysql configuration file (/etc/my.cnf). I think innodb_buffer_pool_size worth some highlights in http://www.openideas.info/wiki/index.php?title=Pandora_3.0:Documentation_en:Anexo_AjusteMySQL. The default value is 8MB and the recommended is about 50-80% of all the RAM, depends if the server is a dedicated MySQL server or not... I was using the default value :-)

More info about innodb_buffer_pool_size can be found here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size

Regards.

[daniels]

So far so good. After increase the value of innodb_buffer_pool_size from the default 8MB to 2GB (my system has 4GB and is MySql exclusive), no more "The total number of locks exceeds the lock table size" error.

About the "Out of limits" error I forget to change the timezone configuration in Configuration->Setup->Time Zone.

I will continue my tests with 3.1 looking forward to put it in production here :-)


Regards.