ID: 39929 Comment by: kabot at go2 dot pl Reported By: aloucks at cofront dot net Status: No Feedback Bug Type: PDO related Operating System: Linux 2.4.31 PHP Version: 5.2.0 Assigned To: wez New Comment:
Bug still exists, linux 2.6.18, php 5.2.11 Bigger problem is with PDO::ERRMODE_EXCEPTION becouse with this connection could not be open (with other ERRMODE warning is produced but connection is ok). Previous Comments: ------------------------------------------------------------------------ [2009-05-03 01:00:02] 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". ------------------------------------------------------------------------ [2009-04-25 14:41:56] [email protected] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ..and update the version field if bug still exists, otherwise close it. ------------------------------------------------------------------------ [2008-07-21 18:16:31] aloucks at cofront dot net It's been over a year and a half.. Is this bug going to be addressed? ------------------------------------------------------------------------ [2007-12-14 19:28:47] mfaust at usinternet dot com I get the same error running PHP 5.2.4, Windows XP SP2, SQL Express 2005, and IIS 5.1. I normally don't use the persistent connection option but it temporarily fixes another issue that I have .Not sure if it's related but occasionally I get an error message in the event viewer stating Out of process application '/LM/W3SVC/1/Root/ticket' terminated unexpectedly. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. I create a new connection using $this->db_conn = new PDO('mssql:' . $this->conn_str, $this->username, $this->password); but after sometime I get the error above and then my connect statement above no longer takes milliseconds but now takes about 2-3 seconds and get: Event Type: Information Event Source: MSSQL$SQLEXPRESS Event Category: (2) Event ID: 17137 Date: 12/14/2007 Time: 1:01:11 PM User: N/A Computer: my_pcname Description: Starting up database 'my_dbname'. in the event viewer every time I create a new PDO connection. The only way to solve this is to run the above connect statement but add the array(PDO::ATTR_PERSISTENT => true) parameter. It will give me a warning but the next time I run the connect statement without the persistent option it only takes a few milliseconds to create the connection and no events are logged in the event viewer. The errors seem to happen after about 15 minutes or so after the last db connection was closed. ------------------------------------------------------------------------ [2007-07-13 16:24:29] paulius at yahoo dot com I am experiencing the same issue. Submitted a bug report here: http://pecl.php.net/bugs/bug.php?id=11603 ------------------------------------------------------------------------ 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/39929 -- Edit this bug report at http://bugs.php.net/?id=39929&edit=1
