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.
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot