Re: [Sqlrelay-discussion] I'm having to coninually restart sqlrelay. Why?
Brought to you by:
mused
|
From: Rob T. <rt...@li...> - 2007-04-05 00:07:08
|
David, It didn't hang again until late this afternoon. Before doing anything else, I did a 'ps' and there were three sqlr-connection-mysql processes running, which is consistent with sqlrelay.conf. After a restart, there were again three processes, so that's normal. The one difference I noticed was that there were two listeners running before the restart and one afterwards. Is that normal? I turned on debug and I'll see if we can break it in testing tomorrow. Thanks for your help so far. -- Rob David Muse said the following on 04/03/2007 06:40 PM: > Sounds like the sqlrelay server-side components are crashing or hanging. > Whenever it hangs up, take a look and see if any sqlr-connection-mysql > processes are running. If not, then they may have crashed. If so, then > they may have hung. You can turn on debug in the sqlrelay.conf file and > take a look at the logs. > > Recently, I updated SQL Relay to use the mysql statement API rather than > the standard mysql API. There could be a bug with that. > > The debug logs would be really helpful in figuring out what's going on. > > Dave > dav...@fi... > > On Tue, 2007-04-03 at 10:07 -0700, Rob Tanner wrote: > >> I'm afraid that I'm definitely a newbie using sqlrelay, so I'm not sure >> what information to provide. >> >> I built and installed sqlrelay on a RedHat AS3 system running apache, >> php and perl. The database I want to provide connection pooling for is >> a mysql database running on a different machine. I can start sqlrelay >> using the linux service command (service sqlrelay start) and all is well >> for a while. Database accesses work both in php and perl. Then >> suddenly (and I don't know what causes the "suddenly"), both php and >> perl apps hang while trying to retrieve data from the database. >> Sqlrelay has not stopped running and so I do a restart (service sqlrelay >> restart), and everything is working again. >> >> Any ideas how to figure out the cause of the hanging on the database >> access? This is the connection string from the sqlrelay.conf file: >> >> <connections> >> <connection connectionid="db1" >> string="user=dbuser;password=secret;db=webapps;host=dbhost.linfield.edu;port=3306;fakebinds=no;" >> metric="1" behindloadbalancer="1"/> >> </connections> >> >> Thanks, >> Rob >> >> >> ------------------------------------------------------------------------- >> Take Surveys. Earn Cash. Influence the Future of IT >> Join SourceForge.net's Techsay panel and you'll get the chance to share your >> opinions on IT & business topics through brief surveys-and earn cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |