php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #29501 php Core Dumps randomly and kills mySQL
Submitted: 2004-08-03 07:18 UTC Modified: 2004-12-21 07:42 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: adams at mars-project dot com Assigned:
Status: No Feedback Package: MySQL related
PHP Version: 4.3.7 OS: FreeBSD 4.10
Private report: No CVE-ID: None
View Developer Edit
 [2004-08-03 07:18 UTC] adams at mars-project dot com 
Description:
------------
We have a on-line game in production, it is a online text based stratagy game. Our tick file that runs every 5 minutes has a php core dump very randomly and at that exact same time mySQL drops its connection. 

The odd thing is that if you just cruise the page. It will never show this behavior.

I would have to check with my team members if they are ok with giving you the cod but it is 100K+.

The funny thing is the code will run, about 5% of it then just drop. Every time when that error occurs but it occurs so randomly we have not found a reason yet.

We only have 5 test players so its not like we are overloading the system.

Reproduce code:
---------------
As per above.

Expected result:
----------------
No core dump. Nor mysql connection drops.

Actual result:
--------------
Very random and not reproduceable core dumps.

example of my logs both php and mysql crash at the same time but only php core dumps.

System Error Log.
Aug  2 18:51:00 game /kernel: pid 6679 (php), uid 0: exited on signal 10 (core dumped)
Aug  2 19:32:00 game /kernel: pid 6956 (php), uid 0: exited on signal 10 (core dumped)
Aug  2 20:10:00 game /kernel: pid 7213 (php), uid 0: exited on signal 10 (core dumped)
Aug  2 20:30:01 game /kernel: pid 7345 (php), uid 0: exited on signal 10 (core dumped)
Aug  2 21:04:00 game /kernel: pid 7574 (php), uid 0: exited on signal 10 (core dumped)
Aug  2 21:31:00 game /kernel: pid 7756 (php), uid 0: exited on signal 10 (core dumped)
Aug  2 22:07:00 game /kernel: pid 7998 (php), uid 0: exited on signal 10 (core dumped)
Aug  2 22:20:01 game /kernel: pid 8085 (php), uid 0: exited on signal 10 (core dumped)
Aug  2 22:58:00 game /kernel: pid 8396 (php), uid 0: exited on signal 10 (core dumped)

MYSQL Error Log.
040802 18:51:00  Aborted connection 4381 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)
040802 19:32:00  Aborted connection 4437 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)
040802 20:10:00  Aborted connection 4475 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)
040802 20:30:01  Aborted connection 4511 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)
040802 21:04:00  Aborted connection 4549 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)
040802 21:31:00  Aborted connection 4665 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)
040802 22:07:00  Aborted connection 5115 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)
040802 22:20:01  Aborted connection 5254 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)
040802 22:58:00  Aborted connection 5527 to db: 'mars_game_1' user: 'mars' host: `localhost' (Got an error reading communication packets)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-08-03 07:39 UTC] adams at mars-project dot com 
Here is the backtrace.

GNU gdb 4.18 (FreeBSD)
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "i386-unknown-freebsd"...(no debugging symbols found)...
Core was generated by `php'.
Program terminated with signal 10, Bus error.
Reading symbols from /usr/lib/libcrypt.so.2...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/libsablot.so.70...(no debugging symbols found)...done.
Reading symbols from /usr/lib/libstdc++.so.3...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/libiconv.so.3...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/libexpat.so.5...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/mysql/libmysqlclient.so.12...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/libt1.so.5...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/libfreetype.so.9...(no debugging symbols found)...done.
Reading symbols from /usr/X11R6/lib/libX11.so.6...(no debugging symbols found)...done.
Reading symbols from /usr/X11R6/lib/libXpm.so.4...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/libpng.so.5...(no debugging symbols found)...done.
Reading symbols from /usr/lib/libz.so.2...(no debugging symbols found)...done.
Reading symbols from /usr/local/lib/libjpeg.so.9...(no debugging symbols found)...done.
Reading symbols from /usr/lib/libm.so.2...(no debugging symbols found)...done.
Reading symbols from /usr/lib/libc.so.4...(no debugging symbols found)...done.
Reading symbols from /usr/X11R6/lib/libXThrStub.so.6...(no debugging symbols found)...done.
Reading symbols from /usr/X11R6/lib/libXext.so.6...(no debugging symbols found)...done.
Reading symbols from /usr/libexec/ld-elf.so.1...(no debugging symbols found)...done.
#0  0x812aa01 in pass_two ()
(gdb) bt
#0  0x812aa01 in pass_two ()
#1  0x811c4c6 in compile_file ()
#2  0x811c57b in compile_filename ()
#3  0x8147e91 in execute ()
#4  0x813156a in zend_execute_scripts ()
#5  0x8109a99 in php_execute_script ()
#6  0x814b32e in main ()
#7  0x8063efa in _start ()
 [2004-08-03 09:19 UTC] derick@php.net 
Can you try to run the script from within GDB, and PLEASE add debug information by adding --enable-debug to your PHP configure line.
 [2004-08-06 19:34 UTC] adams at mars-project dot com 
When i recompiled to --enable-debug i nolonger get any core dumps but the file still crashes. 

Not to worry though we are going to wipe the box and reinstall. If we get this again we will notify you.

Thank you for your help, and a really great language. :D
 [2004-12-13 07:40 UTC] sniper@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
 [2004-12-21 07:42 UTC] sniper@php.net 
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 12:01:31 2024 UTC