It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Following upgrade to 7.6 DVCS synch appears frozen

Stopped getting BitBucket updates right after the upgrade which seemingly went ok. DVCS will not sync although it appears loaded.

In the atlasian.jira.log we have a message as per the below

2017-11-28 18:57:24,457 WaitForAO ERROR      [c.a.j.p.dvcs.scheduler.DvcsScheduler] Exception waiting for AO to initialize
 at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(
 at com.querydsl.sql.Configuration.translate(
 at com.querydsl.sql.AbstractSQLQuery.fetch(
 at com.atlassian.jira.plugins.dvcs.dao.impl.querydsl.MessageDaoQueryDsl.lambda$getById$8(
 at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.lambda$execute$0(
 at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(
 at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.lambda$execute$0(
 at com.atlassian.jira.database.DatabaseAccessorImpl.runInManagedTransaction(
 ... 3 filtered
 at java.lang.reflect.Method.invoke(
 at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(
 at com.sun.proxy.$Proxy273.runInManagedTransaction(Unknown Source)
 ... 3 filtered
 at java.lang.reflect.Method.invoke(
 at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(
 at com.sun.proxy.$Proxy273.runInManagedTransaction(Unknown Source)
 at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.runInStartedOrExistingTransaction(
 at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(
 at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(
 at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.execute(
 at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInTransaction(
 at com.atlassian.jira.plugins.dvcs.dao.impl.querydsl.MessageDaoQueryDsl.getById(
 at com.atlassian.jira.plugins.dvcs.dao.impl.querydsl.MessageQueueItemDaoQueryDsl.getByQueueAndMessage(
 at com.atlassian.jira.plugins.dvcs.service.MessagingServiceImpl.lambda$initRunningToFail$0(
 at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(
 at com.atlassian.jira.plugins.dvcs.dao.impl.querydsl.util.PseudoStream.consumeAllInTable(
 at com.atlassian.jira.plugins.dvcs.dao.impl.querydsl.MessageQueueItemDaoQueryDsl.getByState(
 at com.atlassian.jira.plugins.dvcs.service.MessagingServiceImpl.initRunningToFail(
 at com.atlassian.jira.plugins.dvcs.service.MessagingServiceImpl.onStart(
 at com.atlassian.jira.plugins.dvcs.scheduler.DvcsScheduler.lambda$onStart$0(
Caused by: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(
 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(
 at com.querydsl.sql.AbstractSQLQuery.fetch(
 ... 41 more

Running the same query as above in the SQL server (same SQL server and instance as before the update), it appears that the query will not execute because it's trying to order by ntext fields ("AO_E8B6CC_MESSAGE"."PAYLOAD"). This is inline with the error shown in the log. 

Seemingly we have the wrong statement issued to the SQL server. Not sure if this is a bug or something went wrong in the upgrade. Any ideas/suggestions?


7 answers

This is breaking for us too and causing havoc on our DEV teams that rely on the DVCS integration as part of our review process. 

Would be great to get an update on this.

@Jeremy Durnell @Casey_Daniell

I had a look at the bug that Andrew created, and it appears we're currently trying to narrow down the cause of the issue.

My recommendation would be to watch the bug itself, so you will receive automatic updates to your email when there are any changes.

Also, if you vote on the bug, it helps show the number of users that are running into the issue so we can include this in our research.

Thank you both for your understanding!



0 votes

Hi there,

Can you please confirm also your MS SQL version and your Bitbucket version?

Kind regards,


Hello Shannon,

MS SQL 2014 and Bitbucket cloud

Thank you for confirming that. Could you confirm what version of Jira you came from initially?

In my investigation, I found that it seems that one of the columns (such as PAYLOAD) needs to be nvarchar, and this is what is causing it. 

I found a few other cases in our system, and they're already working through an investigation, which means it's likely a bug.

I will keep you posted on what we find out.



It was 7.1.9. 

We figured the nvarchar gap but I didn't want to go dropping tables without any visibility on consequences. 

Is there a rough ETA on a possible fix because DVCS has been down for a week now. 

No ETA at this moment, as we're still doing the initial investigation, but it has been escalated internally.

I don't have a public link to provide you but as many of these teams are either in Sydney or the US I will be able to update you tomorrow at least to say whether or not we have found more details on the case, if not a fix.


0 votes
Andy_Heinzer Atlassian Team Nov 30, 2017

Hi Pantelis,

Sorry to hear about this problem.  I have created a new bug for this problem in

I would recommend watching this issue for updates.  As for possible work-arounds until this issue is resolved:

  1. It might be possible to avoid this problem by migrating the Jira database to a different database type such as Postgres
  2. Alternative to that, it might be possible to Roll back the Jira upgrade as a means to revert this upgrade and restore this functionality.

I understand that neither of these are simple quick fixes, but we starting to see more reported cases like this which tends to indicate that this bug should be getting more attention very soon.


Andy_Heinzer Atlassian Team Feb 22, 2018

Just to update this thread, this bug has been fixed in Jira 7.6.3 as well as 7.7.1.  So any versions above those lines are expected to have this fix.

Can you thkn about changing DB by:

To avoid
Caused by: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator
works for me

My concern making the same change is breaking the upgrade path, or inadvertently breaking some other piece of functionality.  

This does seem like a ridiculously simple fix -- there are other varchar(255) datatypes in this table.


Why Atlassian is taking so long to implement, and support, what is a simple fix on the surface is concerning when this is a critical part of many development teams SDLC.

I did change to nvarchar(max) for all AO_E8B6CC_% and made collation to be same for them as well for other columns i DVCS tables.  GITHUB is now connected and works. Something like this can be used:

SELECT CONCAT( 'ALTER TABLE ' ,, ' ALTER COLUMN ',, ' nvarchar(max) COLLATE SQL_Latin1_General_CP437_CI_AI;') FROM   sys.tables AS T INNER JOIN sys.columns C ON T.object_id = C.object_id WHERE  collation_name IS NOT NULL AND collation_name = 'SQL_Latin1_General_CP437_CI_AI' AND like 'AO_E8B6CC_%' and type_name(c.user_type_id) ='ntext'

Will Atlassian support this change, if implemented.

I identified the tables to change with

and TABLE_NAME like 'AO_E8B6CC_%'

Which gives me:  

And this SQL will give me the correct alter statement preserving the nullability of a column.

'alter table [dbo].' + quotename(TABLE_NAME)
+ ' alter column ' + quotename(COLUMN_NAME)
+ ' nvarchar(max) '
+ case when IS_NULLABLE = 'NO' then 'not null' else 'null' end
+ ';'
and TABLE_NAME like 'AO_E8B6CC_%'

Ideally, Atlassian will support these changes and let me get our critically needed GIT / JIRA integration functional again -- our DEV process is currently severely impacted by this issue.

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you