Bug #74223 [Csd]: db2 table locks during commit after hitting max_execution_time

Edit report at https://bugs.php.net/bug.php?id=74223&edit=1 ID: 74223 Updated by: cmb@php.net Reported by: giacomo dot fontanella at carige dot it Summary: db2 table locks during commit after hitting max_execution_time Status: Closed Type: Bug Package: ODBC related Operating System: windows server 2008 R2 PHP Version: 5.6.30 Assigned To: cmb Block user comment: N Private report: N New Comment: Great! Thanks for checking. Previous Comments: ------------------------------------------------------------------------ [2020-10-12 12:44:51] giacomo dot fontanella at carige dot it I've upgraded my environment, abandoning the unsupported php release; starting from PHP ver. 7.1 the bug seems resolved. Here's my latest working environment: WEBSERVER OS: Windows server 2008 R2 webserver: Apache 2.4.41, 32bit VC15 compiler PHP: 7.3.8, 32 bit MSVC15 compiler DBSERVER OS: Windows server 2008 R2 database: IBM DB2 9.7.8 ------------------------------------------------------------------------ [2020-10-11 04:22:14] php-bugs at lists dot php dot net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. ------------------------------------------------------------------------ [2020-09-29 15:17:46] cmb@php.net Can anyone still reproduce this problem with any of the actively supported PHP versions[1]? [1] <https://www.php.net/supported-versions.php> ------------------------------------------------------------------------ [2018-01-05 13:05:32] nikic@php.net I'd also be interested in knowing if this issue still reproduces on PHP 7.1. I have no familiarity with ODBC or DB2, but depending on the specific reasons of why this happens, the timeout handling changes in PHP 7.1 may have fixed this already. Timeouts will no longer interrupt internal function calls -- either it will wait until the call is finished, or it will kill the process entirely. ------------------------------------------------------------------------ [2018-01-05 13:00:28] spam2 at rhsoft dot net > with different versions of PHP from 5.3 to 5.6 but in Linux server what about try and report back with some *supported* version of PHP (7.1.x/7.2.x) especially for a niche like db2 stuff not that widely used combined with PHP ------------------------------------------------------------------------ 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=74223 -- Edit this bug report at https://bugs.php.net/bug.php?id=74223&edit=1