Details
-
Bug
-
Resolution: Fixed
-
Low
-
None
-
None
-
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
- Install a vanilla instance of Confluence using SQL Server.
- Create thousands of Spaces; i.e. 10000
- 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.