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

              payert Tamas Payer
              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 - 40m
                  40m