Le Thu, Jul 27, 2023 at 11:16:48AM +0100, Stuart Henderson a écrit :
> On 2023/07/26 22:51, Denis Fondras wrote:
> > Here is an update to the latest version of GoToSocial.
> > It is not broken anymore.
>
> I see https://github.com/superseriousbusiness/gotosocial/issues/1710
> is still open, is that tested with a sqlite db (not pgsql)?
>
> If so, ok.
>
It was started with a SQLite DB :
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.210"
func=cache.(*Cac
hes).Init level=INFO msg="init: 0xc0005a2000"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.211"
func=cache.(*Cac
hes).Start level=INFO msg="start: 0xc0005a2000"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.212"
func=bundb.sqlit
eConn level=INFO msg="connected to SQLITE database with address
file:/var/gotosocial/gotosocial
.db?_txlock=immediate"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.217"
func=bundb.sqlit
ePragmas level=INFO msg="sqlite pragma journal_mode set to wal"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.217"
func=bundb.sqlit
ePragmas level=INFO msg="sqlite pragma synchronous set to 1"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.217"
func=bundb.sqlit
ePragmas level=INFO msg="sqlite pragma cache_size set to -8192"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.217"
func=bundb.sqlit
ePragmas level=INFO msg="sqlite pragma busy_timeout set to 1800000"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.221"
func=bundb.doMig
ration level=INFO msg="there are no new migrations to run"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023
13:53:43.221" func=bundb.(*adm
inDB).CreateInstanceAccount level=INFO msg="instance account localhost already
exists"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.221"
func=bundb.(*adm
inDB).CreateInstanceInstance level=INFO msg="instance entry already exists"
Jul 27 13:53:43 carcass gotosocial[93477]: timestamp="27/07/2023 13:53:43.226"
func=router.(*ro
uter).Start.func5 level=INFO msg="listening on [2a00:6060:1::1]:6666"
Jul 27 13:54:21 carcass gotosocial[93477]: timestamp="27/07/2023 13:54:21.392"
func=middleware.
Logger.func1.1 level=INFO latency=5.551004ms userAgent="Mozilla/5.0 (X11;
OpenBSD amd64; rv:109
.0) Gecko/20100101 Firefox/115.0" method=GET statusCode=200 path=/
clientIP=2a00:6060:1::10 req
uestID=9cqk75w904001pwdqe40 msg="OK: wrote 3.88kiB"
I believe the new version of modernc.org/sqlite resolved the issue.
