Bug #20727 mysqlhocopy gives error message about disconnect invalidates statement handle
Submitted: 27 Jun 2006 17:38 Modified: 27 Jun 2006 18:37
Reporter: Rick Wargo Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:1.22 OS:Linux (Fedora Core 5)
Assigned to: CPU Architecture:Any

[27 Jun 2006 17:38] Rick Wargo 
Description:
Text of the error:

DBI::db=HASH(0x84736ec)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/bin/mysqlhotcopy line 537.

How to repeat:
mysqlhotcopy --allowold --regexp='.*' /store/backup/mysql

Suggested fix:
Need to finish statement handle in global context (at line 210) prior to disconnecting database. Suggest adding $sth_vars->finish() at line 215.
[27 Jun 2006 18:37] Sveta Smirnova 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

--------------

Duplicates http://bugs.mysql.com/bug.php?id=20153