Re: [Sqlrelay-discussion] debugging sql-relay

[Cal H. <ca...@fb...>]

This is an interesting coincidence, but I just had this same problem earlier
this morning.  We use big brother <http://bb4.com/> for our
monitoring/paging, and I have a check setup to run a simple query on all of
my instances.  At 2:38am we rebooted one of the servers, the check seemed to
hang at 2:39, and then recover at 2:40 after the machine was live again.
Then mysteriously at 3:35am I got a page:

Mon Jul 12 03:35:16 2010 relay  Failed to authenticate.
Mon Jul 12 03:35:16 2010 relay   A network error may have ocurred.
Mon Jul 12 03:35:16 2010 relay          Rows Returned   : 0
Mon Jul 12 03:35:16 2010 relay          Fields Returned : 0
Mon Jul 12 03:35:16 2010 relay          System time     : 0

Now at 9:30am I still have 20 forked listeners running, and only 8 server
connections.  I have all of my config settings cranked way up...

maxlisteners="300"
listenertimeout="20"
sessiontimeout="60"
maxsessioncount="170"

I haven't yet applied Renat's patches to my live systems, I only have my
dynamic cursors patch installed.  I was waiting for the "official" release
with our two patches combined to see if David would catch any merge bugs
between everything.  (What's the status on that BTW?)

Thanks,

--Cal

On Sun, Jul 11, 2010 at 10:25 AM, Renat Sabitov <sr...@st...> wrote:

> 10.07.2010 02:22, sql...@ma... пишет:
> > The number of "Forked Listeners" might be the problem considering that
> number is usually 0.
> >
> This number represent count of client connections to sqlrelay waiting
> for free connection to DB. This means that all your 15 sessions to DB
> are busy. If it is so, you should check what they are doing and maybe
> increase maximum connection count in config.
> But be aware that usually sqlr-status shows information far from the
> reality. I recommend you to apply my patches for sqlrelay and rudiments
> (http://www.srr.pp.ru/www/sqlrelay/) and use -fork option (check
> description for patches in this list).
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>