I am experiencing a particular problem when running an SQL script on a database managed with MariaDB. When I run the script, the connection closes after exactly 2 hours, interrupting the execution of the query. I am certain that the query is correct, because when I run it on a smaller dataset, the results are returned without any problems.

I have ruled out the possibility that the problem could be related to the server or the firewall, as a colleague of mine executed the same query without interruption. This leads me to think that the problem is client-side.

I have tried running the query with both DBeaver and DataGrip, changing some generic timeout settings, but the problem persists. Has anyone had a similar problem or knows how to solve it?

Thanks in advance for any help!

[logs error]
[socket timeout]

I tried to solve the problem by changing various settings in both the client and the driver, but without success. Even after these changes, the socket goes into timeout when the query takes more than 2 hours to execute.