Details
-
Bug
-
Resolution: Fixed
-
High
-
7.6.0, 7.6.2, 7.7.0, 7.6.1
-
7.06
-
10
-
Severity 2 - Major
-
19
-
Description
Summary
Upgrading Jira from version prior to 7.4 to 7.6+ causes DVCS to fail on MS SQL environments
Environment
- Jira 7.6.0
- Jira database is using a MS SQL server on the backend such as 2012 or 2014
Steps to Reproduce
This problem can be reproduced by
- Install previous version of Jira such as 7.1.9 or 7.2.x
- Use a MS SQL 2012 database
- connect Jira to a bitbucket or github repo using the DVCS connector
- upgrade Jira to 7.6.0
Expected Results
DVCS works
Actual Results
DVCS stops working, and the logs have errors such as:
Caught SQLServerException 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") as "RETRIES_COUNT" from "dbo"."AO_E8B6CC_MESSAGE" "AO_E8B6CC_MESSAGE" left join "dbo"."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 SQLServerException 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") as "RETRIES_COUNT" from "dbo"."AO_E8B6CC_MESSAGE" "AO_E8B6CC_MESSAGE" left join "dbo"."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"
The more telling error is:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
Which appears to indicate that the DVCS is trying to make a SQL comparison/sort that is not possible in MS SQL
Notes
Workaround
- Manually update all columns in table AO_E8B6CC_% from ntext to nvarchar(max)
Attachments
Issue Links
- is related to
-
-
- Closed
-
- relates to
-
-
- Gathering Impact
-
-
-
- Gathering Impact
-
- mentioned in
-
Page Loading...
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-