LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-10-2008, 11:59 PM   #1
Zeno McDohl
Member
 
Registered: Apr 2005
Location: Saratoga, NY
Distribution: Slackware
Posts: 316

Rep: Reputation: 30
MySQL failing


MySQL goes down once in a while. How can I determine the cause of this? I am unsure if there are logs, etc.
 
Old 06-11-2008, 12:13 AM   #2
custangro
Senior Member
 
Registered: Nov 2006
Location: California
Distribution: Fedora , CentOS , RHEL
Posts: 1,970
Blog Entries: 1

Rep: Reputation: 208Reputation: 208Reputation: 208
Look in /var/log/messages

What errors are you getting?
 
Old 06-11-2008, 12:17 AM   #3
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 234Reputation: 234Reputation: 234
/var/log/messages probably will tell you nothing. Check the mysql logs in /var/lib/mysql usually named after the hostname and ends with .err
 
Old 06-11-2008, 01:19 AM   #4
Zeno McDohl
Member
 
Registered: Apr 2005
Location: Saratoga, NY
Distribution: Slackware
Posts: 316

Original Poster
Rep: Reputation: 30
The latest .err file is from March. I had at least 2 times MySQL went down this month.
 
Old 06-11-2008, 01:32 AM   #5
immortaltechnique
Member
 
Registered: Oct 2006
Location: Kenya
Distribution: Ubuntu, RHEL, OpenBSD
Posts: 287

Rep: Reputation: 32
Kindly paste the contents of the above mentioned logs.
 
Old 06-11-2008, 01:47 AM   #6
Zeno McDohl
Member
 
Registered: Apr 2005
Location: Saratoga, NY
Distribution: Slackware
Posts: 316

Original Poster
Rep: Reputation: 30
Sure thing.

Dated 2008-03-09
Quote:
071221 00:07:01 mysqld started
071221 0:07:01 [ERROR] Can't start server : Bind on unix socket: Permission denied
071221 0:07:01 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ?
071221 0:07:01 [ERROR] Aborting

071221 0:07:02 [Note] /usr/libexec/mysqld: Shutdown complete

071221 00:07:02 mysqld ended

071221 02:10:53 mysqld started
071221 2:10:55 [ERROR] Can't start server : Bind on unix socket: Permission denied
071221 2:10:55 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ?
071221 2:10:55 [ERROR] Aborting

071221 2:10:55 [Note] /usr/libexec/mysqld: Shutdown complete

071221 02:10:55 mysqld ended

071230 14:24:49 mysqld started
071230 14:24:50 [ERROR] Can't start server : Bind on unix socket: Permission denied
071230 14:24:50 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ?
071230 14:24:50 [ERROR] Aborting

071230 14:24:50 [Note] /usr/libexec/mysqld: Shutdown complete

071230 14:24:50 mysqld ended

080309 13:42:18 mysqld started
080309 13:42:20 [ERROR] Can't start server : Bind on unix socket: Permission denied
080309 13:42:20 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ?
080309 13:42:20 [ERROR] Aborting

080309 13:42:20 [Note] /usr/libexec/mysqld: Shutdown complete

080309 13:42:20 mysqld ended
 
Old 06-11-2008, 08:50 AM   #7
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 234Reputation: 234Reputation: 234
Do you happen to have a /var/log/mysql.log? Sometimes that's a common place for mysql logs as well. And how was MySQL installed on this machine, what distro?
 
Old 06-11-2008, 09:18 AM   #8
sir_com
Member
 
Registered: Feb 2008
Posts: 31

Rep: Reputation: 15
Hi,

from the above log you have pasted....it seems that you have two instance of mysql installed on your machine. Please check the same.

When you connect to mysql server if from your local machine you are connecting (machine where server is installed)then it creates a linux domain socket to connect to server. So, if one instance is already using the socket to connect to server then the other instance will fail to connect. The sample log entry proves that...
-----------------
071230 14:24:50 mysqld ended

080309 13:42:18 mysqld started
080309 13:42:20 [ERROR] Can't start server : Bind on unix socket: Permission denied
080309 13:42:20 [ERROR] Do you already have another mysqld server running on socket: /opt/lampp/var/mysql/mysql.sock ?
080309 13:42:20 [ERROR] Aborting
----------------------

PLease provide the path where mysql is installed?

Thanks,
sir_com
 
Old 06-11-2008, 09:48 PM   #9
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,240

Rep: Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324
Actually its saying that he has one copy of the MySQL SERVER running and is trying to start another on the same machine. The client has nothing to do with it.
 
Old 06-11-2008, 10:49 PM   #10
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 234Reputation: 234Reputation: 234
Also if you read his reply, those logs he posted are from two months ago. The OP has stated that the MySQL server has crashed twice since the last log he's posted.
 
Old 06-12-2008, 12:07 AM   #11
Zeno McDohl
Member
 
Registered: Apr 2005
Location: Saratoga, NY
Distribution: Slackware
Posts: 316

Original Poster
Rep: Reputation: 30
Quote:
Originally Posted by trickykid View Post
Do you happen to have a /var/log/mysql.log? Sometimes that's a common place for mysql logs as well. And how was MySQL installed on this machine, what distro?
No such mysql.log file. I am using Slackware, and MySQL came with XAMPP.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
compiz failing, GLcore.so failing to load Schrambo Linux - Desktop 4 02-23-2008 07:13 PM
Remote MySQL connection failing jamsda Linux - Server 2 12-16-2007 07:21 PM
eth1 failing on boot, IEEE firewire card driver failing, help jackuss_169 Linux - Laptop and Netbook 5 03-05-2005 08:34 AM
LILO install failing, Boot failing, but Installation fine. sramelyk Slackware 9 08-23-2003 03:37 PM
X failing to load; AddScreen/InitScreen failing for driver 0 weblion Linux - Software 1 08-01-2002 07:14 AM


All times are GMT -5. The time now is 01:07 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration