Shulou(Shulou.com)05/31 Report--

Synchronization failure 8810 deny connection from how to do, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Discovery method xxx.xxx.254.45, does not synchronously pull the data to other points, view the synchronous log, and always show the status of being rejected by other nodes. The refusal indicates that the permission has not been passed.

May 17 13:22:10 warning db_sync_short_video_oss_r2m0_d []: [tid:137732] [SocketServer::OnAccept] deny connection from: xxx.xxx.125.2:53316May 17 13:22:20 warning db_sync_short_video_oss_r2m0_d []: [tid:137739] [SocketServer::OnAccept] deny connection from: xxx.xxx.125.2:53318May 17 13:22:31 warning db_sync_short_video_oss_r2m0_d [ ]: [tid:137746] [SocketServer::OnAccept] deny connection from: xxx.xxx.125.2:53320May 17 13:22:41 warning db_sync_short_video_oss_r2m0_d []: [tid:137752] [SocketServer::OnAccept] deny connection from: xxx.xxx.125.2:53322

The target machine has already opened the firewall and whitelist. On the xxx.xxx.125.2 machine, using netstat has seen the establishment of a connection, indicating that the firewall has opened the port.

Tcp 0 0 xxx.xxx.125.2:12505 xxx.xxx.254.45:41734 ESTABLISHED 48767/./db_sync_sho

Restart 4455 of xxx.xxx.254.45 and see an error

May 17 13:36:43 info shardadmin_short_video_oss_20_d [138429]: HAVE_EPOLLMay 17 13:36:43 debug shardadmin_short_video_oss_20_d [138429]: output queue okMay 17 13:36:43 debug shardadmin_short_video_oss_20_d [138429]: output queue okMay 17 13:36:43 err shardadmin_short_video_oss_20_d [138429]: Connect to db failed: [admin | SXobJfaXm4 | xxx.xxx.254.45 | 8810] Lost connection to MySQL server at 'reading initial communication packet' System error: 0May 17 13:36:43 info shardadmin_short_video_oss_20_d [138429]: create listen port 4455 successMay 17 13:36:43 info shardadmin_short_video_oss_20_d [138429]: server start, epoll_prt=0x1335000May 17 13:36:53 notice shardadmin_short_video_oss_20_d [138429]: request:0 proc:0 droped:0 active:0May 17 13:37:03 notice shardadmin_short_video_oss_20_d [138429]: request:0 proc:0 droped:0 active:0

It is normal to connect less than 8810 DB, because synchronization has not been turned on. If you do not start shard8821 to 8827, starting myshardmin will report the following error

May 17 14:27:31 info shardadmin_short_video_oss_20_d [141736]: HAVE_EPOLLMay 17 14:27:31 debug shardadmin_short_video_oss_20_d [141736]: output queue okMay 17 14:27:31 debug shardadmin_short_video_oss_20_d [141736]: output queue okMay 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 45.124.254.45 | 8810] Lost connection to MySQL server at 'reading initial communication packet' System error: 111May 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 127.0.0.1 | | 8810] Lost connection to MySQL server at 'reading initial communication packet', system error: 111May 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 127.0.0.1 | | 8821] Lost connection to MySQL server at' reading initial communication packet' System error: 111May 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 127.0.0.1 | | 8822] Lost connection to MySQL server at 'reading initial communication packet', system error: 111May 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 127.0.0.1 | | 8823] Lost connection to MySQL server at' reading initial communication packet' System error: 111May 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 127.0.0.1 | | 8824] Lost connection to MySQL server at 'reading initial communication packet', system error: 111May 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 127.0.0.1 | | 8825] Lost connection to MySQL server at' reading initial communication packet' System error: 111May 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 127.0.0.1 | | 8826] Lost connection to MySQL server at 'reading initial communication packet', system error: 111May 17 14:27:31 err shardadmin_short_video_oss_20_d [141736]: Connect to db failed: [admin | SXobJfaXm4 | 127.0.0.1 | | 8827] Lost connection to MySQL server at' reading initial communication packet' System error: 111May 17 14:27:31 warning shardadmin_short_video_oss_20_d [141736]: connect sync_server 45.124.254.45:12505 failed, [ShardAdminConfig2.cpp#81] May 17 14:27:31 info shardadmin_short_video_oss_20_d [141736]: create listen port 4455 successMay 17 14:27:31 info shardadmin_short_video_oss_20_d [141736]: server start, epoll_prt=0x119b000

It connects the proxy of 8821-8827 as a db, because it is really possible that different ports correspond to different DB

Later, the management port of 4455 could not log in, and there was no permission to report an error.

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0May 17 14:12:01 warning shardadmin_short_video_oss_20_d [139578]: deny connection from: 127.0.0.1

There's no way to connect.

[root@localhost bin] # mysql-H0-umyshard-pmyshard-P4455ERROR 2013 (HY000): Lost connection to MySQL server at'reading initial communication packet', system error: 0 [root@localhost bin] # mysql-h227.0.0.1-umyshard-pmyshard-P4455ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 [root@localhost bin] # mysql-h227.0.0.1-uadmin-padmin-P4455ERROR 2013 (HY000): Lost connection to MySQL server at' reading initial communication packet' System error: 0 [root@localhost bin] # mysql-h227.0.0.1-uadmin-pSXobJfaXm4-P4455ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

And it has something to do with the whitelist.

Mysql > select * from myshard_redip_list +-+ | busi_name | machine_room_no | ip | +- -+ | short_video_oss | 2 | xxx.xxx.252.45 | +-+

I found that the whitelist was not added, so I changed it to my own IP. After restarting shardadmin again, I was able to log in smoothly.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.