| << Back to previous view |
|
[QB-4089] Able to query builds of large configuation tree via restful api
|
|
| Status: | Closed |
| Project: | QuickBuild |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 15.0.0 |
| Type: | Improvement | Priority: | Major |
| Reporter: | Robin Shen | Assigned To: | Robin Shen |
| Resolution: | Fixed | Votes: | 0 |
| Remaining Estimate: | Unknown | Time Spent: | Unknown |
| Original Estimate: | Unknown | ||
| Description |
|
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 |