[pgpool-general: 7603] Re: Pgppol - ERROR: maximum number of prepared transactions reached
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Jun 30 10:45:08 JST 2021
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
More information about the pgpool-general
mailing list