Re: [sqlite] delete record fail when disk full

2004-05-27 Thread Darren Duncan
At 9:06 PM +0800 5/27/04, Kei wrote: Hi all, Thank you. Does the size of the second rollback file depend on the size of database file or another issue? If the size of database file is 2MB, will the rollabck file also consume 2MB? Best regards, Kei The size of the rollback file is equivalent to the

Re: [sqlite] delete record fail when disk full

2004-05-27 Thread Christian Smith
e as and when they are updated in the main file. > >Best regards, >Kei > >- Original Message - >From: "Darren Duncan" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, May 27, 2004 1:10 PM >Subject: Re: [sqlite] delete record fail

Re: [sqlite] delete record fail when disk full

2004-05-27 Thread Kei
> To: <[EMAIL PROTECTED]> Sent: Thursday, May 27, 2004 1:10 PM Subject: Re: [sqlite] delete record fail when disk full > At 11:59 AM +0800 5/27/04, Kei wrote: > >Is it a normal condition if no space to do the delete operation?or > >is it a bug?how to solve it if it has so

Re: [sqlite] delete record fail when disk full

2004-05-26 Thread Darren Duncan
At 11:59 AM +0800 5/27/04, Kei wrote: Is it a normal condition if no space to do the delete operation?or is it a bug?how to solve it if it has solution? Thx a lot! I am running it in arm_linux and I use sqlite version 2.8.12. temp_store is 3 in sqliteInt.h (use memory). While performing any chang

[sqlite] delete record fail when disk full

2004-05-26 Thread Kei
Hi all, I want to delete a record when database is full but I get the error message "../../src/sqlite/pager.c:559: pager_playback_one_page: Assertion `pPg->nRef==0 || pPg->pgno==1' failed." or "SQL error:databse is full" The sequence of doing the test: 1. create the db file and insert records u