PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : Plesk 7.5 nach mySQL-Update auf 4.1



HyperSurf
04.08.07, 22:06
Hallo,

ich habe per Anleitung aus http://forum.swsoft.com/showthread.php?threadid=30854&perpage=15&pagenumber=1 meinen mySQL-Server auf Version 4.1 upgedatet. Das ganze hat per "yum" soweit eigentlich alles wunderbar geklappt. mySQL-Info zeigt die entsprechende Version auch an.




[root@km20929-03 scripte]# yum upgrade mysql
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 3AS - Atomic PSA-Compatible RPMS
Finding updated packages
Downloading needed headers
Finding obsoleted packages
Resolving dependencies
.Dependencies resolved
I will do the following:
[update: mysql 4.1.21-2.rhel3.art.i386]
I will install/upgrade these to satisfy the dependencies:
[deps: mysql-compat 4.1.21-2.rhel3.art.i386]
[deps: mysql-server 4.1.21-2.rhel3.art.i386]
[deps: mysql-devel 4.1.21-2.rhel3.art.i386]
Is this ok [y/N]: y
Downloading Packages
Getting mysql-compat-4.1.21-2.rhel3.art.i386.rpm
mysql-compat-4.1.21-2.rhe 100% |=========================| 249 kB 00:00
Getting mysql-4.1.21-2.rhel3.art.i386.rpm
mysql-4.1.21-2.rhel3.art. 100% |=========================| 3.5 MB 00:05
Getting mysql-server-4.1.21-2.rhel3.art.i386.rpm
mysql-server-4.1.21-2.rhe 100% |=========================| 10 MB 00:16
Getting mysql-devel-4.1.21-2.rhel3.art.i386.rpm
mysql-devel-4.1.21-2.rhel 100% |=========================| 2.1 MB 00:03
Running test transaction:
Test transaction complete, Success!
mysql 100 % done 1/7
mysql-compat 100 % done 2/7
mysql-server 100 % done 3/7
mysql-devel 100 % done 4/7
Completing update for mysql - 5/7
Completing update for mysql-server - 6/7
Completing update for mysql-devel - 7/7
Updated: mysql 4.1.21-2.rhel3.art.i386
Dep Installed: mysql-compat 4.1.21-2.rhel3.art.i386 mysql-server 4.1.21-2.rhel3.art.i386 mysql-devel 4.1.21-2.rhel3.art.i386
Transaction(s) Complete



Nach dem Update hatte ich zuerst das Problem, dass mySQL nicht mehr starten wollte:


070804 21:24:02 mysqld ended

070804 21:24:03 mysqld started
070804 21:24:03 [ERROR] bdb: unable to initialize mutex: Function not implemented
070804 21:24:03 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
InnoDB: Resetting space id's in the doublewrite buffer
070804 21:24:03 InnoDB: Started; log sequence number 0 5908808
InnoDB: You are upgrading to an InnoDB version which allows multiple
InnoDB: tablespaces. Wait that purge and insert buffer merge run to
InnoDB: completion...
InnoDB: Full purge and insert buffer merge completed.
InnoDB: You have now successfully upgraded to the multiple tablespaces
InnoDB: format. You should NOT DOWNGRADE to an earlier version of
InnoDB: InnoDB! But if you absolutely need to downgrade, see
InnoDB: http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html
InnoDB: for instructions.
070804 21:24:05 [ERROR] Can't init databases
070804 21:24:05 [ERROR] Aborting

070804 21:24:05 InnoDB: Starting shutdown...
070804 21:24:07 InnoDB: Shutdown completed; log sequence number 0 5908935
070804 21:24:07 [Note] /usr/libexec/mysqld: Shutdown complete

070804 21:24:07 mysqld ended

070804 21:32:03 mysqld started
070804 21:32:04 [ERROR] bdb: unable to initialize mutex: Function not implemented
070804 21:32:04 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
070804 21:32:04 InnoDB: Started; log sequence number 0 5908935
070804 21:32:04 [ERROR] Can't init databases
070804 21:32:04 [ERROR] Aborting

070804 21:32:04 InnoDB: Starting shutdown...
070804 21:32:06 InnoDB: Shutdown completed; log sequence number 0 5908935
070804 21:32:06 [Note] /usr/libexec/mysqld: Shutdown complete

070804 21:32:06 mysqld ended

Dieses habe ich über die Parameter "skip-innodb" und "skip-bdb" übergangen, so dass die mySQL-Datenbank jetzt wieder startet und meine Foren etc. wieder laufen.

Jetzt funzt Plesk aber nicht mehr. In der mysql.log stehen jetzt auch wieder neue Einträge, die (vermute ich mal) die Ursache für die Probleme von Plesk sein werden:



070804 21:45:17 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
/usr/libexec/mysqld: ready for connections.
Version: '4.1.21' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
070804 21:45:23 [ERROR] /usr/libexec/mysqld: Can't find file: 'sa_conf.MYI' (errno: 2)
070804 21:45:23 [ERROR] /usr/libexec/mysqld: Can't find file: 'sa_conf.MYI' (errno: 2)
070804 21:45:23 [ERROR] /usr/libexec/mysqld: Can't find file: 'DomainServices.MYI' (errno: 2)
070804 21:45:23 [ERROR] /usr/libexec/mysqld: Can't find file: 'DomainServices.MYI' (errno: 2)
070804 21:46:17 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:46:17 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:46:17 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:46:17 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:46:24 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:46:24 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:46:24 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:46:24 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:47:51 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:47:51 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:47:51 [ERROR] /usr/libexec/mysqld: Can't find file: 'Components.MYI' (errno: 2)
070804 21:47:51 [ERROR] /usr/libexec/mysqld: Can't find file: 'Components.MYI' (errno: 2)
070804 21:48:03 [ERROR] /usr/libexec/mysqld: Can't find file: 'sa_conf.MYI' (errno: 2)
070804 21:48:03 [ERROR] /usr/libexec/mysqld: Can't find file: 'sa_conf.MYI' (errno: 2)
070804 21:48:03 [ERROR] /usr/libexec/mysqld: Can't find file: 'DomainServices.MYI' (errno: 2)
070804 21:48:03 [ERROR] /usr/libexec/mysqld: Can't find file: 'DomainServices.MYI' (errno: 2)
070804 21:48:04 [ERROR] /usr/libexec/mysqld: Can't find file: 'sessions.MYI' (errno: 2)
070804 21:48:04 [ERROR] /usr/libexec/mysqld: Can't find file: 'sessions.MYI' (errno: 2)
070804 21:48:04 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:48:04 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:48:04 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:48:04 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:48:05 [ERROR] /usr/libexec/mysqld: Can't find file: 'domains.MYI' (errno: 2)
070804 21:48:05 [ERROR] /usr/libexec/mysqld: Can't find file: 'domains.MYI' (errno: 2)
070804 21:48:09 [ERROR] /usr/libexec/mysqld: Can't find file: 'mail.MYI' (errno: 2)
070804 21:48:09 [ERROR] /usr/libexec/mysqld: Can't find file: 'mail.MYI' (errno: 2)
070804 21:48:26 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:26 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:28 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:28 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:31 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:31 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:31 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:48:31 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:48:31 [ERROR] /usr/libexec/mysqld: Can't find file: 'Components.MYI' (errno: 2)
070804 21:48:31 [ERROR] /usr/libexec/mysqld: Can't find file: 'Components.MYI' (errno: 2)
070804 21:48:31 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:31 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:36 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:36 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:39 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:39 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:39 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:48:39 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:48:39 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:39 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:39 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:39 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:45 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:45 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:46 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:46 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:50 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:48:50 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:27 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:27 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:33 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:33 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:33 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:49:33 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:49:33 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:33 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:33 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:33 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:41 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:41 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:41 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:41 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:41 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:41 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:47 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:48 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:49:48 [ERROR] /usr/libexec/mysqld: Can't find file: 'key_history.MYI' (errno: 2)
070804 21:49:48 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:49:48 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:50:02 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:50:02 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:50:18 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:50:18 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:50:18 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:50:18 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:51:56 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:51:56 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:51:56 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:51:56 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:52:09 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:52:09 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:52:09 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:52:09 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:52:21 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:52:21 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:52:21 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:52:21 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:52:21 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:52:21 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:52:21 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:52:21 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:53:46 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:46 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:46 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:46 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:48 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:48 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:48 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:53:48 [ERROR] /usr/libexec/mysqld: Can't find file: 'smtp_poplocks.MYI' (errno: 2)
070804 21:53:50 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:50 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:50 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:50 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:59 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:59 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:59 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:53:59 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:56:36 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 21:56:36 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 22:00:00 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 22:00:00 [ERROR] /usr/libexec/mysqld: Can't find file: 'misc.MYI' (errno: 2)
070804 22:00:00 [ERROR] /usr/libexec/mysqld: Can't find file: 'BackupTasks.MYI' (errno: 2)
070804 22:00:00 [ERROR] /usr/libexec/mysqld: Can't find file: 'BackupTasks.MYI' (errno: 2)



Hat jemand Erfahrung damit oder eine Idee wie ich die restlichen Fehler beheben kann?


Danke schonmal :)

mfg

Hyper

HyperSurf
04.08.07, 22:19
Hat sich erledigt. Vielen Dank an "^Winampbot^" aus dem #linux.de-Channel im Quakenet.

Nachdem ich das skip-innodb wieder rausgenommen und den Dienst neugestartet habe funktioniert wieder alles. Beim ersten Start des Dienstes nach dem Update hat er anscheinend alles konvertiert:D