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.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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