Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
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