Once I experienced a problem during testing where multi-threaded Win32
Application (using SQLite 3.3.4) was running (in development environment)
and due to power-failure, rollback journal file was OK but disk bad-sector
damaged the sqlite db-file.
When I restarted App, db could not be opened
> What OS are you using?
Linux 2.6.15-23-server #1 SMP Tue May 23 15:10:35 UTC 2006 i686
GNU/Linux
It's an ubuntu 6.06 server distribution.
> What kind of mass storage? (Disk or flash?)
It's just the disk of the computer on which I installed sqlite, I don't
use any mass storage device. The
I have identified the only table which is corrupted.
> 2) See if the "vacuum" command will run, and if all tables remain
afterwards.
> http://www.sqlite.org/lang_vacuum.html
It does not work, I have the same message:
SQL error: database disk image is malformed
> 3) Try a ".dump"
"zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote:
> Sorry, I meant a power failure, or a power loss if you prefer.
No worries. I got to learn a new French word!
>
> I have generated a new data file, this is not a problem in a development =
> environment, but what should I
Ok, I'll try those steps and I keep you informed.
-Message d'origine-
De : Griggs, Donald [mailto:[EMAIL PROTECTED]
Envoyé : mardi 8 août 2006 14:54
À : sqlite-users@sqlite.org
Objet : RE: [sqlite] Recovery tool ?
"...alimentation interruption..." --- Power interruption -- f
: mardi 8 août 2006 13:38
À : sqlite-users@sqlite.org
Objet : Re: [sqlite] Recovery tool ?
"zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I had an alimentation interruption on my sqlite database running on
> linux. And now the dat
all OTHER tables.
5) Now gauge how much data, if any, is missing, and plan your remediation.
-Original Message-
From: zze-ContentLab MARTINEAU Y ext RD-SIRP-REN
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 4:48 AM
To: sqlite-users@sqlite.org
Subject: [sqlite]
Alimentation is the French word and alimentacion is the
Spanish word for "food" or "feed".
In this case the poster is referring to an electrical power failure
on the computer.
On Tue, 08 Aug 2006 11:38:09 +, [EMAIL PROTECTED] wrote:
>"zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL
"zze-ContentLab MARTINEAU Y ext RD-SIRP-REN" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I had an alimentation interruption on my sqlite database running on
> linux. And now the data file seems to be corrupted. Is there any tool to
> cleanup this file ? Or is it necessary to restart from a blank new
Hello,
I had an alimentation interruption on my sqlite database running on
linux. And now the data file seems to be corrupted. Is there any tool to
cleanup this file ? Or is it necessary to restart from a blank new data
file ?
Thank you,
yohann
10 matches
Mail list logo
