[jira] [Commented] (AMBARI-15774) Ambari upgrade fails with MySQL DB and enforce gtid enabled

["Siddharth Wagle (JIRA)" <ji...@apache.org>]

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

Siddharth Wagle commented on AMBARI-15774:
------------------------------------------

The GTID consistency error is rather strange.

http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-restrictions.html

    Temporary tables. CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements are not supported inside transactions when using GTIDs (that is, when the server was started with the --enforce-gtid-consistency option). It is possible to use these statements with GTIDs enabled, but only outside of any transaction, and only with autocommit=1.



> Ambari upgrade fails with MySQL DB and enforce gtid enabled
> -----------------------------------------------------------
>
>                 Key: AMBARI-15774
>                 URL: https://issues.apache.org/jira/browse/AMBARI-15774
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.2.0
>            Reporter: Siddharth Wagle
>            Assignee: Siddharth Wagle
>            Priority: Critical
>             Fix For: 2.2.2
>
>
> Issue: Ambari upgrade is failing from 2.2.0 to 2.2.1.1 with below error:
> {code}
> mbari-server upgrade 
> Using python /usr/bin/python 
> Upgrading ambari-server 
> Updating properties in ambari.properties ... 
> WARNING: Can not find ambari.properties.rpmsave file from previous version, skipping import of settings 
> WARNING: Can not find ambari-env.sh.rpmsave file from previous version, skipping restore of environment settings 
> Fixing database objects owner 
> Ambari Server configured for MySQL. Confirm you have made a backup of the Ambari Server database [y/n] (y)? y 
> Upgrading database schema 
> Error output from schema upgrade command: 
> Exception in thread "main" org.apache.ambari.server.AmbariException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException 
> Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.TL_alert_notice' doesn't exist 
> Error Code: 1146
> {code}



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