Open Stack

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.

Best,
-jay

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).
>
> However:
> root at controller:~# echo 'SHOW TABLES' | mysql nova
> agent_builds
> aggregate_hosts
> aggregate_metadata
> aggregates
> auth_tokens
> block_device_mapping
> bw_usage_cache
> cells
> certificates
> compute_nodes
> console_pools
> consoles
> dns_domains
> fixed_ips
> floating_ips
> instance_actions
> instance_faults
> instance_info_caches
> instance_metadata
> instance_type_extra_specs
> instance_types
> instances
> iscsi_targets
> key_pairs
> migrate_version
> migrations
> networks
> projects
> provider_fw_rules
> quotas
> s3_images
> security_group_instance_association
> security_group_rules
> security_groups
> services
> sm_backend_config
> sm_flavors
> sm_volume
> snapshots
> user_project_association
> user_project_role_association
> user_role_association
> users
> virtual_interfaces
> virtual_storage_arrays
> volume_metadata
> volume_type_extra_specs
> volume_types
> volumes
> 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
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators