History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-4089
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: Robin Shen
Reporter: Robin Shen
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
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