Bug #79721 [Com]: Insert queries that take more than a day are dropped

From: Date: Sun, 21 Jun 2020 18:55:47 +0000
Subject: Bug #79721 [Com]: Insert queries that take more than a day are dropped
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-227585@lists.php.net to get a copy of this message
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:

> 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?


Previous Comments:
------------------------------------------------------------------------
[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

------------------------------------------------------------------------
[2020-06-21 18:42:55] cbimax at gmail dot com

Sorry, I didn't known PHP 7.2 isn't no longer supported. We used it because
xapian-bindings doesn't run yet on 7.4 on Gentoo.

Do you believe that PHP 7.4 will drop the query if it's longer more than one day?

------------------------------------------------------------------------
[2020-06-21 18:37:07] bugreports2 at gmail dot com

the point is that you need to find out the differences of your builds to write a qualified bug
report, coming out 2020 with a direct jump from a for years outdated version to a another no longer
supported version is a joke

what about fix the root cause?
there is nothing I could imagine taking longer than 24 hours

------------------------------------------------------------------------
[2020-06-21 18:27:58] cbimax at gmail dot com

Sorry, I didn't quite follow you... perhaps 'cos English isn't my native language.

What are you suggesting then? What interface should we use in order to query MariaDB and wait a dull
week for its completeness?

------------------------------------------------------------------------
[2020-06-21 18:23:46] bugreports2 at gmail dot com

what about type mysqlnd in any random source engine given that mysqli can use mysqlnd or libmysql
behind the scenes for a dull decade? i won't even consider to write a Bugreport at all in case
whatever action is not finished within 24 hours - in that timeframe one could move a whole
infrastructure including data to new hardware without any service interruption

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


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


Thread (21 messages)

« previous php.bugs (#227585) next »