percona_skip_innodb_i_s test fails under Mac OS X

[Laurynas Biveinis]

innodb.percona_skip_innodb_i_s [ fail ]
        Test ended at 2014-06-03 13:20:36

CURRENT_TEST: innodb.percona_skip_innodb_i_s
--- /Users/laurynas/percona/lp-mysql-server/percona-server/5.5/mysql-test/suite/innodb/r/percona_skip_innodb_i_s.result 2014-04-09 20:21:26.000000000 +0300
+++ /Users/laurynas/percona/lp-mysql-server/percona-server/5.5/mysql-test/suite/innodb/r/percona_skip_innodb_i_s.reject 2014-06-03 13:20:36.000000000 +0300
@@ -32,88 +32,88 @@
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS;
 TABLE_ID NAME POS MTYPE PRTYPE LEN
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_COLUMNS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_columns but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_RSEG;
 rseg_id space_id zip_size page_no max_size curr_size
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_RSEG but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_rseg but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMP;
 page_size compress_ops compress_ops_ok compress_time uncompress_ops uncompress_time
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_CMP but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_cmp but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
 trx_id trx_state trx_started trx_requested_lock_id trx_wait_started trx_weight trx_mysql_thread_id trx_query trx_operation_state trx_tables_in_use trx_tables_locked trx_lock_structs trx_lock_memory_bytes trx_rows_locked trx_rows_modified trx_concurrency_tickets trx_isolation_level trx_unique_checks trx_foreign_key_checks trx_last_foreign_key_error trx_adaptive_hash_latched trx_adaptive_hash_timeout
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_TRX but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_trx but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS;
 TABLE_ID SCHEMA NAME STATS_INITIALIZED NUM_ROWS CLUST_INDEX_SIZE OTHER_INDEX_SIZE MODIFIED_COUNTER AUTOINC MYSQL_HANDLES_OPENED
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_tablestats but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
 requesting_trx_id requested_lock_id blocking_trx_id blocking_lock_id
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_LOCK_WAITS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_lock_waits but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
 lock_id lock_trx_id lock_mode lock_type lock_table lock_index lock_space lock_page lock_rec lock_data
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_LOCKS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_locks but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS;
 ID FOR_COL_NAME REF_COL_NAME POS
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_foreign_cols but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMP_RESET;
 page_size compress_ops compress_ops_ok compress_time uncompress_ops uncompress_time
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_CMP_RESET but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_cmp_reset but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES;
 page_type space_id page_no lru_position fix_count flush_type
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_buffer_pool_pages but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES;
 TABLE_ID SCHEMA NAME FLAG N_COLS SPACE
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_TABLES but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_tables but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_INDEX;
 index_id space_id page_no n_recs data_size hashed access_time modified dirty old lru_position fix_count flush_type
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_INDEX but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_buffer_pool_pages_index but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMPMEM;
 page_size buffer_pool_instance pages_used pages_free relocation_ops relocation_time
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_CMPMEM but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_cmpmem but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_BLOB;
 space_id page_no compressed part_len next_page_no lru_position fix_count flush_type
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_BLOB but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_buffer_pool_pages_blob but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMPMEM_RESET;
 page_size buffer_pool_instance pages_used pages_free relocation_ops relocation_time
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_CMPMEM_RESET but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_cmpmem_reset but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS;
 INDEX_ID NAME POS
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_FIELDS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_fields but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLE_STATS;
 table_schema table_name rows clust_size other_size modified
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_TABLE_STATS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_table_stats but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_STATS;
 INDEX_ID KEY_COLS DIFF_VALS NON_NULL_VALS
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_STATS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_stats but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN;
 ID FOR_NAME REF_NAME N_COLS TYPE
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_FOREIGN but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_foreign but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_INDEX_STATS;
 table_schema table_name index_name fields rows_per_key index_total_pages index_leaf_pages
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_INDEX_STATS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_index_stats but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES;
 INDEX_ID NAME TABLE_ID TYPE N_FIELDS PAGE_NO SPACE
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_INDEXES but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_indexes but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.XTRADB_ADMIN_COMMAND;
 result_message
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.XTRADB_ADMIN_COMMAND but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.xtradb_admin_command but the InnoDB storage engine is not installed

mysqltest: Result content mismatch

[Paul Namuag (paul-namuag)]

Verified as well in my Mac OS X.

OS version: OS X 10.9.3 (13D65)
Server: 5.5.37-35.1

macmini@/usr/local/percona-server-5.5.37-35.1/mysql-test #> MTR_BUILD_THREAD=auto ./mtr --force --max-test-fail=1 percona_skip_innodb_i_s
defined(@array) is deprecated at lib/mtr_cases.pm line 339.
 (Maybe you should just omit the defined()?)
defined(@array) is deprecated at ./mtr line 493.
 (Maybe you should just omit the defined()?)
Logging: ./mtr --force --max-test-fail=1 percona_skip_innodb_i_s
140606 21:50:46 [Warning] Setting lower_case_table_names=2 because file system for /tmp/S46T4VAo2Y/ is case insensitive
140606 21:50:46 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.5.37
Checking supported features...
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Checking leftover processes...
Removing old var directory...
Creating var directory '/usr/local/percona-server-5.5.37-35.1/mysql-test/var'...
Installing system database...

==============================================================================

TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
innodb.percona_skip_innodb_i_s [ fail ]
        Test ended at 2014-06-06 21:51:05

CURRENT_TEST: innodb.percona_skip_innodb_i_s
--- /usr/local/percona-server-5.5.37-35.1/mysql-test/suite/innodb/r/percona_skip_innodb_i_s.result 2014-06-02 01:25:00.000000000 +0300
+++ /usr/local/percona-server-5.5.37-35.1/mysql-test/suite/innodb/r/percona_skip_innodb_i_s.reject 2014-06-06 16:51:05.000000000 +0300
@@ -32,88 +32,88 @@
 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS;
 TABLE_ID NAME POS MTYPE PRTYPE LEN
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_SYS_COLUMNS but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_sys_columns but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_RSEG;
 rseg_id space_id zip_size page_no max_size curr_size
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_RSEG but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_rseg but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMP;
 page_size compress_ops compress_ops_ok compress_time uncompress_ops uncompress_time
 Warnings:
-Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.INNODB_CMP but the InnoDB storage engine is not installed
+Warning 1012 InnoDB: SELECTing from INFORMATION_SCHEMA.innodb_cmp but the InnoDB storage engine is not installed
 SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
 trx_id trx_state trx_started trx_requested_lock_id trx_wait_started trx_weight trx_mysql_thread_id trx_query trx_operation_state trx_tables_in_use trx_tables_locked trx_lock_structs trx_lock_memory_bytes trx_rows_locked trx_rows_modified trx_concurrency_tickets trx_isolation_level trx_unique_chec...

[Valerii Kravchuk (valerii-kravchuk)]

Test case on 5.6 is different by content (for whatever reason), so 5.6 is NOT affected formally:

openxs@ao756:~/bzr/percona-5.6$ cat mysql-test/suite/innodb/t/percona_skip_innodb_i_s.test
# we just test that we don't crash. The SELECT below is to ensure we update the test if we add I_S tables for INNODB or XTRADB

call mtr.add_suppression(".*Info table is not ready to be used.*");

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='INFORMATION_SCHEMA' AND TABLE_NAME LIKE 'INNODB%' ORDER BY TABLE_NAME;
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='INFORMATION_SCHEMA' AND TABLE_NAME LIKE 'XTRADB%' ORDER BY TABLE_NAME;
openxs@ao756:~/bzr/percona-5.6$ cat mysql-test/suite/innodb/r/percona_skip_innodb_i_s.result
call mtr.add_suppression(".*Info table is not ready to be used.*");
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='INFORMATION_SCHEMA' AND TABLE_NAME LIKE 'INNODB%' ORDER BY TABLE_NAME;
TABLE_NAME
INNODB_BUFFER_PAGE
INNODB_BUFFER_PAGE_LRU
INNODB_BUFFER_POOL_STATS
INNODB_CHANGED_PAGES
INNODB_CMP
INNODB_CMPMEM
INNODB_CMPMEM_RESET
INNODB_CMP_PER_INDEX
INNODB_CMP_PER_INDEX_RESET
INNODB_CMP_RESET
INNODB_FT_BEING_DELETED
INNODB_FT_CONFIG
INNODB_FT_DEFAULT_STOPWORD
INNODB_FT_DELETED
INNODB_FT_INDEX_CACHE
INNODB_FT_INDEX_TABLE
INNODB_LOCKS
INNODB_LOCK_WAITS
INNODB_METRICS
INNODB_SYS_COLUMNS
INNODB_SYS_DATAFILES
INNODB_SYS_FIELDS
INNODB_SYS_FOREIGN
INNODB_SYS_FOREIGN_COLS
INNODB_SYS_INDEXES
INNODB_SYS_TABLES
INNODB_SYS_TABLESPACES
INNODB_SYS_TABLESTATS
INNODB_TRX
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='INFORMATION_SCHEMA' AND TABLE_NAME LIKE 'XTRADB%' ORDER BY TABLE_NAME;
TABLE_NAME
XTRADB_INTERNAL_HASH_TABLES
XTRADB_READ_VIEW
XTRADB_RSEG
openxs@ao756:~/bzr/percona-5.6$

[Paul Namuag (paul-namuag)]

This is as well affected in version 5.1. Below is the information of what I have,

OS version: OS X 10.9.3 (13D65)
Server: 5.1.73-rel14.11

/usr/local/Percona-Server-5.1.73-rel14.11/mysql-test@macmini #> MTR_BUILD_THREAD=auto ./mtr --force --max-test-fail=1 percona_skip_innodb_i_s
defined(@array) is deprecated at ./mtr line 450.
 (Maybe you should just omit the defined()?)
Logging: ./mtr --force --max-test-fail=1 percona_skip_innodb_i_s
140617 16:49:05 [Warning] Setting lower_case_table_names=2 because file system for /var/folders/h9/x43wvvts0h3gg1_xt3hmkhw40000gn/T/F50crVfZHa/ is case insensitive
MySQL Version 5.1.73
Checking supported features...
 - skipping ndbcluster
 - skipping SSL, mysqld not compiled with SSL
Collecting tests...
vardir: /usr/local/Percona-Server-5.1.73-rel14.11/mysql-test/var
Removing old var directory...
Creating var directory '/usr/local/Percona-Server-5.1.73-rel14.11/mysql-test/var'...
Installing system database...
Using server port 55874

==============================================================================

TEST RESULT TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: Process [mysqld.1 - pid: 34804, winpid: 34804, exit: 512] died
innodb_plugin.percona_skip_innodb_i_s [ fail ]
        Test ended at 2014-06-17 16:49:10

Server log is:
140617 11:49:10 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
140617 11:49:10 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/Percona-Server-5.1.73-rel14.11/mysql-test/var/mysqld.1/data/ is case insensitive
140617 11:49:10 [Warning] /usr/local/Percona-Server-5.1.73-rel14.11/sql/mysqld: unknown variable 'loose-innodb_data_file_path=ibdata1:10M:autoextend'
140617 11:49:10 [Warning] /usr/local/Percona-Server-5.1.73-rel14.11/sql/mysqld: unknown option '--loose-skip-innodb'
140617 11:49:10 [ERROR] /usr/local/Percona-Server-5.1.73-rel14.11/sql/mysqld: unknown option '--skip-innodb'
140617 11:49:10 [ERROR] Aborting

140617 11:49:10 [Note] /usr/local/Percona-Server-5.1.73-rel14.11/sql/mysqld: Shutdown complete

Failed to start mysqld.1

 - saving '/usr/local/Percona-Server-5.1.73-rel14.11/mysql-test/var/log/innodb_plugin.percona_skip_innodb_i_s/' to '/usr/local/Percona-Server-5.1.73-rel14.11/mysql-test/var/log/innodb_plugin.percona_skip_innodb_i_s/'
The servers were restarted 0 times
Spent 0.000 of 5 seconds executing testcases

Too many failed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): innodb_plugin.percona_skip_innodb_i_s

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

Too many tests(1) failed! Terminating...
mysql-test-run: *** ERROR: Test suite aborted

/usr/local/Percona-Server-5.1.73-rel14.11/mysql-test@macmini #> cat ./suite/innodb_plugin/r/percona_skip_innodb_i_s.result
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABL...

[Paul Namuag (paul-namuag)]

Affected and have been tested in 5.1.73 version.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3145