By type
+ CONTAINER_SCRIPTS_DIR=/usr/share/container-scripts/mysql
+ EXTRA_DEFAULTS_FILE=/etc/my.cnf.d/galera.cnf
+ '[' -z onap ']'
+ echo 'Galera: Finding peers'
Galera: Finding peers
++ hostname -f
++ cut -d. -f2
Using service name: mariadb-galera
+ K8S_SVC_NAME=mariadb-galera
+ echo 'Using service name: mariadb-galera'
+ cp /usr/share/container-scripts/mysql/galera.cnf /etc/my.cnf.d/galera.cnf
+ /usr/bin/peer-finder -on-start=/usr/share/container-scripts/mysql/configure-galera.sh -service=mariadb-galera
2021/05/22 01:50:44 Peer list updated
was []
now [onap-mariadb-galera-0.mariadb-galera.onap.svc.cluster.local]
2021/05/22 01:50:44 execing: /usr/share/container-scripts/mysql/configure-galera.sh with stdin: onap-mariadb-galera-0.mariadb-galera.onap.svc.cluster.local
2021/05/22 01:50:44
2021/05/22 01:50:45 Peer finder exiting
+ '[' '!' -d /var/lib/mysql/mysql ']'
+ echo 'Configure first time mysql'
+ /usr/share/container-scripts/mysql/configure-mysql.sh
Configure first time mysql
+ echo 'Running mysql_install_db ...'
+ mysql_install_db --datadir=/var/lib/mysql
Running mysql_install_db ...
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
2021-05-22 1:50:45 139778200316160 [Note] /usr/sbin/mysqld (mysqld 10.1.24-MariaDB) starting as process 49 ...
2021-05-22 1:50:45 139778200316160 [Note] WSREP: Read nil XID from storage engines, skipping position init
2021-05-22 1:50:45 139778200316160 [Note] WSREP: wsrep_load(): loading provider library 'none'
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: The InnoDB memory heap is disabled
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Compressed tables use zlib 1.2.7
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Using Linux native AIO
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Using SSE crc32 instructions
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Completed initialization of buffer pool
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2021-05-22 1:50:45 139778200316160 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-05-22 1:50:46 139778200316160 [Warning] InnoDB: New log files created, LSN=45883
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Doublewrite buffer not found: creating new
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Doublewrite buffer created
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: 128 rollback segment(s) are active.
2021-05-22 1:50:46 139778200316160 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Foreign key constraint system tables created
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Creating tablespace and datafile system tables.
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Tablespace and datafile system tables created.
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Waiting for purge to start
2021-05-22 1:50:46 139778200316160 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 0
2021-05-22 1:50:46 139777416361728 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Filling help tables...
2021-05-22 1:50:50 140657117985024 [Note] /usr/sbin/mysqld (mysqld 10.1.24-MariaDB) starting as process 78 ...
2021-05-22 1:50:50 140657117985024 [Note] WSREP: Read nil XID from storage engines, skipping position init
2021-05-22 1:50:50 140657117985024 [Note] WSREP: wsrep_load(): loading provider library 'none'
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: The InnoDB memory heap is disabled
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Compressed tables use zlib 1.2.7
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Using Linux native AIO
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Using SSE crc32 instructions
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Completed initialization of buffer pool
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Highest supported file format is Barracuda.
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: 128 rollback segment(s) are active.
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Waiting for purge to start
2021-05-22 1:50:50 140657117985024 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1616799
2021-05-22 1:50:50 140656336959232 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Creating OpenGIS required SP-s...
2021-05-22 1:50:54 140058256623872 [Note] /usr/sbin/mysqld (mysqld 10.1.24-MariaDB) starting as process 108 ...
2021-05-22 1:50:54 140058256623872 [Note] WSREP: Read nil XID from storage engines, skipping position init
2021-05-22 1:50:54 140058256623872 [Note] WSREP: wsrep_load(): loading provider library 'none'
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: The InnoDB memory heap is disabled
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Compressed tables use zlib 1.2.7
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Using Linux native AIO
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Using SSE crc32 instructions
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Completed initialization of buffer pool
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Highest supported file format is Barracuda.
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: 128 rollback segment(s) are active.
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Waiting for purge to start
2021-05-22 1:50:54 140058256623872 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1616809
2021-05-22 1:50:54 140057478428416 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h onap-mariadb-galera-0 password 'new-password'
Alternatively you can run:
'/usr/bin/mysql_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 http://mariadb.com/kb or the
MySQL manual for more instructions.
You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql'
You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mysql-test-run.pl
Please report any problems at http://mariadb.org/jira
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/
+ echo 'Finished mysql_install_db'
Finished mysql_install_db
+ pid=135
+ mysql=(mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock)
+ mysqld --skip-networking --socket=/var/lib/mysql/mysql-init.sock --wsrep_on=OFF
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
MySQL init process in progress...
+ echo 'MySQL init process in progress...'
+ sleep 1
2021-05-22 1:50:58 140400057792768 [Note] mysqld (mysqld 10.1.24-MariaDB) starting as process 135 ...
2021-05-22 1:50:58 140400057792768 [Warning] You need to use --log-bin to make --binlog-format work.
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: The InnoDB memory heap is disabled
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: Compressed tables use zlib 1.2.7
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: Using Linux native AIO
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: Using SSE crc32 instructions
2021-05-22 1:50:58 140400057792768 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-05-22 1:50:59 140400057792768 [Note] InnoDB: Completed initialization of buffer pool
2021-05-22 1:50:59 140400057792768 [Note] InnoDB: Highest supported file format is Barracuda.
2021-05-22 1:50:59 140400057792768 [Note] InnoDB: 128 rollback segment(s) are active.
2021-05-22 1:50:59 140400057792768 [Note] InnoDB: Waiting for purge to start
2021-05-22 1:50:59 140400057792768 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1616819
2021-05-22 1:50:59 140399276455680 [Note] InnoDB: Dumping buffer pool(s) not yet started
2021-05-22 1:50:59 140400057792768 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-22 1:50:59 140400057792768 [Note] mysqld: ready for connections.
Version: '10.1.24-MariaDB' socket: '/var/lib/mysql/mysql-init.sock' port: 0 MariaDB Server
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ break
+ '[' 29 = 0 ']'
+ '[' -z '' ']'
+ mysql_tzinfo_to_sql /usr/share/zoneinfo
+ sed 's/Local time zone must be set--see zic manual page/FCTY/'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock mysql
++ prepare_password Pupp4=BobuBaho
++ echo Pupp4=BobuBaho
++ sed -e 's/'\''/\\'\''/g; s/"/\\"/g'
+ mysql_root_password=Pupp4=BobuBaho
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ '[' '!' -z Pupp4=BobuBaho ']'
+ mysql+=(-p"${MYSQL_ROOT_PASSWORD}")
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock -pPupp4=BobuBaho
+ '[' '' ']'
+ '[' my-user -a Gabv2~LenzBuku ']'
++ prepare_password Gabv2~LenzBuku
++ echo Gabv2~LenzBuku
++ sed -e 's/'\''/\\'\''/g; s/"/\\"/g'
+ mysql_password=Gabv2~LenzBuku
+ echo 'CREATE USER '\''my-user'\''@'\''%'\'' IDENTIFIED BY '\''Gabv2~LenzBuku'\'' ;'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock -pPupp4=BobuBaho
+ '[' '' ']'
+ echo 'FLUSH PRIVILEGES ;'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock -pPupp4=BobuBaho
+ kill -s TERM 135
+ wait 135
2021-05-22 1:51:03 140400056941312 [Note] mysqld: Normal shutdown
2021-05-22 1:51:03 140400056941312 [Note] Event Scheduler: Purging the queue. 0 events
2021-05-22 1:51:03 140399259670272 [Note] InnoDB: FTS optimize thread exiting.
2021-05-22 1:51:03 140400056941312 [Note] InnoDB: Starting shutdown...
2021-05-22 1:51:04 140400056941312 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2021-05-22 1:51:05 140400056941312 [Note] InnoDB: Shutdown completed; log sequence number 1616829
2021-05-22 1:51:05 140400056941312 [Note] mysqld: Shutdown complete
+ echo
+ echo 'MySQL init process done. Ready for start up.'
MySQL init process done. Ready for start up.
+ echo
+ exec mysqld
2021-05-22 1:51:05 139956241520896 [Note] mysqld (mysqld 10.1.24-MariaDB) starting as process 1 ...
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Read nil XID from storage engines, skipping position init
2021-05-22 1:51:06 139956241520896 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
2021-05-22 1:51:06 139956241520896 [Note] WSREP: wsrep_load(): Galera 25.3.20(r3703) by Codership Oy loaded successfully.
2021-05-22 1:51:06 139956241520896 [Note] WSREP: CRC-32C: using hardware acceleration.
2021-05-22 1:51:06 139956241520896 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = onap-mariadb-galera-0.mariadb-galera.onap.svc.cluster.local; base_port = 4567; cert.log_conflicts = no; 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.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; 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.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.ann
2021-05-22 1:51:06 139956241520896 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2021-05-22 1:51:06 139956241520896 [Note] WSREP: wsrep_sst_grab()
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Start replication
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2021-05-22 1:51:06 139956241520896 [Note] WSREP: protonet asio version 0
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Using CRC-32C for message checksums.
2021-05-22 1:51:06 139956241520896 [Note] WSREP: backend: asio
2021-05-22 1:51:06 139956241520896 [Note] WSREP: gcomm thread scheduling priority set to other:0
2021-05-22 1:51:06 139956241520896 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2021-05-22 1:51:06 139956241520896 [Note] WSREP: restore pc from disk failed
2021-05-22 1:51:06 139956241520896 [Note] WSREP: GMCast version 0
2021-05-22 1:51:06 139956241520896 [Note] WSREP: (2c25f9dc, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2021-05-22 1:51:06 139956241520896 [Note] WSREP: (2c25f9dc, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2021-05-22 1:51:06 139956241520896 [Note] WSREP: EVS version 0
2021-05-22 1:51:06 139956241520896 [Note] WSREP: gcomm: connecting to group 'mariadb-galera', peer ''
2021-05-22 1:51:06 139956241520896 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Node 2c25f9dc state prim
2021-05-22 1:51:06 139956241520896 [Note] WSREP: view(view_id(PRIM,2c25f9dc,1) memb {
2c25f9dc,0
} joined {
} left {
} partitioned {
})
2021-05-22 1:51:06 139956241520896 [Note] WSREP: save pc into disk
2021-05-22 1:51:06 139956241520896 [Note] WSREP: gcomm: connected
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Opened channel 'mariadb-galera'
2021-05-22 1:51:06 139956241520896 [Note] WSREP: Waiting for SST to complete.
2021-05-22 1:51:06 139955917547264 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2021-05-22 1:51:06 139955917547264 [Note] WSREP: Starting new group from scratch: 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021
2021-05-22 1:51:06 139955917547264 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 2c26a627-baa0-11eb-b412-16278b458bdc
2021-05-22 1:51:06 139955917547264 [Note] WSREP: STATE EXCHANGE: sent state msg: 2c26a627-baa0-11eb-b412-16278b458bdc
2021-05-22 1:51:06 139955917547264 [Note] WSREP: STATE EXCHANGE: got state msg: 2c26a627-baa0-11eb-b412-16278b458bdc from 0 (onap-mariadb-galera-0)
2021-05-22 1:51:06 139955917547264 [Note] WSREP: Quorum results:
version = 4,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 0,
last_appl. = -1,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021
2021-05-22 1:51:06 139955917547264 [Note] WSREP: Flow-control interval: [16, 16]
2021-05-22 1:51:06 139955917547264 [Note] WSREP: Restored state OPEN -> JOINED (0)
2021-05-22 1:51:06 139955917547264 [Note] WSREP: Member 0.0 (onap-mariadb-galera-0) synced with group.
2021-05-22 1:51:06 139955917547264 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2021-05-22 1:51:06 139956241070848 [Note] WSREP: New cluster view: global state: 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2021-05-22 1:51:06 139956241520896 [Note] WSREP: SST complete, seqno: 0
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: The InnoDB memory heap is disabled
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Compressed tables use zlib 1.2.7
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Using Linux native AIO
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Using SSE crc32 instructions
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Completed initialization of buffer pool
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Highest supported file format is Barracuda.
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: 128 rollback segment(s) are active.
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Waiting for purge to start
2021-05-22 1:51:06 139956241520896 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 1616829
2021-05-22 1:51:06 139955233879808 [Note] InnoDB: Dumping buffer pool(s) not yet started
2021-05-22 1:51:06 139956241520896 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-22 1:51:06 139956241520896 [Note] Server socket created on IP: '0.0.0.0'.
2021-05-22 1:51:06 139956241070848 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-05-22 1:51:06 139956241070848 [Note] WSREP: REPL Protocols: 7 (3, 2)
2021-05-22 1:51:06 139956241070848 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
2021-05-22 1:51:06 139955975853824 [Note] WSREP: Service thread queue flushed.
2021-05-22 1:51:06 139956241070848 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(2c26a1d7-baa0-11eb-9ca4-5af4bab6b021:0)
2021-05-22 1:51:06 139956241070848 [Note] WSREP: Synchronized with group, ready for connections
2021-05-22 1:51:06 139956241070848 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-05-22 1:51:06 139956241520896 [Note] mysqld: ready for connections.
Version: '10.1.24-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
2021-05-22 1:53:52 139955925939968 [Note] WSREP: (2c25f9dc, 'tcp://0.0.0.0:4567') connection established to 8f3e0a7d tcp://10.233.76.56:4567
2021-05-22 1:53:52 139955925939968 [Note] WSREP: (2c25f9dc, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2021-05-22 1:53:53 139955925939968 [Note] WSREP: declaring 8f3e0a7d at tcp://10.233.76.56:4567 stable
2021-05-22 1:53:53 139955925939968 [Note] WSREP: Node 2c25f9dc state prim
2021-05-22 1:53:53 139955925939968 [Note] WSREP: view(view_id(PRIM,2c25f9dc,2) memb {
2c25f9dc,0
8f3e0a7d,0
} joined {
} left {
} partitioned {
})
2021-05-22 1:53:53 139955925939968 [Note] WSREP: save pc into disk
2021-05-22 1:53:53 139955917547264 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
2021-05-22 1:53:53 139955917547264 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 8f8c86d5-baa0-11eb-b2bd-97ab26f21682
2021-05-22 1:53:53 139955917547264 [Note] WSREP: STATE EXCHANGE: sent state msg: 8f8c86d5-baa0-11eb-b2bd-97ab26f21682
2021-05-22 1:53:53 139955917547264 [Note] WSREP: STATE EXCHANGE: got state msg: 8f8c86d5-baa0-11eb-b2bd-97ab26f21682 from 0 (onap-mariadb-galera-0)
2021-05-22 1:53:53 139955917547264 [Note] WSREP: STATE EXCHANGE: got state msg: 8f8c86d5-baa0-11eb-b2bd-97ab26f21682 from 1 (onap-mariadb-galera-1)
2021-05-22 1:53:53 139955917547264 [Note] WSREP: Quorum results:
version = 4,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 0,
last_appl. = 0,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021
2021-05-22 1:53:53 139955917547264 [Note] WSREP: Flow-control interval: [23, 23]
2021-05-22 1:53:53 139956241070848 [Note] WSREP: New cluster view: global state: 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021:0, view# 2: Primary, number of nodes: 2, my index: 0, protocol version 3
2021-05-22 1:53:53 139956241070848 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-05-22 1:53:53 139956241070848 [Note] WSREP: REPL Protocols: 7 (3, 2)
2021-05-22 1:53:53 139956241070848 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
2021-05-22 1:53:53 139955975853824 [Note] WSREP: Service thread queue flushed.
2021-05-22 1:53:55 139955925939968 [Note] WSREP: (2c25f9dc, 'tcp://0.0.0.0:4567') turning message relay requesting off
2021-05-22 1:53:57 139955917547264 [Note] WSREP: Member 1.0 (onap-mariadb-galera-1) requested state transfer from '*any*'. Selected 0.0 (onap-mariadb-galera-0)(SYNCED) as donor.
2021-05-22 1:53:57 139955917547264 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0)
2021-05-22 1:53:57 139956241070848 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-05-22 1:53:57 139955154188032 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'donor' --address 'onap-mariadb-galera-1.mariadb-galera.onap.svc.cluster.local:4444/xtrabackup_sst//1' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' '' --gtid '2c26a1d7-baa0-11eb-9ca4-5af4bab6b021:0' --gtid-domain-id '0''
2021-05-22 1:53:57 139956241070848 [Note] WSREP: sst_donor_thread signaled with 0
WSREP_SST: [INFO] Streaming with xbstream (20210522 01:53:58.046)
WSREP_SST: [INFO] Using socat as streamer (20210522 01:53:58.049)
WSREP_SST: [INFO] Using /tmp/tmp.ns3DgUJKp5 as xtrabackup temporary directory (20210522 01:53:58.099)
WSREP_SST: [INFO] Using /tmp/tmp.Y1p1hxJgt5 as innobackupex temporary directory (20210522 01:53:58.103)
WSREP_SST: [INFO] Streaming GTID file before SST (20210522 01:53:58.109)
WSREP_SST: [INFO] Evaluating xbstream -c ${INFO_FILE} | socat -u stdio TCP:onap-mariadb-galera-1.mariadb-galera.onap.svc.cluster.local:4444; RC=( ${PIPESTATUS[@]} ) (20210522 01:53:58.115)
WSREP_SST: [INFO] Sleeping before data transfer for SST (20210522 01:53:58.122)
WSREP_SST: [INFO] Streaming the backup to joiner at onap-mariadb-galera-1.mariadb-galera.onap.svc.cluster.local 4444 (20210522 01:54:08.128)
WSREP_SST: [INFO] Evaluating innobackupex --no-version-check $tmpopts $INNOEXTRA --galera-info --stream=$sfmt $itmpdir 2>${DATA}/innobackup.backup.log | socat -u stdio TCP:onap-mariadb-galera-1.mariadb-galera.onap.svc.cluster.local:4444; RC=( ${PIPESTATUS[@]} ) (20210522 01:54:08.198)
2021-05-22 1:54:09 139956161682176 [Note] WSREP: Provider paused at 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021:0 (5)
2021-05-22 1:54:10 139956161682176 [Note] WSREP: resuming provider at 5
2021-05-22 1:54:10 139956161682176 [Note] WSREP: Provider resumed.
2021-05-22 1:54:10 139955917547264 [Note] WSREP: 0.0 (onap-mariadb-galera-0): State transfer to 1.0 (onap-mariadb-galera-1) complete.
2021-05-22 1:54:10 139955917547264 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)
WSREP_SST: [INFO] Total time on donor: 0 seconds (20210522 01:54:10.215)
WSREP_SST: [INFO] Cleaning up temporary directories (20210522 01:54:10.221)
2021-05-22 1:54:10 139955917547264 [Note] WSREP: Member 0.0 (onap-mariadb-galera-0) synced with group.
2021-05-22 1:54:10 139955917547264 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2021-05-22 1:54:10 139956241070848 [Note] WSREP: Synchronized with group, ready for connections
2021-05-22 1:54:10 139956241070848 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-05-22 1:54:14 139955917547264 [Note] WSREP: 1.0 (onap-mariadb-galera-1): State transfer from 0.0 (onap-mariadb-galera-0) complete.
2021-05-22 1:54:14 139955917547264 [Note] WSREP: Member 1.0 (onap-mariadb-galera-1) synced with group.
2021-05-22 1:54:55 139955925939968 [Note] WSREP: (2c25f9dc, 'tcp://0.0.0.0:4567') connection established to b49b181d tcp://10.233.78.195:4567
2021-05-22 1:54:55 139955925939968 [Note] WSREP: (2c25f9dc, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2021-05-22 1:54:55 139955925939968 [Note] WSREP: declaring 8f3e0a7d at tcp://10.233.76.56:4567 stable
2021-05-22 1:54:55 139955925939968 [Note] WSREP: declaring b49b181d at tcp://10.233.78.195:4567 stable
2021-05-22 1:54:55 139955925939968 [Note] WSREP: Node 2c25f9dc state prim
2021-05-22 1:54:55 139955925939968 [Note] WSREP: view(view_id(PRIM,2c25f9dc,3) memb {
2c25f9dc,0
8f3e0a7d,0
b49b181d,0
} joined {
} left {
} partitioned {
})
2021-05-22 1:54:55 139955925939968 [Note] WSREP: save pc into disk
2021-05-22 1:54:55 139955917547264 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3
2021-05-22 1:54:55 139955917547264 [Note] WSREP: STATE_EXCHANGE: sent state UUID: b4ee233f-baa0-11eb-b268-ca9446ea7cb2
2021-05-22 1:54:55 139955917547264 [Note] WSREP: STATE EXCHANGE: sent state msg: b4ee233f-baa0-11eb-b268-ca9446ea7cb2
2021-05-22 1:54:55 139955917547264 [Note] WSREP: STATE EXCHANGE: got state msg: b4ee233f-baa0-11eb-b268-ca9446ea7cb2 from 0 (onap-mariadb-galera-0)
2021-05-22 1:54:55 139955917547264 [Note] WSREP: STATE EXCHANGE: got state msg: b4ee233f-baa0-11eb-b268-ca9446ea7cb2 from 1 (onap-mariadb-galera-1)
2021-05-22 1:54:56 139955917547264 [Note] WSREP: STATE EXCHANGE: got state msg: b4ee233f-baa0-11eb-b268-ca9446ea7cb2 from 2 (onap-mariadb-galera-2)
2021-05-22 1:54:56 139955917547264 [Note] WSREP: Quorum results:
version = 4,
component = PRIMARY,
conf_id = 2,
members = 2/3 (joined/total),
act_id = 0,
last_appl. = 0,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021
2021-05-22 1:54:56 139955917547264 [Note] WSREP: Flow-control interval: [28, 28]
2021-05-22 1:54:56 139956241070848 [Note] WSREP: New cluster view: global state: 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021:0, view# 3: Primary, number of nodes: 3, my index: 0, protocol version 3
2021-05-22 1:54:56 139956241070848 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-05-22 1:54:56 139956241070848 [Note] WSREP: REPL Protocols: 7 (3, 2)
2021-05-22 1:54:56 139956241070848 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
2021-05-22 1:54:56 139955975853824 [Note] WSREP: Service thread queue flushed.
2021-05-22 1:54:58 139955925939968 [Note] WSREP: (2c25f9dc, 'tcp://0.0.0.0:4567') turning message relay requesting off
2021-05-22 1:54:59 139955917547264 [Note] WSREP: Member 2.0 (onap-mariadb-galera-2) requested state transfer from '*any*'. Selected 0.0 (onap-mariadb-galera-0)(SYNCED) as donor.
2021-05-22 1:54:59 139955917547264 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0)
2021-05-22 1:54:59 139956241070848 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-05-22 1:54:59 139955137410816 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'donor' --address 'onap-mariadb-galera-2.mariadb-galera.onap.svc.cluster.local:4444/xtrabackup_sst//1' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' '' --gtid '2c26a1d7-baa0-11eb-9ca4-5af4bab6b021:0' --gtid-domain-id '0''
2021-05-22 1:54:59 139956241070848 [Note] WSREP: sst_donor_thread signaled with 0
WSREP_SST: [INFO] Streaming with xbstream (20210522 01:55:00.045)
WSREP_SST: [INFO] Using socat as streamer (20210522 01:55:00.048)
WSREP_SST: [INFO] Using /tmp/tmp.LNScKp5c2m as xtrabackup temporary directory (20210522 01:55:00.106)
WSREP_SST: [INFO] Using /tmp/tmp.RtNAXuBiOE as innobackupex temporary directory (20210522 01:55:00.110)
WSREP_SST: [INFO] Streaming GTID file before SST (20210522 01:55:00.116)
WSREP_SST: [INFO] Evaluating xbstream -c ${INFO_FILE} | socat -u stdio TCP:onap-mariadb-galera-2.mariadb-galera.onap.svc.cluster.local:4444; RC=( ${PIPESTATUS[@]} ) (20210522 01:55:00.123)
WSREP_SST: [INFO] Sleeping before data transfer for SST (20210522 01:55:00.131)
WSREP_SST: [INFO] Streaming the backup to joiner at onap-mariadb-galera-2.mariadb-galera.onap.svc.cluster.local 4444 (20210522 01:55:10.200)
WSREP_SST: [INFO] Evaluating innobackupex --no-version-check $tmpopts $INNOEXTRA --galera-info --stream=$sfmt $itmpdir 2>${DATA}/innobackup.backup.log | socat -u stdio TCP:onap-mariadb-galera-2.mariadb-galera.onap.svc.cluster.local:4444; RC=( ${PIPESTATUS[@]} ) (20210522 01:55:10.300)
2021-05-22 1:55:11 139956161682176 [Note] WSREP: Provider paused at 2c26a1d7-baa0-11eb-9ca4-5af4bab6b021:0 (10)
2021-05-22 1:55:12 139956161682176 [Note] WSREP: resuming provider at 10
2021-05-22 1:55:12 139956161682176 [Note] WSREP: Provider resumed.
2021-05-22 1:55:12 139955917547264 [Note] WSREP: 0.0 (onap-mariadb-galera-0): State transfer to 2.0 (onap-mariadb-galera-2) complete.
2021-05-22 1:55:12 139955917547264 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)
2021-05-22 1:55:12 139955917547264 [Note] WSREP: Member 0.0 (onap-mariadb-galera-0) synced with group.
2021-05-22 1:55:12 139955917547264 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2021-05-22 1:55:12 139956241070848 [Note] WSREP: Synchronized with group, ready for connections
WSREP_SST: [INFO] Total time on donor: 0 seconds (20210522 01:55:12.078)
2021-05-22 1:55:12 139956241070848 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
WSREP_SST: [INFO] Cleaning up temporary directories (20210522 01:55:12.083)
2021-05-22 1:55:16 139955917547264 [Note] WSREP: 2.0 (onap-mariadb-galera-2): State transfer from 0.0 (onap-mariadb-galera-0) complete.
2021-05-22 1:55:16 139955917547264 [Note] WSREP: Member 2.0 (onap-mariadb-galera-2) synced with group.
2021-05-22 1:56:24 139956161682176 [Warning] IP address '10.233.67.58' could not be resolved: Name or service not known
2021-05-22 1:56:26 139956161682176 [Warning] IP address '10.233.70.61' could not be resolved: Name or service not known
2021-05-22 2:07:57 139956161682176 [Warning] IP address '10.233.67.149' could not be resolved: Name or service not known
2021-05-22 2:22:42 139955906120448 [Warning] IP address '10.233.71.240' could not be resolved: Name or service not known