[Sqlrelay-discussion] (Resend) Re: Listener hangs on query

[Jamie A L. <ja...@ja...>]

Just sending this out again, hoping that someone has an idea.

I've tried stracing sqlr-start, but that appears to not provide much  
in the way of anything useful.

-j


On Mar 26, 2008, at 10:16 AM, David Muse wrote:
> It looks like either the sqlr-connection-mysql processes aren't  
> running,
> or they're hung.
>
> Do ps -efa | grep sqlr-connection-mysql and see if they are  
> running.  If
> not, then they may not have been able to log into the DB.  If they are
> running, then something more sinister is going on.  In that case, try
> handoff="reconnect" rather than handoff="pass" and see if that works.
>
> Let me know what you find.


Sorry to be slow. Looks like "not running". is the answer.


jal@charybdis $ ps -efa | grep sqlr
sqlrelay 29858     1  0 18:05 pts/7    00:00:00 sqlr-listener-debug - 
id jal -config /etc/sqlrelay.conf
sqlrelay 29900     1  0 18:06 ?        00:00:00 sqlr-scaler -id jal - 
debug -config /etc/sqlrelay.conf
root     29906     1  0 18:06 ?        00:00:00 sqlr-cachemanager
root     29911 19275  0 18:06 pts/7    00:00:00 sqlrsh -config /etc/ 
sqlrelay.conf -id jal
sqlrelay 29912 29858  0 18:06 pts/7    00:00:00 sqlr-listener-debug - 
id jal -config /etc/sqlrelay.conf
jal      29932 29913  0 18:07 pts/6    00:00:00 grep sqlr


As for not logging in to the DB, would that failure be logged  
anywhere? I doublechecked the credentials in /etc/sqlrelay.conf, and  
they're correct. Are there other reasons sqlr-connection might not  
start?

Thanks,

-j