Bug 97093

Summary:	mysql upgrade package leaves mysql stopped after upgrade
Product:	[Retired] Red Hat Linux	Reporter:	Toni Willberg <toniw>
Component:	mysql	Assignee:	Patrick Macdonald <patrickm>
Status:	CLOSED WORKSFORME	QA Contact:	David Lawrence <dkl>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	7.3
Target Milestone:	---
Target Release:	---
Hardware:	i386
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2003-07-23 11:01:26 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Toni Willberg 2003-06-10 10:45:08 UTC

mysql-server-3.23.56-1.73


Upgrading the mysql-server package stops the server, upgrades the package but
fails to start the server again. No error is displayed during upgrade process:

$tail -f /var/log/messages &
$rpm -Uvh mysql-server.. mysql-devel.. mysql..

..
7:mysql-server   ########################################### [ 41%]
==> /var/log/messages <==
Jun 10 13:37:39 innostunutsonni mysqld: Stopping MySQL:  succeeded
Jun 10 13:37:40 innostunutsonni mysqld: Starting MySQL:  succeeded
8:mysql-devel    ########################################### [ 47%]
9:mysql          ########################################### [ 52%]
..

$service mysqld status
mysqld dead but subsys locked

$service mysqld stop
Stopping MySQL:                                            [FAILED]

$service mysqld start
Starting MySQL:                                            [  OK  ]

$service mysqld status
mysqld (pid 19379 19378 19377 19375) is running...


How reproducible:
Always

Comment 1 Patrick Macdonald 2003-06-10 16:25:37 UTC

This works fine for me.  Also, your /var/log/messages states that the mysqld
service was stopped at 13:37:39 and started at 13:37:40 (which is part of the 
mysql-server package upgrade).

Where there client connections to mysqld at the time of upgrade?

Anyway, here's the output of my logged testing run:

.live.[root@i386-73 mysql]# service mysqld start
Starting MySQL:                                            [  OK  ]

.live.[root@i386-73 mysql]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.54

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \s
--------------
mysql  Ver 11.18 Distrib 3.23.54, for pc-linux (i686)

  [snipped output]

.live.[root@i386-73 i386]# rpm -Fvh mysql-3.23.56-1.73.i386.rpm mysql-server-3.2
3.56-1.73.i386.rpm mysql-devel-3.23.56-1.73.i386.rpm
Preparing...                ########################################### [100%]
   1:mysql                  ########################################### [ 33%]
   2:mysql-server           ########################################### [ 66%]
   3:mysql-devel            ########################################### [100%]

.live.[root@i386-73 i386]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.56

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \s
--------------
mysql  Ver 11.18 Distrib 3.23.56, for pc-linux (i686)

Comment 2 Toni Willberg 2003-07-23 11:01:26 UTC

It seems to work now for me too. Let's reopen this if it happens again later.