Re: [Sqlrelay-discussion] Listener hangs on query
Brought to you by:
mused
|
From: David M. <dav...@fi...> - 2008-03-26 14:17:20
|
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. David Muse dav...@fi... On Mon, 2008-03-24 at 13:59 -0400, Jamie A Lawrence wrote: > Hello, > > I'm trying to get a pretty simple sqlrelay setup working. Config: > > <?xml version="1.0"?> > <!DOCTYPE instances SYSTEM "sqlrelay.dtd"> > > <instances> > > <instance id="gab" port="9000" socket="/tmp/sqlrelay.socket" > dbase="mysql" connections="20" maxconnections="20" maxqueuelength="5" > growby="1" ttl="60" endofsession="commit" sessiontimeout="600" > runasuser="sqlrelay" runasgroup="sqlrelay" cursors="5" > authtier="listener" handoff="pass" deniedips="" allowedips="(127\.0\. > 0\.1|209\.212\.93\.52)" debug="listener_and_connection"> > <users> > <user user="jal" password="xxx"/> --> > </users> > <connections> > <connection connectionid="gab" > string > ="user=jal;password=xxx;db=gab;host=127.0.0.1;port=3306;fakebinds=no;" > metric="1"/> > </connections> > </instance> > > </instances> > > > Symptom: > > I start sqlrsh, try to ping, and it hangs forever: > > [jal@zipp ~]$ sqlrsh localhost 9000 /tmp/sqlrelay.socket jal xxx > SQLRShell - Version 0.22 > Connected to: localhost:9000 as jal > > type help; for a help. > > 0> ping; > > > The logs seem to indicate that it is hanging on getting a connection: > > :::::::::::::: > sqlr-listener.8041 > :::::::::::::: > 03/24/2008 13:58:37 EDT listener [8041] : creating shared memory and > semaphores > > 03/24/2008 13:58:37 EDT listener [8041] : id filename: > > 03/24/2008 13:58:37 EDT listener [8041] : /var/sqlrelay/tmp/gab > > 03/24/2008 13:58:37 EDT listener [8041] : creating shared memory... > > 03/24/2008 13:58:37 EDT listener [8041] : creating semaphores... > > 03/24/2008 13:58:37 EDT listener [8041] : waiting for client > connection... > > 03/24/2008 13:59:08 EDT listener [8041] : done waiting for client > connection > > 03/24/2008 13:59:08 EDT listener [8041] : forked a child: 8092 > > 03/24/2008 13:59:08 EDT listener [8041] : waiting for client > connection... > > :::::::::::::: > sqlr-listener.8092 > :::::::::::::: > 03/24/2008 13:59:08 EDT listener [8092] : getting authentication... > > 03/24/2008 13:59:08 EDT listener [8092] : listener-based > authentication succeeded > > 03/24/2008 13:59:08 EDT listener [8092] : incrementing session count... > > 03/24/2008 13:59:08 EDT listener [8092] : 1 > > 03/24/2008 13:59:08 EDT listener [8092] : done incrementing session > count > > 03/24/2008 13:59:08 EDT listener [8092] : getting a connection... > > This is on FC5, with Mysql 5.0.22 and Sqlrelay from sqlrelay-0.33.1- > fr0.2.i386.rpm, and rudiments-0.25.1-fr1.i386.rpm > > Anyone have any ideas? > > Thanks, > > -j > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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 |