| Bug #19406 | Tests with expected failures, fails with wrong error code on Windows x64 | ||
|---|---|---|---|
| Submitted: | 27 Apr 2006 18:23 | Modified: | 28 Mar 2007 12:43 |
| Reporter: | Kent Boortz | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Backup | Severity: | S3 (Non-critical) |
| Version: | 5.0.21 | OS: | Windows (Windows 2003 x64) |
| Assigned to: | Magnus Blåudd | CPU Architecture: | Any |
[27 Apr 2006 18:23]
Kent Boortz
[27 Apr 2006 18:53]
Kent Boortz
This seems to be a more general problem create [ fail ] mysqltest: At line 29: query 'create table t2 engine=heap select * from t1' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... create_select_tmp [ fail ] mysqltest: At line 17: query 'select * from t2' failed with wrong errno 1017: 'Can't find file: './test/t2.frm' (errno: 9)', instead of 1146... errors [ fail ] mysqltest: At line 9: query 'insert into t1 values(1)' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... handler [ fail ] mysqltest: At line 425: query 'select * from t1' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... information_schema [ fail ] mysqltest: At line 390: query 'show create view v2' failed: 1017: Can't find file: '.\test\t1.frm' (errno: 9) innodb [ fail ] *** r/innodb.result Thu Apr 27 17:59:31 2006 --- r/innodb.reject Thu Apr 27 19:13:53 2006 *************** *** 1453,1459 **** test.t3 NULL test.t4 NULL Warnings: ! Error 1146 Table 'test.t4' doesn't exist checksum table t1, t2, t3, t4; Table Checksum test.t1 2948697075 --- 1453,1459 ---- test.t3 NULL test.t4 NULL Warnings: ! Error 1017 Can't find file: './test/t4.frm' (errno: 9) ... preload [ fail ] *** r/preload.result Thu Apr 27 17:59:31 2006 --- r/preload.reject Thu Apr 27 19:27:41 2006 *************** *** 143,152 **** Key_reads 0 load index into cache t3, t2 key (primary,b) ; Table Op Msg_type Msg_text ! test.t3 preload_keys error Table 'test.t3' doesn't exist test.t2 preload_keys status OK Warnings: ! Error 1146 Table 'test.t3' doesn't exist show status like "key_read%"; Variable_name Value Key_read_requests 478 --- 143,152 ---- Key_reads 0 load index into cache t3, t2 key (primary,b) ; Table Op Msg_type Msg_text ! test.t3 preload_keys error Can't find file: './test/t3.frm' (errno: 9) ... ps_1general [ fail ] mysqltest: At line 118: query 'prepare stmt1 from ' select * from not_exist where a <= 2 ' ' failed with wrong errno 1017: 'Can't find file: './test/not_exist.frm' (errno: 9)', instead of 1146... ps_grant [ fail ] mysqltest: At line 81: query 'execute s_t9 ' failed with wrong errno 1017: 'Can't find file: '.\mysqltest\t9.frm' (errno: 9)', instead of 1146... query_cache [ fail ] mysqltest: At line 397: query 'select * from t1 where id=2' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... repair [ fail ] *** r/repair.result Thu Apr 27 17:59:31 2006 --- r/repair.reject Thu Apr 27 19:31:48 2006 *************** *** 26,34 **** drop table t1; repair table t1 use_frm; Table Op Msg_type Msg_text ! test.t1 repair error Table 'test.t1' doesn't exist Warnings: ! Error 1146 Table 'test.t1' doesn't exist create table t1 engine=myisam SELECT 1,"table 1"; flush tables; repair table t1; --- 26,34 ---- drop table t1; repair table t1 use_frm; Table Op Msg_type Msg_text ! test.t1 repair error Can't find file: './test/t1.frm' (errno: 9) Warnings: ! Error 1017 Can't find file: './test/t1.frm' (errno: 9) create table t1 engine=myisam SELECT 1,"table 1"; flush tables; repair table t1; sp-error [ fail ] mysqltest: At line 1572: query 'create view v1 as select bug11555_1()' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... sp [ fail ] mysqltest: At line 1355: query 'select f10()' failed with wrong errno 1017: 'Can't find file: './test/t4.frm' (errno: 9)', instead of 1146... sql_mode [ fail ] mysqltest: At line 216: query 'show create table t1' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... subselect [ fail ] mysqltest: At line 524: query 'do (SELECT a from t1)' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... trigger [ fail ] mysqltest: At line 317: query 'create trigger trg before insert on t2 for each row set @a:=1' failed with wrong errno 1017: 'Can't find file: './test/t2.frm' (errno: 9)', instead of 1146... truncate [ fail ] mysqltest: At line 19: query 'select count(*) from t1' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... view [ fail ] mysqltest: At line 14: query 'create view v1 (c,d) as select a,b from t1' failed with wrong errno 1017: 'Can't find file: './test/t1.frm' (errno: 9)', instead of 1146... view_query_cache [ fail ] mysqltest: At line 73: query 'select * from v1' failed with wrong errno 1017: 'Can't find file: './test/v1.frm' (errno: 9)', instead of 1146...
[12 May 2006 17:11]
MySQL Verification Team
Kent, I'm getting this alot on our wind2003-amd64 machine. I've tried various my.ini tweaks, flush tables, etc, and cannot seem to recover except for shutdown of mysqld. The testcase for bug17750 used to crash, but now gives many, many of these errors: Can't find file: '.\xxx\ttt.frm' (errno: 9)
[21 Feb 2007 14:44]
Magnus Blåudd
Looks kind of weird. Kent, Does this occur on any of our build hosts?
