[pgpool-general: 7603] Re: Pgppol - ERROR: maximum number of prepared transactions reached

[Tatsuo Ishii]

Please do not send emails to pgpool-general-owner at pgpool.net.
The address is solely for managing purpose.

> Hi,
> 
> After integrating pgpool with the app server, we tested by running load
> tests with 25 concurrent users.
> The following error comes multiple times while test running:
>  ERROR:  maximum number of prepared transactions reached
> 
> This does not occur when we test by directly pointing to postgres DB.
> 
> Can anyone please clarify?

No idea. Pgpool-II just forwards "PREPARE TRANSACTION" to the primary
PostgreSQL node (also COMMIT PREPARED and ROLLBACK PREPARED).
Maybe SQL log by enabling log_per_node_statement will help.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp