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

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.5.2
• Fix Version/s: 2.5.2
• Component/s: ambari-server
• Assignee: Dmytro Grinenko
• Reporter: Dmytro Grinenko
• Created: 21/Jun/17 08:36
• Updated: 23/Jun/17 16:19
• Resolved: 23/Jun/17 05:24

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

Issue Links

• links to: Review Board