[rt.cpan.org #20648] Server side prepares fail on load-balanced web servers.

" via RT" <[email protected]> Mon, 24 Jul 2006 12:32:33 -0400

Newsgroups	gmane.comp.db.postgresql.dbdpg
Message-ID	<[email protected]>

Mon Jul 24 12:32:32 2006: Request 20648 was acted upon.
Transaction: Ticket created by MARKSTOS
       Queue: DBD-Pg
     Subject: Server side prepares fail on load-balanced web servers.
   Broken in: 1.48
    Severity: Normal
       Owner: Nobody
  Requestors: [email protected]
      Status: new
 Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=20648 >


Hello,

After deploying DBD::Pg 1.48 on a load-balanced web server talking to
PostgreSQL 8.1, I saw a lot of these kind of errors:

 prepared statement "dbdpg_7" already exists

I suspect this is because DBD::Pg is on two different machines,
talking to the same database, and each has different concept of
what should be stored in 'dbdpg_7'.

If so, it would be nice if this could be avoided. 

Using a hash of the query itself would be a useful key, because that
means it could originate on one of the front end web servers, 
and then be re-used by one of the other ones.

    Mark