Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-60729

Upgrading JIRA to 7.1.5 breaks due to incorrect syntax in ALTER SQL

      Summary

      Upgrading to JIRA 7.1.5 breaks because the ALTER SQL on customfield table has an incorrect syntax.

      Environment

      • JIRA 7.1.5
      • MSSQL and MySQL database

      Steps to Reproduce

      Upgrade JIRA 7.1.4 to JIRA 7.1.5.

      Expected Results

      Upgrade suppose to finish successfully.

      Actual Results

      The below exception is thrown in the atlassian-jira.log file:

      • For MS SQL:
        2016-04-21 21:03:13,804 JIRA-Bootstrap WARN      [o.o.c.entity.jdbc.DatabaseUtil] Entity "CustomField" has 10 fields but table "dbo.customfield" has 9 columns.
        2016-04-21 21:03:13,804 JIRA-Bootstrap WARN      [o.o.c.entity.jdbc.DatabaseUtil] Field "key" of entity "CustomField" is missing its corresponding column "KEY"
        2016-04-21 21:03:14,491 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Could not add column "KEY" to table "dbo.customfield"
        2016-04-21 21:03:14,491 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
            ALTER TABLE dbo.customfield ADD KEY NVARCHAR(255)
            Error was: java.sql.SQLException: Incorrect syntax near the keyword 'KEY'.
        

        Following by:

        2016-04-21 21:04:47,736 JIRA-Bootstrap ERROR      [c.a.jira.startup.IndexRecoveryLauncher] Automatic index recovery failed
        com.atlassian.cache.CacheException: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM dbo.customfield WHERE ID=? (Incorrect syntax near the keyword 'KEY'.)
        	at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:84)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager.getHelper(DefaultSearchHandlerManager.java:254)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager.getFieldIds(DefaultSearchHandlerManager.java:197)
        	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getSearchSorts(LuceneSearchProvider.java:435)
        	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:279)
        	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchOverrideSecurity(LuceneSearchProvider.java:95)
        	at com.atlassian.jira.issue.search.providers.DualSearchProvider.lambda$searchOverrideSecurity$2(DualSearchProvider.java:88)
        	at com.atlassian.jira.issue.search.providers.DualSearchProvider.performSearch(DualSearchProvider.java:140)
        	at com.atlassian.jira.issue.search.providers.DualSearchProvider.searchOverrideSecurity(DualSearchProvider.java:88)
        	at com.atlassian.jira.index.ha.DefaultIndexRecoveryManager.getLatestIndexDate(DefaultIndexRecoveryManager.java:261)
        	at com.atlassian.jira.index.ha.DefaultIndexRecoveryManager.getDurationToRecover(DefaultIndexRecoveryManager.java:244)
        	at com.atlassian.jira.startup.IndexRecoveryLauncher.start(IndexRecoveryLauncher.java:45)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postTenantArrived$4(DefaultJiraLauncher.java:183)
        	at com.atlassian.jira.startup.DefaultInstantUpgradeManager$StatupTask.run(DefaultInstantUpgradeManager.java:113)
        	at com.atlassian.jira.startup.DefaultInstantUpgradeManager.runTask(DefaultInstantUpgradeManager.java:46)
        	at com.atlassian.jira.startup.DefaultInstantUpgradeManager.doNowOrWhenInstanceBecomesActive(DefaultInstantUpgradeManager.java:35)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.postTenantArrived(DefaultJiraLauncher.java:173)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDBActivated$3(DefaultJiraLauncher.java:161)
        	at com.atlassian.jira.tenancy.DefaultTenantManager.doNowOrWhenTenantArrives(DefaultTenantManager.java:55)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.postDBActivated(DefaultJiraLauncher.java:158)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:147)
        	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:298)
        	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:194)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:137)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:103)
        	at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:101)
        	at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:115)
        	at java.lang.Thread.run(Unknown Source)
        Caused by: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM dbo.customfield WHERE ID=? (Incorrect syntax near the keyword 'KEY'.)
        	at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:207)
        	at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:158)
        	at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.getCustomFieldsFromIds(DefaultCustomFieldManager.java:412)
        	at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.getCustomFieldObjects(DefaultCustomFieldManager.java:402)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager.createHelper(DefaultSearchHandlerManager.java:276)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager$1.get(DefaultSearchHandlerManager.java:102)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager$1.get(DefaultSearchHandlerManager.java:99)
        	at com.atlassian.cache.memory.MemoryCacheManager$1$1.load(MemoryCacheManager.java:93)
        	at com.atlassian.cache.memory.MemoryCacheManager$1$1.load(MemoryCacheManager.java:69)
        	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
        	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
        	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
        	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
        	at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
        	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
        	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
        	at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4830)
        	at com.atlassian.cache.memory.DelegatingCachedReference.getUnderLock(DelegatingCachedReference.java:94)
        	at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:79)
        	... 28 more
        Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM dbo.customfield WHERE ID=? (Incorrect syntax near the keyword 'KEY'.)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:341)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:333)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findById(DefaultOfBizDelegator.java:325)
        	at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findById(WrappingOfBizDelegator.java:192)
        	at com.atlassian.jira.issue.managers.DefaultCustomFieldManager$CustomFieldByIdCacheLoader.load(DefaultCustomFieldManager.java:154)
        	at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:162)
        	at com.atlassian.cache.memory.DelegatingCache.lambda$get$0(DelegatingCache.java:158)
        	at com.atlassian.cache.memory.DelegatingCache.lambda$get$1(DelegatingCache.java:186)
        	at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4742)
        	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
        	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
        	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
        	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
        	at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
        	at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739)
        	at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:173)
        	... 47 more
        Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM dbo.customfield WHERE ID=? (Incorrect syntax near the keyword 'KEY'.)
        	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:641)
        	at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:623)
        	at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:592)
        	at org.ofbiz.core.entity.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:97)
        	at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:611)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:339)
        	... 63 more
        Caused by: java.sql.SQLException: Incorrect syntax near the keyword 'KEY'.
        	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
        	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
        	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
        	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
        	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
        	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
        	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
        	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:633)
        	... 69 more
        
      • For MySQL:
        2016-04-21 19:30:38,959 JIRA-Bootstrap WARN      [o.o.c.entity.jdbc.DatabaseUtil] Entity "CustomField" has 10 fields but table "customfield" has 9 columns.
        2016-04-21 19:30:38,959 JIRA-Bootstrap WARN      [o.o.c.entity.jdbc.DatabaseUtil] Field "key" of entity "CustomField" is missing its corresponding column "KEY"
        2016-04-21 19:30:38,962 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Could not add column "KEY" to table "customfield"
        2016-04-21 19:30:38,962 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
            ALTER TABLE customfield ADD KEY VARCHAR(255)
            Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR(255)' at line 1
        

        Following by:

        2016-04-21 19:31:35,175 JIRA-Bootstrap ERROR      [c.a.jira.startup.IndexRecoveryLauncher] Automatic index recovery failed
        com.atlassian.cache.CacheException: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield WHERE ID=? (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultval' at line 1)
        	at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:84)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager.getHelper(DefaultSearchHandlerManager.java:254)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager.getFieldIds(DefaultSearchHandlerManager.java:197)
        	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.getSearchSorts(LuceneSearchProvider.java:435)
        	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.search(LuceneSearchProvider.java:279)
        	at com.atlassian.jira.issue.search.providers.LuceneSearchProvider.searchOverrideSecurity(LuceneSearchProvider.java:95)
        	at com.atlassian.jira.issue.search.providers.DualSearchProvider.lambda$searchOverrideSecurity$2(DualSearchProvider.java:88)
        	at com.atlassian.jira.issue.search.providers.DualSearchProvider.performSearch(DualSearchProvider.java:140)
        	at com.atlassian.jira.issue.search.providers.DualSearchProvider.searchOverrideSecurity(DualSearchProvider.java:88)
        	at com.atlassian.jira.index.ha.DefaultIndexRecoveryManager.getLatestIndexDate(DefaultIndexRecoveryManager.java:261)
        	at com.atlassian.jira.index.ha.DefaultIndexRecoveryManager.getDurationToRecover(DefaultIndexRecoveryManager.java:244)
        	at com.atlassian.jira.startup.IndexRecoveryLauncher.start(IndexRecoveryLauncher.java:45)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postTenantArrived$4(DefaultJiraLauncher.java:183)
        	at com.atlassian.jira.startup.DefaultInstantUpgradeManager$StatupTask.run(DefaultInstantUpgradeManager.java:113)
        	at com.atlassian.jira.startup.DefaultInstantUpgradeManager.runTask(DefaultInstantUpgradeManager.java:46)
        	at com.atlassian.jira.startup.DefaultInstantUpgradeManager.doNowOrWhenInstanceBecomesActive(DefaultInstantUpgradeManager.java:35)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.postTenantArrived(DefaultJiraLauncher.java:173)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDBActivated$3(DefaultJiraLauncher.java:161)
        	at com.atlassian.jira.tenancy.DefaultTenantManager.doNowOrWhenTenantArrives(DefaultTenantManager.java:55)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.postDBActivated(DefaultJiraLauncher.java:158)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:147)
        	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:298)
        	at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:194)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:137)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:103)
        	at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31)
        	at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:101)
        	at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:115)
        	at java.lang.Thread.run(Thread.java:745)
        Caused by: com.atlassian.cache.CacheException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield WHERE ID=? (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultval' at line 1)
        	at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:207)
        	at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:158)
        	at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.getCustomFieldsFromIds(DefaultCustomFieldManager.java:412)
        	at com.atlassian.jira.issue.managers.DefaultCustomFieldManager.getCustomFieldObjects(DefaultCustomFieldManager.java:402)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager.createHelper(DefaultSearchHandlerManager.java:276)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager$1.get(DefaultSearchHandlerManager.java:102)
        	at com.atlassian.jira.issue.search.managers.DefaultSearchHandlerManager$1.get(DefaultSearchHandlerManager.java:99)
        	at com.atlassian.cache.memory.MemoryCacheManager$1$1.load(MemoryCacheManager.java:93)
        	at com.atlassian.cache.memory.MemoryCacheManager$1$1.load(MemoryCacheManager.java:69)
        	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
        	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
        	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
        	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
        	at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
        	at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3941)
        	at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4824)
        	at com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4830)
        	at com.atlassian.cache.memory.DelegatingCachedReference.getUnderLock(DelegatingCachedReference.java:94)
        	at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:79)
        	... 28 more
        Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield WHERE ID=? (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultval' at line 1)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:341)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:333)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findById(DefaultOfBizDelegator.java:325)
        	at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.findById(WrappingOfBizDelegator.java:192)
        	at com.atlassian.jira.issue.managers.DefaultCustomFieldManager$CustomFieldByIdCacheLoader.load(DefaultCustomFieldManager.java:154)
        	at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:162)
        	at com.atlassian.cache.memory.DelegatingCache.lambda$get$0(DelegatingCache.java:158)
        	at com.atlassian.cache.memory.DelegatingCache.lambda$get$1(DelegatingCache.java:186)
        	at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4742)
        	at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
        	at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
        	at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
        	at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
        	at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
        	at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739)
        	at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:173)
        	... 47 more
        Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultvalue, FIELDTYPE, PROJECT, ISSUETYPE FROM customfield WHERE ID=? (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultval' at line 1)
        	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:641)
        	at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:623)
        	at org.ofbiz.core.entity.GenericDAO.select(GenericDAO.java:592)
        	at org.ofbiz.core.entity.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:97)
        	at org.ofbiz.core.entity.GenericDelegator.findByPrimaryKey(GenericDelegator.java:611)
        	at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByPrimaryKey(DefaultOfBizDelegator.java:339)
        	... 63 more
        Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY, cfname, DESCRIPTION, defaultval' at line 1
        	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
        	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
        	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
        	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
        	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
        	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
        	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
        	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
        	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
        	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
        	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
        	at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:633)
        	... 69 more
        

      Workaround

      Notes

      This appears to be caused by not properly escaping 'KEY', which is a restricted column name in certain DBMS.

            [JRASERVER-60729] Upgrading JIRA to 7.1.5 breaks due to incorrect syntax in ALTER SQL

            Thank u

            Kathy Sawyer added a comment - Thank u

            Hi chris.stamp,

            It should be ok. Having said that, 7.1.6 is already available so you can just upgrade to that

            Regards,

            Oswaldo Hernández.
            JIRA Bugmaster.
            [Atlassian].

            Oswaldo Hernandez (Inactive) added a comment - Hi chris.stamp , It should be ok. Having said that, 7.1.6 is already available so you can just upgrade to that Regards, Oswaldo Hernández. JIRA Bugmaster. [Atlassian] .

            Ok, so if I "downgrade to JIRA 7.1.4 and I already made the upgrade to 7.1.5 will there be a problem. You see I didn't restart to finish the upgrade. Can I downgrade to 7.1.4 and then restart. Will there be any ill affects if I do this? Or will it just wipe what 7.1.5 inserted. Thanks.

            Chris Stamp added a comment - Ok, so if I "downgrade to JIRA 7.1.4 and I already made the upgrade to 7.1.5 will there be a problem. You see I didn't restart to finish the upgrade. Can I downgrade to 7.1.4 and then restart. Will there be any ill affects if I do this? Or will it just wipe what 7.1.5 inserted. Thanks.

            Hi chris.stamp,

            It means we are currently doing final testing of the artifacts containing this fix in our internal dogfooding instances.

            Regards,

            Oswaldo Hernández.
            JIRA Bugmaster.
            [Atlassian].

            Oswaldo Hernandez (Inactive) added a comment - Hi chris.stamp , It means we are currently doing final testing of the artifacts containing this fix in our internal dogfooding instances. Regards, Oswaldo Hernández. JIRA Bugmaster. [Atlassian] .

            What does soaking mean?

            Chris Stamp added a comment - What does soaking mean?

            We are working on a fix for this and we expect it to be delivered early next week. If you are having issues with a production instance due to this issue, please contact support at https://support.atlassian.com/

            Benjamin Magro
            Service Enablement

            Ben Magro (Inactive) added a comment - We are working on a fix for this and we expect it to be delivered early next week. If you are having issues with a production instance due to this issue, please contact support at https://support.atlassian.com/ Benjamin Magro Service Enablement

            As a paying customer when can we see the fix? Can we please get an answer soon. If at all assign to a developer so this can be quickly fixed.

            Chris Stamp added a comment - As a paying customer when can we see the fix? Can we please get an answer soon. If at all assign to a developer so this can be quickly fixed.

            Dick Schiferli added a comment - Link to 7.1.4 is here: https://www.atlassian.com/software/jira/post-download?file=https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-software-7.1.4-jira-7.1.4-x64.bin (Linux 64bit) Maybe can use it for 7.1.2 ?

            Btw, now in the Versions&Licenses admin page it says: JIRA Software is licensed but not currently installed. But hitting the install button won't do anything much. The version display at the bottom is still 7.1.2, but somehow it is not anymore.

            Patrick Scheller added a comment - Btw, now in the Versions&Licenses admin page it says: JIRA Software is licensed but not currently installed. But hitting the install button won't do anything much. The version display at the bottom is still 7.1.2, but somehow it is not anymore.

            Patrick Scheller added a comment - - edited

            (Server Version) We ran into the same problems because we trusted Atlassian to not offer a broken update... but the update button was there and then things broke up. Only after that we read the release notes, since there is no direct link on that update page to them!

            If you cancel a release, then please disable the update!!

            There's no automatic rollback (why not?), so now we have to figure out how to get back to 7.1.2 without losing all our data!

            Patrick Scheller added a comment - - edited (Server Version) We ran into the same problems because we trusted Atlassian to not offer a broken update... but the update button was there and then things broke up. Only after that we read the release notes, since there is no direct link on that update page to them! If you cancel a release, then please disable the update !! There's no automatic rollback (why not?), so now we have to figure out how to get back to 7.1.2 without losing all our data!

              Unassigned Unassigned
              mmuthusamy Moga
              Affected customers:
              32 This affects my team
              Watchers:
              50 Start watching this issue

                Created:
                Updated:
                Resolved: