Hi, It seems more related to an optimization of the mysql server rather than a problem because of the update process. Yo may try to check the database size, and maybe try purge the binary logs or optimize the tables.
Cheers Ruben On Wed, Jun 18, 2014 at 11:43 AM, Fernando Durá <[email protected]> wrote: > Hello, > > We tried to update to 4.6.2 from 4.6.0-1 (Debian Wheezy system with > packages obtained from opennebula.org), and MySql database. The > opennebula database wasn't upgraded (no "onedb upgrade..."), as it > wasn't needed, as stated in the upgrade instructions. > > The upgrade went apparently well, but when we tried to start a vm via > sunstone it got stuck in "boot" state, even when we checked with "onevm > top". But this wasn't the real state as we were able to connect to the > vm vía ssh (so, the vm was really running). > > Looking to the logs, we saw lots of messages like: > > Tue Jun 17 13:15:17 2014 [ONE][E]: SQL command was: REPLACE INTO > vm_monitoring (vmid, last_poll, body),... > ... (lots of stuff)... error 1205 : Lock wait timeout exceeded; try > restarting transaction > > Moreover, when we noticed that , after stopping opennebula, a > "/etc/init.d/mysql stop" needed a couple of minutes (instead of just a > few seconds). > > We went back to 4.6.0 and both problems dissapeared. > > Is this a known problem with the update? Are we missing something? Any > suggestions? > > Thank you for your help. > Best regards. > > -- > Fernando Durá Colomina e-mail: > [email protected] > Servei d'Informàtica; Univ.de València Tel: +34 96 354 43 10 > E-46100 Burjassot (Valencia) - SPAIN > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opennebula.org/listinfo.cgi/users-opennebula.org > -- -- Ruben S. Montero, PhD Project co-Lead and Chief Architect OpenNebula - Flexible Enterprise Cloud Made Simple www.OpenNebula.org | [email protected] | @OpenNebula
_______________________________________________ Users mailing list [email protected] http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
