ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-21291) Schema error during upgrade related to request table
Date Fri, 23 Jun 2017 16:20:00 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-21291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16061170#comment-16061170
] 

Hudson commented on AMBARI-21291:
---------------------------------

FAILURE: Integrated in Jenkins build Ambari-trunk-Commit #7676 (See [https://builds.apache.org/job/Ambari-trunk-Commit/7676/])
AMBARI-21291. Schema error during upgrade related to request table - (adoroszlai: [http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=8f80fe733dc3a69a83abad2cb8f2ee499cab7da3])
* (edit) ambari-server/src/test/java/org/apache/ambari/server/orm/DBAccessorImplTest.java


> 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
>
>         Attachments: AMBARI-21291.patch
>
>
> 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)

Mime
View raw message