Bug #53287 [Com]: PDO 5 Byte write to a broken pipe when forked
Edit report at https://bugs.php.net/bug.php?id=53287&edit=1
ID: 53287
Comment by: dragomir dot enachi dot qs at gmail dot com
Reported by: bryan dot tong at gigenet dot com
Summary: PDO 5 Byte write to a broken pipe when forked
Status: Not a bug
Type: Bug
Package: PDO related
Operating System: CentOS 5.5 x86-64
PHP Version: 5.3SVN-2010-11-10 (snap)
Assigned To: mysql
Block user comment: N
Private report: N
New Comment:
while using php7, restarting mysql service brings the error
disabling mysql persistent connections fixes the problem
Previous Comments:
------------------------------------------------------------------------
[2013-09-20 03:25:36] bryan at esited dot com
Hello,
I wanted to note that a common mysql configuration error will cause this issue.
Try changing the following.
wait_timeout=60
to
wait_timeout=3600
This is located in the /etc/mysql/my.cnf
Basically the wait_timeout value should equal that of client_max_read_timeout in
NGINX.
Hopefully this will help someone else correct the issue.
Thanks
------------------------------------------------------------------------
[2012-03-06 01:17:11] johannes@php.net
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php
------------------------------------------------------------------------
[2011-01-31 10:42:56] bryan dot tong at gigenet dot com
Though it can really make parsing the output a pain when there are multiple versions of mysqlnd
floating about.
------------------------------------------------------------------------
[2011-01-31 10:27:42] uw@php.net
This does not smell like an error rather more like mysqlnd being more verbose. No bug, a feature,
I'd say.
------------------------------------------------------------------------
[2010-12-05 21:23:46] seza at paradoxal dot org
I have the same error message with php.5.3.3 (send of 5 bytes failed with errno=32 Broken pipe) but
in a
different context more simply to reproduce :
I have a simple website (no fork or stuff like that). It make persistent connection with pdo to
mysql
(mysqlnd). The errors are raised when the mysql is server is restarted.
When mysql server is off error message are mysql server is gone away. No problem with that but once
the
mysql server is restarted and during 15 minutes I have sometimes this error message (send of 5 bytes
failed with errno=32 Broken pipe).
Certainly a reuse of a cached connection to mysql before it was restarted.
PS : I use mysql_sock connection (mysql:unix_socket=/var/run/mysqld/mysqld.sock)
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=53287
--
Edit this bug report at https://bugs.php.net/bug.php?id=53287&edit=1
Thread (10 messages)