Major failure after upgrade to 4.0

[Christer]

Upgrade went fine and everything, until I restarted the server some hours after that.
All of a sudden pandora_server could not start.

pandora_server.error said:

DBD::mysql::db do failed: Failed to read auto-increment value from storage engine at /usr/lib/perl5/PandoraFMS/DB.pm line 556.

Thankfully the machine is in VMware and I could return to a snapshot I did before I began the upgrade.

[Christer]

I managed to recreate the failure.
I installed a new machine in our Vshpere with help of the VMware image you guys also provide, which is nice.

Did mysql dump on the 3.2.1 pandora server and exported it into the new one.
Stopped pandora_server and injected the backuped up sql.

Then ran /srv/www/htdocs/pandora_console/extras/pandoradb_migrate_v3.2_to_v4.0.sql

Started Pandora, server ran fine and stuff.
Tried a restart of the server to see if the problem would appear again, and sure it did.
Have made sure the mysql password for pandora user is correct in the conf and stuff.
Even added $config["dbtype"]="mysql"; to <pandora_console_path>/include/config.php as per upgrade major version in the online documentation. None of it has helped.

Btw the new VMware harddisk wasent as easy as the 3.2.1 version. The server wouldnt load the disk. Googled on the issue and learned that i had to run vmfkstool to import the disk because it was of the wrong version or something.

[Bty]

Upgrade went fine and everything, until I restarted the server some hours after that.
All of a sudden pandora_server could not start.

pandora_server.error said:

DBD::mysql::db do failed: Failed to read auto-increment value from storage engine at /usr/lib/perl5/PandoraFMS/DB.pm line 556.

Thankfully the machine is in VMware and I could return to a snapshot I did before I began the upgrade.

Same problem here. The web console is working fine, but I can't start pandora_server. When I do it manually I get the same error.

2011-10-05 16:52:12 - nadzor Starting Pandora FMS Server. Error logging activated.
DBD::mysql::db do failed: Failed to read auto-increment value from storage engine at /usr/lib/perl5/PandoraFMS/DB.pm line 556.
DBD::mysql::db do failed: Failed to read auto-increment value from storage engine at /usr/lib/perl5/PandoraFMS/DB.pm line 556.

[tpalacios]

Please insert this into your Pandora database:

Code:

ALTER TABLE tsesion AUTO_INCREMENT = 1;

And let me know if it worked.

Regards.

[Bty]

Yap, working like a charm.

Thank you for your support.

[Bty]

Found another bug. When I try to create or modify a module I receive an error.

[Christer]

Yap, working like a charm.

Thank you for your support.

Worked for me as well. Thank you.