Re: [sqlite] SQLite: Database or disk full

2011-11-23 Thread Pavel Ivanov
On Wed, Nov 23, 2011 at 2:10 AM, Gaurav Vyas wrote: > There is no optimization as of now. I am just slitting the code into > various independent parts. And one more thing I found, I have installed > SQLite3 3.7.9 and when I am using sqlite3_open_v2 it gives error that says >

Re: [sqlite] SQLite: Database or disk full

2011-11-22 Thread Gaurav Vyas
There is no optimization as of now. I am just slitting the code into various independent parts. And one more thing I found, I have installed SQLite3 3.7.9 and when I am using sqlite3_open_v2 it gives error that says undefined symbol sqlite3_open_v2, and I have linked the correct library. Gaurav

Re: [sqlite] SQLite: Database or disk full

2011-11-22 Thread Simon Slavin
On 22 Nov 2011, at 5:40am, gavyas wrote: > Its working fine with g++ compiler but not mpicc!! Good experiment. Well spotted. Do you have control over the amount of optimization the mpicc compiler does ? Can you try turning optimization off entirely, or to its lowest setting ? Simon.

Re: [sqlite] SQLite: Database or disk full

2011-11-22 Thread gavyas
FMDvZtMJXu5oC > yW0AoJRRaJtNHB1xQviY00khV79aVIWV > =W5E1 > -END PGP SIGNATURE- > ___ > 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.n

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 21/11/11 23:02, gavyas wrote: > I dont understand why I am getting this error. My best guess would be that a fork is happening after the database has been opened inserted by the compiler (but not gcc) in order to make things parallel. If you do a

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
;>>> <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 >>>>

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
eading> >>> >>> 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.or

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread Dan Kennedy
On 11/22/2011 09:48 AM, gavyas wrote: 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 1 OFFSET 0" but it ran successfully for LIMIT 5000. I dont understand if there is an upper limit on LIMIT or

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
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

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread Simon Slavin
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:

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- View this message in context: http://old.nabble.com/SQLite%3A-Database-or-disk-full-tp32871505p32871706.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing li

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread Simon Slavin
On 21 Nov 2011, at 9:44pm, gavyas wrote: > I am using SQLite to handle database while running a simulation on > supercomputers here. I am using MPI process to do multiple threading. I am > keep getting error that says "database or disk is full" while passing any > querry to SQLite. I have

[sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
ve so much of the space available. I dont know why I am getting this error, so can you tell me what is causing this problem? -- View this message in context: http://old.nabble.com/SQLite%3A-Database-or-disk-full-tp32871505p32871505.html Sent from the SQLite mailing list archive at

[sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
ve so much of the space available. I dont know why I am getting this error, so can you tell me what is causing this problem? -- View this message in context: http://old.nabble.com/SQLite%3A-Database-or-disk-full-tp32871501p32871501.html Sent from the SQLite mailing list archive at