Re: [Sqlrelay-discussion] RE: Failed to acquire announce mutex

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

Hmmm,

The sqlr-listener starts up, and then each sqlr-connection process
registers itself with the listener.  The have to take turns registering,
so each sqlr-connection waits on a semaphore (the announce mutex) for
it's turn.

Are all of the sqlr-connection's in that state?  One of them should have
successfully acquired the mutex unless the sqlr-listener isn't running.
See if the sqlr-listener isn't running.  If it is running, look through
the logs and see if one of the sqlr-connections did in fact acquire the
announce mutex, but hasn't get released it.  If you find a case of that,
send me the log for that connection.

Are you by any chance running on a virtual server?

David Muse
dav...@fi...

On Wed, 2005-11-23 at 14:50 -0600, Guo, Jinnan wrote:
> Dave,
> 
> After some investigation, I found that if I increase the connection number to 40, the connection process is stopped at "Waiting for client...". Thanks
> 
> -----Original Message-----
> From: Guo, Jinnan 
> Sent: November 22, 2005 06:20 AM
> To: 'sql...@li...'
> Subject: Failed to acquire announce mutex
> 
> 
> Dave,
> 
> I setup SQLRelay with 20 connections, everything is fine. But when I tried to start 30 connections, most of the connections failed. Here is log of one of the connection process.
> 
> ....
> 
> 11/16/2005 20:35:48 EST connection [19181] : database is available
> 
> 11/16/2005 20:35:48 EST connection [19181] : initializing session...
> 
> 11/16/2005 20:35:48 EST connection [19181] : done initializing session...
> 
> 11/16/2005 20:35:48 EST connection [19181] : announcing availability...
> 
> 11/16/2005 20:35:48 EST connection [19181] : registering for handoff...
> 
> 11/16/2005 20:35:48 EST connection [19181] : handoffsockname: /opt/sybase/fir
> 
> stworks/var/sqlrelay/tmp/sockets/parsons-handoff
> 
> 11/16/2005 20:35:48 EST connection [19181] : trying...
> 
> 11/16/2005 20:35:48 EST connection [19181] : done registering for handoff
> 
> 11/16/2005 20:35:48 EST connection [19181] : acquiring announce mutex
> 
> Then, the process hang there forever.
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>