Jira is having difficulty contacting Bitbucket Data Center. If this condition persists, please contact your Jira administrators.
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
After upgrading Jira to Jira 8.17 and Bitbucket to 7.12, when editing an issue the Development panel shows the error message "Jira is having difficulty contacting Bitbucket. If this condition persists, please contact your Jira administrators".
Removing and recreating the Application Links does not resolve the issue.
Application links on both Jira and Bitbucket show "Connected".
Environment
Tested on Jira 8.17.0
Tested on Bitbucket 7.12
Diagnosis
Navigate to logging and profiling in the admin section of JIRA
Add the following packages, setting them to Debug:
org.apache.http is very verbose, we need to enable, reproduce and disable quickly
1 2 3 4
com.atlassian.applinks com.atlassian.plugin.remotable.plugin.module.oauth.OAuth2LOAuthenticator com.atlassian.plugin.remotable.plugin.OAuthLinkManager org.apache.http
atlassian-jira.log
shows the following error:
1
2
3
/rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7443 << "Caused by: Error : 955, Position : 16, Sql = CREATE SEQUENCE "AO_777666_JIRA_SITE1384450722" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1, OriginalSql = CREATE SEQUENCE "AO_"
...
/rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7443 << "777666_JIRA_SITE1384450722" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1, Error Msg = ORA-00955: name is already used by an existing object[\n]"
Full Stack Trace
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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
2021-10-15 07:59:41,999-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.client.protocol.RequestAddCookies] CookieSpec selected: standard
2021-10-15 07:59:42,000-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.conn.PoolingHttpClientConnectionManager] Connection request: [route: {}->http://Bitbucket.domain.com:7990][total available: 0; route allocated: 0 of 5; total allocated: 0 of 10]
2021-10-15 07:59:42,000-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.conn.PoolingHttpClientConnectionManager] Connection leased: [id: 7420][route: {}->http://Bitbucket.domain.com:7990][total available: 0; route allocated: 1 of 5; total allocated: 1 of 10]
2021-10-15 07:59:42,000-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.execchain.MainClientExec] Opening connection {}->http://Bitbucket.domain.com:7990
2021-10-15 07:59:42,005-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.conn.DefaultHttpClientConnectionOperator] Connecting to Bitbucket.domain.com/222.33.333.221:7990
2021-10-15 07:59:42,005-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.conn.DefaultHttpClientConnectionOperator] Connection established 222.33.333.221:41782<->222.33.333.221:7990
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.conn.DefaultManagedHttpClientConnection] http-outgoing-7420: set socket timeout to 5000
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.execchain.MainClientExec] Executing request GET /rest/remote-link-aggregation/latest/aggregation?globalId=RAND-1 HTTP/1.1
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.execchain.MainClientExec] Proxy auth state: UNCHALLENGED
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 >> GET /rest/remote-link-aggregation/latest/aggregation?globalId=RAND-1 HTTP/1.1
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 >> Authorization: OAuth oauth_token="", oauth_consumer_key="jira%3A22222222-cccc-4444-9999-111111111111", oauth_signature_method="RSA-SHA1", oauth_timestamp="1634302781", oauth_nonce="77777777-2222-4444-8888-333333333333_4444444444444444", oauth_version="1.0", oauth_signature="AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 >> Host: Bitbucket.domain.com:7990
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 >> Connection: Keep-Alive
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 >> User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_275)
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 >> Accept-Encoding: gzip,deflate
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 >> "GET /rest/remote-link-aggregation/latest/aggregation?globalId=RAND-1 HTTP/1.1[\r][\n]"
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 >> "Authorization: OAuth oauth_token="", oauth_consumer_key="jira%3A22222222-cccc-4444-9999-111111111111", oauth_signature_method="RSA-SHA1", oauth_timestamp="1634302781", oauth_nonce="77777777-2222-4444-8888-333333333333_4444444444444444", oauth_version="1.0", oauth_signature="AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"[\r][\n]"
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 >> "Host: Bitbucket.domain.com:7990[\r][\n]"
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 >> "Connection: Keep-Alive[\r][\n]"
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 >> "User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_275)[\r][\n]"
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 >> "Accept-Encoding: gzip,deflate[\r][\n]"
2021-10-15 07:59:42,006-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 >> "[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "HTTP/1.1 500 [\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "X-AREQUESTID: @PPPPPPx479x256854x0[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Cache-Control: max-age=1800, must-revalidate, private[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Vary: Accept[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Content-Type: application/xml[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Transfer-Encoding: chunked[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Date: Fri, 15 Oct 2021 12:59:42 GMT[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Connection: close[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "2000[\r][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "<?xml version="1.0" encoding="UTF-8" standalone="yes"?><status><status-code>500</status-code><message>bundle [com.atlassian.Bitbucket.server.Bitbucket-jira-development-integration]</message><stack-trace>com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.Bitbucket.server.Bitbucket-jira-development-integration][\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:95)[\n]"
[...]
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Database:[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]- name:Oracle[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]- version:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "and Real Application Testing options[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]- minor version:1[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]- major version:12[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Driver:[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]- name:Oracle JDBC driver[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]- version:12.2.0.1.0[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[\n]"
2021-10-15 07:59:42,060-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:54)[\n]"
[...] 2021-10-15 07:59:42,061-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object[\n]"
[...] 2021-10-15 07:59:42,061-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "Caused by: Error : 955, Position : 16, Sql = CREATE SEQUENCE "AO_777666_JIRA_SITE1384450722" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1, OriginalSql = CREATE SEQUENCE "AO_"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 << HTTP/1.1 500
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 << X-AREQUESTID: @PPPPPPx479x256854x0
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 << Cache-Control: max-age=1800, must-revalidate, private
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 << Vary: Accept
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 << Content-Type: application/xml
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 << Transfer-Encoding: chunked
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 << Date: Fri, 15 Oct 2021 12:59:42 GMT
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.headers] http-outgoing-7420 << Connection: close
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "777666_JIRA_SITE1384450722" INCREMENT BY 1 START WITH 1 NOMAXVALUE MINVALUE 1, Error Msg = ORA-00955: name is already used by an existing object[\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)[\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[0x9]... 70 more[\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "</stack-trace>[\r][\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "9[\r][\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "</status>[\r][\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "0[\r][\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.apache.http.wire] http-outgoing-7420 << "[\r][\n]"
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.conn.DefaultManagedHttpClientConnection] http-outgoing-7420: Close connection
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.execchain.MainClientExec] Connection discarded
2021-10-15 07:59:42,062-0500 devstatus.applink:thread-4 DEBUG xxxxxxxx 505x2508x1 1rk5hkt 11.xxx.xxx.x /rest/dev-status/1.0/issue/summary [o.a.h.impl.conn.PoolingHttpClientConnectionManager] Connection released: [id: 7420][route: {}->http://Bitbucket.domain.com:7990][total available: 0; route allocated: 0 of 5; total allocated: 0 of 10]
Cause
JIRA does not check properly if all the "AO_*" tables and sequences already exist. Reference: JRASERVER-29155 - Check for pre existing sequences when using Oracle DB.
Solution
1. Start with backing up your Bitbucket database.
2. Stop your Bitbucket instance.
3. In a database session, confirm that the offending sequence already exists through a query such as the following:
1
2
3
SELECT *
FROM all_sequences
WHERE sequence_name LIKE 'AO_777666_JIRA_SITE1384450722';
4. Record the value under the 'LAST_NUMBER
' column. (If the 'LAST_NUMBER
' column is just equal to 1, this step can safely be ignored).
5. Drop the sequence using a query similar to the following:
1
DROP SEQUENCE AO_777666_JIRA_SITE1384450722;
6. Start Bitbucket
ℹ️ This should re-create the sequence that we dropped and allow the application to proceed normally and without error
7. If the previous 'LAST_NUMBER
' value for the sequence wasn't 1, we recommend resetting the LAST_NUMBER
value back to the original value through the following query:
1
2
ALTER SEQUENCE AO_777666_JIRA_SITE1384450722 RESTART
START WITH LAST_NUMBER_VALUE_HERE;
Was this helpful?