Re: [Sqlrelay-discussion] (Resend) Re: Listener hangs on query
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2008-04-09 18:45:17
|
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 |