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 Join to answer
Community showcase
Emilee Spencer
Published 8 hours ago in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

30 views 0 3
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot