org.apache.oozie.command.CommandException: E0603: SQL error in operation, Ran out of memory retrieving query results. {prepstmnt 287634419 SELECT t0.id, t0.bean_type, t0.app_name, t0.app_path, t0.conf, t0.group_name, t0.parent_id, t0.run, t0.user_name, t0.auth_token, t0.created_time, t0.end_time, t0.external_id, t0.last_modified_time, t0.log_token, t0.proto_action_conf, t0.sla_xml, t0.start_time, t0.status, t0.wf_instance FROM WF_JOBS t0 WHERE (t0.id = ?) AND t0.bean_type = ?} [code=0, state=53200]

oozie-user | Denis Yuen | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    RE: Oozie workflow size

    oozie-user | 3 years ago | Denis Yuen
    org.apache.oozie.command.CommandException: E0603: SQL error in operation, Ran out of memory retrieving query results. {prepstmnt 287634419 SELECT t0.id, t0.bean_type, t0.app_name, t0.app_path, t0.conf, t0.group_name, t0.parent_id, t0.run, t0.user_name, t0.auth_token, t0.created_time, t0.end_time, t0.external_id, t0.last_modified_time, t0.log_token, t0.proto_action_conf, t0.sla_xml, t0.start_time, t0.status, t0.wf_instance FROM WF_JOBS t0 WHERE (t0.id = ?) AND t0.bean_type = ?} [code=0, state=53200]
  2. 0

    RE: Oozie workflow size

    oozie-user | 3 years ago | Denis Yuen
    org.apache.oozie.command.CommandException: E0603: SQL error in operation, Ran out of memory retrieving query results. {prepstmnt 287634419 SELECT t0.id, t0.bean_type, t0.app_name, t0.app_path, t0.conf, t0.group_name, t0.parent_id, t0.run, t0.user_name, t0.auth_token, t0.created_time, t0.end_time, t0.external_id, t0.last_modified_time, t0.log_token, t0.proto_action_conf, t0.sla_xml, t0.start_time, t0.status, t0.wf_instance FROM WF_JOBS t0 WHERE (t0.id = ?) AND t0.bean_type = ?} [code=0, state=53200]

    Root Cause Analysis

    1. org.apache.oozie.command.CommandException

      E0603: SQL error in operation, Ran out of memory retrieving query results. {prepstmnt 287634419 SELECT t0.id, t0.bean_type, t0.app_name, t0.app_path, t0.conf, t0.group_name, t0.parent_id, t0.run, t0.user_name, t0.auth_token, t0.created_time, t0.end_time, t0.external_id, t0.last_modified_time, t0.log_token, t0.proto_action_conf, t0.sla_xml, t0.start_time, t0.status, t0.wf_instance FROM WF_JOBS t0 WHERE (t0.id = ?) AND t0.bean_type = ?} [code=0, state=53200]

      at org.apache.oozie.command.wf.JobXCommand.execute()
    2. org.apache.oozie
      BaseJobServlet.doGet
      1. org.apache.oozie.command.wf.JobXCommand.execute(JobXCommand.java:71)
      2. org.apache.oozie.command.wf.JobXCommand.execute(JobXCommand.java:33)
      3. org.apache.oozie.command.XCommand.call(XCommand.java:277)
      4. org.apache.oozie.DagEngine.getJob(DagEngine.java:331)
      5. org.apache.oozie.servlet.V1JobServlet.getWorkflowJob(V1JobServlet.java:679)
      6. org.apache.oozie.servlet.V1JobServlet.getJob(V1JobServlet.java:212)
      7. org.apache.oozie.servlet.BaseJobServlet.doGet(BaseJobServlet.java:228)
      7 frames