2020-01-08 10:35:34 INFO JsonConverterConfig:347 - JsonConverterConfig values: converter.type = key decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = true 2020-01-08 10:35:34 INFO JsonConverterConfig:347 - JsonConverterConfig values: converter.type = value decimal.format = BASE64 schemas.cache.size = 1000 schemas.enable = false 2020-01-08 10:35:34 INFO EmbeddedEngine$EmbeddedConfig:347 - EmbeddedConfig values: access.control.allow.methods = access.control.allow.origin = admin.listeners = null bootstrap.servers = [localhost:9092] client.dns.lookup = default config.providers = [] connector.client.config.override.policy = None header.converter = class org.apache.kafka.connect.storage.SimpleHeaderConverter internal.key.converter = class org.apache.kafka.connect.json.JsonConverter internal.value.converter = class org.apache.kafka.connect.json.JsonConverter key.converter = class org.apache.kafka.connect.json.JsonConverter listeners = null metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 offset.flush.interval.ms = 80000 offset.flush.timeout.ms = 5000 offset.storage.file.filename = /tmp/offset9.dat offset.storage.partitions = null offset.storage.replication.factor = null offset.storage.topic = plugin.path = null rest.advertised.host.name = null rest.advertised.listener = null rest.advertised.port = null rest.extension.classes = [] rest.host.name = null rest.port = 8083 ssl.client.auth = none task.shutdown.graceful.timeout.ms = 5000 value.converter = class org.apache.kafka.connect.json.JsonConverter 2020-01-08 10:35:34 INFO WorkerConfig:343 - Worker configuration property 'internal.key.converter' is deprecated and may be removed in an upcoming release. The specified value 'org.apache.kafka.connect.json.JsonConverter' matches the default, so this property can be safely removed from the worker configuration. 2020-01-08 10:35:34 INFO WorkerConfig:343 - Worker configuration property 'internal.value.converter' is deprecated and may be removed in an upcoming release. The specified value 'org.apache.kafka.connect.json.JsonConverter' matches the default, so this property can be safely removed from the worker configuration. does this return 2020-01-08 10:35:34 INFO FileOffsetBackingStore:58 - Starting FileOffsetBackingStore with file \tmp\offset9.dat 2020-01-08 10:35:34 INFO BaseSourceTask:43 - Starting MySqlConnectorTask with configuration: 2020-01-08 10:35:34 INFO BaseSourceTask:45 - connector.class = io.debezium.connector.mysql.MySqlConnector 2020-01-08 10:35:34 INFO BaseSourceTask:45 - database.history.file.filename = /tmp/dbhistory9.dat 2020-01-08 10:35:34 INFO BaseSourceTask:45 - database.user = debezium 2020-01-08 10:35:34 INFO BaseSourceTask:45 - database.server.id = 85744 2020-01-08 10:35:34 INFO BaseSourceTask:45 - offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore 2020-01-08 10:35:34 INFO BaseSourceTask:45 - database.server.name = my-app-connector 2020-01-08 10:35:34 INFO BaseSourceTask:45 - database.port = 3306 2020-01-08 10:35:34 INFO BaseSourceTask:45 - table.whitelist = employees.departments 2020-01-08 10:35:34 INFO BaseSourceTask:45 - offset.flush.interval.ms = 80000 2020-01-08 10:35:34 INFO BaseSourceTask:45 - offset.storage.file.filename = /tmp/offset9.dat 2020-01-08 10:35:34 INFO BaseSourceTask:45 - database.hostname = mysql.ci6utmybrvui.eu-west-1.rds.amazonaws.com 2020-01-08 10:35:34 INFO BaseSourceTask:45 - database.password = ******** 2020-01-08 10:35:34 INFO BaseSourceTask:45 - name = my-sql-connector 2020-01-08 10:35:34 INFO BaseSourceTask:45 - table.ignore.builtin = true 2020-01-08 10:35:34 INFO BaseSourceTask:45 - database.history = io.debezium.relational.history.FileDatabaseHistory 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:310 - Reading MySQL system variables 2020-01-08 10:35:35 DEBUG JdbcConnection:186 - Connected to jdbc:mysql://mysql.ci6utmybrvui.eu-west-1.rds.amazonaws.com:3306/?useInformationSchema=true&nullCatalogMeansCurrent=false&useSSL=false&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&zeroDateTimeBehavior=CONVERT_TO_NULL&connectTimeout=30000 with {server.id=85744, server.name=my-app-connector, user=debezium, useLegacyDatetimeCode=false, password=password} 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - activate_all_roles_on_login = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - admin_address = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - admin_port = 33062 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - auto_generate_certs = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - auto_increment_increment = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - auto_increment_offset = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - autocommit = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - automatic_sp_privileges = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - avoid_temporal_upgrade = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - back_log = 150 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - basedir = /rdsdbbin/mysql-8.0.16.R1/ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - big_tables = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - bind_address = * 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_cache_size = 32768 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_checksum = CRC32 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_direct_non_transactional_updates = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_encryption = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_error_action = ABORT_SERVER 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_expire_logs_seconds = 2592000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_format = ROW 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_group_commit_sync_delay = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_group_commit_sync_no_delay_count = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_gtid_simple_recovery = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_max_flush_queue_time = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_order_commits = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_rotate_encryption_master_key_at_startup = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_row_event_max_size = 8192 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_row_image = FULL 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_row_metadata = MINIMAL 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_row_value_options = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_rows_query_log_events = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_stmt_cache_size = 32768 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_transaction_dependency_history_size = 25000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - binlog_transaction_dependency_tracking = COMMIT_ORDER 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - block_encryption_mode = aes-128-ecb 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - bulk_insert_buffer_size = 8388608 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - caching_sha2_password_auto_generate_rsa_keys = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - caching_sha2_password_private_key_path = private_key.pem 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - caching_sha2_password_public_key_path = public_key.pem 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - character_set_client = utf8mb4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - character_set_connection = utf8mb4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - character_set_database = utf8mb4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - character_set_filesystem = binary 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - character_set_results = utf8mb4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - character_set_server = utf8mb4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - character_set_system = utf8 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - character_sets_dir = /rdsdbbin/mysql-8.0.16.R1/share/charsets/ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - check_proxy_users = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - collation_connection = utf8mb4_0900_ai_ci 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - collation_database = utf8mb4_0900_ai_ci 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - collation_server = utf8mb4_0900_ai_ci 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - completion_type = NO_CHAIN 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - concurrent_insert = AUTO 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - connect_timeout = 10 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - core_file = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - create_admin_listener_thread = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - cte_max_recursion_depth = 1000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - datadir = /rdsdbdata/db/ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - default_authentication_plugin = mysql_native_password 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - default_collation_for_utf8mb4 = utf8mb4_0900_ai_ci 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - default_password_lifetime = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - default_storage_engine = InnoDB 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - default_table_encryption = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - default_tmp_storage_engine = InnoDB 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - default_week_format = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - delay_key_write = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - delayed_insert_limit = 100 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - delayed_insert_timeout = 300 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - delayed_queue_size = 1000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - disabled_storage_engines = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - disconnect_on_expired_password = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - div_precision_increment = 4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - end_markers_in_json = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - enforce_gtid_consistency = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - eq_range_index_dive_limit = 200 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - error_count = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - event_scheduler = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - expire_logs_days = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - explicit_defaults_for_timestamp = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - external_user = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - flush = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - flush_time = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - foreign_key_checks = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ft_boolean_syntax = + -><()~*:""&| 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ft_max_word_len = 84 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ft_min_word_len = 4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ft_query_expansion_limit = 20 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ft_stopword_file = (built-in) 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - general_log = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - general_log_file = /rdsdbdata/log/general/mysql-general.log 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - group_concat_max_len = 1024 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - group_replication_consistency = EVENTUAL 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - gtid_executed = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - gtid_executed_compression_period = 1000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - gtid_mode = OFF_PERMISSIVE 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - gtid_next = AUTOMATIC 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - gtid_owned = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - gtid_purged = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_compress = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_dynamic_loading = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_geometry = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_openssl = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_profiling = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_query_cache = NO 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_rtree_keys = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_ssl = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_statement_timeout = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - have_symlink = DISABLED 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - histogram_generation_max_mem_size = 20000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - host_cache_size = 278 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - hostname = ip-10-4-0-152 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - identity = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - immediate_server_version = 999999 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - information_schema_stats_expiry = 86400 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - init_connect = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - init_file = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - init_slave = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_adaptive_flushing = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_adaptive_flushing_lwm = 10 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_adaptive_hash_index = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_adaptive_hash_index_parts = 8 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_adaptive_max_sleep_delay = 150000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_api_bk_commit_interval = 5 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_api_disable_rowlock = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_api_enable_binlog = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_api_enable_mdl = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_api_trx_level = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_autoextend_increment = 64 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_autoinc_lock_mode = 2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_chunk_size = 134217728 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_dump_at_shutdown = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_dump_now = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_dump_pct = 25 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_filename = ib_buffer_pool 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_in_core_file = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_instances = 8 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_load_abort = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_load_at_startup = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_load_now = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_buffer_pool_size = 1073741824 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_change_buffer_max_size = 25 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_change_buffering = all 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_checksum_algorithm = crc32 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_cmp_per_index_enabled = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_commit_concurrency = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_compression_failure_threshold_pct = 5 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_compression_level = 6 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_compression_pad_pct_max = 50 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_concurrency_tickets = 5000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_data_file_path = ibdata1:12M:autoextend 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_data_home_dir = /rdsdbdata/db/innodb 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_deadlock_detect = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_dedicated_server = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_default_row_format = dynamic 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_directories = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_disable_sort_file_cache = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_doublewrite = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_fast_shutdown = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_file_per_table = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_fill_factor = 100 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_flush_log_at_timeout = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_flush_log_at_trx_commit = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_flush_method = O_DIRECT 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_flush_neighbors = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_flush_sync = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_flushing_avg_loops = 30 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_force_load_corrupted = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_force_recovery = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_fsync_threshold = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_aux_table = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_cache_size = 8000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_enable_diag_print = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_enable_stopword = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_max_token_size = 84 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_min_token_size = 3 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_num_word_optimize = 2000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_result_cache_limit = 2000000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_server_stopword_table = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_sort_pll_degree = 2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_total_cache_size = 640000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_ft_user_stopword_table = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_io_capacity = 200 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_io_capacity_max = 2000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_lock_wait_timeout = 50 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_buffer_size = 8388608 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_checksums = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_compressed_pages = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_file_size = 134217728 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_files_in_group = 2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_group_home_dir = /rdsdbdata/log/innodb 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_spin_cpu_abs_lwm = 80 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_spin_cpu_pct_hwm = 50 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_wait_for_flush_spin_hwm = 400 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_log_write_ahead_size = 8192 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_lru_scan_depth = 1024 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_max_dirty_pages_pct = 90.000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_max_dirty_pages_pct_lwm = 10.000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_max_purge_lag = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_max_purge_lag_delay = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_max_undo_log_size = 1073741824 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_monitor_disable = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_monitor_enable = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_monitor_reset = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_monitor_reset_all = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_numa_interleave = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_old_blocks_pct = 37 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_old_blocks_time = 1000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_online_alter_log_max_size = 134217728 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_open_files = 4000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_optimize_fulltext_only = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_page_cleaners = 4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_page_size = 16384 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_parallel_read_threads = 4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_print_all_deadlocks = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_print_ddl_logs = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_purge_batch_size = 300 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_purge_rseg_truncate_frequency = 128 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_purge_threads = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_random_read_ahead = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_read_ahead_threshold = 56 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_read_io_threads = 4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_read_only = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_redo_log_encrypt = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_replication_delay = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_rollback_on_timeout = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_rollback_segments = 128 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_sort_buffer_size = 1048576 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_spin_wait_delay = 6 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_spin_wait_pause_multiplier = 50 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_stats_auto_recalc = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_stats_include_delete_marked = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_stats_method = nulls_equal 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_stats_on_metadata = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_stats_persistent = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_stats_persistent_sample_pages = 20 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_stats_transient_sample_pages = 8 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_status_output = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_status_output_locks = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_strict_mode = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_sync_array_size = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_sync_spin_loops = 30 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_table_locks = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_temp_data_file_path = ibtmp1:12M:autoextend 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_temp_tablespaces_dir = ./#innodb_temp/ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_thread_concurrency = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_thread_sleep_delay = 10000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_tmpdir = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_undo_directory = ./ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_undo_log_encrypt = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_undo_log_truncate = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_undo_tablespaces = 2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_use_native_aio = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_version = 8.0.16 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - innodb_write_io_threads = 4 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - insert_id = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - interactive_timeout = 28800 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - internal_tmp_mem_storage_engine = TempTable 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - join_buffer_size = 262144 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - keep_files_on_create = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - key_buffer_size = 16777216 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - key_cache_age_threshold = 300 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - key_cache_block_size = 1024 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - key_cache_division_limit = 100 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - keyring_operations = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - large_files_support = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - large_page_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - large_pages = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - last_insert_id = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - lc_messages = en_US 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - lc_messages_dir = /rdsdbbin/mysql-8.0.16.R1/share/ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - lc_time_names = en_US 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - license = GPL 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - local_infile = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - lock_wait_timeout = 31536000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - locked_in_memory = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_bin = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_bin_basename = /rdsdbdata/log/binlog/mysql-bin-changelog 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_bin_index = /rdsdbdata/log/binlog/mysql-bin-changelog.index 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_bin_trust_function_creators = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_bin_use_v1_row_events = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_error = /rdsdbdata/log/error/mysql-error.log 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_error_services = log_filter_internal; log_sink_internal 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_error_suppression_list = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_error_verbosity = 2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_output = TABLE 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_queries_not_using_indexes = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_slave_updates = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_slow_admin_statements = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_slow_extra = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_slow_slave_statements = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_statements_unsafe_for_binlog = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_throttle_queries_not_using_indexes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - log_timestamps = UTC 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - long_query_time = 10.000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - low_priority_updates = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - lower_case_file_system = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - lower_case_table_names = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mandatory_roles = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - master_info_repository = TABLE 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - master_verify_checksum = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_allowed_packet = 67108864 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_binlog_cache_size = 18446744073709547520 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_binlog_size = 134217728 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_binlog_stmt_cache_size = 18446744073709547520 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_connect_errors = 100 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_connections = 150 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_delayed_threads = 20 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_digest_length = 1024 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_error_count = 1024 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_execution_time = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_heap_table_size = 16777216 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_insert_delayed_threads = 20 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_join_size = 18446744073709551615 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_length_for_sort_data = 4096 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_points_in_geometry = 65536 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_prepared_stmt_count = 16382 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_relay_log_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_seeks_for_key = 18446744073709551615 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_sort_length = 1024 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_sp_recursion_depth = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_user_connections = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - max_write_lock_count = 18446744073709551615 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - min_examined_row_limit = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - myisam_data_pointer_size = 6 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - myisam_max_sort_file_size = 9223372036853727232 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - myisam_mmap_size = 18446744073709551615 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - myisam_recover_options = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - myisam_repair_threads = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - myisam_sort_buffer_size = 8388608 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - myisam_stats_method = nulls_unequal 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - myisam_use_mmap = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysql_native_password_proxy_users = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_bind_address = * 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_connect_timeout = 30 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_document_id_unique_prefix = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_enable_hello_notice = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_idle_worker_thread_timeout = 60 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_interactive_timeout = 28800 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_max_allowed_packet = 1048576 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_max_connections = 100 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_min_worker_threads = 2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_port = 33060 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_port_open_timeout = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_read_timeout = 28800 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_socket = /tmp/mysqlx.sock 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_ssl_ca = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_ssl_capath = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_ssl_cert = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_ssl_cipher = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_ssl_crl = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_ssl_crlpath = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_ssl_key = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_wait_timeout = 28800 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - mysqlx_write_timeout = 60 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - net_buffer_length = 16384 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - net_read_timeout = 30 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - net_retry_count = 10 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - net_write_timeout = 60 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - new = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ngram_token_size = 2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - offline_mode = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - old = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - old_alter_table = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - open_files_limit = 65535 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - optimizer_prune_level = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - optimizer_search_depth = 62 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - optimizer_switch = index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - optimizer_trace = enabled=off,one_line=off 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - optimizer_trace_features = greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - optimizer_trace_limit = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - optimizer_trace_max_mem_size = 1048576 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - optimizer_trace_offset = -1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - original_commit_timestamp = 36028797018963968 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - original_server_version = 999999 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - parser_max_mem_size = 18446744073709551615 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - partial_revokes = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - password_history = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - password_require_current = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - password_reuse_interval = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_accounts_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_digests_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_error_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_events_stages_history_long_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_events_stages_history_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_events_statements_history_long_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_events_statements_history_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_events_transactions_history_long_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_events_transactions_history_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_events_waits_history_long_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_events_waits_history_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_hosts_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_cond_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_cond_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_digest_length = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_digest_sample_age = 60 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_file_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_file_handles = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_file_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_index_stat = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_memory_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_metadata_locks = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_mutex_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_mutex_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_prepared_statements_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_program_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_rwlock_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_rwlock_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_socket_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_socket_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_sql_text_length = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_stage_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_statement_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_statement_stack = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_table_handles = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_table_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_table_lock_stat = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_thread_classes = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_max_thread_instances = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_session_connect_attrs_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_setup_actors_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_setup_objects_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - performance_schema_users_size = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - persist_only_admin_x509_subject = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - persisted_globals_load = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - pid_file = /rdsdbdata/log/mysql-3306.pid 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - plugin_dir = /rdsdbbin/mysql-8.0.16.R1/lib/plugin/ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - port = 3306 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - preload_buffer_size = 32768 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - profiling = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - profiling_history_size = 15 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - protocol_version = 10 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - proxy_user = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - pseudo_slave_mode = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - pseudo_thread_id = 22 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - query_alloc_block_size = 8192 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - query_prealloc_size = 8192 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - rand_seed1 = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - rand_seed2 = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - range_alloc_block_size = 4096 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - range_optimizer_max_mem_size = 8388608 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - rbr_exec_mode = STRICT 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - read_buffer_size = 262144 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - read_only = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - read_rnd_buffer_size = 524288 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - regexp_stack_limit = 8000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - regexp_time_limit = 32 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - relay_log = /rdsdbdata/log/relaylog/relaylog 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - relay_log_basename = /rdsdbdata/log/relaylog/relaylog 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - relay_log_index = /rdsdbdata/log/relaylog/relaylog.index 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - relay_log_info_file = relay-log.info 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - relay_log_info_repository = TABLE 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - relay_log_purge = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - relay_log_recovery = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - relay_log_space_limit = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - report_host = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - report_password = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - report_port = 3306 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - report_user = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - require_secure_transport = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - resultset_metadata = FULL 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - rpl_read_size = 8192 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - rpl_stop_slave_timeout = 31536000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - schema_definition_cache = 256 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - secondary_engine_cost_threshold = 100000.000000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - secure_file_priv = /tmp/ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - server_id = 321483488 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - server_id_bits = 32 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - server_uuid = 3a6743ad-08be-11ea-9f10-06bc77f09204 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - session_track_gtids = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - session_track_schema = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - session_track_state_change = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - session_track_system_variables = time_zone,autocommit,character_set_client,character_set_results,character_set_connection 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - session_track_transaction_info = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sha256_password_auto_generate_rsa_keys = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sha256_password_private_key_path = private_key.pem 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sha256_password_proxy_users = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sha256_password_public_key_path = public_key.pem 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - show_create_table_verbosity = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - show_old_temporals = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - skip_external_locking = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - skip_name_resolve = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - skip_networking = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - skip_show_database = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_allow_batching = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_checkpoint_group = 512 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_checkpoint_period = 300 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_compressed_protocol = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_exec_mode = IDEMPOTENT 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_load_tmpdir = /tmp 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_max_allowed_packet = 1073741824 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_net_timeout = 60 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_parallel_type = DATABASE 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_parallel_workers = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_pending_jobs_size_max = 134217728 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_preserve_commit_order = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_rows_search_algorithms = INDEX_SCAN,HASH_SCAN 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_skip_errors = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_sql_verify_checksum = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_transaction_retries = 10 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slave_type_conversions = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slow_launch_time = 2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slow_query_log = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - slow_query_log_file = /rdsdbdata/log/slowquery/mysql-slowquery.log 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - socket = /tmp/mysql.sock 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sort_buffer_size = 262144 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_auto_is_null = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_big_selects = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_buffer_result = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_log_bin = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_log_off = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_notes = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_quote_show_create = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_require_primary_key = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_safe_updates = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_select_limit = 18446744073709551615 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_slave_skip_counter = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sql_warnings = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ssl_ca = /rdsdbdata/rds-metadata/ca-cert.pem 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ssl_capath = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ssl_cert = /rdsdbdata/rds-metadata/server-cert.pem 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ssl_cipher = EXP1024-RC4-SHA:EXP1024-DES-CBC-SHA:AES256-SHA:AES128-SHA:DES-CBC3-SHA:DES-CBC-SHA:EXP-DES-CBC-SHA:EXP-RC2-CBC-MD5:RC4-SHA:RC4-MD5:EXP-RC4-MD5:NULL-SHA:NULL-MD5:DES-CBC3-MD5:DES-CBC-MD5:EXP-RC2-CBC-MD5:RC2-CBC-MD5:EXP-RC4-MD5:RC4-MD5:KRB5-DES-CBC3-MD5:KRB5-DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:EXP-KRB5-RC4-MD5:EXP-KRB5-RC2-CBC-MD5:EXP-KRB5-DES-CBC-MD5:KRB5-RC4-MD5:KRB5-DES-CBC-MD5:ADH-RC4-MD5:EXP-ADH-RC4-MD5:DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-RC4-SHA:EXP1024-DHE-DSS-DES-CBC-SHA:EXP-KRB5-RC4-SHA:EXP-KRB5-RC2-CBC-SHA:EXP-KRB5-DES-CBC-SHA:KRB5-RC4-SHA:KRB5-DES-CBC-SHA:ADH-DES-CBC-SHA:EXP-ADH-DES-CBC-SHA:EDH-RSA-DES-CBC-SHA:EXP-EDH-RSA-DES-CBC-SHA:EDH-DSS-DES-CBC-SHA:EXP-EDH-DSS-DES-CBC-SHA 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ssl_crl = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ssl_crlpath = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ssl_fips_mode = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - ssl_key = /rdsdbdata/rds-metadata/server-key.pem 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - stored_program_cache = 256 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - stored_program_definition_cache = 256 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - super_read_only = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sync_binlog = 1 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sync_master_info = 10000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sync_relay_log = 10000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - sync_relay_log_info = 10000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - system_time_zone = UTC 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - table_definition_cache = 2000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - table_encryption_privilege_check = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - table_open_cache = 4000 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - table_open_cache_instances = 16 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - tablespace_definition_cache = 256 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - temptable_max_ram = 1073741824 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - temptable_use_mmap = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - thread_cache_size = 9 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - thread_handling = one-thread-per-connection 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - thread_stack = 262144 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - time_zone = UTC 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - timestamp = 1578479734.162082 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - tls_ciphersuites = 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - tls_version = TLSv1,TLSv1.1,TLSv1.2 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - tmp_table_size = 16777216 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - tmpdir = /rdsdbdata/tmp 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - transaction_alloc_block_size = 8192 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - transaction_allow_batching = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - transaction_isolation = REPEATABLE-READ 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - transaction_prealloc_size = 4096 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - transaction_read_only = OFF 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - transaction_write_set_extraction = XXHASH64 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - unique_checks = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - updatable_views_with_limit = YES 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - use_secondary_engine = ON 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - version = 8.0.16 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - version_comment = Source distribution 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - version_compile_machine = x86_64 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - version_compile_os = Linux 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - version_compile_zlib = 1.2.11 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - wait_timeout = 28800 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - warning_count = 0 2020-01-08 10:35:35 DEBUG MySqlJdbcContext:324 - windowing_use_high_precision = ON 2020-01-08 10:35:35 INFO MySqlConnectorTask:168 - Found no existing offset, so preparing to perform a snapshot 2020-01-08 10:35:35 DEBUG MySqlConnectorTask:608 - binlog_format=ROW 2020-01-08 10:35:35 DEBUG MySqlConnectorTask:622 - binlog_row_image=FULL 2020-01-08 10:35:35 INFO Threads:251 - Requested thread factory for connector MySqlConnector, id = my-app-connector named = binlog-client 2020-01-08 10:35:35 DEBUG ChainedReader:204 - Starting the snapshot reader 2020-01-08 10:35:35 INFO Threads:251 - Requested thread factory for connector MySqlConnector, id = my-app-connector named = snapshot 2020-01-08 10:35:35 INFO Threads:268 - Creating thread debezium-mysqlconnector-my-app-connector-snapshot 2020-01-08 10:35:35 INFO SnapshotReader:239 - Starting snapshot for jdbc:mysql://mysql.ci6utmybrvui.eu-west-1.rds.amazonaws.com:3306/?useInformationSchema=true&nullCatalogMeansCurrent=false&useSSL=false&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&zeroDateTimeBehavior=CONVERT_TO_NULL&connectTimeout=30000 with user 'debezium' with locking mode 'minimal' 2020-01-08 10:35:35 DEBUG EmbeddedEngine:813 - Embedded engine is polling task for records on thread Thread[pool-1-thread-1,5,main] 2020-01-08 10:35:35 INFO SnapshotReader:991 - Snapshot is using user 'debezium' with these MySQL grants: 2020-01-08 10:35:35 INFO SnapshotReader:992 - GRANT SELECT, RELOAD, SHOW DATABASES, LOCK TABLES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO `debezium`@`%` 2020-01-08 10:35:35 INFO SnapshotReader:992 - GRANT BACKUP_ADMIN ON *.* TO `debezium`@`%` 2020-01-08 10:35:35 INFO SnapshotReader:962 - MySQL server variables related to change data capture: 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_cache_size = 32768 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_checksum = CRC32 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_direct_non_transactional_updates = OFF 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_encryption = OFF 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_error_action = ABORT_SERVER 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_expire_logs_seconds = 2592000 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_format = ROW 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_group_commit_sync_delay = 0 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_group_commit_sync_no_delay_count = 0 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_gtid_simple_recovery = ON 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_max_flush_queue_time = 0 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_order_commits = ON 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_rotate_encryption_master_key_at_startup = OFF 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_row_event_max_size = 8192 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_row_image = FULL 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_row_metadata = MINIMAL 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_row_value_options = 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_rows_query_log_events = OFF 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_stmt_cache_size = 32768 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_transaction_dependency_history_size = 25000 2020-01-08 10:35:35 INFO SnapshotReader:965 - binlog_transaction_dependency_tracking = COMMIT_ORDER 2020-01-08 10:35:35 INFO SnapshotReader:965 - character_set_client = utf8mb4 2020-01-08 10:35:35 INFO SnapshotReader:965 - character_set_connection = utf8mb4 2020-01-08 10:35:35 INFO SnapshotReader:965 - character_set_database = utf8mb4 2020-01-08 10:35:35 INFO SnapshotReader:965 - character_set_filesystem = binary 2020-01-08 10:35:35 INFO SnapshotReader:965 - character_set_results = utf8mb4 2020-01-08 10:35:35 INFO SnapshotReader:965 - character_set_server = utf8mb4 2020-01-08 10:35:35 INFO SnapshotReader:965 - character_set_system = utf8 2020-01-08 10:35:35 INFO SnapshotReader:965 - character_sets_dir = /rdsdbbin/mysql-8.0.16.R1/share/charsets/ 2020-01-08 10:35:35 INFO SnapshotReader:965 - collation_connection = utf8mb4_0900_ai_ci 2020-01-08 10:35:35 INFO SnapshotReader:965 - collation_database = utf8mb4_0900_ai_ci 2020-01-08 10:35:35 INFO SnapshotReader:965 - collation_server = utf8mb4_0900_ai_ci 2020-01-08 10:35:35 INFO SnapshotReader:965 - default_collation_for_utf8mb4 = utf8mb4_0900_ai_ci 2020-01-08 10:35:35 INFO SnapshotReader:965 - enforce_gtid_consistency = OFF 2020-01-08 10:35:35 INFO SnapshotReader:965 - gtid_executed = 2020-01-08 10:35:35 INFO SnapshotReader:965 - gtid_executed_compression_period = 1000 2020-01-08 10:35:35 INFO SnapshotReader:965 - gtid_mode = OFF_PERMISSIVE 2020-01-08 10:35:35 INFO SnapshotReader:965 - gtid_next = AUTOMATIC 2020-01-08 10:35:35 INFO SnapshotReader:965 - gtid_owned = 2020-01-08 10:35:35 INFO SnapshotReader:965 - gtid_purged = 2020-01-08 10:35:35 INFO SnapshotReader:965 - immediate_server_version = 999999 2020-01-08 10:35:35 INFO SnapshotReader:965 - innodb_api_enable_binlog = OFF 2020-01-08 10:35:35 INFO SnapshotReader:965 - innodb_version = 8.0.16 2020-01-08 10:35:35 INFO SnapshotReader:965 - log_statements_unsafe_for_binlog = OFF 2020-01-08 10:35:35 INFO SnapshotReader:965 - max_binlog_cache_size = 18446744073709547520 2020-01-08 10:35:35 INFO SnapshotReader:965 - max_binlog_size = 134217728 2020-01-08 10:35:35 INFO SnapshotReader:965 - max_binlog_stmt_cache_size = 18446744073709547520 2020-01-08 10:35:35 INFO SnapshotReader:965 - original_server_version = 999999 2020-01-08 10:35:35 INFO SnapshotReader:965 - protocol_version = 10 2020-01-08 10:35:35 INFO SnapshotReader:965 - session_track_gtids = OFF 2020-01-08 10:35:35 INFO SnapshotReader:965 - slave_type_conversions = 2020-01-08 10:35:35 INFO SnapshotReader:965 - sync_binlog = 1 2020-01-08 10:35:35 INFO SnapshotReader:965 - system_time_zone = UTC 2020-01-08 10:35:35 INFO SnapshotReader:965 - time_zone = UTC 2020-01-08 10:35:35 INFO SnapshotReader:965 - tls_version = TLSv1,TLSv1.1,TLSv1.2 2020-01-08 10:35:35 INFO SnapshotReader:965 - version = 8.0.16 2020-01-08 10:35:35 INFO SnapshotReader:965 - version_comment = Source distribution 2020-01-08 10:35:35 INFO SnapshotReader:965 - version_compile_machine = x86_64 2020-01-08 10:35:35 INFO SnapshotReader:965 - version_compile_os = Linux 2020-01-08 10:35:35 INFO SnapshotReader:965 - version_compile_zlib = 1.2.11 2020-01-08 10:35:35 INFO SnapshotReader:270 - Step 0: disabling autocommit, enabling repeatable read transactions, and setting lock wait timeout to 10 2020-01-08 10:35:36 DEBUG MySqlJdbcContext:299 - Reading MySQL charset-related system variables before parsing DDL history. 2020-01-08 10:35:36 DEBUG MySqlJdbcContext:324 - character_set_server = utf8mb4 2020-01-08 10:35:36 DEBUG MySqlJdbcContext:324 - collation_server = utf8mb4_0900_ai_ci 2020-01-08 10:35:36 INFO SnapshotReader:304 - Step 1: flush and obtain global read lock to prevent writes to database 2020-01-08 10:35:36 INFO SnapshotReader:312 - Step 1: unable to flush and acquire global read lock, will use table read locks after reading table names 2020-01-08 10:35:36 INFO SnapshotReader:329 - Step 2: start transaction with consistent snapshot 2020-01-08 10:35:36 INFO SnapshotReader:354 - Step 3: read list of available databases 2020-01-08 10:35:36 INFO SnapshotReader:362 - list of available databases is: [employees, information_schema, innodb, mysql, performance_schema, sys] 2020-01-08 10:35:36 INFO SnapshotReader:373 - Step 4: read list of available tables in each database 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'employees.departments' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:401 - including 'employees.departments' for further processing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'employees.dept_emp' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'employees.dept_emp' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'employees.dept_manager' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'employees.dept_manager' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'employees.employees' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'employees.employees' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'employees.salaries' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'employees.salaries' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'employees.titles' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'employees.titles' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.columns_priv' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.columns_priv' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.component' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.component' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.db' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.db' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.default_roles' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.default_roles' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.engine_cost' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.engine_cost' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.func' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.func' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.general_log' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.general_log' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.general_log_backup' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.general_log_backup' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.general_log_template' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.general_log_template' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.global_grants' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.global_grants' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.gtid_executed' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.gtid_executed' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.help_category' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.help_category' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.help_keyword' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.help_keyword' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.help_relation' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.help_relation' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.help_topic' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.help_topic' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.host' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.host' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.innodb_index_stats' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.innodb_index_stats' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.innodb_table_stats' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.innodb_table_stats' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.ndb_binlog_index' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.ndb_binlog_index' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.password_history' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.password_history' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.plugin' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.plugin' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.procs_priv' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.procs_priv' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.proxies_priv' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.proxies_priv' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.rds_configuration' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.rds_configuration' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.rds_global_status_history' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.rds_global_status_history' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.rds_global_status_history_old' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.rds_global_status_history_old' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.rds_heartbeat2' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.rds_heartbeat2' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.rds_history' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.rds_history' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.rds_replication_status' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.rds_replication_status' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.rds_sysinfo' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.rds_sysinfo' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.role_edges' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.role_edges' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.server_cost' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.server_cost' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.servers' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.servers' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.slave_master_info' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.slave_master_info' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.slave_relay_log_info' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.slave_relay_log_info' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.slave_worker_info' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.slave_worker_info' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.slow_log' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.slow_log' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.slow_log_backup' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.slow_log_backup' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.slow_log_template' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.slow_log_template' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.tables_priv' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.tables_priv' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.time_zone' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.time_zone' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.time_zone_leap_second' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.time_zone_leap_second' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.time_zone_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.time_zone_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.time_zone_transition' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.time_zone_transition' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.time_zone_transition_type' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.time_zone_transition_type' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'mysql.user' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'mysql.user' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.accounts' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.accounts' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.cond_instances' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.cond_instances' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.data_lock_waits' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.data_lock_waits' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.data_locks' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.data_locks' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_errors_summary_by_account_by_error' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_errors_summary_by_account_by_error' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_errors_summary_by_host_by_error' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_errors_summary_by_host_by_error' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_errors_summary_by_thread_by_error' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_errors_summary_by_thread_by_error' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_errors_summary_by_user_by_error' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_errors_summary_by_user_by_error' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_errors_summary_global_by_error' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_errors_summary_global_by_error' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_stages_current' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_stages_current' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_stages_history' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_stages_history' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_stages_history_long' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_stages_history_long' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_stages_summary_by_account_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_stages_summary_by_account_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_stages_summary_by_host_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_stages_summary_by_host_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_stages_summary_by_thread_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_stages_summary_by_thread_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_stages_summary_by_user_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_stages_summary_by_user_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_stages_summary_global_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_stages_summary_global_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_current' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_current' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_histogram_by_digest' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_histogram_by_digest' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_histogram_global' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_histogram_global' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_history' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_history' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_history_long' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_history_long' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_summary_by_account_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_summary_by_account_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_summary_by_digest' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_summary_by_digest' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_summary_by_host_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_summary_by_host_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_summary_by_program' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_summary_by_program' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_summary_by_thread_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_summary_by_thread_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_summary_by_user_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_summary_by_user_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_statements_summary_global_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_statements_summary_global_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_transactions_current' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_transactions_current' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_transactions_history' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_transactions_history' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_transactions_history_long' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_transactions_history_long' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_transactions_summary_by_account_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_transactions_summary_by_account_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_transactions_summary_by_host_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_transactions_summary_by_host_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_transactions_summary_by_thread_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_transactions_summary_by_thread_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_transactions_summary_by_user_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_transactions_summary_by_user_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_transactions_summary_global_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_transactions_summary_global_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_current' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_current' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_history' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_history' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_history_long' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_history_long' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_summary_by_account_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_summary_by_account_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_summary_by_host_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_summary_by_host_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_summary_by_instance' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_summary_by_instance' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_summary_by_thread_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_summary_by_thread_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_summary_by_user_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_summary_by_user_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.events_waits_summary_global_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.events_waits_summary_global_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.file_instances' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.file_instances' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.file_summary_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.file_summary_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.file_summary_by_instance' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.file_summary_by_instance' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.global_status' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.global_status' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.global_variables' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.global_variables' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.host_cache' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.host_cache' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.hosts' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.hosts' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.keyring_keys' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.keyring_keys' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.log_status' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.log_status' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.memory_summary_by_account_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.memory_summary_by_account_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.memory_summary_by_host_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.memory_summary_by_host_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.memory_summary_by_thread_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.memory_summary_by_thread_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.memory_summary_by_user_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.memory_summary_by_user_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.memory_summary_global_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.memory_summary_global_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.metadata_locks' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.metadata_locks' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.mutex_instances' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.mutex_instances' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.objects_summary_global_by_type' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.objects_summary_global_by_type' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.performance_timers' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.performance_timers' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.persisted_variables' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.persisted_variables' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.prepared_statements_instances' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.prepared_statements_instances' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_applier_configuration' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_applier_configuration' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_applier_filters' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_applier_filters' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_applier_global_filters' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_applier_global_filters' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_applier_status' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_applier_status' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_applier_status_by_coordinator' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_applier_status_by_coordinator' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_applier_status_by_worker' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_applier_status_by_worker' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_connection_configuration' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_connection_configuration' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_connection_status' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_connection_status' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_group_member_stats' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_group_member_stats' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.replication_group_members' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.replication_group_members' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.rwlock_instances' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.rwlock_instances' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.session_account_connect_attrs' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.session_account_connect_attrs' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.session_connect_attrs' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.session_connect_attrs' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.session_status' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.session_status' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.session_variables' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.session_variables' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.setup_actors' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.setup_actors' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.setup_consumers' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.setup_consumers' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.setup_instruments' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.setup_instruments' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.setup_objects' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.setup_objects' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.setup_threads' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.setup_threads' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.socket_instances' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.socket_instances' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.socket_summary_by_event_name' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.socket_summary_by_event_name' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.socket_summary_by_instance' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.socket_summary_by_instance' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.status_by_account' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.status_by_account' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.status_by_host' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.status_by_host' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.status_by_thread' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.status_by_thread' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.status_by_user' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.status_by_user' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.table_handles' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.table_handles' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.table_io_waits_summary_by_index_usage' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.table_io_waits_summary_by_index_usage' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.table_io_waits_summary_by_table' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.table_io_waits_summary_by_table' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.table_lock_waits_summary_by_table' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.table_lock_waits_summary_by_table' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.threads' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.threads' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.user_defined_functions' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.user_defined_functions' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.user_variables_by_thread' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.user_variables_by_thread' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.users' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.users' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.variables_by_thread' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.variables_by_thread' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'performance_schema.variables_info' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'performance_schema.variables_info' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:394 - including 'sys.sys_config' among known tables 2020-01-08 10:35:36 INFO SnapshotReader:404 - 'sys.sys_config' is filtered out of capturing 2020-01-08 10:35:36 INFO SnapshotReader:433 - snapshot continuing with database(s): [innodb, employees] 2020-01-08 10:35:36 DEBUG MySqlJdbcContext:271 - GRANT SELECT, RELOAD, SHOW DATABASES, LOCK TABLES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO `debezium`@`%` 2020-01-08 10:35:36 DEBUG MySqlJdbcContext:271 - GRANT BACKUP_ADMIN ON *.* TO `debezium`@`%` 2020-01-08 10:35:36 INFO SnapshotReader:449 - Step 5: flush and obtain read lock for 156 tables (preventing writes) 2020-01-08 10:35:36 INFO SnapshotReader:876 - Step 6: read binlog position of MySQL master 2020-01-08 10:35:36 INFO SnapshotReader:888 - using binlog 'mysql-bin-changelog.015187' at position '155' and gtid '' 2020-01-08 10:35:36 INFO SnapshotReader:479 - Step 7: generating DROP and CREATE statements to reflect current database schemas: 2020-01-08 10:35:37 INFO SnapshotReader:1032 - SET character_set_server=utf8mb4, collation_server=utf8mb4_0900_ai_ci;SET character_set_server=utf8mb4, collation_server=utf8mb4_0900_ai_ci; 2020-01-08 10:35:37 INFO SnapshotReader:1032 - DROP TABLE IF EXISTS departments; 2020-01-08 10:35:37 INFO SnapshotReader:1032 - DROP TABLE IF EXISTS dept_emp; 2020-01-08 10:35:37 INFO SnapshotReader:1032 - DROP TABLE IF EXISTS dept_manager; 2020-01-08 10:35:37 INFO SnapshotReader:1032 - DROP TABLE IF EXISTS employees; 2020-01-08 10:35:37 INFO SnapshotReader:1032 - DROP TABLE IF EXISTS salaries; 2020-01-08 10:35:37 INFO SnapshotReader:1032 - DROP TABLE IF EXISTS titles; 2020-01-08 10:35:37 DEBUG EmbeddedEngine:815 - Embedded engine returned from polling task for records 2020-01-08 10:35:37 DEBUG EmbeddedEngine:830 - Received 7 records from the task 2020-01-08 10:35:37 DEBUG DebeziumRunner:82 - Table Name=NO TABLE ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:37 DEBUG DebeziumRunner:82 - Table Name=departments ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:37 DEBUG DebeziumRunner:82 - Table Name=dept_emp ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:37 DEBUG DebeziumRunner:82 - Table Name=dept_manager ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:37 DEBUG DebeziumRunner:82 - Table Name=employees ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:37 DEBUG DebeziumRunner:82 - Table Name=salaries ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:37 DEBUG DebeziumRunner:82 - Table Name=titles ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:37 DEBUG EmbeddedEngine:813 - Embedded engine is polling task for records on thread Thread[pool-1-thread-1,5,main] 2020-01-08 10:35:38 INFO SnapshotReader:1032 - DROP DATABASE IF EXISTS `employees` 2020-01-08 10:35:38 INFO SnapshotReader:1032 - CREATE DATABASE `employees` 2020-01-08 10:35:38 INFO SnapshotReader:1032 - USE `employees` 2020-01-08 10:35:38 DEBUG EmbeddedEngine:815 - Embedded engine returned from polling task for records 2020-01-08 10:35:38 DEBUG EmbeddedEngine:830 - Received 3 records from the task 2020-01-08 10:35:38 DEBUG DebeziumRunner:82 - Table Name=NO TABLE ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:38 DEBUG DebeziumRunner:82 - Table Name=NO TABLE ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:38 DEBUG DebeziumRunner:82 - Table Name=NO TABLE ,Operation=No Data Operation, Columnsnull 2020-01-08 10:35:38 DEBUG EmbeddedEngine:813 - Embedded engine is polling task for records on thread Thread[pool-1-thread-1,5,main] 2020-01-08 10:35:38 INFO SnapshotReader:1032 - CREATE TABLE `departments` ( `dept_no` char(4) NOT NULL, `dept_name` varchar(40) NOT NULL, PRIMARY KEY (`dept_no`), UNIQUE KEY `dept_name` (`dept_name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 2020-01-08 10:35:38 DEBUG TableSchemaBuilder:101 - Mapping table 'employees.departments' to schemas under 'my-app-connector.employees.departments' 2020-01-08 10:35:38 WARN MySqlSchema:172 - The Kafka Connect schema name 'my-app-connector.employees.departments.Value' is not a valid Avro schema name, so replacing with 'my_app_connector.employees.departments.Value' 2020-01-08 10:35:38 WARN MySqlSchema:172 - The Kafka Connect schema name 'my-app-connector.employees.departments.Key' is not a valid Avro schema name, so replacing with 'my_app_connector.employees.departments.Key' 2020-01-08 10:35:38 DEBUG TableSchemaBuilder:379 - - field 'dept_no' (STRING) from column dept_no CHAR(4) CHARSET latin1 NOT NULL 2020-01-08 10:35:38 DEBUG TableSchemaBuilder:379 - - field 'dept_no' (STRING) from column dept_no CHAR(4) CHARSET latin1 NOT NULL 2020-01-08 10:35:38 DEBUG TableSchemaBuilder:379 - - field 'dept_name' (STRING) from column dept_name VARCHAR(40) CHARSET latin1 NOT NULL 2020-01-08 10:35:38 DEBUG TableSchemaBuilder:124 - Mapped primary key for table 'employees.departments' to schema: {"name" : "my_app_connector.employees.departments.Key", "type" : "STRUCT", "optional" : "false", "fields" : [{"name" : "dept_no", "index" : "0", "schema" : {"type" : "STRING", "optional" : "false"}}]} 2020-01-08 10:35:38 DEBUG TableSchemaBuilder:125 - Mapped columns for table 'employees.departments' to schema: {"name" : "my_app_connector.employees.departments.Value", "type" : "STRUCT", "optional" : "true", "fields" : [{"name" : "dept_no", "index" : "0", "schema" : {"type" : "STRING", "optional" : "false"}}, {"name" : "dept_name", "index" : "1", "schema" : {"type" : "STRING", "optional" : "false"}}]} 2020-01-08 10:35:38 WARN MySqlSchema:172 - The Kafka Connect schema name 'my-app-connector.employees.departments.Envelope' is not a valid Avro schema name, so replacing with 'my_app_connector.employees.departments.Envelope' 2020-01-08 10:35:38 DEBUG MySqlValueConverters:294 - Using windows-1252 charset by default for column: dept_no CHAR(4) CHARSET latin1 NOT NULL 2020-01-08 10:35:38 DEBUG MySqlValueConverters:294 - Using windows-1252 charset by default for column: dept_no CHAR(4) CHARSET latin1 NOT NULL 2020-01-08 10:35:38 DEBUG MySqlValueConverters:294 - Using windows-1252 charset by default for column: dept_name VARCHAR(40) CHARSET latin1 NOT NULL 2020-01-08 10:35:38 DEBUG RecordMakers:162 - Clearing table converters 2020-01-08 10:35:38 DEBUG RecordMakers:176 - Regenerating converters for 1 tables 2020-01-08 10:35:38 INFO SnapshotReader:541 - Step 8: tables were locked explicitly, but to get a consistent snapshot we cannot release the locks until we've read all tables. 2020-01-08 10:35:38 INFO SnapshotReader:572 - Step 9: scanning contents of 1 tables while still in transaction 2020-01-08 10:35:38 INFO SnapshotReader:623 - Step 9: - scanning table 'employees.departments' (1 of 1 tables) 2020-01-08 10:35:38 INFO SnapshotReader:628 - For table 'employees.departments' using select statement: 'SELECT * FROM `employees`.`departments`' 2020-01-08 10:35:38 INFO SnapshotReader:665 - Step 9: - Completed scanning a total of 9 rows from table 'employees.departments' after 00:00:00.029 2020-01-08 10:35:38 INFO SnapshotReader:702 - Step 9: scanned 9 rows in 1 tables in 00:00:00.092 2020-01-08 10:35:38 INFO SnapshotReader:739 - Step 10: committing transaction 2020-01-08 10:35:38 INFO SnapshotReader:755 - Step 11: releasing table read locks to enable MySQL writes 2020-01-08 10:35:38 INFO SnapshotReader:767 - Writes to MySQL prevented for a total of 00:00:02.093 2020-01-08 10:35:38 INFO SnapshotReader:774 - Step 12: reading table schema for non-whitelisted tables 2020-01-08 10:35:38 ERROR SnapshotReader:208 - Failed due to error: Aborting snapshot due to error when last running 'SHOW CREATE TABLE `performance_schema`.`accounts`': Invalid value: null used for required field: "db", schema type: STRING org.apache.kafka.connect.errors.ConnectException: Invalid value: null used for required field: "db", schema type: STRING at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230) at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:207) at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:839) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.apache.kafka.connect.errors.DataException: Invalid value: null used for required field: "db", schema type: STRING at org.apache.kafka.connect.data.ConnectSchema.validateValue(ConnectSchema.java:220) at org.apache.kafka.connect.data.Struct.put(Struct.java:216) at org.apache.kafka.connect.data.Struct.put(Struct.java:203) at io.debezium.connector.AbstractSourceInfoStructMaker.commonStruct(AbstractSourceInfoStructMaker.java:54) at io.debezium.connector.mysql.MySqlSourceInfoStructMaker.struct(MySqlSourceInfoStructMaker.java:40) at io.debezium.connector.mysql.MySqlSourceInfoStructMaker.struct(MySqlSourceInfoStructMaker.java:14) at io.debezium.connector.AbstractSourceInfo.struct(AbstractSourceInfo.java:76) at io.debezium.connector.mysql.RecordMakers.schemaChangeRecordValue(RecordMakers.java:379) at io.debezium.connector.mysql.RecordMakers.schemaChanges(RecordMakers.java:145) at io.debezium.connector.mysql.SnapshotReader.enqueueSchemaChanges(SnapshotReader.java:1031) at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:346) at io.debezium.connector.mysql.SnapshotReader.lambda$readTableSchema$15(SnapshotReader.java:857) at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:453) at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:394) at io.debezium.connector.mysql.SnapshotReader.readTableSchema(SnapshotReader.java:855) at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:779) ... 3 more 2020-01-08 10:35:38 DEBUG EmbeddedEngine:858 - Stopping the task and engine 2020-01-08 10:35:38 INFO MySqlConnectorTask:446 - Stopping MySQL connector task 2020-01-08 10:35:38 INFO ChainedReader:121 - ChainedReader: Stopping the snapshot reader 2020-01-08 10:35:38 INFO SnapshotReader:129 - Discarding 10 unsent record(s) due to the connector shutting down 2020-01-08 10:35:38 DEBUG SnapshotReader:139 - Stopping snapshot reader 2020-01-08 10:35:38 DEBUG SnapshotReader:147 - Completed writing all snapshot records 2020-01-08 10:35:38 INFO SnapshotReader:129 - Discarding 0 unsent record(s) due to the connector shutting down 2020-01-08 10:35:38 DEBUG SnapshotReader:139 - Stopping snapshot reader 2020-01-08 10:35:38 DEBUG SnapshotReader:147 - Completed writing all snapshot records 2020-01-08 10:35:38 DEBUG SnapshotReader:147 - Completed writing all snapshot records 2020-01-08 10:35:38 DEBUG MySqlTaskContext:252 - Stopping database history 2020-01-08 10:35:38 INFO MySqlConnectorTask:484 - Connector task finished all work and is now shutdown 2020-01-08 10:35:38 DEBUG SnapshotReader:147 - Completed writing all snapshot records 2020-01-08 10:35:38 DEBUG OffsetStorageWriter:166 - Submitting 1 entries to backing store. The offsets are: {{server=my-app-connector}={file=mysql-bin-changelog.015187, pos=155, snapshot=true}} 2020-01-08 10:35:38 INFO FileOffsetBackingStore:66 - Stopped FileOffsetBackingStore 2020-01-08 10:35:38 DEBUG DebeziumRunner:155 - Done, was a success=false, Error while trying to run connector class 'io.debezium.connector.mysql.MySqlConnector' .org.apache.kafka.connect.errors.ConnectException: Invalid value: null used for required field: "db", schema type: STRING