ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myroslav Papirkovskyy (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMBARI-8079) 1.5.1 -> 1.7.0 upgrade fails with mysql DB
Date Fri, 31 Oct 2014 19:19:33 GMT
Myroslav Papirkovskyy created AMBARI-8079:
---------------------------------------------

             Summary: 1.5.1 -> 1.7.0 upgrade fails with mysql DB
                 Key: AMBARI-8079
                 URL: https://issues.apache.org/jira/browse/AMBARI-8079
             Project: Ambari
          Issue Type: Bug
          Components: ambari-server
    Affects Versions: 1.7.0
            Reporter: Myroslav Papirkovskyy
            Assignee: Myroslav Papirkovskyy
            Priority: Blocker
             Fix For: 1.7.0


ambari 1.5.1 with mysqldb for ambari db
upgraded to 1.70, fails with the error below

{code}
[root@c6402 yum.repos.d]# ambari-server upgrade
Using python  /usr/bin/python2.6
Upgrading ambari-server
Updating properties in ambari.properties ...
ERROR: Error executing schema upgrade, please check the server logs.
ERROR: Ambari server upgrade failed. Please look at /var/log/ambari-server/ambari-server.log,
for more details.
ERROR: Exiting with exit code 11. 
REASON: Schema upgrade failed.
[root@c6402 yum.repos.d]# 
{code}

{code}
12:34:42,587  WARN [main] DBAccessorImpl:535 - Error executing query: ALTER TABLE viewmain
ADD icon VARCHAR(255) 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambaridb.viewmain' doesn't
exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
	at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:532)
	at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:518)
	at org.apache.ambari.server.orm.DBAccessorImpl.addColumn(DBAccessorImpl.java:384)
	at org.apache.ambari.server.upgrade.UpgradeCatalog161.executeDDLUpdates(UpgradeCatalog161.java:113)
	at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:383)
	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:179)
	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:239)
12:34:42,594 ERROR [main] SchemaUpgradeHelper:181 - Upgrade failed. 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambaridb.viewmain' doesn't
exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
	at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:532)
	at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:518)
	at org.apache.ambari.server.orm.DBAccessorImpl.addColumn(DBAccessorImpl.java:384)
	at org.apache.ambari.server.upgrade.UpgradeCatalog161.executeDDLUpdates(UpgradeCatalog161.java:113)
	at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:383)
	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:179)
	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:239)
12:34:42,596 ERROR [main] SchemaUpgradeHelper:252 - Exception occured during upgrade, failed
org.apache.ambari.server.AmbariException: Table 'ambaridb.viewmain' doesn't exist
	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:182)
	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:239)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambaridb.viewmain'
doesn't exist
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
	at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:532)
	at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:518)
	at org.apache.ambari.server.orm.DBAccessorImpl.addColumn(DBAccessorImpl.java:384)
	at org.apache.ambari.server.upgrade.UpgradeCatalog161.executeDDLUpdates(UpgradeCatalog161.java:113)
	at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:383)
	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:179)
	... 1 more
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message