PHP :: Bug #29501 :: php Core Dumps randomly and kills mySQL

[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)

[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.

Patches

Pull Requests

History

	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2023 The PHP Group All rights reserved.	Last updated: Wed Sep 27 11:01:25 2023 UTC