[Openstack-operators] nova.projects mysql table getting lost almost *every* day!
jaypipes at gmail.com
Tue May 15 17:41:25 UTC 2012
I believe you have corrupted MySQL system tables...
Not sure there is a great solution for you other than to go back to a
backup that you know is good. :(
You might want to hop onto the MySQL forums or #mysql and see if anyone
there has advice.
On 05/15/2012 04:42 AM, Christian Parpart wrote:
> Hi all,
> 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 lost almost
> every day now.
> I have absolutely NO clue what the heck is going on to let mySQL ripp of
> this table.
> 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 OpenStack packages.
> Please, can anybody provide me a hint on what the heck is going on here?
> Many thanks,
> Christian Parpart.
> Openstack-operators mailing list
> Openstack-operators at lists.openstack.org
More information about the Openstack-operators