o: 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 should not be
>
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
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
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
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
nt: 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, what happen if jo
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
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:
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
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, 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
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.,
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
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
17 matches
Mail list logo