Details
-
Bug
-
Resolution: Fixed
-
Highest
-
1.9.0
-
None
Description
After upgrading to version 1.9.0, some users are reporting poor performance of their JIRA instance and a large number of errors like the following in their atlassian-jira.log files
2015-04-13 11:48:57,845 http-bio-443-exec-48 ERROR judi.uttal 708x6493x3 caokqm 10.11.0.112 /secure/AttachTemporaryFile.jspa [net.java.ao.sql] Exception executing SQL update <ALTER TABLE dbo.AO_A415DF_AOSOLUTION ALTER COLUMN AOPLAN_ID INTEGER NOT NULL> java.sql.SQLException: The object 'U_AO_A415DF_AOSOLUT806524854' is dependent on column 'AOPLAN_ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)
and
2015-04-13 11:48:57,848 http-bio-443-exec-48 ERROR judi.uttal 708x6493x3 caokqm 10.11.0.112 /secure/AttachTemporaryFile.jspa [common.data.activeobjects.ActiveObjectsAccessorImpl] There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:09.00.5057 - minor version:0 - major version:9 Driver: - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase - version:1.2.4 java.sql.SQLException: The object 'U_AO_A415DF_AOSOLUT806524854' is dependent on column 'AOPLAN_ID'. com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:Microsoft SQL Server - version:09.00.5057 - minor version:0 - major version:9 Driver: - name:jTDS Type 4 JDBC Driver for MS SQL Server and Sybase - version:1.2.4 java.sql.SQLException: The object 'U_AO_A415DF_AOSOLUT806524854' is dependent on column 'AOPLAN_ID
Disabling the plugin resolves the error and improves JIRA performance.