{"id":203,"date":"2015-05-10T10:44:40","date_gmt":"2015-05-10T08:44:40","guid":{"rendered":"http:\/\/www.dolicapax.org\/?p=203"},"modified":"2015-11-02T04:49:20","modified_gmt":"2015-11-02T03:49:20","slug":"workaround-for-ovmm-database-restore-bug-ovca-2-0-2-ovm3-2-8-x","status":"publish","type":"post","link":"https:\/\/www.dolicapax.org\/?p=203","title":{"rendered":"Workaround for OVMM database restore BUG – OVCA 2.0.2 – OVM3.2.8.x"},"content":{"rendered":"

If you ever have to restore the Oracle Virtual Machine Manager database using the provided RestoreDatabase.sh, chances are that you will end up with a bunch of corrupted or missing tables in the back-end MySQL database schema. Specifically, all tables with 0 rows will be dysfunctional after successful restore. In turn this prevents management of compute-nodes, virtual machines and other resources.<\/strong><\/p>\n

I don’t know which other versions of OVM might be affected, but the latest 2.0.2 software release for the Virtual Compute Appliance certainly is.<\/p>\n

I wrote a workaround that will identify, drop and re-create the corrupted tables. No guarantees, but it did the trick here. Perhaps it can save someone a bit of a headache.<\/p>\n

===== CUSTOMER BUG REPORT =====<\/p>\n

Description
\n———–<\/p>\n

Assorted errors related to missing tables after restoring OVMM database using provided tools.<\/p>\n

Example:<\/p>\n

While trying to stop a VM server:<\/p>\n

OVMAPI_6000E Internal Error: Caught during commit: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘ovs.Mgr_ServerStoppingEvent’ doesn’t exist<\/p>\n

Affected Versions
\n—————–
\nOracle Virtual Compute Appliance Software Release 2.0.2
\nOracle VM Manager Software Release 3.2.8.x<\/p>\n

Working Theory
\n————–<\/p>\n

All ovs tables with 0 rows are corrupted during restore.<\/p>\n

Steps to repdroduce
\n——————-<\/p>\n

1. Restore OVMM database using \/u01\/app\/oracle\/ovm-manager-3\/ovm_shell\/tools\/RestoreDatabase.sh<\/p>\n

2. Query all tables in ovs schema<\/p>\n

3. Look for ERROR 1146<\/p>\n

Workaround
\n———-<\/p>\n

1)
\nservice ovmm stop ; service ovmm_mysql stop<\/p>\n

2)<\/p>\n

sudo -u oracle \/bin\/bash \/u01\/app\/oracle\/ovm-manager-3\/ovm_shell\/tools\/RestoreDatabase.sh AutoFullBackup-20150510_0100<\/p>\n

3)<\/p>\n

service ovmm_mysql start<\/p>\n

4)<\/p>\n

This should identify, drop and re-create affected tables:<\/p>\n

\/usr\/bin\/mysql -D ovs -b -f -s -u root -pWelcome1 -S \/u01\/app\/oracle\/mysql\/data\/mysqld.sock -e “show tables;” | awk ‘{print “select count(*) from ” $1 “;” }’ | \/usr\/bin\/mysql -D ovs -b -f -s -u root -pWelcome1 -S \/u01\/app\/oracle\/mysql\/data\/mysqld.sock 2>&1 >\/dev\/null | grep “ERROR 1146” | awk –field-separator=\\’ ‘{print “drop table ” $2 “;\\ncreate table ” $2″(m_id bigint,m_data longblob,primary key (m_id));”}’ | \/usr\/bin\/mysql -D ovs -b -f -s -u root -pWelcome1 -S \/u01\/app\/oracle\/mysql\/data\/mysqld.sock<\/p>\n

5)<\/p>\n

service ovmm start<\/p>\n<\/address>\n","protected":false},"excerpt":{"rendered":"

If you ever have to restore the Oracle Virtual Machine Manager database using the provided RestoreDatabase.sh, chances are that you will end up with a bunch of corrupted or missing tables in the back-end MySQL database schema. Specifically, all tables … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"_links":{"self":[{"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=\/wp\/v2\/posts\/203"}],"collection":[{"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=203"}],"version-history":[{"count":3,"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=\/wp\/v2\/posts\/203\/revisions"}],"predecessor-version":[{"id":205,"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=\/wp\/v2\/posts\/203\/revisions\/205"}],"wp:attachment":[{"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dolicapax.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}