Debian Codegraph @

mysql-test/suite/maria/maria-gis-recovery.result

raw
1 set global aria_log_file_size=4294967295;
2 Warnings:
3 Warning 1292 Truncated incorrect aria_log_file_size value: '4294967295'
4 drop database if exists mysqltest;
5 create database mysqltest;
6 connect admin, localhost, root,,mysqltest,,;
7 connection default;
8 use mysqltest;
9 connection default;
10 connection admin;
11 * shut down mysqld, removed logs, restarted it
12 connection default;
13 CREATE TABLE t1 (
14 i int,
15 shape GEOMETRY NOT NULL,
16 SPATIAL (shape)
17 ) ENGINE=ARIA;
18 insert into t1 values(1,POINT(1, 1));
19 connection admin;
20 * copied t1 for feeding_recovery
21 connection default;
22 insert into t1 values(2,POINT(2, 2)), (3,POINT(3, 3)), (4,POINT(4, 4));
23 connection admin;
24 flush table t1;
25 * copied t1 for comparison
26 connection default;
27 connection admin;
28 SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash";
29 * crashing mysqld intentionally
30 set global aria_checkpoint_interval=1;
31 ERROR HY000: Lost connection to server during query
32 * copied t1 back for feeding_recovery
33 * recovery happens
34 check table t1 extended;
35 Table Op Msg_type Msg_text
36 mysqltest.t1 check status OK
37 * testing that checksum after recovery is as expected
38 Checksum-check
39 ok
40 connection default;
41 use mysqltest;
42 show create table t1;
43 Table Create Table
44 t1 CREATE TABLE `t1` (
45 `i` int(11) DEFAULT NULL,
46 `shape` geometry NOT NULL,
47 SPATIAL KEY `shape` (`shape`)
48 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
49 * TEST of UPDATE vs state.auto_increment
50 connection admin;
51 * copied t1 for feeding_recovery
52 connection default;
53 update t1 set shape=POINT(5, 5) where i=2;
54 connection admin;
55 flush table t1;
56 * copied t1 for comparison
57 connection default;
58 connection admin;
59 SET SESSION debug_dbug="+d,maria_flush_whole_log,maria_crash";
60 * crashing mysqld intentionally
61 set global aria_checkpoint_interval=1;
62 ERROR HY000: Lost connection to server during query
63 * copied t1 back for feeding_recovery
64 * recovery happens
65 check table t1 extended;
66 Table Op Msg_type Msg_text
67 mysqltest.t1 check status OK
68 * testing that checksum after recovery is as expected
69 Checksum-check
70 ok
71 connection default;
72 use mysqltest;
73 show create table t1;
74 Table Create Table
75 t1 CREATE TABLE `t1` (
76 `i` int(11) DEFAULT NULL,
77 `shape` geometry NOT NULL,
78 SPATIAL KEY `shape` (`shape`)
79 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
80 drop table t1;
81 drop database mysqltest_for_feeding_recovery;
82 drop database mysqltest_for_comparison;
83 drop database mysqltest;