MySQL Forums :: Utilities :: Aborted Connection user Fabric_server (Got error reading communication packets)


Advanced Search

Aborted Connection user Fabric_server (Got error reading communication packets)
Posted by: Jirka Wendekamm ()
Date: March 09, 2016 08:33AM

tryout first time fabric and run into some errors.

OS: centOS7
DB: mysql Enterprise 5.7.11

2 Servers (master / Slave)

tryout follow instuction in 5.7 reference manuel to configure server and fabric.

initialize and active fabric configuration seems look good.

<console>
#> mysqlfabric group health jh_group
Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

uuid is_alive status is_not_running is_not_configured io_not_running sql_not_running io_error sql_error
------------------------------------ -------- --------- -------------- ----------------- -------------- --------------- -------- ---------
1369caa7-e5f5-11e5-b047-005056b9756c 1 SECONDARY 0 0 0 0 False False
6386296e-e5f5-11e5-b557-005056b91b9a 1 PRIMARY 0 0 0 0 False False

issue
-----
<end>


if a run "activate command"

<console>
# mysqlfabric group activate jh_group
Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

uuid finished success result
------------------------------------ -------- ------- ------
bf2fc991-d30a-4bc1-a0b7-cfba6a6a03cc 1 1 1

state success when description
----- ------- ------------- -------------------------------------------------------------
3 2 1457530630.58 Triggered by <mysql.fabric.events.Event object at 0x2dda710>.
4 2 1457530630.58 Executing action (_activate_group).
5 2 1457530630.59 Executed action (_activate_group).

<end>

But error log from servers was spammed ever second with error:

2016-03-09T14:25:09.279475Z 541 [Note] Aborted connection 541 to db: 'unconnected' user: 'fabric_server' host: 'fabric-master1' (Got an error reading communication packets)

Show processlist on the same server show one connection.

mysql> show processlist;
+-----+---------------+---------------------+------+---------+------+----------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+---------------+---------------------+------+---------+------+----------+------------------+
| 48 | fabric_server | fabric-master1:44627 | NULL | Sleep | 919 | | NULL |
| 571 | root | localhost | NULL | Query | 0 | starting | show processlist |
+-----+---------------+---------------------+------+---------+------+----------+------------------+
2 rows in set (0.00 sec)

i tryout failover test by stopping active master node


<fabric log>
[INFO] 1457532434.311552 - Executor-4 - Monitoring group (jh_group).
[WARNING] 1457532516.768410 - FailureDetector(jh_group) - Server (6386296e-e5f5-11e5-b557-005056b91b9a) in group (jh_group) is unreachable.
[WARNING] 1457532518.776335 - FailureDetector(jh_group) - Server (6386296e-e5f5-11e5-b557-005056b91b9a) in group (jh_group) is unreachable.
[WARNING] 1457532520.785540 - FailureDetector(jh_group) - Server (6386296e-e5f5-11e5-b557-005056b91b9a) in group (jh_group) is unreachable.
[WARNING] 1457532520.821894 - Executor-1 - Reported issue (FAULTY) for server (6386296e-e5f5-11e5-b557-005056b91b9a).
[INFO] 1457532520.824412 - Executor-1 - Master (6386296e-e5f5-11e5-b557-005056b91b9a) in group (jh_group) has been lost.
[INFO] 1457532521.003064 - Executor-1 - Master has changed from 6386296e-e5f5-11e5-b557-005056b91b9a to 1369caa7-e5f5-11e5-b047-005056b9756c.
<end>

But after restarting old master node status sill "Faulty"

<fabric-master1>
# mysqlfabric group health jh_group
Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

uuid is_alive status is_not_running is_not_configured io_not_running sql_not_running io_error sql_error
------------------------------------ -------- ------- -------------- ----------------- -------------- --------------- -------- ---------
1369caa7-e5f5-11e5-b047-005056b9756c 1 PRIMARY 0 0 0 0 False False
6386296e-e5f5-11e5-b557-005056b91b9a 1 FAULTY 0 1 0 0 False False

issue
-----

<end>

Any ways to get Node back to healthy? Any hints for my aborted connection ?

Options: ReplyQuote


Subject Views Written By Posted
Aborted Connection user Fabric_server (Got error reading communication packets) 1803 Jirka Wendekamm 03/09/2016 08:33AM
Re: Aborted Connection user Fabric_server (Got error reading communication packets) 515 Antonio Di Motta 05/24/2016 06:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.