Mailinglist Archive: opensuse-bugs (4060 mails)

< Previous Next >
[Bug 496196] mysql packages broken in repositories/server:/database/openSUSE_11.0
  • From: bugzilla_noreply@xxxxxxxxxx
  • Date: Thu, 25 Jun 2009 14:06:11 -0600
  • Message-id: <20090625200611.27BC9CC7D1@xxxxxxxxxxxxxxxxxxxxxx>
http://bugzilla.novell.com/show_bug.cgi?id=496196

User drankinatty@xxxxxxxxxxxxxxxxxx added comment
http://bugzilla.novell.com/show_bug.cgi?id=496196#c12


David Rankin <drankinatty@xxxxxxxxxxxxxxxxxx> changed:

What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |ASSIGNED
Info Provider|drankinatty@suddenlinkmail. |
|com |




--- Comment #12 from David Rankin <drankinatty@xxxxxxxxxxxxxxxxxx> 2009-06-25
14:06:10 MDT ---
[14:19 ecstasy:/home/david] # zypper up -t package -r database
Downloading repository 'openSUSE BuildService - Database' metadata [done]
Building repository 'openSUSE BuildService - Database' cache [done]
Reading installed packages...

The following packages are going to be upgraded:
mysql-client mysql libmysqlclient16 libmysqlclient_r16


Overall download size: 10.7 M. After the operation, 2.1 M will be freed.
Continue? [YES/no]:
Downloading package libmysqlclient16-5.1.35-32.1.x86_64 (1/4), 490.0 K (1.4 M
unpacked)
Downloading: libmysqlclient16-5.1.35-32.1.x86_64.rpm [done (75.5 K/s)]
Installing: libmysqlclient16-5.1.35-32.1 [done]
Downloading package libmysqlclient_r16-5.1.35-32.1.x86_64 (2/4), 494.0 K (1.4 M
unpacked)
Downloading: libmysqlclient_r16-5.1.35-32.1.x86_64.rpm [done (94.8 K/s)]
Installing: libmysqlclient_r16-5.1.35-32.1 [done]
Downloading package mysql-client-5.1.35-32.1.x86_64 (3/4), 157.0 K (372.0 K
unpacked)
Downloading: mysql-client-5.1.35-32.1.x86_64.rpm [done (65.3 K/s)]
Installing: mysql-client-5.1.35-32.1 [done]
Downloading package mysql-5.1.35-32.1.x86_64 (4/4), 9.6 M (26.0 M unpacked)
Downloading: mysql-5.1.35-32.1.x86_64.rpm [done (132.3 K/s)]
Installing: mysql-5.1.35-32.1 [done]

Seems to be an issue with the "rcmysql status" response:

[14:29 ecstasy:/home/david] # rcmysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL done
[14:30 ecstasy:/home/david] # rcmysql status
Checking for service MySQL:

It isn't reporting that it is running for some reason??

Let's see:

[14:31 ecstasy:/etc] # l /var/run/mysql/
total 12
-rw-rw---- 1 mysql mysql 6 2009-06-25 14:30 mysqld.pid
[14:31 ecstasy:/etc] # l /var/lib/mysql | grep sock
srwxrwxrwx 1 mysql mysql 0 2009-06-25 14:30 mysql.sock=

pid is in /var/run/mysql/ .sock is in /var/lib/mysql/, seem to work fine
that way. I can get to all the database driven apps without any problems. So
that is fixed!

OK, let's test 10.3:

Current version: Server version: 5.0.67 SUSE MySQL RPM

[14:39 providence/home/david] # l /var/lib/mysql/
total 20556
drwxr-xr-x 6 mysql mysql 4096 2009-06-25 14:39 ./
drwxr-xr-x 50 root root 4096 2009-06-25 02:33 ../
-rw-rw---- 1 mysql mysql 10485760 2009-06-25 14:18 ibdata1
-rw-rw---- 1 mysql mysql 5242880 2009-06-25 14:39 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2009-06-25 14:17 ib_logfile1
drwx------ 2 mysql mysql 4096 2009-06-25 14:17 mysql/
-rw-rw---- 1 mysql mysql 2059 2009-06-25 14:39 mysqld.log
-rw-rw---- 1 mysql mysql 6 2009-06-25 14:39 mysqld.pid
srwxrwxrwx 1 mysql mysql 0 2009-06-25 14:39 mysql.sock=
-rw-r--r-- 1 mysql mysql 6 2009-06-25 14:17 mysql_upgrade_info

Prior to upgrade both .sock and .pid are in /var/lib/mysql/

Uh, Oh... Houston, we have a problem with 10.3:

[14:41 providence/home/david] # zypper up -t package -r database
Refreshing 'openSUSE BuildService - Database'
* Cleaning repository 'openSUSE BuildService - Database' cache
* Building repository 'openSUSE BuildService - Database' cache
* Reading repository 'openSUSE BuildService - Database' cache
* Reading installed packages [100%]


The following packages are going to be upgraded:
mysql-client mysql

The following NEW packages are going to be installed:
libmysqlclient16 libmysqlclient_r16

Overall download size: 12.7 M. After the operation, additional 4.9 M will be
used.
Continue? [yes/no]: yes
Downloading package libmysqlclient16-5.1.35-32.1.i586, 637.7 K (1.3 M unpacked)
Downloading: libmysqlclient16-5.1.35-32.1.i586.rpm
* Downloading [100%]
* Installing: libmysqlclient16-5.1.35-32.1 [100%]
Downloading package libmysqlclient_r16-5.1.35-32.1.i586, 648.5 K (1.3 M
unpacked)
Downloading: libmysqlclient_r16-5.1.35-32.1.i586.rpm
* Downloading [100%]
* Installing: libmysqlclient_r16-5.1.35-32.1 [100%]
Downloading package mysql-client-5.1.35-32.1.i586, 183.7 K (317.0 K unpacked)
Downloading: mysql-client-5.1.35-32.1.i586.rpm
* Downloading [100%]
* Installing: mysql-client-5.1.35-32.1 [100%]
Downloading package mysql-5.1.35-32.1.i586, 11.3 M (24.7 M unpacked)
Downloading: mysql-5.1.35-32.1.i586.rpm
* Downloading [100%]
* Installing: mysql-5.1.35-32.1 [100%]
[14:45 providence/home/david] # mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[14:45 providence/home/david] # rcmysql status
Checking for service MySQL: unused
[14:45 providence/home/david] # rcmysql start
Will update MySQL now, if you encounter any problems, please read following
file:
/usr/share/doc/packages/mysql/README.SuSE
Running protected MySQL...
error: /var/run/mysql/protected/mysql.sock file didn't appeared...
failed
[14:48 providence/home/david] # rcmysql status
Checking for service MySQL: unused
[14:48 providence/home/david] # l /etc/my.*
-rw-rw---- 1 mysql mysql 6336 2009-06-25 14:41 /etc/my.cnf
-rw-rw---- 1 mysql mysql 6273 2009-06-23 13:48 /etc/my.cnf.rpmnew
[14:48 providence/home/david] # mv /etc/my.cnf /etc/my.cnf.sav
[14:49 providence/home/david] # cp /etc/my.cnf.rpmnew /etc/my.cnf
[14:49 providence/home/david] # rcmysql start
Will update MySQL now, if you encounter any problems, please read following
file:
/usr/share/doc/packages/mysql/README.SuSE
Running protected MySQL...
Upgrading MySQL...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Running 'mysqlcheck'...
Running 'mysqlcheck'...
mysql.columns_priv OK
mysql.db OK
mysql.func OK
<snip>
Running 'mysql_fix_privilege_tables'...
OK
Starting service MySQL done

OK, except for the situation where the /etc/my.cnf has been modified
forcing the creation of /etc/my.cnf.rpmnew, the new packages work great! For
this response I did upgrades on 3 servers one 11.0 and two 10.3. All worked
fine after changing the my.cnf. I don't know how you handle the my.cnf issue.
The biggest problem that remains is that upon install, no notice is given that
mysql hasn't restarted until you manually check or hit one of your web pages.

Then, there needs to be something that tells the admin that the location of
the .pid file has changed and that to restart mysql, he will need to update
my.cnf or simply copy my.cnf.rpmnew over the existing my.cnf and restart mysql
to restore operation. Without some kinds of notice, the poor guy could be left
scratching his head for a while, checking mailing lists, googling bugs, etc.
unless he is told what has changes. Adding a post-install script that provides
that WARNING would be a great way to resolve the issue for this -- and -- then
next few updates (in case the user misses one or two of the updates)

With that, I think this bug is squashed!

--
Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

< Previous Next >