Memory leak with .Count()

[aj3423]

I was using sqlite3 and gorm and found a memory leak problem, then I tried upper-db, the same problem. Maybe it is caused by the driver library mattn/go-sqlite3? But from the pprof backtrace, most leaks are ended in code of upper, not in driver code.

To reproduce, run the following code, then open this URL in browser: http://localhost:3344/debug/pprof.

package main

import (
	"fmt"
	"runtime"

	"github.com/upper/db/adapter/sqlite"

	"net/http"
	_ "net/http/pprof"
)

type Person struct {
	Age int `db:"age"`
}

func leak_upper() {
	sess, e := sqlite.Open(sqlite.ConnectionURL{Database: `test.db`})
	if e != nil {
		panic(e)
	}
	sess.SQL().Exec(`create table "person" ("age" int);`)

	P := sess.Collection(`person`)

	for i := 0; i < 10000; i++ {
		P.Find(`age`, 123).Count()
	}
	//for i := 0; i < 10000; i++ {
		//P.Find(`age`, 123).Count()
	//}
	//for i := 0; i < 10000; i++ {
		//P.Find(`age`, 123).Count()
	//}
}
func main() {
	go func() { // set up pprof server, for analyzing heap leak
		fmt.Println("open in browser: http://localhost:3344/debug/pprof")
		e := http.ListenAndServe("0.0.0.0:3344", nil)
		if e != nil {
			panic(e)
		}
	}()

	leak_upper()

	runtime.GC()

	fmt.Println("press enter to exit")
	fmt.Scanln()
}

The heap grows when .Count() called, in my case the number is near 70+. Click it for details, all these heap allocations point to sqladapter.(*Result).Count

a sample trace:

How to solve this? Thanks.