go-ora: Leaking cursors
If we have four timeouting queries cursors all cursors leaking after about 30 minutes. Maybe depends on #267
func main() {
...
pool, err := sql.Open("oracle", dsn)
defer pool.Close()
...
queries := [4]string{"select1", "select2", "select3", "select4"}
scheduler := gocron.NewScheduler(time.UTC)
for _, query := range queries {
if _, err := scheduler.Every(30).Second().Do(execQuery, pool, query); err := nil {
log.Fatalf("Err job: %v", err)
}
}
if _, err := scheduler.Every(60).Second().Do(pingDB, pool); err := nil {
log.Fatalf("Err job: %v", err)
}
scheduler.StartBlocking()
}
func execQuery(pool *sql.DB, query string) {
ctx, cancel := context.WithTimeout(context.Background(), time.Duration(1)*time.Second)
defer cancel()
rows, err := pool.QueryContext(ctx, query)
if err != nil {
log.Printf("Rows err: %v", err)
}
defer rows.Close()
log.Printf("%v", rows)
}
func pingDB(pool *sql.DB) {
ctx, cancel := context.WithTimeout(context.Background(), time.Duration(5)*time.Second)
defer cancel()
err := pool.PingContext(ctx)
if err != nil {
log.Printf("PingErr: %v", err)
}
}
About this issue
- Original URL
- State: closed
- Created 4 years ago
- Comments: 26 (12 by maintainers)
ok i will re-investigate the issue