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

Error in SQL during Upgrade Task

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • High
    • 4.2
    • 4.2 - EAP
    • Installation
    • JAC, Performance.

    Description

      2010-05-04 01:49:24,618 main INFO      [jira.upgrade.tasks.UpgradeTask_Build552] Converting search requests to use the new labels system field is 100% complete.
      2010-05-04 01:49:24,618 main INFO      [jira.upgrade.tasks.UpgradeTask_Build552] Updating saved filters to use the new labels system field...DONE
      2010-05-04 01:49:24,618 main INFO      [jira.upgrade.tasks.UpgradeTask_Build552] Updating label gadgets use the new labels system field...
      2010-05-04 01:49:24,717 main ERROR      [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception whi
      le executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY =  ? ) (You have a
      n error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY =  'fieldId' )' at line 1)
      com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPRE
      FKEY, USERPREFVALUE FROM gadgetuserpreference WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY =  ? ) (You have an error in your SQL syntax; check the manual that corresponds to yo
      ur MySQL server version for the right syntax to use near ') ) AND (USERPREFKEY =  'fieldId' )' at line 1)
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:188)
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:175)
              at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.updateGadgetConfigurations(UpgradeTask_Build552.java:190)
              at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build552.doUpgrade(UpgradeTask_Build552.java:151)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSucess(UpgradeManagerImpl.java:562)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:466)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:402)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:353)
              at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:292)
              at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:100)
              at com.atlassian.jira.upgrade.UpgradeLauncher.contextInitialized(UpgradeLauncher.java:49)
              at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
              at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
              at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
              at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
              at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
              at org.apache.catalina.core.StandardService.start(StandardService.java:516)
              at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
              at org.apache.catalina.startup.Catalina.start(Catalina.java:583)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:597)
              at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
              at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
      Caused by: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, PORTLETCONFIGURATION, USERPREFKEY, USERPREFVALUE FROM gadgetuserpref
      erence WHERE (PORTLETCONFIGURATION IN () ) AND (USERPREFKEY =  ? ) (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right s
      yntax to use near ') ) AND (USERPREFKEY =  'fieldId' )' at line 1)
              at org.ofbiz.core.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:596)
              at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1076)
              at org.ofbiz.core.entity.GenericDAO.selectByCondition(GenericDAO.java:919)
              at org.ofbiz.core.entity.GenericHelperDAO.findByCondition(GenericHelperDAO.java:162)
              at org.ofbiz.core.entity.GenericDelegator.findByCondition(GenericDelegator.java:960)
              at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.findByCondition(DefaultOfBizDelegator.java:183)
              ... 25 more
      

      Attachments

        Activity

          People

            andreask@atlassian.com Andreas Knecht (Inactive)
            gbarnett George Barnett
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 10m
                10m