Re: PHP + PDO + PGPOOL = Segmentation fault - Mailing list pgsql-general

From Richard Huxton
Subject Re: PHP + PDO + PGPOOL = Segmentation fault
Date
Msg-id 4AE74D64.6060508@archonet.com
Whole thread Raw
In response to PHP + PDO + PGPOOL = Segmentation fault  (VladK <vladimir.klykov@gmail.com>)
Responses Re: PHP + PDO + PGPOOL = Segmentation fault
List pgsql-general
VladK wrote:
> Hello,
>
> I have a script which is written in PHP (5.2.8) + PDO (1.0.3). It's stable,
> but actual version of PGSQL driver for PDO don't allow persistent
> connections.
>
> So we decided to use PGPOOL-II-2.2.5. It's configured to work in connection
> pool mode with following settings:

PHP doesn't really do connection pools anyway. You would have ended up
with one connection for each Apache backend.

> When our script establish connection to PGPOOL, it can work well or can fail
> with "Segmentation fault". Measurement shows that 40% of script executions
> failed with "Segmentation fault" and always under heavy stress.

What fails with "segmentation fault" - Apache+PHP, pgpool or PostgreSQL?

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: auto truncate/vacuum full
Next
From: Richard Huxton
Date:
Subject: Re: indexing