dreeves Posted October 9, 2009 Report Posted October 9, 2009 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. Quote
Ric Posted October 9, 2009 Report Posted October 9, 2009 Can you please try 5.3-Nano? This includes all the latest components. All the bestRic Quote
dreeves Posted October 12, 2009 Author Report Posted October 12, 2009 Can you please try 5.3-Nano? This includes all the latest components. All the bestRic 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. Quote
Ric Posted October 12, 2009 Report Posted October 12, 2009 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\wwwCopy 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\dataCopy 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 bestRic Quote
dreeves Posted October 13, 2009 Author Report Posted October 13, 2009 Thanks. That worked. Now I'm dealing with html/form/php code issues. It never seems to end. Quote
Ric Posted October 13, 2009 Report Posted October 13, 2009 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 bestRic Quote
dreeves Posted October 14, 2009 Author Report Posted October 14, 2009 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. Quote
Ric Posted October 14, 2009 Report Posted October 14, 2009 A quick test to confirm its eAccelerator; before running script disable eAccelerator In Apanel under Plugin Manager click link eAccelerator cPanelThis opens a new page, under actions click disable.Run your script All the bestRic Quote
r-a-y Posted October 15, 2009 Report Posted October 15, 2009 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? Quote
Ric Posted October 15, 2009 Report Posted October 15, 2009 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:<?phpprint "fred";mysql_connect('127.0.0.1', 'root', 'root');mysql_close();?> You require an handle to close:<?phpprint "fred";$a=mysql_connect('127.0.0.1', 'root', 'root');mysql_close($a);?> “Fix should be part of 5.3.1” All the bestRic Quote
Twinky Posted March 20 Report Posted March 20 On 10/15/2009 at 6:47 AM, Ric said: 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 I'm using US 7.0.1 Orion with php 5.3.6.. this bug is not fixed at all from 5.3.1 I've noticed php crashes via EAACCELERATOR many times per day and it's always from my phpbb forum. I've commented out eaccelerator in php.ini and restarted apache so that i can carry on without it. It's been too much of a pain lately with apache crashing daily. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.