Edit report at https://bugs.php.net/bug.php?id=79721&edit=1
ID: 79721
Updated by: dharman@php.net
Reported by: cbimax at gmail dot com
Summary: Insert queries that take more than a day are dropped
-Status: Open
+Status: Not a bug
Type: Bug
Package: MySQLi related
Operating System: Linux Gentoo
PHP Version: 7.2.31
-Assigned To:
+Assigned To: dharman
Block user comment: N
Private report: N
New Comment:
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
Previous Comments:
------------------------------------------------------------------------
[2020-06-21 19:17:05] cbimax at gmail dot com
Thank you nikic at php.net !!
I'll try this ASAP and inform you (when we reprocess the longer query!)
With best regards,
cbi
------------------------------------------------------------------------
[2020-06-21 19:10:13] nikic@php.net
There is a mysqlnd.net_read_timeout option which defaults to 86400 (aka one day). Assuming you left
this at the default, that should be the culprit.
If you did not change any php.ini settings, then the reason why this timeout may only be taking
effect now might indeed be a switch from libmysql to mysqlnd, as suggested by the rude person.
So, adjusting this ini setting should resolve your issue.
------------------------------------------------------------------------
[2020-06-21 19:08:27] bugreports2 at gmail dot com
what do you expect? you jump from php5 to 7.2,skip 7.0 and 7.1 while you can't even say which
database driver your old build used nor can you provide a reproducer
in a proper setup with error_reporting E_ALL you would get warnings in your log fwiw
------------------------------------------------------------------------
[2020-06-21 19:03:06] cbimax at gmail dot com
Well, something has changed without any doubt... people politeness has dropped as valid queries!
------------------------------------------------------------------------
[2020-06-21 18:59:11] bugreports2 at gmail dot com
nothing takes a day, however try it out! switch php builds takes the blink of an eye and when you
are at it try out 7.0 and 7.1 too and especially find out if your precious binary used libmysql
instead of mysqlnd
------------------------------------------------------------------------
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=79721
--
Edit this bug report at https://bugs.php.net/bug.php?id=79721&edit=1