On Mon, Nov 11, 2019 at 05:03:25PM +0000, Simon Slavin wrote: > On 11 Nov 2019, at 1:42pm, Jukka Marin <jukka.ma...@jmp.fi> wrote: > > > Or does the main process need to close all databases, then fork, then > > reopen the databases? > > Which processes access the databases ? The main process ? Its children ? > Are they all using the same connection ? > Are they all trying to use the same connection at the same time ?
All processes access the databases. No, I changed the code so that every process opens the databases separately, so they use their own connections (at random times, so probably simultaneously). The main process first opens the databases and checks that their version matches that of the software and if not, the databases are closed and initialized by running a script. After closing the databases, main process forks the children and all processes (including main process) open the databases and use their own connections. What I was trying to ask was this: If any of the children dies (a bug in the code), main process will restart the child. At this point, the main process has the databases open, so the new child receives the connections as well. What should I do now? Should the child close the databases before opening them again? Will this close the databases for the main process as well? (One way is to stop using the databases in the main process, so they are not passed to children, but this would be a major change in the code.) -jm _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
