sqlgrey-users

[Sqlgrey-users] Daemon Dying

[Jeff G. <je...@st...>]

My Sqlgrey daemon died last night and all of my mail was temp failed.  
What do people recommend for making sure the daemon stays running?  Is 
there a watchdog type program I can run to verify it is running, and if 
not, it will automatically restart it for me?

Thanks,
Jeff

Re: [Sqlgrey-users] Daemon Dying

[Brian C. <li...@ne...>]

> My Sqlgrey daemon died last night and all of my mail was temp failed.
> What do people recommend for making sure the daemon stays running?  Is
> there a watchdog type program I can run to verify it is running, and if
> not, it will automatically restart it for me?

I had the same occasional problem and created a "nanny" shell script to
monitor.  I run it every 10 minutes.  This is not foolproof but it works for
me.  I'm sure someone can make something better.  :)  
#!/bin/bash

/sbin/service sqlgrey status > /tmp/sqlgreystat.txt

sqlgreystat=`awk '{print $5}' /tmp/sqlgreystat.txt`
case "$sqlgreystat" in
   running...)
        exit 0
        ;;
   *)
        /sbin/service sqlgrey restart
        exit 0
        ;;
esac

Re: [Sqlgrey-users] Daemon Dying

[Klaus A. S. <kse...@gm...>]

Brian Collins wrote:

> I had the same occasional problem and created a "nanny" shell script to
> monitor.  I run it every 10 minutes.  This is not foolproof but it works for
> me.  I'm sure someone can make something better.  :)

Other possibilities are running SQLgrey under init, upstart, runit or
dæmontools.  They will all restart SQLgrey as soon as it fails.

Cheers,

--
Klaus Alexander Seistrup
https://twitter.com/kseistrup

Re: [Sqlgrey-users] Daemon Dying

[Karl O. P. <ko...@me...>]

On 04/21/2009 08:23:29 AM, Jeff Grossman wrote:
> My Sqlgrey daemon died last night and all of my mail was temp failed.
> 
> What do people recommend for making sure the daemon stays running?

I had a problem like this until I upgraded to the latest
version available, which IIRC is a beta but I think only
because nobody's gotten around to releasing it.

If that does not fix it you're probably better off
solving the problem at it's source rather than papering
over the symptom.


Karl <ko...@me...>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

Re: [Sqlgrey-users] Daemon Dying

[David L. <da...@la...>]

Karl O. Pinc wrote:
> On 04/21/2009 08:23:29 AM, Jeff Grossman wrote:
>> My Sqlgrey daemon died last night and all of my mail was temp failed.
>>
>> What do people recommend for making sure the daemon stays running?
> 
> I had a problem like this until I upgraded to the latest
> version available, which IIRC is a beta but I think only
> because nobody's gotten around to releasing it.
> 
> If that does not fix it you're probably better off
> solving the problem at it's source rather than papering
> over the symptom.

Easier said than done. I have sqlgrey die intermittently (like, 1 or 2 
times per year) with an obscure internals error. I know my perl 
internals pretty well but I have only a vague idea where to start 
looking. A better use of my time was to write a watchdog.

Here's my version (relies on FreeBSD's sockstat):

#! /usr/local/bin/perl -w

my $alive = 0 + `/usr/bin/sockstat -l|/usr/bin/grep 
127.0.0.1:2501|/usr/bin/wc -l`;

exit if $alive;

system( "/usr/local/etc/rc.d/sqlgrey restart" );
system( qq{mail -s 'sqlgrey restarted' david < /dev/null } );

__END__

Hmm, that should probably have been written in shell, come to think of it :)

David