On 2/11/22 12:44, Rob Sargent wrote:
I'm using jooq3.14, pg_bouncer, tomcat, postgres. I have a long
running process (20 hours) which starts with a select by id, does a
million simulations, then does the select again (it's in a stateless
servlet) and blows up with
SQL [select "base"."markerset"."id", "base"."markerset"."name",
"base"."markerset"."chrom", "base"."markerset"."genome_id",
"base"."markerset"."avg_theta", "base"."markerset"."std_theta"
from "base"."markerset" where "base"."markerset"."id" = cast(? as
uuid)]; ERROR: prepared statement "S_4" does not exist
Or is this pg_bouncer?
I should have mentioned that pg_bouncer is using
pool_mode = transaction
And the line generating the exception is
markersetRec =
dslContext.selectFrom(MARKERSET).where(MARKERSET.ID.equal(mid)).fetchOne();
Sub-note: with only 10,000 simulations the entire process works - or at
least the one test run did.
--
You received this message because you are subscribed to the Google Groups "jOOQ User
Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/3166861f-a427-0682-b729-c42ae3b4d39c%40gmail.com.
