mysql fails to startup after upgrading fc10->fc11

[bbobbo]

are you trying to reinstall mysql-libs? i don't think you need to touch that. as far as i can tell, you can install mysql and mysql-server without touching mysql-libs.

it would really be a lot easier if you posted the results of the commands you ran--otherwise, i'm left trying to guess exactly what you did.

[tamar]

No, I removed mysql, mysql-devel, and mysql-server. Now I am trying to reinstall the fc10 versions.

# rpm -ivh --nodeps http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-5.0.83-2.fc10.i386.rpm http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-devel-5.0.83-2.fc10.i386.rpm http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-server-5.0.83-2.fc10.i386.rpm http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-libs-5.0.83-2.fc10.i386.rpm
Retrieving http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-5.0.83-2.fc10.i386.rpm
Retrieving http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-devel-5.0.83-2.fc10.i386.rpm
Retrieving http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-server-5.0.83-2.fc10.i386.rpm
Retrieving http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-libs-5.0.83-2.fc10.i386.rpm
Preparing...                ########################################### [100%]
        package mysql-libs-5.1.36-1.fc11.i586 (which is newer than mysql-libs-5.0.83-2.fc10.i386) is already installed
        file /etc/ld.so.conf.d/mysql-i386.conf from install of mysql-libs-5.0.83-2.fc10.i386 conflicts with file from package mysql-libs-5.1.36-1.fc11.i586
        file /etc/my.cnf from install of mysql-libs-5.0.83-2.fc10.i386 conflicts with file from package mysql-libs-5.1.36-1.fc11.i586
        file /usr/share/mysql/charsets/Index.xml from install of mysql-libs-5.0.83-2.fc10.i386 conflicts with file from package mysql-libs-5.1.36-1.fc11.i586
...snip

It's a mess now

[P38Lightning]

Originally Posted by monkeypet

Hi, After upgrading from fc10->fc11, mysql fails to startup with the following in /var/log/mysql*

090626 02:37:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090626  2:37:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090626  2:37:20  InnoDB: Started; log sequence number 0 29288572
090626  2:37:20 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect key file for table 'host'; try to repair it

I can get it to startup if I add '--skip-grant' to the mysqld_safe line in the /etc/init.d/mysqld file.

Running mysqlcheck --databases mysql reveals the following, repairing it does nothing:

[root@mythtv mysql]# mysqlcheck --databases mysql
mysql.columns_priv
Error    : Incorrect key file for table 'columns_priv'; try to repair it
error    : Corrupt
mysql.db
Error    : Incorrect key file for table 'db'; try to repair it
error    : Corrupt
mysql.event                                        OK
mysql.func
Error    : Incorrect key file for table 'func'; try to repair it
error    : Corrupt
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host
Error    : Incorrect key file for table 'host'; try to repair it
error    : Corrupt
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv
Error    : Incorrect key file for table 'tables_priv'; try to repair it
error    : Corrupt
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user
Error    : Incorrect key file for table 'user'; try to repair it
error    : Corrupt

I am guessing that if I can't figure it out, I'll nuke the db and reinitialize it restoring from the backups.

I have had problems with upgrading fedora. I found that the best was to go ahead and back up my data, and format my drive and just start with the new version fresh.

[tamar]

Thanks fedora 6 but I can't do that and I'm not the OP.

[bbobbo]

Originally Posted by tamar

No, I removed mysql, mysql-devel, and mysql-server. Now I am trying to reinstall the fc10 versions.

# rpm -ivh --nodeps http://download.fedora.redhat.com/pu....fc10.i386.rpm http://download.fedora.redhat.com/pu....fc10.i386.rpm http://download.fedora.redhat.com/pu....fc10.i386.rpm http://download.fedora.redhat.com/pub/fedora/linux/updates/10/i386/mysql-libs-5.0.83-2.fc10.i386.rpm

yes, you are trying to reinstall mysql-libs (the last item in your rpm command). as i stated before, only install mysql and mysql-server. don't install mysql-devel or mysql-libs.

[tamar]

oops, good call... I thought I removed that. Let's see what this does.

[tamar]

This is evil

# mysql_upgrade
mysql_upgrade: /usr/lib/mysql/libmysqlclient.so.15: no version information available (required by mysql_upgrade)
mysql_upgrade: relocation error: mysql_upgrade: symbol handle_options, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference

and....

# ldd /usr/bin/mysql_upgrade
/usr/bin/mysql_upgrade: /usr/lib/mysql/libmysqlclient.so.15: no version information available (required by /usr/bin/mysql_upgrade)
        linux-gate.so.1 =>  (0x00c8f000)
        libmysqlclient.so.15 => /usr/lib/mysql/libmysqlclient.so.15 (0x0038c000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x0035b000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x071a6000)
        libm.so.6 => /lib/libm.so.6 (0x003c7000)
        libssl.so.7 => /usr/lib/libssl.so.7 (0x00cee000)
        libcrypto.so.7 => /usr/lib/libcrypto.so.7 (0x00ad8000)
        libz.so.1 => /lib/libz.so.1 (0x00415000)
        libc.so.6 => /lib/libc.so.6 (0x00428000)
        libfreebl3.so => /lib/libfreebl3.so (0x008eb000)
        /lib/ld-linux.so.2 (0x0022f000)
        libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x00c46000)
        libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00a03000)
        libcom_err.so.2 => /lib/libcom_err.so.2 (0x009f9000)
        libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00aad000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x009d8000)
        libdl.so.2 => /lib/libdl.so.2 (0x003f1000)
        libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x00aa1000)
        libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x009fe000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x003f8000)
        libselinux.so.1 => /lib/libselinux.so.1 (0x00110000)

[bbobbo]

okay, it looks like mysql_upgrade relies on libssl.so.7 and libcrypto.so.7, and probably on the old version of mysql-libs.

i'm out of "easy" answers...the last thing i can think of would be to copy the mysql files over to a fedora 10 machine and do the updates there, but of course i'm guessing you don't have another fedora 10 machine or you would have done this already.

my recommendation:

1) install virtualbox
2) install fedora 10 as a virtual os within virtualbox
3) copy the mysql files over
4) run mysql_upgrade
5) copy the files back over to your fedora 11 installation
6) run mysql_upgrade again

sounds convoluted, i know. but that's the best i can come up with at the moment.

[tamar]

hmm, yeah, that's a pain.

I assume the only corrupted table here is "mysql." Is there any way I can just uh, create it from scratch and associate it with the usernames/other databases later?

[bbobbo]

i'm not sure you can assume that the only corrupted database is `mysql`. but if that's the case i think what you're saying will work. update back to mysql-5.1.36-1, start and stop mysqld, then copy all the other database directories into /var/lib/mysql. then try mysql_upgrade again.

then fill in the 'db' and 'user' tables in the `mysql` database with the appropriate data. or maybe you have to fill in that data before doing mysql_upgrade.

[tamar]

I actually think that did it Thanks for your help!