On Tue, Jul 8, 2014 at 3:58 PM, Mayank Kumar (mayankum) <mayan...@cisco.com> wrote:
> Hi All > > We have a process with a single sqlite db and a single connection to the > database from a thread. From time to time our processs restarts and reopens > the database or tries to create the database if it doesn't exists. > Sometimes when the process restarts, we get the error "database is locked" > although the way the process is restarted is the following:- > > -we always starts the process as a child by doing a vfork and exec > -if we receive a sigchld, we waitpid and finally restarts the process in > same way > I don't think this is possible. I think something else must be going on. Have you enabled logging? See http://www.sqlite.org/errlog.html for details. The error log might give additional clues. > > Could this scenario ever lead to database locked scenario, should we build > a retry mechanism when we get this error or this shouldn't occur if we know > the older process has died. > > Any suggestions? > > -Mayank > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
