Startup error: database is read only

I am using the JIRA provided database for my prototyping/demo purposes and I just started getting the following error on startup:

Error occurred while starting component 'com.atlassian.jira.web.action.issue.DefaultTemporaryWebAttachmentsMonitor'. caused by: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM PUBLIC.clusteredjob WHERE JOB_ID=? (The database is read only; SQL statement: DELETE FROM PUBLIC.clusteredjob WHERE JOB_ID=? [90097-185]))

 

I checked the permissions for the database and they're good - it belongs to my user/group, and to be safe I ran a chmod 666 on it, so it's not a unix issue, this is something internal to the database.  I figure some flag is set and needs to be set, inside the db.  Help!

 

1 answer

This widget could not be displayed.

"run a chmod 666" - that's for files, not databases - you wouldn't get as far as a   You need to check if the user that JIRA uses to log into and read/write the database has full access to it. 

Have a look in jira-home/dbconfig.xml to see who that is, and then use an hsql or h2 tool to check access.

yeah, I didn't expect chmod to do squat, but since I'd had a permissions issue last week, I gave it a try. I can open the database and touch it, no problem. The dbconfig file has the correct username/password too.

Ok, the basic OS stuff is ok then.  But how do you know that the dbconfig file has the correct settings?  How have you tested that?

What should I look for the the dbconfig.xml file to ensure it has the correct settings?

The host, username, password and connection settings.  You need to check that the named user can log into the database with full read/write access.

Switched to a fresh postgres database and it solved the issue I was seeing. Thanks for quick responses.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

97 views 1 0
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