@Equinox76 both lines look the same?

Thanks! Copy paste error which i corrected.

cc @bradfitz @kardianos @kevinburke

I re-discovered this today and can add a little more context on how to reproduce it.

I believe @eqinox76's examples are actually backwards. Setting SetConnMaxIdleTime before SetConnMaxLifetime gives the correct behaviour, while setting SetConnMaxLifetime first gives the incorrect behavior.

Reproducing the bug

To trigger this bug, the following order of operations is required:

1. We have an open connection
2. We set SetConnMaxLifetime to something higher than our desired SetConnMaxIdleTime
3. We set SetConnMaxIdleTime

If this is the order of operations, then no idle connections will be closed until one SetConnMaxLifetime time has passed. After that we will cleanup connections every SetConnMaxIdleTime seconds as expected

Example code that triggers the bug:

package main

// Import go-sql-driver and connect to a mysqL server and make a basic query
import (
	"database/sql"
	"fmt"
	"time"

	_ "github.com/go-sql-driver/mysql"
)

func main() {
	db, _ := sql.Open("mysql", "root:@tcp(localhost:3306)/dbname")

        // Create a connection
	db.Ping()

	db.SetConnMaxLifetime(1000 * time.Second)
	db.SetConnMaxIdleTime(3 * time.Second)

	stats := db.Stats()
	fmt.Println("Open connections", stats.OpenConnections, "Idle connections", stats.Idle)

	fmt.Println("Sleep")
	// Should be long enough to clear idle connection
	time.Sleep(5 * time.Second)

	stats = db.Stats()
	fmt.Println("Open connections", stats.OpenConnections, "Idle connections", stats.Idle)
}

Expected output:

Open connections 1 Idle connections 1
Sleep
Open connections 0 Idle connections 0

Actual Output:

Open connections 1 Idle connections 1
Sleep
Open connections 1 Idle connections 1

Workarounds

To avoid the bug currently, either of the following changes will fix it:

1. Call SetConnMaxIdleTime before SetConnMaxLifetime:

	db.SetConnMaxLifetime(1000 * time.Second)
	db.SetConnMaxIdleTime(3 * time.Second)

2. Ensure that no active connections are setup when calling SetConnMaxLifetime and SetConnMaxIdleTime

Cause

When a connection exists and SetConnMaxLifetime is called, we will start the connectionCleaner with the interval set to our value of SetConnMaxLifetime.

https://github.com/golang/go/blob/master/src/database/sql/sql.go#L1046

Afterwards when we call SetConnMaxIdleTime we will not wake the cleaner because the existing logic only does so if we've reduced maxIdleTime, which we haven't. As suggested by @eqinox76 we probably should check additionally if if maxIdleTime has been set to less than maxLifetime and wake up the cleaner in that case too.

https://github.com/golang/go/blob/master/src/database/sql/sql.go#L1034

Why the workarounds work:

If there is no connection when we call these functions, then the cleaner is not started at all, and is only started after the first connection is allocated here, at which point it will use the lower maxIdleTime as expected.

https://github.com/golang/go/blob/master/src/database/sql/sql.go#L1521-L1523

Alternatively, calling SetConnMaxIdleTime before SetConnMaxLifetime ensures that the cleaner is setup with the shorter interval initially.

Change https://go.dev/cl/467655 mentions this issue: database/sql: wake cleaner if maxIdleTime set to less than maxLifetime