Edit report at https://bugs.php.net/bug.php?id=79721&edit=1
ID: 79721
Comment by: cbimax at gmail dot com
Reported by: cbimax at gmail dot com
Summary: Insert queries that take more than a day are dropped
Status: Open
Type: Bug
Package: MySQLi related
Operating System: Linux Gentoo
PHP Version: 7.2.31
Block user comment: N
Private report: N
New Comment:
Thank you nikic at php.net !!
I'll try this ASAP and inform you (when we reprocess the longer query!)
With best regards,
cbi
Previous Comments:
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
[2020-06-21 18:55:47] cbimax at gmail dot com
> what about fix the root cause?
> there is nothing I could imagine taking
> longer than 24 hours
There is nothing to fix from this side. A common OLAP index caché of 25 years take a few days
to compute.
If you can't imagine it, well, that another issue.
I'll try to answer again: does PHP 7.4 drop the query if its longer than a day?
------------------------------------------------------------------------
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