- Build details

cat docs/INFO_SRC
commit: bf61dba743616af128896221f7395bddc37af3bc
date: 2022-03-23 12:02:41 +0100
build-date: 2022-03-23 13:54:03 +0000
short: bf61dba7436
branch: mysql-8.0.29-release

MySQL source 8.0.29

- Env

 cat /etc/*release
Oracle Linux Server release 7.9
NAME="Oracle Linux Server"
VERSION="7.9"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.9"
PRETTY_NAME="Oracle Linux Server 7.9"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:9:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.9
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.9
Red Hat Enterprise Linux Server release 7.9 (Maipo)
Oracle Linux Server release 7.9


-- 8.0.29/8.0.31 - No issues observed while performing local/remote clone with below steps -

rm -rf Donor/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/Donor --log-error-verbosity=3
bin/mysqld_safe --no-defaults --basedir=$PWD --datadir=$PWD/Donor --core-file --socket=/tmp/mysqlD.sock  --port=3306 --log-error=$PWD/Donor/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_D_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1 --gtid_mode=ON --log-slave-updates --enforce-gtid-consistency --log-bin=donor-bin --server_id=1 2>&1 &


rm -rf Recipient/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/Recipient --log-error-verbosity=3
bin/mysqld_safe --no-defaults --basedir=$PWD --datadir=$PWD/Recipient --core-file --socket=/tmp/mysqlR.sock  --port=3307 --log-error=$PWD/Recipient/log.err --mysqlx-port=33331 --mysqlx-socket=/tmp/mysql_R_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1 --gtid_mode=ON --log-slave-updates --enforce-gtid-consistency --log-bin=donor-bin --server_id=2 2>&1 &

## Donor

bin/mysql -uroot -S /tmp/mysqlD.sock --prompt='Donor>'
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.29 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Donor>INSTALL PLUGIN CLONE SONAME "mysql_clone.so";
Query OK, 0 rows affected (0.01 sec)

Donor>CREATE USER clone_user IDENTIFIED BY "clone_password";
Query OK, 0 rows affected (0.01 sec)

Donor>GRANT BACKUP_ADMIN ON *.* to clone_user;
Query OK, 0 rows affected (0.01 sec)

Donor>GRANT SELECT ON performance_schema.* TO clone_user;
Query OK, 0 rows affected (0.01 sec)

Donor>GRANT EXECUTE ON *.* to clone_user;
Query OK, 0 rows affected (0.00 sec)

Donor>create database if not exists test;
use test;
drop table if exists keyvalue;
CREATE TABLE `keyvalue` (
  `id` bigint(20) unsigned NOT NULL,
  `name1` varchar(250),
  `name2` varchar(250),
  `name3` varchar(250),
  `name4` varchar(250),
  PRIMARY KEY (`id`, name1(10))
) ENGINE=innodb;

set @id:=0;

 insert into `keyvalue` values
  (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
Query OK, 1 row affected (0.01 sec)

Donor>use test;
Database changed
Donor>drop table if exists keyvalue;
Query OK, 0 rows affected, 1 warning (0.01 sec)

Donor>CREATE TABLE `keyvalue` (
    ->   `id` bigint(20) unsigned NOT NULL,
    ->   `name1` varchar(250),
    ->   `name2` varchar(250),
    ->   `name3` varchar(250),
    ->   `name4` varchar(250),
    ->   PRIMARY KEY (`id`, name1(10))
    -> ) ENGINE=innodb;
Query OK, 0 rows affected, 1 warning (0.02 sec)

Donor>
Donor>set @id:=0;
Query OK, 0 rows affected (0.00 sec)

Donor>
Donor> insert into `keyvalue` values
    ->   (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> ,  (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
Query OK, 4 rows affected, 4 warnings (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 4

Donor>
Donor> insert into `keyvalue`(`id`,`name1`,`name2`,`name3`,`name4`)   select  @id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)  from   `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9, `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit  10000000;
Query OK, 10000000 rows affected, 1 warning (2 min 36.97 sec)
Records: 10000000  Duplicates: 0  Warnings: 1

## Recipient

 bin/mysql -uroot -S /tmp/mysqlR.sock --prompt='Recipient>'
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.29 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Recipient>create database if not exists test;
use test;
drop table if exists keyvalue;
CREATE TABLE `keyvalue` (
  `id` bigint(20) unsigned NOT NULL,
  `name1` varchar(250),
  `name2` varchar(250),
  `name3` varchar(250),
  `name4` varchar(250),
  PRIMARY KEY (`id`, name1(10))
) ENGINE=innodb;

set @id:=0;

 insert into `keyvalue` values
  (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
Query OK, 1 row affected (0.00 sec)

Recipient>use test;
Database changed
Recipient>drop table if exists keyvalue;
Query OK, 0 rows affected, 1 warning (0.00 sec)

Recipient>CREATE TABLE `keyvalue` (
    ->   `id` bigint(20) unsigned NOT NULL,
    ->   `name1` varchar(250),
    ->   `name2` varchar(250),
    ->   `name3` varchar(250),
    ->   `name4` varchar(250),
    ->   PRIMARY KEY (`id`, name1(10))
    -> ) ENGINE=innodb;
Query OK, 0 rows affected, 1 warning (0.02 sec)

Recipient>
Recipient>set @id:=0;
Query OK, 0 rows affected (0.00 sec)

Recipient>
Recipient> insert into `keyvalue` values
    ->   (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> ,  (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000))
    -> , (@id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000));
Query OK, 4 rows affected, 4 warnings (0.01 sec)
Records: 4  Duplicates: 0  Warnings: 4

Recipient>
Recipient> insert into `keyvalue`(`id`,`name1`,`name2`,`name3`,`name4`)   select  @id:=@id+1,md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000),md5(rand()*1000000)  from   `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9, `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit  10000000;
Query OK, 10000000 rows affected, 1 warning (2 min 44.98 sec)
Records: 10000000  Duplicates: 0  Warnings: 1

Recipient>INSTALL PLUGIN CLONE SONAME "mysql_clone.so";
Query OK, 0 rows affected (0.01 sec)

Recipient>SET GLOBAL clone_valid_donor_list = "remote-host-ip:3306";
Query OK, 0 rows affected (0.00 sec)

Recipient>CREATE USER clone_user IDENTIFIED BY "clone_password";
Query OK, 0 rows affected (0.01 sec)

Recipient>GRANT CLONE_ADMIN ON *.* to clone_user;
Query OK, 0 rows affected (0.00 sec)

Recipient>GRANT SELECT ON performance_schema.* TO clone_user;
Query OK, 0 rows affected (0.00 sec)

Recipient>GRANT EXECUTE ON *.* to clone_user;
Query OK, 0 rows affected (0.01 sec)

## Re-Start Recipient with innodb_force_recovery=3

Recipient>shutdown;
Query OK, 0 rows affected (0.00 sec)

bin/mysqld_safe --no-defaults --basedir=$PWD --datadir=$PWD/Recipient --core-file --socket=/tmp/mysqlR.sock  --port=3307 --log-error=$PWD/Recipient/log.err --mysqlx-port=33331 --mysqlx-socket=/tmp/mysql_R_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1 --innodb_force_recovery=3 2>&1 &
[1] 15096
[umshastr@support-cluster03:/export/home/tmp/ushastry/mysql-8.0.29]$ 2022-11-30T05:52:50.965520Z mysqld_safe Logging to '/export/home/tmp/ushastry/mysql-8.0.29/Recipient/log.err'.
2022-11-30T05:52:50.983760Z mysqld_safe Starting mysqld daemon with databases from /export/home/tmp/ushastry/mysql-8.0.29/Recipient

[umshastr@support-cluster03:/export/home/tmp/ushastry/mysql-8.0.29]$ bin/mysql -uroot -S /tmp/mysqlR.sock --prompt='Recipient>'                           Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.29 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Recipient>SET GLOBAL clone_valid_donor_list = "remote-host-ip:3306";
Query OK, 0 rows affected (0.00 sec)

Recipient>CLONE INSTANCE FROM 'clone_user'@'remote-host-ip':3306 IDENTIFIED BY "clone_password";
Query OK, 0 rows affected (6.89 sec)

Recipient>Restarting mysqld...
2022-11-30T05:53:30.882816Z mysqld_safe Number of processes running now: 0
2022-11-30T05:53:30.885508Z mysqld_safe mysqld restarted


-- No Errors noted in the Recipient nodes error log

2022-11-30T05:52:51.517700Z 0 [System] [MY-010931] [Server] /export/home/tmp/ushastry/mysql-8.0.29/bin/mysqld: ready for connections. Version: '8.0.29'  socket: '/tmp/mysqlR.sock'  port: 3307  MySQL Community Server - GPL.
2022-11-30T05:53:21.648928Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task Connect.'
2022-11-30T05:53:21.652936Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Master ACK Connect.'
2022-11-30T05:53:21.652972Z 7 [Note] [MY-013457] [InnoDB] Clone Apply Begin Master Version Check
2022-11-30T05:53:21.726068Z 7 [Note] [MY-013457] [InnoDB] Clone Apply Version End Master Task ID: 0 Passed, code: 0:
2022-11-30T05:53:21.765534Z 7 [Note] [MY-013457] [InnoDB] Clone Apply Begin Master Task
2022-11-30T05:53:21.766162Z 7 [Warning] [MY-013460] [InnoDB] Clone removing all user data for provisioning: Started
2022-11-30T05:53:21.766175Z 7 [Note] [MY-011977] [InnoDB] Clone Drop all user data
2022-11-30T05:53:21.844529Z 7 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 183 task: 0
2022-11-30T05:53:21.972468Z 7 [Note] [MY-011977] [InnoDB] Clone Drop User schemas
2022-11-30T05:53:21.972687Z 7 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 5 task: 0
2022-11-30T05:53:21.978875Z 7 [Note] [MY-011977] [InnoDB] Clone Drop User tablespaces
2022-11-30T05:53:21.979326Z 7 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 6 task: 0
2022-11-30T05:53:22.051154Z 7 [Note] [MY-011977] [InnoDB] Clone Drop: finished successfully
2022-11-30T05:53:22.051178Z 7 [Warning] [MY-013460] [InnoDB] Clone removing all user data for provisioning: Finished
2022-11-30T05:53:22.055198Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Command COM_INIT.'
2022-11-30T05:53:22.057465Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State Change : Number of tasks = 1
2022-11-30T05:53:22.057492Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State FILE COPY:
2022-11-30T05:53:22.057574Z 7 [Note] [MY-011978] [InnoDB] Clone estimated size: 2.20 GiB Available space: 1.06 TiB
2022-11-30T05:53:24.026409Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Total Data: 2160 MiB @ 1097 MiB/sec, Network: 2160 MiB @ 1097 MiB/sec.'
2022-11-30T05:53:24.029635Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State Change : Number of tasks = 1
2022-11-30T05:53:24.029653Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State PAGE COPY:
2022-11-30T05:53:24.029702Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Total Data: 2160 MiB @ 1095 MiB/sec, Network: 2160 MiB @ 1095 MiB/sec.'
2022-11-30T05:53:24.032784Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State Change : Number of tasks = 1
2022-11-30T05:53:24.032800Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State REDO COPY:
2022-11-30T05:53:24.032984Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Total Data: 2160 MiB @ 1093 MiB/sec, Network: 2160 MiB @ 1093 MiB/sec.'
2022-11-30T05:53:24.034092Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State Change : Number of tasks = 1
2022-11-30T05:53:24.034113Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State FLUSH DATA:
2022-11-30T05:53:28.295460Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State FLUSH REDO:
2022-11-30T05:53:28.520568Z 7 [Note] [MY-013458] [InnoDB] Clone Apply State DONE
2022-11-30T05:53:28.520644Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Command COM_EXECUTE.'
2022-11-30T05:53:28.520808Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Master ACK COM_EXIT.'
2022-11-30T05:53:28.521078Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Master ACK Disconnect : abort: false.'
2022-11-30T05:53:28.521203Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task COM_EXIT.'
2022-11-30T05:53:28.521311Z 7 [Note] [MY-013272] [Clone] Plugin Clone reported: 'Client: Task Disconnect : abort: false.'
2022-11-30T05:53:28.521467Z 7 [Note] [MY-013457] [InnoDB] Clone Apply End Master Task ID: 0 Passed, code: 0:
2022-11-30T05:53:28.522219Z 0 [Note] [MY-010067] [Server] Giving 2 client threads a chance to die gracefully
2022-11-30T05:53:28.522252Z 0 [Note] [MY-010117] [Server] Shutting down slave threads
2022-11-30T05:53:28.522262Z 0 [Note] [MY-010054] [Server] Event Scheduler: Killing the scheduler thread, thread id 5
2022-11-30T05:53:28.522268Z 0 [Note] [MY-010050] [Server] Event Scheduler: Waiting for the scheduler thread to reply
2022-11-30T05:53:28.522329Z 0 [Note] [MY-010048] [Server] Event Scheduler: Stopped
2022-11-30T05:53:30.522415Z 0 [Note] [MY-010118] [Server] Forcefully disconnecting 1 remaining clients
2022-11-30T05:53:30.522442Z 0 [Warning] [MY-010909] [Server] /export/home/tmp/ushastry/mysql-8.0.29/bin/mysqld: Forcing close of thread 7  user: 'root'.
2022-11-30T05:53:30.522507Z 0 [Note] [MY-010043] [Server] Event Scheduler: Purging the queue. 0 events
2022-11-30T05:53:30.522710Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2022-11-30T05:53:30.524706Z 0 [Note] [MY-010120] [Server] Binlog end
2022-11-30T05:53:30.526572Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'clone'
2022-11-30T05:53:30.526599Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2022-11-30T05:53:30.526922Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2022-11-30T05:53:30.526938Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2022-11-30T05:53:30.526943Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2022-11-30T05:53:30.526949Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2022-11-30T05:53:30.526953Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2022-11-30T05:53:30.526961Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-11-30T05:53:30.527003Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2022-11-30T05:53:30.527010Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2022-11-30T05:53:30.527028Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2022-11-30T05:53:30.527036Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2022-11-30T05:53:30.527043Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2022-11-30T05:53:30.527050Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2022-11-30T05:53:30.527057Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2022-11-30T05:53:30.527064Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2022-11-30T05:53:30.527070Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2022-11-30T05:53:30.527082Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2022-11-30T05:53:30.527089Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-11-30T05:53:30.527095Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-11-30T05:53:30.527102Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2022-11-30T05:53:30.527108Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-11-30T05:53:30.527114Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2022-11-30T05:53:30.527120Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-11-30T05:53:30.527127Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2022-11-30T05:53:30.527134Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-11-30T05:53:30.527141Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-11-30T05:53:30.527147Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-11-30T05:53:30.527154Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-11-30T05:53:30.527161Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-11-30T05:53:30.527167Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-11-30T05:53:30.527174Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-11-30T05:53:30.527181Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2022-11-30T05:53:30.527187Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2022-11-30T05:53:30.527194Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2022-11-30T05:53:30.527200Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2022-11-30T05:53:30.527206Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2022-11-30T05:53:30.527232Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2022-11-30T05:53:30.628011Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2022-11-30T05:53:30.830954Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 2462080346
2022-11-30T05:53:30.831965Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2022-11-30T05:53:30.831990Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2022-11-30T05:53:30.831999Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2022-11-30T05:53:30.832006Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'daemon_keyring_proxy_plugin'
2022-11-30T05:53:30.832018Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2022-11-30T05:53:30.832024Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2022-11-30T05:53:30.832030Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2022-11-30T05:53:30.832034Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2022-11-30T05:53:30.832515Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2022-11-30T05:53:30.833240Z 0 [System] [MY-010910] [Server] /export/home/tmp/ushastry/mysql-8.0.29/bin/mysqld: Shutdown complete (mysqld 8.0.29)  MySQL Community Server - GPL.
2022-11-30T05:53:30.882816Z mysqld_safe Number of processes running now: 0
2022-11-30T05:53:30.885508Z mysqld_safe mysqld restarted
2022-11-30T05:53:31.095130Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2022-11-30T05:53:31.095168Z 0 [Note] [MY-010949] [Server] Basedir set to /export/home/tmp/ushastry/mysql-8.0.29/.
2022-11-30T05:53:31.095179Z 0 [System] [MY-010116] [Server] /export/home/tmp/ushastry/mysql-8.0.29/bin/mysqld (mysqld 8.0.29) starting as process 15536
2022-11-30T05:53:31.099176Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2022-11-30T05:53:31.099400Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2022-11-30T05:53:31.100951Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-30T05:53:31.100987Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled
2022-11-30T05:53:31.101024Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2022-11-30T05:53:31.101042Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2022-11-30T05:53:31.101061Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2022-11-30T05:53:31.101073Z 1 [Note] [MY-012946] [InnoDB] !!! innodb_force_recovery is set to 3 !!!
2022-11-30T05:53:31.101088Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2022-11-30T05:53:31.102701Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-11-30T05:53:31.102799Z 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2022-11-30T05:53:31.103178Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './'
2022-11-30T05:53:31.103246Z 1 [Note] [MY-011976] [InnoDB] Clone Old File Roll Forward: Skipped cloned file ./ib_logfile0 state: 101
2022-11-30T05:53:31.103270Z 1 [Note] [MY-011976] [InnoDB] Clone Old File Roll Forward: Skipped cloned file ./ib_logfile1 state: 101
2022-11-30T05:53:31.103328Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file /export/home/tmp/ushastry/mysql-8.0.29/Recipient/ib_buffer_pool state: 101
2022-11-30T05:53:31.103365Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file /export/home/tmp/ushastry/mysql-8.0.29/Recipient/ib_buffer_pool state: 101
2022-11-30T05:53:31.103416Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ibdata1 state: 101
2022-11-30T05:53:31.103448Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ibdata1 state: 101
2022-11-30T05:53:31.103497Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file sys/sys_config.ibd state: 101
2022-11-30T05:53:31.103522Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file sys/sys_config.ibd state: 101
2022-11-30T05:53:31.103570Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file mysql.ibd state: 101
2022-11-30T05:53:31.103601Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file mysql.ibd state: 101
2022-11-30T05:53:31.103644Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ./undo_002 state: 101
2022-11-30T05:53:31.103697Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ./undo_002 state: 101
2022-11-30T05:53:31.103746Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ./undo_001 state: 101
2022-11-30T05:53:31.103774Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ./undo_001 state: 101
2022-11-30T05:53:31.103816Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ./ib_logfile0 state: 101
2022-11-30T05:53:31.103846Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ./ib_logfile0 state: 101
2022-11-30T05:53:31.103878Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Save data file ./ib_logfile1 state: 101
2022-11-30T05:53:31.103910Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Rename clone to data file ./ib_logfile1 state: 101
2022-11-30T05:53:31.104032Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2022-11-30T05:53:31.104297Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 5 files.
2022-11-30T05:53:31.104851Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2022-11-30T05:53:31.110762Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2022-11-30T05:53:31.113706Z 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().
2022-11-30T05:53:31.113988Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2022-11-30T05:53:31.114270Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2022-11-30T05:53:31.209222Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2
2022-11-30T05:53:31.209266Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4
2022-11-30T05:53:31.209302Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite
2022-11-30T05:53:31.209331Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite
2022-11-30T05:53:31.209839Z 1 [Note] [MY-012556] [InnoDB] Opening cloned database
2022-11-30T05:53:31.209865Z 1 [Note] [MY-012560] [InnoDB] The log sequence number 18884745 in the system tablespace does not match the log sequence number 2462130364 in the ib_logfiles!
2022-11-30T05:53:31.209879Z 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2022-11-30T05:53:31.209900Z 1 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2022-11-30T05:53:31.210006Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 2462130212, whereas checkpoint_lsn = 2462130364 and start_lsn = 2462130176
2022-11-30T05:53:31.210021Z 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 2462130411
2022-11-30T05:53:31.212947Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-11-30T05:53:31.213311Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 1 redo log records ...
2022-11-30T05:53:31.213344Z 1 [Note] [MY-012533] [InnoDB] 100%
2022-11-30T05:53:31.216138Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2022-11-30T05:53:31.316286Z 1 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2022-11-30T05:53:31.316730Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-11-30T05:53:31.316958Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-11-30T05:53:31.317807Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-11-30T05:53:31.318708Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2022-11-30T05:53:31.318756Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 1354
2022-11-30T05:53:31.321948Z 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete
2022-11-30T05:53:31.321995Z 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 3239 ms.
2022-11-30T05:53:31.322090Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2022-11-30T05:53:31.322171Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-30T05:53:31.351081Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2022-11-30T05:53:31.351223Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2022-11-30T05:53:31.371242Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2022-11-30T05:53:31.371465Z 1 [Note] [MY-011976] [InnoDB] Clone Old File Roll Forward: Skipped cloned file ./ib_logfile0 state: 11
2022-11-30T05:53:31.371493Z 1 [Note] [MY-011976] [InnoDB] Clone Old File Roll Forward: Skipped cloned file ./ib_logfile1 state: 11
2022-11-30T05:53:31.371605Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file /export/home/tmp/ushastry/mysql-8.0.29/Recipient/ib_buffer_pool state: 11
2022-11-30T05:53:31.372546Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ibdata1 state: 11
2022-11-30T05:53:31.372617Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file sys/sys_config.ibd state: 11
2022-11-30T05:53:31.374359Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file mysql.ibd state: 11
2022-11-30T05:53:31.375501Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ./undo_002 state: 11
2022-11-30T05:53:31.395518Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ./undo_001 state: 11
2022-11-30T05:53:31.398766Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ./ib_logfile0 state: 11
2022-11-30T05:53:31.402014Z 1 [Note] [MY-011976] [InnoDB] Clone File Roll Forward: Remove saved data file ./ib_logfile1 state: 11
2022-11-30T05:53:31.402117Z 1 [Note] [MY-012976] [InnoDB] 8.0.29 started; log sequence number 2462130421
2022-11-30T05:53:31.403092Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-11-30T05:53:31.408307Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'.
2022-11-30T05:53:31.491669Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2022-11-30T05:53:31.492340Z 1 [Note] [MY-012356] [InnoDB] Scanned 7 tablespaces. Validated 7.
2022-11-30T05:53:31.492374Z 1 [Note] [MY-011977] [InnoDB] Clone Fixup: check and create schema directory
2022-11-30T05:53:31.492493Z 1 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 5 task: 0
2022-11-30T05:53:31.492553Z 1 [Note] [MY-011977] [InnoDB] Clone Fixup: create empty MyIsam and CSV tables
2022-11-30T05:53:31.555909Z 1 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 0 task: 1
2022-11-30T05:53:31.556069Z 0 [Note] [MY-011977] [InnoDB] Clone: Fix Object count: 183 task: 0
2022-11-30T05:53:31.560717Z 1 [Note] [MY-011977] [InnoDB] Clone Fixup: replication configuration tables
2022-11-30T05:53:31.560759Z 1 [Note] [MY-011977] [InnoDB] Clone Fixup: finished successfully
2022-11-30T05:53:31.561156Z 1 [Warning] [MY-011018] [InnoDB] Skip updating information_schema metadata in InnoDB read-only mode.
2022-11-30T05:53:31.561182Z 1 [Warning] [MY-010005] [Server] Skip re-populating collations and character sets tables in InnoDB read-only mode.
2022-11-30T05:53:31.561218Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80023'.
2022-11-30T05:53:31.567707Z 0 [Note] [MY-011332] [Server] Plugin mysqlx reported: 'IPv6 is available'
2022-11-30T05:53:31.569391Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. bind-address: '::' port: 33331'
2022-11-30T05:53:31.569417Z 0 [Note] [MY-011323] [Server] Plugin mysqlx reported: 'X Plugin ready for connections. socket: '/tmp/mysql_R_ushastry.sock''
2022-11-30T05:53:31.576531Z 2 [Warning] [MY-011018] [Server] Skip updating information_schema metadata in InnoDB read-only mode.
2022-11-30T05:53:31.576741Z 0 [Note] [MY-010902] [Server] Thread priority attribute setting in Resource Group SQL shall be ignored due to unsupported platform or insufficient privilege.
2022-11-30T05:53:31.577078Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode.
2022-11-30T05:53:31.577098Z 0 [Warning] [MY-010970] [Server] Skipped updating resource group metadata in InnoDB read only mode.
2022-11-30T05:53:31.588566Z 0 [Note] [MY-010913] [Server] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
2022-11-30T05:53:31.593638Z 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.
2022-11-30T05:53:31.593679Z 0 [Note] [MY-010304] [Server] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-11-30T05:53:31.594616Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-11-30T05:53:31.594650Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2022-11-30T05:53:31.594690Z 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.
2022-11-30T05:53:31.594706Z 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.
2022-11-30T05:53:31.594871Z 0 [Note] [MY-010252] [Server] Server hostname (bind-address): '*'; port: 3307
2022-11-30T05:53:31.594913Z 0 [Note] [MY-010253] [Server] IPv6 is available.
2022-11-30T05:53:31.594933Z 0 [Note] [MY-010264] [Server]   - '::' resolves to '::';
2022-11-30T05:53:31.594951Z 0 [Note] [MY-010251] [Server] Server socket created on IP: '::'.
2022-11-30T05:53:31.596198Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/export/home/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2022-11-30T05:53:31.612290Z 0 [Note] [MY-011025] [Repl] Failed to start slave threads for channel ''.
2022-11-30T05:53:31.614173Z 5 [Note] [MY-010051] [Server] Event Scheduler: scheduler thread started with id 5
2022-11-30T05:53:31.614829Z 0 [Note] [MY-011240] [Server] Plugin mysqlx reported: 'Using SSL configuration from MySQL Server'
2022-11-30T05:53:31.615366Z 0 [Note] [MY-011243] [Server] Plugin mysqlx reported: 'Using OpenSSL for TLS connections'
2022-11-30T05:53:31.615469Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33331, socket: /tmp/mysql_R_ushastry.sock
2022-11-30T05:53:31.615504Z 0 [System] [MY-010931] [Server] /export/home/tmp/ushastry/mysql-8.0.29/bin/mysqld: ready for connections. Version: '8.0.29'  socket: '/tmp/mysqlR.sock'  port: 3307  MySQL Community Server - GPL.