Edit report at https://bugs.php.net/bug.php?id=79721&edit=1
ID: 79721
Updated by: nikic@php.net
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:
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.
Previous Comments:
------------------------------------------------------------------------
[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?
------------------------------------------------------------------------
[2020-06-21 18:50:14] bugreports2 at gmail dot com
https://www.php.net/supported-versions.php
php 7.2 is out of support for 7 months now, anyways fix the root cause of a simple query running for
days
------------------------------------------------------------------------
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