How to disable PrepareStmt LRU cache?

[zllovesuki]

I'm getting unexplained lock up in unit test after upgrading to gorm v1.30.0. Is there a way to keep PrepareStmt: true but without using the LRU cache?

2025-06-18T10:46:11.5351831Z goroutine 4293 [select, 1 minutes]:
2025-06-18T10:46:11.5352283Z database/sql.(*DB).connectionOpener(0xc00093be10, {0x111afe8, 0xc00030a0f0})
2025-06-18T10:46:11.5352750Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1261 +0xeb
2025-06-18T10:46:11.5353112Z created by database/sql.OpenDB in goroutine 4292
2025-06-18T10:46:11.5353492Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:841 +0x287
2025-06-18T10:46:11.5353733Z 
2025-06-18T10:46:11.5353818Z goroutine 4042 [select, 1 minutes]:
2025-06-18T10:46:11.5354145Z database/sql.(*DB).connectionOpener(0xc00018d520, {0x111afe8, 0xc0002db130})
2025-06-18T10:46:11.5354600Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1261 +0xeb
2025-06-18T10:46:11.5354948Z created by database/sql.OpenDB in goroutine 4041
2025-06-18T10:46:11.5355324Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:841 +0x287
2025-06-18T10:46:11.5355568Z 
2025-06-18T10:46:11.5355650Z goroutine 4044 [select, 1 minutes]:
2025-06-18T10:46:11.5355973Z database/sql.(*DB).connectionOpener(0xc00018dc70, {0x111afe8, 0xc0002dbc20})
2025-06-18T10:46:11.5356425Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1261 +0xeb
2025-06-18T10:46:11.5356783Z created by database/sql.OpenDB in goroutine 4041
2025-06-18T10:46:11.5357156Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:841 +0x287
2025-06-18T10:46:11.5357397Z 
2025-06-18T10:46:11.5357478Z goroutine 4294 [select, 1 minutes]:
2025-06-18T10:46:11.5357725Z gorm.io/gorm/internal/lru.NewLRU[...].func1()
2025-06-18T10:46:11.5358109Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/internal/lru/lru.go:83 +0x1b8
2025-06-18T10:46:11.5358534Z created by gorm.io/gorm/internal/lru.NewLRU[...] in goroutine 4292
2025-06-18T10:46:11.5358971Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/internal/lru/lru.go:79 +0x545
2025-06-18T10:46:11.5359404Z 
2025-06-18T10:46:11.5359487Z goroutine 4300 [select, 1 minutes]:
2025-06-18T10:46:11.5359778Z database/sql.(*DB).conn(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x1)
2025-06-18T10:46:11.5360203Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1369 +0x71b
2025-06-18T10:46:11.5360735Z database/sql.(*DB).begin(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x0, 0x1)
2025-06-18T10:46:11.5361160Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1891 +0x57
2025-06-18T10:46:11.5361494Z database/sql.(*DB).BeginTx.func1(0x1)
2025-06-18T10:46:11.5361846Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1874 +0x7a
2025-06-18T10:46:11.5362193Z database/sql.(*DB).retry(0x4bae89?, 0xc0003a39a0)
2025-06-18T10:46:11.5362565Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1576 +0x4b
2025-06-18T10:46:11.5362957Z database/sql.(*DB).BeginTx(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x0)
2025-06-18T10:46:11.5363383Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1873 +0x108
2025-06-18T10:46:11.5363822Z gorm.io/gorm.(*PreparedStmtDB).BeginTx(0xc000a61260, {0x111af40, 0x15b88c0}, 0x0)
2025-06-18T10:46:11.5364300Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/prepare_stmt.go:90 +0xe4
2025-06-18T10:46:11.5364695Z gorm.io/gorm.(*DB).Begin(0xc0005270e0, {0x0, 0x0, 0xc0007b5290?})
2025-06-18T10:46:11.5365115Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/finisher_api.go:688 +0x3c8
2025-06-18T10:46:11.5365551Z gorm.io/gorm.(*DB).Transaction(0xc0005270e0, 0xc0003a3e30, {0x0, 0x0, 0x0})
2025-06-18T10:46:11.5365992Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/finisher_api.go:642 +0x446
2025-06-18T10:46:11.5366644Z go.miragespace.co/specter/kv/sqlite3.(*SqliteKV).Put(0xc0002546a0, {0x111af40, 0x15b88c0}, {0xc0007b6688, 0x8, 0x8}, {0xc0001fe057, 0x9, 0x9})
2025-06-18T10:46:11.5367286Z 	/home/runner/work/specter/specter/kv/sqlite3/simple.go:19 +0x28e
2025-06-18T10:46:11.5367857Z go.miragespace.co/specter/kv/sqlite3.TestConcurrentOps.func1({0x111af40, 0x15b88c0}, {0xc0007b6688, 0x8, 0x8}, 0x0)
2025-06-18T10:46:11.5368449Z 	/home/runner/work/specter/specter/kv/sqlite3/kv_test.go:193 +0x177
2025-06-18T10:46:11.5368916Z created by go.miragespace.co/specter/kv/sqlite3.TestConcurrentOps in goroutine 4292
2025-06-18T10:46:11.5369808Z 	/home/runner/work/specter/specter/kv/sqlite3/kv_test.go:229 +0x5db
2025-06-18T10:46:11.5370074Z 
2025-06-18T10:46:11.5370153Z goroutine 4305 [select]:
2025-06-18T10:46:11.5370433Z database/sql.(*DB).conn(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x1)
2025-06-18T10:46:11.5370864Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1369 +0x71b
2025-06-18T10:46:11.5371281Z database/sql.(*DB).begin(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x0, 0x1)
2025-06-18T10:46:11.5371712Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1891 +0x57
2025-06-18T10:46:11.5372045Z database/sql.(*DB).BeginTx.func1(0x1)
2025-06-18T10:46:11.5372390Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1874 +0x7a
2025-06-18T10:46:11.5372740Z database/sql.(*DB).retry(0x4bae89?, 0xc001017978)
2025-06-18T10:46:11.5373113Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1576 +0x4b
2025-06-18T10:46:11.5373506Z database/sql.(*DB).BeginTx(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x0)
2025-06-18T10:46:11.5373933Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1873 +0x108
2025-06-18T10:46:11.5374387Z gorm.io/gorm.(*PreparedStmtDB).BeginTx(0xc000a61260, {0x111af40, 0x15b88c0}, 0x0)
2025-06-18T10:46:11.5374861Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/prepare_stmt.go:90 +0xe4
2025-06-18T10:46:11.5375257Z gorm.io/gorm.(*DB).Begin(0xc00158c330, {0x0, 0x0, 0xc0007b5290?})
2025-06-18T10:46:11.5375675Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/finisher_api.go:688 +0x3c8
2025-06-18T10:46:11.5376103Z gorm.io/gorm.(*DB).Transaction(0xc00158c330, 0xc001017e28, {0x0, 0x0, 0x0})
2025-06-18T10:46:11.5376550Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/finisher_api.go:642 +0x446
2025-06-18T10:46:11.5377182Z go.miragespace.co/specter/kv/sqlite3.(*SqliteKV).Acquire(0xc0002546a0, {0x111af40, 0x15b88c0}, {0xc0007b6658, 0x8, 0x8}, 0x12a05f200)
2025-06-18T10:46:11.5377806Z 	/home/runner/work/specter/specter/kv/sqlite3/lease.go:28 +0x25f
2025-06-18T10:46:11.5378384Z go.miragespace.co/specter/kv/sqlite3.TestConcurrentOps.func1({0x111af40, 0x15b88c0}, {0xc0007b6658, 0x8, 0x8}, 0x1)
2025-06-18T10:46:11.5379209Z 	/home/runner/work/specter/specter/kv/sqlite3/kv_test.go:200 +0x276
2025-06-18T10:46:11.5379696Z created by go.miragespace.co/specter/kv/sqlite3.TestConcurrentOps in goroutine 4292
2025-06-18T10:46:11.5380182Z 	/home/runner/work/specter/specter/kv/sqlite3/kv_test.go:229 +0x5db
2025-06-18T10:46:11.5380430Z 
2025-06-18T10:46:11.5380517Z goroutine 4326 [select, 1 minutes]:
2025-06-18T10:46:11.5380806Z database/sql.(*DB).conn(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x1)
2025-06-18T10:46:11.5381232Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1369 +0x71b
2025-06-18T10:46:11.5381647Z database/sql.(*DB).begin(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x0, 0x1)
2025-06-18T10:46:11.5382069Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1891 +0x57
2025-06-18T10:46:11.5382405Z database/sql.(*DB).BeginTx.func1(0x1)
2025-06-18T10:46:11.5382745Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1874 +0x7a
2025-06-18T10:46:11.5383111Z database/sql.(*DB).retry(0x4bae89?, 0xc00093f9a0)
2025-06-18T10:46:11.5383478Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1576 +0x4b
2025-06-18T10:46:11.5383873Z database/sql.(*DB).BeginTx(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x0)
2025-06-18T10:46:11.5384297Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1873 +0x108
2025-06-18T10:46:11.5384743Z gorm.io/gorm.(*PreparedStmtDB).BeginTx(0xc000a61260, {0x111af40, 0x15b88c0}, 0x0)
2025-06-18T10:46:11.5385216Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/prepare_stmt.go:90 +0xe4
2025-06-18T10:46:11.5385603Z gorm.io/gorm.(*DB).Begin(0xc000263170, {0x0, 0x0, 0xc0007b5290?})
2025-06-18T10:46:11.5386017Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/finisher_api.go:688 +0x3c8
2025-06-18T10:46:11.5386450Z gorm.io/gorm.(*DB).Transaction(0xc000263170, 0xc00093fe30, {0x0, 0x0, 0x0})
2025-06-18T10:46:11.5386898Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/finisher_api.go:642 +0x446
2025-06-18T10:46:11.5387672Z go.miragespace.co/specter/kv/sqlite3.(*SqliteKV).Put(0xc0002546a0, {0x111af40, 0x15b88c0}, {0xc0007b66a8, 0x8, 0x8}, {0xc0001fe377, 0x9, 0x9})
2025-06-18T10:46:11.5388313Z 	/home/runner/work/specter/specter/kv/sqlite3/simple.go:19 +0x28e
2025-06-18T10:46:11.5388892Z go.miragespace.co/specter/kv/sqlite3.TestConcurrentOps.func1({0x111af40, 0x15b88c0}, {0xc0007b66a8, 0x8, 0x8}, 0x3)
2025-06-18T10:46:11.5389581Z 	/home/runner/work/specter/specter/kv/sqlite3/kv_test.go:193 +0x177
2025-06-18T10:46:11.5390051Z created by go.miragespace.co/specter/kv/sqlite3.TestConcurrentOps in goroutine 4292
2025-06-18T10:46:11.5390534Z 	/home/runner/work/specter/specter/kv/sqlite3/kv_test.go:229 +0x5db
2025-06-18T10:46:11.5390775Z 
2025-06-18T10:46:11.5390860Z goroutine 4304 [select, 1 minutes]:
2025-06-18T10:46:11.5391146Z database/sql.(*DB).conn(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x1)
2025-06-18T10:46:11.5391559Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1369 +0x71b
2025-06-18T10:46:11.5391974Z database/sql.(*DB).begin(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x0, 0x1)
2025-06-18T10:46:11.5392398Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1891 +0x57
2025-06-18T10:46:11.5392743Z database/sql.(*DB).BeginTx.func1(0x1)
2025-06-18T10:46:11.5393086Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1874 +0x7a
2025-06-18T10:46:11.5393428Z database/sql.(*DB).retry(0x4bae89?, 0xc0002ed9a0)
2025-06-18T10:46:11.5393793Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1576 +0x4b
2025-06-18T10:46:11.5394176Z database/sql.(*DB).BeginTx(0xc0003bcb60, {0x111af40, 0x15b88c0}, 0x0)
2025-06-18T10:46:11.5394593Z 	/opt/hostedtoolcache/go/1.24.3/x64/src/database/sql/sql.go:1873 +0x108
2025-06-18T10:46:11.5395029Z gorm.io/gorm.(*PreparedStmtDB).BeginTx(0xc000a61260, {0x111af40, 0x15b88c0}, 0x0)
2025-06-18T10:46:11.5395493Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/prepare_stmt.go:90 +0xe4
2025-06-18T10:46:11.5395880Z gorm.io/gorm.(*DB).Begin(0xc000a755f0, {0x0, 0x0, 0xc0007b5290?})
2025-06-18T10:46:11.5396414Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/finisher_api.go:688 +0x3c8
2025-06-18T10:46:11.5396845Z gorm.io/gorm.(*DB).Transaction(0xc000a755f0, 0xc0002ede30, {0x0, 0x0, 0x0})
2025-06-18T10:46:11.5397276Z 	/home/runner/go/pkg/mod/gorm.io/gorm@v1.30.0/finisher_api.go:642 +0x446
2025-06-18T10:46:11.5397916Z go.miragespace.co/specter/kv/sqlite3.(*SqliteKV).Put(0xc0002546a0, {0x111af40, 0x15b88c0}, {0xc0007b66c8, 0x8, 0x8}, {0xc0001c4157, 0x9, 0x9})
2025-06-18T10:46:11.5398582Z 	/home/runner/work/specter/specter/kv/sqlite3/simple.go:19 +0x28e
2025-06-18T10:46:11.5399363Z go.miragespace.co/specter/kv/sqlite3.TestConcurrentOps.func1({0x111af40, 0x15b88c0}, {0xc0007b66c8, 0x8, 0x8}, 0x0)
2025-06-18T10:46:11.5399956Z 	/home/runner/work/specter/specter/kv/sqlite3/kv_test.go:193 +0x177
2025-06-18T10:46:11.5400417Z created by go.miragespace.co/specter/kv/sqlite3.TestConcurrentOps in goroutine 4292
2025-06-18T10:46:11.5400899Z 	/home/runner/work/specter/specter/kv/sqlite3/kv_test.go:229 +0x5db