After Upgrade to BDA V4.9/CDH 5.11.1 The Navigator Audit Server Fails to Start with "Current database schema version: 5900"/"SQL error when updating tables. java.sql.BatchUpdateException: Duplicate key name"

(Doc ID 2327339.1)

Last updated on NOVEMBER 12, 2017

Applies to:

Big Data Appliance Integrated Software - Version 4.9.0 and later
Linux x86-64

Symptoms

After upgrade to BDA V4.9/CDH 5.11.1 the Navigator Audit Server fails to start. The Navigator Audit Server role log shows errors like below:

2017-11-12 15:48:20,187 INFO org.hibernate.validator.internal.util.Version [main]: **: Hibernate Validator 5.0.1.Final
2017-11-12 15:48:20,892 INFO com.cloudera.enterprise.dbutil.DbUtil [main]: Schema version table doesn't exist.
2017-11-12 15:48:20,895 INFO com.cloudera.enterprise.dbutil.DbUtil [main]: Schema version table already exists.
2017-11-12 15:48:20,897 INFO com.cloudera.enterprise.dbutil.DbUtil [main]: DB Schema version 5900.
2017-11-12 15:48:20,897 INFO com.cloudera.enterprise.dbutil.DbUtil [main]: Current database schema version: 5900
2017-11-12 15:48:20,983 ERROR com.cloudera.navigator.schema.AbstractPartitionUpgrade [main]: SQL error when updating tables.
java.sql.BatchUpdateException: Duplicate key name '***_****'
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1110)
at com.cloudera.navigator.schema.AbstractPartitionUpgrade.upgradePartitions(AbstractPartitionUpgrade.java:120)
at com.cloudera.navigator.schema.AbstractPartitionUpgrade.upgradeMySQL(AbstractPartitionUpgrade.java:36)
at com.cloudera.navigator.schema.CreateIndexOnPrivilegeForImpalaAudits.upgradeMySQL(CreateIndexOnPrivilegeForImpalaAudits.java:28)
at com.cloudera.enterprise.dbutil.JavaRunner$DbUpgradeVisitor.handleMySql(JavaRunner.java:92)
at com.cloudera.enterprise.dbutil.JavaRunner$DbUpgradeVisitor.handleMySql(JavaRunner.java:74)
at com.cloudera.enterprise.dbutil.MySqlHandler.dispatch(MySqlHandler.java:76)
at com.cloudera.enterprise.dbutil.JavaRunner.run(JavaRunner.java:54)
at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:139)
at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:139)
at com.cloudera.enterprise.dbutil.DbUtil.runScripts(DbUtil.java:444)
at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchemaInternal(DbUtil.java:384)
at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:354)
at com.cloudera.navigator.NavigatorServer.initializeDatabase(NavigatorServer.java:152)
at com.cloudera.navigator.NavigatorServer.<init>(NavigatorServer.java:87)
at com.cloudera.navigator.NavigatorMain.main(NavigatorMain.java:20)
2017-11-12 15:48:20,990 ERROR com.cloudera.enterprise.dbutil.JavaRunner [main]: Exception while executing com.cloudera.navigator.schema.CreateIndexOnPrivilegeForImpalaAudits
java.lang.RuntimeException: SQL error when altering tables.

 

 

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