[ PCA 2.3.1 upgrade] During the upgrade of the first management node, there are several "Error Code: 1050" and "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'XXX' already exists" being reported.

(Doc ID 2301245.1)

Last updated on AUGUST 29, 2017

Applies to:

Private Cloud Appliance - Version 2.1.1 and later
Linux x86-64

Symptoms

On Oracle Private Cloud Appliance, when upgrading to the 2.3.1 release, when the first management node is being upgraded, if the person performing the upgrade is monitoring /tmp/install.log on the first management node being upgraded ( so the slave management node at the time the upgrade was started from the master), the following kind of error is being logged repeatedly at some point during the upgrade :

Call: CREATE TABLE OVM_SERVERPOOL_POOLFILESYSTEM (ServerPoolEntity_CLUSTERID BIGINT, POOLFILESYSTEMS BIGINT)
Query: DataModifyQuery(sql="CREATE TABLE OVM_SERVERPOOL_POOLFILESYSTEM (ServerPoolEntity_CLUSTERID BIGINT, POOLFILESYSTEMS BIGINT)")
[EL Warning]: 2017-08-26 14:51:37.629--ServerSession(1667658949)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'OVM_SERVERPOOL_SERVER' already exists
Error Code: 1050
Call: CREATE TABLE OVM_SERVERPOOL_SERVER (ServerPoolEntity_CLUSTERID BIGINT, SERVERS BIGINT)
Query: DataModifyQuery(sql="CREATE TABLE OVM_SERVERPOOL_SERVER (ServerPoolEntity_CLUSTERID BIGINT, SERVERS BIGINT)")
[EL Warning]: 2017-08-26 14:51:52.672--ServerSession(1667658949)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'OVM_VM_AFFINITYGROUP' already exists
Error Code: 1050
Call: CREATE TABLE OVM_VM_AFFINITYGROUP (VmEntity_CLUSTERID BIGINT, AFFINITYGROUPS BIGINT)
Query: DataModifyQuery(sql="CREATE TABLE OVM_VM_AFFINITYGROUP (VmEntity_CLUSTERID BIGINT, AFFINITYGROUPS BIGINT)")
[EL Warning]: 2017-08-26 14:52:07.718--ServerSession(1667658949)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'OVM_VM_BOOTORDER' already exists
Error Code: 1050
Call: CREATE TABLE OVM_VM_BOOTORDER (VM BIGINT, BOOT_TYPE VARCHAR(32) NOT NULL, SEQUENCE INTEGER NOT NULL)
Query: DataModifyQuery(sql="CREATE TABLE OVM_VM_BOOTORDER (VM BIGINT, BOOT_TYPE VARCHAR(32) NOT NULL, SEQUENCE INTEGER NOT NULL)")
[EL Warning]: 2017-08-26 14:52:22.759--ServerSession(1667658949)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'OVM_VM_VMCLONEDEFINION' already exists
Error Code: 1050

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms