I’m receiving only these messages and no calls connecting, it worked for years but after a server restart it’s not working anymore, can you please help me to fix as soon as possible? I’m getting mad trying to figure out what is happening, thank you a lot!
Also I receive
[5795/yeti:db/PgConnectionPool.cpp:190] WARNING: : timeout waiting for an active connection (waited 125ms)
Apr 07 12:17:35 Debian-bullseye-latest-amd64-base sems[5786]: [5795/yeti:SqlRouter.cpp:409] ERROR: SQL cant get profiles. Drop request
i’ve tried to increase connection pool to routing db but it’s not working, I don’t receive any warning about sql router but routing delay increase up to 30 seconds
You have no enough connections to serve routing requests. It may be caused by low connections throughput(in req/s), caused by network issues or slow query processing.
routing db is local because it’s the slave of the master on a remote node, and always used 4 connections to local slave of routing db. I’m working on it but I can’t solve the issue, I see very high latency on routing delay column, how can I troubleshoot and fix this problem? Routing delay on the image for first routing attempt. Thanks
