On Thu, 27 May 2004, 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?
No, pages are appended to the rollback file 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 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]
>
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
