Getting database lock error on sqlite3 golang?

Question

my queries

var m sync.Mutex
m.Lock()
defer m.Unlock()

_, err1 := database.Exec(`UPDATE  UserData SET coins = coins + ? WHERE rollno = ?`, transfer_data.Coins, transfer_data.ReceiverRollno)    
if err1 != nil {
   //if some error rollback databse to initial condition and print the error 
   fmt.Println("error lies in database.Exec() err1")
   fmt.Println(err1)
   tx.Rollback()
   return
   // panic(err)
}
    
_, err2 := database.Exec(`UPDATE UserData SET coins = coins - ?  WHERE rollno = ? AND coins - ? >= 0`, transfer_data.Coins, claims.Rollno, transfer_data.Coins)
    
if err2 != nil {
   //if some error rollback databse to initial condition and print the error
   fmt.Println(err2)
   fmt.Println("error lies in database.Exec() err2")
   tx.Rollback()
   return
}

//we are here so this means transaction is successful so Commit this change to the database
tx.Commit()

my table

UserCoin_info := `CREATE TABLE IF NOT EXISTS UserData(
   "rollno" INTEGER NOT NULL,
   "coins" INTEGER NOT NULL
);`
    
statement, err := db.Prepare(UserCoin_info)
if err != nil {
   panic(err)
}
statement.Exec()

I am getting database lock error as err1 while making a update in the first query, i tried using mutexes but still getting this error, i searched for possible solutions but didn't get any.

It would be helpful if you provided the original error message — zerkms
– zerkms, Commented Jun 29, 2021 at 4:49
i am getting this error lies in database.Exec() err1 database is locked — Dhruv singhal
– Dhruv singhal, Commented Jun 29, 2021 at 4:50
tx, err := database.Begin() if err != nil { fmt.Println("error lies in database.begin()") return } — Dhruv singhal
– Dhruv singhal, Commented Jun 29, 2021 at 4:56
If you run it on windows - it looks some other process has obtained the lock over the db file. — zerkms
– zerkms, Commented Jun 29, 2021 at 4:56

Anderson F. Viana · Accepted Answer · 2021-07-26 05:18:35Z

0

Database lock is result of not closing *Stmt and *Rows.

statement, err := db.Prepare(UserCoin_info)
if err != nil {
     panic(err)
}
defer statement.Close()

statement.Exec()

edited Jul 26, 2021 at 5:18

answered Jul 26, 2021 at 5:13

Anderson F. Viana

561 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user4466350 Over a year ago

to read also stackoverflow.com/a/32483180/4466350 and this is another variation stackoverflow.com/a/37769626/4466350

Collectives™ on Stack Overflow

Getting database lock error on sqlite3 golang?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related