Inactive connections with 510 second duration
After commit 1bc54948 (!108 (merged)), I started to notice lots of connections in logs with similar duration (510s-512s), which were closed due to inactivity.
I see several possible reasons for such behaviour:
- All such connections come from non-standard clients.
- Timeout value from !108 (merged) is too small.
- Lots of connections broke because of high rate of UDP losses in my network.
$ grep -c "over 51[012]" log_crop2.txt && grep -c "Traffic throughput" log_crop2.txt
52
459
If connections are closed because of problems with my network (3), then, most likely, nothing should be done from snowflake side.
If this is a sign of attack or other bot activity (1), then it may need further investigation.
And, most importantly, if all of them are legit and my network is good enough for snowflake (2), it means losing >11% of user connections just because of bug, which I think is not acceptable.
$ grep "over 51[012]" log_crop2.txt | tail -20
2022/10/20 09:20:16 Traffic throughput (up|down): 1 MB|45 KB -- (209 OnMessages, 2641 Sends, over 510 seconds)
2022/10/20 09:49:23 Traffic throughput (up|down): 7 MB|367 KB -- (750 OnMessages, 6452 Sends, over 510 seconds)
2022/10/20 10:18:56 Traffic throughput (up|down): 184 KB|12 KB -- (53 OnMessages, 1236 Sends, over 510 seconds)
2022/10/20 11:05:02 Traffic throughput (up|down): 1 MB|26 KB -- (193 OnMessages, 1156 Sends, over 510 seconds)
2022/10/20 11:11:46 Traffic throughput (up|down): 51 KB|16 KB -- (93 OnMessages, 853 Sends, over 510 seconds)
2022/10/20 11:52:27 Traffic throughput (up|down): 11 MB|180 KB -- (428 OnMessages, 11799 Sends, over 510 seconds)
2022/10/20 12:16:46 Traffic throughput (up|down): 48 KB|13 KB -- (169 OnMessages, 334 Sends, over 510 seconds)
2022/10/20 12:30:28 Traffic throughput (up|down): 3 MB|353 KB -- (1053 OnMessages, 4517 Sends, over 510 seconds)
2022/10/20 12:31:58 Traffic throughput (up|down): 4 MB|47 KB -- (500 OnMessages, 3478 Sends, over 511 seconds)
2022/10/20 12:39:16 Traffic throughput (up|down): 27 KB|28 KB -- (58 OnMessages, 297 Sends, over 510 seconds)
2022/10/20 12:56:22 Traffic throughput (up|down): 1 MB|12 KB -- (72 OnMessages, 1206 Sends, over 510 seconds)
2022/10/20 13:16:58 Traffic throughput (up|down): 29 KB|5 KB -- (28 OnMessages, 224 Sends, over 510 seconds)
2022/10/20 13:29:10 Traffic throughput (up|down): 159 KB|4 KB -- (17 OnMessages, 1997 Sends, over 510 seconds)
2022/10/20 13:30:19 Traffic throughput (up|down): 244 KB|199 KB -- (444 OnMessages, 1257 Sends, over 510 seconds)
2022/10/20 13:52:30 Traffic throughput (up|down): 259 KB|77 KB -- (236 OnMessages, 1230 Sends, over 510 seconds)
2022/10/20 13:58:37 Traffic throughput (up|down): 33 KB|7 KB -- (39 OnMessages, 760 Sends, over 511 seconds)
2022/10/20 14:00:25 Traffic throughput (up|down): 23 KB|15 KB -- (89 OnMessages, 398 Sends, over 510 seconds)
2022/10/20 14:51:09 Traffic throughput (up|down): 102 KB|30 KB -- (344 OnMessages, 538 Sends, over 511 seconds)
2022/10/20 15:06:10 Traffic throughput (up|down): 132 KB|31 KB -- (87 OnMessages, 305 Sends, over 510 seconds)
2022/10/20 15:10:26 Traffic throughput (up|down): 161 KB|111 KB -- (194 OnMessages, 1157 Sends, over 510 seconds)