com.atlassian.jira.scheduler

Class OracleClusteredJobParametersTypeFixer

java.lang.Object

com.atlassian.jira.scheduler.OracleClusteredJobParametersTypeFixer

public class OracleClusteredJobParametersTypeFixer
extends Object

Workaround for JRA-47267, an inconsistent column type on Oracle introduced in JIRA 6.4.8.

In the schema backports that enabled exports from JIRA Cloud to JIRA Server during the 7.0 development period, the "clusteredjob" table's "parameters" column incorrectly got the type LONG RAW instead of BLOB on Oracle. The result of this is that the column can be written to, but attempts to read from it fail, which breaks the scheduler.

This attempts to detect the problem and correct it, either as a one-off or in reaction to an exception while trying to read from the table. The column is modified from LONG RAW to BLOB, which Oracle specifically allows because LONG RAW is an older, deprecated format and BLOB is preferred. Unfortunately, this breaks all of the existing indexes on the table, and they must be rebuilt.

This is the kind of thing we would normally do in an upgrade task, but unfortunately that is way too late. The startup checklist and the start() method of the services container try to ensure that certain scheduled jobs exist, which results in them trying to read from this table before the upgrade tasks have run.

Since:

v7.0.6

Constructor Summary

Constructors

Constructor and Description
OracleClusteredJobParametersTypeFixer(DatabaseConfigurationManager dbConfigManager)

Method Summary

Modifier and Type	Method and Description
StartupCheck	asStartupCheck()
boolean	fix()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OracleClusteredJobParametersTypeFixer

public OracleClusteredJobParametersTypeFixer(DatabaseConfigurationManager dbConfigManager)

Method Detail

fix

public boolean fix()

asStartupCheck

public StartupCheck asStartupCheck()