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

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

Not running is probably the best result in this case :)  If it were
anything else then it would be tougher to track down.

It's most likely that there is just some permissions-related problem and
the sqlr-connection-mysql daemons can't log into the db.  Check the
mysql db log.

ltrace is actually a lot more useful for this stuff than strace.  You
could try starting sqlr-listener manually and then start an instance of
sqlr-connection-mysql-debug using ltrace:

sqlr-listener -id jal
ltrace sqlr-connection-mysql-debug -id jal -connectionid something

(where "something" is replaced with the connectionid defined in the
sqlrelay.conf file)

You should be able to tell what function is failing that way.

Dave
dav...@fi...


On Tue, 2008-04-08 at 12:08 -0400, Jamie A Lawrence wrote:
> 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
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
> Register now and save $200. Hurry, offer ends at 11:59 p.m., 
> Monday, April 7! Use priority code J8TLD2. 
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com