Skip to main content

debian - Mysql-Server-5.1 upgrade problem

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?

Comments

Post a Comment

Popular posts from this blog

linux - Awstats - outputting stats for merged Access_logs only producing stats for one server's log

I've been attempting this for two weeks and I've accessed countless number of sites on this issue and it seems there is something I'm not getting here and I'm at a lost. I manged to figure out how to merge logs from two servers together. (Taking care to only merge the matching domains together) The logs from the first server span from 15 Dec 2012 to 8 April 2014 The logs from the second server span from 2 Mar 2014 to 9 April 2014 I was able to successfully merge them using the logresolvemerge.pl script simply enermerating each log and > out_putting_it_to_file Looking at the two logs from each server the format seems exactly the same. The problem I'm having is producing the stats page for the logs. The command I've boiled it down to is /usr/share/awstats/tools/awstats_buildstaticpages.pl -configdir=/home/User/Documents/conf/ -config=example.com awstatsprog=/usr/share/awstats/wwwroot/cgi-bin/awstats.pl dir=/home/User/Documents/parced -month=all -year=all...
Post a Comment
Read more

iLO 3 Firmware Update (HP Proliant DL380 G7)

The iLO web interface allows me to upload a .bin file ( Obtain the firmware image (.bin) file from the Online ROM Flash Component for HP Integrated Lights-Out. ) The iLO web interface redirects me to a page in the HP support website ( http://www.hp.com/go/iLO ) where I am supposed to find this .bin firmware, but no luck for me. The support website is a mess and very slow, badly categorized and generally unusable. Where can I find this .bin file? The only related link I am able to find asks me about my server operating system (what does this have to do with the iLO?!) and lets me download an .iso with no .bin file And also a related question: what is the latest iLO 3 version? (for Proliant DL380 G7, not sure if the iLO is tied to the server model)
Post a Comment
Read more

hp proliant - Smart Array P822 with HBA Mode?

We get an HP DL360 G8 with an Smart Array P822 controller. On that controller will come a HP StorageWorks D2700 . Does anybody know, that it is possible to run the Smart Array P822 in HBA mode? I found only information about the P410i, who can run HBA. If this is not supported, what you think about the LSI 9207-8e controller? Will this fit good in that setup? The Hardware we get is used but all original from HP. The StorageWorks has 25 x 900 GB SAS 10K disks. Because the disks are not new I would like to use only 22 for raid6, and the rest for spare (I need to see if the disk count is optimal or not for zfs). It would be nice if I'm not stick to SAS in future. As OS I would like to install debian stretch with zfs 0.71 as file system and software raid. I have see that hp has an page for debian to. I would like to use hba mode because it is recommend, that zfs know at most as possible about the disk, and I'm independent from the raid controller. For us zfs have many benefits, ...
Post a Comment
Read more