2023-05-18T18:51:54.720550+08:00 0 [Warning] [MY-011069] [Server] The syntax '--transaction-write-set-extraction' is deprecated and will be removed in a future release.
2023-05-18T18:51:54.720560+08:00 0 [Warning] [MY-011069] [Server] The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release.
2023-05-18T18:51:54.720569+08:00 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2023-05-18T18:51:54.720576+08:00 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2023-05-18T18:51:54.722732+08:00 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2023-05-18T18:51:54.722794+08:00 0 [Note] [MY-013932] [Server] BuildID[sha1]=2322a98ee785d298cbc399f95a31b9671531a40b
2023-05-18T18:51:54.722800+08:00 0 [Note] [MY-010949] [Server] Basedir set to /u01/app/8.0.33/usr/.
2023-05-18T18:51:54.722811+08:00 0 [System] [MY-010116] [Server] /u01/app/mnotintt1/usr/sbin/mysqld (mysqld 8.0.33) starting as process 1516726
2023-05-18T18:51:54.745370+08:00 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 00d1f9cf-f56a-11ed-a9f2-005056a0ddac.
2023-05-18T18:51:54.748039+08:00 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2023-05-18T18:51:54.748352+08:00 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2023-05-18T18:51:54.748449+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled.
2023-05-18T18:51:54.748474+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled.
2023-05-18T18:51:54.748488+08:00 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled.
2023-05-18T18:51:54.748541+08:00 0 [Note] [MY-010747] [Server] Plugin 'mysqlx' is disabled.
2023-05-18T18:51:54.750059+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-05-18T18:51:54.750113+08:00 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2023-05-18T18:51:54.750173+08:00 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2023-05-18T18:51:54.750194+08:00 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2023-05-18T18:51:54.750204+08:00 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2023-05-18T18:51:54.750216+08:00 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.13
2023-05-18T18:51:54.754009+08:00 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2023-05-18T18:51:54.754839+08:00 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2023-05-18T18:51:54.754924+08:00 1 [Note] [MY-012204] [InnoDB] Scanning './'
2023-05-18T18:51:54.771073+08:00 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 33 files.
2023-05-18T18:51:54.772140+08:00 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 4.000000G, instances = 8, chunk size =128.000000M 
2023-05-18T18:51:55.002077+08:00 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2023-05-18T18:51:55.019628+08:00 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-05-18T18:51:55.020530+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2023-05-18T18:51:55.021835+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2023-05-18T18:51:55.040832+08:00 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2023-05-18T18:51:55.040869+08:00 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2023-05-18T18:51:55.040902+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2023-05-18T18:51:55.040938+08:00 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2023-05-18T18:51:55.079229+08:00 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 3933563989 in redo log file /u01/mydata/mnotintt1/#innodb_redo/#ib_redo0.
2023-05-18T18:51:55.079358+08:00 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 3933563951, whereas checkpoint_lsn = 3933563989 and start_lsn = 3933563904
2023-05-18T18:51:55.088439+08:00 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2023-05-18T18:51:55.089932+08:00 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2023-05-18T18:51:55.089968+08:00 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2023-05-18T18:51:55.090147+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undotbs/undo_001'.
2023-05-18T18:51:55.090955+08:00 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undotbs/undo_002'.
2023-05-18T18:51:55.092385+08:00 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2023-05-18T18:51:55.092449+08:00 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 5192720
2023-05-18T18:51:55.100827+08:00 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2023-05-18T18:51:55.100868+08:00 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 8423 ms.
2023-05-18T18:51:55.100949+08:00 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2023-05-18T18:51:55.101023+08:00 1 [Note] [MY-012265] [InnoDB] Setting file '/u01/mydata/mnotintt1/ibtmp1' size to 512 MB. Physically writing the file full; Please wait ...
2023-05-18T18:51:55.116822+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 10%
2023-05-18T18:51:55.131962+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 20%
2023-05-18T18:51:55.147105+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 30%
2023-05-18T18:51:55.162910+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 40%
2023-05-18T18:51:55.177999+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 50%
2023-05-18T18:51:55.193658+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 60%
2023-05-18T18:51:55.208953+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 70%
2023-05-18T18:51:55.223812+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 80%
2023-05-18T18:51:55.238882+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 90%
2023-05-18T18:51:55.253610+08:00 1 [Note] [MY-012887] [InnoDB] Setting file /u01/mydata/mnotintt1/ibtmp1 size to 512 MB. Progress : 100%
2023-05-18T18:51:55.564178+08:00 1 [Note] [MY-012266] [InnoDB] File '/u01/mydata/mnotintt1/ibtmp1' size is now 512 MB.
2023-05-18T18:51:55.564357+08:00 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2023-05-18T18:51:55.572362+08:00 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2023-05-18T18:51:55.572702+08:00 1 [Note] [MY-012976] [InnoDB] 8.0.33 started; log sequence number 3933563999
2023-05-18T18:51:55.573479+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-05-18T18:51:55.580224+08:00 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
2023-05-18T18:51:55.651381+08:00 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2023-05-18T18:51:55.655087+08:00 1 [Note] [MY-012356] [InnoDB] Scanned 35 tablespaces. Validated 35.
2023-05-18T18:51:55.664361+08:00 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2023-05-18T18:51:55.669837+08:00 0 [Note] [MY-011130] [Repl] Semi-sync replication initialized for transactions.
2023-05-18T18:51:55.669872+08:00 0 [Note] [MY-011142] [Repl] Semi-sync replication enabled on the source.
2023-05-18T18:51:55.670146+08:00 0 [Note] [MY-011166] [Repl] Starting ack receiver thread.
2023-05-18T18:51:55.684454+08:00 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2023-05-18T18:51:55.686907+08:00 0 [Note] [MY-010856] [Server] Failed to open the crashed binlog file when source server is recovering it.
2023-05-18T18:51:55.693331+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in binlog engine. No attempts to commit, rollback or prepare any transactions.
2023-05-18T18:51:55.693364+08:00 0 [Note] [MY-013911] [Server] Crash recovery finished in InnoDB engine. No attempts to commit, rollback or prepare any transactions.
2023-05-18T18:51:55.695039+08:00 0 [Note] [MY-012487] [InnoDB] DDL log recovery : begin
2023-05-18T18:51:55.695097+08:00 0 [Note] [MY-012488] [InnoDB] DDL log recovery : end
2023-05-18T18:51:55.695234+08:00 0 [Note] [MY-011946] [InnoDB] Loading buffer pool(s) from /u01/mydata/mnotintt1/ib_buffer_pool
2023-05-18T18:51:55.704524+08:00 0 [Note] [MY-011946] [InnoDB] Buffer pool(s) load completed at 230518 18:51:55
2023-05-18T18:51:55.736266+08:00 0 [Note] [MY-010182] [Server] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-05-18T18:51:55.736792+08:00 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-05-18T18:51:55.737902+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-05-18T18:51:55.737943+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-05-18T18:51:55.738231+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --sha256_password_auto_generate_rsa_keys as key files are present in data directory.
2023-05-18T18:51:55.738487+08:00 0 [Note] [MY-010308] [Server] Skipping generation of RSA key pair through --caching_sha2_password_auto_generate_rsa_keys as key files are present in data directory.
2023-05-18T18:51:55.738655+08:00 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '10.123.119.151'; port: 19001
2023-05-18T18:51:55.738681+08:00 0 [Note] [MY-010264] [Server]   - '10.123.119.151' resolves to '10.123.119.151';
2023-05-18T18:51:55.738765+08:00 0 [Note] [MY-010251] [Server] Server socket created on IP: '10.123.119.151'.
2023-05-18T18:51:55.757993+08:00 5 [Note] [MY-011179] [Repl] Replica I/O thread: Start semi-sync replication to source 'replicate@10.123.119.152:19001' in log 'mysql-bin.010500' at position 1589.
2023-05-18T18:51:55.758055+08:00 5 [Warning] [MY-010897] [Repl] Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
2023-05-18T18:51:55.760256+08:00 0 [System] [MY-010931] [Server] /u01/app/mnotintt1/usr/sbin/mysqld: ready for connections. Version: '8.0.33'  socket: '/u01/mydata/mnotintt1/mysql.sock'  port: 19001  MySQL Community Server - GPL.
2023-05-18T18:51:55.760336+08:00 5 [Note] [MY-014000] [Repl] The source server has changed from ':0' with server_uuid 74a73b95-6e1b-11ec-95e4-005056b3321f, to '10.123.119.152:19001' with server_uuid ff7b13c8-f569-11ed-90bc-005056b3813c.
2023-05-18T18:51:55.770729+08:00 5 [System] [MY-014001] [Repl] Replica receiver thread for channel '': connected to source 'replicate@10.123.119.152:19001' with server_uuid=ff7b13c8-f569-11ed-90bc-005056b3813c, server_id=2. Starting replication from file 'mysql-bin.010500', position '1589'.
2023-05-18T18:51:55.774904+08:00 6 [Warning] [MY-010584] [Repl] Replica SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: MY-000000
2023-05-18T18:51:55.775430+08:00 6 [ERROR] [MY-013117] [Repl] Replica SQL for channel '': (null), Error_code: MY-013117
2023-05-18T18:51:55.775748+08:00 6 [Note] [MY-010587] [Repl] Replica SQL thread for channel '' exiting, replication stopped in log 'mysql-bin.010496' at position 4