Install guide for Galera for mysql 5.7
807 views
Skip to first unread message
Ronnie Visser
Jan 26, 2017, 4:45:23 PM1/26/17
to codership
Hi,
I was wondering if there is an install guide for installing with mysql 5.7. I tried several thing but I fail everytime starting the first node.
thanks
I was wondering if there is an install guide for installing with mysql 5.7. I tried several thing but I fail everytime starting the first node.
thanks
Philip Stoev
Jan 27, 2017, 1:53:42 AM1/27/17
to Ronnie Visser, codership
Hello,
Please see the documentation at
http://galeracluster.com/documentation-webpages/startingcluster.html
Depending on your distro and distro version, you may need to use a different
command when starting the first node.
If that does not work for you, please provide the error log for further
examination.
Philip Stoev
--
You received this message because you are subscribed to the Google Groups
"codership" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to codership-tea...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Please see the documentation at
http://galeracluster.com/documentation-webpages/startingcluster.html
Depending on your distro and distro version, you may need to use a different
command when starting the first node.
If that does not work for you, please provide the error log for further
examination.
Philip Stoev
You received this message because you are subscribed to the Google Groups
"codership" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to codership-tea...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Ronnie Visser
Jan 27, 2017, 3:15:22 AM1/27/17
to codership
Hi,
I followed the tutorials for installing with 5.6 here: https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04 . everything where 5.6 is meantion i have changed it to 5.7
when running /usr/bin/mysqld_bootstrap the following output is given:
/usr/bin/mysqld_bootstrap
Failed to set environment: Access denied
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to start 'mysql.service'.
Authenticating as: SportMonks,,, (sportmonk)
Password:
==== AUTHENTICATION COMPLETE ===
Failed to set environment: Access denied
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Failed to set environment: Access denied
in the journalctl file is see this:
[sudo] password for sportmonk:
Jan 27 08:10:29 SportMonks-Galera-001 polkitd(authority=local)[1515]: Registered
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Operator o
Jan 27 08:10:30 SportMonks-Galera-001 systemd[1]: Started MySQL Wsrep Server.
-- Subject: Unit mysql.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished starting up.
--
-- The start-up result is done.
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Unregister
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Registered
Jan 27 08:10:30 SportMonks-Galera-001 dbus[1427]: [system] Rejected send message
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Unregister
Jan 27 08:10:58 SportMonks-Galera-001 sshd[15829]: pam_unix(sshd:auth): authenti
Jan 27 08:11:00 SportMonks-Galera-001 sshd[15829]: Failed password for root from
Jan 27 08:11:03 SportMonks-Galera-001 sshd[15829]: Failed password for root from
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Failed password for root from
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Received disconnect from 116.
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Disconnected from 116.31.116.
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: PAM 2 more authentication fai
Jan 27 08:11:28 SportMonks-Galera-001 sudo[15832]: sportmonk : TTY=pts/0 ; PWD=/
Jan 27 08:11:28 SportMonks-Galera-001 sudo[15832]: pam_unix(sudo:session): sessi
lines 2272-2294/2294 (END)
Jan 27 08:10:29 SportMonks-Galera-001 polkitd(authority=local)[1515]: Registered A
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Operator of
Jan 27 08:10:30 SportMonks-Galera-001 systemd[1]: Started MySQL Wsrep Server.
-- Subject: Unit mysql.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished starting up.
--
-- The start-up result is done.
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Unregistered
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Registered A
Jan 27 08:10:30 SportMonks-Galera-001 dbus[1427]: [system] Rejected send message,
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Unregistered
Jan 27 08:10:58 SportMonks-Galera-001 sshd[15829]: pam_unix(sshd:auth): authentica
Jan 27 08:11:00 SportMonks-Galera-001 sshd[15829]: Failed password for root from 1
Jan 27 08:11:03 SportMonks-Galera-001 sshd[15829]: Failed password for root from 1
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Failed password for root from 1
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Received disconnect from 116.31
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Disconnected from 116.31.116.49
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: PAM 2 more authentication failu
Jan 27 08:11:28 SportMonks-Galera-001 sudo[15832]: sportmonk : TTY=pts/0 ; PWD=/ho
Jan 27 08:11:28 SportMonks-Galera-001 sudo[15832]: pam_unix(sudo:session): session
lines 2272-2294/2294 (END)
it has something to do with autentication or something but I also see this: ==== AUTHENTICATION COMPLETE ===
hope you can help me out here.
I followed the tutorials for installing with 5.6 here: https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04 . everything where 5.6 is meantion i have changed it to 5.7
when running /usr/bin/mysqld_bootstrap the following output is given:
/usr/bin/mysqld_bootstrap
Failed to set environment: Access denied
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to start 'mysql.service'.
Authenticating as: SportMonks,,, (sportmonk)
Password:
==== AUTHENTICATION COMPLETE ===
Failed to set environment: Access denied
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Failed to set environment: Access denied
in the journalctl file is see this:
[sudo] password for sportmonk:
Jan 27 08:10:29 SportMonks-Galera-001 polkitd(authority=local)[1515]: Registered
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Operator o
Jan 27 08:10:30 SportMonks-Galera-001 systemd[1]: Started MySQL Wsrep Server.
-- Subject: Unit mysql.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished starting up.
--
-- The start-up result is done.
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Unregister
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Registered
Jan 27 08:10:30 SportMonks-Galera-001 dbus[1427]: [system] Rejected send message
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Unregister
Jan 27 08:10:58 SportMonks-Galera-001 sshd[15829]: pam_unix(sshd:auth): authenti
Jan 27 08:11:00 SportMonks-Galera-001 sshd[15829]: Failed password for root from
Jan 27 08:11:03 SportMonks-Galera-001 sshd[15829]: Failed password for root from
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Failed password for root from
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Received disconnect from 116.
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Disconnected from 116.31.116.
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: PAM 2 more authentication fai
Jan 27 08:11:28 SportMonks-Galera-001 sudo[15832]: sportmonk : TTY=pts/0 ; PWD=/
Jan 27 08:11:28 SportMonks-Galera-001 sudo[15832]: pam_unix(sudo:session): sessi
lines 2272-2294/2294 (END)
Jan 27 08:10:29 SportMonks-Galera-001 polkitd(authority=local)[1515]: Registered A
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Operator of
Jan 27 08:10:30 SportMonks-Galera-001 systemd[1]: Started MySQL Wsrep Server.
-- Subject: Unit mysql.service has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished starting up.
--
-- The start-up result is done.
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Unregistered
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Registered A
Jan 27 08:10:30 SportMonks-Galera-001 dbus[1427]: [system] Rejected send message,
Jan 27 08:10:30 SportMonks-Galera-001 polkitd(authority=local)[1515]: Unregistered
Jan 27 08:10:58 SportMonks-Galera-001 sshd[15829]: pam_unix(sshd:auth): authentica
Jan 27 08:11:00 SportMonks-Galera-001 sshd[15829]: Failed password for root from 1
Jan 27 08:11:03 SportMonks-Galera-001 sshd[15829]: Failed password for root from 1
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Failed password for root from 1
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Received disconnect from 116.31
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: Disconnected from 116.31.116.49
Jan 27 08:11:05 SportMonks-Galera-001 sshd[15829]: PAM 2 more authentication failu
Jan 27 08:11:28 SportMonks-Galera-001 sudo[15832]: sportmonk : TTY=pts/0 ; PWD=/ho
Jan 27 08:11:28 SportMonks-Galera-001 sudo[15832]: pam_unix(sudo:session): session
lines 2272-2294/2294 (END)
it has something to do with autentication or something but I also see this: ==== AUTHENTICATION COMPLETE ===
hope you can help me out here.
Philip Stoev
Jan 27, 2017, 3:29:19 AM1/27/17
to Ronnie Visser, codersh...@googlegroups.com
Hello,
Please look into the mysql error log, which is in /var/log/mysql or
thereabout.
Thank you.
Philip Stoev
-----Original Message-----
From: Ronnie Visser
Please look into the mysql error log, which is in /var/log/mysql or
thereabout.
Thank you.
Philip Stoev
-----Original Message-----
From: Ronnie Visser
Ronnie Visser
Jan 27, 2017, 3:45:47 AM1/27/17
to codership
2017-01-27T07:58:26.552999Z 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50764S), skipping check
2017-01-27T07:58:56.069482Z 0 [Note] WSREP: view((empty))
2017-01-27T07:58:56.072023Z 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():158
2017-01-27T07:58:56.072055Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2017-01-27T07:58:56.072123Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1404: Failed to open channel 'sportmonks_cluster' at 'gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19': -110 (Connection timed out)
2017-01-27T07:58:56.072141Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2017-01-27T07:58:56.072151Z 0 [ERROR] WSREP: wsrep::connect(gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19) failed: 7
2017-01-27T07:58:56.072157Z 0 [ERROR] Aborting
2017-01-27T07:58:56.072162Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-01-27T07:58:56.072170Z 0 [Note] WSREP: Service disconnected.
2017-01-27T07:58:57.072338Z 0 [Note] WSREP: Some threads may fail to exit.
2017-01-27T07:58:57.075176Z 0 [Note] Binlog end
2017-01-27T07:58:57.075291Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-01-27T07:58:59.406662Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-27T07:58:59.408055Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 15425 ...
2017-01-27T07:58:59.410956Z 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-01-27T07:58:59.410978Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2017-01-27T07:58:59.414935Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <in...@codership.com> loaded successfully.
2017-01-27T07:58:59.414980Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-01-27T07:58:59.415400Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-01-27T07:58:59.416775Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.129.29.245; 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 = PT3S; pc.checksum = false; pc.
2017-01-27T07:58:59.430499Z 0 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-01-27T07:58:59.431057Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-01-27T07:58:59.431094Z 0 [Note] WSREP: wsrep_sst_grab()
2017-01-27T07:58:59.431112Z 0 [Note] WSREP: Start replication
2017-01-27T07:58:59.431141Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-01-27T07:58:59.431300Z 0 [Note] WSREP: protonet asio version 0
2017-01-27T07:58:59.431512Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-01-27T07:58:59.431575Z 0 [Note] WSREP: backend: asio
2017-01-27T07:58:59.431699Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-01-27T07:58:59.431901Z 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-01-27T07:58:59.431926Z 0 [Note] WSREP: restore pc from disk failed
2017-01-27T07:58:59.432777Z 0 [Note] WSREP: GMCast version 0
2017-01-27T07:58:59.433440Z 0 [Note] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-01-27T07:58:59.433465Z 0 [Note] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-01-27T07:58:59.434197Z 0 [Note] WSREP: EVS version 0
2017-01-27T07:58:59.434398Z 0 [Note] WSREP: gcomm: connecting to group 'sportmonks_cluster', peer '10.129.29.245:,10.129.30.11:,10.129.30.15:,10.129.30.19:'
2017-01-27T07:58:59.436737Z 0 [Note] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') connection established to 75ba4d7d tcp://10.129.29.245:4567
2017-01-27T07:58:59.436775Z 0 [Warning] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') address 'tcp://10.129.29.245:4567' points to own listening address, blacklisting
2017-01-27T07:59:02.436711Z 0 [Note] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') connection to peer 75ba4d7d with addr tcp://10.129.29.245:4567 timed out, no messages seen in PT3S
2017-01-27T07:59:02.438799Z 0 [Warning] WSREP: no nodes coming from prim view, prim not possible
2017-01-27T07:59:02.438848Z 0 [Note] WSREP: view(view_id(NON_PRIM,75ba4d7d,1) memb {
75ba4d7d,0
} joined {
} left {
} partitioned {
})
2017-01-27T07:59:02.939878Z 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50569S), skipping check
2017-01-27T07:59:32.457007Z 0 [Note] WSREP: view((empty))
2017-01-27T07:59:32.457681Z 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():158
2017-01-27T07:59:32.457715Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2017-01-27T07:59:32.457862Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1404: Failed to open channel 'sportmonks_cluster' at 'gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19': -110 (Connection timed out)
2017-01-27T07:59:32.457898Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2017-01-27T07:59:32.457932Z 0 [ERROR] WSREP: wsrep::connect(gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19) failed: 7
2017-01-27T07:59:32.457944Z 0 [ERROR] Aborting
2017-01-27T07:59:32.457950Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-01-27T07:59:32.457961Z 0 [Note] WSREP: Service disconnected.
2017-01-27T07:59:33.458114Z 0 [Note] WSREP: Some threads may fail to exit.
2017-01-27T07:59:33.462519Z 0 [Note] Binlog end
2017-01-27T07:59:33.462823Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-01-27T07:59:35.989660Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-27T07:59:35.991721Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 15483 ...
2017-01-27T07:59:35.994761Z 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-01-27T07:59:35.994783Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2017-01-27T07:59:35.999273Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <in...@codership.com> loaded successfully.
2017-01-27T07:59:35.999333Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-01-27T07:59:35.999936Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-01-27T07:59:36.001326Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.129.29.245; 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 = PT3S; pc.checksum = false; pc.
2017-01-27T07:59:36.015324Z 0 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-01-27T07:59:36.015914Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-01-27T07:59:36.015946Z 0 [Note] WSREP: wsrep_sst_grab()
2017-01-27T07:59:36.015954Z 0 [Note] WSREP: Start replication
2017-01-27T07:59:36.015981Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-01-27T07:59:36.016121Z 0 [Note] WSREP: protonet asio version 0
2017-01-27T07:59:36.016293Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-01-27T07:59:36.016350Z 0 [Note] WSREP: backend: asio
2017-01-27T07:59:36.016500Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-01-27T07:59:36.016682Z 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-01-27T07:59:36.016699Z 0 [Note] WSREP: restore pc from disk failed
2017-01-27T07:59:36.017344Z 0 [Note] WSREP: GMCast version 0
2017-01-27T07:59:36.017746Z 0 [Note] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-01-27T07:59:36.017764Z 0 [Note] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-01-27T07:59:36.018272Z 0 [Note] WSREP: EVS version 0
2017-01-27T07:59:36.018488Z 0 [Note] WSREP: gcomm: connecting to group 'sportmonks_cluster', peer '10.129.29.245:,10.129.30.11:,10.129.30.15:,10.129.30.19:'
2017-01-27T07:59:36.020970Z 0 [Note] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') connection established to 8b88b1ef tcp://10.129.29.245:4567
2017-01-27T07:59:36.021024Z 0 [Warning] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') address 'tcp://10.129.29.245:4567' points to own listening address, blacklisting
2017-01-27T07:59:39.021231Z 0 [Note] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') connection to peer 8b88b1ef with addr tcp://10.129.29.245:4567 timed out, no messages seen in PT3S
2017-01-27T07:59:39.023661Z 0 [Warning] WSREP: no nodes coming from prim view, prim not possible
2017-01-27T07:59:39.023726Z 0 [Note] WSREP: view(view_id(NON_PRIM,8b88b1ef,1) memb {
8b88b1ef,0
} joined {
} left {
} partitioned {
})
2017-01-27T07:59:39.524180Z 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50594S), skipping check
2017-01-27T08:00:09.053648Z 0 [Note] WSREP: view((empty))
2017-01-27T08:00:09.054654Z 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():158
2017-01-27T08:00:09.054688Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2017-01-27T08:00:09.054825Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1404: Failed to open channel 'sportmonks_cluster' at 'gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19': -110 (Connection timed out)
2017-01-27T08:00:09.054853Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2017-01-27T08:00:09.054867Z 0 [ERROR] WSREP: wsrep::connect(gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19) failed: 7
2017-01-27T08:00:09.054879Z 0 [ERROR] Aborting
2017-01-27T08:00:09.054885Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-01-27T08:00:09.054894Z 0 [Note] WSREP: Service disconnected.
2017-01-27T08:00:10.055062Z 0 [Note] WSREP: Some threads may fail to exit.
2017-01-27T08:00:10.058985Z 0 [Note] Binlog end
2017-01-27T08:00:10.059143Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-01-27T08:00:12.476140Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-27T08:00:12.479335Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 15627 ...
2017-01-27T08:00:12.483418Z 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-01-27T08:00:12.483453Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2017-01-27T08:00:12.489355Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <in...@codership.com> loaded successfully.
2017-01-27T08:00:12.489428Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-01-27T08:00:12.489941Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-01-27T08:00:12.491807Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.129.29.245; 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 = PT3S; pc.checksum = false; pc.
2017-01-27T08:00:12.514960Z 0 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-01-27T08:00:12.515522Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-01-27T08:00:12.515546Z 0 [Note] WSREP: wsrep_sst_grab()
2017-01-27T08:00:12.515561Z 0 [Note] WSREP: Start replication
2017-01-27T08:00:12.515578Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-01-27T08:00:12.515700Z 0 [Note] WSREP: protonet asio version 0
2017-01-27T08:00:12.515855Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-01-27T08:00:12.515909Z 0 [Note] WSREP: backend: asio
2017-01-27T08:00:12.516006Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-01-27T08:00:12.516135Z 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-01-27T08:00:12.516150Z 0 [Note] WSREP: restore pc from disk failed
2017-01-27T08:00:12.516758Z 0 [Note] WSREP: GMCast version 0
2017-01-27T08:00:12.517192Z 0 [Note] WSREP: (a14a1132, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-01-27T08:00:12.517222Z 0 [Note] WSREP: (a14a1132, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-01-27T08:00:12.517746Z 0 [Note] WSREP: EVS version 0
2017-01-27T08:00:12.517867Z 0 [Note] WSREP: gcomm: bootstrapping new group 'sportmonks_cluster'
2017-01-27T08:00:12.517908Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2017-01-27T08:00:12.518780Z 0 [Note] WSREP: Node a14a1132 state prim
2017-01-27T08:00:12.518922Z 0 [Note] WSREP: view(view_id(PRIM,a14a1132,1) memb {
a14a1132,0
} joined {
} left {
} partitioned {
})
2017-01-27T08:00:12.518942Z 0 [Note] WSREP: save pc into disk
2017-01-27T08:00:12.519168Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.129.29.245:4567
2017-01-27T08:00:12.519186Z 0 [Note] WSREP: discarding pending addr proto entry 0x3c01c50
2017-01-27T08:00:12.519243Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.129.30.11:4567
2017-01-27T08:00:12.519258Z 0 [Note] WSREP: discarding pending addr proto entry 0x3c0a5f0
2017-01-27T08:00:12.519282Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.129.30.15:4567
2017-01-27T08:00:12.519292Z 0 [Note] WSREP: discarding pending addr proto entry 0x3c12f40
2017-01-27T08:00:12.519309Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.129.30.19:4567
2017-01-27T08:00:12.519319Z 0 [Note] WSREP: discarding pending addr proto entry 0x3c1b7c0
2017-01-27T08:00:12.519362Z 0 [Note] WSREP: gcomm: connected
2017-01-27T08:00:12.519432Z 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2017-01-27T08:00:12.519490Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-01-27T08:00:12.519500Z 0 [Note] WSREP: Opened channel 'sportmonks_cluster'
2017-01-27T08:00:12.519607Z 0 [Note] WSREP: Waiting for SST to complete.
2017-01-27T08:00:12.520650Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-01-27T08:00:12.521386Z 0 [Note] WSREP: Starting new group from scratch: a14acd6e-e466-11e6-9048-82933c8a877f
2017-01-27T08:00:12.521861Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: a14add46-e466-11e6-99d6-6b6f50974c0a
2017-01-27T08:00:12.521900Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: a14add46-e466-11e6-99d6-6b6f50974c0a
2017-01-27T08:00:12.521914Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: a14add46-e466-11e6-99d6-6b6f50974c0a from 0 (SportMonks-Galera-001)
2017-01-27T08:00:12.521925Z 0 [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 = a14acd6e-e466-11e6-9048-82933c8a877f
2017-01-27T08:00:12.521933Z 0 [Note] WSREP: Flow-control interval: [16, 16]
2017-01-27T08:00:12.521949Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0)
2017-01-27T08:00:12.521976Z 0 [Note] WSREP: Member 0.0 (SportMonks-Galera-001) synced with group.
2017-01-27T08:00:12.521996Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2017-01-27T08:00:12.522993Z 2 [Note] WSREP: New cluster view: global state: a14acd6e-e466-11e6-9048-82933c8a877f:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2017-01-27T08:00:12.523038Z 0 [Note] WSREP: SST complete, seqno: 0
2017-01-27T08:00:12.525105Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-01-27T08:00:12.525169Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-27T08:00:12.525272Z 0 [Note] InnoDB: Uses event mutexes
2017-01-27T08:00:12.525282Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-27T08:00:12.525289Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-27T08:00:12.525296Z 0 [Note] InnoDB: Using Linux native AIO
2017-01-27T08:00:12.525678Z 0 [Note] InnoDB: Number of pools: 1
2017-01-27T08:00:12.525865Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-01-27T08:00:12.528018Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-01-27T08:00:12.541422Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-01-27T08:00:12.547001Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-01-27T08:00:12.564355Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-27T08:00:12.581556Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-01-27T08:00:12.581678Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-01-27T08:00:12.640461Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-01-27T08:00:12.641497Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-01-27T08:00:12.641519Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-01-27T08:00:12.643585Z 0 [Note] InnoDB: Waiting for purge to start
2017-01-27T08:00:12.693923Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 1354338
2017-01-27T08:00:12.696046Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-01-27T08:00:12.700725Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-01-27T08:00:12.701058Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170127 8:00:12
2017-01-27T08:00:12.743058Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-01-27T08:00:12.750810Z 0 [Warning] CA certificate ca.pem is self signed.
2017-01-27T08:00:12.753415Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2017-01-27T08:00:12.753464Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2017-01-27T08:00:12.753520Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2017-01-27T08:00:12.783569Z 0 [Note] Event Scheduler: Loaded 0 events
2017-01-27T08:00:12.784886Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-01-27T08:00:12.784910Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-01-27T08:00:12.786320Z 2 [Note] WSREP: Initialized wsrep sidno 2
2017-01-27T08:00:12.786417Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-01-27T08:00:12.786491Z 2 [Note] WSREP: REPL Protocols: 7 (3, 2)
2017-01-27T08:00:12.786522Z 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
2017-01-27T08:00:12.786579Z 0 [Note] WSREP: Service thread queue flushed.
2017-01-27T08:00:12.786848Z 2 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(a14acd6e-e466-11e6-9048-82933c8a877f:0)
2017-01-27T08:00:12.787691Z 2 [Note] WSREP: Synchronized with group, ready for connections
2017-01-27T08:00:12.787712Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-01-27T08:00:12.845600Z 0 [Note] End of list of non-natively partitioned tables
2017-01-27T08:00:12.845799Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Wsrep Server (GPL), wsrep_25.11
2017-01-27T08:00:13.889585Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-01-27T07:58:56.069482Z 0 [Note] WSREP: view((empty))
2017-01-27T07:58:56.072023Z 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():158
2017-01-27T07:58:56.072055Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2017-01-27T07:58:56.072123Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1404: Failed to open channel 'sportmonks_cluster' at 'gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19': -110 (Connection timed out)
2017-01-27T07:58:56.072141Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2017-01-27T07:58:56.072151Z 0 [ERROR] WSREP: wsrep::connect(gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19) failed: 7
2017-01-27T07:58:56.072157Z 0 [ERROR] Aborting
2017-01-27T07:58:56.072162Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-01-27T07:58:56.072170Z 0 [Note] WSREP: Service disconnected.
2017-01-27T07:58:57.072338Z 0 [Note] WSREP: Some threads may fail to exit.
2017-01-27T07:58:57.075176Z 0 [Note] Binlog end
2017-01-27T07:58:57.075291Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-01-27T07:58:59.406662Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-27T07:58:59.408055Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 15425 ...
2017-01-27T07:58:59.410956Z 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-01-27T07:58:59.410978Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2017-01-27T07:58:59.414935Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <in...@codership.com> loaded successfully.
2017-01-27T07:58:59.414980Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-01-27T07:58:59.415400Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-01-27T07:58:59.416775Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.129.29.245; 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 = PT3S; pc.checksum = false; pc.
2017-01-27T07:58:59.430499Z 0 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-01-27T07:58:59.431057Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-01-27T07:58:59.431094Z 0 [Note] WSREP: wsrep_sst_grab()
2017-01-27T07:58:59.431112Z 0 [Note] WSREP: Start replication
2017-01-27T07:58:59.431141Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-01-27T07:58:59.431300Z 0 [Note] WSREP: protonet asio version 0
2017-01-27T07:58:59.431512Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-01-27T07:58:59.431575Z 0 [Note] WSREP: backend: asio
2017-01-27T07:58:59.431699Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-01-27T07:58:59.431901Z 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-01-27T07:58:59.431926Z 0 [Note] WSREP: restore pc from disk failed
2017-01-27T07:58:59.432777Z 0 [Note] WSREP: GMCast version 0
2017-01-27T07:58:59.433440Z 0 [Note] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-01-27T07:58:59.433465Z 0 [Note] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-01-27T07:58:59.434197Z 0 [Note] WSREP: EVS version 0
2017-01-27T07:58:59.434398Z 0 [Note] WSREP: gcomm: connecting to group 'sportmonks_cluster', peer '10.129.29.245:,10.129.30.11:,10.129.30.15:,10.129.30.19:'
2017-01-27T07:58:59.436737Z 0 [Note] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') connection established to 75ba4d7d tcp://10.129.29.245:4567
2017-01-27T07:58:59.436775Z 0 [Warning] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') address 'tcp://10.129.29.245:4567' points to own listening address, blacklisting
2017-01-27T07:59:02.436711Z 0 [Note] WSREP: (75ba4d7d, 'tcp://0.0.0.0:4567') connection to peer 75ba4d7d with addr tcp://10.129.29.245:4567 timed out, no messages seen in PT3S
2017-01-27T07:59:02.438799Z 0 [Warning] WSREP: no nodes coming from prim view, prim not possible
2017-01-27T07:59:02.438848Z 0 [Note] WSREP: view(view_id(NON_PRIM,75ba4d7d,1) memb {
75ba4d7d,0
} joined {
} left {
} partitioned {
})
2017-01-27T07:59:02.939878Z 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50569S), skipping check
2017-01-27T07:59:32.457007Z 0 [Note] WSREP: view((empty))
2017-01-27T07:59:32.457681Z 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():158
2017-01-27T07:59:32.457715Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2017-01-27T07:59:32.457862Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1404: Failed to open channel 'sportmonks_cluster' at 'gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19': -110 (Connection timed out)
2017-01-27T07:59:32.457898Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2017-01-27T07:59:32.457932Z 0 [ERROR] WSREP: wsrep::connect(gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19) failed: 7
2017-01-27T07:59:32.457944Z 0 [ERROR] Aborting
2017-01-27T07:59:32.457950Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-01-27T07:59:32.457961Z 0 [Note] WSREP: Service disconnected.
2017-01-27T07:59:33.458114Z 0 [Note] WSREP: Some threads may fail to exit.
2017-01-27T07:59:33.462519Z 0 [Note] Binlog end
2017-01-27T07:59:33.462823Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-01-27T07:59:35.989660Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-27T07:59:35.991721Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 15483 ...
2017-01-27T07:59:35.994761Z 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-01-27T07:59:35.994783Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2017-01-27T07:59:35.999273Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <in...@codership.com> loaded successfully.
2017-01-27T07:59:35.999333Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-01-27T07:59:35.999936Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-01-27T07:59:36.001326Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.129.29.245; 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 = PT3S; pc.checksum = false; pc.
2017-01-27T07:59:36.015324Z 0 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-01-27T07:59:36.015914Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-01-27T07:59:36.015946Z 0 [Note] WSREP: wsrep_sst_grab()
2017-01-27T07:59:36.015954Z 0 [Note] WSREP: Start replication
2017-01-27T07:59:36.015981Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-01-27T07:59:36.016121Z 0 [Note] WSREP: protonet asio version 0
2017-01-27T07:59:36.016293Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-01-27T07:59:36.016350Z 0 [Note] WSREP: backend: asio
2017-01-27T07:59:36.016500Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-01-27T07:59:36.016682Z 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-01-27T07:59:36.016699Z 0 [Note] WSREP: restore pc from disk failed
2017-01-27T07:59:36.017344Z 0 [Note] WSREP: GMCast version 0
2017-01-27T07:59:36.017746Z 0 [Note] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-01-27T07:59:36.017764Z 0 [Note] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-01-27T07:59:36.018272Z 0 [Note] WSREP: EVS version 0
2017-01-27T07:59:36.018488Z 0 [Note] WSREP: gcomm: connecting to group 'sportmonks_cluster', peer '10.129.29.245:,10.129.30.11:,10.129.30.15:,10.129.30.19:'
2017-01-27T07:59:36.020970Z 0 [Note] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') connection established to 8b88b1ef tcp://10.129.29.245:4567
2017-01-27T07:59:36.021024Z 0 [Warning] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') address 'tcp://10.129.29.245:4567' points to own listening address, blacklisting
2017-01-27T07:59:39.021231Z 0 [Note] WSREP: (8b88b1ef, 'tcp://0.0.0.0:4567') connection to peer 8b88b1ef with addr tcp://10.129.29.245:4567 timed out, no messages seen in PT3S
2017-01-27T07:59:39.023661Z 0 [Warning] WSREP: no nodes coming from prim view, prim not possible
2017-01-27T07:59:39.023726Z 0 [Note] WSREP: view(view_id(NON_PRIM,8b88b1ef,1) memb {
8b88b1ef,0
} joined {
} left {
} partitioned {
})
2017-01-27T07:59:39.524180Z 0 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50594S), skipping check
2017-01-27T08:00:09.053648Z 0 [Note] WSREP: view((empty))
2017-01-27T08:00:09.054654Z 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():158
2017-01-27T08:00:09.054688Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2017-01-27T08:00:09.054825Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1404: Failed to open channel 'sportmonks_cluster' at 'gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19': -110 (Connection timed out)
2017-01-27T08:00:09.054853Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2017-01-27T08:00:09.054867Z 0 [ERROR] WSREP: wsrep::connect(gcomm://10.129.29.245,10.129.30.11,10.129.30.15,10.129.30.19) failed: 7
2017-01-27T08:00:09.054879Z 0 [ERROR] Aborting
2017-01-27T08:00:09.054885Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-01-27T08:00:09.054894Z 0 [Note] WSREP: Service disconnected.
2017-01-27T08:00:10.055062Z 0 [Note] WSREP: Some threads may fail to exit.
2017-01-27T08:00:10.058985Z 0 [Note] Binlog end
2017-01-27T08:00:10.059143Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2017-01-27T08:00:12.476140Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-27T08:00:12.479335Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17) starting as process 15627 ...
2017-01-27T08:00:12.483418Z 0 [Note] WSREP: Read nil XID from storage engines, skipping position init
2017-01-27T08:00:12.483453Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so'
2017-01-27T08:00:12.489355Z 0 [Note] WSREP: wsrep_load(): Galera 3.20(r7e383f7) by Codership Oy <in...@codership.com> loaded successfully.
2017-01-27T08:00:12.489428Z 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2017-01-27T08:00:12.489941Z 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootsrap: 1
2017-01-27T08:00:12.491807Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.129.29.245; 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 = PT3S; pc.checksum = false; pc.
2017-01-27T08:00:12.514960Z 0 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(00000000-0000-0000-0000-000000000000:-1)
2017-01-27T08:00:12.515522Z 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
2017-01-27T08:00:12.515546Z 0 [Note] WSREP: wsrep_sst_grab()
2017-01-27T08:00:12.515561Z 0 [Note] WSREP: Start replication
2017-01-27T08:00:12.515578Z 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
2017-01-27T08:00:12.515700Z 0 [Note] WSREP: protonet asio version 0
2017-01-27T08:00:12.515855Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2017-01-27T08:00:12.515909Z 0 [Note] WSREP: backend: asio
2017-01-27T08:00:12.516006Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2017-01-27T08:00:12.516135Z 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2017-01-27T08:00:12.516150Z 0 [Note] WSREP: restore pc from disk failed
2017-01-27T08:00:12.516758Z 0 [Note] WSREP: GMCast version 0
2017-01-27T08:00:12.517192Z 0 [Note] WSREP: (a14a1132, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2017-01-27T08:00:12.517222Z 0 [Note] WSREP: (a14a1132, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2017-01-27T08:00:12.517746Z 0 [Note] WSREP: EVS version 0
2017-01-27T08:00:12.517867Z 0 [Note] WSREP: gcomm: bootstrapping new group 'sportmonks_cluster'
2017-01-27T08:00:12.517908Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2017-01-27T08:00:12.518780Z 0 [Note] WSREP: Node a14a1132 state prim
2017-01-27T08:00:12.518922Z 0 [Note] WSREP: view(view_id(PRIM,a14a1132,1) memb {
a14a1132,0
} joined {
} left {
} partitioned {
})
2017-01-27T08:00:12.518942Z 0 [Note] WSREP: save pc into disk
2017-01-27T08:00:12.519168Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.129.29.245:4567
2017-01-27T08:00:12.519186Z 0 [Note] WSREP: discarding pending addr proto entry 0x3c01c50
2017-01-27T08:00:12.519243Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.129.30.11:4567
2017-01-27T08:00:12.519258Z 0 [Note] WSREP: discarding pending addr proto entry 0x3c0a5f0
2017-01-27T08:00:12.519282Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.129.30.15:4567
2017-01-27T08:00:12.519292Z 0 [Note] WSREP: discarding pending addr proto entry 0x3c12f40
2017-01-27T08:00:12.519309Z 0 [Note] WSREP: discarding pending addr without UUID: tcp://10.129.30.19:4567
2017-01-27T08:00:12.519319Z 0 [Note] WSREP: discarding pending addr proto entry 0x3c1b7c0
2017-01-27T08:00:12.519362Z 0 [Note] WSREP: gcomm: connected
2017-01-27T08:00:12.519432Z 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2017-01-27T08:00:12.519490Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2017-01-27T08:00:12.519500Z 0 [Note] WSREP: Opened channel 'sportmonks_cluster'
2017-01-27T08:00:12.519607Z 0 [Note] WSREP: Waiting for SST to complete.
2017-01-27T08:00:12.520650Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2017-01-27T08:00:12.521386Z 0 [Note] WSREP: Starting new group from scratch: a14acd6e-e466-11e6-9048-82933c8a877f
2017-01-27T08:00:12.521861Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: a14add46-e466-11e6-99d6-6b6f50974c0a
2017-01-27T08:00:12.521900Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: a14add46-e466-11e6-99d6-6b6f50974c0a
2017-01-27T08:00:12.521914Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: a14add46-e466-11e6-99d6-6b6f50974c0a from 0 (SportMonks-Galera-001)
2017-01-27T08:00:12.521925Z 0 [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 = a14acd6e-e466-11e6-9048-82933c8a877f
2017-01-27T08:00:12.521933Z 0 [Note] WSREP: Flow-control interval: [16, 16]
2017-01-27T08:00:12.521949Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0)
2017-01-27T08:00:12.521976Z 0 [Note] WSREP: Member 0.0 (SportMonks-Galera-001) synced with group.
2017-01-27T08:00:12.521996Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2017-01-27T08:00:12.522993Z 2 [Note] WSREP: New cluster view: global state: a14acd6e-e466-11e6-9048-82933c8a877f:0, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2017-01-27T08:00:12.523038Z 0 [Note] WSREP: SST complete, seqno: 0
2017-01-27T08:00:12.525105Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-01-27T08:00:12.525169Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-27T08:00:12.525272Z 0 [Note] InnoDB: Uses event mutexes
2017-01-27T08:00:12.525282Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-27T08:00:12.525289Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-27T08:00:12.525296Z 0 [Note] InnoDB: Using Linux native AIO
2017-01-27T08:00:12.525678Z 0 [Note] InnoDB: Number of pools: 1
2017-01-27T08:00:12.525865Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-01-27T08:00:12.528018Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-01-27T08:00:12.541422Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-01-27T08:00:12.547001Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-01-27T08:00:12.564355Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-27T08:00:12.581556Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-01-27T08:00:12.581678Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-01-27T08:00:12.640461Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-01-27T08:00:12.641497Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-01-27T08:00:12.641519Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-01-27T08:00:12.643585Z 0 [Note] InnoDB: Waiting for purge to start
2017-01-27T08:00:12.693923Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 1354338
2017-01-27T08:00:12.696046Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-01-27T08:00:12.700725Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-01-27T08:00:12.701058Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170127 8:00:12
2017-01-27T08:00:12.743058Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-01-27T08:00:12.750810Z 0 [Warning] CA certificate ca.pem is self signed.
2017-01-27T08:00:12.753415Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2017-01-27T08:00:12.753464Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0';
2017-01-27T08:00:12.753520Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2017-01-27T08:00:12.783569Z 0 [Note] Event Scheduler: Loaded 0 events
2017-01-27T08:00:12.784886Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-01-27T08:00:12.784910Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-01-27T08:00:12.786320Z 2 [Note] WSREP: Initialized wsrep sidno 2
2017-01-27T08:00:12.786417Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-01-27T08:00:12.786491Z 2 [Note] WSREP: REPL Protocols: 7 (3, 2)
2017-01-27T08:00:12.786522Z 2 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3
2017-01-27T08:00:12.786579Z 0 [Note] WSREP: Service thread queue flushed.
2017-01-27T08:00:12.786848Z 2 [Note] WSREP: GCache history reset: old(00000000-0000-0000-0000-000000000000:0) -> new(a14acd6e-e466-11e6-9048-82933c8a877f:0)
2017-01-27T08:00:12.787691Z 2 [Note] WSREP: Synchronized with group, ready for connections
2017-01-27T08:00:12.787712Z 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2017-01-27T08:00:12.845600Z 0 [Note] End of list of non-natively partitioned tables
2017-01-27T08:00:12.845799Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Wsrep Server (GPL), wsrep_25.11
2017-01-27T08:00:13.889585Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
On Thursday, January 26, 2017 at 10:45:23 PM UTC+1, Ronnie Visser wrote:
Philip Stoev
Jan 27, 2017, 3:49:11 AM1/27/17
to Ronnie Visser, codersh...@googlegroups.com
The end of the log
2017-01-27T08:00:12.845799Z 0 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '5.7.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL
Wsrep Server (GPL), wsrep_25.11
2017-01-27T08:00:13.889585Z 5 [Note] Access denied for user
'root'@'localhost' (using password: NO)
indicates that mysqld is now running .
-----Original Message-----
From: Ronnie Visser
Sent: Friday, January 27, 2017 10:45
To: codership
Subject: [codership-team] Re: Install guide for Galera for mysql 5.7
2017-01-27T08:00:12.845799Z 0 [Note] /usr/sbin/mysqld: ready for
connections.
Version: '5.7.17' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL
Wsrep Server (GPL), wsrep_25.11
2017-01-27T08:00:13.889585Z 5 [Note] Access denied for user
'root'@'localhost' (using password: NO)
-----Original Message-----
From: Ronnie Visser
Sent: Friday, January 27, 2017 10:45
To: codership
Subject: [codership-team] Re: Install guide for Galera for mysql 5.7
Jörg Brühe
Jan 27, 2017, 4:31:19 AM1/27/17
to codersh...@googlegroups.com
Hi Ronnie, all!
On 27.01.2017 09:15, Ronnie Visser wrote:
> Hi,
>
MySQL-wsrep 5.7 is prepared to work with systemd, whereas 5.6 was not.
This is an important difference, it makes the 5.6 instructions
inappropriate for 5.7.
>
> when running /usr/bin/mysqld_bootstrap the following output is given:
>
> /usr/bin/mysqld_bootstrap
> Failed to set environment: Access denied
> ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
> Authentication is required to start 'mysql.service'.
> Authenticating as: SportMonks,,, (sportmonk)
> Password:
> ==== AUTHENTICATION COMPLETE ===
> Failed to set environment: Access denied
TTBOMK, you need root privileges for this: Use "sudo" when calling it.
Further down, the log you quote has many messages "Failed password for
root ...". Make sure "sudo" works correct, for this run "sudo id" and
verify the answer starts with the text "uid=0(root)".
>
> [[...]]
HTH,
Jörg
--
Joerg Bruehe, Senior MySQL Support Engineer, joerg....@fromdual.com
FromDual GmbH, Rebenweg 6, CH - 8610 Uster; phone +41 44 500 58 26
Geschäftsführer: Oliver Sennhauser
Handelsregister-Eintrag: CH-020.4.044.539-3
On 27.01.2017 09:15, Ronnie Visser wrote:
> Hi,
>
> I followed the tutorials for installing with 5.6 here:
> https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04
> . everything where 5.6 is meantion i have changed it to 5.7
From your further quotes, your platform is using systemd.
> https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mysql-5-6-on-ubuntu-16-04
> . everything where 5.6 is meantion i have changed it to 5.7
MySQL-wsrep 5.7 is prepared to work with systemd, whereas 5.6 was not.
This is an important difference, it makes the 5.6 instructions
inappropriate for 5.7.
>
> when running /usr/bin/mysqld_bootstrap the following output is given:
>
> /usr/bin/mysqld_bootstrap
> Failed to set environment: Access denied
> ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
> Authentication is required to start 'mysql.service'.
> Authenticating as: SportMonks,,, (sportmonk)
> Password:
> ==== AUTHENTICATION COMPLETE ===
> Failed to set environment: Access denied
Further down, the log you quote has many messages "Failed password for
root ...". Make sure "sudo" works correct, for this run "sudo id" and
verify the answer starts with the text "uid=0(root)".
>
> [[...]]
HTH,
Jörg
--
Joerg Bruehe, Senior MySQL Support Engineer, joerg....@fromdual.com
FromDual GmbH, Rebenweg 6, CH - 8610 Uster; phone +41 44 500 58 26
Geschäftsführer: Oliver Sennhauser
Handelsregister-Eintrag: CH-020.4.044.539-3
Reply all
Reply to author
Forward
0 new messages