MySQL Forums
Forum List  »  Utilities

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)
2094
March 09, 2016 08:33AM


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.