| mysql error during deployment [message #124526] |
Mon, 28 September 2015 17:16  |
markus.k1985
Messages: 11
Registered: September 2015
|
|
|
|
PM and first Backend logs during puppet agent -t:
err: /Stage[main]/Mysql::Server::Service/Service[mysqld]/ensure: change from stopped to running failed: Could not start Service[mysqld]: Execution of '/etc/init.d/mysql start' returned 1: at /etc/puppet/modules/mysql/manifests/server/service.pp:23
err: Could not prefetch mysql_user provider 'mysql': Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf -NBe SELECT CONCAT(User, '<_at_>',Host) AS User FROM mysql.user' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")
mysql dubug on first backend:
Sep 28 15:10:09 shs-mail-be-01 mysqld: vo = false; pc.recovery
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: Service thread queue flushed.
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: wsrep_sst_grab()
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: Start replication
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: protonet asio version 0
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: Using CRC-32C for message checksums.
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: backend: asio
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Warning] WSREP: access file(gvwstate.dat) failed(No such file or directory)
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: restore pc from disk failed
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: GMCast version 0
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: (020e7d68, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: (020e7d68, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: EVS version 0
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Note] WSREP: gcomm: connecting to group 'my_wsrep_cluster', peer '172.18.3.66:,172.18.3.68:'
Sep 28 15:10:09 shs-mail-be-01 mysqld: 150928 15:10:09 [Warning] WSREP: (020e7d68, 'tcp://0.0.0.0:4567') address 'tcp://172.18.3.68:4567' points to own listening address, blacklisting
Sep 28 15:10:12 shs-mail-be-01 mysqld: 150928 15:10:12 [Warning] WSREP: no nodes coming from prim view, prim not possible
Sep 28 15:10:12 shs-mail-be-01 mysqld: 150928 15:10:12 [Note] WSREP: view(view_id(NON_PRIM,020e7d68,1) memb {
Sep 28 15:10:12 shs-mail-be-01 mysqld: #011020e7d68,0
Sep 28 15:10:12 shs-mail-be-01 mysqld: } joined {
Sep 28 15:10:12 shs-mail-be-01 mysqld: } left {
Sep 28 15:10:12 shs-mail-be-01 mysqld: } partitioned {
Sep 28 15:10:12 shs-mail-be-01 mysqld: })
Sep 28 15:10:12 shs-mail-be-01 mysqld: 150928 15:10:12 [Warning] WSREP: last inactive check more than PT1.5S ago (PT3.50195S), skipping check
Sep 28 15:10:42 shs-mail-be-01 mysqld: 150928 15:10:42 [Note] WSREP: view((empty))
Sep 28 15:10:42 shs-mail-be-01 mysqld: 150928 15:10:42 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view: 110 (Connection timed out)
Sep 28 15:10:42 shs-mail-be-01 mysqld: #011 at gcomm/src/pc.cpp:connect():161
Sep 28 15:10:42 shs-mail-be-01 mysqld: 150928 15:10:42 [ERROR] WSREP: gcs/src/gcs_core.cpp:long int gcs_core_open(gcs_core_t*, const char*, const char*, bool)():206: Failed to open backend connection: -110 (Connection timed out)
Sep 28 15:10:42 shs-mail-be-01 mysqld: 150928 15:10:42 [ERROR] WSREP: gcs/src/gcs.cpp:long int gcs_open(gcs_conn_t*, const char*, const char*, bool)():1379: Failed to open channel 'my_wsrep_cluster' at 'gcomm://172.18.3.66,172.18.3.68': -110 (Connection timed out)
Sep 28 15:10:42 shs-mail-be-01 mysqld: 150928 15:10:42 [ERROR] WSREP: gcs connect failed: Connection timed out
Sep 28 15:10:42 shs-mail-be-01 mysqld: 150928 15:10:42 [ERROR] WSREP: wsrep::connect() failed: 7
Sep 28 15:10:42 shs-mail-be-01 mysqld: 150928 15:10:42 [ERROR] Aborting
Sep 28 15:10:42 shs-mail-be-01 mysqld:
Sep 28 15:10:42 shs-mail-be-01 mysqld: 150928 15:10:42 [Note] WSREP: Service disconnected.
Sep 28 15:10:43 shs-mail-be-01 mysqld: 150928 15:10:43 [Note] WSREP: Some threads may fail to exit.
Sep 28 15:10:43 shs-mail-be-01 mysqld: 150928 15:10:43 [Note] /usr/sbin/mysqld: Shutdown complete
Sep 28 15:10:43 shs-mail-be-01 mysqld:
Sep 28 15:10:43 shs-mail-be-01 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
|
|
|
|
|
|
|
|
Members
Search
Help
Register
Login
Home
