Listmates, MySQL died on my laptop after the latest package update. Looking at the logs, I think they are just the old logs and don't show much: [03:05 alchemy:~] # cat mysqld.log-20090411 090410 03:46:55 mysqld ended 090410 03:48:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 090410 3:48:17 InnoDB: Started; log sequence number 0 43655 090410 3:48:17 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated' 090410 3:48:17 [ERROR] Aborting 090410 3:48:17 InnoDB: Starting shutdown... 090410 3:48:21 InnoDB: Shutdown completed; log sequence number 0 43655 090410 3:48:21 [Warning] Forcing shutdown of 1 plugins 090410 3:48:21 [Note] /usr/sbin/mysqld: Shutdown complete 090410 03:48:22 mysqld_safe mysqld from pid file /var/run/mysql/protected/mysqld.pid ended Trying to start mysql results in a failed start: [02:53 alchemy:/home/david] # rcmysql start Updating MySQL privilege database... failed Looking at the installed mysql packages, something is definitely out of whack: [02:55 alchemy:/home/david] # rpm -qa | grep mysql libgda-3_0-mysql-3.1.2-42.1 libmysqlclient15-5.0.67-49.1 libmysqlclient16-5.1.33-26.1 libmysqlclient_r15-5.0.67-49.1 libmysqlclient_r16-5.1.33-26.1 mysql-5.1.33-26.1 mysql-client-5.1.33-26.1 Hmm, an overabundance of libmysqlclient, but how & how to fix? I'll try the removal of the libmysqlclient16 versions and if that fails, all of mysql and reinstall. Where did 16 come from? 03:09 alchemy:~> webpin -u libmysqlclient_r16 ... performing request on http://api.opensuse-community.org/searchservice/Search/Simple/openSUSE_110/l... 5 results (1 packages) found for "libmysqlclient_r16" in openSUSE_110 * libmysqlclient_r16: MySQL Shared Libraries - 5.1.33 [BS::server:/database:/mysql51 | BS::server:/database | BS::home:/NicoK:/server | BS::home:/fchua | BS::home:/bajizs_cnt] <snip> @ http://download.opensuse.org/repositories/server:/database/openSUSE_11.0 Thanks for the -u Anders;-) The biggest question is how did zypper allow this? Seems like installing 2 versions of the same package with foreseeable conflicting library files would have been caught. (1) First attempt at repair: Yast -> SW Management -> Search mysql -> Packages -> All packages in this list -> update if a newer version available Curious, yast didn't complain at all about both versions of libmysqlclient(15/16) being installed at the same time. Result: [03:18 alchemy:/home/david] # rcmysql start Updating MySQL privilege database... failed Nothing in syslog Exit status of rcmysql start: 1 /usr/sbin/rcmysql: # 1 - generic or unspecified error 03:37 alchemy:~> rpm -qa | grep mysql | sort libgda-3_0-mysql-3.1.2-42.1 libmysqlclient15-5.0.67-49.1 libmysqlclient16-5.1.33-27.1 libmysqlclient_r15-5.0.67-49.1 libmysqlclient_r16-5.1.33-27.1 mysql-5.1.33-26.1 mysql-client-5.1.33-26.1 (2) Second Attempt at repair: Yast -> SW Management -> Search mysql -> downgrade to libmysqlclient15-5.0.51a Result: WTF?? [03:48 alchemy:~] # rcmysql start Updating MySQL privilege database... failed [03:48 alchemy:~] # echo $? 1 [03:49 alchemy:~] # rpm -qa | grep mysql | sort libgda-3_0-mysql-3.1.2-42.1 libmysqlclient15-5.0.67-49.1 libmysqlclient_r15-5.0.67-49.1 mysql-5.0.51a-27.2 mysql-client-5.0.51a-27.2 [03:52 alchemy:/var/lib/mysql] # l total 20572 drwxr-xr-x 7 mysql mysql 4096 2009-04-14 03:46 ./ drwxr-xr-x 50 root root 4096 2009-04-13 05:01 ../ -rw-rw---- 1 mysql mysql 10485760 2009-04-14 03:25 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2009-04-14 03:25 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2008-07-27 13:12 ib_logfile1 drwx------ 2 mysql mysql 4096 2008-08-28 14:40 mysql/ -rw-rw---- 1 mysql mysql 5427 2009-04-14 03:48 mysqld.log -rw-rw---- 1 mysql mysql 435 2009-04-03 05:02 mysqld.log-20090403.bz2 -rw-rw---- 1 mysql mysql 235 2009-04-07 05:02 mysqld.log-20090407.bz2 -rw-rw---- 1 mysql mysql 249 2009-04-09 05:06 mysqld.log-20090409.bz2 -rw-r--r-- 1 mysql mysql 7 2008-07-27 13:12 mysql_upgrade_info drwx------ 2 mysql mysql 4096 2008-09-19 11:54 .protected/ -rw-r--r-- 1 mysql mysql 0 2009-04-14 03:46 .run-mysql_upgrade drwx------ 2 mysql mysql 4096 2009-03-07 01:34 test/ drwxr-xr-x 2 mysql mysql 4096 2008-09-19 11:54 .tmp/ drwx------ 2 mysql mysql 4096 2009-04-03 01:46 web/ Looks like a bloody mess! Since when are my log files now in /var/lib/mysql? Let's delete .run-mysql_upgrade and give it a go -- nope: [04:01 alchemy:/var/lib/mysql] # rcmysql start Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds done [04:02 alchemy:/var/lib/mysql] # rcmysql status Checking for service MySQL: unused OK, let's wipe everything out and give it another go: [04:05 alchemy:/var/lib] # rm -r mysql/ && rcmysql start Ooops! That was bad, good thing I used the old tar -cjf mysql_upgrade_mess.tar.bz2 (3) Third Attempt at repair: [04:12 alchemy:/var/lib] # tar -xjf /root/mysql_upgrade_mess.tar.bz2 Yast -> Repository Manager -> disable Build service - server Yast -> SW Management -> Search mysql -> downgrade all packages in red Result: 090414 04:16:31 mysqld started 090414 4:16:31 [ERROR] /usr/sbin/mysqld: unknown option '--skip-federated' 090414 04:16:31 mysqld ended WTF is --skip-federated? [04:20 alchemy:/var/lib] # mysqld 090414 4:20:36 [ERROR] mysqld: unknown option '--skip-federated' Alright where is the option my.cnf? [04:20 alchemy:/var/lib] # grep federated /etc/my.cnf skip-federated [04:21 alchemy:/var/lib] # vi /etc/my.cnf #skip-federated [04:22 alchemy:/var/lib] # rcmysql start Starting service MySQL done Well Son-of-a-Bitch, will you look at that! [04:23 alchemy:/var/lib] # mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51a SUSE MySQL RPM Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | | web | +--------------------+ 4 rows in set (0.00 sec) Looks like there was a problem with the openSuSE build service server/database mysql packages. Oh well, just another problem with build service. No use filing a bug report -- WON'T FIX. We'll just let the next guy bitten by the botched mysql packages for 11.0 figure it out himself ;-) -- David C. Rankin, J.D.,P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org