[
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)
