You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Tamas Payer (Jira)" <ji...@apache.org> on 2021/03/09 06:36:00 UTC
[jira] [Updated] (AMBARI-25627) ORA-01795 error when querying
hostcomponentdesiredstate table on large cluster
[ 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 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}
was:
Ambari server we are not able to login because the server is querying Oracle DB which has more than 1000 entries.
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
> 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 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}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)