Anyone seeing big difference in Snowflake proxy utilization after upgrade to 2.10.1?

I saw this post:

It claims that Snowflake proxy usage went to the moon after an upgrade from 2.9.2 to 2.10.x. However, I personally do not see a commit that could explain such a huge difference. Here is comparison of the 2 versions. Apart from a bunch of dependency updates, I singled out these commits:

But IMO none of them should be that impactful.

So, the question is: does anyone else see huge differences in traffic / utilization after the upgrade from 2.9.2 to 2.10.x?

Are your proxies by any chance now “Unrestricted NAT” and before they were recognized as “Restricted” ?

Here the update(s) of Snowflake proxies don’t show any breaking changes in the metrics.

3 Likes

I do not see changes that should affect NAT checking on the proxy side. Also I would expect the traffic difference to be much higher (though let’s keep in mind that they posted aggregate metrics for several proxies).

Hi,

I’m from Unredacted.

I don’t recall seeing this in the logs, and I believe they were unrestricted before. None of our snowflake proxies are running behind NAT, and they’re all on dedicated IPs.

2 Likes

Not much data collected yet and difference is not huge, but I see it:

$ grep "completed\|starting" /d/snowflake/log.txt | tail -49
2024/11/14 19:54:19 In the last 1h0m0s, there were 61 completed connections. Traffic Relayed ↓ 1047545 KB, ↑ 166131 KB.
2024/11/14 20:54:19 In the last 1h0m0s, there were 45 completed connections. Traffic Relayed ↓ 1974041 KB, ↑ 344890 KB.
2024/11/14 21:54:19 In the last 1h0m0s, there were 35 completed connections. Traffic Relayed ↓ 1656270 KB, ↑ 125317 KB.
2024/11/14 22:54:19 In the last 1h0m0s, there were 19 completed connections. Traffic Relayed ↓ 897964 KB, ↑ 98472 KB.
2024/11/14 23:54:19 In the last 1h0m0s, there were 41 completed connections. Traffic Relayed ↓ 439852 KB, ↑ 52340 KB.
2024/11/15 00:54:19 In the last 1h0m0s, there were 39 completed connections. Traffic Relayed ↓ 755063 KB, ↑ 55532 KB.
2024/11/15 01:54:19 In the last 1h0m0s, there were 34 completed connections. Traffic Relayed ↓ 999981 KB, ↑ 87807 KB.
2024/11/15 02:54:19 In the last 1h0m0s, there were 33 completed connections. Traffic Relayed ↓ 695931 KB, ↑ 47144 KB.
2024/11/15 03:54:19 In the last 1h0m0s, there were 26 completed connections. Traffic Relayed ↓ 799956 KB, ↑ 50434 KB.
2024/11/15 04:54:19 In the last 1h0m0s, there were 52 completed connections. Traffic Relayed ↓ 971213 KB, ↑ 70468 KB.
2024/11/15 05:54:19 In the last 1h0m0s, there were 55 completed connections. Traffic Relayed ↓ 473815 KB, ↑ 56776 KB.
2024/11/15 06:54:19 In the last 1h0m0s, there were 46 completed connections. Traffic Relayed ↓ 659812 KB, ↑ 91565 KB.
2024/11/15 07:54:19 In the last 1h0m0s, there were 39 completed connections. Traffic Relayed ↓ 1616590 KB, ↑ 108245 KB.
2024/11/15 08:54:19 In the last 1h0m0s, there were 27 completed connections. Traffic Relayed ↓ 780198 KB, ↑ 106271 KB.
2024/11/15 09:54:19 In the last 1h0m0s, there were 44 completed connections. Traffic Relayed ↓ 541960 KB, ↑ 95502 KB.
2024/11/15 10:54:19 In the last 1h0m0s, there were 61 completed connections. Traffic Relayed ↓ 578765 KB, ↑ 59398 KB.
2024/11/15 11:54:19 In the last 1h0m0s, there were 55 completed connections. Traffic Relayed ↓ 712707 KB, ↑ 75116 KB.
2024/11/15 12:54:19 In the last 1h0m0s, there were 46 completed connections. Traffic Relayed ↓ 749133 KB, ↑ 177799 KB.
2024/11/15 13:54:19 In the last 1h0m0s, there were 39 completed connections. Traffic Relayed ↓ 1003583 KB, ↑ 127254 KB.
2024/11/15 14:54:19 In the last 1h0m0s, there were 45 completed connections. Traffic Relayed ↓ 506639 KB, ↑ 59460 KB.
2024/11/15 15:54:19 In the last 1h0m0s, there were 53 completed connections. Traffic Relayed ↓ 1548249 KB, ↑ 136643 KB.
2024/11/15 16:54:19 In the last 1h0m0s, there were 65 completed connections. Traffic Relayed ↓ 1838542 KB, ↑ 165871 KB.
2024/11/15 17:54:19 In the last 1h0m0s, there were 45 completed connections. Traffic Relayed ↓ 1438460 KB, ↑ 179130 KB.
2024/11/15 18:54:19 In the last 1h0m0s, there were 55 completed connections. Traffic Relayed ↓ 1677574 KB, ↑ 168384 KB.
2024/11/15 19:54:19 In the last 1h0m0s, there were 67 completed connections. Traffic Relayed ↓ 1303920 KB, ↑ 185785 KB.
2024/11/15 20:54:19 In the last 1h0m0s, there were 46 completed connections. Traffic Relayed ↓ 1318863 KB, ↑ 137266 KB.
2024/11/15 21:54:19 In the last 1h0m0s, there were 61 completed connections. Traffic Relayed ↓ 976954 KB, ↑ 105706 KB.
2024/11/15 22:54:19 In the last 1h0m0s, there were 49 completed connections. Traffic Relayed ↓ 1400569 KB, ↑ 131866 KB.
2024/11/15 23:54:19 In the last 1h0m0s, there were 45 completed connections. Traffic Relayed ↓ 1481322 KB, ↑ 98709 KB.
2024/11/16 00:54:19 In the last 1h0m0s, there were 28 completed connections. Traffic Relayed ↓ 606246 KB, ↑ 47642 KB.
2024/11/16 01:54:19 In the last 1h0m0s, there were 13 completed connections. Traffic Relayed ↓ 22339 KB, ↑ 7261 KB.
2024/11/16 02:54:19 In the last 1h0m0s, there were 22 completed connections. Traffic Relayed ↓ 574203 KB, ↑ 60168 KB.
2024/11/16 03:54:19 In the last 1h0m0s, there were 27 completed connections. Traffic Relayed ↓ 691077 KB, ↑ 64850 KB.
2024/11/16 04:54:19 In the last 1h0m0s, there were 26 completed connections. Traffic Relayed ↓ 838664 KB, ↑ 79757 KB.
2024/11/16 05:54:19 In the last 1h0m0s, there were 38 completed connections. Traffic Relayed ↓ 1092028 KB, ↑ 102901 KB.
2024/11/16 06:54:19 In the last 1h0m0s, there were 63 completed connections. Traffic Relayed ↓ 2907563 KB, ↑ 216042 KB.
2024/11/16 07:54:19 In the last 1h0m0s, there were 49 completed connections. Traffic Relayed ↓ 731014 KB, ↑ 97379 KB.
2024/11/16 08:54:19 In the last 1h0m0s, there were 62 completed connections. Traffic Relayed ↓ 1384940 KB, ↑ 125384 KB.
2024/11/16 09:54:19 In the last 1h0m0s, there were 61 completed connections. Traffic Relayed ↓ 758305 KB, ↑ 79709 KB.
2024/11/16 10:54:19 In the last 1h0m0s, there were 51 completed connections. Traffic Relayed ↓ 668823 KB, ↑ 99071 KB.
2024/11/16 11:54:19 In the last 1h0m0s, there were 52 completed connections. Traffic Relayed ↓ 1160182 KB, ↑ 169377 KB.
2024/11/16 12:42:54 Proxy starting
2024/11/16 13:42:54 In the last 1h0m0s, there were 48 completed connections. Traffic Relayed ↓ 546363 KB (151.77 KB/s), ↑ 69781 KB (19.38 KB/s).
2024/11/16 14:42:54 In the last 1h0m0s, there were 57 completed connections. Traffic Relayed ↓ 1392034 KB (386.68 KB/s), ↑ 139644 KB (38.79 KB/s).
2024/11/16 15:42:54 In the last 1h0m0s, there were 74 completed connections. Traffic Relayed ↓ 1654149 KB (459.49 KB/s), ↑ 133668 KB (37.13 KB/s).
2024/11/16 16:42:54 In the last 1h0m0s, there were 58 completed connections. Traffic Relayed ↓ 2355710 KB (654.36 KB/s), ↑ 191297 KB (53.14 KB/s).
2024/11/16 17:42:54 In the last 1h0m0s, there were 59 completed connections. Traffic Relayed ↓ 1938685 KB (538.52 KB/s), ↑ 193443 KB (53.73 KB/s).
2024/11/16 18:42:54 In the last 1h0m0s, there were 60 completed connections. Traffic Relayed ↓ 2138684 KB (594.08 KB/s), ↑ 177815 KB (49.39 KB/s).
2024/11/16 19:42:54 In the last 1h0m0s, there were 51 completed connections. Traffic Relayed ↓ 2086345 KB (579.54 KB/s), ↑ 175947 KB (48.87 KB/s).
1 Like

Just a snapshot, I recently checked how many concurrent clients my proxy was serving, it was about 20, now it’s about 30.

1 Like

Well, probably off-topic, but I do have dedicated cloud instances, were NAT detection failed for some (local?) reasons:

As they said in Unredacted: "@WofWca No worries, not annoying at all. Haven't…" - Mastodon, this commit is probably also ruled out as a possible cause.

Possible, but with the behavior outlined in the issue, I’d expect an opposite effect: reduced load after a restart.

For my info, how do you check concurrent clients?

In verbose logging my proxy shows a counter that increases when a client connects and decreases when a client disconnects.

Is this standard or some mode you made? It’s not that 1 hour message then.

Here is updated data from my proxy (collected from lines In the last 1h0m0s...).
For me it looks like user count is the same, traffic is slightly higher.
Connections:
snowflake_update_conns
Traffic:
snowflake_update_traff

1 Like

I don’t put much faith in the completed connections count of “In the last” message. I use to think it was a client count.

It just states how many connections closed in the last hour. That connection could have opened in the last minute, last hour, last day or, in theory, the last week or last month.

1 Like