MySQL crashes in KT VA

I’ve recently downloaded the OpenSuse-based KnowledgeTree Virtual Appliance.

In poking through the settings and configuration page after logging into the web-based UI I’m occasionally redirected to an error page. When I check the console on the VA there is an error saying:

/opt/bitnami/mysql/bin/mysqld_safe: line 133: 2992 Killed

Then there appears to be a line restarting mysqld with all appropriate options. The longer the VM stays running the more frequent these errors happen. If I’m willing to wait several seconds after that request I can get back into KT, but I can usually only visit one, maybe two, config pages before the crash happens again.

Now, I am not using VMWare, I’m using VirtualBox, but I haven’t had trouble with other VMs in the past.

Thoughts?

(edited to add blockquote to console results)

Here’s an update. mysqld is crashing on almost every request now. I was able to change the URL to the custom error page in the config before the last crash, so now I can get more detailed error reporting from KT in addition to the console. KT reports the following on the custom error page:

[db_error: message=“DB Error: connect failed” code=-24 mode=return level=notice prefix="" info=" [nativecode=Can’t connect to local MySQL server through socket ‘/opt/bitnami/mysql/tmp/mysql.sock’ (2)] ** Array"]

Hi,

Could you post the mysql log file: /opt/bitnami/mysql/data/mysqld.log ? Sometimes the Virtual Appliace requires more RAM to works properly. Try to increase the RAM memory from the VirtualBox control panel and restart the appliance.

I haven’t been able to reproduce the problem. It doesn’t crash now. …I guess I’m good for now.

Thanks

I’m glad to hear this. If it is a random problem it could be the RAM issue. Java application requires more than 512Mb so it is necessary to increase the RAM memory for the Virtual Appliance.