Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My System (Linux Debian) got updatet wirth

apt-get update apt-get upgrade

Everything got upgraded, also my mysql server. At the upgrade of mysql-server, I got a error message (unfortunately missing. It was at the, when I where asked for mysql admin password).

There was just "Retry" or "cancel". After Retry didnt work, I choosed cancel ...

Now the server can´t start anymore

Mysql Error Log: 110502 07:49:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 110502 7:49:48 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist 110502 7:49:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: No valid checkpoint found. InnoDB: If this error appears when you are creating an InnoDB database, InnoDB: the problem may be that during an earlier attempt you managed InnoDB: to create the InnoDB data files, but log file creation failed. InnoDB: If that is the case, please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html 110502 7:49:48 [ERROR] Plugin 'InnoDB' init function returned error. 110502 7:49:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 110502 7:49:48 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb' 110502 7:49:48 [ERROR] Aborting

110502 7:49:48 [Note] /usr/sbin/mysqld: Shutdown complete

110502 07:49:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


with the command "mysql_upgrade" it tells me: Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--socket=/var/run/mysqld/mysqld.sock' mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect FATAL ERROR: Upgrade failed


Status of the mysql-server-5.1 paket: Package: mysql-server-5.1 Status: install ok half-configured Priority: optional Section: misc Installed-Size: 13996 Maintainer: Debian MySQL Maintainers Architecture: i386 Source: mysql-5.1 Version: 5.1.49-3 Replaces: libmysqlclient-dev (<= 5.1.41-1), mysql-server (<< 5.1.49-3), mysql-server-5.0 Provides: mysql-server, mysql-server-5.0, virtual-mysql-server Depends: mysql-client-5.1 (>= 5.1.49-3), libdbi-perl, perl (>= 5.6), libc6 (>= 2.7), libgcc1 (>= 1:4.1.1), libmysqlclient16 (>= 5.1.21-1), libstdc++6 (>= 4.1.1), zlib1g (>= 1:1.1.4), debconf (>= 0.5) | debconf-2.0, psmisc, passwd, lsb-base (>= 3.0-10), mysql-server-core-5.1 (= 5.1.49-3) Pre-Depends: mysql-common (>= 5.1.49-3), adduser (>= 3.40), debconf Recommends: mailx, libhtml-template-perl Suggests: tinyca Conflicts: mysql-server (<< 5.1.49-3), mysql-server-4.1 Conffiles: /etc/logrotate.d/mysql-server 64e209fe34f73fbf10c9479bf30947c4 /etc/mysql/debian-start 4272e4d740c8ae651ac35bbf4d2ed6dc /etc/mysql/conf.d/mysqld_safe_syslog.cnf 347fa9f3d579ffc06c39bf7e69f4fc6e /etc/logcheck/ignore.d.workstation/mysql-server-5_1 2d34a7ed83fefc165cd1dfea3a72ccc8 /etc/logcheck/ignore.d.server/mysql-server-5_1 2d34a7ed83fefc165cd1dfea3a72ccc8 /etc/logcheck/ignore.d.paranoid/mysql-server-5_1 6babe46e791059cdd5a26f4f7fec9eca /etc/init.d/mysql ea6d050ac82ed69d01970f9b95ab9b9d


What I already tried: apt mirror got updatet

aptitude remove mysql-server-5.1 aptitude install mysql-server-5.1

aptitude update aptitude full-upgrade


After "aptitude full-upgrade" it shows me (Language: german):

Die folgenden teilweise installierten Pakete werden konfiguriert: mysql-server-5.1 Es werden keine Pakete installiert, aktualisiert oder entfernt. 0 Pakete aktualisiert, 0 zusätzlich installiert, 0 werden entfernt und 0 nicht aktualisiert. Muss 0 B an Archiven herunterladen. Nach dem Entpacken werden 0 B zusätzlich belegt sein. mysql-server-5.1 (5.1.49-3) wird eingerichtet ... Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed. dpkg: Fehler beim Bearbeiten von mysql-server-5.1 (--configure): Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurück configured to not write apport reports Fehler traten auf beim Bearbeiten von: mysql-server-5.1 E: Sub-process /usr/bin/dpkg returned an error code (1) Ein Paket konnte nicht installiert werden. Versuche zu lösen: mysql-server-5.1 (5.1.49-3) wird eingerichtet ... Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action "start" failed. dpkg: Fehler beim Bearbeiten von mysql-server-5.1 (--configure): Unterprozess installiertes post-installation-Skript gab den Fehlerwert 1 zurück Fehler traten auf beim Bearbeiten von: mysql-server-5.1

Can anyone tell me, what to do now?

share|improve this question

1 Answer 1

Have you tried with removing or commenting "skip-bdb" from /etc/mysql/my.cnf? See MySQL bug 50336: http://bugs.mysql.com/bug.php?id=50336

share|improve this answer
    
Thanks! That was the problem. Thanks very much ...! –  user80090 May 2 '11 at 10:37
    
And now you're supposed to give me some "credit-points" in return. ;-) –  Henk May 2 '11 at 14:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.