By type
2023-12-25 01:01:07+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.1.2+maria~ubu2204 started.
2023-12-25 01:01:08+00:00 [Note] [Entrypoint]: Initializing database files
2023-12-25 1:01:08 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
2023-12-25 1:01:08 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2023-12-25 1:01:10 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2023-12-25 1:01:10 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following command:
'/usr/bin/mariadb-secure-installation'
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the MariaDB Knowledgebase at https://mariadb.com/kb
Please report any problems at https://mariadb.org/jira
The latest information about MariaDB is available at https://mariadb.org/.
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
2023-12-25 01:01:30+00:00 [Note] [Entrypoint]: Database files initialized
2023-12-25 01:01:30+00:00 [Note] [Entrypoint]: Starting temporary server
2023-12-25 01:01:30+00:00 [Note] [Entrypoint]: Waiting for server startup
2023-12-25 1:01:30 0 [Note] Starting MariaDB 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 69
2023-12-25 1:01:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-12-25 1:01:30 0 [Note] InnoDB: Number of transaction pools: 1
2023-12-25 1:01:30 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-12-25 1:01:30 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-12-25 1:01:30 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
2023-12-25 1:01:30 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2023-12-25 1:01:30 0 [Note] InnoDB: Initializing buffer pool, total size = 2.000GiB, chunk size = 32.000MiB
2023-12-25 1:01:30 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-25 1:01:30 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2023-12-25 1:01:30 0 [Note] InnoDB: End of log at LSN=47129
2023-12-25 1:01:30 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-12-25 1:01:30 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-12-25 1:01:30 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-12-25 1:01:30 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-12-25 1:01:30 0 [Note] InnoDB: log sequence number 47129; transaction id 14
2023-12-25 1:01:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-25 1:01:30 0 [Note] Plugin 'wsrep-provider' is disabled.
2023-12-25 1:01:30 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2023-12-25 1:01:30 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2023-12-25 1:01:30 0 [Warning] 'user' entry 'root@mariadb-galera-1' ignored in --skip-name-resolve mode.
2023-12-25 1:01:30 0 [Warning] 'proxies_priv' entry '@% root@mariadb-galera-1' ignored in --skip-name-resolve mode.
2023-12-25 1:01:30 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2023-12-25 1:01:30 0 [Note] mariadbd: ready for connections.
Version: '11.1.2-MariaDB-1:11.1.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
2023-12-25 01:01:31+00:00 [Note] [Entrypoint]: Temporary server started.
2023-12-25 01:01:31+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
2023-12-25 01:01:31+00:00 [Note] [Entrypoint]: Stopping temporary server
2023-12-25 1:01:31 0 [Note] mariadbd (initiated by: unknown): Normal shutdown
2023-12-25 1:01:31 0 [Note] InnoDB: FTS optimize thread exiting.
2023-12-25 1:01:31 0 [Note] InnoDB: Starting shutdown...
2023-12-25 1:01:31 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2023-12-25 1:01:31 0 [Note] InnoDB: Buffer pool(s) dump completed at 231225 1:01:31
2023-12-25 1:01:31 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2023-12-25 1:01:31 0 [Note] InnoDB: Shutdown completed; log sequence number 47129; transaction id 15
2023-12-25 1:01:32 0 [Note] mariadbd: Shutdown complete
2023-12-25 01:01:32+00:00 [Note] [Entrypoint]: Temporary server stopped
2023-12-25 01:01:32+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
2023-12-25 1:01:32 0 [Note] Starting MariaDB 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 source revision 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 as process 1
2023-12-25 1:01:32 0 [Note] WSREP: Loading provider /usr/lib/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2023-12-25 1:01:32 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2023-12-25 1:01:32 0 [Note] WSREP: wsrep_load(): Galera 26.4.14(r06a0c285) by Codership Oy loaded successfully.
2023-12-25 1:01:32 0 [Note] WSREP: Initializing allowlist service v1
2023-12-25 1:01:32 0 [Note] WSREP: Initializing event service v1
2023-12-25 1:01:32 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2023-12-25 1:01:32 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2023-12-25 1:01:32 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2023-12-25 1:01:32 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 0
UUID: 00000000-0000-0000-0000-000000000000
Seqno: -1 - -1
Offset: -1
Synced: 0
2023-12-25 1:01:32 0 [Note] WSREP: Skipped GCache ring buffer recovery: could not determine history UUID.
2023-12-25 1:01:32 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = mariadb-galera-1.mariadb-galera-internal.onap.svc.cluster.local; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.keep_plaintext_size = 128M; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.fc_single_primary = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_lim
2023-12-25 1:01:32 0 [Note] WSREP: Start replication
2023-12-25 1:01:32 0 [Note] WSREP: Connecting with bootstrap option: 0
2023-12-25 1:01:32 0 [Note] WSREP: Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1
2023-12-25 1:01:32 0 [Note] WSREP: Using CRC-32C for message checksums.
2023-12-25 1:01:32 0 [Note] WSREP: backend: asio
2023-12-25 1:01:32 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2023-12-25 1:01:32 0 [Note] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2023-12-25 1:01:32 0 [Note] WSREP: restore pc from disk failed
2023-12-25 1:01:32 0 [Note] WSREP: GMCast version 0
2023-12-25 1:01:32 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2023-12-25 1:01:32 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2023-12-25 1:01:32 0 [Note] WSREP: EVS version 1
2023-12-25 1:01:32 0 [Note] WSREP: gcomm: connecting to group 'mariadb-operator', peer 'mariadb-galera-0.mariadb-galera-internal.onap.svc.cluster.local:,mariadb-galera-1.mariadb-galera-internal.onap.svc.cluster.local:,mariadb-galera-2.mariadb-galera-internal.onap.svc.cluster.local:'
2023-12-25 1:01:32 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') Found matching local endpoint for a connection, blacklisting address tcp://10.233.68.198:4567
2023-12-25 1:01:32 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') connection established to 08347a08-a2c6 tcp://10.233.70.122:4567
2023-12-25 1:01:32 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2023-12-25 1:01:32 0 [Note] WSREP: EVS version upgrade 0 -> 1
2023-12-25 1:01:32 0 [Note] WSREP: declaring 08347a08-a2c6 at tcp://10.233.70.122:4567 stable
2023-12-25 1:01:32 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2023-12-25 1:01:32 0 [Note] WSREP: Node 08347a08-a2c6 state prim
2023-12-25 1:01:32 0 [Note] WSREP: view(view_id(PRIM,08347a08-a2c6,2) memb {
08347a08-a2c6,0
24a21a5c-b4ac,0
} joined {
} left {
} partitioned {
})
2023-12-25 1:01:32 0 [Note] WSREP: save pc into disk
2023-12-25 1:01:32 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.233.71.150:4567
2023-12-25 1:01:33 0 [Note] WSREP: gcomm: connected
2023-12-25 1:01:33 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2023-12-25 1:01:33 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2023-12-25 1:01:33 0 [Note] WSREP: Opened channel 'mariadb-operator'
2023-12-25 1:01:33 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
2023-12-25 1:01:33 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-12-25 1:01:33 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 25445354-a2c1-11ee-b525-6f10e26cc168
2023-12-25 1:01:33 0 [Note] WSREP: Initializing config service v1
2023-12-25 1:01:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: 25445354-a2c1-11ee-b525-6f10e26cc168 from 0 (mariadb-galera-0)
2023-12-25 1:01:33 1 [Note] WSREP: Starting rollbacker thread 1
2023-12-25 1:01:33 0 [Note] WSREP: Deinitializing config service v1
2023-12-25 1:01:33 2 [Note] WSREP: Starting applier thread 2
2023-12-25 1:01:33 0 [Note] WSREP: STATE EXCHANGE: got state msg: 25445354-a2c1-11ee-b525-6f10e26cc168 from 1 (mariadb-galera-1)
2023-12-25 1:01:33 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 1,
last_appl. = 0,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235
2023-12-25 1:01:33 0 [Note] WSREP: Flow-control interval: [23, 23]
2023-12-25 1:01:33 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2)
2023-12-25 1:01:33 2 [Note] WSREP: ####### processing CC 2, local, ordered
2023-12-25 1:01:33 2 [Note] WSREP: Process first view: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235 my uuid: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e
2023-12-25 1:01:33 2 [Note] WSREP: Server mariadb-galera-1 connected to cluster at position 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2 with ID 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e
2023-12-25 1:01:33 2 [Note] WSREP: Server status change disconnected -> connected
2023-12-25 1:01:33 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:01:33 2 [Note] WSREP: ####### My UUID: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e
2023-12-25 1:01:33 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: yes
2023-12-25 1:01:33 0 [Note] WSREP: Service thread queue flushed.
2023-12-25 1:01:33 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2023-12-25 1:01:33 2 [Note] WSREP: State transfer required:
Group state: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2
Local state: 00000000-0000-0000-0000-000000000000:-1
2023-12-25 1:01:33 2 [Note] WSREP: Server status change connected -> joiner
2023-12-25 1:01:33 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:01:33 0 [Note] WSREP: Joiner monitor thread started to monitor
2023-12-25 1:01:33 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address 'mariadb-galera-1.mariadb-galera-internal.onap.svc.cluster.local' --datadir '/var/lib/mysql/' --parent 1 --progress 0'
WSREP_SST: [INFO] mariabackup SST started on joiner (20231225 01:01:33.256)
WSREP_SST: [INFO] SSL configuration: CA='', CAPATH='', CERT='', KEY='', MODE='DISABLED', encrypt='0' (20231225 01:01:33.324)
WSREP_SST: [INFO] Progress reporting tool pv not found in path: /usr//bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/sbin:/usr/bin:/sbin:/bin (20231225 01:01:33.494)
WSREP_SST: [INFO] Disabling all progress/rate-limiting (20231225 01:01:33.499)
WSREP_SST: [INFO] Streaming with mbstream (20231225 01:01:33.530)
WSREP_SST: [INFO] Using socat as streamer (20231225 01:01:33.535)
WSREP_SST: [INFO] Evaluating timeout -k 310 300 socat -u TCP-LISTEN:4444,reuseaddr stdio | '/usr//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) (20231225 01:01:33.595)
2023-12-25 1:01:34 2 [Note] WSREP: ####### IST uuid:00000000-0000-0000-0000-000000000000 f: 0, l: 2, STRv: 3
2023-12-25 1:01:34 2 [Note] WSREP: IST receiver addr using tcp://mariadb-galera-1.mariadb-galera-internal.onap.svc.cluster.local:4568
2023-12-25 1:01:34 2 [Note] WSREP: Prepared IST receiver for 0-2, listening at: tcp://10.233.68.198:4568
2023-12-25 1:01:34 0 [Note] WSREP: Member 1.0 (mariadb-galera-1) requested state transfer from '*any*'. Selected 0.0 (mariadb-galera-0)(SYNCED) as donor.
2023-12-25 1:01:34 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 2)
2023-12-25 1:01:34 2 [Note] WSREP: Requesting state transfer: success, donor: 0
2023-12-25 1:01:34 2 [Note] WSREP: Resetting GCache seqno map due to different histories.
2023-12-25 1:01:34 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2
WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | '/usr//bin/mbstream' -x; RC=( ${PIPESTATUS[@]} ) (20231225 01:01:34.836)
WSREP_SST: [INFO] Proceeding with SST (20231225 01:01:34.837)
WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20231225 01:01:34.880)
WSREP_SST: [INFO] Waiting for SST streaming to complete! (20231225 01:01:34.900)
2023-12-25 1:01:35 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') turning message relay requesting off
2023-12-25 1:01:47 0 [Note] WSREP: 0.0 (mariadb-galera-0): State transfer to 1.0 (mariadb-galera-1) complete.
2023-12-25 1:01:47 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql/.sst (20231225 01:01:47.401)
WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --prepare --no-version-check --target-dir='/var/lib/mysql/.sst' --datadir='/var/lib/mysql/.sst' > '/var/lib/mysql/mariabackup.prepare.log' 2>&1 (20231225 01:01:47.408)
WSREP_SST: [INFO] Moving the backup to /var/lib/mysql (20231225 01:01:48.591)
WSREP_SST: [INFO] Evaluating /usr//bin/mariadb-backup --move-back --no-version-check --galera-info --force-non-empty-directories --target-dir='/var/lib/mysql/.sst' --datadir='/var/lib/mysql' > '/var/lib/mysql/mariabackup.move.log' 2>&1 (20231225 01:01:48.596)
WSREP_SST: [INFO] Move successful, removing /var/lib/mysql/.sst (20231225 01:01:48.640)
WSREP_SST: [INFO] Galera co-ords from recovery: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2 (20231225 01:01:48.651)
WSREP_SST: [INFO] Total time on joiner: 0 seconds (20231225 01:01:48.656)
WSREP_SST: [INFO] mariabackup SST completed on joiner (20231225 01:01:48.662)
WSREP_SST: [INFO] Removing the sst_in_progress file (20231225 01:01:48.669)
WSREP_SST: [INFO] Cleaning up temporary directories (20231225 01:01:48.678)
2023-12-25 1:01:48 3 [Note] WSREP: SST received
2023-12-25 1:01:48 3 [Note] WSREP: Server status change joiner -> initializing
2023-12-25 1:01:48 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:01:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-12-25 1:01:48 0 [Note] InnoDB: Number of transaction pools: 1
2023-12-25 1:01:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-12-25 1:01:48 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2023-12-25 1:01:48 0 [Warning] mariadbd: io_uring_queue_init() failed with ENOMEM: try larger memory locked limit, ulimit -l, or https://mariadb.com/kb/en/systemd/#configuring-limitmemlock under systemd (262144 bytes required)
2023-12-25 1:01:48 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2023-12-25 1:01:48 0 [Note] InnoDB: Initializing buffer pool, total size = 2.000GiB, chunk size = 32.000MiB
2023-12-25 1:01:48 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-25 1:01:48 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2023-12-25 1:01:48 0 [Note] InnoDB: End of log at LSN=56662
2023-12-25 1:01:48 0 [Note] InnoDB: Resizing redo log from 12.016KiB to 128.000MiB; LSN=56662
2023-12-25 1:01:48 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2023-12-25 1:01:49 0 [Note] InnoDB: Opened 3 undo tablespaces
2023-12-25 1:01:49 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2023-12-25 1:01:49 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2023-12-25 1:01:49 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2023-12-25 1:01:49 0 [Note] InnoDB: log sequence number 56662; transaction id 32
2023-12-25 1:01:49 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-12-25 1:01:49 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory
2023-12-25 1:01:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-25 1:01:49 0 [Warning] 'innodb-log-files-in-group' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2023-12-25 1:01:49 0 [Warning] 'innodb-file-format' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
2023-12-25 1:01:49 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-12-25 1:01:49 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2023-12-25 1:01:49 0 [Note] WSREP: wsrep_init_schema_and_SR (nil)
2023-12-25 1:01:50 0 [Note] WSREP: Server initialized
2023-12-25 1:01:50 0 [Note] WSREP: Server status change initializing -> initialized
2023-12-25 1:01:50 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:01:50 3 [Note] WSREP: Recovered position from storage: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2
2023-12-25 1:01:50 3 [Note] WSREP: Server status change initialized -> joined
2023-12-25 1:01:50 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:01:50 3 [Note] WSREP: Recovered view from SST:
id: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 1
members(2):
0: 08347a08-a2c1-11ee-a2c6-2b7dfec46b42, mariadb-galera-0
1: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e, mariadb-galera-1
2023-12-25 1:01:50 3 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:01:50 6 [Note] WSREP: Recovered cluster id 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235
2023-12-25 1:01:50 3 [Note] WSREP: SST received: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2
2023-12-25 1:01:50 3 [Note] WSREP: SST succeeded for position 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2
2023-12-25 1:01:50 0 [Note] WSREP: Joiner monitor thread ended with total time 17 sec
2023-12-25 1:01:50 2 [Note] WSREP: Installed new state from SST: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2
2023-12-25 1:01:50 2 [Note] WSREP: Cert. index preload up to 2
2023-12-25 1:01:50 0 [Note] WSREP: ####### IST applying starts with 3
2023-12-25 1:01:50 0 [Note] WSREP: ####### IST current seqno initialized to 2
2023-12-25 1:01:50 0 [Note] WSREP: Receiving IST... 0.0% (0/1 events) complete.
2023-12-25 1:01:50 0 [Note] WSREP: IST preload starting at 2
2023-12-25 1:01:50 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-12-25 1:01:50 0 [Note] WSREP: Service thread queue flushed.
2023-12-25 1:01:50 0 [Note] mariadbd: ready for connections.
Version: '11.1.2-MariaDB-1:11.1.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2023-12-25 1:01:50 0 [Note] WSREP: ####### Assign initial position for certification: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:1, protocol version: 5
2023-12-25 1:01:50 0 [Note] WSREP: REPL Protocols: 10 (5)
2023-12-25 1:01:50 0 [Note] WSREP: ####### Adjusting cert position: 1 -> 2
2023-12-25 1:01:50 0 [Note] WSREP: Service thread queue flushed.
2023-12-25 1:01:50 0 [Note] WSREP: Lowest cert index boundary for CC from preload: 2
2023-12-25 1:01:50 0 [Note] WSREP: Min available from gcache for CC from preload: 2
2023-12-25 1:01:50 0 [Note] WSREP: Receiving IST...100.0% (1/1 events) complete.
2023-12-25 1:01:50 2 [Note] WSREP: IST received: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:2
2023-12-25 1:01:50 2 [Note] WSREP: Lowest cert index boundary for CC from sst: 2
2023-12-25 1:01:50 2 [Note] WSREP: Min available from gcache for CC from sst: 2
2023-12-25 1:01:50 0 [Note] WSREP: 1.0 (mariadb-galera-1): State transfer from 0.0 (mariadb-galera-0) complete.
2023-12-25 1:01:50 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 2)
2023-12-25 1:01:50 0 [Note] WSREP: Processing event queue:... -nan% (0/0 events) complete.
2023-12-25 1:01:50 0 [Note] WSREP: Member 1.0 (mariadb-galera-1) synced with group.
2023-12-25 1:01:50 0 [Note] WSREP: Processing event queue:...100.0% (1/1 events) complete.
2023-12-25 1:01:50 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 2)
2023-12-25 1:01:50 2 [Note] WSREP: Server mariadb-galera-1 synced with group
2023-12-25 1:01:50 2 [Note] WSREP: Server status change joined -> synced
2023-12-25 1:01:50 2 [Note] WSREP: Synchronized with group, ready for connections
2023-12-25 1:01:50 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:03:03 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.233.71.150:4567
2023-12-25 1:03:03 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') connection established to 5b9ab736-8b7d tcp://10.233.71.150:4567
2023-12-25 1:03:04 0 [Note] WSREP: declaring 08347a08-a2c6 at tcp://10.233.70.122:4567 stable
2023-12-25 1:03:04 0 [Note] WSREP: declaring 5b9ab736-8b7d at tcp://10.233.71.150:4567 stable
2023-12-25 1:03:05 0 [Note] WSREP: Node 08347a08-a2c6 state prim
2023-12-25 1:03:05 0 [Note] WSREP: view(view_id(PRIM,08347a08-a2c6,3) memb {
08347a08-a2c6,0
24a21a5c-b4ac,0
5b9ab736-8b7d,0
} joined {
} left {
} partitioned {
})
2023-12-25 1:03:05 0 [Note] WSREP: save pc into disk
2023-12-25 1:03:05 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
2023-12-25 1:03:05 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-12-25 1:03:05 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 5c79a79e-a2c1-11ee-bd4a-d3d923b305f4
2023-12-25 1:03:05 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5c79a79e-a2c1-11ee-bd4a-d3d923b305f4 from 0 (mariadb-galera-0)
2023-12-25 1:03:05 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5c79a79e-a2c1-11ee-bd4a-d3d923b305f4 from 1 (mariadb-galera-1)
2023-12-25 1:03:05 0 [Note] WSREP: STATE EXCHANGE: got state msg: 5c79a79e-a2c1-11ee-bd4a-d3d923b305f4 from 2 (mariadb-galera-2)
2023-12-25 1:03:05 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 2,
members = 2/3 (joined/total),
act_id = 2,
last_appl. = 0,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235
2023-12-25 1:03:05 0 [Note] WSREP: Flow-control interval: [28, 28]
2023-12-25 1:03:05 2 [Note] WSREP: ####### processing CC 3, local, ordered
2023-12-25 1:03:05 2 [Note] WSREP: ####### My UUID: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e
2023-12-25 1:03:05 2 [Note] WSREP: Skipping cert index reset
2023-12-25 1:03:05 2 [Note] WSREP: REPL Protocols: 10 (5)
2023-12-25 1:03:05 2 [Note] WSREP: ####### Adjusting cert position: 2 -> 3
2023-12-25 1:03:05 0 [Note] WSREP: Service thread queue flushed.
2023-12-25 1:03:05 2 [Note] WSREP: ================================================
View:
id: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:3
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 1
members(3):
0: 08347a08-a2c1-11ee-a2c6-2b7dfec46b42, mariadb-galera-0
1: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e, mariadb-galera-1
2: 5b9ab736-a2c1-11ee-8b7d-def43e14f836, mariadb-galera-2
=================================================
2023-12-25 1:03:05 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:03:05 2 [Note] WSREP: Lowest cert index boundary for CC from group: 3
2023-12-25 1:03:05 2 [Note] WSREP: Min available from gcache for CC from group: 2
2023-12-25 1:03:06 0 [Note] WSREP: Member 2.0 (mariadb-galera-2) requested state transfer from '*any*'. Selected 0.0 (mariadb-galera-0)(SYNCED) as donor.
2023-12-25 1:03:07 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') turning message relay requesting off
2023-12-25 1:03:19 0 [Note] WSREP: 0.0 (mariadb-galera-0): State transfer to 2.0 (mariadb-galera-2) complete.
2023-12-25 1:03:19 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
2023-12-25 1:03:23 0 [Note] WSREP: 2.0 (mariadb-galera-2): State transfer from 0.0 (mariadb-galera-0) complete.
2023-12-25 1:03:23 0 [Note] WSREP: Member 2.0 (mariadb-galera-2) synced with group.
2023-12-25 1:03:24 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://10.233.71.150:4567
2023-12-25 1:03:25 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') connection established to 5b9ab736-8b7e tcp://10.233.71.150:4567
2023-12-25 1:03:25 0 [Note] WSREP: remote endpoint tcp://10.233.71.150:4567 changed identity 5b9ab736-a2c1-11ee-8b7d-def43e14f836 -> 5b9ab736-a2c1-11ee-8b7e-def43e14f836
2023-12-25 1:03:28 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') turning message relay requesting off
2023-12-25 1:03:28 0 [Note] WSREP: evs::proto(24a21a5c-b4ac, OPERATIONAL, view_id(REG,08347a08-a2c6,3)) suspecting node: 5b9ab736-8b7d
2023-12-25 1:03:28 0 [Note] WSREP: evs::proto(24a21a5c-b4ac, OPERATIONAL, view_id(REG,08347a08-a2c6,3)) suspected node without join message, declaring inactive
2023-12-25 1:03:29 0 [Note] WSREP: declaring 08347a08-a2c6 at tcp://10.233.70.122:4567 stable
2023-12-25 1:03:29 0 [Note] WSREP: Node 08347a08-a2c6 state prim
2023-12-25 1:03:29 0 [Note] WSREP: view(view_id(PRIM,08347a08-a2c6,4) memb {
08347a08-a2c6,0
24a21a5c-b4ac,0
} joined {
} left {
} partitioned {
5b9ab736-8b7d,0
})
2023-12-25 1:03:29 0 [Note] WSREP: save pc into disk
2023-12-25 1:03:29 0 [Note] WSREP: forgetting 5b9ab736-8b7e (tcp://10.233.71.150:4567)
2023-12-25 1:03:29 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 2
2023-12-25 1:03:29 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-12-25 1:03:29 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 6ac8db6c-a2c1-11ee-891b-4f6aad576428
2023-12-25 1:03:29 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6ac8db6c-a2c1-11ee-891b-4f6aad576428 from 0 (mariadb-galera-0)
2023-12-25 1:03:29 0 [Note] WSREP: STATE EXCHANGE: got state msg: 6ac8db6c-a2c1-11ee-891b-4f6aad576428 from 1 (mariadb-galera-1)
2023-12-25 1:03:29 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 3,
members = 2/2 (joined/total),
act_id = 3,
last_appl. = 0,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235
2023-12-25 1:03:29 0 [Note] WSREP: Flow-control interval: [23, 23]
2023-12-25 1:03:29 2 [Note] WSREP: ####### processing CC 4, local, ordered
2023-12-25 1:03:29 2 [Note] WSREP: ####### My UUID: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e
2023-12-25 1:03:29 2 [Note] WSREP: Skipping cert index reset
2023-12-25 1:03:29 2 [Note] WSREP: REPL Protocols: 10 (5)
2023-12-25 1:03:29 2 [Note] WSREP: ####### Adjusting cert position: 3 -> 4
2023-12-25 1:03:29 0 [Note] WSREP: Service thread queue flushed.
2023-12-25 1:03:29 2 [Note] WSREP: ================================================
View:
id: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:4
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 1
members(2):
0: 08347a08-a2c1-11ee-a2c6-2b7dfec46b42, mariadb-galera-0
1: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e, mariadb-galera-1
=================================================
2023-12-25 1:03:29 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:03:29 2 [Note] WSREP: Lowest cert index boundary for CC from group: 4
2023-12-25 1:03:29 2 [Note] WSREP: Min available from gcache for CC from group: 2
2023-12-25 1:03:30 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') connection established to 5b9ab736-8b7e tcp://10.233.71.150:4567
2023-12-25 1:03:30 0 [Warning] WSREP: discarding established (time wait) 5b9ab736-8b7e (tcp://10.233.71.150:4567)
2023-12-25 1:03:30 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: tcp://10.233.71.150:44268
2023-12-25 1:03:30 0 [Note] WSREP: Deferred close timer handle_wait Operation aborted. for 0x559fdc9a1fa0
2023-12-25 1:03:30 0 [Note] WSREP: Deferred close timer destruct
2023-12-25 1:03:32 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') connection established to 5b9ab736-8b7e tcp://10.233.71.150:4567
2023-12-25 1:03:32 0 [Warning] WSREP: discarding established (time wait) 5b9ab736-8b7e (tcp://10.233.71.150:4567)
2023-12-25 1:03:32 0 [Note] WSREP: Deferred close timer started for socket with remote endpoint: tcp://10.233.71.150:44290
2023-12-25 1:03:32 0 [Note] WSREP: cleaning up 5b9ab736-8b7e (tcp://10.233.71.150:4567)
2023-12-25 1:03:32 0 [Note] WSREP: Deferred close timer handle_wait Operation aborted. for 0x7f6160001510
2023-12-25 1:03:32 0 [Note] WSREP: Deferred close timer destruct
2023-12-25 1:03:33 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') connection established to 5b9ab736-8b7e tcp://10.233.71.150:4567
2023-12-25 1:03:33 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2023-12-25 1:03:36 0 [Note] WSREP: (24a21a5c-b4ac, 'tcp://0.0.0.0:4567') turning message relay requesting off
2023-12-25 1:03:38 0 [Note] WSREP: declaring 08347a08-a2c6 at tcp://10.233.70.122:4567 stable
2023-12-25 1:03:38 0 [Note] WSREP: Node 08347a08-a2c6 state prim
2023-12-25 1:03:39 0 [Note] WSREP: declaring 08347a08-a2c6 at tcp://10.233.70.122:4567 stable
2023-12-25 1:03:39 0 [Note] WSREP: declaring 5b9ab736-8b7e at tcp://10.233.71.150:4567 stable
2023-12-25 1:03:39 0 [Note] WSREP: Node 08347a08-a2c6 state prim
2023-12-25 1:03:39 0 [Note] WSREP: view(view_id(PRIM,08347a08-a2c6,6) memb {
08347a08-a2c6,0
24a21a5c-b4ac,0
5b9ab736-8b7e,0
} joined {
} left {
} partitioned {
})
2023-12-25 1:03:39 0 [Note] WSREP: save pc into disk
2023-12-25 1:03:39 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 3
2023-12-25 1:03:39 0 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID.
2023-12-25 1:03:39 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 70c0bb71-a2c1-11ee-9a75-6675faf1db0b
2023-12-25 1:03:39 0 [Note] WSREP: STATE EXCHANGE: got state msg: 70c0bb71-a2c1-11ee-9a75-6675faf1db0b from 0 (mariadb-galera-0)
2023-12-25 1:03:39 0 [Note] WSREP: STATE EXCHANGE: got state msg: 70c0bb71-a2c1-11ee-9a75-6675faf1db0b from 1 (mariadb-galera-1)
2023-12-25 1:03:39 0 [Note] WSREP: STATE EXCHANGE: got state msg: 70c0bb71-a2c1-11ee-9a75-6675faf1db0b from 2 (mariadb-galera-2)
2023-12-25 1:03:39 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 4,
members = 2/3 (joined/total),
act_id = 4,
last_appl. = 0,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235
2023-12-25 1:03:39 0 [Note] WSREP: Flow-control interval: [28, 28]
2023-12-25 1:03:39 2 [Note] WSREP: ####### processing CC 5, local, ordered
2023-12-25 1:03:39 2 [Note] WSREP: ####### My UUID: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e
2023-12-25 1:03:39 2 [Note] WSREP: Skipping cert index reset
2023-12-25 1:03:39 2 [Note] WSREP: REPL Protocols: 10 (5)
2023-12-25 1:03:39 2 [Note] WSREP: ####### Adjusting cert position: 4 -> 5
2023-12-25 1:03:39 0 [Note] WSREP: Service thread queue flushed.
2023-12-25 1:03:39 2 [Note] WSREP: ================================================
View:
id: 083a11a2-a2c1-11ee-a5f2-1bf88b3fd235:5
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 1
members(3):
0: 08347a08-a2c1-11ee-a2c6-2b7dfec46b42, mariadb-galera-0
1: 24a21a5c-a2c1-11ee-b4ac-5efe82065b5e, mariadb-galera-1
2: 5b9ab736-a2c1-11ee-8b7e-def43e14f836, mariadb-galera-2
=================================================
2023-12-25 1:03:39 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2023-12-25 1:03:39 2 [Note] WSREP: Lowest cert index boundary for CC from group: 5
2023-12-25 1:03:39 2 [Note] WSREP: Min available from gcache for CC from group: 2
2023-12-25 1:03:40 0 [Note] WSREP: Member 2.0 (mariadb-galera-2) requested state transfer from '*any*'. Selected 0.0 (mariadb-galera-0)(SYNCED) as donor.
2023-12-25 1:03:52 0 [Note] WSREP: 0.0 (mariadb-galera-0): State transfer to 2.0 (mariadb-galera-2) complete.
2023-12-25 1:03:52 0 [Note] WSREP: Member 0.0 (mariadb-galera-0) synced with group.
2023-12-25 1:03:56 0 [Note] WSREP: 2.0 (mariadb-galera-2): State transfer from 0.0 (mariadb-galera-0) complete.
2023-12-25 1:03:56 0 [Note] WSREP: Member 2.0 (mariadb-galera-2) synced with group.
2023-12-25 1:23:43 331 [Warning] Access denied for user 'so_admin'@'127.0.0.6' (using password: YES)
2023-12-25 1:25:19 350 [Warning] Access denied for user 'so_admin'@'127.0.0.6' (using password: YES)