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

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

    XMLWordPrintable

    Details

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                mmuthusamy Mogavenasan Muthusamy (Inactive)
              • Votes:
                32 Vote for this issue
                Watchers:
                52 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: