CODEWITHSUNDEEP
sqlgoruntime-errorruntime
srx lnx
srx lnx

Reputation: 157

sql golang invalid memory address or nil pointer dereference when do query

i am trying to insert data after the connection, when i command the logic of INSERT... i was able to connect to the database, but when i uncommand them , i got error 

panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0x40f8e2a]

here is my function :

func Connect() (*sql.DB, error) {
    db, err := sql.Open("postgres", os.Getenv("PG_URL"))
    if err != nil {
        return nil, err
    }
    defer db.Close()

    stmt, _ := db.Prepare("INSERT INTO users(name, email, password) VALUES(?,?,?)")
    res, err := stmt.Exec("test", "[email protected]", "12344")

    if err != nil{
        panic(err.Error())
    }
    fmt.Println(res)
    fmt.Println("Successfully connected!")
    return db, nil
}

I have tried to do the same thing also like this article go sql and have the same issue do I wrong implement this?

Upvotes: 1

Views: 7095

Answers (2)

suiluj
suiluj

Reputation: 11

I had the same problem with sqlite.

As Ivaylo Novakov described in his answer I had to log the err of the prepare statement (which i ignored like you before stmt, _)

For me it was running okay as long as i was developing but when I created my final binary i forgot to enable cgo).

The err got the hint:

Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub

Upvotes: 1

Ivaylo Novakov
Ivaylo Novakov

Reputation: 905

I bet a dollar/euro/frank that the NPE is on the line executing the prepared statement and that if you check the only error you ignored it won't be nil and it will tell you what's wrong.

Upvotes: 4

Related Questions