Search Postgresql Archives

Re: PostgreSQL 8.4.8 bringing my website down every evening

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jun 20, 2011 at 5:08 AM, Amitabh Kant <amitabhkant@xxxxxxxxx> wrote:
> 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.

No, in transaction mode the reset_query should actually be empty.

Instead you need to disable use of db-side prepared statements
by adding option PDO::ATTR_EMULATE_PREPARES => true

-- 
marko

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux