MailScanner and MySQL - SOLVED

[Martin Hepworth]

Martin

Well yes it can do, but for example if mysql is on a fast machine (mine is a
2.8ghz PIV SATA based thing - so not that fast by this months standards)....

Mysql will 'start' & daemonise and hand back to the init process. BUT in
reality it's still starting and isn't ready to accept connections for a few
more seconds. IF MailScanner or whatever comes along very quickly after
mysql start it can get stuck trying to connect and failing.

This has only happened to be once when I tore down a mysql DB without
shutting it down nice....but it's a real nice gotcha...

--
Martin Hepworth 
Snr Systems Administrator
Solid State Logic
Tel: +44 (0)1865 842300

> -----Original Message-----
> From: mailscanner-bounces at lists.mailscanner.info [mailto:mailscanner-
> bounces at lists.mailscanner.info] On Behalf Of Martin
> Sent: 25 April 2006 14:53
> To: mailscanner at lists.mailscanner.info
> Subject: Re: MailScanner and MySQL - SOLVED
> 
> Martin Hepworth wrote:
> 
> > Martin
> > Another thing I do is put a 20 second wait start the start of the
> > mailScanner start script. This makes sure mysql is up and running before
> MS
> > starts. I've had one reboot where even though mysql should have started
> > before mailscanner starts, the box was so fast mysql hadn't quite some
> up
> > before MS started....this lead to alsorts of fun as there as a stuck MS
> > process that wouldn't release on the mysql....I had to kill -15 it,
> after
> > much confusion about what processed were running etc.
> 
> Martin,
> 
> Thanks, but isn't this what the start-order suppose to do: Wait to start
> the next item until the previous is started?
> 
> I'm not quite sure of this, but i thought this is the way it's supposed
> to work?
> 
> Thank you
> 
> --
> MailScanner mailing list
> mailscanner at lists.mailscanner.info
> http://lists.mailscanner.info/mailman/listinfo/mailscanner
> 
> Before posting, read http://wiki.mailscanner.info/posting
> 
> Support MailScanner development - buy the book off the website!


**********************************************************************

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote confirms that this email message has been swept
for the presence of computer viruses and is believed to be clean.	

**********************************************************************