Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ubuntu@nuc-3:~$ kubectl logs -n openstack mariadb-0
- + CLUSTER_INIT_ARGS=
- + '[' '!' -d /var/lib/mysql/mysql ']'
- + '[' xmariadb-0 = xmariadb-0 ']'
- No data found for pod 0
- + echo No data found for pod 0
- + '[' xfalse = xtrue ']'
- + mysql --defaults-file=/etc/mysql/admin_user.cnf --connect-timeout 2 -e 'select 1'
- ERROR 2003 (HY000): Can't connect to MySQL server on 'mariadb' (110 "Connection timed out")
- + echo 'No other nodes found, so will initialize cluster.'
- + CLUSTER_INIT_ARGS=--wsrep-new-cluster
- + CLUSTER_CONFIG_PATH=/etc/mysql/conf.d/10-cluster-config.cnf
- + MEMBERS=
- No other nodes found, so will initialize cluster.
- ++ seq 1 3
- + for i in '$(seq 1 ${MARIADB_REPLICAS})'
- + '[' 1 -eq 1 ']'
- + NUM=0
- + CANDIDATE_POD=mariadb-0.mariadb-discovery
- + '[' xmariadb-0.mariadb-discovery '!=' xmariadb-0.mariadb-discovery ']'
- + for i in '$(seq 1 ${MARIADB_REPLICAS})'
- + '[' 2 -eq 1 ']'
- ++ expr 2 - 1
- + NUM=1
- + CANDIDATE_POD=mariadb-1.mariadb-discovery
- + '[' xmariadb-1.mariadb-discovery '!=' xmariadb-0.mariadb-discovery ']'
- + '[' -n '' ']'
- + MEMBERS+=mariadb-1.mariadb-discovery:4567
- + for i in '$(seq 1 ${MARIADB_REPLICAS})'
- + '[' 3 -eq 1 ']'
- ++ expr 3 - 1
- + NUM=2
- + CANDIDATE_POD=mariadb-2.mariadb-discovery
- + '[' xmariadb-2.mariadb-discovery '!=' xmariadb-0.mariadb-discovery ']'
- + '[' -n mariadb-1.mariadb-discovery:4567 ']'
- + MEMBERS+=,
- + MEMBERS+=mariadb-2.mariadb-discovery:4567
- + echo 'Writing cluster config for mariadb-0 to /etc/mysql/conf.d/10-cluster-config.cnf'
- + cat
- Writing cluster config for mariadb-0 to /etc/mysql/conf.d/10-cluster-config.cnf
- Executing upstream docker-entrypoint.
- + echo 'Executing upstream docker-entrypoint.'
- + set +e
- + exec /usr/local/bin/docker-entrypoint.sh mysqld --wsrep-new-cluster
- Initializing database
- 2017-08-08 20:25:17 139954771883968 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-1~jessie) starting as process 73 ...
- 2017-08-08 20:25:17 139954771883968 [Note] WSREP: Read nil XID from storage engines, skipping position init
- 2017-08-08 20:25:17 139954771883968 [Note] WSREP: wsrep_load(): loading provider library 'none'
- 2017-08-08 20:25:17 7f49c27677c0 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/5.6/en/set-transaction.html.
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: Using mutexes to ref count buffer pool pages
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: Using Linux native AIO
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: Using SSE crc32 instructions
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: Initializing buffer pool, size = 1.0G
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: Completed initialization of buffer pool
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
- 2017-08-08 20:25:17 139954771883968 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
- 2017-08-08 20:25:35 139954771883968 [Note] InnoDB: Setting log file ./ib_logfile101 size to 128 MB
- 2017-08-08 20:25:54 139954771883968 [Note] InnoDB: Setting log file ./ib_logfile1 size to 128 MB
- 2017-08-08 20:26:16 139954771883968 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
- 2017-08-08 20:26:16 139954771883968 [Warning] InnoDB: New log files created, LSN=45883
- 2017-08-08 20:26:16 139954771883968 [Note] InnoDB: Doublewrite buffer not found: creating new
- 2017-08-08 20:26:20 139954771883968 [Note] InnoDB: Doublewrite buffer created
- 2017-08-08 20:26:20 139954771883968 [Note] InnoDB: 128 rollback segment(s) are active.
- 2017-08-08 20:26:20 139954771883968 [Warning] InnoDB: Creating foreign key constraint system tables.
- 2017-08-08 20:26:20 139954771883968 [Note] InnoDB: Foreign key constraint system tables created
- 2017-08-08 20:26:20 139954771883968 [Note] InnoDB: Creating tablespace and datafile system tables.
- 2017-08-08 20:26:20 139954771883968 [Note] InnoDB: Tablespace and datafile system tables created.
- 2017-08-08 20:26:20 139954771883968 [Note] InnoDB: Waiting for purge to start
- 2017-08-08 20:26:20 139954771883968 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 0
- 2017-08-08 20:26:26 139953052841728 [Note] InnoDB: Dumping buffer pool(s) not yet started
- 2017-08-08 20:27:23 140257448585152 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-1~jessie) starting as process 192 ...
- 2017-08-08 20:27:23 140257448585152 [Note] WSREP: Read nil XID from storage engines, skipping position init
- 2017-08-08 20:27:23 140257448585152 [Note] WSREP: wsrep_load(): loading provider library 'none'
- 2017-08-08 20:27:23 7f903b6667c0 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/5.6/en/set-transaction.html.
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: Using mutexes to ref count buffer pool pages
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: Using Linux native AIO
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: Using SSE crc32 instructions
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: Initializing buffer pool, size = 1.0G
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: Completed initialization of buffer pool
- 2017-08-08 20:27:23 140257448585152 [Note] InnoDB: Highest supported file format is Barracuda.
- 2017-08-08 20:27:24 140257448585152 [Note] InnoDB: 128 rollback segment(s) are active.
- 2017-08-08 20:27:24 140257448585152 [Note] InnoDB: Waiting for purge to start
- 2017-08-08 20:27:24 140257448585152 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1616799
- 2017-08-08 20:27:26 140255734765312 [Note] InnoDB: Dumping buffer pool(s) not yet started
- 2017-08-08 20:27:35 140658349594560 [Note] /usr/sbin/mysqld (mysqld 10.1.23-MariaDB-1~jessie) starting as process 236 ...
- 2017-08-08 20:27:35 140658349594560 [Note] WSREP: Read nil XID from storage engines, skipping position init
- 2017-08-08 20:27:35 140658349594560 [Note] WSREP: wsrep_load(): loading provider library 'none'
- 2017-08-08 20:27:35 7fed92f657c0 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/5.6/en/set-transaction.html.
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: Using mutexes to ref count buffer pool pages
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: Using Linux native AIO
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: Using SSE crc32 instructions
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: Initializing buffer pool, size = 1.0G
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: Completed initialization of buffer pool
- 2017-08-08 20:27:35 140658349594560 [Note] InnoDB: Highest supported file format is Barracuda.
- 2017-08-08 20:27:36 140658349594560 [Note] InnoDB: 128 rollback segment(s) are active.
- 2017-08-08 20:27:36 140658349594560 [Note] InnoDB: Waiting for purge to start
- 2017-08-08 20:27:36 140658349594560 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1616809
- 2017-08-08 20:27:38 140656638924544 [Note] InnoDB: Dumping buffer pool(s) not yet started
- 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 mariadb-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.
- 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/
- Database initialized
- MySQL init process in progress...
- 2017-08-08 20:27:49 140603015104448 [Note] mysqld (mysqld 10.1.23-MariaDB-1~jessie) starting as process 291 ...
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Read nil XID from storage engines, skipping position init
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: wsrep_load(): Galera 25.3.20(r3703) by Codership Oy <[email protected]> loaded successfully.
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: CRC-32C: using hardware acceleration.
- 2017-08-08 20:27:49 140603015104448 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.241.9; 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.listen_addr = tcp://0.0.0.0:4567; gmcast.segment = 0; gmcast.version = 0; pc.announce
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: wsrep_sst_grab()
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Start replication
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: 'wsrep-new-cluster' option used, bootstrapping the cluster
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: protonet asio version 0
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Using CRC-32C for message checksums.
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: backend: asio
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: gcomm thread scheduling priority set to other:0
- 2017-08-08 20:27:49 140603015104448 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: restore pc from disk failed
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: GMCast version 0
- 2017-08-08 20:27:49 140603015104448 [Warning] WSREP: Failed to resolve tcp://mariadb-1.mariadb-discovery:4567
- 2017-08-08 20:27:49 140603015104448 [Warning] WSREP: Failed to resolve tcp://mariadb-2.mariadb-discovery:4567
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: (0c0d296b, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: (0c0d296b, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: EVS version 0
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: gcomm: bootstrapping new group 'mariadb'
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: start_prim is enabled, turn off pc_recovery
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Node 0c0d296b state prim
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: view(view_id(PRIM,0c0d296b,1) memb {
- 0c0d296b,0
- } joined {
- } left {
- } partitioned {
- })
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: save pc into disk
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: gcomm: connected
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Opened channel 'mariadb'
- MySQL init process in progress...
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: Waiting for SST to complete.
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: Starting new group from scratch: 0c1d40d7-7c78-11e7-83c7-32b86b8deef4
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 0c1d4542-7c78-11e7-b1b4-cfffde69fc38
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: STATE EXCHANGE: sent state msg: 0c1d4542-7c78-11e7-b1b4-cfffde69fc38
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: STATE EXCHANGE: got state msg: 0c1d4542-7c78-11e7-b1b4-cfffde69fc38 from 0 (mariadb-0.mariadb-discovery)
- 2017-08-08 20:27:49 140602712778496 [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 = 0c1d40d7-7c78-11e7-83c7-32b86b8deef4
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: Flow-control interval: [16, 16]
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: Restored state OPEN -> JOINED (0)
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: Member 0.0 (mariadb-0.mariadb-discovery) synced with group.
- 2017-08-08 20:27:49 140602712778496 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
- 2017-08-08 20:27:49 140603014789888 [Note] WSREP: New cluster view: global state: 0c1d40d7-7c78-11e7-83c7-32b86b8deef4:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
- 2017-08-08 20:27:49 140603015104448 [Note] WSREP: SST complete, seqno: 0
- 2017-08-08 20:27:49 7fe0b0c507c0 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/5.6/en/set-transaction.html.
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: The InnoDB memory heap is disabled
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: Compressed tables use zlib 1.2.8
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: Using Linux native AIO
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: Using SSE crc32 instructions
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: Initializing buffer pool, size = 1.0G
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: Completed initialization of buffer pool
- 2017-08-08 20:27:50 140603015104448 [Note] InnoDB: Highest supported file format is Barracuda.
- MySQL init process in progress...
- 2017-08-08 20:27:51 140603015104448 [Note] InnoDB: 128 rollback segment(s) are active.
- 2017-08-08 20:27:51 140603015104448 [Note] InnoDB: Waiting for purge to start
- 2017-08-08 20:27:51 140603015104448 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1616819
- MySQL init process in progress...
- MySQL init process in progress...
- MySQL init process in progress...
- 2017-08-08 20:27:54 140601068590848 [Note] InnoDB: Dumping buffer pool(s) not yet started
- 2017-08-08 20:27:54 140603015104448 [Note] Plugin 'FEEDBACK' is disabled.
- MySQL init process in progress...
- 2017-08-08 20:27:55 140603015104448 [Warning] 'user' entry 'root@mariadb-0' ignored in --skip-name-resolve mode.
- 2017-08-08 20:27:55 140603015104448 [Warning] 'proxies_priv' entry '@% root@mariadb-0' ignored in --skip-name-resolve mode.
- 2017-08-08 20:27:55 140603015104448 [Note] Reading of all Master_info entries succeded
- 2017-08-08 20:27:55 140603014789888 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
- 2017-08-08 20:27:55 140603015104448 [Note] Added new Master_info '' to hash table
- 2017-08-08 20:27:55 140603014789888 [Note] WSREP: REPL Protocols: 7 (3, 2)
- 2017-08-08 20:27:55 140603015104448 [Note] mysqld: ready for connections.
- Version: '10.1.23-MariaDB-1~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
- 2017-08-08 20:27:55 140603014789888 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
- 2017-08-08 20:27:55 140602770814720 [Note] WSREP: Service thread queue flushed.
- 2017-08-08 20:27:55 140603014789888 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(0c1d40d7-7c78-11e7-83c7-32b86b8deef4:0)
- 2017-08-08 20:27:55 140603014789888 [Note] WSREP: Synchronized with group, ready for connections
- 2017-08-08 20:27:55 140603014789888 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
- 2017-08-08 20:28:05 140602760297216 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
- 2017-08-08 20:28:15 140602760297216 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
- ...
Advertisement
Add Comment
Please, Sign In to add comment