2008 7:50 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] transaction recovery question
On Jun 3, 2008, at 10:03 PM, Darko Filipovic wrote:
> I've tried...(not with UFO :D ). Nothing happens, database is not
> corrupted and that is what confuses me...I thought it
On Jun 3, 2008, at 10:03 PM, Darko Filipovic wrote:
> I've tried...(not with UFO :D ). Nothing happens, database is not
> corrupted and that is what confuses me...I thought it should not be
> readable (malformed) ?!
When SQLite needs to modify the content of a database page, it does
two things:
> First - some sample code or queries would be helpful.
> Second - start a new topic
> (http://en.wikipedia.org/wiki/Thread_hijacking).
>
Yes, sorry, my fault, i am a lazy bum these days.
My apologies. This was also an indirect test if this list is still alive..
Will start a new thread right
On 6/3/08, Christophe Leske <[EMAIL PROTECTED]> wrote:
> Hi,
>
> i am new to this list,
Welcome. But you have hijacked an existing thread. That will decrease
your chances of getting folks to reply to you positively.
Tip: Start a new thread for a different query.
> can anyone point me to a good
PROTECTED] On Behalf Of Christophe Leske
Sent: Tuesday, June 03, 2008 12:58 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] transaction recovery question
Hi,
i am new to this list, can anyone point me to a good FAQ document on how
to improve the speed of a SQLite database?
I got a
Hi,
i am new to this list, can anyone point me to a good FAQ document on how
to improve the speed of a SQLite database?
I got a city database (a geographical database) that I need to query for
lat/long values, and importance of the city (class value).
For my smallest query, i am waiting severa
Of P Kishor
Sent: Tuesday, June 03, 2008 10:06 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] transaction recovery question
On 6/3/08, Federico Granata <[EMAIL PROTECTED]> wrote:
> 2008/6/3 Darko Filipovic <[EMAIL PROTECTED]>:
>
>
> > But, wh
Darko Filipovic
<[EMAIL PROTECTED]> wrote:
> The thing is that my system sometimes produces malformed database,
> but I don't know what cause that. I'm trying to collect possible
> cases when database gets malformed. I'm going in this direction
> because it is not possible to debug system to reprod
The thing is that my system sometimes produces malformed database, but I
don't know what cause that. I'm trying to collect possible cases when
database gets malformed. I'm going in this direction because it is not
possible to debug system to reproduce condition. Because of that
question is: can
On 6/3/08, Darko Filipovic <[EMAIL PROTECTED]> wrote:
> I've tried...(not with UFO :D ). Nothing happens, database is not
> corrupted and that is what confuses me...I thought it should not be
> readable (malformed) ?!
The journal file is happily delete-able. So is the db itself. Try it.
My sens
Darko Filipovic
<[EMAIL PROTECTED]> wrote:
> But, what happen if journal file is deleted before starting B process?
"Doctor, it hurts when I do this" - "So don't do that".
If you expect random changes to the file system beyond your control,
then I don't see how any DBMS can maintain consistency.
Darko Filipovic
<[EMAIL PROTECTED]> wrote:
> I've tried...(not with UFO :D ). Nothing happens, database is not
> corrupted and that is what confuses me...I thought it should not be
> readable (malformed) ?!
Not necessarily. Suppose you issued an update statement that was
supposed to update 100 re
On 6/3/08, Federico Granata <[EMAIL PROTECTED]> wrote:
> 2008/6/3 Darko Filipovic <[EMAIL PROTECTED]>:
>
>
> > But, what happen if journal file is deleted before starting B process?
> >
>
> what if a UFO stole your pc ? :-D
>
> try to delete journal file and see what happens ...
>
my vote for
I've tried...(not with UFO :D ). Nothing happens, database is not
corrupted and that is what confuses me...I thought it should not be
readable (malformed) ?!
Greetings,
Darko F.
Federico Granata wrote:
> 2008/6/3 Darko Filipovic <[EMAIL PROTECTED]>:
>
>
>> But, what happen if journal file
2008/6/3 Darko Filipovic <[EMAIL PROTECTED]>:
> But, what happen if journal file is deleted before starting B process?
>
what if a UFO stole your pc ? :-D
try to delete journal file and see what happens ...
___
sqlite-users mailing list
sqlite-users@sql
But, what happen if journal file is deleted before starting B process?
Pozdrav,
Darko F.
Igor Tandetnik wrote:
> Robert Lehr <[EMAIL PROTECTED]> wrote:
>
>> I have a question about recovering from a transaction that was not
>> completed by a process b/c it terminated abnormally, e.g., carele
Robert Lehr <[EMAIL PROTECTED]> wrote:
> I have a question about recovering from a transaction that was not
> completed by a process b/c it terminated abnormally, e.g., careless
> SIGKILL or segfault. The scenario involves multiple processes having
> the database open.
>
> * process A opens the da
Simple enough to test... just open two sqlite sessions and try it...
Process B will recover the database when the transaction begins.
Are you having an issue with sqlite doing something different?
HTH
Robert Lehr <[EMAIL PROTECTED]> wrote: I have a question about recovering from
a transaction
I have a question about recovering from a transaction that was not
completed by a process b/c it terminated abnormally, e.g., careless
SIGKILL or segfault. The scenario involves multiple processes having
the database open.
* process A opens the database
* process B opens the datab
19 matches
Mail list logo