Details
-
Bug
-
Resolution: Duplicate
-
Low
-
None
-
7.6.2, 7.7.0
-
None
-
7.06
-
Severity 1 - Critical
-
Description
Summary
Upgrading from JIRA version 7.4.3 to JIRA 7.6.2 break the Oracle DCVS tables and sync.
Environment
- JIRA 7.4.3
- JIRA 7.6.2
- Oracle 12C
- GitHub
Steps to Reproduce
- Install JIRA 7.4.3
- Add a GitHub DVCS account
- Create issue, add a commit to the issue
- Upgrade to JIRA 7.6.2
Expected Results
DVCS sync should have no issues.
Actual Results
DVCS Sync will not complete with the following error:
2018-01-15 09:38:34,912 StreamsCompletionService::thread-1 DEBUG admin 578x129x2 1b7fjbv 172.22.94.13 /plugins/servlet/streams [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] getService bundle [com.atlassian.streams.thirdparty-plugin] 2018-01-15 09:38:48,728 http-nio-8762-exec-5 ERROR admin 578x170x1 1b7fjbv 172.22.94.13 /rest/bitbucket/1.0/repository/1/softsync [c.a.j.p.d.sync.impl.DefaultSynchronizer] Caught SQLSyntaxErrorException for select "AO_E8B6CC_MESSAGE"."ID", "AO_E8B6CC_MESSAGE"."ADDRESS", "AO_E8B6CC_MESSAGE"."PAYLOAD", "AO_E8B6CC_MESSAGE"."PAYLOAD_TYPE", "AO_E8B6CC_MESSAGE"."PRIORITY", max("AO_E8B6CC_MESSAGE_QUEUE_ITEM"."RETRIES_COUNT") "RETRIES_COUNT" from "AO_E8B6CC_MESSAGE" "AO_E8B6CC_MESSAGE" left join "AO_E8B6CC_MESSAGE_QUEUE_ITEM" "AO_E8B6CC_MESSAGE_QUEUE_ITEM" on "AO_E8B6CC_MESSAGE"."ID" = "AO_E8B6CC_MESSAGE_QUEUE_ITEM"."MESSAGE_ID" where "AO_E8B6CC_MESSAGE"."ID" = ? group by "AO_E8B6CC_MESSAGE"."ID", "AO_E8B6CC_MESSAGE"."ADDRESS", "AO_E8B6CC_MESSAGE"."PAYLOAD", "AO_E8B6CC_MESSAGE"."PAYLOAD_TYPE", "AO_E8B6CC_MESSAGE"."PRIORITY" com.querydsl.core.QueryException: Caught SQLSyntaxErrorException for select "AO_E8B6CC_MESSAGE"."ID", "AO_E8B6CC_MESSAGE"."ADDRESS", "AO_E8B6CC_MESSAGE"."PAYLOAD", "AO_E8B6CC_MESSAGE"."PAYLOAD_TYPE", "AO_E8B6CC_MESSAGE"."PRIORITY", max("AO_E8B6CC_MESSAGE_QUEUE_ITEM"."RETRIES_COUNT") "RETRIES_COUNT" from "AO_E8B6CC_MESSAGE" "AO_E8B6CC_MESSAGE" left join "AO_E8B6CC_MESSAGE_QUEUE_ITEM" "AO_E8B6CC_MESSAGE_QUEUE_ITEM" on "AO_E8B6CC_MESSAGE"."ID" = "AO_E8B6CC_MESSAGE_QUEUE_ITEM"."MESSAGE_ID" where "AO_E8B6CC_MESSAGE"."ID" = ? group by "AO_E8B6CC_MESSAGE"."ID", "AO_E8B6CC_MESSAGE"."ADDRESS", "AO_E8B6CC_MESSAGE"."PAYLOAD", "AO_E8B6CC_MESSAGE"."PAYLOAD_TYPE", "AO_E8B6CC_MESSAGE"."PRIORITY" at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50) at com.querydsl.sql.Configuration.translate(Configuration.java:453) at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:502) at com.atlassian.jira.plugins.dvcs.dao.impl.querydsl.MessageDaoQueryDsl.lambda$getById$8(MessageDaoQueryDsl.java:196) at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$0(DatabaseAccessorImpl.java:66) at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:86) at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.lambda$execute$0(DefaultTransactionalExecutor.java:42) at com.atlassian.jira.database.DatabaseAccessorImpl.runInManagedTransaction(DatabaseAccessorImpl.java:125) ... 2 filtered at java.lang.reflect.Method.invoke(Method.java:498) ... Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
Notes
I have already tried upgrading to JIRA 7.7.0, but the issue persists.
Workaround
Downgrade the JIRA DVCS Connector Plugin to version 4.1.7
- Stop JIRA
- Remove the JIRA DVCS Connector Plugin 4.2.X version from the JIRA_HOME/plugins/installed-plugins directory
- Add this plugin to the directory : jira-dvcs-connector-plugin-4.1.7.jar (replacing the removed 4.2.x version)
- Start JIRA
Attachments
Issue Links
- duplicates
-
JSWSERVER-16333 Upgrading Jira to 7.6 causes DVCS to fail on Oracle
- Closed