| Bug #12601 | Error on ALTER TABLE to/from Archive engine | ||
|---|---|---|---|
| Submitted: | 16 Aug 2005 15:13 | Modified: | 25 Apr 2006 4:55 |
| Reporter: | Robin Schumacher | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Archive storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.0.11 | OS: | Linux (Linux or Windows XP) |
| Assigned to: | Brian Aker | CPU Architecture: | Any |
[16 Aug 2005 18:26]
MySQL Verification Team
miguel@hegel:~/dbs/5.0> bin/mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.12-beta-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table rms (c1 int) engine=myisam; Query OK, 0 rows affected (0.04 sec) mysql> alter table rms engine=archive; Query OK, 0 rows affected, 1 warning (0.15 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show warnings\G *************************** 1. row *************************** Level: Error Code: 7 Message: Error on rename of './test/#sql-1b44_4.ARN' to './test/rms.ARN' (Errcode: 2) 1 row in set (0.00 sec) mysql> show variables like "%have%"; +-----------------------+----------+ | Variable_name | Value | +-----------------------+----------+ | have_archive | YES |
[30 Aug 2005 13:32]
Magnus Blåudd
Related to already fixed Bug #9911 "RENAME TABLE of type ARCHIVE fails with .ARN file error".
Description: When altering a table from any engine to Archive, a warning is issued. Ditto from moving an Archive table to any other engine. How to repeat: mysql> create table rms (c1 int) engine=myisam; Query OK, 0 rows affected (0.11 sec) mysql> alter table rms engine=archive; Query OK, 0 rows affected, 1 warning (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show warnings; +-------+------+---------------------------------------------------------------- ------------+ | Level | Code | Message | +-------+------+---------------------------------------------------------------- ------------+ | Error | 7 | Error on rename of './gim/#sql-36ef_8.ARN' to './gim/rms.ARN' ( Errcode: 2) | +-------+------+---------------------------------------------------------------- ------------+ 1 row in set (0.00 sec) mysql> alter table rms engine=myisam; Query OK, 0 rows affected, 1 warning (0.05 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show warnings; +-------+------+---------------------------------------------------------------- -------------+ | Level | Code | Message | +-------+------+---------------------------------------------------------------- -------------+ | Error | 7 | Error on rename of './gim/rms.ARN' to './gim/#sql2-36ef-8.ARN' (Errcode: 2) | +-------+------+---------------------------------------------------------------- -------------+ 1 row in set (0.00 sec)