ID: 26771 Comment by: super_freax at hotmail dot com Reported By: info at tphnet dot com Status: Verified Bug Type: Apache2 related Operating System: * (ZTS only!) PHP Version: 4CVS, 5CVS (2004-02-25) New Comment:
It says in the PHP-manual for child operations that : This means that for every child that opened a persistent connection will have its own open persistent connection to the server. For example, if you had 20 different child processes that ran a script that made a persistent connection to your SQL server, you'd have 20 different connections to the SQL server, one from each child. Note, however, that this can have some drawbacks if you are using a database with connection limits that are exceeded by persistent child connections. If your database has a limit of 16 simultaneous connections, and in the course of a busy server session, 17 child threads attempt to connect, one will not be able to. If there are bugs in your scripts which do not allow the connections to shut down (such as infinite loops), the database with only 16 connections may be rapidly swamped ====== So it might be the database that has no more connections left ? My config is : WinXPProSP1 (NTFS Formatted) Apache version 2.0.49 MySQL 4.0.18 with MyODBC 3.51 and winMYSQLadmin 1.4 PHP 4.3.6 with Pear 1.3.1 ,Smarty 2.5.0 ,Zend Opt. 2.5.0 , Dbg 2.16.3, TCL 8.4.5 with TK 8.4 and Vtcl 1.6.0 Previous Comments: ------------------------------------------------------------------------ [2004-06-29 23:51:40] ryders at gmail dot com Hey... I have the same problem here (same error) [notice] Parent: Created child process 2104 [notice] Child 2104: Child process is running [notice] Child 2104: Acquired the start mutex. [notice] Child 2104: Starting 250 worker threads. [notice] Parent: child process exited with status 128 -- Restarting. But it has nothing to do with the register_tick_funtions here. I have almost the same config as some of you (XP/SP1, Apache2.0.49, PHP 4.3.7, mysql 4.0.18, php as a module - php4appache2.dll). I've also try it on apache 1.3.31 (Win+Unix) and php 4.3.3 (W+nix as well)... I'm so lost... if anyone ever find something let me know PLEASE!! ; ) Good luck everyone! sebastian ------------------------------------------------------------------------ [2004-06-28 16:35:22] joker at localfoo dot info This script crashes (every environment I gave a try) under WinXP/SP1 with the following packages: Apache 2.0.49 PHP 4.3.7 (with or without ZendOptimizer 2.5.1) PHP 4.3.8-dev (win32-STABLE-200406272030) PHP 5.0.0-dev (win32-200406271830) (hope this information is somewhat new here) The crash never occurs in CGI mode, only using the module ------------------------------------------------------------------------ [2004-04-19 23:41:51] banterbubba at yahoo dot com Any resolution? I was thinking that it might be Apache/PHP on Windows. I have another developer who runs the same config as I do, but on Linux and has no problems. Is is a Windows conflict? We may just switch the OS... ------------------------------------------------------------------------ [2004-04-18 13:07:22] cpuidle at gmx dot de Similiar Issue, but not register_ticks-related: [Sun Apr 18 12:56:48 2004] [notice] Parent: child process exited with status 128 -- Restarting. [Sun Apr 18 12:56:49 2004] [notice] Parent: Created child process 3824 [Sun Apr 18 12:56:49 2004] [notice] Child 3824: Child process is running [Sun Apr 18 12:56:49 2004] [notice] Child 3824: Acquired the start mutex. [Sun Apr 18 12:56:49 2004] [notice] Child 3824: Starting 64 worker threads. Happening e.h. with osCommerce and custom apps. Not always reproducible... ------------------------------------------------------------------------ [2004-01-02 19:23:33] info at tphnet dot com Description: ------------ While searching the bug database I found some similar problems, but all were suspended. I wasn't sure if it was useful to reply to one of those (Most recent one: http://bugs.php.net/bug.php?id=26286). Well anyways, here goes: The problem is very simple. I just copy and paste the 'tick' example from the php manual into a new php file an try to execute it on my apache2 server. The apache child process crashes, restarts, crashes, restarts and eventually just stops restarting. When I comment out the line 'register_tick_function', everyting works just fine. Also, when I start the file from the CLI version of PHP it is executed without any problems. I'm using PHP 4.3.4 and Apache 2.0.48 (in conjunction with php4apache2.dll). Reproduce code: --------------- http://nl.php.net/manual/en/control-structures.declare.php See Example 11-1 Actual result: -------------- [Sat Jan 03 01:11:04 2004] [notice] Parent: child process exited with status 3221225477 -- Restarting. [Sat Jan 03 01:11:04 2004] [notice] Parent: Created child process 3036 [Sat Jan 03 01:11:04 2004] [notice] Child 3036: Child process is running [Sat Jan 03 01:11:04 2004] [notice] Child 3036: Acquired the start mutex. [Sat Jan 03 01:11:04 2004] [notice] Child 3036: Starting 250 worker threads. Small snippit from my apache2 error.log. It's filled with the above lines, the status code is the same for every restart. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26771&edit=1
