#36895 [Opn->Csd]: Access Violation and Faulting Application (both Apache & IIS)

ID: 36895 Updated by: jani@php.net Reported By: jsschuetz at knapheide dot com -Status: Open +Status: Closed Bug Type: ODBC related Operating System: server2003/WinXP Pro PHP Version: 5.1.2 New Comment: Since we don't have the backtrace I'm assuming it was crashing in the 3rd party library and not PHP itself. Previous Comments: ------------------------------------------------------------------------ [2006-09-07 14:47:18] jsschuetz at knapheide dot com We were able to solve the problem. It had to do with null terminated strings in the DB2 database on the AS400. There must be an issue with the IBM ODBC driver or something that does not always handle the data/error appropriately and when and error is thrown it crashes PHP and the web server. When we stopped null terminating the data in the table, the problem when away. Hope this helps ------------------------------------------------------------------------ [2006-09-07 13:57:03] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip ------------------------------------------------------------------------ [2006-09-07 13:51:40] karlsonas at mazylis dot lt P.S. I'm on Win2K3, using MySQL 5.0.x ------------------------------------------------------------------------ [2006-09-07 13:49:43] karlsonas at mazylis dot lt Hi, I've tryed several combinations of Apache/PHP and found only one which still generated error, but Apache recovers from crach and continues to work. It's PHP 5.1.1/Apache 2.0.55 Combinations on which Apache crashes without recovering: PHP5.1.4/Apache2.0.58 PHP5.1.6/Apache2.0.59 PHP5.1.1/Apache2.0.59 PHP5.1.6/Apache2.0.55 I have two servers - test and production with exact configuration and code. And strangest thing that I have PHP5.1.4/Apache2.0.58 working without any problems on test server and can't get it crash at all. On production server I have crach after 15-30mins after upgrade. Of course production server is used by 100-200 users... I've tryed to look through acceess/error logs but really can't find what is cousing this crash ... Could You please give me a way to debug that not rising production servers resources use ? I will try to follow instructions on back-trace .. but it's kind a hard on prod server :) Wish me luch :) ------------------------------------------------------------------------ [2006-08-02 10:50:04] matthius at pointbtel dot com I'm fairly certain that I am suffering from this same bug. Though I am not using ODBC, I do however hit MySQL pretty hard. Sadly I'm not equipped to generate a backtrace on this machine. This is a major problem though, I am going to have to roll everything back to PHP4 bacause i can't seem to keep Apache on its feet for more than 15 min as it is. I'm currently running PHP 5.1.4 and I've tried Apache 2.0.53 and 2.2.3. - both die the same way :-( - Matt ------------------------------------------------------------------------ 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/36895 -- Edit this bug report at http://bugs.php.net/?id=36895&edit=1