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!
"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.
Thanks for signing up for Jira Ops! I’m Matt Ryall, leader for the Jira Ops product team at Atlassian. Since this is a brand new product, we’ll be delivering improvements quickly and sharing updates...
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!
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