Issues

ZF-5170: Zend_Db_Adapter_Pdo_Mssql memory leak?

Issue Type: Bug Created: 2008-12-05T16:33:09.000+0000 Last Updated: 2009-09-17T17:34:33.000+0000 Status: Resolved Fix version(s): Reporter: Michael Kliewe (mkliewe) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db

Related issues: Attachments: - memleak.zip

Description

Hello,

I have a problem with Zend_Db when using a mssql-database. I'm working several month with Zend Framework now, and was writing a kind of "windows service" in php (with php cli as service or scheduled task). This script runs very long (many days/weeks) in a loop. But I experienced memory problems with Zend_Db.

With each SQL-Query the Zend_Db object seems to grow a bit, depending on the select-result-size!!! Even with only one result row, the script-memory-usage grows. If I do INSERTs or UPDATES, all works fine, but when doing SELECTs, the script-memory-usage grows and grows. And my script runs many days and has 100.000 selects a day, which results in >100MB memory usage growth per day. So I have to restart the script every day ;-(

Zend_Db seems to cache that results or so, I don't know. Zend_Db_Profiler is disabled of cause.

I did a few tests, tested PEAR-MDB2 and also Zend_Db Pdo_Sqlite-Adapter . With these two methods I didn't experience a memory growth.

I will attach my test files, so you can check it on your own. You will need PEAR MDB2 installed to run it (or you disable that part). I will also attach my results (results.txt), where you can see, that sqlite and mdb2 don't grow, but mssql does!

I cannot use Zend_Db with that bug. Please fix it soon!

Michael

Comments

Posted by Michael Kliewe (mkliewe) on 2008-12-05T16:34:44.000+0000

zip archive with my test script and results.txt, where you can see the problem with mssql-adapter

Posted by Petr Gottvald (gotys) on 2009-09-08T00:51:17.000+0000

I ran into the same exact issue yesterday. It doesn't seem Zend_Db was written with memory leaks in mind. Running a PHP Daemon using Zend_Db is impossible right now. I am examining the source codes of Zend_Framework right now and will report if I find something.

Someone please fix this!

Posted by Petr Gottvald (gotys) on 2009-09-08T02:05:25.000+0000

Well, I think I solved my problem . It was much easier then I thought. My memory kept leaking with when I had the Query Profiler turned on. I turned it off, now memory stopped leaking. Let me know if this solved your issue as well.

Petr

Have you found an issue?

See the Overview section for more details.

Copyright

© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.

Contacts