Why the mariadb container always restart ?

Tommy Sway sz_cuitao at 163.com
Fri Aug 27 16:39:28 UTC 2021


Hi:

 

The system is broken down for the power, and I restart the whole system, but
the mariadb container always restart, about one minite restart once.

 

Ant this is the log :

 

 

2021-08-28  0:34:51 0 [Note] WSREP: (a8e9005b, 'tcp://10.10.10.63:4567')
turning message relay requesting off

2021-08-28  0:35:03 0 [ERROR] WSREP: failed to open gcomm backend
connection: 110: failed to reach primary view: 110 (Connection timed out)

         at gcomm/src/pc.cpp:connect():160

2021-08-28  0:35:03 0 [ERROR] WSREP:
gcs/src/gcs_core.cpp:gcs_core_open():209: Failed to open backend connection:
-110 (Connection timed out)

2021-08-28  0:35:03 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1475: Failed
to open channel 'openstack' at
'gcomm://10.10.10.61:4567,10.10.10.62:4567,10.10.10.63:4567': -110
(Connection timed out)

2021-08-28  0:35:03 0 [ERROR] WSREP: gcs connect failed: Connection timed
out

2021-08-28  0:35:03 0 [ERROR] WSREP:
wsrep::connect(gcomm://10.10.10.61:4567,10.10.10.62:4567,10.10.10.63:4567)
failed: 7

2021-08-28  0:35:03 0 [ERROR] Aborting

 

210828 00:35:05 mysqld_safe mysqld from pid file /var/lib/mysql/mariadb.pid
ended

210828 00:35:08 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql/

210828 00:35:08 mysqld_safe WSREP: Running position recovery with
--disable-log-error  --pid-file='/var/lib/mysql//control03-recover.pid'

210828 00:35:12 mysqld_safe WSREP: Recovered position
5bdd8d83-05a4-11ec-adfd-ae6e7e26deb9:140403

2021-08-28  0:35:12 0 [Note] WSREP: Read nil XID from storage engines,
skipping position init

2021-08-28  0:35:12 0 [Note] WSREP: wsrep_load(): loading provider library
'/usr/lib64/galera/libgalera_smm.so'

2021-08-28  0:35:12 0 [Note] /usr/libexec/mysqld (mysqld
10.3.28-MariaDB-log) starting as process 258 ...

2021-08-28  0:35:12 0 [Note] WSREP: wsrep_load(): Galera 3.32(rXXXX) by
Codership Oy info at codership.com <mailto:info at codership.com>  loaded
successfully.

2021-08-28  0:35:12 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.

2021-08-28  0:35:12 0 [Note] WSREP: Found saved state:
5bdd8d83-05a4-11ec-adfd-ae6e7e26deb9:-1, safe_to_bootstrap: 1

2021-08-28  0:35:12 0 [Note] WSREP: Passing config to GCS: base_dir =
/var/lib/mysql/; base_host = 10.10.10.63; base_port = 4567;
cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no;
evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period =
PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S;
evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3;
evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout =
PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir
= /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.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://10.10.10.63:4567; gmcast.segment = 0; gmc

2021-08-28  0:35:12 0 [Note] WSREP: GCache history reset:
5bdd8d83-05a4-11ec-adfd-ae6e7e26deb9:0 ->
5bdd8d83-05a4-11ec-adfd-ae6e7e26deb9:140403

2021-08-28  0:35:12 0 [Note] WSREP: Assign initial position for
certification: 140403, protocol version: -1

2021-08-28  0:35:12 0 [Note] WSREP: wsrep_sst_grab()

2021-08-28  0:35:12 0 [Note] WSREP: Start replication

2021-08-28  0:35:12 0 [Note] WSREP: Setting initial position to
5bdd8d83-05a4-11ec-adfd-ae6e7e26deb9:140403

2021-08-28  0:35:12 0 [Note] WSREP: protonet asio version 0

2021-08-28  0:35:12 0 [Note] WSREP: Using CRC-32C for message checksums.

2021-08-28  0:35:12 0 [Note] WSREP: backend: asio

2021-08-28  0:35:12 0 [Note] WSREP: gcomm thread scheduling priority set to
other:0

2021-08-28  0:35:12 0 [Warning] WSREP: access
file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)

2021-08-28  0:35:12 0 [Note] WSREP: restore pc from disk failed

2021-08-28  0:35:12 0 [Note] WSREP: GMCast version 0

2021-08-28  0:35:12 0 [Note] WSREP: (c05f5c52, 'tcp://10.10.10.63:4567')
listening at tcp://10.10.10.63:4567

2021-08-28  0:35:12 0 [Note] WSREP: (c05f5c52, 'tcp://10.10.10.63:4567')
multicast: , ttl: 1

2021-08-28  0:35:12 0 [Note] WSREP: EVS version 0

2021-08-28  0:35:12 0 [Note] WSREP: gcomm: connecting to group 'openstack',
peer '10.10.10.61:4567,10.10.10.62:4567,10.10.10.63:4567'

2021-08-28  0:35:12 0 [Note] WSREP: (c05f5c52, 'tcp://10.10.10.63:4567')
connection established to b1ae23e3 tcp://10.10.10.62:4567

2021-08-28  0:35:12 0 [Note] WSREP: (c05f5c52, 'tcp://10.10.10.63:4567')
turning message relay requesting on, nonlive peers:

2021-08-28  0:35:16 0 [Note] WSREP: (c05f5c52, 'tcp://10.10.10.63:4567')
turning message relay requesting off

2021-08-28  0:35:16 0 [Note] WSREP: (c05f5c52, 'tcp://10.10.10.63:4567')
connection established to c296912b tcp://10.10.10.61:4567

2021-08-28  0:35:16 0 [Note] WSREP: (c05f5c52, 'tcp://10.10.10.63:4567')
turning message relay requesting on, nonlive peers:

2021-08-28  0:35:18 0 [Note] WSREP: declaring b1ae23e3 at
tcp://10.10.10.62:4567 stable

2021-08-28  0:35:18 0 [Note] WSREP: declaring c296912b at
tcp://10.10.10.61:4567 stable

2021-08-28  0:35:19 0 [Warning] WSREP: no nodes coming from prim view, prim
not possible

 

 

What's matter with it ?

 

Thanks!

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20210828/dcf9a514/attachment-0001.html>


More information about the openstack-discuss mailing list