#42450 [NEW]: PDO pgSql persistent connections fails on PostgreSQL server restart

From: davojan at mail dot ru Operating system: FreeBSD and WinXP PHP version: 5.2.3 PHP Bug Type: PostgreSQL related Bug description: PDO pgSql persistent connections fails on PostgreSQL server restart Description: ------------ When using PDO pgSQL with persistent connections and restarting the PostgreSQL server, which the PDO has been connected with, PDO raises exception (see below). So I need to restart PHP to reset persistent connections. The bug was reproduced in two different environments: Apache2 (multi-threaded) + mod_php + WinXP lighttpd + PHP(FastCGI) + FreeBSD MySQL persistent connections in the same situation works fine... Reproduce code: --------------- <?php $db = new PDO( 'pgsql:host=localhost port=5432 dbname=test user=user password=secret', 'user', 'secret', array( PDO::ATTR_PERSISTENT => true ) ); echo 'ok'; ?> # /usr/local/etc/rc.d/postgresql restart and again the above php script Expected result: ---------------- ok Actual result: -------------- Unknown exception: SQLSTATE[57P01]: Admin shutdown: 7 FATAL: <closing connection on admin command> (this is my translation from russian message) server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. -- Edit bug report at http://bugs.php.net/?id=42450&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42450&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42450&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42450&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42450&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42450&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42450&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42450&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42450&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42450&r=support Expected behavior: http://bugs.php.net/fix.php?id=42450&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42450&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42450&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42450&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42450&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42450&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42450&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42450&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42450&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42450&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42450&r=mysqlcfg