Debian etch hangs on mysqld while booting

bidevi · 01-06-2009, 07:54 AM

Hi,

I'm running Debian Etch GNU/Linux with kernel 2.6.18-6-686 on 2 PC's. On PC #2, which I hadn't used for a while, all of the sudden Debian hangs while booting, on this line:

Starting MySQL database server: mysqld

I haven't the foggiest about what to do. Any help is welcome, but please keep your advice easy to follow.

eco · 01-07-2009, 03:44 AM

Hi,

You could always start in single user mode, disable MySQL at startup and then, once you booted again, check the logs and if necessary upgrade/downgrade. Your box would at least boot.

Just a thought.

bidevi · 01-07-2009, 12:55 PM

Thanx eco,

But it's too little info for me.

I start up in single user mode and get to the point where it says:

Give root password for maintenance

I type my root password and it says:

blah:~#

I type: /etc/init.d/mysql stop

I get:
Stopping MySQL database server: mysqld.

I haven't a clou what to do next. If you do I'd appreciate some hints.

Thanx,
Bidevi

repo · 01-07-2009, 01:01 PM

Quote:

I type my root password and it says:
blah:~#

Best is to type
chmod -x /etc/init.d/mysql

This will prevent the execution at boot.
Reboot your system.

Then do
blah:~#chmod +x /etc/init.d/mysql
blah:~#/etc/init.d/mysql start
and see if there are error messages in the log files.

bidevi · 01-08-2009, 02:49 AM

Thanx repo,

I was able to boot up following your instruction. Then, when I tried to restart mysql, Terminal said:

Starting MySQL database server: mysql*** glibc detected *** free(): invalid pointer: 0x08acfa50 ***

What could I do next?

Best,
Bidevi

repo · 01-08-2009, 05:00 AM

which version are you using?
try to upgrade to the latest version.

Also, do you use mysql?

bidevi · 01-08-2009, 05:07 AM

I executed apt-get update, also apt-get upgrade. I removed mysql server et cetera and reinstalled it. All to no avail.

And yes, I use mysql.

The thing is, I use this Debian version just for experiments, so it's no problem to do a complete new installation. But if this can happen here, it could happen on my other PC too, so I want to be able to solve it without trashing the whole thing and start anew.

Which brings me to the next point: what's the best way to make a complete backup of my system that could be transported to another PC?

repo · 01-08-2009, 05:36 AM

to find the version you are using
#apt-cache search mysql-server

Quote:

Which brings me to the next point: what's the best way to make a complete backup of my system that could be transported to another PC?

There ae several threads on this topic.

bidevi · 01-08-2009, 06:57 AM

This is the output:

cacti - Frontend to rddtool for monitoring systems and services
mysql-server - mysql database server (meta package depending on the latest version)
mysql-server-4.1 - mysql database server (transitional package)
mysql-server-5.0 - mysql database server binaries
phpbb2-conf-mysql - Automatic configurator for phpbb2 on MySQL database

repo · 01-08-2009, 07:05 AM

Perhaps this thread can give some pointers:
http://www.linuxquestions.org/questi...2c1120-345095/

bidevi · 01-08-2009, 07:11 AM

Thanx but no: too complicated. It's easier to reinstall Etch.

farslayer · 01-08-2009, 02:40 PM

did you just uninstall mysql-server-5.0 or did you purge it ?
I would have purged to get rid of the config files as well, so the re-install would have been clean.

aptitude purge mysql-server-5.0 mysql-common
aptitude clean
aptitude update
aptitude install mysql-server-5.0

I would check for version like this..

Code:

it-etch:~$ aptitude search ~i | grep mysql-server
i   mysql-server-5.0                - MySQL database server binaries   
         
it-etch:~$ apt-cache policy mysql-server-5.0
mysql-server-5.0:
  Installed: 5.0.51a-20
  Candidate: 5.0.51a-20
  Version table:
 *** 5.0.51a-20 0
        500 http://ftp.uwsg.indiana.edu lenny/main Packages
        100 /var/lib/dpkg/status