Bug #78690 [NEW]: Database persistent connection leaks with ZTS and Event, Worker MPMs

From: Date: Fri, 18 Oct 2019 13:09:25 +0000
Subject: Bug #78690 [NEW]: Database persistent connection leaks with ZTS and Event, Worker MPMs
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-223256@lists.php.net to get a copy of this message
From:             coladict at gmail dot com
Operating system: Linux
PHP version:      7.2.23
Package:          Apache2 related
Bug Type:         Bug
Bug description:Database persistent connection leaks with ZTS and Event, Worker MPMs

Description:
------------
When using the Prefork MPM, persistent MySQLi connections (for example,
but not limited to MySQLi) are reused.
When using other MPMs, they are not. For traced it to:

ext/mysqli/mysqli_nonapi.c: 166

The EG(persistent_list) macro always returns a new list. This results in
reaching the MySQL server's connection limit (default at 151) with
having all of them waiting in sleep.




-- 
Edit bug report at https://bugs.php.net/bug.php?id=78690&edit=1
-- 
Fix committed:                    https://bugs.php.net/fix.php?id=78690&r=fixed
Fixed in release:                 https://bugs.php.net/fix.php?id=78690&r=alreadyfixed
Need backtrace:                   https://bugs.php.net/fix.php?id=78690&r=needtrace
Need Reproduce Script:            https://bugs.php.net/fix.php?id=78690&r=needscript
Try newer version:                https://bugs.php.net/fix.php?id=78690&r=oldversion
Not developer issue:              https://bugs.php.net/fix.php?id=78690&r=support
Expected behavior:                https://bugs.php.net/fix.php?id=78690&r=notwrong
Not enough info:                  https://bugs.php.net/fix.php?id=78690&r=notenoughinfo
Submitted twice:                  https://bugs.php.net/fix.php?id=78690&r=submittedtwice
register_globals:                 https://bugs.php.net/fix.php?id=78690&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=78690&r=phptooold
Daylight Savings:                 https://bugs.php.net/fix.php?id=78690&r=dst
IIS Stability:                    https://bugs.php.net/fix.php?id=78690&r=isapi
Install GNU Sed:                  https://bugs.php.net/fix.php?id=78690&r=gnused
Floating point limitations:       https://bugs.php.net/fix.php?id=78690&r=float
No Zend Extensions:               https://bugs.php.net/fix.php?id=78690&r=nozend
MySQL Configuration Error:        https://bugs.php.net/fix.php?id=78690&r=mysqlcfg


Thread (1 message)

  • coladict at gmail dot com
« previous php.bugs (#223256) next »