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 ----- Original Message ----- From: "Darren Duncan" <[EMAIL PROTECTED]> 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 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 change operation, SQLite will first back-up the > original portions to a second rollback file, usually in multiples of > 1K. This file disappears or resets when you commit the current > transaction. If the disk is full, then this file creation fails, so > no changes will work. -- Darren Duncan > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
