Bug #51347 [Fbk->Opn]: mysqli_close / connection memory leak

Edit report at http://bugs.php.net/bug.php?id=51347&edit=1 ID: 51347 User updated by: mat999 at gmail dot com Reported by: mat999 at gmail dot com Summary: mysqli_close / connection memory leak -Status: Feedback +Status: Open Type: Bug Package: MySQLi related Operating System: Debian Lenny / Linux PHP Version: 5.3.2 Assigned To: mysql New Comment: Ok tested it on php 5.3.2, sorry had issues getting php to build on my server (some hacks to get other stuff compiled have screwed with libs) Memory consumption after 0 iterations is 637088<br /> Memory consumption after 1000 iterations is 829464<br /> Memory consumption after 2000 iterations is 1021680<br /> Memory consumption after 3000 iterations is 1222080<br /> Memory consumption after 4000 iterations is 1406088<br /> Memory consumption after 5000 iterations is 1622856<br /> Memory consumption after 6000 iterations is 1806856<br /> Memory consumption after 7000 iterations is 1990864<br /> Memory consumption after 8000 iterations is 2174872<br /> Memory consumption after 9000 iterations is 2424448<br /> Memory consumption after 10000 iterations is 2608448<br /> Memory consumption after 11000 iterations is 2792464<br /> Memory consumption after 12000 iterations is 2976472<br /> Memory consumption after 13000 iterations is 3160480<br /> Memory consumption after 14000 iterations is 3344480<br /> Memory consumption after 15000 iterations is 3528496<br /> Memory consumption after 16000 iterations is 3712504<br /> Memory consumption after 17000 iterations is 4027576<br /> Memory consumption after 18000 iterations is 4211640<br /> Memory consumption after 19000 iterations is 4395640<br /> Memory consumption after 20000 iterations is 4579648<br /> Memory consumption after 21000 iterations is 4763656<br /> Memory consumption after 22000 iterations is 4947656<br /> Memory consumption after 23000 iterations is 5131672<br /> Memory consumption after 24000 iterations is 5315680<br /> Memory consumption after 25000 iterations is 5499688<br /> Memory consumption after 26000 iterations is 5683688<br /> Memory consumption after 27000 iterations is 5867704<br /> Memory consumption after 28000 iterations is 6051712<br /> Memory consumption after 29000 iterations is 6235712<br /> Memory consumption after 30000 iterations is 6419720<br /> Memory consumption after 31000 iterations is 6603736<br /> Memory consumption after 32000 iterations is 6787736<br /> Memory consumption after 33000 iterations is 7233888<br /> Memory consumption after 34000 iterations is 7417896<br /> Memory consumption after 35000 iterations is 7601912<br /> Memory consumption after 36000 iterations is 7785912<br /> Memory consumption after 37000 iterations is 7969920<br /> Memory consumption after 38000 iterations is 8153928<br /> Memory consumption after 39000 iterations is 8337928<br /> Memory consumption after 40000 iterations is 8521944<br /> Memory consumption after 41000 iterations is 8705952<br /> Memory consumption after 42000 iterations is 8889952<br /> Memory consumption after 43000 iterations is 9073960<br /> Memory consumption after 44000 iterations is 9257976<br /> Memory consumption after 45000 iterations is 9441984<br /> Memory consumption after 46000 iterations is 9625984<br /> Memory consumption after 47000 iterations is 9809992<br /> Memory consumption after 48000 iterations is 9994008<br /> Memory consumption after 49000 iterations is 10178008<br /> Memory consumption after 50000 iterations is 10362016<br /> Memory consumption after 51000 iterations is 10546024<br /> Memory consumption after 52000 iterations is 10730024<br /> Memory consumption after 53000 iterations is 10914040<br /> Memory consumption after 54000 iterations is 11098048<br /> Memory consumption after 55000 iterations is 11282056<br /> Memory consumption after 56000 iterations is 11466056<br /> Memory consumption after 57000 iterations is 11650072<br /> Memory consumption after 58000 iterations is 11834080<br /> Memory consumption after 59000 iterations is 12018080<br /> Memory consumption after 60000 iterations is 12202088<br /> Memory consumption after 61000 iterations is 12386104<br /> Memory consumption after 62000 iterations is 12570104<br /> Memory consumption after 63000 iterations is 12754112<br /> Memory consumption after 64000 iterations is 12938120<br /> Memory consumption after 65000 iterations is 13122136<br /> Memory consumption after 66000 iterations is 13830424<br /> Memory consumption after 67000 iterations is 14014432<br /> Memory consumption after 68000 iterations is 14198440<br /> Memory consumption after 69000 iterations is 14382440<br /> Memory consumption after 70000 iterations is 14566456<br /> Memory consumption after 71000 iterations is 14750464<br /> Memory consumption after 72000 iterations is 14934472<br /> Memory consumption after 73000 iterations is 15118472<br /> Memory consumption after 74000 iterations is 15302488<br /> Memory consumption after 75000 iterations is 15486496<br /> Memory consumption after 76000 iterations is 15670496<br /> Memory consumption after 77000 iterations is 15854504<br /> Memory consumption after 78000 iterations is 16038520<br /> Memory consumption after 79000 iterations is 16222520<br /> Memory consumption after 80000 iterations is 16406528<br /> Memory consumption after 81000 iterations is 16590536<br /> Memory consumption after 82000 iterations is 16774552<br /> Memory consumption after 83000 iterations is 16958552<br /> Memory consumption after 84000 iterations is 17142560<br /> Memory consumption after 85000 iterations is 17326568<br /> Memory consumption after 86000 iterations is 17510568<br /> Looks like its still there. Previous Comments: ------------------------------------------------------------------------ [2010-04-16 10:41:21] johannes@php.net Keeping it on "Feedback" till there was actual feedback. ------------------------------------------------------------------------ [2010-04-15 13:01:42] mat999 at gmail dot com ok on the weekend Ill remake my build environment and see what I can do. ------------------------------------------------------------------------ [2010-04-15 12:50:54] andrey@php.net Can you try with 5.3.3-dev. I am sure I fixed this. Not a real leak, more like streams were freeing memory too late. Please try a snapshot from snaps.php.net ------------------------------------------------------------------------ [2010-04-06 07:38:40] mat999 at gmail dot com Gee, no responses on a proven bug... Heres valgrind info, sorry no debug symbols for php5-mysql [...] ==49959== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 52 from 4) --49959-- --49959-- supp: 22 dl-hack4-64bit-addr-1 --49959-- supp: 2 dl-hack3-cond-2 --49959-- supp: 27 dl-hack3-cond-1 --49959-- supp: 1 dl-hack4-64bit-addr-2 ==49959== malloc/free: in use at exit: 6,394 bytes in 22 blocks. ==49959== malloc/free: 31,095 allocs, 31,073 frees, 4,718,692 bytes allocated. ==49959== ==49959== searching for pointers to 22 not-freed blocks. ==49959== checked 1,626,688 bytes. ==49959== ==49959== 5 bytes in 1 blocks are indirectly lost in loss record 1 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x9161D71: strdup (in /lib/libc-2.7.so) ==49959== by 0x91A0036: (within /lib/libc-2.7.so) ==49959== by 0x91A1F78: getaddrinfo (in /lib/libc-2.7.so) ==49959== by 0xA5C017E: ??? ==49959== by 0xA5C030D: ??? ==49959== by 0xA5C0488: ??? ==49959== by 0xA5C04A9: ??? ==49959== by 0xA5C7D96: ??? ==49959== by 0xA38C5FC: ??? ==49959== by 0x74A6CA: zend_startup_module_ex (in /usr/bin/php5) ==49959== by 0x752E3A: zend_hash_apply (in /usr/bin/php5) ==49959== ==49959== ==49959== 12 bytes in 1 blocks are still reachable in loss record 2 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x9161D71: strdup (in /lib/libc-2.7.so) ==49959== by 0x555354: zm_startup_intl (in /usr/bin/php5) ==49959== by 0x74A6CA: zend_startup_module_ex (in /usr/bin/php5) ==49959== by 0x752E3A: zend_hash_apply (in /usr/bin/php5) ==49959== by 0x74DC29: zend_startup_modules (in /usr/bin/php5) ==49959== by 0x6F1399: php_module_startup (in /usr/bin/php5) ==49959== by 0x7D7B4C: php_cli_startup (in /usr/bin/php5) ==49959== by 0x7D850F: main (in /usr/bin/php5) ==49959== ==49959== ==49959== 12 bytes in 1 blocks are still reachable in loss record 3 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x777588D: uprv_getDefaultLocaleID_3_8 (in /usr/lib/libicuuc.so.38.1) ==49959== by 0x77AC129: (within /usr/lib/libicuuc.so.38.1) ==49959== by 0x77AC2AE: icu_3_8::Locale::getDefault() (in /usr/lib/libicuuc.so.38.1) ==49959== by 0x77AD7C8: (within /usr/lib/libicuuc.so.38.1) ==49959== by 0x55534C: zm_startup_intl (in /usr/bin/php5) ==49959== by 0x74A6CA: zend_startup_module_ex (in /usr/bin/php5) ==49959== by 0x752E3A: zend_hash_apply (in /usr/bin/php5) ==49959== by 0x74DC29: zend_startup_modules (in /usr/bin/php5) ==49959== by 0x6F1399: php_module_startup (in /usr/bin/php5) ==49959== by 0x7D7B4C: php_cli_startup (in /usr/bin/php5) ==49959== by 0x7D850F: main (in /usr/bin/php5) ==49959== ==49959== ==49959== 32 bytes in 1 blocks are still reachable in loss record 4 of 11 ==49959== at 0x4C203E4: calloc (vg_replace_malloc.c:397) ==49959== by 0x66C73DF: (within /lib/libdl-2.7.so) ==49959== by 0x66C6F20: dlopen (in /lib/libdl-2.7.so) ==49959== by 0x752274: zend_load_extension (in /usr/bin/php5) ==49959== by 0x73D30D: zend_llist_apply (in /usr/bin/php5) ==49959== by 0x6F8226: php_ini_register_extensions (in /usr/bin/php5) ==49959== by 0x6F1394: php_module_startup (in /usr/bin/php5) ==49959== by 0x7D7B4C: php_cli_startup (in /usr/bin/php5) ==49959== by 0x7D850F: main (in /usr/bin/php5) ==49959== ==49959== ==49959== 53 bytes in 2 blocks are definitely lost in loss record 5 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0xA5BF317: ??? ==49959== by 0xA5C0269: ??? ==49959== by 0xA5C030D: ??? ==49959== by 0xA5C0488: ??? ==49959== by 0xA5C04A9: ??? ==49959== by 0xA5C7D96: ??? ==49959== by 0xA38C5FC: ??? ==49959== by 0x74A6CA: zend_startup_module_ex (in /usr/bin/php5) ==49959== by 0x752E3A: zend_hash_apply (in /usr/bin/php5) ==49959== by 0x74DC29: zend_startup_modules (in /usr/bin/php5) ==49959== by 0x6F1399: php_module_startup (in /usr/bin/php5) ==49959== ==49959== ==49959== 69 (64 direct, 5 indirect) bytes in 1 blocks are definitely lost in loss record 6 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x919FC83: (within /lib/libc-2.7.so) ==49959== by 0x91A1F78: getaddrinfo (in /lib/libc-2.7.so) ==49959== by 0xA5C017E: ??? ==49959== by 0xA5C030D: ??? ==49959== by 0xA5C0488: ??? ==49959== by 0xA5C04A9: ??? ==49959== by 0xA5C7D96: ??? ==49959== by 0xA38C5FC: ??? ==49959== by 0x74A6CA: zend_startup_module_ex (in /usr/bin/php5) ==49959== by 0x752E3A: zend_hash_apply (in /usr/bin/php5) ==49959== by 0x74DC29: zend_startup_modules (in /usr/bin/php5) ==49959== ==49959== ==49959== 176 bytes in 1 blocks are still reachable in loss record 7 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x77AC169: (within /usr/lib/libicuuc.so.38.1) ==49959== by 0x77AC2AE: icu_3_8::Locale::getDefault() (in /usr/lib/libicuuc.so.38.1) ==49959== by 0x77AD7C8: (within /usr/lib/libicuuc.so.38.1) ==49959== by 0x55534C: zm_startup_intl (in /usr/bin/php5) ==49959== by 0x74A6CA: zend_startup_module_ex (in /usr/bin/php5) ==49959== by 0x752E3A: zend_hash_apply (in /usr/bin/php5) ==49959== by 0x74DC29: zend_startup_modules (in /usr/bin/php5) ==49959== by 0x6F1399: php_module_startup (in /usr/bin/php5) ==49959== by 0x7D7B4C: php_cli_startup (in /usr/bin/php5) ==49959== by 0x7D850F: main (in /usr/bin/php5) ==49959== ==49959== ==49959== 672 bytes in 1 blocks are still reachable in loss record 8 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x4011429: (within /lib/ld-2.7.so) ==49959== by 0x4011A24: (within /lib/ld-2.7.so) ==49959== by 0x400D385: (within /lib/ld-2.7.so) ==49959== by 0x401111A: (within /lib/ld-2.7.so) ==49959== by 0x66C6FBA: (within /lib/libdl-2.7.so) ==49959== by 0x400D385: (within /lib/ld-2.7.so) ==49959== by 0x66C736B: (within /lib/libdl-2.7.so) ==49959== by 0x66C6F20: dlopen (in /lib/libdl-2.7.so) ==49959== by 0x66A870: php_load_extension (in /usr/bin/php5) ==49959== by 0x73D30D: zend_llist_apply (in /usr/bin/php5) ==49959== by 0x6F8239: php_ini_register_extensions (in /usr/bin/php5) ==49959== ==49959== ==49959== 1,272 bytes in 11 blocks are still reachable in loss record 9 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x59BB8F2: CRYPTO_malloc (in /usr/lib/libcrypto.so.0.9.8) ==49959== by 0x5A1C2DE: sk_new (in /usr/lib/libcrypto.so.0.9.8) ==49959== by 0x572D649: (within /usr/lib/libssl.so.0.9.8) ==49959== by 0x572D858: SSL_COMP_get_compression_methods (in /usr/lib/libssl.so.0.9.8) ==49959== by 0x5733A0F: SSL_library_init (in /usr/lib/libssl.so.0.9.8) ==49959== by 0x468BCE: zm_startup_openssl (in /usr/bin/php5) ==49959== by 0x74A6CA: zend_startup_module_ex (in /usr/bin/php5) ==49959== by 0x752E3A: zend_hash_apply (in /usr/bin/php5) ==49959== by 0x74DC29: zend_startup_modules (in /usr/bin/php5) ==49959== by 0x6F1399: php_module_startup (in /usr/bin/php5) ==49959== by 0x7D7B4C: php_cli_startup (in /usr/bin/php5) ==49959== ==49959== ==49959== 2,048 bytes in 1 blocks are still reachable in loss record 10 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x753619: _zend_hash_init (in /usr/bin/php5) ==49959== by 0x75366C: _zend_hash_init_ex (in /usr/bin/php5) ==49959== by 0x7472D5: zend_startup (in /usr/bin/php5) ==49959== by 0x6F0DCF: php_module_startup (in /usr/bin/php5) ==49959== by 0x7D7B4C: php_cli_startup (in /usr/bin/php5) ==49959== by 0x7D850F: main (in /usr/bin/php5) ==49959== ==49959== ==49959== 2,048 bytes in 1 blocks are still reachable in loss record 11 of 11 ==49959== at 0x4C2260E: malloc (vg_replace_malloc.c:207) ==49959== by 0x73DC8D: zend_llist_init (in /usr/bin/php5) ==49959== by 0x6FA902: sapi_activate (in /usr/bin/php5) ==49959== by 0x6F0CB3: php_module_startup (in /usr/bin/php5) ==49959== by 0x7D7B4C: php_cli_startup (in /usr/bin/php5) ==49959== by 0x7D850F: main (in /usr/bin/php5) ==49959== ==49959== LEAK SUMMARY: ==49959== definitely lost: 117 bytes in 3 blocks. ==49959== indirectly lost: 5 bytes in 1 blocks. ==49959== possibly lost: 0 bytes in 0 blocks. ==49959== still reachable: 6,272 bytes in 18 blocks. ==49959== suppressed: 0 bytes in 0 blocks. --49959-- memcheck: sanity checks: 50 cheap, 4 expensive --49959-- memcheck: auxmaps: 0 auxmap entries (0k, 0M) in use --49959-- memcheck: auxmaps_L1: 0 searches, 0 cmps, ratio 0:10 --49959-- memcheck: auxmaps_L2: 0 searches, 0 nodes --49959-- memcheck: SMs: n_issued = 161 (2576k, 2M) --49959-- memcheck: SMs: n_deissued = 9 (144k, 0M) --49959-- memcheck: SMs: max_noaccess = 524287 (8388592k, 8191M) --49959-- memcheck: SMs: max_undefined = 14 (224k, 0M) --49959-- memcheck: SMs: max_defined = 2155 (34480k, 33M) --49959-- memcheck: SMs: max_non_DSM = 160 (2560k, 2M) --49959-- memcheck: max sec V bit nodes: 8 (0k, 0M) --49959-- memcheck: set_sec_vbits8 calls: 13 (new: 8, updates: 5) --49959-- memcheck: max shadow mem size: 6704k, 6M --49959-- translate: fast SP updates identified: 21,056 ( 84.1%) --49959-- translate: generic_known SP updates identified: 3,640 ( 14.5%) --49959-- translate: generic_unknown SP updates identified: 331 ( 1.3%) --49959-- tt/tc: 44,478 tt lookups requiring 53,263 probes --49959-- tt/tc: 44,478 fast-cache updates, 24 flushes --49959-- transtab: new 18,748 (589,533 -> 7,876,845; ratio 133:10) [0 scs] --49959-- transtab: dumped 0 (0 -> ??) --49959-- transtab: discarded 1,820 (46,106 -> ??) --49959-- scheduler: 5,020,598 jumps (bb entries). --49959-- scheduler: 50/88,483 major/minor sched events. --49959-- sanity: 51 cheap, 4 expensive checks. --49959-- exectx: 12,289 lists, 10,787 contexts (avg 0 per list) --49959-- exectx: 62,188 searches, 59,102 full compares (950 per 1000) --49959-- exectx: 65 cmp2, 444 cmp4, 0 cmpAll --49959-- errormgr: 44 supplist searches, 1,362 comparisons during search --49959-- errormgr: 52 errlist searches, 607 comparisons during search ------------------------------------------------------------------------ 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 http://bugs.php.net/bug.php?id=51347 -- Edit this bug report at http://bugs.php.net/bug.php?id=51347&edit=1