Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_gipk_cross_version_schema_changes.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6
7 ##################################################
8 # 1. Create table t1 with a GIPK
9 [connection slave]
10 SET SESSION sql_generate_invisible_primary_key = ON;
11 CREATE TABLE t1 (c1 BIGINT, c2 TEXT);
12 SET SESSION sql_generate_invisible_primary_key = OFF;
13
14 ##################################################
15 # 2. Simulate replication from version 8.0.28 using a generated relay log from that version
16 # The table on the source only has 1 column, leading to an applier error
17 include/setup_fake_relay_log.inc
18 Setting up fake replication from MYSQL_TEST_DIR/std_data/rpl_no_gipk_low_column_number.000001
19 START REPLICA SQL_THREAD;
20 include/wait_for_slave_sql_error.inc [errno=13964]
21 include/cleanup_fake_relay_log.inc
22
23 ##################################################
24 # 3. Simulate replication from version 5.7.41 using a generated relay log from that version
25 # The table on the source has 4 column, leading to an applier error
26 include/setup_fake_relay_log.inc
27 Setting up fake replication from MYSQL_TEST_DIR/std_data/rpl_no_gipk_high_column_number.000001
28 START REPLICA SQL_THREAD;
29 include/wait_for_slave_sql_error.inc [errno=13964]
30 include/cleanup_fake_relay_log.inc
31
32 ##################################################
33 # 4. Simulate replication from version 8.0.28 using a generated relay log from that version
34 # The table on the source has 3 column, one extra on the right with a INT type, leading to an applier error
35 include/setup_fake_relay_log.inc
36 Setting up fake replication from MYSQL_TEST_DIR/std_data/rpl_no_gipk_schema_divergence.000001
37 START REPLICA SQL_THREAD;
38 include/wait_for_slave_sql_error.inc [errno=13146]
39 include/cleanup_fake_relay_log.inc
40
41 ##################################################
42 # 5. Simulate replication from version 8.0.28 using a generated relay log from that version
43 # The table on the source has 2 column, same fields as the replica but no GIPK
44 include/setup_fake_relay_log.inc
45 Setting up fake replication from MYSQL_TEST_DIR/std_data/rpl_no_gipk_minus_one_column_number.000001
46 START REPLICA SQL_THREAD;
47 include/assert.inc [Table t1 contains the inserted values]
48 include/stop_slave_sql.inc
49 include/cleanup_fake_relay_log.inc
50
51 ##################################################
52 # 6. Simulate replication from version 5.7.41 using a generated relay log from that version
53 # The table on the source has 3 column, with a compatible key similar to a GIPK
54 include/setup_fake_relay_log.inc
55 Setting up fake replication from MYSQL_TEST_DIR/std_data/rpl_gipk_equivalent_key.000001
56 START REPLICA SQL_THREAD;
57 include/assert.inc [Table t1 contains the inserted values]
58
59 ##################################################
60 # 7. # Clean up
61 DROP TABLE t1;
62 STOP SLAVE SQL_THREAD;
63 Warnings:
64 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
65 include/cleanup_fake_relay_log.inc
66 include/start_slave.inc
67 include/suppress_messages.inc
68 # Connection 2 suppresses message <Replica SQL for channel .*: Worker .* failed executing transaction .* at .* end_log_pos .* Failed to apply row event with 1 columns,>.
69 # Connection 2 suppresses message <Replica SQL for channel .*: Worker .* failed executing transaction .* at .* end_log_pos .* Failed to apply row event with 4 columns>.
70 # Connection 2 suppresses message <Replica SQL for channel .*: Worker .* failed executing transaction .* at .* end_log_pos .* Column 2 of table 'test.t1' cannot be converted from type>.
71 # Connection 2 suppresses message <The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state>.
72 # Connection 2 suppresses message <Replica SQL for channel .*: Failed to apply row event with 1 columns, originating from a server of version 8.0.28>.
73 # Connection 2 suppresses message <Replica SQL for channel .*: Failed to apply row event with 4 columns, originating from a server of version unknown>.
74 # Connection 2 suppresses message <Replica SQL for channel .*: Column 2 of table 'test.t1' cannot be converted from type>.
75 include/rpl_end.inc