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: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.15 | OS: | MacOS (Mac OS X 10.4) |
Assigned to: | CPU Architecture: | Any |
[26 Oct 2005 1:35]
John David Duncan
[26 Oct 2005 3:55]
Heikki Tuuri
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
[26 Oct 2005 7:32]
Valeriy Kravchuk
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.
[27 Nov 2005 0:00]
Bugs System
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".