Child process exited with status 3221225477

[dreeves]

I've seen this problem all over the Internet, but since I'm using Uniform Server, I was hoping to get a solution that was catered to US. Here are the details:

 

Apache/2.2.13 (Win32) mod_ssl/2.2.13 OpenSSL/0.9.8k PHP/5.3.0 DAV/2

 

I am entering information into a form, which then gets put on to a mysql database. When I submit the form, the page displays "The connection to the server was reset while the page was loading." The data gets entered in the database successfully, however. The error log displays:

 

- [Fri Oct 09 16:42:05 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.

- [Fri Oct 09 16:42:06 2009] [notice] Apache/2.2.13 (Win32) mod_ssl/2.2.13 OpenSSL/0.9.8k PHP/5.3.0 DAV/2 configured -- resuming normal operations

- [Fri Oct 09 16:42:06 2009] [notice] Server built: Aug 6 2009 15:50:50

- [Fri Oct 09 16:42:06 2009] [notice] Parent: Created child process 3456

- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Child process is running

- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Acquired the start mutex.

- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Starting 250 worker threads.

- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Starting thread to listen on port 443.

- [Fri Oct 09 16:42:07 2009] [notice] Child 3456: Starting thread to listen on port 80.

 

One solution I've tried was to copy the libmysql.dll file from the PHP installation folder to the system32 folder. That did not work. Since I downloaded this just a few days ago, I didn't think that there were any updates required.

 

Let me know if you would like me to include the php code, in case that will help.

[Ric]

Can you please try 5.3-Nano? This includes all the latest components.

 

All the best

Ric

[dreeves]

Can you please try 5.3-Nano? This includes all the latest components.

 

All the best

Ric

 

Thanks! Just a quick question though about updating to the new version,

 

Do I need to uninstall the old version?

I have 5.1 directly on C:// and when installing 5.3 it wants to replace some files.

What is the best way to update to 5.3 without losing any work I've done in 5.1?

 

Apache/php/mysql is new to me, so I'm not 100% on how it all works together.

 

Any guidance would be appreciated.

[Ric]

I never recommend installing over an older version.

 

You currently have C:\\UniServer rename the folder to give C:\\UniServer1 (It can have any name must not include spaces.)

 

Now extract 5.3 to your C drive again this will give C:\\UniServer rename this to C:\\UniServer2

 

Assuming you have not changed any configuration files, the quickest way to up date without losing any work:

 

The following updates your server root folder:

Delete folder C:\\UniServer2\www

Copy folder C:\\UniServer1\www to C:\\UniServer2

 

If you have created databases copy these to the new server:

Go to folder: UniServer\usr1\local\mysql\data

Copy all new folders (not mysql or phpmyadmin)

To folder: UniServer\usr2\local\mysql\data

 

Run UniServer2 and check your website works.

You can delete folder UniServer1 generally it’s a good idea to keep this as a backup.

 

All the best

Ric

[dreeves]

Thanks. That worked.

 

Now I'm dealing with html/form/php code issues. It never seems to end.

[Ric]

Ace, thanks for the feedback. Uniform Server 5.3 is looking like a stable core.

Any one of an infinite number of permutations can kill.

 

I do understand “html/form/php code issues” depends on your outlook either a pain or an exciting chase to resolve.

 

All the best

Ric

[dreeves]

When I submit form.html, it sends the info to insert.php and successfully enters the info into a mysql database. However, I get "Problem loading Page: The connection to the server was reset while the page was loading." I have to restart the servers inorder for apanel/phpMyAdmin to work again.

 

From the error log, I think the problem occurs when attempting to close the connection to the mysql database. Here is the error:

 

- [Wed Oct 14 09:39:38 2009- ] [notice] EACCELERATOR(3332): PHP crashed on opline 99 of mysql_close() at C:\UniServer\www\insert.php:33

- [Wed Oct 14 09:39:38 2009] [crit] Parent: child process exited with status 3 -- Aborting.

- [Wed Oct 14 09:39:59 2009] [notice] Apache/2.2.14 (Win32) mod_ssl/2.2.14 OpenSSL/0.9.8k PHP/5.3.0 DAV/2 configured -- resuming normal operations

- [Wed Oct 14 09:39:59 2009] [notice] Server built: Sep 28 2009 22:41:08

- [Wed Oct 14 09:39:59 2009] [notice] Parent: Created child process 3024

- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Child process is running

- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Acquired the start mutex.

- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Starting 250 worker threads.

- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Starting thread to listen on port 443.

- [Wed Oct 14 09:40:00 2009] [notice] Child 3024: Starting thread to listen on port 80.

 

I've numbered the lines of code for you and eliminated some things for convenience. Does the "33" mean that the problem is on line 33 of insert.php? Is it something to do with EACCELERATOR?

 

(29) $query="INSERT INTO reimbursements (column_name1, column_name2) VALUES (value1, value2)";

(30) mysql_query($query) or die("reimbursements insert failed - " . mysql_errno() . ": " .

(31) mysql_error());

 

(33)mysql_close();

 

I'm happy that data finally gets entered, but Apache shouldn't crash every time I submit this form. Thanks for being so helpful.

[Ric]

A quick test to confirm its eAccelerator; before running script disable eAccelerator

 

In Apanel under Plugin Manager click link eAccelerator cPanel

This opens a new page, under actions click disable.

Run your script

 

All the best

Ric

[r-a-y]

I'm getting identical errors as dreeves; I've upgraded to v5.3 and have disabled eAccelerator like Ric stated above.

 

I'm getting this in the error logs:

 

[Wed Oct 14 20:26:01 2009
] [notice] EACCELERATOR(2732): PHP crashed on opline 33 of mysql_close() at C:\UniServer\www\wp-content\plugins\bp-chat\chat\lib\class\CustomAJAXChat.php:170

[Wed Oct 14 20:26:01 2009] [crit] Parent: child process exited with status 3 -- Aborting.

 

It's also failing on mysql_close() like dreeves.

 

Any other ideas?

[Ric]

This is not an issue with eAccelerator it’s a bug in PHP 5.3.0

 

Check this bug report:

http://bugs.php.net/bug.php?id=48754

 

Confirmed this crashes:

<?php

print "fred";

mysql_connect('127.0.0.1', 'root', 'root');

mysql_close();

?>

 

You require an handle to close:

<?php

print "fred";

$a=mysql_connect('127.0.0.1', 'root', 'root');

mysql_close($a);

?>

 

“Fix should be part of 5.3.1”

 

All the best

Ric

[r-a-y]

Thanks Ric!