[ https://issues.apache.org/jira/browse/OOZIE-2669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
zeeshan haider naqvi resolved OOZIE-2669. ----------------------------------------- Resolution: Fixed 1 Go to the 'Oozie Data Dir' folder and check to see that oozie-db folder and subdirectory and files is owned by oozie:hadoop 2 If this is not the case, do a chown -R oozie:hadoop <OOZIE_DATA_DIR>/oozie_db > Oozie error : An SQL data change is not permitted for a read-only connection, > user or database > ---------------------------------------------------------------------------------------------- > > Key: OOZIE-2669 > URL: https://issues.apache.org/jira/browse/OOZIE-2669 > Project: Oozie > Issue Type: Bug > Components: coordinator > Reporter: zeeshan haider naqvi > > While running oozie job i am getting below exception:- > 2016-09-13 17:43:05,449 WARN CoordSubmitXCommand:523 - > SERVER[ip-10-47-143-47.us-west-2.compute.internal] USER[-] GROUP[-] TOKEN[-] > APP[-] JOB[-] ACTION[-] ERROR: org.apache.oozie.command.CommandException: > E0603: SQL error in operation, > org.apache.openjpa.persistence.RollbackException: The transaction has been > rolled back. See the nested exceptions for details on the errors that > occurred. FailedObject: org.apache.oozie.CoordinatorJobBean@550f4b27 > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: An SQL data > change is not permitted for a read-only connection, user or database. > {prepstmnt 1670056758 INSERT INTO COORD_JOBS (id, app_name, app_namespace, > app_path, bundle_id, concurrency, conf, created_time, done_materialization, > end_time, execution, external_id, frequency, group_name, job_xml, > last_action_number, last_action, last_modified_time, mat_throttling, > next_matd_time, orig_job_xml, pause_time, pending, sla_xml, start_time, > status, suspended_time, time_out, time_unit, time_zone, user_name) VALUES (?, > ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?)} [code=20000, state=25502] > I have also tried to run command : > sudo -u oozie /usr/lib/oozie/bin/ooziedb.sh create -sqlfile > /usr/lib/oozie/oozie.sql -run -- This message was sent by Atlassian JIRA (v6.3.4#6332)