[jira] [Created] (AMBARI-21291) Schema error during upgrade related to request table

["Dmytro Grinenko (JIRA)" <ji...@apache.org>]

Dmytro Grinenko created AMBARI-21291:
----------------------------------------

             Summary: Schema error during upgrade related to request table
                 Key: AMBARI-21291
                 URL: https://issues.apache.org/jira/browse/AMBARI-21291
             Project: Ambari
          Issue Type: Bug
          Components: ambari-server
    Affects Versions: 2.5.2
            Reporter: Dmytro Grinenko
            Assignee: Dmytro Grinenko
            Priority: Critical
             Fix For: 2.5.2


During an upgrade from 2.4.1 to 2. 5.1 we experience the following error:
{code}
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) 
{code}

Problem were that cluster_host_info had null value



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)