Editing issues with large history may be slow after upgrading to Jira v9.5.x with Oracle Database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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.
*Except Fisheye and Crucible
Summary
This article describes a problem with issues takes a long time to update (8-20 seconds) after upgrading the Jira Data Center to version 9.5.x from 8.20.x.
Environment
Jira Data Center 9.5.x with Oracle Database
Diagnosis
The following stack trace was observed in the thread dump. Going through the stack trace, there appears to be a problem with the database driver itself.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
Stack trace
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.parser.ParseNode.descendants(ParseNode.java:48)
oracle.jdbc.driver.OracleParameterMetaDataParser.findFirstDescendant(OracleParameterMetaDataParser.java:963)
oracle.jdbc.driver.OracleParameterMetaDataParser.findBindVarNodeMetaData(OracleParameterMetaDataParser.java:1099)
oracle.jdbc.driver.OracleParameterMetaDataParser.getParameterMetaDataSql_internal(OracleParameterMetaDataParser.java:584)
oracle.jdbc.driver.OracleParameterMetaDataParser.getParameterMetaDataSql(OracleParameterMetaDataParser.java:1285)
oracle.jdbc.driver.OracleParameterMetaData.<init>(OracleParameterMetaData.java:194)
oracle.jdbc.driver.OracleParameterMetaData.getParameterMetaData(OracleParameterMetaData.java:150)
oracle.jdbc.driver.OraclePreparedStatement.getParameterMetaData(OraclePreparedStatement.java:10566)Cause
In this scenario, it was found that the Oracle Database driver version used is 23.2.0. However, this driver is not supported by Jira:
1
Database Driver : Oracle JDBC driver - 23.2.0.0.0 Driver information can be found in atlassian-jira.log file at time when Jira is started.
Refer to the Supported platforms documentation:
JDBC Driver: For all Oracle versions, use the JDBC 19.3 (ojdbc8) driver listed here. This is the driver we’re using to test Jira with Oracle.
Solution
Use Oracle JDBC 19.3 (ojdbc8) driver listed here.
Was this helpful?