Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_alter_repository.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 include/stop_slave.inc
7 SHOW CREATE TABLE mysql.slave_relay_log_info;
8 Table Create Table
9 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
10 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
11 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
12 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
13 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
14 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
15 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
16 `Number_of_workers` int unsigned DEFAULT NULL,
17 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
18 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
19 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
20 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
21 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
22 `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
23 `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
24 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
25 PRIMARY KEY (`Channel_name`)
26 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
27 ALTER TABLE mysql.slave_relay_log_info ENGINE= Innodb;
28 SHOW CREATE TABLE mysql.slave_relay_log_info;
29 Table Create Table
30 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
31 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
32 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
33 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
34 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
35 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
36 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
37 `Number_of_workers` int unsigned DEFAULT NULL,
38 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
39 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
40 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
41 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
42 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
43 `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
44 `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
45 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
46 PRIMARY KEY (`Channel_name`)
47 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
48 SET @@global.relay_log_info_repository="TABLE";
49 Warnings:
50 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
51 SET @@global.master_info_repository="TABLE";
52 Warnings:
53 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
54 SET @@global.sync_source_info= 1;
55 include/start_slave.inc
56 CREATE TABLE t_innodb (id INTEGER) engine= Innodb;
57 call mtr.add_suppression("Error writing relay log configuration.");
58 call mtr.add_suppression("Column count of mysql.slave_relay_log_info is wrong.");
59 call mtr.add_suppression("Error running query, replica SQL thread aborted.");
60 call mtr.add_suppression("Info table is not ready to be used.");
61 call mtr.add_suppression("Error writing source configuration.");
62 call mtr.add_suppression("Failed to flush connection metadata.");
63 call mtr.add_suppression(" Error while checking replication metadata.");
64 call mtr.add_suppression("Failed to create or recover replication info repository.");
65 call mtr.add_suppression("Error in checking.* repository info type of");
66 call mtr.add_suppression("Error creating.*: Error checking repositories");
67 call mtr.add_suppression("Failed to create or recover replication info repositories.");
68 call mtr.add_suppression("An unexpected event sequence was detected by the IO thread");
69 call mtr.add_suppression("GTID_LOG_EVENT .* is not expected in an event stream");
70 call mtr.add_suppression("Failed to initialize the connection metadata structure for channel ''");
71 INSERT INTO t_innodb VALUES (1), (2), (3);
72 include/sync_slave_sql_with_master.inc
73 ALTER TABLE mysql.slave_relay_log_info DROP COLUMN Number_of_workers;
74 INSERT INTO t_innodb VALUES (1), (2), (3);
75 include/wait_for_slave_sql_error.inc [errno=1805]
76 Last_SQL_Error = 'Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted'
77 include/stop_slave_io.inc
78 include/rpl_restart_server.inc [server_number=2 parameters: --sync-source-info=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE]
79 START SLAVE SQL_THREAD;
80 ERROR HY000: Replica is not configured or failed to initialize properly. You must at least set --server-id to enable either a source or a replica. Additional error messages can be found in the MySQL error log.
81 ALTER TABLE mysql.slave_relay_log_info ADD COLUMN Number_of_workers INTEGER UNSIGNED AFTER Sql_delay;
82 UPDATE mysql.slave_relay_log_info SET Number_of_workers= 0;
83 include/rpl_restart_server.inc [server_number=2 parameters: --sync-source-info=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE]
84 include/start_slave.inc
85 INSERT INTO t_innodb VALUES (1), (2), (3);
86 include/sync_slave_sql_with_master.inc
87 ALTER TABLE mysql.slave_relay_log_info DROP COLUMN Number_of_workers;
88 INSERT INTO t_innodb VALUES (1), (2), (3);
89 include/wait_for_slave_sql_error.inc [errno=1805]
90 Last_SQL_Error = 'Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted'
91 include/stop_slave_io.inc
92 START SLAVE SQL_THREAD;
93 ERROR HY000: Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted
94 RESET SLAVE ALL;
95 ERROR HY000: Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted
96 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT, SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_LOG_POS;
97 ERROR HY000: Column count of mysql.slave_relay_log_info is wrong. Expected 15, found 14. The table is probably corrupted
98 ALTER TABLE mysql.slave_relay_log_info ADD COLUMN Number_of_workers INTEGER UNSIGNED AFTER Sql_delay;
99 UPDATE mysql.slave_relay_log_info SET Number_of_workers= 0;
100 RESET SLAVE ALL;
101 Warnings:
102 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
103 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT, SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_LOG_POS;
104 Warnings:
105 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
106 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.
107 include/start_slave.inc
108 include/sync_slave_sql_with_master.inc
109 ALTER TABLE mysql.slave_master_info DROP COLUMN Enabled_auto_position;
110 INSERT INTO t_innodb VALUES (1), (2), (3);
111 include/wait_for_slave_io_error.inc [errno=13117]
112 Last_IO_Error = 'Fatal error: Failed to flush connection metadata.'
113 include/stop_slave_sql.inc
114 include/rpl_restart_server.inc [server_number=2 parameters: --sync-source-info=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE]
115 START SLAVE SQL_THREAD;
116 ERROR HY000: Replica is not configured or failed to initialize properly. You must at least set --server-id to enable either a source or a replica. Additional error messages can be found in the MySQL error log.
117 ALTER TABLE mysql.slave_master_info ADD COLUMN Enabled_auto_position BOOLEAN NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.' AFTER Ssl_crlpath;
118 UPDATE mysql.slave_master_info SET Enabled_auto_position= 0;
119 include/rpl_restart_server.inc [server_number=2 parameters: --sync-source-info=1 --master-info-repository=TABLE --relay-log-info-repository=TABLE]
120 include/start_slave.inc
121 ALTER TABLE mysql.slave_master_info DROP COLUMN Enabled_auto_position;
122 INSERT INTO t_innodb VALUES (1), (2), (3);
123 include/wait_for_slave_io_error.inc [errno=13117]
124 Last_IO_Error = 'Fatal error: Failed to flush connection metadata.'
125 include/stop_slave_sql.inc
126 START SLAVE SQL_THREAD;
127 ERROR HY000: Column count of mysql.slave_master_info is wrong. Expected 33, found 32. The table is probably corrupted
128 RESET SLAVE ALL;
129 ERROR HY000: Column count of mysql.slave_master_info is wrong. Expected 33, found 32. The table is probably corrupted
130 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT, SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_LOG_POS;
131 ERROR HY000: Column count of mysql.slave_master_info is wrong. Expected 33, found 32. The table is probably corrupted
132 ALTER TABLE mysql.slave_master_info ADD COLUMN Enabled_auto_position BOOLEAN NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.' AFTER Ssl_crlpath;
133 UPDATE mysql.slave_master_info SET Enabled_auto_position= 0;
134 RESET SLAVE ALL;
135 Warnings:
136 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
137 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'MASTER_HOST', SOURCE_USER= 'MASTER_USER', SOURCE_PORT= MASTER_PORT, SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_LOG_POS;
138 Warnings:
139 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
140 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.
141 include/start_slave.inc
142 include/sync_slave_sql_with_master.inc
143 ANALYZE TABLE mysql.slave_master_info, mysql.slave_relay_log_info;
144 Table Op Msg_type Msg_text
145 mysql.slave_master_info analyze status OK
146 mysql.slave_relay_log_info analyze status OK
147 CHECK TABLE mysql.slave_master_info, mysql.slave_relay_log_info EXTENDED;
148 Table Op Msg_type Msg_text
149 mysql.slave_master_info check status OK
150 mysql.slave_relay_log_info check status OK
151 OPTIMIZE TABLE mysql.slave_master_info, mysql.slave_relay_log_info;
152 Table Op Msg_type Msg_text
153 mysql.slave_master_info optimize note Table does not support optimize, doing recreate + analyze instead
154 mysql.slave_master_info optimize status OK
155 mysql.slave_relay_log_info optimize note Table does not support optimize, doing recreate + analyze instead
156 mysql.slave_relay_log_info optimize status OK
157 REPAIR TABLE mysql.slave_master_info, mysql.slave_relay_log_info EXTENDED;
158 Table Op Msg_type Msg_text
159 mysql.slave_master_info repair note The storage engine for the table doesn't support repair
160 mysql.slave_relay_log_info repair note The storage engine for the table doesn't support repair
161 SHOW CREATE TABLE mysql.slave_master_info;
162 Table Create Table
163 slave_master_info CREATE TABLE `slave_master_info` (
164 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file.',
165 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
166 `Master_log_pos` bigint unsigned NOT NULL COMMENT 'The master log position of the last read event.',
167 `Host` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'The host name of the source.',
168 `User_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The user name used to connect to the master.',
169 `User_password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The password used to connect to the master.',
170 `Port` int unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
171 `Connect_retry` int unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
172 `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
173 `Ssl_ca` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
174 `Ssl_capath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
175 `Ssl_cert` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL certificate file.',
176 `Ssl_cipher` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the cipher in use for the SSL connection.',
177 `Ssl_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL key file.',
178 `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
179 `Heartbeat` float NOT NULL,
180 `Bind` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
181 `Ignored_server_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
182 `Uuid` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The master server uuid.',
183 `Retry_count` bigint unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
184 `Ssl_crl` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
185 `Ssl_crlpath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
186 `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
187 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
188 `Tls_version` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Tls version',
189 `Public_key_path` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file containing public key of master server.',
190 `Get_public_key` tinyint(1) NOT NULL COMMENT 'Preference to get public key from master.',
191 `Network_namespace` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Network namespace used for communication with the master server.',
192 `Master_compression_algorithm` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'Compression algorithm supported for data transfer between source and replica.',
193 `Master_zstd_compression_level` int unsigned NOT NULL COMMENT 'Compression level associated with zstd compression algorithm.',
194 `Tls_ciphersuites` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Ciphersuites used for TLS 1.3 communication with the master server.',
195 `Source_connection_auto_failover` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates whether the channel connection failover is enabled.',
196 `Gtid_only` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if this channel only uses GTIDs and does not persist positions.',
197 PRIMARY KEY (`Channel_name`)
198 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Master Information'
199 SHOW CREATE TABLE mysql.slave_relay_log_info;
200 Table Create Table
201 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
202 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
203 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
204 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
205 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
206 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
207 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
208 `Number_of_workers` int unsigned DEFAULT NULL,
209 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
210 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
211 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
212 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
213 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
214 `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
215 `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
216 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
217 PRIMARY KEY (`Channel_name`)
218 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
219 # Search for occurrences of slave_master_info in the output from mysqldump
220 - Occurrences: 1
221 DROP TABLE t_innodb;
222 include/sync_slave_sql_with_master.inc
223 include/stop_slave.inc
224 Warnings:
225 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
226 Warnings:
227 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
228 SELECT * FROM mysql.slave_master_info;
229 SELECT * FROM mysql.slave_relay_log_info;
230 include/rpl_restart_server.inc [server_number=2]
231 include/start_slave.inc
232 include/rpl_end.inc