Bug #53287 [Opn->Asn]: PDO 5 Byte write to a broken pipe when forked

From: Date: Wed, 10 Nov 2010 03:11:02 +0000
Subject: Bug #53287 [Opn->Asn]: PDO 5 Byte write to a broken pipe when forked
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-155907@lists.php.net to get a copy of this message
Edit report at http://bugs.php.net/bug.php?id=53287&edit=1

 ID:                 53287
 Updated by:         aharvey@php.net
 Reported by:        bryan dot tong at gigenet dot com
 Summary:            PDO 5 Byte write to a broken pipe when forked
-Status:             Open
+Status:             Assigned
 Type:               Bug
 Package:            PDO related
 Operating System:   CentOS 5.5 x86-64
 PHP Version:        5.3SVN-2010-11-10 (snap)
-Assigned To:        
+Assigned To:        mysql
 Block user comment: N



Previous Comments:
------------------------------------------------------------------------
[2010-11-10 03:21:00] bryan dot tong at gigenet dot com

Description:
------------
When switching from PHP 5.1.6 to PHP 5.3.3 the following notice has
begun to show up in our scripts.

PDO::__construct(): send of 5 bytes failed with errno=32 Broken pipe

We are running a daemon and the forked children throw this error on the
PDO construct that is used to refresh the class.

The error changes depending on whether a persistent connection is set or
not.

When persistent is on the above error is produced. Without persistent
connection applied the error is thrown when the class is destructed.

Example: $pdo = null;
send of 5 bytes failed with errno=32 Broken pipe

We have confirmed this to be apparent in PHP 5.3.3 and the trunk build.
I was unable to test on 5.2, but I was able to confirm this bug does not
occur on 5.1.6

I have tried wrapping ob functions around the calls in case the broken
pipe happened to be stdout but I think it is the mysql socket that is in
question. On that same note, switching mysql to connect via tcp did not
help.

From searching I found a site that threw this error but no discussions
of it.

Let me know any additional information that is needed.

Test script:
---------------
// without persistance
public static function shutdown(){
	$base = Base::getBase();
	$base->db = null;
	self::$base = false;
}

// with persistance
$this->pdo = new PDO(
	$dsn,
	$user,
	$pass,
	array(
		PDO::ATTR_ERRMODE	=>	PDO::ERRMODE_EXCEPTION,
		PDO::ATTR_PERSISTENT=>	true
	)
);

Expected result:
----------------
The PDO class should startup quietly when persistent connections are
enabled and destruct quietly when persistent connections are disabled.

Actual result:
--------------
PDO::__construct(): send of 5 bytes failed with errno=32 Broken pipe
with persistent connections.

Base::shutdown(): send of 5 bytes failed with errno=32 Broken pipe
without persistent connections.

I believe this problem is only related to forked processes. I have
confirmed the standard page serving to not throw this.






------------------------------------------------------------------------



-- 
Edit this bug report at http://bugs.php.net/bug.php?id=53287&edit=1


Thread (10 messages)

« previous php.bugs (#155907) next »