Re: [sqlite] SQLite: Database or disk full

2011-11-22 Thread gavyas
Thanks a lot...forking was the problem..it is working now :) Roger Binns wrote: -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

[sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
Hi all, 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 checked the space quota and I have so much of the

[sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
Hi all, 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 checked the space quota and I have so much of the

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
I am able to run the code successfully when I dont use parallel runs. It gives error when I am running the code parallely. 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

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
points. The code didnt run for LIMIT 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

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
Its working fine with g++ compiler but not mpicc!! Dan Kennedy-4 wrote: 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

Re: [sqlite] SQLite: Database or disk full

2011-11-21 Thread gavyas
. Further debugging revlealed that sqlite3_step() was returning 1 and that means SQL error or Database missing. It was able to get the number of columns with the same database and SQL querry. I dont understand why I am getting this error. Gaurav gavyas wrote: Its working fine with g++ compiler