#16272 [Com]: SegFault in MySQL

ID: 16272 Comment by: odysseus@soa.co.nz Reported By: jweiss@greyzone.com Status: No Feedback Bug Type: MySQL related Operating System: Linux 2.4.x PHP Version: 4.1.2 New Comment: Getting the same problems as the last poster - lots of SIGSEGVs then the apache processes seem to hang - can't get any data out of them. Previous Comments: ------------------------------------------------------------------------ [2002-08-12 06:37:18] bartvb@iae.nl Please change the status of this bug.. This bug is really bothering me, all my users are affected by this bug because it gives them empty pages :\ Here's a snippet from my errorlog: [Mon Aug 12 12:01:16 2002] [notice] child pid 20887 exit signal Segmentation fault (11) [Mon Aug 12 12:03:09 2002] [notice] child pid 20929 exit signal Segmentation fault (11) [Mon Aug 12 12:03:28 2002] [notice] child pid 20938 exit signal Segmentation fault (11) [Mon Aug 12 12:05:09 2002] [notice] child pid 20562 exit signal Segmentation fault (11) [Mon Aug 12 12:05:18 2002] [notice] child pid 21044 exit signal Segmentation fault (11) [Mon Aug 12 12:06:30 2002] [notice] child pid 20925 exit signal Segmentation fault (11) [Mon Aug 12 12:07:07 2002] [notice] child pid 21078 exit signal Segmentation fault (11) [Mon Aug 12 12:07:13 2002] [notice] child pid 21086 exit signal Segmentation fault (11) [Mon Aug 12 12:07:17 2002] [notice] child pid 20559 exit signal Segmentation fault (11) [Mon Aug 12 12:07:29 2002] [notice] child pid 21091 exit signal Segmentation fault (11) [Mon Aug 12 12:07:37 2002] [notice] child pid 21094 exit signal Segmentation fault (11) [Mon Aug 12 12:10:19 2002] [notice] child pid 21237 exit signal Segmentation fault (11) [Mon Aug 12 12:10:26 2002] [notice] child pid 21240 exit signal Segmentation fault (11) [Mon Aug 12 12:10:57 2002] [notice] child pid 21249 exit signal Segmentation fault (11) Mainly using phpBB 2.0.1 on that site. Furthermore I'm using PHP version 4.2.2 on Linux 2.4.18-5, Apache/1.3.26 with MySQL 3.23.47. See http://www.bokt.nl/klad/info.php for phpinfo(). ------------------------------------------------------------------------ [2002-08-07 13:42:16] db@dbinteractive.com I don't know if my uneducated comment will really contribute to the understanding of this bug, but I'll offer it up anyway: I encountered the same problem with the exact same Apache/PHP/MySQL setup as b0nfire@fdns.net. When I changed the connection type from persistent (using mysql_pconnect) to a regular MySQL connection (using mysql_connect), the problem went away--the script worked fine and no further segfaults appeared in the http error log. If others find the same results, then it may be safe to assume the problem is limited to persistent connections only. ------------------------------------------------------------------------ [2002-07-26 01:00:10] php-bugs@lists.php.net No feedback was provided for this bug for over a month, 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". ------------------------------------------------------------------------ [2002-06-25 13:27:51] sniper@php.net Please try this snapshot: http://snaps.php.net/php4-latest.tar.gz ------------------------------------------------------------------------ [2002-06-25 08:27:32] b0nfire@fdns.net We are experiencing similar problems on our slack 8.0 box: apache 1.3.26 php 4.1.2 mysql 3.23.49a We initially saw the follow apache logs: [Tue Jun 25 05:44:31 2002] [notice] child pid 4503 exit signal Segmentation fault (11) [Tue Jun 25 06:11:08 2002] [notice] child pid 17668 exit signal Segmentation fault (11) Which similar logs are generated with a pre 1.3.26 apache DOS attack script... but since 1.3.26 is apparently patched this should not be a factor.. We also have a small built in wrapper that reports any connection failure attempts.. We have not seen any in months and since upgrading php we have started to see them more frequently... One note though is that all of our crashes thusfar have all occurred on 1 peticular script that processes file uploads. This script has worked flawlessly for many months.. Sorry no backtrace so far.. I'll try and grab one.. ------------------------------------------------------------------------ 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/16272 -- Edit this bug report at http://bugs.php.net/?id=16272&edit=1