[Openstack-operators] nova.projects mysql table getting lost almost *every* day!
trapni at gmail.com
Tue May 15 08:42:38 UTC 2012
I am now in some urgent emergency mode :( - as I wanted to set our
OpenStack trials in stone
and make actually production-use of it.
However, Nova's projects table (sometimes the dns_domains table) is getting
every day now.
I have absolutely NO clue what the heck is going on to let mySQL ripp of
I cannot find anything in /var/log/mysql.* nor in /var/log/nova/*.log that
it was about to drop
any table or do anything special (yet - maybe I am missing something).
root at controller:~# echo 'SHOW TABLES' | mysql nova
root at controller:~# echo 'DESCRIBE projects' | mysql nova
ERROR 1146 (42S02) at line 1: Table 'nova.projects' doesn't exist
root at controller:~# ls -l /var/lib/mysql/nova/projects.*
-rw-rw---- 1 mysql mysql 8844 May 14 13:40 /var/lib/mysql/nova/projects.frm
the migrations table is empty, and I am running on Ubuntu 12.04 with Essex
Please, can anybody provide me a hint on what the heck is going on here?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Openstack-operators