I checked the code again and debugged it. The code gave error when I am passing the querry "SELECT * FROM households ORDER BY zone_id LIMIT 10000 OFFSET 0" but it ran successfully for LIMIT 5000. I dont understand if there is an upper limit on LIMIT or what but the table "households" has 10000 data points. The code didnt run for LIMIT 9999 either
Simon Slavin-3 wrote: > > > On 21 Nov 2011, at 11:09pm, gavyas wrote: > >> I am able to run the code successfully when I dont use parallel runs. It >> gives error when I am running the code parallely. > > Ahha. That's a more useful diagnostic. If you haven't already, read > these: > > <http://www.sqlite.org/threadsafe.html> > > <http://stackoverflow.com/questions/524797/python-sqlite-and-threading> > > but I can't comment on multi-threading from my own use. I hope someone > else can. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/SQLite%3A-Database-or-disk-full-tp32871505p32871964.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
