2025-05-08T00:31:35.451651Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.41-0ubuntu0.22.04.1) initializing of server in progress as process 8119 2025-05-08T00:31:35.480845Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-05-08T00:31:37.205889Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-05-08T00:31:43.628950Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2025-05-08T00:31:46.515545Z 6 [System] [MY-013172] [Server] Received SHUTDOWN from user boot. Shutting down mysqld (Version: 8.0.41-0ubuntu0.22.04.1). 2025-05-08T00:31:52.931790Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-0ubuntu0.22.04.1) starting as process 8167 2025-05-08T00:31:53.309817Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-05-08T00:31:53.889794Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-05-08T00:31:54.807613Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-05-08T00:31:54.809398Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-05-08T00:31:54.829454Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory. 2025-05-08T00:31:54.875467Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: /var/run/mysqld/mysqlx.sock 2025-05-08T00:31:54.876962Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41-0ubuntu0.22.04.1' socket: '/tmp/tmp.GVSXzzSfyD/mysqld.sock' port: 0 (Ubuntu). 2025-05-08T00:31:54.955487Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.0.41-0ubuntu0.22.04.1). 2025-05-08T00:31:56.551406Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.22.04.1) (Ubuntu). 2025-05-08T00:31:58.948976Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-0ubuntu0.22.04.1) starting as process 8313 2025-05-08T00:31:58.969596Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-05-08T00:32:00.031157Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-05-08T00:32:00.843772Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-05-08T00:32:00.843831Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-05-08T00:32:00.908494Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41-0ubuntu0.22.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu). 2025-05-08T00:32:00.908545Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2025-05-08T00:32:05.296131Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.0.41-0ubuntu0.22.04.1). 2025-05-08T00:32:05.952966Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.22.04.1) (Ubuntu). 2025-05-08T00:32:06.738328Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.41-0ubuntu0.22.04.1) starting as process 8463 2025-05-08T00:32:06.753094Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-05-08T00:32:07.542772Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-05-08T00:32:08.005944Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-05-08T00:32:08.012353Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-05-08T00:32:08.073728Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2025-05-08T00:32:08.073885Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.41-0ubuntu0.22.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu). 2025-05-08T00:34:19.971181Z 14 [ERROR] [MY-011685] [Repl] Plugin group_replication reported: 'The group_replication_group_name option is mandatory' 2025-05-08T00:34:19.971222Z 14 [ERROR] [MY-011660] [Repl] Plugin group_replication reported: 'Unable to start Group Replication on boot' 2025-05-08T00:34:19.982114Z 14 [Warning] [MY-010604] [Repl] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a replica and has his hostname changed!! Please use '--relay-log=juju-33e30c-0-lxd-3-relay-bin' to avoid this problem. 2025-05-08T00:34:19.996204Z 14 [System] [MY-010597] [Repl] 'CHANGE REPLICATION SOURCE TO FOR CHANNEL '__mysql_innodb_cluster_creating_cluster__' executed'. Previous state source_host='', source_port= 3306, source_log_file='', source_log_pos= 4, source_bind=''. New state source_host='', source_port= 3306, source_log_file='', source_log_pos= 4, source_bind=''. 2025-05-08T00:34:20.083029Z 14 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.' 2025-05-08T00:34:20.084458Z 14 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the allowlist. It is mandatory that it is added.' 2025-05-08T00:34:20.084479Z 14 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the allowlist. It is mandatory that it is added.' 2025-05-08T00:34:20.116950Z 19 [System] [MY-010597] [Repl] 'CHANGE REPLICATION SOURCE TO FOR CHANNEL 'group_replication_applier' executed'. Previous state source_host='', source_port= 3306, source_log_file='', source_log_pos= 4, source_bind=''. New state source_host='', source_port= 0, source_log_file='', source_log_pos= 4, source_bind=''. 2025-05-08T00:34:20.584817Z 0 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.' 2025-05-08T00:34:20.585189Z 0 [System] [MY-013471] [Repl] Plugin group_replication reported: 'Distributed recovery will transfer data using: Incremental recovery from a group donor' 2025-05-08T00:34:20.585632Z 0 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.' 2025-05-08T00:34:20.585655Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 252.129.3.20:3306 on view 17466644605822911:1.' 2025-05-08T00:34:20.886177Z 0 [System] [MY-011490] [Repl] Plugin group_replication reported: 'This server was declared online within the replication group.' 2025-05-08T00:34:20.886310Z 0 [System] [MY-011507] [Repl] Plugin group_replication reported: 'A new primary with address 252.129.3.20:3306 was elected. The new primary will execute all previous group transactions before allowing writes.' 2025-05-08T00:34:20.886867Z 29 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.' 2025-05-08T00:34:20.888990Z 27 [System] [MY-013731] [Repl] Plugin group_replication reported: 'The member action "mysql_disable_super_read_only_if_primary" for event "AFTER_PRIMARY_ELECTION" with priority "1" will be run.' 2025-05-08T00:34:20.889022Z 27 [System] [MY-011566] [Repl] Plugin group_replication reported: 'Setting super_read_only=OFF.' 2025-05-08T00:34:20.889097Z 27 [System] [MY-013731] [Repl] Plugin group_replication reported: 'The member action "mysql_start_failover_channels_if_primary" for event "AFTER_PRIMARY_ELECTION" with priority "10" will be run.' 2025-05-08T00:34:20.889415Z 29 [System] [MY-011510] [Repl] Plugin group_replication reported: 'This server is working as primary member.' 2025-05-08T00:34:21.582520Z 14 [System] [MY-014010] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' has been started.' 2025-05-08T00:34:22.288089Z 14 [System] [MY-010597] [Repl] 'CHANGE REPLICATION SOURCE TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state source_host='', source_port= 3306, source_log_file='', source_log_pos= 4, source_bind=''. New state source_host='', source_port= 3306, source_log_file='', source_log_pos= 4, source_bind=''. 2025-05-08T00:34:36.691693Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 252.129.3.20:3306, 252.129.29.12:3306 on view 17466644605822911:2.' 2025-05-08T00:34:39.686930Z 0 [Warning] [MY-011499] [Repl] Plugin group_replication reported: 'Members removed from the group: 252.129.29.12:3306' 2025-05-08T00:34:39.687013Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 252.129.3.20:3306 on view 17466644605822911:3.' 2025-05-08T00:34:52.493322Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 252.129.3.20:3306, 252.129.29.12:3306 on view 17466644605822911:4.' 2025-05-08T00:34:52.805490Z 0 [System] [MY-011492] [Repl] Plugin group_replication reported: 'The member with address 252.129.29.12:3306 was declared online within the replication group.' 2025-05-08T00:35:06.510549Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 252.129.3.20:3306, 252.129.79.218:3306, 252.129.29.12:3306 on view 17466644605822911:5.' 2025-05-08T00:35:08.458297Z 0 [Warning] [MY-011499] [Repl] Plugin group_replication reported: 'Members removed from the group: 252.129.79.218:3306' 2025-05-08T00:35:08.458369Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 252.129.3.20:3306, 252.129.29.12:3306 on view 17466644605822911:6.' 2025-05-08T00:35:22.083299Z 0 [System] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to 252.129.3.20:3306, 252.129.79.218:3306, 252.129.29.12:3306 on view 17466644605822911:7.' 2025-05-08T00:35:22.637933Z 0 [System] [MY-011492] [Repl] Plugin group_replication reported: 'The member with address 252.129.79.218:3306 was declared online within the replication group.'