Re: PostgreSQL 8.4.8 bringing my website down every evening

[Amitabh Kant <amitabhkant@xxxxxxxxx>]

On Mon, Jun 20, 2011 at 1:43 AM, Alexander Farber <alexander.farber@xxxxxxxxx> wrote:

Hello Cedric and others,

On Sun, Jun 19, 2011 at 9:56 PM, Cédric Villemain

<cedric.villemain.debian@xxxxxxxxx> wrote:

> 2011/6/19 Alexander Farber <alexander.farber@xxxxxxxxx>:

>> [pgbouncer]
>> logfile = /var/log/pgbouncer.log
>> pidfile = /var/run/pgbouncer/pgbouncer.pid

>> listen_port = 6432
>> unix_socket_dir = /tmp
>> auth_type = md5
>> auth_file = /var/lib/pgsql/data/global/pg_auth
>> pool_mode = transaction
>> server_check_delay = 10
>> max_client_conn = 200
>> default_pool_size = 20

>> My php script displaying player stats:
>> http://preferans.de/user.php?id=OK493430777441
>> will sometimes exit with the PDO error:
>>
>>  SQLSTATE[26000]: Invalid sql statement name:
>>  7 ERROR: prepared statement
>>  "pdo_stmt_00000016" does not exist
>>

<snip>

why add a begin/commit if I only
have SELECT statements
there (in the default mode) and
the data isn't critical to me
(just some player statistics and
notes by other players - i.e.
a statistic or note is ok to be lost
occasionally)?

Also I've changed my PHP-script
to non-persistent connections:

      $options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
       $db = new PDO(sprintf('pgsql:host=%s port=%u; dbname=%s',
               DBHOST, DBPORT, DBNAME), DBUSER, DBPASS, $options);

and restarted Apache 2.2.3,
but that error is still there:

SQLSTATE[26000]: Invalid sql
statement name: 7 ERROR: prepared

statement "pdo_stmt_0000000a" does not exist

Regards
Alex

Try setting "set server_reset_query = DISCARD ALL;" in your pgbouncer configuration file. 

Amitabh