Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Connect Multi-Server » mysql error during deployment
  •  
markus.k1985

Messages: 11
Karma: 0
Send a private message to this user
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
  •  
markus.k1985

Messages: 11
Karma: 0
Send a private message to this user
  •  
Bud Durland

Messages: 390
Karma: 43
Send a private message to this user
Previous Topic: Clarification of connectivity
Next Topic: Sharing experiences for a proper hosted installation
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Fri Sep 22 13:47:04 CEST 2017

Total time taken to generate the page: 0.00371 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.