[#QB-4089] Able to query builds of large configuation tree via restful api

QuickBuild

Able to query builds of large configuation tree via restful api

Created: 12/Apr/24 01:32 PM Updated: 12/Apr/24 01:33 PM

Component/s:

None

Affects Version/s:

None

Fix Version/s:

None

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Description

« Hide

We encountered an issue with one of API call which looked something like this:

https://<qb_url>/rest/builds?configuration_id=<config_id>&count=1&recursive=true&version=<build_version>

When calling above we received 500 error, "could not extract ResultSet" and in the logs we could see:

SQL Error: 8003, SQLState: S0001
2024-04-11 12:02:05,303 [qtp1793216081-78194028] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
2024-04-11 12:02:05,303 [qtp1793216081-78194028] ERROR com.pmease.quickbuild.rest.providers.GenericExceptionMapper - Error serving restful request (client ip: 10.96.5.151).
org.hibernate.exception.SQLGrammarException: could not extract ResultSet

All

Comments

Work Log

Change History

Sort Order:

Change by Robin Shen [12/Apr/24 01:33 PM]
Field	Original Value	New Value
Description		We encountered an issue with one of API call which looked something like this: When calling above we received 500 error, "could not extract ResultSet" and in the logs we could see: SQL Error: 8003, SQLState: S0001 2024-04-11 12:02:05,303 [qtp1793216081-78194028] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. 2024-04-11 12:02:05,303 [qtp1793216081-78194028] ERROR com.pmease.quickbuild.rest.providers.GenericExceptionMapper - Error serving restful request (client ip: 10.96.5.151). org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Change by Robin Shen [12/Apr/24 01:33 PM]
Description	We encountered an issue with one of API call which looked something like this: When calling above we received 500 error, "could not extract ResultSet" and in the logs we could see: SQL Error: 8003, SQLState: S0001 2024-04-11 12:02:05,303 [qtp1793216081-78194028] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. 2024-04-11 12:02:05,303 [qtp1793216081-78194028] ERROR com.pmease.quickbuild.rest.providers.GenericExceptionMapper - Error serving restful request (client ip: 10.96.5.151). org.hibernate.exception.SQLGrammarException: could not extract ResultSet	We encountered an issue with one of API call which looked something like this: https://<qb_url>/rest/builds?configuration_id=<config_id>&count=1&recursive=true&version=<build_version> When calling above we received 500 error, "could not extract ResultSet" and in the logs we could see: SQL Error: 8003, SQLState: S0001 2024-04-11 12:02:05,303 [qtp1793216081-78194028] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. 2024-04-11 12:02:05,303 [qtp1793216081-78194028] ERROR com.pmease.quickbuild.rest.providers.GenericExceptionMapper - Error serving restful request (client ip: 10.96.5.151). org.hibernate.exception.SQLGrammarException: could not extract ResultSet