MySQL Bugs: #14314: Direct upgrade from 5.0.3 to 5.0.15 causes server crash

Bug #14314	Direct upgrade from 5.0.3 to 5.0.15 causes server crash
Submitted:	26 Oct 2005 1:35	Modified:	26 Nov 2005 7:32
Reporter:	John David Duncan	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.15	OS:	MacOS (Mac OS X 10.4)
Assigned to:		CPU Architecture:	Any

Description:
When I shut down a server running 5.0.3, install 5.0.15 on top of it, and then restart the server, mysqld crashes.

How to repeat:
Install MySQL 5.0.3.  
Create database d
use d
Create table t (i int, j int, primary key (i,j)) type = innodb.
insert into d values (3,5)
insert into d values (5,7)

mysqladmin shutdown

Install mysql 5.0.15

Start server

Suggested fix:
Detect the problem, write a warning message, and shut down cleanly.

Hi!

I tested an upgrade 5.0.4 to a 5.0.15 that was built on Oct 3 on Linux/x86.

heikki@hundin:~/mysql-5.0.4-beta/client> ./mysql test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.4-beta-log

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

mysql> Create database d
    -> use d
    -> Create table t (i int, j int, primary key (i,j)) type = innodb.
    -> insert into d values (3,5)
    -> insert into d values (5,7)
    ->
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'use d
Create table t (i int, j int, primary key (i,j)) type = innodb.
insert int' at line 2
mysql> Create database d;
Query OK, 1 row affected (0.01 sec)

mysql> use d;
Database changed
mysql> Create table t (i int, j int, primary key (i,j)) type = innodb;
Query OK, 0 rows affected, 1 warning (0.10 sec)

mysql> insert into d values (3,5);
ERROR 1146 (42S02): Table 'd.d' doesn't exist
mysql> insert into d values (5,7);
ERROR 1146 (42S02): Table 'd.d' doesn't exist
mysql> insert into t values (3,5);
Query OK, 1 row affected (0.03 sec)

mysql> insert into t values (5,7);
Query OK, 1 row affected (0.00 sec)

mysql> exit

..........

heikki@hundin:~/mysql-5.0/sql> ./mysqld
051026  7:00:09  InnoDB: Started; log sequence number 0 47250
051026  7:00:10 [Warning] mysql.user table is not updated to new password format
; Disabling new password usage until mysql_fix_privilege_tables is run
051026  7:00:10 [Note] ./mysqld: ready for connections.
Version: '5.0.15-rc-log'  socket: '/home/heikki/bugsocket'  port: 3307  Source d
istribution

No crash in this case. The system tables in datadir/mysql were from around version 5.0.10.

Please compile 5.0.15 with the -g flag on Mac OS X, run inside gdb, and post bt full from the crash.

Regards,

Heikki

Please, answer the questions from Heikki and reopen this bug report.

Have you performed the upgrade step described in http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-5-0.html? Server should not crash without it, but just to be sure what you did.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".