Closed
Description
Cannot insert or update while a query is "opened", which is not prohibited by the SQLite api.
Opening the database with SQLITE_OPEN_NOMUTEX or SQLITE_OPEN_PRIVATECACHE does not fix the problem.
This code while always result in golang "could not insert data into dst: database is locked". When one writes the equivalent code in C, the program just works.
I am about lost as to how to fix the problem. This "kind of use" has been supported by SQLite for quite some time now: database is locked.
package main
import (
"database/sql"
_ "github.com/mattn/go-sqlite3"
"log"
)
func main() {
db, err := sql.Open("sqlite3", "locked.sqlite")
if err != nil {
log.Fatalln("could not open database:", err)
}
defer db.Close()
// Drop, create and insert data into the test table
_, err = db.Exec("DROP TABLE IF EXISTS src;")
if err != nil {
log.Fatalln("could not drop table:", err)
}
_, err = db.Exec("DROP TABLE IF EXISTS dst;")
if err != nil {
log.Fatalln("could not drop table:", err)
}
_, err = db.Exec("CREATE TABLE src (id INTEGER NOT NULL PRIMARY KEY, data1 INTEGER, data2 INTEGER);")
if err != nil {
log.Fatalln("could not create table:", err)
}
_, err = db.Exec("CREATE TABLE dst (id INTEGER, data1 INTEGER, data2 INTEGER);")
if err != nil {
log.Fatalln("could not create table:", err)
}
for i := 0; i < 100; i++ {
_, err = db.Exec("INSERT INTO src (id, data1, data2) VALUES (?, ?, ?);", i, 100 + i, 1000 + i)
if err != nil {
log.Fatalln("could not insert into table:", err)
}
}
rows, err := db.Query("SELECT id, data1, data2 FROM src;")
if err != nil {
log.Fatalln("could not select data:", err)
}
defer rows.Close()
insert, err := db.Prepare("INSERT INTO dst (id, data1, data2) VALUES (?, ?, ?);")
if err != nil {
log.Fatalln("could not prepare statement:", err)
}
defer insert.Close()
for rows.Next() {
var id, data1, data2 int64
err = rows.Scan(&id, &data1, &data2)
if err != nil {
log.Fatalln("could not scan row:", err)
}
_, err = insert.Exec(id, data1, data2)
if err != nil {
log.Fatalln("could not insert data into dst:", err)
}
}
insert.Close()
rows.Close()
return
}Metadata
Metadata
Assignees
Labels
No labels