Uploaded image for project: 'Ambari'
  1. Ambari
  2. AMBARI-25627

ORA-01795 error when querying hostcomponentdesiredstate table on large cluster

    XMLWordPrintableJSON

    Details

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                payert Tamas Payer
                Reporter:
                payert Tamas Payer
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m