[PCA 2.x] Provision Compute Node Fails with "MySQLSyntaxErrorException: Table 'ovs.XXX' doesn't exist" (Doc ID 2341946.1)

Last updated on OCTOBER 02, 2022

Applies to:

Symptoms

On Private Cloud Appliance, when provisioning or reprovisioning a compute node, the reprovisioning fails with the following kind of error in the /var/log/ovca.log :

#### <>> <> : ovcacn14r1, Discover failed with error: com.oracle.odof.exception.InternalException: Caught during commit: java.sql.SQLException: Create table, Mgr_MissingMetaDataEve
nt failed with exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ovs.Mgr_MissingMetaDataEvent' doesn't exist. The prior exception was: com.m
ysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ovs.Mgr_MissingMetaDataEvent' doesn't exist
Fri Dec 15 06:05:08 UTC 2017
at com.oracle.odof.core.storage.Transaction.commit(Transaction.java:421)
at com.oracle.odof.core.TransactionManager.commitTransaction(TransactionManager.java:231)
at com.oracle.odof.core.TransactionManager.processTransactionWork(TransactionManager.java:642)
at com.oracle.odof.core.TransactionManager.processCommand(TransactionManager.java:769)
at com.oracle.odof.core.Exchange.createObject(Exchange.java:78)
at com.oracle.odof.core.AbstractExchange.createObject(AbstractExchange.java:204)
at com.oracle.ovm.mgr.api.manager.ModelManagerDbImpl.createEvent(ModelManagerDbImpl.java:1376)
at com.oracle.odof.core.AbstractVessel.invokeMethod(AbstractVessel.java:378)
at com.oracle.odof.core.AbstractVessel.invokeMethod(AbstractVessel.java:355)
at com.oracle.odof.core.BasicWork.invokeMethod(BasicWork.java:106)
at com.oracle.odof.command.InvokeMethodCommand.process(InvokeMethodCommand.java:92)
at com.oracle.odof.core.BasicWork.processCommand(BasicWork.java:81)
at com.oracle.odof.core.TransactionManager.processCommand(TransactionManager.java:752)
at com.oracle.odof.core.WorkflowManager.processCommand(WorkflowManager.java:467)
at com.oracle.odof.core.WorkflowManager.processWork(WorkflowManager.java:525)
at com.oracle.odof.io.AbstractClient.run(AbstractClient.java:42)
at java.lang.Thread.run(Thread.java:682)
Caused by: java.sql.SQLException: Create table, Mgr_MissingMetaDataEvent failed with exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ovs.Mgr_MissingMetaDataEvent' doesn't exist. The prior exception was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ovs.Mgr_MissingMetaDataEvent' doesn't exist
at com.oracle.odof.core.storage.RelationalStore.checkObjectExistsInMgrTable(RelationalStore.java:2953)
at com.oracle.odof.core.storage.RelationalStore.commitCluster(RelationalStore.java:2751)
at com.oracle.odof.core.storage.ObjectStore.commitTransaction(ObjectStore.java:1488)
at com.oracle.odof.core.storage.Transaction.commit(Transaction.java:413)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.