-- Boot 832759dab8c8473f9b1d5f3f050f5251 -- Feb 22 11:51:09 sql-cluster-1-new systemd[1]: Starting MariaDB 10.10.2 database server... Feb 22 11:51:16 sql-cluster-1-new sh[878]: WSREP: Recovered position b3a9e948-8dbc-11ed-a590-9a26952cd684:44975166 Feb 22 11:51:16 sql-cluster-1-new mariadbd[1679]: 2023-02-22 11:51:16 0 [Note] /usr/sbin/mariadbd (server 10.10.2-MariaDB-1:10.10.2+maria~ubu2204-log) starting as process 1679 ... Feb 22 11:51:16 sql-cluster-1-new mariadbd[1679]: 2023-02-22 11:51:16 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 160254) Feb 22 11:51:23 sql-cluster-1-new -wsrep-sst-joiner[2003]: Galera co-ords from recovery: b3a9e948-8dbc-11ed-a590-9a26952cd684:44975166 0 Feb 22 11:51:23 sql-cluster-1-new -wsrep-sst-joiner[2004]: Total time on joiner: 0 seconds Feb 22 11:51:23 sql-cluster-1-new -wsrep-sst-joiner[2009]: Cleaning up temporary directories Feb 22 11:51:24 sql-cluster-1-new systemd[1]: Started MariaDB 10.10.2 database server. Feb 22 11:51:24 sql-cluster-1-new /etc/mysql/debian-start[2053]: Upgrading MySQL tables if necessary. Feb 22 11:51:24 sql-cluster-1-new debian-start[2068]: ERROR 1047 (08S01) at line 1: WSREP has not yet prepared node for application use --> issue happening at about Feb 23 11:00:00, but no entry here Feb 23 11:33:11 sql-cluster-1-new systemd[1]: Stopping MariaDB 10.10.2 database server... Feb 23 11:33:16 sql-cluster-1-new systemd[1]: mariadb.service: Deactivated successfully. Feb 23 11:33:16 sql-cluster-1-new systemd[1]: Stopped MariaDB 10.10.2 database server. Feb 23 11:33:16 sql-cluster-1-new systemd[1]: mariadb.service: Consumed 22h 26min 18.203s CPU time. -- Boot f4bf5df454c3486b9ba2667c03fee1c3 -- Feb 23 11:33:33 sql-cluster-1-new systemd[1]: Starting MariaDB 10.10.2 database server... Feb 23 11:33:36 sql-cluster-1-new sh[879]: WSREP: Recovered position b3a9e948-8dbc-11ed-a590-9a26952cd684:46125123 Feb 23 11:33:36 sql-cluster-1-new mariadbd[1330]: 2023-02-23 11:33:36 0 [Note] /usr/sbin/mariadbd (server 10.10.2-MariaDB-1:10.10.2+maria~ubu2204-log) starting as process 1330 ... Feb 23 11:33:36 sql-cluster-1-new mariadbd[1330]: 2023-02-23 11:33:36 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 160254) Feb 23 11:33:39 sql-cluster-1-new -wsrep-sst-joiner[1844]: Evaluating timeout -k 310 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | '/usr//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) Feb 23 11:33:39 sql-cluster-1-new -wsrep-sst-joiner[1861]: Galera co-ords from recovery: b3a9e948-8dbc-11ed-a590-9a26952cd684:46125123 0 Feb 23 11:33:39 sql-cluster-1-new -wsrep-sst-joiner[1863]: mariabackup IST completed on joiner Feb 23 11:33:39 sql-cluster-1-new -wsrep-sst-joiner[1865]: Removing the sst_in_progress file Feb 23 11:33:39 sql-cluster-1-new -wsrep-sst-joiner[1867]: Cleaning up temporary directories Feb 23 11:33:41 sql-cluster-1-new systemd[1]: Started MariaDB 10.10.2 database server. Feb 23 11:33:41 sql-cluster-1-new /etc/mysql/debian-start[2019]: Upgrading MySQL tables if necessary. Feb 23 11:33:41 sql-cluster-1-new /etc/mysql/debian-start[2032]: Checking for insecure root accounts. Feb 23 12:28:04 sql-cluster-1-new systemd[1]: Stopping MariaDB 10.10.2 database server... -- Boot ae296ddd57fd4efa86087e7073295058 -- Feb 23 12:30:14 sql-cluster-1-new systemd[1]: Starting MariaDB 10.10.2 database server... Feb 23 12:30:19 sql-cluster-1-new sh[880]: WSREP: Recovered position b3a9e948-8dbc-11ed-a590-9a26952cd684:46151343 Feb 23 12:30:19 sql-cluster-1-new mariadbd[1610]: 2023-02-23 12:30:19 0 [Note] /usr/sbin/mariadbd (server 10.10.2-MariaDB-1:10.10.2+maria~ubu2204-log) starting as process 1610 ... Feb 23 12:30:19 sql-cluster-1-new mariadbd[1610]: 2023-02-23 12:30:19 0 [Warning] Could not increase number of max_open_files to more than 32768 (request: 160254) Feb 23 12:30:23 sql-cluster-1-new -wsrep-sst-joiner[1992]: Cleaning up temporary directories Feb 23 12:30:24 sql-cluster-1-new systemd[1]: Started MariaDB 10.10.2 database server. Feb 23 12:30:24 sql-cluster-1-new /etc/mysql/debian-start[2036]: Upgrading MySQL tables if necessary. Feb 23 12:30:24 sql-cluster-1-new debian-start[2054]: ERROR 1047 (08S01) at line 1: WSREP has not yet prepared node for application use Feb 23 12:31:11 sql-cluster-1-new -wsrep-sst-donor[2275]: Using socat as streamer Feb 23 12:31:11 sql-cluster-1-new -wsrep-sst-donor[2278]: Evaluating '/usr//bin/mbstream' -c 'xtrabackup_galera_info' 'xtrabackup_ist' | socat -u stdio TCP:172.16.98.22:4444; RC=( ${PIPESTATUS[@]} ) Feb 23 12:31:11 sql-cluster-1-new -wsrep-sst-donor[2285]: Cleaning up temporary directories Feb 23 12:32:08 sql-cluster-1-new -wsrep-sst-donor[2474]: Streaming with mbstream Feb 23 12:32:08 sql-cluster-1-new -wsrep-sst-donor[2478]: Evaluating '/usr//bin/mbstream' -c 'xtrabackup_galera_info' 'xtrabackup_ist' | socat -u stdio TCP:172.16.98.33:4444; RC=( ${PIPESTATUS[@]} ) Feb 23 12:32:08 sql-cluster-1-new -wsrep-sst-donor[2481]: Total time on donor: 0 seconds Feb 23 12:32:08 sql-cluster-1-new -wsrep-sst-donor[2482]: mariabackup IST completed on donor Feb 23 12:32:08 sql-cluster-1-new -wsrep-sst-donor[2485]: Cleaning up temporary directories Feb 23 12:33:15 sql-cluster-1-new -wsrep-sst-donor[2683]: Streaming with mbstream Feb 23 12:33:15 sql-cluster-1-new -wsrep-sst-donor[2684]: Using socat as streamer