JIRA cannot be accessed after upgrading to JIRA 7
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Fisheye および Crucible は除く
問題
After upgrading to JIRA 7, user is unable to access any page.
The following appears in the atlassian-jira.log
016-05-23 14:18:11,966 http-nio-8080-exec-15 ERROR ross 858x2728x1 1isj01k 172.16.101.36 /secure/Dashboard.jspa [o.a.c.c.C.[.[.[.[jsp.decorators.general_002dhead_002dpre_jsp]] Servlet.service() for servlet jsp.decorators.general_002dhead_002dpre_jsp threw exception
com.atlassian.cache.CacheException: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.pyxis.greenhopper.jira]
at com.atlassian.cache.memory.DelegatingCachedReference.get(DelegatingCachedReference.java:62)
...
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.pyxis.greenhopper.jira]
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:86)
at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:42)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
... 1 more
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Microsoft SQL Server
- version:10.00.5538
- minor version:0
- major version:10
- name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
- version:1.3.1
java.sql.SQLException: The object 'DF__AO_60DB71__DESCR__375B2DB9' is dependent on column 'DESCRIPTION'.
...
Caused by: java.sql.SQLException: The object 'DF__AO_60DB71__DESCR__375B2DB9' is dependent on column 'DESCRIPTION'
...
診断
環境
- JIRA 7
Diagnostic Steps
We can see the in the logs the following :
2016-05-23 21:06:45,016 active-objects-init-JiraTenantImpl{id='system'}-0 ERROR ross [n.java.ao.sql] Exception executing SQL update <ALTER TABLE dbo.AO_60DB71_SWIMLANE ALTER COLUMN DESCRIPTION NVARCHAR(255)>
java.sql.SQLException: The object 'DF__AO_60DB71__DESCR__3572E547' is dependent on column 'DESCRIPTION'.
DF_AO_60DB71DESCR_3572E547 is a constraint on table: dbo.AO_60DB71_SWIMLANE
Then we see this error :
2016-05-23 21:06:45,016 active-objects-init-JiraTenantImpl{id='system'}-0 WARN ross [n.j.ao.db.SQLServerDatabaseProvider] Error in schema creation: The object 'DF__AO_60DB71__DESCR__3572E547' is dependent on column 'DESCRIPTION'.; attempting to roll back last partially generated tableWhich shows that the table was only partially generated and then rolled back. This would mean that JIRA software is only partially installed and there are issues in the database which is what's causing the issue.
原因
The upgrade didn't run on the database correctly and it's rolling back the table creation.
回避策
Drop the constrain on the affected table as per http://stackoverflow.com/questions/9866989/alter-table-on-dependant-column
ALTER TABLE AO_60DB71_QUICKFILTER DROP CONSTRAINT [DF__AO_60DB71__DESCR__30AE302A]