Comments (17)
tongpu
commented on August 17, 2024
In which environment are you running? Are the logs you provided the full output or only an excerpt?
from openshift-mariadb-galera.
RobinsChens
commented on August 17, 2024
we use openshift 3.4 to deploy this cluster and store pv data with glusterfs
from openshift-mariadb-galera.
RobinsChens
commented on August 17, 2024
+ 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 <[email protected]> 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
from openshift-mariadb-galera.
RobinsChens
commented on August 17, 2024
that's all output log above
from openshift-mariadb-galera.
RobinsChens
commented on August 17, 2024
@tongpu Really thank you for your reply
from openshift-mariadb-galera.
tongpu
commented on August 17, 2024
@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?
from openshift-mariadb-galera.
RobinsChens
commented on August 17, 2024
@tongpu let me try
from openshift-mariadb-galera.
RobinsChens
commented on August 17, 2024
@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 <[email protected]> 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
from openshift-mariadb-galera.
RobinsChens
commented on August 17, 2024
+ 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
from openshift-mariadb-galera.
tongpu
commented on August 17, 2024
You seem to have a very strange permission issue in your PersistentVolume. Could you show a ls -lZ for the /var/lib/mysql directory?
from openshift-mariadb-galera.
richard-julien
commented on August 17, 2024
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
from openshift-mariadb-galera.
tongpu
commented on August 17, 2024
@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.
from openshift-mariadb-galera.
richard-julien
commented on August 17, 2024
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 !
from openshift-mariadb-galera.
tongpu
commented on August 17, 2024
@richard-julien Could you check if the busybox init-container I added in ea547d7 help with your issues.
from openshift-mariadb-galera.
richard-julien
commented on August 17, 2024
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
from openshift-mariadb-galera.
tongpu
commented on August 17, 2024
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.
from openshift-mariadb-galera.
eni23
commented on August 17, 2024
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.
from openshift-mariadb-galera.
Related Issues (17)
- Better readiness probe
- OpenShift templates HOT 1
- issue with restart nodes HOT 2
- Configure wsrep_cluster_name
- No route to host HOT 4
- Check WSREP status in readiness probe HOT 1
- Lost+found directory inside /var/lib/mysql HOT 2
- Can't work with a custom dns domain HOT 6
- Failed wsrep_sst_xtrabackup-v2 on Openshift 3.7, Kubernetes 1.7 HOT 5
- Compile peer finder from source HOT 4
- Recover from power failure in DC HOT 4
- Clients connect to unready endpoints HOT 1
- Failed to open file '/var/lib/mysql//galera.cache': 1 (Operation not permitted) HOT 6
- Openshift deployment problem: entry point script error HOT 1
- When change in yum.repos.d HOT 3
- I can't deploy it HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from openshift-mariadb-galera.