opt: reduce sqlite "database is locked" error (#1009)

myml · looplj · gemini-code-assist[bot] · web-flow · commit f0e32b2cf6bb · 2026-03-10T10:54:42.000+08:00
* fix: sqlite "database is locked" error

在sqllite+hdd+trace很容易出现 database is locked 错误, 导致trace记录不完整

通过限制sqlite并发数避免这个问题

* Update internal/server/db/ent.go

Co-authored-by: gemini-code-assist[bot] &lt;176961590+gemini-code-assist[bot]@users.noreply.github.com&gt;

---------

Co-authored-by: Loop &lt;bababaa261@gmail.com&gt;
Co-authored-by: gemini-code-assist[bot] &lt;176961590+gemini-code-assist[bot]@users.noreply.github.com&gt;
diff --git a/internal/server/db/ent.go b/internal/server/db/ent.go
@@ -46,6 +46,10 @@ func NewEntClient(cfg Config) *ent.Client {
 		if err != nil {
 			panic(err)
 		}
+		// 将 SQLite 的最大打开连接数限制为 1，以防止在高并发写入时出现 "database is locked" 错误。
+		// 这有效地序列化了所有数据库访问。
+		sqlDB.SetMaxOpenConns(1)
+		sqlDB.SetMaxIdleConns(1)
 
 		dbDialect = dialect.SQLite
 	case "mysql", "tidb":
