diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/doublewrite.result')
-rw-r--r-- | mysql-test/suite/innodb/r/doublewrite.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/doublewrite.result b/mysql-test/suite/innodb/r/doublewrite.result index 9a94a081abe..5adae545a71 100644 --- a/mysql-test/suite/innodb/r/doublewrite.result +++ b/mysql-test/suite/innodb/r/doublewrite.result @@ -4,6 +4,7 @@ # PAGE OF SYSTEM TABLESPACE # SET GLOBAL innodb_fast_shutdown = 0; +# restart show variables like 'innodb_doublewrite'; Variable_name Value innodb_doublewrite ON @@ -26,6 +27,8 @@ commit work; # tablespace is full of zeroes. select space from information_schema.innodb_sys_tables where name = 'test/t1' into @space_id; +Warnings: +Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead # Ensure that dirty pages of table t1 is flushed. flush tables t1 for export; unlock tables; @@ -41,6 +44,7 @@ set global innodb_buf_flush_list_now = 1; # full of zeroes. # # MDEV-11623: Use old FSP_SPACE_FLAGS in the doublewrite buffer. +# restart check table t1; Table Op Msg_type Msg_text test.t1 check status OK @@ -57,6 +61,8 @@ f1 f2 # tablespace is corrupted. select space from information_schema.innodb_sys_tables where name = 'test/t1' into @space_id; +Warnings: +Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead # Ensure that dirty pages of table t1 is flushed. flush tables t1 for export; unlock tables; @@ -69,6 +75,7 @@ set global innodb_fil_make_page_dirty_debug = @space_id; set global innodb_buf_flush_list_now = 1; # Kill the server # Corrupt the first page (page_no=0) of the user tablespace. +# restart check table t1; Table Op Msg_type Msg_text test.t1 check status OK @@ -85,6 +92,8 @@ f1 f2 # tablespace is full of zeroes. select space from information_schema.innodb_sys_tables where name = 'test/t1' into @space_id; +Warnings: +Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead # Ensure that dirty pages of table t1 is flushed. flush tables t1 for export; unlock tables; @@ -97,6 +106,7 @@ set global innodb_fil_make_page_dirty_debug = @space_id; set global innodb_buf_flush_list_now = 1; # Kill the server # Make the 2nd page (page_no=1) of the tablespace all zeroes. +# restart check table t1; Table Op Msg_type Msg_text test.t1 check status OK @@ -113,6 +123,8 @@ f1 f2 # tablespace is corrupted. select space from information_schema.innodb_sys_tables where name = 'test/t1' into @space_id; +Warnings: +Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead # Ensure that dirty pages of table t1 is flushed. flush tables t1 for export; unlock tables; @@ -125,6 +137,7 @@ set global innodb_fil_make_page_dirty_debug = @space_id; set global innodb_buf_flush_list_now = 1; # Kill the server # Corrupt the 2nd page (page_no=1) of the user tablespace. +# restart check table t1; Table Op Msg_type Msg_text test.t1 check status OK @@ -151,6 +164,7 @@ set global innodb_buf_flush_list_now = 1; # Kill the server # Make the first page (page_no=0) of the system tablespace # all zeroes. +# restart check table t1; Table Op Msg_type Msg_text test.t1 check status OK @@ -176,6 +190,7 @@ set global innodb_fil_make_page_dirty_debug = 0; set global innodb_buf_flush_list_now = 1; # Kill the server # Corrupt the first page (page_no=0) of the system tablespace. +# restart check table t1; Table Op Msg_type Msg_text test.t1 check status OK @@ -202,6 +217,7 @@ set global innodb_buf_flush_list_now = 1; # Kill the server # Make the 2nd page (page_no=1) of the system tablespace # all zeroes. +# restart check table t1; Table Op Msg_type Msg_text test.t1 check status OK @@ -228,6 +244,7 @@ set global innodb_buf_flush_list_now = 1; # Kill the server # Make the 2nd page (page_no=1) of the system tablespace # all zeroes. +# restart check table t1; Table Op Msg_type Msg_text test.t1 check status OK @@ -244,8 +261,10 @@ drop table t1; # MDEV-12600 crash during install_db with innodb_page_size=32K # and ibdata1=3M # +# restart: --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/doublewrite --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/doublewrite --innodb-data-file-path=ibdata1:1M;ibdata2:1M:autoextend SELECT * FROM INFORMATION_SCHEMA.ENGINES WHERE engine = 'innodb' AND support IN ('YES', 'DEFAULT', 'ENABLED'); ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS FOUND 1 /\[ERROR\] InnoDB: Cannot create doublewrite buffer/ in mysqld.1.err +# restart |