Re: [sqlite] My first hot journal, what do I do with it?

[Simon Slavin]

On 21 May 2014, at 9:16pm, Drago, William @ MWG - NARDAEAST 
 wrote:

> Well, it finally happened. I had a program crash and was left with a hot 
> journal file. A while back there was a post by Richard Hipp detailing 
> something that could/should be done before trying to use the database to 
> assure that SQLite does the rollback. I can't find that post now.

Nothing.  Leave everything as it is.  Do not move or rename the journal file.  
Just run whatever app it was that opens the database again.  SQLite will 
automatically notice the hot journal file and do its best to restore the 
database to an uncorrupted between-transaction state.

If you want to be extremely cautious take a backup copy of the database and the 
journal file before you reopen the database file.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] My first hot journal, what do I do with it?

[Drago, William @ MWG - NARDAEAST]

All,

Well, it finally happened. I had a program crash and was left with a hot 
journal file. A while back there was a post by Richard Hipp detailing something 
that could/should be done before trying to use the database to assure that 
SQLite does the rollback. I can't find that post now.

Any suggestions?

Thanks,
--
Bill Drago
Senior Engineer

L3 Communications / Narda Microwave East
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l-3com.com

CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users