go sqlite3 connection

[kushalsubedi]

What version of Go are you using (go version)?

$ go version
go version go1.23.1 linux/amd64

Does this issue reproduce with the latest release?

i don't know but im using this version and have problem while connecting with sqlite3

What operating system and processor architecture are you using (go env)?

go env Output

$ go env
GO111MODULE=''
GOARCH='amd64'
GOBIN=''
GOCACHE='/home/kushal/.cache/go-build'
GOENV='/home/kushal/.config/go/env'
GOEXE=''
GOEXPERIMENT=''
GOFLAGS=''
GOHOSTARCH='amd64'
GOHOSTOS='linux'
GOINSECURE=''
GOMODCACHE='/home/kushal/go/pkg/mod'
GONOPROXY=''
GONOSUMDB=''
GOOS='linux'
GOPATH='/home/kushal/go'
GOPRIVATE=''
GOPROXY='https://proxy.golang.org,direct'
GOROOT='/usr/lib/go'
GOSUMDB='sum.golang.org'
GOTMPDIR=''
GOTOOLCHAIN='auto'
GOTOOLDIR='/usr/lib/go/pkg/tool/linux_amd64'
GOVCS=''
GOVERSION='go1.23.1'
GODEBUG=''
GOTELEMETRY='local'
GOTELEMETRYDIR='/home/kushal/.config/go/telemetry'
GCCGO='gccgo'
GOAMD64='v1'
AR='ar'
CC='gcc'
CXX='g++'
CGO_ENABLED='1'
GOMOD='/dev/null'
GOWORK=''
CGO_CFLAGS='-O2 -g'
CGO_CPPFLAGS=''
CGO_CXXFLAGS='-O2 -g'
CGO_FFLAGS='-O2 -g'
CGO_LDFLAGS='-O2 -g'
PKG_CONFIG='pkg-config'
GOGCCFLAGS='-fPIC -m64 -pthread -Wl,--no-gc-sections -fmessage-length=0 -ffile-prefix-map=/tmp/go-build2772116798=/tmp/go-build -gno-record-gcc-switches'
uname -sr: Linux 6.10.10-arch1-1
LSB Version:    n/a
Distributor ID: Arch
Description:    Arch Linux
Release:    rolling
Codename:   n/a
/usr/lib/libc.so.6: GNU C Library (GNU libc) stable release version 2.40.

What did you do?

i tried to connect sqlite3 database in go but when i ran the program the program seems it stuck in infinite for loop neither it produce any output or throw any errors

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/mattn/go-sqlite3"
    "log"
    "net/http"
    _ "net/http/pprof"
)

func main() {
    go func() {
        log.Println(http.ListenAndServe("localhost:6060", nil))
    }()

    db, err := sql.Open("sqlite3", ":memory:")
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()

    var version string
    err = db.QueryRow("SELECT SQLITE_VERSION()").Scan(&version)
    if err != nil {
        log.Fatal(err)
    }

    fmt.Println("SQLite Version:", version)
}

What did you expect to see?

What did you see instead?

[gabyhelp]

Related Issues and Documentation

• sql #54339 (closed)
• cmd/link: system linker warnings on macOS 10.14 when using cgo #36025 (closed)
• cgo: program crashes when more that one package uses cgo #8948 (closed)
• Seems to be a bug in the source code, someone please help me. #35982 (closed)
• i got a problem, it feel like a resource bug, someone please help me #35980 (closed)
• runtime: "fatal: systemstack called from unexpected goroutine" on armv6 #38539
• "crawshaw.io/sqlite": Compilation inconsistency #65693 (closed)
• how to use gomobile to manipulate database for both android and ios #18194 (closed)
• cmd/compile: internal compiler error: gen_as_init couldn't make data statement #17990 (closed)
• cgo - crashy statically linked SQLite on Darwin #1429 (closed)

_{(Emoji vote if this was helpful or unhelpful; more detailed feedback welcome in this discussion.)}

[seankhliao]

Unlike many projects, the Go project does not use GitHub Issues for general discussion or asking questions. GitHub Issues are used for tracking bugs and proposals only.

For questions please refer to https://github.com/golang/go/wiki/Questions