Sometime get "database is locked" warn when trying to delete table rows one by one.

You must Login before you can answer or comment on any questions.

Hello all.

I'm facing a sqlite problem. it just drives me crazy! ok.... thats the situation. there are some rows in a tableview. and when I trying to delete one of them, sometime is ok. sometimes i get the "database is locked" WARN.

And I'm 100% sure that I close all the connection. but just sometimes get this erros. And I'm not the first one get the some problem. but seems didnt get the answer yet. here is the post!

so confusing. Any ideal?

— asked 7 months ago by wei huang
2 Comments

  • it is more reliable to solve your problem if you share that portion of code

    — commented 7 months ago by Mitul Bhalia

  • Alternative is to keep db connection open and pass it to all of your windows commonJS style..

    — commented 7 months ago by Mark Henderson

1 Answer

Hello Mitul and Mark,

Thank you so much for your guys support. The problem had been fixed. What I do is writing a db operation API and all the DB operation CRUD is running there.

thank you so much and I hope this would help someone who has the same problem.

Your Answer

Think you can help? Login to answer this question!