Re: [Sqlrelay-discussion] I'm having to coninually restart sqlrelay. Why?

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

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