org.apache.oozie.command.CommandException: E0603: SQL error in operation, Ran out of memory retrieving query results. {prepstmnt 906542123 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
  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 906542123 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 906542123 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]
  3. 0

    JA017: Could not lookup launched hadoop Job ID

    Stack Overflow | 1 year ago | Mobin Ranjbar
    org.apache.oozie.command.CommandException: E0800: Action it is not running its in [FAILED] state, action [0000010-150711083342968-oozie-root-W@mapreduce-52d9]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ActionExecutorException: Unknown hadoop job associated with action. Failing this action

    Stack Overflow | 2 years ago | Kumar Reddy Basapuram
    org.apache.oozie.command.CommandException: E0800: Action it is not running its in [PREP] state, action [0000011-140804121522195-oozie-hwcl-W@hive-node]
  6. 0

    Apache Oozie Installation on Hadoop 2.4.1 | Gaurav Kohli

    gauravkohli.com | 12 months ago
    org.apache.oozie.command.CommandException: E0800: Action it is not running its in [PREP] state, action [0000003-140930181109732-oozie-impa-W@mr-node]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.apache.oozie.executor.jpa.JPAExecutorException

      E0603: SQL error in operation, Ran out of memory retrieving query results. {prepstmnt 906542123 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.executor.jpa.WorkflowJobGetJPAExecutor.execute()
    2. org.apache.oozie
      CallableQueueService$CallableWrapper.run
      1. org.apache.oozie.executor.jpa.WorkflowJobGetJPAExecutor.execute(WorkflowJobGetJPAExecutor.java:62)
      2. org.apache.oozie.executor.jpa.WorkflowJobGetJPAExecutor.execute(WorkflowJobGetJPAExecutor.java:32)
      3. org.apache.oozie.service.JPAService.execute(JPAService.java:212)
      4. org.apache.oozie.command.wf.ActionCheckXCommand.eagerLoadState(ActionCheckXCommand.java:87)
      5. org.apache.oozie.command.XCommand.call(XCommand.java:246)
      6. org.apache.oozie.service.CallableQueueService$CompositeCallable.call(CallableQueueService.java:326)
      7. org.apache.oozie.service.CallableQueueService$CompositeCallable.call(CallableQueueService.java:255)
      8. org.apache.oozie.service.CallableQueueService$CallableWrapper.run(CallableQueueService.java:175)
      8 frames
    3. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      3. java.lang.Thread.run(Thread.java:662)
      3 frames