[AMBARI-21291] Schema error during upgrade related to request table - ASF JIRA

Attach files

Attach Screenshot

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Resolved
Priority: Critical
Resolution: Fixed
Affects Version/s: 2.5.2
Fix Version/s: 2.5.2
Component/s: ambari-server
Labels:
None

Description

During an upgrade from 2.4.1 to 2. 5.1 we experience the following error:

ERROR: Error output from schema upgrade command: 
ERROR: Exception in thread "main" org.apache.ambari.server.AmbariException: Data truncation: Invalid use of NULL value 
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:210) 
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:425) 
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid use of NULL value 
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3833) 
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) 
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) 
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) 
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531) 
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489) 
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848) 
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742) 
at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:844) 
at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:836) 
at org.apache.ambari.server.orm.DBAccessorImpl.setColumnNullable(DBAccessorImpl.java:1086) 
at org.apache.ambari.server.orm.DBAccessorImpl.setColumnNullable(DBAccessorImpl.java:1098) 
at org.apache.ambari.server.orm.DBAccessorImpl.moveColumnToAnotherTable(DBAccessorImpl.java:1340) 
at org.apache.ambari.server.upgrade.UpgradeCatalog251.moveClusterHostColumnFromStageToRequest(UpgradeCatalog251.ja 
at org.apache.ambari.server.upgrade.UpgradeCatalog251.executeDDLUpdates(UpgradeCatalog251.java:90) 
at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:925) 
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:207)

Problem were that cluster_host_info had null value