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

[Rob T. <rt...@li...>]

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
>