From:             adams at mars-project dot com
Operating system: FreeBSD 4.10
PHP version:      4.3.7
PHP Bug Type:     MySQL related
Bug description:  php Core Dumps randomly and kills mySQL

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)


-- 
Edit bug report at http://bugs.php.net/?id=29501&edit=1
-- 
Try a CVS snapshot (php4):  http://bugs.php.net/fix.php?id=29501&r=trysnapshot4
Try a CVS snapshot (php5):  http://bugs.php.net/fix.php?id=29501&r=trysnapshot5
Fixed in CVS:               http://bugs.php.net/fix.php?id=29501&r=fixedcvs
Fixed in release:           http://bugs.php.net/fix.php?id=29501&r=alreadyfixed
Need backtrace:             http://bugs.php.net/fix.php?id=29501&r=needtrace
Need Reproduce Script:      http://bugs.php.net/fix.php?id=29501&r=needscript
Try newer version:          http://bugs.php.net/fix.php?id=29501&r=oldversion
Not developer issue:        http://bugs.php.net/fix.php?id=29501&r=support
Expected behavior:          http://bugs.php.net/fix.php?id=29501&r=notwrong
Not enough info:            http://bugs.php.net/fix.php?id=29501&r=notenoughinfo
Submitted twice:            http://bugs.php.net/fix.php?id=29501&r=submittedtwice
register_globals:           http://bugs.php.net/fix.php?id=29501&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29501&r=php3
Daylight Savings:           http://bugs.php.net/fix.php?id=29501&r=dst
IIS Stability:              http://bugs.php.net/fix.php?id=29501&r=isapi
Install GNU Sed:            http://bugs.php.net/fix.php?id=29501&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=29501&r=float

Reply via email to