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

0 vote

"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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Trello

Alice Camilla on organizing your work/life/fandoms with Trello!

@Alice Camilla is a university student, currently writing her MA thesis in Archaeology. She's also a freelance blogger and content creator, writing about geeky stuff from productivity apps to JR...

91 views 2 7
Read article

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