[AMBARI-25627] ORA-01795 error when querying hostcomponentdesiredstate table on large cluster

• Type: Task
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.7.4, 2.7.5, 2.7.6
• Fix Version/s: 2.8.0, 2.7.6
• Component/s: ambari-server
• Labels: ambari-server oracle
• Assignee: Tamas Payer
• Reporter: Tamas Payer
• Created: 09/Mar/21 06:34
• Updated: 26/Nov/22 08:15
• Resolved: 10/Mar/21 08:32

Description

Ambari server is 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

Issue Links

• links to: GitHub PR#3292
• links to: GitHub PR#3574