can not start successful

RobinsChens commented 7 years ago

2017-05-04  9:31:03 140203041720064 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-05-04  9:31:03 140204026059008 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-04  9:31:03 140204026059008 [Note] Server socket created on IP: '0.0.0.0'.
2017-05-04  9:31:03 140204026059008 [ERROR] Can't start server : Bind on unix socket: Permission denied
2017-05-04  9:31:03 140204026059008 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
2017-05-04  9:31:03 140204026059008 [ERROR] Aborting

Error in my_thread_global_end(): 1 threads didn't exit

tongpu commented 7 years ago

In which environment are you running? Are the logs you provided the full output or only an excerpt?

RobinsChens commented 7 years ago

we use openshift 3.4 to deploy this cluster and store pv data with glusterfs

RobinsChens commented 7 years ago

+ CONTAINER_SCRIPTS_DIR=/usr/share/container-scripts/mysql
+ EXTRA_DEFAULTS_FILE=/etc/my.cnf.d/galera.cnf
+ '[' -z mysql-cluster ']'
+ echo 'Galera: Finding peers'
Galera: Finding peers
++ hostname -f
++ cut -d. -f2
Using service name: galera
+ K8S_SVC_NAME=galera
+ echo 'Using service name: 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=galera
2017/05/04 12:50:02 Peer list updated
was []
now [mysql-0.galera.mysql-cluster.svc.cluster.local]
2017/05/04 12:50:02 execing: /usr/share/container-scripts/mysql/configure-galera.sh with stdin: mysql-0.galera.mysql-cluster.svc.cluster.local
2017/05/04 12:50:02 
2017/05/04 12:50:03 Peer finder exiting
+ '[' '!' -d /var/lib/mysql/mysql ']'
+ exec mysqld
2017-05-04 12:50:04 140532255717632 [Note] mysqld (mysqld 10.1.20-MariaDB) starting as process 1 ...
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-05-04 12:50:04 140532255717632 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
2017-05-04 12:50:04 140532255717632 [Note] WSREP: wsrep_load(): Galera 25.3.19(r3667) by Codership Oy <info@codership.com> loaded successfully.
2017-05-04 12:50:04 140532255717632 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = mysql-0.galera.mysql-cluster.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.announce_timeout
2017-05-04 12:50:04 140532255717632 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-05-04 12:50:04 140532255717632 [Note] WSREP: wsrep_sst_grab()
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Start replication
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-05-04 12:50:04 140532255717632 [Note] WSREP: protonet asio version 0
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Using CRC-32C for message checksums.
2017-05-04 12:50:04 140532255717632 [Note] WSREP: backend: asio
2017-05-04 12:50:04 140532255717632 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2017-05-04 12:50:04 140532255717632 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-05-04 12:50:04 140532255717632 [Note] WSREP: restore pc from disk failed
2017-05-04 12:50:04 140532255717632 [Note] WSREP: GMCast version 0
2017-05-04 12:50:04 140532255717632 [Note] WSREP: (3210a19c, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-05-04 12:50:04 140532255717632 [Note] WSREP: (3210a19c, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-05-04 12:50:04 140532255717632 [Note] WSREP: EVS version 0
2017-05-04 12:50:04 140532255717632 [Note] WSREP: gcomm: connecting to group 'galera', peer ''
2017-05-04 12:50:04 140532255717632 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Node 3210a19c state prim
2017-05-04 12:50:04 140532255717632 [Note] WSREP: view(view_id(PRIM,3210a19c,1) memb {
    3210a19c,0
} joined {
} left {
} partitioned {
})
2017-05-04 12:50:04 140532255717632 [Note] WSREP: save pc into disk
2017-05-04 12:50:04 140532255717632 [Note] WSREP: gcomm: connected
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Opened channel 'galera'
2017-05-04 12:50:04 140531933898496 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-05-04 12:50:04 140532255717632 [Note] WSREP: Waiting for SST to complete.
2017-05-04 12:50:04 140531933898496 [Note] WSREP: Starting new group from scratch: 3214558b-30c8-11e7-a310-5fa809368b58
2017-05-04 12:50:04 140531933898496 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 321469aa-30c8-11e7-9f0e-aa248df84ba0
2017-05-04 12:50:04 140531933898496 [Note] WSREP: STATE EXCHANGE: sent state msg: 321469aa-30c8-11e7-9f0e-aa248df84ba0
2017-05-04 12:50:04 140531933898496 [Note] WSREP: STATE EXCHANGE: got state msg: 321469aa-30c8-11e7-9f0e-aa248df84ba0 from 0 (mysql-0)
2017-05-04 12:50:04 140531933898496 [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 = 3214558b-30c8-11e7-a310-5fa809368b58
2017-05-04 12:50:04 140531933898496 [Note] WSREP: Flow-control interval: [16, 16]
2017-05-04 12:50:04 140531933898496 [Note] WSREP: Restored state OPEN -> JOINED (0)
2017-05-04 12:50:04 140531933898496 [Note] WSREP: Member 0.0 (mysql-0) synced with group.
2017-05-04 12:50:04 140531933898496 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2017-05-04 12:50:04 140532255267584 [Note] WSREP: New cluster view: global state: 3214558b-30c8-11e7-a310-5fa809368b58:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2017-05-04 12:50:04 140532255717632 [Note] WSREP: SST complete, seqno: 0
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Using Linux native AIO
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Using SSE crc32 instructions
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Completed initialization of buffer pool
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-04 12:50:05 140532255717632 [Note] InnoDB: Waiting for purge to start
2017-05-04 12:50:05 140532255717632 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1623454
2017-05-04 12:50:05 140531271173888 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-05-04 12:50:05 140532255717632 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-04 12:50:05 140532255717632 [Note] Server socket created on IP: '0.0.0.0'.
2017-05-04 12:50:05 140532255717632 [ERROR] Can't start server : Bind on unix socket: Permission denied
2017-05-04 12:50:05 140532255717632 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
2017-05-04 12:50:05 140532255717632 [ERROR] Aborting

Error in my_thread_global_end(): 1 threads didn't exit

RobinsChens commented 7 years ago

that's all output log above

RobinsChens commented 7 years ago

@tongpu Really thank you for your reply

tongpu commented 7 years ago

@RobinsChens You seem to have data from a previous installation of MariaDB in you PersistentVolume, especially the socket file /var/lib/mysql/mysql.sock causes MariaDB to not start properly. Could you delete all data in the PV, or at least delete the socket file?

RobinsChens commented 7 years ago

@tongpu let me try

RobinsChens commented 7 years ago

@tongpu it doesn't work, the same error ...

+ CONTAINER_SCRIPTS_DIR=/usr/share/container-scripts/mysql
+ EXTRA_DEFAULTS_FILE=/etc/my.cnf.d/galera.cnf
+ '[' -z mysql-cluster ']'
+ echo 'Galera: Finding peers'
Galera: Finding peers
++ hostname -f
++ cut -d. -f2
+ K8S_SVC_NAME=galera
+ echo 'Using service name: galera'
+ cp /usr/share/container-scripts/mysql/galera.cnf /etc/my.cnf.d/galera.cnf
Using service name: galera
+ /usr/bin/peer-finder -on-start=/usr/share/container-scripts/mysql/configure-galera.sh -service=galera
2017/05/05 04:20:43 Peer list updated
was []
now [mysql-0.galera.mysql-cluster.svc.cluster.local]
2017/05/05 04:20:43 execing: /usr/share/container-scripts/mysql/configure-galera.sh with stdin: mysql-0.galera.mysql-cluster.svc.cluster.local
2017/05/05 04:20:43 
2017/05/05 04:20:44 Peer finder exiting
+ '[' '!' -d /var/lib/mysql/mysql ']'
+ exec mysqld
2017-05-05  4:20:44 140087352867072 [Note] mysqld (mysqld 10.1.20-MariaDB) starting as process 1 ...
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-05-05  4:20:45 140087352867072 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'
2017-05-05  4:20:45 140087352867072 [Note] WSREP: wsrep_load(): Galera 25.3.19(r3667) by Codership Oy <info@codership.com> loaded successfully.
2017-05-05  4:20:45 140087352867072 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = mysql-0.galera.mysql-cluster.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.announce_timeout
2017-05-05  4:20:45 140087352867072 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-05-05  4:20:45 140087352867072 [Note] WSREP: wsrep_sst_grab()
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Start replication
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-05-05  4:20:45 140087352867072 [Note] WSREP: protonet asio version 0
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Using CRC-32C for message checksums.
2017-05-05  4:20:45 140087352867072 [Note] WSREP: backend: asio
2017-05-05  4:20:45 140087352867072 [Note] WSREP: gcomm thread scheduling priority set to other:0 
2017-05-05  4:20:45 140087352867072 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-05-05  4:20:45 140087352867072 [Note] WSREP: restore pc from disk failed
2017-05-05  4:20:45 140087352867072 [Note] WSREP: GMCast version 0
2017-05-05  4:20:45 140087352867072 [Note] WSREP: (35b9272a, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-05-05  4:20:45 140087352867072 [Note] WSREP: (35b9272a, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-05-05  4:20:45 140087352867072 [Note] WSREP: EVS version 0
2017-05-05  4:20:45 140087352867072 [Note] WSREP: gcomm: connecting to group 'galera', peer ''
2017-05-05  4:20:45 140087352867072 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Node 35b9272a state prim
2017-05-05  4:20:45 140087352867072 [Note] WSREP: view(view_id(PRIM,35b9272a,1) memb {
    35b9272a,0
} joined {
} left {
} partitioned {
})
2017-05-05  4:20:45 140087352867072 [Note] WSREP: save pc into disk
2017-05-05  4:20:45 140087352867072 [Note] WSREP: gcomm: connected
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Opened channel 'galera'
2017-05-05  4:20:45 140087031490304 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-05-05  4:20:45 140087352867072 [Note] WSREP: Waiting for SST to complete.
2017-05-05  4:20:45 140087031490304 [Note] WSREP: Starting new group from scratch: 35c052ac-314a-11e7-b9e6-cfd2dbacca57
2017-05-05  4:20:45 140087031490304 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 35c07a01-314a-11e7-9dfb-87280fa821fe
2017-05-05  4:20:45 140087031490304 [Note] WSREP: STATE EXCHANGE: sent state msg: 35c07a01-314a-11e7-9dfb-87280fa821fe
2017-05-05  4:20:45 140087031490304 [Note] WSREP: STATE EXCHANGE: got state msg: 35c07a01-314a-11e7-9dfb-87280fa821fe from 0 (mysql-0)
2017-05-05  4:20:45 140087031490304 [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 = 35c052ac-314a-11e7-b9e6-cfd2dbacca57
2017-05-05  4:20:45 140087031490304 [Note] WSREP: Flow-control interval: [16, 16]
2017-05-05  4:20:45 140087031490304 [Note] WSREP: Restored state OPEN -> JOINED (0)
2017-05-05  4:20:45 140087031490304 [Note] WSREP: Member 0.0 (mysql-0) synced with group.
2017-05-05  4:20:45 140087031490304 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2017-05-05  4:20:45 140087352417024 [Note] WSREP: New cluster view: global state: 35c052ac-314a-11e7-b9e6-cfd2dbacca57:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2017-05-05  4:20:45 140087352867072 [Note] WSREP: SST complete, seqno: 0
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: Using Linux native AIO
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: Using SSE crc32 instructions
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: Completed initialization of buffer pool
2017-05-05  4:20:45 140087352867072 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-05 04:20:46 7f68a0e7b900  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2017-05-05  4:20:46 140087352867072 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/gtid_slave_pos'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-05-05  4:20:46 140087352867072 [ERROR] InnoDB: Tablespace open failed for '"mysql"."gtid_slave_pos"', ignored.
2017-05-05 04:20:46 7f68a0e7b900  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2017-05-05  4:20:46 140087352867072 [ERROR] InnoDB: Could not find a valid tablespace file for 'mysql/innodb_index_stats'. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2017-05-05  4:20:46 140087352867072 [ERROR] InnoDB: Tablespace open failed for '"mysql"."innodb_index_stats"', ignored.
2017-05-05  4:20:46 140087352867072 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-05  4:20:46 140087352867072 [Note] InnoDB: Waiting for purge to start
2017-05-05  4:20:46 140087352867072 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1623365
2017-05-05  4:20:46 140087352867072 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-05  4:20:46 140086368765696 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-05-05  4:20:46 140087352867072 [Note] Server socket created on IP: '0.0.0.0'.
2017-05-05  4:20:46 140087352867072 [ERROR] Can't start server : Bind on unix socket: Permission denied
2017-05-05  4:20:46 140087352867072 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
2017-05-05  4:20:46 140087352867072 [ERROR] Aborting

Error in my_thread_global_end(): 1 threads didn't exit

RobinsChens commented 7 years ago

+ CONTAINER_SCRIPTS_DIR=/usr/share/container-scripts/mysql
+ EXTRA_DEFAULTS_FILE=/etc/my.cnf.d/galera.cnf
+ '[' -z mysql-cluster ']'
+ echo 'Galera: Finding peers'
Galera: Finding peers
++ hostname -f
++ cut -d. -f2
+ K8S_SVC_NAME=galera
+ echo 'Using service name: galera'
+ cp /usr/share/container-scripts/mysql/galera.cnf /etc/my.cnf.d/galera.cnf
Using service name: galera
+ /usr/bin/peer-finder -on-start=/usr/share/container-scripts/mysql/configure-galera.sh -service=galera
2017/05/05 04:30:56 lookup galera on 172.16.5.85:53: no such host
2017/05/05 04:30:57 Peer list updated
was []
now [mysql-0.galera.mysql-cluster.svc.cluster.local]
2017/05/05 04:30:57 execing: /usr/share/container-scripts/mysql/configure-galera.sh with stdin: mysql-0.galera.mysql-cluster.svc.cluster.local
2017/05/05 04:30:57 
2017/05/05 04:30:58 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' ...
2017-05-05  4:31:02 140225163270400 [Note] /usr/sbin/mysqld (mysqld 10.1.20-MariaDB) starting as process 49 ...
2017-05-05  4:31:03 140225163270400 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-05-05  4:31:03 140225163270400 [Note] WSREP: wsrep_load(): loading provider library 'none'
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Using Linux native AIO
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Using SSE crc32 instructions
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Completed initialization of buffer pool
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2017-05-05  4:31:04 140225163270400 [Note] InnoDB: Database physically writes the file full: wait...
2017-05-05  4:31:06 140225163270400 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2017-05-05  4:31:11 140225163270400 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2017-05-05  4:31:16 140225163270400 [Warning] InnoDB: New log files created, LSN=45883
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: Doublewrite buffer not found: creating new
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: Doublewrite buffer created
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-05  4:31:16 140225163270400 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: Foreign key constraint system tables created
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: Creating tablespace and datafile system tables.
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: Tablespace and datafile system tables created.
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: Creating zip_dict and zip_dict_cols system tables.
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: zip_dict and zip_dict_cols system tables created.
2017-05-05  4:31:16 140225163270400 [Note] InnoDB: Waiting for purge to start
2017-05-05  4:31:16 140225163270400 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 0
2017-05-05  4:31:16 140224394950400 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Filling help tables...
2017-05-05  4:31:27 140676941965568 [Note] /usr/sbin/mysqld (mysqld 10.1.20-MariaDB) starting as process 92 ...
2017-05-05  4:31:27 140676941965568 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-05-05  4:31:27 140676941965568 [Note] WSREP: wsrep_load(): loading provider library 'none'
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: Using Linux native AIO
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: Using SSE crc32 instructions
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-05  4:31:27 140676941965568 [Note] InnoDB: Completed initialization of buffer pool
2017-05-05  4:31:30 140676941965568 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-05  4:31:31 140676941965568 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-05  4:31:31 140676941965568 [Note] InnoDB: Waiting for purge to start
2017-05-05  4:31:31 140676941965568 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1622818
2017-05-05  4:31:32 140676184377088 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
Creating OpenGIS required SP-s...
2017-05-05  4:31:44 140324911429888 [Note] /usr/sbin/mysqld (mysqld 10.1.20-MariaDB) starting as process 129 ...
2017-05-05  4:31:44 140324911429888 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-05-05  4:31:44 140324911429888 [Note] WSREP: wsrep_load(): loading provider library 'none'
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Using Linux native AIO
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Using SSE crc32 instructions
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Completed initialization of buffer pool
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-05  4:31:44 140324911429888 [Note] InnoDB: Waiting for purge to start
2017-05-05  4:31:44 140324911429888 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1622828
2017-05-05  4:31:44 140324152248064 [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 mysql-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'
+ pid=163
+ 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}'
Finished mysql_install_db
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
2017-05-05  4:31:51 139662748338432 [Note] mysqld (mysqld 10.1.20-MariaDB) starting as process 163 ...
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
2017-05-05  4:31:52 139662748338432 [Warning] You need to use --log-bin to make --binlog-format work.
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
MySQL init process in progress...
+ echo 'MySQL init process in progress...'
+ sleep 1
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: Using Linux native AIO
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: Using SSE crc32 instructions
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-05  4:31:52 139662748338432 [Note] InnoDB: Completed initialization of buffer pool
2017-05-05  4:31:53 139662748338432 [Note] InnoDB: Highest supported file format is Barracuda.
+ 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
2017-05-05  4:31:53 139662748338432 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-05  4:31:53 139662748338432 [Note] InnoDB: Waiting for purge to start
2017-05-05  4:31:53 139662748338432 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1622838
2017-05-05  4:31:53 139661976516352 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-05-05  4:31:53 139662748338432 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-05  4:31:53 139662748338432 [ERROR] Can't start server : Bind on unix socket: Permission denied
2017-05-05  4:31:53 139662748338432 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql-init.sock ?
2017-05-05  4:31:53 139662748338432 [ERROR] Aborting

+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ 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
+ 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
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
MySQL init process in progress...
+ echo 'MySQL init process in progress...'
+ sleep 1
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ 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
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
MySQL init process in progress...
+ echo 'MySQL init process in progress...'
+ sleep 1
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ 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
+ 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
+ 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
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
MySQL init process in progress...
+ echo 'MySQL init process in progress...'
+ sleep 1
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ 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
+ 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
+ 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
+ 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
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ 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
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
MySQL init process in progress...
+ echo 'MySQL init process in progress...'
+ sleep 1
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'
MySQL init process in progress...
+ echo 'MySQL init process in progress...'
+ sleep 1
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ for i in '{30..0}'
+ echo 'SELECT 1'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'MySQL init process in progress...'
+ sleep 1
MySQL init process in progress...
+ '[' 0 = 0 ']'
+ echo 'MySQL init process failed.'
MySQL init process failed.
+ exit 1

tongpu commented 7 years ago

You seem to have a very strange permission issue in your PersistentVolume. Could you show a ls -lZ for the /var/lib/mysql directory?

richard-julien commented 7 years ago

Exactly the same problem for me. Command result

sh-4.2$ cd /var/lib/mysql/
sh-4.2$ ls -lZ
-rw-rw----. 27 2001 system_u:object_r:fusefs_t:s0    aria_log.00000001
-rw-rw----. 27 2001 system_u:object_r:fusefs_t:s0    aria_log_control
-rw-rw----. 27 2001 system_u:object_r:fusefs_t:s0    ib_logfile0
-rw-rw----. 27 2001 system_u:object_r:fusefs_t:s0    ib_logfile1
-rw-rw----. 27 2001 system_u:object_r:fusefs_t:s0    ibdata1
drwx--S---. 27 2001 system_u:object_r:fusefs_t:s0    mysql
drwx--S---. 27 2001 system_u:object_r:fusefs_t:s0    performance_schema
-rw-rw----. 27 2001 system_u:object_r:fusefs_t:s0    tc.log
drwx--S---. 27 2001 system_u:object_r:fusefs_t:s0    test

tongpu commented 7 years ago

@richard-julien What is the exact environment (OpenShift/Kubernetes version, backend for PersistentVolume, ...) you're running into this issue? We can then try to reproduce it. We using this image on OpenShift and Kubernetes without any issues.

richard-julien commented 7 years ago

Its a kubernetes 1.6.2 deployed on centos07 with Kubeadm. The volume is a GlusterFS created with a StorageClass using Heketi. I used https://github.com/adfinis-sygroup/openshift-mariadb-galera/blob/master/galera_k8s_v1.5.yml Thanks !

tongpu commented 7 years ago

@richard-julien Could you check if the busybox init-container I added in https://github.com/adfinis-sygroup/openshift-mariadb-galera/commit/ea547d7f26db5960c50dfd96f8cfa6afd36a91b8 help with your issues.

richard-julien commented 7 years ago

Unfortunately I get the same result. User information

kubectl exec -ti --namespace=xxxss mysql-0 /bin/sh
sh-4.2$ id
uid=27 gid=0(root) groups=0(root),2002

Directory permissions

sh-4.2$ cd /var/lib/
sh-4.2$ ls -al
total 8
drwxr-xr-x. 13 root root  163 Feb  8 12:55 .
drwxr-xr-x. 18 root root  238 Sep  6  2016 ..
drwxr-xr-x.  2 root root   44 May 15 17:06 alternatives
drwxr-xr-x.  2 root root    6 Aug  2  2016 dbus
drwxr-xr-x.  2 root root    6 Aug 12  2015 games
drwxr-xr-x.  2 root root    6 Jun 23  2016 initramfs
drwx------.  2 root root    6 Sep  6  2016 machines
drwxr-xr-x.  2 root root    6 Aug 12  2015 misc
drwxrwsr-x.  5   27   27 4096 May 17 01:23 mysql
drwxr-xr-x.  2 root root 4096 May 15 17:06 rpm
drwxr-xr-x.  2 root root    6 Aug 12  2015 rpm-state
drwxr-xr-x.  4 root root   56 May 15 17:06 systemd
drwxr-xr-x.  6 root root   80 May 15 17:06 yum

Deployment logs

Finished mysql_install_db
+ mysqld --skip-networking --socket=/var/lib/mysql/mysql-init.sock --wsrep_on=OFF
MySQL init process in progress...
+ echo 'MySQL init process in progress...'
+ sleep 1
2017-05-17  1:26:09 140653501077760 [Note] mysqld (mysqld 10.1.20-MariaDB) starting as process 143 ...
2017-05-17  1:26:09 140653501077760 [Warning] You need to use --log-bin to make --binlog-format work.
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Using Linux native AIO
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Using SSE crc32 instructions
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Completed initialization of buffer pool
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-17  1:26:10 140653501077760 [Note] InnoDB: Waiting for purge to start
2017-05-17  1:26:10 140653501077760 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1622838
+ 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
2017-05-17  1:26:10 140653501077760 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-17  1:26:10 140652754994944 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-05-17  1:26:10 140653501077760 [ERROR] Can't start server : Bind on unix socket: Permission denied
2017-05-17  1:26:10 140653501077760 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql-init.sock ?
2017-05-17  1:26:10 140653501077760 [ERROR] Aborting
+ for i in '{30..0}'
+ mysql --protocol=socket -uroot -hlocalhost --socket=/var/lib/mysql/mysql-init.sock
+ echo 'SELECT 1'

The node used for the deployment is a centos 7

[xxxx@centos01 ~]$ getenforce
Permissive
[xxxx@centos01 ~]$ uname -a
Linux centos01 3.10.0-514.el7.x86_64 #1 SMP Tue Nov 22 16:42:41 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

tongpu commented 7 years ago

Somehow there seem to be issues with creating the socket on the GlusterFS PV. I'll build a separate image which creates the sockets in /var/run/mysql, maybe that would help.

eni23 commented 7 years ago

The current version of the image has moved the socket to /var/run/mysql and was successfully tested with glusterfs. You can reopen this issue if its still not starting.

adfinis / openshift-mariadb-galera

can not start successful #9