Re: /tmp/mysql.sock disappearing?
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote: > I couldn't fine this mentioned in the archives, so I hope someone has seen > this before: > > I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. > > There is still server process (sleeping), and there is still a pidfile. > > This can happen after ten or fifteen minutes of queries. > > I don't have a cronjob, or any other external process that scrubs /tmp. I have to apologize to everyone; I found out that I _did_ have a cronjob that caused this socket to go away: I had been doing this nightly: /usr/local/bin/mysqladmin -uroot -proot flush-logs && /usr/local/bin/safe_mysqld & safe_mysqld out-of-hand removes $MYSQL_UNIX_PORT; I don't know why. (I also don't know why I felt the need to restart mysqld after a flush-logs.) Thanks for everyone's advice... -- Brian 'you Bastard' Reichert<[EMAIL PROTECTED]> 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: /tmp/mysql.sock disappearing?
On Wed, Feb 14, 2001 at 09:03:16AM +0800, Rolf Hopkins wrote: > Do you have a cron job that's cleaning up your socket file along with > whatever other garbage it's cleaning up? Nope. As I said in my original mail: > I don't have a cronjob, or any other external process that scrubs /tmp. I'm waiting for it to happen again; it's been behaving for twelve hours now... -- Brian 'you Bastard' Reichert<[EMAIL PROTECTED]> 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: /tmp/mysql.sock disappearing?
Do you have a cron job that's cleaning up your socket file along with whatever other garbage it's cleaning up? - Original Message - From: "Brian Reichert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 4:42 Subject: Re: /tmp/mysql.sock disappearing? > On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote: > > I've seen it after installing two versions of MySQL on one server. > > I forgot to set another location for the second MySQL process > > before starting it with /bin/safe_mysqld. The result was that the > > socket was removed by the second process. > > > > Looking at safe_mysqld you would probably get the same result if > > you run multiple MySQL processes of the same version but from > > different data directories. > > Believable, but we in fact only have the one instance of mysql running. :/ > > > > > Fred. > > > > -- > > Fred van Engen XO Communications B.V. > > email: [EMAIL PROTECTED] Televisieweg 2 > > tel: +31 36 5462400 1322 AC Almere > > fax: +31 36 5462424 The Netherlands > > -- > Brian 'you Bastard' Reichert <[EMAIL PROTECTED]> > 37 Crystal Ave. #303 Daytime number: (603) 434-6842 > Derry NH 03038-1713 USA Intel architecture: the left-hand path > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: /tmp/mysql.sock disappearing?
On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote: > I've seen it after installing two versions of MySQL on one server. > I forgot to set another location for the second MySQL process > before starting it with /bin/safe_mysqld. The result was that the > socket was removed by the second process. > > Looking at safe_mysqld you would probably get the same result if > you run multiple MySQL processes of the same version but from > different data directories. Believable, but we in fact only have the one instance of mysql running. :/ > > Fred. > > -- > Fred van Engen XO Communications B.V. > email: [EMAIL PROTECTED] Televisieweg 2 > tel: +31 36 5462400 1322 AC Almere > fax: +31 36 5462424 The Netherlands -- Brian 'you Bastard' Reichert<[EMAIL PROTECTED]> 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: /tmp/mysql.sock disappearing?
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote: > I couldn't fine this mentioned in the archives, so I hope someone has seen > this before: > > I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. > > There is still server process (sleeping), and there is still a pidfile. > > This can happen after ten or fifteen minutes of queries. > > I don't have a cronjob, or any other external process that scrubs /tmp. > > Has anyone seen this sort of symptom before? > I've seen it after installing two versions of MySQL on one server. I forgot to set another location for the second MySQL process before starting it with /bin/safe_mysqld. The result was that the socket was removed by the second process. Looking at safe_mysqld you would probably get the same result if you run multiple MySQL processes of the same version but from different data directories. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
/tmp/mysql.sock disappearing?
I couldn't fine this mentioned in the archives, so I hope someone has seen this before: I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. There is still server process (sleeping), and there is still a pidfile. This can happen after ten or fifteen minutes of queries. I don't have a cronjob, or any other external process that scrubs /tmp. Has anyone seen this sort of symptom before? FWIW, the details: OS: FreeBSD 3.4-RELEASE MySQL 3.22.32 -- Brian 'you Bastard' Reichert<[EMAIL PROTECTED]> 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php