Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-309

Loading space statics with thousands of Confluence Spaces surpasses the limits of elements in an IN predicate in MS SQL Server

    XMLWordPrintable

Details

    • 1
    • Severity 3 - Minor

    Description

      Issue Summary

      During Confluence startup, the Confluence Cloud Migration Assistant pre-loads statistics about all Confluence Spaces.

      If the number of Spaces is too high, there will be warning entries in the application logs similar to the below.

      2020-11-23 18:03:55,574 WARN [SiteSummaryCalculator:thread-1] [hibernate.query.internal.QueryParameterBindingsImpl] doLogf HHH000443: Dialect [org.hibernate.dialect.SQLServer2012Dialect] limits the number of elements in an IN predicate to 2100 entries.  However, the given parameter list [keys] contained 11000 entries, which will likely cause failures to execute the query in the database
      2020-11-23 18:03:55,790 ERROR [SiteSummaryCalculator:thread-1] [engine.jdbc.spi.SqlExceptionHelper] doLog The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
      

      Steps to Reproduce

      1. Install a vanilla instance of Confluence using SQL Server.
      2. Create thousands of Spaces; i.e. 10000
      3. Start Confluence.

      Expected Results

      Confluence starts with no warning presented by the Cloud Migration Assistant.

      Actual Results

      The below warning appears in the atlassian-confluence.log:

      2020-11-23 18:03:55,574 WARN [SiteSummaryCalculator:thread-1] [hibernate.query.internal.QueryParameterBindingsImpl] doLogf HHH000443: Dialect [org.hibernate.dialect.SQLServer2012Dialect] limits the number of elements in an IN predicate to 2100 entries.  However, the given parameter list [keys] contained 11000 entries, which will likely cause failures to execute the query in the database
      2020-11-23 18:03:55,790 ERROR [SiteSummaryCalculator:thread-1] [engine.jdbc.spi.SqlExceptionHelper] doLog The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
      

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available.

      Attachments

        Activity

          People

            Unassigned Unassigned
            tmasutti Thiago Masutti
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: