From: Warren Young
Date: November 29 2005 7:58am
Subject: Re: Problems with mysql_close() (function does not return) + potential
 bugs found
List-Archive: http://lists.mysql.com/plusplus/5223
Message-Id: <438C0A33.9020104@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

RedFraggle wrote:
> 
> In the problem might depend on the fact, that i still have a 'Result'
> stored somewhere else , which is not deleted while closing the
> connection , but i'm not sure (this would mean, that mysql_close()
> knows, there is a 'Result' somewhere and waits for closing it (?)...hard
> to believe...)

I don't think that's the problem.  I couldn't replicate it by dropping 
con.close() calls into various parts of the simple1 and usequery 
examples where the Result/ResUse objects are still active.

Can you reduce the problem to a simple example?

Is the database server on another machine?  If so, mysql_close() will 
involve a network operation.  If the remote machine isn't responding, 
mysql_close() certainly could block.

> Any ideas what may cause the hanging and for what i should look?

There's a fair chance that this is not a MySQL++ issue.  If you can 
reproduce the problem with a small example, I would then convert it to 
the equivalent MySQL C API code and try that, too.  If that fails in the 
same way, please take it up on the main MySQL mailing list.