Re: PHP + PDO + PGPOOL = Segmentation fault

From: Richard Huxton <dev(at)archonet(dot)com>
To: VladK <vladimir(dot)klykov(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PHP + PDO + PGPOOL = Segmentation fault
Date: 2009-10-27 19:43:32
Message-ID: 4AE74D64.6060508@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-10-27 19:50:58 Re: indexing
Previous Message Alvaro Herrera 2009-10-27 19:39:58 Re: auto truncate/vacuum full