[
https://issues.apache.org/jira/browse/OOZIE-2669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15489832#comment-15489832
]
zeeshan haider naqvi commented on OOZIE-2669:
---------------------------------------------
I resolved my issue , now it is working fine.
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)
