Re: Leak with prepared statements and mysql_server_prepare=1

Patrick Galbraith <[email protected]> Thu, 03 May 2007 11:12:32 -0400
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
Mika Raento wrote:

> Hiya
>
> Bug #27046 http://bugs.mysql.com/bug.php?id=27046 makes 
> mysql_server_prepare=1 unusable, because of the statement handle leak. 
> I added a comment to the bug with a possible fix - basically adding 
> mysql_stmt_close(imp_sth->stmt) to dbd_st_finish. It does fix the most 
> basic case and passes all tests.
>
> What I don't quite get is why the non-mysql_server_prepare codepath 
> doesn't leak statements, as I don't see it releasing them either. 
> Maybe they are automatically re-used somehow?
>
>     Mika
>
Mika,

I will look at this patch, kitos for the patch!

Patrick

-- 
Patrick Galbraith, Senior Programmer 
Grazr - Easy feed grazing and sharing
http://www.grazr.com 

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]