snapshot 모드를 실행할 때 나오는 로그치다. 참고용으로 저장한다.
[2019-04-16 11:33:38,642] INFO Completed snapshot in 00:35:57.362 (io.debezium.connector.mysql.SnapshotReader:659)
[2019-04-16 11:33:38,809] INFO Transitioning from the snapshot reader to the binlog reader (io.debezium.connector.mysql.ChainedReader:199)
[2019-04-16 11:33:38,819] INFO GTID set purged on server: 9a227629-491c-11e9-ae9d-fa163ea8d9a7:1-74163567,b0be07a9-491c-11e9-ae12-fa163ec49735:1-13745 (io.debezium.connector.mysql.BinlogReader:299)
[2019-04-16 11:33:38,819] INFO Attempting to generate a filtered GTID set (io.debezium.connector.mysql.MySqlTaskContext:306)
[2019-04-16 11:33:38,819] INFO GTID set from previous recorded offset: 9a227629-491c-11e9-ae9d-fa163ea8d9a7:1-84617433,b0be07a9-491c-11e9-ae12-fa163ec49735:1-13745 (io.debezium.connector.mysql.MySqlTaskContext:307)
[2019-04-16 11:33:38,819] INFO GTID set available on server: 9a227629-491c-11e9-ae9d-fa163ea8d9a7:1-88280749,b0be07a9-491c-11e9-ae12-fa163ec49735:1-13745 (io.debezium.connector.mysql.MySqlTaskContext:314)
[2019-04-16 11:33:38,820] INFO Final merged GTID set to use when connecting to MySQL: 9a227629-491c-11e9-ae9d-fa163ea8d9a7:1-84617433,b0be07a9-491c-11e9-ae12-fa163ec49735:1-13745 (io.debezium.connector.mysql.MySqlTaskContext:335)
[2019-04-16 11:33:38,820] INFO Registering binlog reader with GTID set: 9a227629-491c-11e9-ae9d-fa163ea8d9a7:1-84617433,b0be07a9-491c-11e9-ae12-fa163ec49735:1-13745 (io.debezium.connector.mysql.BinlogReader:304)
[2019-04-16 11:33:38,820] INFO Creating thread debezium-mysqlconnector-test-binlog-client (io.debezium.util.Threads:263)
[2019-04-16 11:33:38,823] INFO Creating thread debezium-mysqlconnector-test-binlog-client (io.debezium.util.Threads:263)
Apr 16, 2019 11:33:38 AM com.github.shyiko.mysql.binlog.BinaryLogClient connect
INFO: Connected to cdc-test-slv.mydb.google.io:3306 at 9a227629-491c-11e9-ae9d-fa163ea8d9a7:1-84617433,b0be07a9-491c-11e9-ae12-fa163ec49735:1-13745 (sid:18405, cid:561)
[2019-04-16 11:33:38,913] INFO Connected to MySQL binlog at cdc-test-slv.mydb.google.io:3306, starting at GTIDs 9a227629-491c-11e9-ae9d-fa163ea8d9a7:1-84617433,b0be07a9-491c-11e9-ae12-fa163ec49735:1-13745 and binlog file ‘mysql-bin.000388’, pos=51906298, skipping 0 events plus 0 rows (io.debezium.connector.mysql.BinlogReader:970)
[2019-04-16 11:33:38,913] INFO Creating thread debezium-mysqlconnector-test-binlog-client (io.debezium.util.Threads:263)
→ bin 로그, GTID 값은 덤프후 새로 생성..
[2019-04-16 10:57:41,295] INFO Step 0: disabling autocommit and enabling repeatable read transactions (io.debezium.connector.mysql.SnapshotReader:198)
[2019-04-16 10:57:41,298] INFO Step 1: flush and obtain global read lock to prevent writes to database (io.debezium.connector.mysql.SnapshotReader:220)
[2019-04-16 10:57:41,313] INFO Step 2: start transaction with consistent snapshot (io.debezium.connector.mysql.SnapshotReader:239)
[2019-04-16 10:57:41,313] INFO Step 3: read binlog position of MySQL master (io.debezium.connector.mysql.SnapshotReader:691)
[2019-04-16 10:57:41,314] INFO using binlog ‘mysql-bin.000388’ at position ‘51906298’ and gtid ‘9a227629-491c-11e9-ae9d-fa163ea8d9a7:1-84617433,
b0be07a9-491c-11e9-ae12-fa163ec49735:1-13745’ (io.debezium.connector.mysql.SnapshotReader:703)
[2019-04-16 10:57:41,314] INFO Step 4: read list of available databases (io.debezium.connector.mysql.SnapshotReader:260)
[2019-04-16 10:57:41,315] INFO list of available databases is: [information_schema, mysql, performance_schema, sys, test, voucher] (io.debezium.connector.mysql.SnapshotReader:268)
[2019-04-16 10:57:41,315] INFO Step 5: read list of available tables in each database (io.debezium.connector.mysql.SnapshotReader:277)
[2019-04-16 10:57:41,318] INFO ‘mysql.columns_priv’ is filtered out, discarding (io.debezium.connector.mysql.SnapshotReader:298)
.... (모든 테이블 목록 출력)
\
[2019-04-16 10:57:41,333] INFO Step 6: generating DROP and CREATE statements to reflect current database schemas: (io.debezium.connector.mysql.SnapshotReader:368)
[2019-04-16 10:57:41,337] INFO SET character_set_server=utf8mb4, collation_server=utf8mb4_general_ci; (io.debezium.connector.mysql.SnapshotReader:833)
[2019-04-16 10:57:41,344] INFO Cluster ID: qhNIgHPxQ5aLflVfzbwd8g (org.apache.kafka.clients.Metadata:285)
[2019-04-16 10:57:41,350] INFO DROP TABLE IF EXISTS `voucher`.`b2b_order_snapshot_test` (io.debezium.connector.mysql.SnapshotReader:833)
[2019-04-16 10:57:41,351] INFO DROP DATABASE IF EXISTS `voucher` (io.debezium.connector.mysql.SnapshotReader:833)
[2019-04-16 10:57:41,353] INFO CREATE DATABASE `voucher` (io.debezium.connector.mysql.SnapshotReader:833)
[2019-04-16 10:57:41,354] INFO USE `voucher` (io.debezium.connector.mysql.SnapshotReader:833)
[2019-04-16 10:57:41,371] WARN Column is missing a character set: status VARCHAR(50) NOT NULL DEFAULT VALUE (io.debezium.connector.mysql.MySqlValueConverters:308)
[2019-04-16 10:57:41,371] WARN Using UTF-8 charset by default for column without charset: status VARCHAR(50) NOT NULL DEFAULT VALUE (io.debezium.connector.mysql.MySqlValueConverters:284)
[2019-04-16 10:57:41,372] WARN Column is missing a character set: receiver_type VARCHAR(30) NOT NULL DEFAULT VALUE (io.debezium.connector.mysql.MySqlValueConverters:308)
[2019-04-16 10:57:41,372] WARN Using UTF-8 charset by default for column without charset: receiver_type VARCHAR(30) NOT NULL DEFAULT VALUE (io.debezium.connector.mysql.MySqlValueConverters:284)
[2019-04-16 10:57:41,372] WARN Column is missing a character set: receiver_phone_token VARCHAR(200) DEFAULT VALUE (io.debezium.connector.mysql.MySqlValueConverters:308)
[2019-04-16 10:57:41,372] WARN Using UTF-8 charset by default for column without charset: receiver_phone_token VARCHAR(200) DEFAULT VALUE (io.debezium.connector.mysql.MySqlValueConverters:284)
[2019-04-16 10:57:41,374] WARN Column is missing a character set: created_by VARCHAR(45) NOT NULL DEFAULT VALUE (io.debezium.connector.mysql.MySqlValueConverters:308)
[2019-04-16 10:57:41,374] WARN Using UTF-8 charset by default for column without charset: created_by VARCHAR(45) NOT NULL DEFAULT VALUE (io.debezium.connector.mysql.MySqlValueConverters:284)
[2019-04-16 10:57:41,375] INFO CREATE TABLE `b2b_order_snapshot_test` (
`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
`api_callback_url` varchar(200) DEFAULT NULL COMMENT ‘API ?? URL’,
`trace_id` varchar(100) DEFAULT NULL COMMENT ‘?? ID’,
[2019-04-16 10:57:41,385] INFO Step 7: releasing global read lock to enable MySQL writes (io.debezium.connector.mysql.SnapshotReader:431)
[2019-04-16 10:57:41,387] INFO Step 7: blocked writes to MySQL for a total of 00:00:00.074 (io.debezium.connector.mysql.SnapshotReader:437)
[2019-04-16 10:57:41,387] INFO Step 8: scanning contents of 1 tables while still in transaction (io.debezium.connector.mysql.SnapshotReader:452)
[2019-04-16 10:57:41,391] INFO Step 8: - scanning table ‘voucher.b2b_order_snapshot_test’ (1 of 1 tables) (io.debezium.connector.mysql.SnapshotReader:498)
[2019-04-16 11:33:38,642] INFO Step 8: scanned 75237376 rows in 1 tables in 00:35:57.255 (io.debezium.connector.mysql.SnapshotReader:567)
[2019-04-16 11:33:38,642] INFO Step 9: committing transaction (io.debezium.connector.mysql.SnapshotReader:598)]
