Hello Kathleen, I'd set it to 5 minutes and see what happens. The timeout is worst case. It's not going to slow normal processing. I use infinite here. Is there ever a situation where you don't want to wait for it to finish? If you have hard real time requirements. I'd probably re-design it to be client server and have only one process actually talk to the DB and act like a server to the other processes. If you're going down that route though, a big database might be a better solution.
C Thursday, July 2, 2015, 6:22:52 PM, you wrote: KA> Thanks so much for the help. I set the timeout to 5 seconds (at each KA> instance of a db open connection) and was still seeing the database locked KA> errors with some frequency (haven't quantified it yet), so I will try KA> extending it to 30 seconds, as you suggest, and hopefully that makes a KA> difference. KA> Failing that, PostgreSQL looks promising (thanks so much for the KA> suggestion!), so I will start trying to implement it. KA> Thanks Again! KA> On Thu, Jul 2, 2015 at 6:06 PM, Simon Slavin <slavins at bigfraud.org> wrote: >> >> On 2 Jul 2015, at 3:59pm, Kathleen Alexander <katcalex at mit.edu> wrote: >> >> > I don't explicitly set sqlite3_busy_timeout(sqlite3*, int ms) so I will >> try >> > adding that after the database connection is opened to see if it limits >> > those errors. >> >> This will have an extreme effect. The default timeout for SQLite is not >> to use a timeout at all: any clash in access will result in immediate >> failure. Set your timeout to 30 seconds and see what happens. >> >> Worth noting that the timeout needs to be set by each application for each >> connection. If you set it for the first application which opens the >> database it won't automatically be applied by other connections. >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> KA> _______________________________________________ KA> sqlite-users mailing list KA> sqlite-users at mailinglists.sqlite.org KA> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Teg mailto:Teg at djii.com
