ID: 31411 Comment by: benjiro at benjiro dot com Reported By: mike at ecommerce dot com Status: No Feedback Bug Type: PostgreSQL related Operating System: * PHP Version: 5CVS, 4CVS (2005-01-17) New Comment:
This problem has also confirmed in PHP Version 5.2.6-2+b1. Recreate: Run your test script with a permanent connection. Restart postgresql for whatever reason. Enjoy this nice "NOTICE on 06-11 18:58 with response pg_query_params() [function.pg-query-params]: Cannot set connection to blocking mode". Also note: Don't forget to clear your browser cache afterward, or else your going to keep getting this message when you refresh a page ( F5 ). Making it worse then it is. Previous Comments: ------------------------------------------------------------------------ [2008-08-21 07:41:16] igor dot kotsarev at gloru dot net Same problem on PHP 5.26 ------------------------------------------------------------------------ [2007-11-19 21:18:40] ctrix at hotmail dot com Same problem here with PHP 5.2.0. It's easily reproduceable: simply start a persistent connection, then restart postgres. That message will appear. ------------------------------------------------------------------------ [2005-07-14 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2005-07-06 13:06:59] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2005-04-11 09:28:11] exaton at free dot fr I believe I might be experiencing something similar. Setup is PHP 5.0.4 on Apache 2.0.53 under WinXP SP2. I've just upgraded to PG 8.0.2. With PG 8.0.1, I had to use persistent connections to my (also local) database, otherwise the connection time was absolutely prohibitive. The PG team have apparently solved this issue, so I've dropped persistence as it was cluttering up my system unnecessarily. So now with PG 8.0.2, I'm getting "PHP Notice: Unknown: Cannot set connection to blocking mode in Unknown on line 0" at the end of PHP output, _sporadically_. Not systematically, rather when the page hasn't been reloaded in a little while (3-4 minutes can suffice). It's not messing up the page apart from the notice output ; the rest of the SQL in my scripts works just fine. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31411 -- Edit this bug report at http://bugs.php.net/?id=31411&edit=1
