MySQL 4.1.8a
Hi everyone,
It' s enough to despair:
After the update of my MySQl 4.1.7 to mysql 4.1.8a (Debian-Sarge)the
mysql server doesn't start anymore.
Can anyone give tips to fix the problems.
In the log-files I've found are following entries:
daemon.log from the day updating the system
Jan 8 14:01:49 localhost init: Trying to re-exec init
Jan 8 14:05:31 localhost mysqld[439]: 050108 14:05:30 [Note]
/usr/sbin/mysqld: Normal shutdown
Jan 8 14:05:31 localhost mysqld[439]:
Jan 8 14:05:31 localhost mysqld[439]: 050108 14:05:31 [Note]
/usr/sbin/mysqld: Shutdown complete
Jan 8 14:05:31 localhost mysqld[439]:
Jan 8 14:05:32 localhost /etc/init.d/mysql[3729]: 2 processes alive and
'/usr/bin/mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf ping'
resulted in
Jan 8 14:05:32 localhost /etc/init.d/mysql[3729]:
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 8 14:05:32 localhost /etc/init.d/mysql[3729]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 8 14:05:32 localhost /etc/init.d/mysql[3729]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 8 14:05:32 localhost /etc/init.d/mysql[3729]:
Jan 8 14:05:32 localhost mysqld_safe[3732]: ended
Jan 8 14:12:48 localhost mysqld_safe[5274]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Jan 8 14:12:48 localhost mysqld_safe[5274]: To do so, start the server,
then issue the following commands:
Jan 8 14:12:48 localhost mysqld_safe[5274]: /usr/bin/mysqladmin -u root
password 'new-password'
Jan 8 14:12:48 localhost mysqld_safe[5274]: /usr/bin/mysqladmin -u root
-h marcus password 'new-password'
Jan 8 14:12:48 localhost mysqld_safe[5274]: See the manual for more
instructions.
Jan 8 14:12:48 localhost mysqld_safe[5274]:
Jan 8 14:12:48 localhost mysqld_safe[5274]: NOTE: If you are upgrading
from a MySQL <= 3.22.10 you should run
Jan 8 14:12:48 localhost mysqld_safe[5274]: the
/usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
Jan 8 14:12:48 localhost mysqld_safe[5274]: able to use the new GRANT
command!
Jan 8 14:12:48 localhost mysqld_safe[5274]:
Jan 8 14:12:48 localhost mysqld_safe[5274]: Please report any problems
with the /usr/bin/mysqlbug script!
Jan 8 14:12:48 localhost mysqld_safe[5274]:
Jan 8 14:12:48 localhost mysqld_safe[5274]: The latest information
about MySQL is available on the web at
Jan 8 14:12:48 localhost mysqld_safe[5274]: http://www.mysql.com
Jan 8 14:12:48 localhost mysqld_safe[5274]: Support MySQL by buying
support/licenses at https://order.mysql.com
Jan 8 14:12:49 localhost mysqld_safe[5323]: ERROR: 1054 Unknown column
'Show_db_priv' in 'field list'
Jan 8 14:12:49 localhost mysqld_safe[5388]: started
Jan 8 14:12:49 localhost mysqld[5391]: 050108 14:12:49 [ERROR] bdb:
unable to initialize mutex: Function not implemented
Jan 8 14:12:49 localhost mysqld[5391]: 050108 14:12:49 [ERROR] bdb:
process-private: unable to initialize environment lock: Function not
implemented
Jan 8 14:12:49 localhost mysqld[5391]: 050108 14:12:49 [ERROR] Can't
init databases
Jan 8 14:12:49 localhost mysqld[5391]: 050108 14:12:49 [ERROR] Aborting
Jan 8 14:12:49 localhost mysqld[5391]:
Jan 8 14:12:49 localhost mysqld[5391]: 050108 14:12:49 [Note]
/usr/sbin/mysqld: Shutdown complete
Jan 8 14:12:49 localhost mysqld[5391]:
Jan 8 14:12:49 localhost mysqld_safe[5393]: ended
Jan 8 14:12:56 localhost /etc/init.d/mysql[5435]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf ping'
resulted in
Jan 8 14:12:56 localhost /etc/init.d/mysql[5435]:
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 8 14:12:56 localhost /etc/init.d/mysql[5435]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Jan 8 14:12:56 localhost /etc/init.d/mysql[5435]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 8 14:12:56 localhost /etc/init.d/mysql[5435]:
And the last syslog-file:
Jan 19 20:53:02 localhost /USR/SBIN/CRON[901]: (mail) CMD ( if [ -x
/usr/lib/exim/exim3 -a -f /etc/exim/exim.conf ]; then
/usr/lib/exim/exim3 -q ; fi)
Jan 19 20:55:46 localhost mysqld_safe[963]: started
Jan 19 20:55:46 localhost mysqld[966]: 050119 20:55:46 [ERROR] bdb:
unable to initialize mutex: Function not implemented
Jan 19 20:55:46 localhost mysqld[966]: 050119 20:55:46 [ERROR] bdb:
process-private: unable to initialize environment lock: Function not
implemented
Jan 19 20:55:46 localhost mysqld[966]: 050119 20:55:46 InnoDB: Started;
log sequence number 0 43634
Jan 19 20:55:46 localhost mysqld[966]: 050119 20:55:46 [ERROR] Can't
init databases
Jan 19 20:55:46 localhost mysqld[966]: 050119 20:55:46 [ERROR] Aborting
Jan 19 20:55:46 localhost mysqld[966]:
Jan 19 20:55:46 localhost mysqld[966]: 050119 20:55:46 InnoDB: Starting
shutdown...
Jan 19 20:55:49 localhost mysqld[966]: 050119 20:55:49 InnoDB: Shutdown
completed; log sequence number 0 43634
Jan 19 20:55:49 localhost mysqld[966]: 050119 20:55:49 [Note]
/usr/sbin/mysqld: Shutdown complete
Jan 19 20:55:49 localhost mysqld[966]:
Jan 19 20:55:49 localhost mysqld_safe[979]: ended
Jan 19 20:55:54 localhost /etc/init.d/mysql[1018]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-extra-file=/etc/mysql/debian.cnf ping'
resulted in
Jan 19 20:55:54 localhost /etc/init.d/mysql[1018]:
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 19 20:55:54 localhost /etc/init.d/mysql[1018]: error: 'Can't connect
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'
Jan 19 20:55:54 localhost /etc/init.d/mysql[1018]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 19 20:55:54 localhost /etc/init.d/mysql[1018]:
Jan 19 21:07:42 localhost apmd[377]: Suspending now
Jan 19 21:23:01 localhost /USR/SBIN/CRON[1084]: (mail) CMD ( if [ -x
/usr/lib/exim/exim3 -a -f /etc/exim/exim.conf ]; then
/usr/lib/exim/exim3 -q ; fi)
Jan 19 21:24:14 localhost apmd[377]: Suspending now
What's wrong?
Mechtilde
Reply to: