From 0a176df6fb4109793c7efddb493b1f2f4ba1b1b2 Mon Sep 17 00:00:00 2001 From: Unknwon Date: Wed, 6 Feb 2019 18:46:15 -0500 Subject: models: disable idle connection and set connection max life time (#5532) --- models/models.go | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'models/models.go') diff --git a/models/models.go b/models/models.go index c4b60a0e..4cc6f8c6 100644 --- a/models/models.go +++ b/models/models.go @@ -13,6 +13,7 @@ import ( "os" "path" "strings" + "time" "github.com/Unknwon/com" _ "github.com/denisenkom/go-mssqldb" @@ -200,6 +201,11 @@ func SetEngine() (err error) { return fmt.Errorf("Fail to create 'xorm.log': %v", err) } + // To prevent mystery "MySQL: invalid connection" error, + // see https://github.com/gogs/gogs/issues/5532. + x.SetMaxIdleConns(0) + x.SetConnMaxLifetime(time.Second) + if setting.ProdMode { x.SetLogger(xorm.NewSimpleLogger3(logger, xorm.DEFAULT_LOG_PREFIX, xorm.DEFAULT_LOG_FLAG, core.LOG_WARNING)) } else { -- cgit v1.2.3