Re: [Sqlrelay-discussion] Fwd: possible bug

[David M. <dav...@fi...>]

Thank you for reporting this bug.  I will test your solution and if it 
works well then I will include it in the next release.

Take care,

David Muse
dav...@fi...

On 04/16/2012 07:10 AM, Georgy Kirichenko wrote:
> Hello!
> Sorry for my bad english
>
> I use query from sqlrelay as client.
> When sqlr-listener has a error by getting connection (getAConnection in
> handOffClient function), so it send error code to client, but not call
> flushWriteBuffer. In this case query don't recieve a error message from listener
> and wait, and listener wait disconnect message from client
> (waitForClientClose).
>
> Small example: all connections to db will wait at db locks. A new forked
> listener wait for a free connection (at waitForConnection) and has timeout
> (waitForConnection return false). In this case sqlr-listener and query will
> hang.
> When use this code (at bool sqlrlistener::handOffClient(filedescriptor *sock)):
> if (!getAConnection(&connectionpid,&inetport,
> 					unixportstr,&unixportstrlen)) {
> 			// fatal error occurred while getting a connection
> 			sock->write((uint16_t)ERROR);
> 			sock->write((uint16_t)70);
> 			sock->write("The listener failed to hand the client off to the
> database connection.");
> 			flushWriteBuffer(sock);
> 			retval=false;
> 			break;
> 		}
> all works fine.
>
> My system: Debian Linux (3.0.2), amd64, rudiments 0.34 and sqlrelay 0.43,
> Oracle as database
>
>
> ------------------------------------------------------------------------------
> For Developers, A Lot Can Happen In A Second.
> Boundary is the first to Know...and Tell You.
> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
> http://p.sf.net/sfu/Boundary-d2dvs2
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com