| Bug #48354 | Information Schema Test fails on Windows | ||
|---|---|---|---|
| Submitted: | 27 Oct 2009 16:01 | Modified: | 28 Jan 2010 18:59 |
| Reporter: | Miguel Solorzano | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
| Version: | 5.0 | OS: | Windows (Vista 64-bit) |
| Assigned to: | CPU Architecture: | Any | |
[27 Oct 2009 16:01]
Miguel Solorzano
[27 Oct 2009 16:05]
MySQL Verification Team
It pass with 5.1: ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.information_schema [ pass ] 44402 ------------------------------------------------------------ The servers were restarted 0 times Spent 44.402 of 55 seconds executing testcases All 1 tests were successful. c:\build\mysql-5.1\mysql-test>
[11 Dec 2009 23:20]
MySQL Verification Team
Now it fails with the below messages: c:\build\5.0-build\mysql-test>perl mysql-test-run.pl information_schema Logging: mysql-test-run.pl information_schema MySQL Version 5.0.89 Disable Instance manager - testing not supported on Windows Skipping ndbcluster, mysqld not compiled with ndbcluster Setting mysqld to support SSL connections Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 9306 Using MASTER_MYPORT1 = 9307 Using SLAVE_MYPORT = 9308 Using SLAVE_MYPORT1 = 9309 Using SLAVE_MYPORT2 = 9310 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database ======================================================= Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- information_schema [ fail ] --- c:/build/5.0-build/mysql-test/r/information_schema.result Sat May 16 18:10:35 2009 +++ c:\build\5.0-build\mysql-test\r\information_schema.reject Fri Dec 11 21:18:36 2009 @@ -762,6 +762,9 @@ AND A.TABLE_NAME = B.TABLE_NAME); COUNT(*) 0 +Warnings: +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_2.MYI' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_2.MYI' (Errcode: 13) create table t1 ( x_bigint BIGINT, x_integer INTEGER, @@ -1203,6 +1206,10 @@ TRIGGERS TRIGGER_SCHEMA USER_PRIVILEGES GRANTEE VIEWS TABLE_SCHEMA +Warnings: +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYI' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYI' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYI' (Errcode: 13) SELECT t.table_name, c1.column_name FROM information_schema.tables t INNER JOIN @@ -1235,6 +1242,27 @@ TRIGGERS TRIGGER_SCHEMA USER_PRIVILEGES GRANTEE VIEWS TABLE_SCHEMA +Warnings: +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYI' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYI' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) +Warning 1 Can't create/write to file 'c:/build/5.0-build/mysql-test/var/tmp/#sql_4a4_3.MYD' (Errcode: 13) SELECT MAX(table_name) FROM information_schema.tables; MAX(table_name) VIEWS mysqltest: Result content mismatch Aborting: information_schema failed in default mode. To continue, re-run with '--force'. Stopping All Servers c:\build\5.0-build\mysql-test>
[28 Jan 2010 18:59]
MySQL Verification Team
Not repeatable anymore: Microsoft Windows [Version 6.0.6002] Copyright (c) 2006 Microsoft Corporation. All rights reserved. C:\build>cd 5.0 C:\build\5.0>cd mysql-test C:\build\5.0\mysql-test>perl mysql-test-run.pl information_schema Logging: mysql-test-run.pl information_schema MySQL Version 5.0.91 Disable Instance manager - testing not supported on Windows Skipping ndbcluster, mysqld not compiled with ndbcluster Setting mysqld to support SSL connections Using MTR_BUILD_THREAD = 0 Using MASTER_MYPORT = 9306 Using MASTER_MYPORT1 = 9307 Using SLAVE_MYPORT = 9308 Using SLAVE_MYPORT1 = 9309 Using SLAVE_MYPORT2 = 9310 Killing Possible Leftover Processes Removing Stale Files Creating Directories Installing Master Database ======================================================= Starting Tests in the 'main' suite TEST RESULT TIME (ms) ------------------------------------------------------- information_schema [ pass ] 30511 ------------------------------------------------------- Stopping All Servers All 1 tests were successful. The servers were restarted 1 times Spent 30.511 of 48 seconds executing testcases C:\build\5.0\mysql-test>
