Cannot log into JIRA after upgrade to 5.0.2 w/ Crowd Integration

We just upgraded all of our Atlassian tools this past weekend and have run into a problem where users cannot log into JIRA. Previously we had the JIRA integration with Crowd, but we are seeing errors that seem to state that there's a stale connection within Crowd for JIRA. We had the same problem with Confluence and was able to rectify the problem by resetting the internal Confluence admin account, removing the Crowd integration and logging in locally and then re-establishing the integration with Crowd. The problem is, the initial JIRA (4.1.2) didn't seem to have a local admin account associated with it. So we tried to create a new one and then login locally the same way, but now we can't get in to setup the new Crowd integration.

The errors we are seeing are:

org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

While Confluence documents how to revert from Crowd to internal directory usage, JIRA's documentation doesn't reference this at all. We need help here badly as we're currently down on this JIRA instance.

3 answers

1 accepted

Accepted Answer
0 votes

it was actually a mispelling of the password in the crowd.properties. Pretty simple and stupid on my part. Thanks for helping.

Hi, which version of JIRA / Crowd are you now using? Are you bumping into https://jira.atlassian.com/browse/CWD-2703 that has now been fixed?

There is a table "cwd_directory" in JIRA DB that will have all configured User Directories. By altering the column "directory_position" value in this table, one can bring JIRA back to its own internal directory for authentication

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 16, 2018 in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

80 views 0 4
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you