php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #5335 Aborted pconnects to MySQL with PHP 4.0.1pl1
Submitted: 2000-07-03 03:13 UTC Modified: 2000-08-18 19:01 UTC
From: augustz at bigfoot dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 4..0.1pl2 OS: Redhat 6.1
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: augustz at bigfoot dot com
New email:
PHP Version: OS:

 

 [2000-07-03 03:13 UTC] augustz at bigfoot dot com 
Going to file this one as a bug as an inquiry to Sasha on the MySQL side of this hints at flakiness with pconnects in PHP 4.

We're running a PHP 4.0.1pl1/MySQL combination on three reasonable sized
dedicated servers (Dual PIII/1G RAM/Redhat/Raid 5). On the backend is the
database server, with two frontend web servers. MySQL works like a champ
unless I enable persistent connections, in which case I get a ton of the
following:

000701 19:23:20  Aborted connection 295169 to db: 'cashwars' user: 'root'
host: `216.205.94.xx' (Got an error reading communication packets)

MySQL quickly dies and I'm stuck doing a restart.  Switching back solves the problem. This
is with MySQL 3.23.18-alpha 

Running PHP 4.0.1pl1 as an Apache module, server is 2.2.13-0.13smp. 

./configure' '--disable-xml' '--without-gdb' '--disable-rpath' '--with-mysql' '--with-apxs=/usr/sbin/apxs' '--disable-debug' '--with-config-file-path=/etc/httpd/conf'

Running with connects solves the problem, but we do well over 250 requests/second, and the connection setup/teardown is no fun at that level. Hope to see this fixed or a workaround out soon...

August

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-07-27 20:27 UTC] waldschrott@php.net 
Please verify that it?s still happening using the latest version from CVS or snaps.php.net.
 [2000-08-18 19:01 UTC] sniper@php.net 
No feedback from user.

--Jani
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue Jun 03 02:01:26 2025 UTC