You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Abhishek Bafna (JIRA)" <ji...@apache.org> on 2016/09/14 08:08:20 UTC
[jira] [Commented] (OOZIE-2669) Oozie error : An SQL data change is
not permitted for a read-only connection, user or database
[ https://issues.apache.org/jira/browse/OOZIE-2669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15489757#comment-15489757 ]
Abhishek Bafna commented on OOZIE-2669:
---------------------------------------
With what user Oozie service is running, Ideally it should be oozie user, as you have oozie user available to you.
What is the database you are using?
Are you facing the issue with only coordinators only, are you able to submit and run workflow successfully?
Thanks.
> 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)