[one-users] Database problems with update to 4.6.2

[Fernando Durá]

Hi Rubén,

El 18/06/14 15:36, Ruben S. Montero escribió:
> 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.

Yes. You were right. The tables optimization seemed to do the trick :-)
It works perfect now!.

Thank you  very much

>
> Cheers
>
>
> Ruben
>
>
> On Wed, Jun 18, 2014 at 11:43 AM, Fernando Durá <Fernando.Dura at uv.es
> <mailto:Fernando.Dura at uv.es>> wrote:
>
>     Hello,
>
>     We tried to update to 4.6.2 from 4.6.0-1 (Debian Wheezy system with
>     packages obtained from opennebula.org <http://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:
>     Fernando.Dura at uv.es <mailto:Fernando.Dura at uv.es>
>     Servei d'Informàtica; Univ.de València             Tel: +34 96 354
>     43 10 <tel:%2B34%2096%20354%2043%2010>
>     E-46100 Burjassot (Valencia) - SPAIN
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opennebula.org <mailto:Users at lists.opennebula.org>
>     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 <http://www.OpenNebula.org> |
> rsmontero at opennebula.org <mailto:rsmontero at opennebula.org> | @OpenNebula


-- 
Fernando Durá Colomina				e-mail: Fernando.Dura at uv.es 
Servei d'Informàtica; Univ.de València		   Tel: +34 96 354 43 10
E-46100 Burjassot (Valencia) - SPAIN	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20140619/53e3f93a/attachment.htm>