php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Mon Apr 29 05:01:28 2024 UTC