Loading...

Details

Type: Bug
Resolution: Fixed
Priority: High
Fix Version/s: 6.3.11
Affects Version/s: 6.3
Component/s: Scheduled Tasks
Labels:
- affects-server
- warranty

Introduced in Version:
6.03
Bug Fix Policy:
View Atlassian Server bug fix policy

Description

as mentionned by JIRA-38646, the exact same problem still occurs, depending of the content of your database at the moment you start the upgrade of Jira !!!
This bug is NOT specific to MS SQL Server, and we reproduced it with Oracle 11g.
We reproduced it during upgrade of our PROD evnironment, but the bug did not occurs during the repetition on our DEV environment!!
Upgrade of DEV env worked fine... And we almost had to rollback our production release late in the evening .... until we dicovered a workaround!

WORKAROUND:
comment the section for the culprit class com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6304 in file atlassian-jira/WEB-INF/classes/upgrades.xml

 <!-- JIRA 6.3 -->
    <upgrade build="6301">
        <class&gt;com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6301</class&gt;
    </upgrade>
<!--
    <upgrade build="6302">
        <class&gt;com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302</class&gt;
    </upgrade>
-->
    <upgrade build="6304">
        <class&gt;com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6304</class&gt;
    </upgrade>

So please,

Tell what should be done for finishing the upgrade manually (what has to be inserted/updated/deleted in Quartz job trigger and details tables ?
re-open and FIX this bug JIRA-38646 !!

For fun ... here is our stack trace on our Oracle JDBC Driver ....

ERROR      [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: while inserting: [GenericEntity:JQRTZJobDetails][jobName,TIMESHEET_SUBSCRIPTION][requestsRecovery,false][isVolatile,false][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobG
roup,TIMESHEET_SUBSCRIPTION][isStateful,false] (SQL Exception while setting value:  (Invalid column type: 200
0))
org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:JQRTZJobDetails][jobName,TIMESH
EET_SUBSCRIPTION][requestsRecovery,false][isVolatile,false][className,jira.timesheet.plugin.job.TimesheetJob]
[isDurable,true][jobGroup,TIMESHEET_SUBSCRIPTION][isStateful,false] (SQL Exception while setting value:  (Inv
alid column type: 2000))
        at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200)
        at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165)
        at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540)
        at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98)
        at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.jav
a:93)
        at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:693)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:542)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:471)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:413)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:
348)
        at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:106)
        at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:54)
        at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:42)
        at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:137)
        at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigu
rationManagerImpl.java:324)
        at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(D
atabaseConfigurationManagerImpl.java:214)
        at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:118)
        at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:32)
        at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:81)
        at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)
        at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:76)
        at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:71)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while setting value:  (Invalid column type: 2000)
        at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:804)
        at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:714)
        at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:534)
        at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:191)
        at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165)
        at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540)
        at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98)
        at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93)
        at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:693)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:542)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:471)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:413)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:348)
        at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:106)
        at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:54)
        at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:42)
        at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:137)
        at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:324)
        at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(D
atabaseConfigurationManagerImpl.java:214)
        at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:118)
        at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:32)
        at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:81)
        at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)
        at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:76)
        at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:71)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
java.sql.SQLException: Invalid column type: 2000
        at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3916)
        at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4541)
        at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4523)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1281)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
        at org.ofbiz.core.entity.jdbc.SQLProcessor.setBinaryStream(SQLProcessor.java:1103)
        at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:791)
        at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValue(SqlJdbcUtil.java:714)
        at org.ofbiz.core.entity.jdbc.SqlJdbcUtil.setValues(SqlJdbcUtil.java:534)
        at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:191)
        at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165)
        at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554)
        at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540)
        at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98)
        at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93)
        at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:693)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:542)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:471)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:413)
        at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:348)
        at com.atlassian.jira.upgrade.UpgradeLauncher.checkIfUpgradeNeeded(UpgradeLauncher.java:106)
        at com.atlassian.jira.upgrade.UpgradeLauncher.start(UpgradeLauncher.java:54)
        at com.atlassian.jira.startup.ActiveServicesLauncher.start(ActiveServicesLauncher.java:42)
        at com.atlassian.jira.startup.DefaultJiraLauncher$3.run(DefaultJiraLauncher.java:137)
        at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:324)
        at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:214)
        at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:118)
        at com.atlassian.jira.startup.DefaultJiraLauncher.access$100(DefaultJiraLauncher.java:32)
        at com.atlassian.jira.startup.DefaultJiraLauncher$1.run(DefaultJiraLauncher.java:81)
        at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:34)
        at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:76)
        at com.atlassian.jira.startup.LauncherContextListener.contextInitialized(LauncherContextListener.java:71)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4992)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5490)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575)
        at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

Attachments

Issue Links

is cloned from

JRASERVER-38646 JIRA upgrade fails with "The TDS protocol does not support JDBC datatype 2000"

Closed

mentioned in: Page Loading...

was cloned as: JDEV-31133 Loading...

JIRA upgrade fails when DB contains rows in QuartzScheduledJobDetails, FATAL upgrade failure with SQLException ...from com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302

Details

Description

Attachments

Issue Links

Activity

People

Dates