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)

Most upvoted comments

ok i will re-investigate the issue