Seafile Pro 7.1.3 : Failed to connect to MySQL

Seafile Server
1

Hello,
In seafile.log, several times a day I get this error:

[05/11/2020 04:46:19 PM] ../common/seaf-db.c(596): Failed to connect to MySQL: Can't connect to MySQL server on '127.0.0.1' (110)

do you have an idea ?

Thx

2

This error message can mean anything.
Permission correct?
Databases exist?
Firewall blocking SQL ports?

Not sure if the last one is even possible but not sure

3

I do not have more info … Seafile is working correctly however this message is probably not normal …

5

Thanks Cisco,
I have similar seafile.log, but 4 - 5x per day i have this line in middle …its weird

…/common/seaf-db.c(596): Failed to connect to MySQL: Can’t connect to MySQL server on ‘127.0.0.1’ (110)

6

I have the same problem. It doesn’t affect general Seafile usage (as far as I looked), but it’s breaking the FUSE mount point. I’m using seaf-fuse to backup my files, and this error breaks randomly file access through the FUSE mount point. In my logs :

mai 26 19:35:39 seafile seaf-fuse[1908]: ../common/seaf-db.c(596): Failed to connect to MySQL: Can't connect to MySQL server on '127.0.0.1' (99)
mai 26 19:35:39 seafile seaf-fuse[1908]: ../common/branch-mgr.c(575): [branch mgr] DB error when get branch master.
mai 26 19:35:39 seafile seaf-fuse[1908]: repo-mgr.c(340): Failed to get master branch of repo bf03c3d0.
mai 26 19:35:39 seafile seaf-fuse[1908]: repo-mgr.c(348): Repo bf03c3d0 is corrupted.
mai 26 19:35:39 seafile seaf-fuse[1908]: getattr.c(114): Failed to get repo bf03c3d0-045b-428a-b2d9-0036b7a1d2fe.
mai 26 19:35:39 seafile seaf-fuse[1908]: ../common/seaf-db.c(596): Failed to connect to MySQL: Can't connect to MySQL server on '127.0.0.1' (99)
mai 26 19:35:39 seafile seaf-fuse[1908]: getattr.c(114): Failed to get repo bf03c3d0-045b-428a-b2d9-0036b7a1d2fe.
mai 26 19:35:39 seafile seaf-fuse[1908]: ../common/seaf-db.c(596): Failed to connect to MySQL: Can't connect to MySQL server on '127.0.0.1' (99)
mai 26 19:35:39 seafile seaf-fuse[1908]: getattr.c(114): Failed to get repo bf03c3d0-045b-428a-b2d9-0036b7a1d2fe.
mai 26 19:35:39 seafile seaf-fuse[1908]: ../common/seaf-db.c(596): Failed to connect to MySQL: Can't connect to MySQL server on '127.0.0.1' (99)
mai 26 19:35:39 seafile seaf-fuse[1908]: getattr.c(114): Failed to get repo bf03c3d0-045b-428a-b2d9-0036b7a1d2fe.
mai 26 19:35:39 seafile seaf-fuse[1908]: ../common/seaf-db.c(596): Failed to connect to MySQL: Can't connect to MySQL server on '127.0.0.1' (99)
mai 26 19:35:39 seafile seaf-fuse[1908]: getattr.c(114): Failed to get repo bf03c3d0-045b-428a-b2d9-0036b7a1d2fe.

MariaDB 10.4 too. There’s no network issue, as MariaDB is running on the same server. MariaDB is running fine

7

Seafile 7 to ?

8

Yes, seafile 7.1.4. But I think I found a workaround. Seams seafile is opening too many connections to the DB, until exhaustion (instead of reusing already opened connections). It seems to be OK if I set net.ipv4.tcp_tw_reuse and net.ipv4.tcp_tw_recycle to 1