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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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 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 | 2 years 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 | 3 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 | 1 year 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