This forum is no longer active. Please post your questions to our new community site

MySQL crashes in KT VA

Subscribe to MySQL crashes in KT VA 5 post(s), 2 voice(s)

 
Avatar jwells 16 post(s)

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)

 
Avatar jwells 16 post(s)

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"]

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

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.

 
Avatar jwells 16 post(s)

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

Thanks

 
Avatar Beltrán Rueda Administrator 3,714 post(s)

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.