[GitHub] [ambari] payert opened a new pull request #3292: AMBARI-25627 ORA-01795 error when querying hostcomponentdesiredstate table on large cluster

[GitBox <gi...@apache.org>]

payert opened a new pull request #3292:
URL: https://github.com/apache/ambari/pull/3292


   ## What changes were proposed in this pull request?
   On clusters when there are more than 1000 nodes and Oracle is used as a rdbms backend the following query is failing due to Oracle's limitation that maximum 1000 parameters are allowed in the 'IN' clause.
   `SELECT id, admin_state, blueprint_provisioning_state, cluster_id, component_name, desired_state, host_id, maintenance_state, restart_required, service_name FROM hostcomponentdesiredstate WHERE ((host_id IN ?)...`
   
   This fix attempts to solve the problem by executing the query in batches < 1000.
   
   ## How was this patch tested?
   
   Manually.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [ambari] hapylestat merged pull request #3292: AMBARI-25627 ORA-01795 error when querying hostcomponentdesiredstate table on large cluster

[GitBox <gi...@apache.org>]

hapylestat merged pull request #3292:
URL: https://github.com/apache/ambari/pull/3292


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org