LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 04-24-2007, 03:04 AM   #1
bence8810
Member
 
Registered: Nov 2004
Location: Budapest, Hungary
Distribution: Debian
Posts: 110

Rep: Reputation: 15
MySQL Server crashes on Start - Debian Etch


Hi

I have my forum and Joomla websites hosted on my server which requires MySQL. It has been running just fine, until we had a power failure, and had to manually restart the server. Now all except MySQL seems to work.

My Joomla site is temporary unavailable, so I checked the logs, and I see that MySQL crashes with the following errors:

Code:
server:/home/bfrank# /etc/init.d/mysql start                                    Starting MySQL database server: mysqld...failed.
        Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
The file mysqld.sock really doesnt exist in /var/run/mysqld/ the folder is empty.

This is from Syslog:

Code:
Apr 24 07:53:14 server mysqld_safe[3834]: started
Apr 24 07:53:14 server mysqld[3838]: 070424  7:53:14 /usr/sbin/mysqld: unknown variable 'expire_logs_days=10'
Apr 24 07:53:14 server mysqld[3838]:
Apr 24 07:53:14 server mysqld_safe[3840]: ended
Apr 24 07:53:20 server /etc/init.d/mysql[3903]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Apr 24 07:53:20 server /etc/init.d/mysql[3903]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 24 07:53:20 server /etc/init.d/mysql[3903]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Apr 24 07:53:20 server /etc/init.d/mysql[3903]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Apr 24 07:53:20 server /etc/init.d/mysql[3903]:
Is there anything wrong with the expire_logs variable? If so, how should I correct it?

Can you give me any pointers where should I start digging? I am a new MySQL user, and have not much idea what might have gone wrong,

Thanks

Ben
 
Old 04-24-2007, 03:07 AM   #2
bence8810
Member
 
Registered: Nov 2004
Location: Budapest, Hungary
Distribution: Debian
Posts: 110

Original Poster
Rep: Reputation: 15
Hi

As an update, my site is up and running, by commenting out the expire_logs_days

However, it was working before just fine. Can someone tell me what could have gone wrong?

Thanks

Ben
 
Old 04-29-2007, 11:27 PM   #3
kdagnall
LQ Newbie
 
Registered: Nov 2005
Location: Berkeley CA
Distribution: Debian Etch
Posts: 3

Rep: Reputation: 0
Same problem

root@beast:~# mysqld restart
070429 20:23:21 mysqld: unknown variable 'expire_logs_days=10'

I have no clue what this means. Just crashed and started happening today.
 
Old 04-30-2007, 05:05 AM   #4
bence8810
Member
 
Registered: Nov 2004
Location: Budapest, Hungary
Distribution: Debian
Posts: 110

Original Poster
Rep: Reputation: 15
Hi

For me what fixed it is to comment out the line that the error is reported on.

You will find it in /etc/mysql/my.cnf

Code:
# WARNING: Using expire_logs_days without bin_log crashes the server! See README
.Debian!
#expire_logs_days       = 10
I just put the # mark in front of the expire_logs_days and restarted mysql. Works like a charm ever since.

Hope this helps,

Ben
 
Old 05-01-2007, 01:41 PM   #5
kdagnall
LQ Newbie
 
Registered: Nov 2005
Location: Berkeley CA
Distribution: Debian Etch
Posts: 3

Rep: Reputation: 0
Yea,
Figured it out from the code comments added by the debian team. It says
# "Warning this is broken!"
right above the offending line.

Wonder why this is enabled by default then??
 
Old 05-01-2007, 01:44 PM   #6
bence8810
Member
 
Registered: Nov 2004
Location: Budapest, Hungary
Distribution: Debian
Posts: 110

Original Poster
Rep: Reputation: 15
Good question. It only started to happen to me recently, so I guess the change came with some updates.

Ben
 
  


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
Amarok 1.4.4 crashes on startup on Debian Etch Ynot Irucrem Linux - Software 6 12-02-2007 05:23 AM
Debian Sarge to Etch Upgrade Caused X Windows to Not Start sabot Debian 1 04-11-2006 05:24 PM
Debian etch LAMP Server initialdrifteg6 Debian 3 02-05-2006 02:20 PM
Set mail server on Debian Etch SuSERNuke Linux - Networking 3 11-25-2005 02:54 PM
X server first start crashes girl1984 Linux - Newbie 3 06-16-2005 08:48 PM


All times are GMT -5. The time now is 05:54 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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration