An existing connection was forcibly closed by the remote host

Hello. I have 3-nodes multi-master cluster in different datacenters: Frankfurt, Amsterdam, New York. Also there are 3 photon server instances in each location. They connect to the database through Entity Framework v 6.2. Every server instance send queries to the nearest node (NY to NY; FR to FR; AMS to AMS). So there are no issues with Frankfurt and Amsterdam photon instances but sometimes(every second/third day) on New York instance I have an exception:
An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server.
See the inner exception and for more information.
—> MySql.Data.MySqlClient.MySqlException: Fatal error encountered during command execution.
—> MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset.
—> MySql.Data.MySqlClient.MySqlException: Reading from the stream has failed.
—> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
—> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host.
There are no differences in those photon server instances. Most of the users are connecting to New York photon server so the NY node in cluster so it is the most loaded node. Maybe there are wrong settings for my node? The average online of users is ±1000. My NY node general insides are:

CPU(s): 2
Model name: Intel® Xeon® CPU E5-2630L 0 @ 2.00GHz

Percona cluster settings:

wsrep_provider_options=base_dir = /var/lib/mysql/; base_host = <HOST_IP>; base_port =<BASE_PORT>; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 4; evs.version = 0; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.freeze_purge_at_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; gcs.fc_master_slave = no; gcs.max_packet_size = 6

So the question is: could it be some bugs in Entity Framework / network issues or my settings are wrong for the use case? Thanks.

Hi, seri52, thanks for your question.

Could you post a few more details:
[]versions of Percona XtraDB Cluster
]version of OS
[]if there are any error logs, could you post those, please
]the my.conf for each node of the cluster
[*]any other information that you think might be relevant
[/LIST] Thanks!

Thanks for reply! I’ve solved this problem long time ago :smiley:
Just forgot about my question on forum, sorry!