ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tamas Payer (Jira)" <j...@apache.org>
Subject [jira] [Updated] (AMBARI-25627) ORA-01795 error when querying hostcomponentdesiredstate table on large cluster
Date Tue, 09 Mar 2021 06:37:00 GMT

     [ https://issues.apache.org/jira/browse/AMBARI-25627?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Tamas Payer updated AMBARI-25627:
---------------------------------
    Description: 
Ambari server is not able to login because the server is querying Oracle DB which has more
than 1000 entries.
{noformat}
bind => [1173 parameters bound]
 Query: ReadAllQuery(name="HostComponentDesiredStateEntity.findByHostsAndCluster" referenceClass=HostComponentDesiredStateEntity
sql="SELECT id, admin_state, blueprint_provisio
 ning_state, cluster_id, component_name, desired_state, host_id, maintenance_state, restart_required,
service_name FROM hostcomponentdesiredstate WHERE ((host_id IN ?) AND (clu
 ster_id = ?))")
 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
 at ....
 ... 27 more
 Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in
a list is 1000{noformat}

  was:
Ambari server we are not able to login because the server is querying Oracle DB which has
more than 1000 entries.
{noformat}
bind => [1173 parameters bound]
 Query: ReadAllQuery(name="HostComponentDesiredStateEntity.findByHostsAndCluster" referenceClass=HostComponentDesiredStateEntity
sql="SELECT id, admin_state, blueprint_provisio
 ning_state, cluster_id, component_name, desired_state, host_id, maintenance_state, restart_required,
service_name FROM hostcomponentdesiredstate WHERE ((host_id IN ?) AND (clu
 ster_id = ?))")
 at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
 at ....
 ... 27 more
 Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in
a list is 1000{noformat}


> ORA-01795 error when querying hostcomponentdesiredstate table on large cluster
> ------------------------------------------------------------------------------
>
>                 Key: AMBARI-25627
>                 URL: https://issues.apache.org/jira/browse/AMBARI-25627
>             Project: Ambari
>          Issue Type: Task
>          Components: ambari-server
>    Affects Versions: 2.7.4, 2.7.5, 2.7.6
>            Reporter: Tamas Payer
>            Assignee: Tamas Payer
>            Priority: Critical
>              Labels: ambari-server, oracle
>             Fix For: 2.7.6
>
>
> Ambari server is not able to login because the server is querying Oracle DB which has
more than 1000 entries.
> {noformat}
> bind => [1173 parameters bound]
>  Query: ReadAllQuery(name="HostComponentDesiredStateEntity.findByHostsAndCluster" referenceClass=HostComponentDesiredStateEntity
sql="SELECT id, admin_state, blueprint_provisio
>  ning_state, cluster_id, component_name, desired_state, host_id, maintenance_state, restart_required,
service_name FROM hostcomponentdesiredstate WHERE ((host_id IN ?) AND (clu
>  ster_id = ?))")
>  at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
>  at ....
>  ... 27 more
>  Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions
in a list is 1000{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message