Jira tries to execute ALTER TABLE for Active Objects tables after restart

[Gabriele Caprio]

A customer give me the maintenance of his old jira instance, version 6.2.1. No upgrade is possible.
He doesn't explain me nothing about it so I must to learn all alone.

At first sight all is easy, but my first impossibile error come when I tried to stop and start Jira with its script...

When it was started in fact, every time I want to read a AO table Jira is going in error with this message:

2019-09-04 16:23:14,222 http-bio-9443-exec-2 ERROR admin 982x264x5 1nbazy7 10.57.2.81 /rest/walm/1.0/targetrelease/alltranddc [net.java.ao.sql] Exception executing SQL update <ALTER TABLE "AO_EE8909_RILAS_REQUISITI_BULK" MODIFY ("ID" NULL)>
java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2309)
at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2379)
at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2342)
at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:99)
at net.java.ao.EntityManager.migrate(EntityManager.java:143)
[CUT]
2019-09-04 16:23:14,236 http-bio-9443-exec-2 WARN admin 982x264x5 1nbazy7 10.57.2.81 /rest/walm/1.0/targetrelease/alltranddc [java.ao.db.OracleDatabaseProvider] Error in schema creation: ORA-01451: column to be modified to NULL cannot be modified to NULL
; attempting to roll back last partially generated table
2019-09-04 16:23:14,238 http-bio-9443-exec-2 ERROR admin 982x264x5 1nbazy7 10.57.2.81 /rest/walm/1.0/targetrelease/alltranddc [alm.rest.enumerator.TargetReleaseResourcesImpl] Error loading all datas
com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
- minor version:2
- major version:11
Driver:
- name:Oracle JDBC driver
- version:11.2.0.2.0

java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL

at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:48)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:52)
at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:39)
at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.createActiveObjects(ActiveObjectsServiceFactory.java:136)
at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory.access$000(ActiveObjectsServiceFactory.java:51)
at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$1$1.get(ActiveObjectsServiceFactory.java:65)
at com.atlassian.activeobjects.osgi.ActiveObjectsServiceFactory$1$1.get(ActiveObjectsServiceFactory.java:61)
at com.atlassian.activeobjects.osgi.DelegatingActiveObjects$MemoizingSupplier.get(DelegatingActiveObjects.java:156)
at com.atlassian.activeobjects.osgi.DelegatingActiveObjects.find(DelegatingActiveObjects.java:83)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
[CUT]
Caused by: java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2309)
at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2379)
at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2342)
at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:99)
at net.java.ao.EntityManager.migrate(EntityManager.java:143)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:44)
... 211 more

This ALTER TABLE is absolutely unnecessary and unrequested... I don't know what I can do, it stoppped to work :(

Somebody can help me with a resolution or a workaround?

[JP _AC Bielefeld Leader_ · Accepted solution]

Hm,

you won't get any support on this version from Atlassian. I'm not an expert on Jira 6, so I can only guess:

The ActiveObject tables often belong to Jira addons, so my first try would be to startup Jira with addons disabled. Still no idea how to disable them with Jira 6.2.1

All the best

JP

[Mike Rathwell · Accepted solution]

Hi @Gabriele Caprio 

This does seem odd indeed, especially if it was running before. That said Jira will do a bunch of table updates on start for "current state" kinda stuff (at least that is what I presume is happening.

This does feel a lot like Jira can't access the database for some reason or doesn't have permission to "do stuff". A starting place might be to look at the JIRA_HOME/dbconfig.xml to make sure that it is pointing to the database with permission to do stuff to it. Try to connect to the database on the command line using the credentials in the xml file.

Also... you didn't note the OS this is running on or which script you tried to start Jira with. Some of the scripts in the JIRA_INSTALL/bin directory call others and pass parameters; using the wrong one can get some... interesting... results.