Syncing problem (go-sql-driver)

Seafile Server
1

Dear forum members,

I have a problem with my seafile installation. The fileserver-error log states a problem with the go sql driver.
Syncing via Windows Desktop Client (9.0.6) takes some time to finish, and switches between getting filelist, and uploading. It takes some approaches, after a while it finishes uploading.

Here some version Infos, if you need any more logs or outputs, let me know. Any hints on solving this, is highly appreciated.

Seafile Community Server 11.0.10 (Manual Installation)
OS: Ubuntu Server 22.04.4 LTS
MySQL server-version: 8.0.39-0ubuntu0.22.04.1 (Charset: UTF-8 Unicode (utf8mb4))

fileserver-error.log

[mysql] 2024/08/07 10:59:38 packets.go:122: closing bad idle connection: unexpected read from socket
[mysql] 2024/08/07 10:59:38 connection.go:158: driver: bad Connection

Thanks in advance,
best, Martin

2

… I turned off the go fileserver in seafile.conf. Now everything seems to work fine. Any hints on how to debug the go-fileserver option?

best, Martin

3

This behavior is normal if you copy a lot of files into the library. The client will upload the files in batch less than 100MB.

The Go sql driver closes idle or bad connections. This should also be normal. The Go sql driver uses connection pool.

The connection pooling logic in C fileserver is different from the Go one. It’ll send keep-alive requests to the database to keep the connections alive. So maybe your database has some timeout configuration about idle connections.

Do you have any error messages in the client’s log?