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 should not be
readable (malformed) ?!
When
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
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 sense is
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:
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 is
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
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 the funniest
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 reproduce
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., careless
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 FAQ
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, what happen if journal file is deleted before starting B process?
what if a UFO
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
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
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
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:
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
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 database
17 matches
Mail list logo
