Timeout problem with anope services that connect for a certain amount of time

[JorgeMostiga]

Good morning, I have this problem that never happens, I run the services with the --support option but there is nothing in it, not in the logs (/log/services.log.**). The services are connected well and are configured to use an external MySQL server as we discussed in this link: Error Mysql and that's it, if you connect to the server and I create all the tables, but it takes some time and the services disconnect with this error message on IRC:

link.LINK_UNRELIABLE [warn] Warning, no response from services.Userver.com for 15 seconds
 link.LINK_DISCONNECTED [error] Lost server link to services.UniversoChat.com [127.0.0.1]: No response (Ping timeout)

If anyone could help me, I would be grateful.

PD: as I say, the link is valid:

link.SERVER_LINKED [info] Server linked: irc.server.com -> services.server.com
* link.SERVER_SYNCED [info] Link services.server.com -> irc.server.com is now synced [secs: 0, recv: 3126, sent: 18195]

but I just try to solve the error and this is the timeOut, If you need any additional details, don't hesitate to ask

[sadiepowell]

Can you start anope with -support and pastebin a log?

You can use https://pastebin.anope.org/ and check the protection option if you don't want it to be public.

[JorgeMostiga]

I put the --support parameter and until now no service drops, from this line:

[Apr 18 17:59:40.558133 2025] Debug: Successfully connected to uplink #1 127.0.0.1:7000

until now:

[Apr 18 18:34:42.295144 2025] Debug: bs_main: Running bandata purger
[Apr 18 18:34:47.300356 2025] Debug: Saving databases
[Apr 18 18:35:22.028163 2025] Debug: Received: PING :irc.Server.com
[Apr 18 18:35:22.028251 2025] Debug: Sent: :00B PONG 00B irc.Server.com

Everything is OK! Maybe the connection to the DB takes a while. (sometimes), so the question is:

If services have a query to the external mysql db and it takes a while to respond if the services fall or there is nothing to see with the link with unrealircd?

[sadiepowell]

Which SQL backend are you using? Its generally not recommended to use the SQL backends with databases that aren't on the same machine as services because (especially if you're using db_sql_live) Anope has to execute a lot of queries and they have to be done when not processing data from the network and this can take a long time.

That said, you can try:

1. Lowering readtimeout here: https://github.com/anope/anope/blob/2.0/data/example.conf#L456-L459
2. Using db_sql instead of db_sql_live if you're using the live module (db_sql executes less queries which is acceptable if you don't need to edit the database).
3. If you're using chanstats or irc2sql try unloading them to see if that makes a difference.

[JorgeMostiga]

Thanks for your reply. Are you telling me to reduce the time even more? If it's 5s by default, how much more should I reduce it? Would 3s be fine? I'm using db_sql with the m_mysql module to connect to an external mysql server, and I'm not using chatstats or irc2sql. I'm only using Unrealircd and anope services with the m_mysql and db_sql modules.

[JorgeMostiga]

I followed your advice and installed MySQL locally. It took a long time to connect and process queries with the external MySQL server.