[jira] [Created] (AMBARI-5623) GET request on cluster resource gives psql exception

["Nate Cole (JIRA)" <ji...@apache.org>]

Nate Cole created AMBARI-5623:
---------------------------------

             Summary: GET request on cluster resource gives psql exception
                 Key: AMBARI-5623
                 URL: https://issues.apache.org/jira/browse/AMBARI-5623
             Project: Ambari
          Issue Type: Bug
            Reporter: Nate Cole
            Assignee: Nate Cole
             Fix For: 1.6.0


While installation following GET call failed with psql exception,
{noformat}
http://162.216.148.124:8080/api/v1/clusters/c1/requests/?fields=tasks/Tasks/command,tasks/Tasks/exit_code,tasks/Tasks/start_time,tasks/Tasks/end_time,tasks/Tasks/host_name,tasks/Tasks/id,tasks/Tasks/role,tasks/Tasks/status&minimal_response=true&_=139751585355
{noformat} 

Later It was discovered GET call on following API also fails with same exception
{noformat}
http://162.216.148.124:8080/api/v1/clusters/c1
{noformat}

*Exception:*
{noformat}
{
status: 500,
message: " Internal Exception: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 183 Error Code: 0 Call: SELECT request_id, cluster_id, command_name, create_time, end_time, inputs, request_context, request_schedule_id, request_type, start_time, status FROM request WHERE (request_id IN ()) Query: ReadAllQuery(referenceClass=RequestEntity sql="SELECT request_id, cluster_id, command_name, create_time, end_time, inputs, request_context, request_schedule_id, request_type, start_time, status FROM request WHERE (request_id IN ?)")"
}
{noformat}

IOW, if there are no requests in the requests table and you try to do a GET at cluster/{clusterName} or /requests the call encounters this error.



--
This message was sent by Atlassian JIRA
(v6.2#6252)