> So if the corruption problem is
> confined to an index or indexes, an export/import will fix
> problem but a vacuum will not.
> Dan.
I ran into exactly that problem with Sqlite database used by Trac
(http://trac.edgewall.org/).
The solution Dan proposed here worked fine for me. That's what I d
On Jul 31, 2009, at 12:00 AM, rupert.thurner wrote:
> is there another possibility but exporting and importing the data to
> get rid of:
> SQL error: database disk image is malformed
> ?
>
> here the details of the error and the commands we used. but we are not
> sure why exporting works and va
is there another possibility but exporting and importing the data to
get rid of:
SQL error: database disk image is malformed
?
here the details of the error and the commands we used. but we are not
sure why exporting works and vacuum should not work. we used sqlite
3.6.10, solaris.
# sqlite3 t
On Wed, 6 May 2009 00:40:22 -0500, "Jay A. Kreibich"
wrote:
>On Tue, May 05, 2009 at 11:46:38PM +0200, Kees Nuyt scratched on the wall:
>> On Tue, 5 May 2009 16:55:42 -0400, Pavel Ivanov
>> wrote:
>>
>> >Is it just me or somebody else is
>> >seeing too that the sql statement
>> > "select blobid
On Tue, May 05, 2009 at 11:46:38PM +0200, Kees Nuyt scratched on the wall:
> On Tue, 5 May 2009 16:55:42 -0400, Pavel Ivanov
> wrote:
>
> >Is it just me or somebody else is
> >seeing too that the sql statement
> > "select blobid, fbid from sig group by peerid"
> >is invalid and shouldn't be
> >
On Tue, 5 May 2009 16:55:42 -0400, Pavel Ivanov
wrote:
>Is it just me or somebody else is
>seeing too that the sql statement
> "select blobid, fbid from sig group by peerid"
>is invalid and shouldn't be
>executed or prepared at all?
You are right, it doesn't make sense.
@Joannek: When using
Is it just me or somebody else is seeing too that the sql statement
"select blobid, fbid from sig group by peerid" is invalid and
shouldn't be executed or prepared at all?
Pavel
On Mon, May 4, 2009 at 2:51 PM, Joanne Pham wrote:
> Hi All,
> I ran the following sql statement:
> select blobid,
Hi Joanne,
It's possible you'll have to resort to your most recent backup. But before
doing that, I wasn't sure from your reply that you saw the other points I
listed.
-- Hold tight to my backups of my data.
-- Run "PRAGMA integrity_check;" as soon as possible.
-- See if the problem can be r
day, May 4, 2009 4:26:58 PM
Subject: Re: [sqlite] SQL error: database disk image is malformed
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Joanne Pham
Sent: Monday, May 04, 2009 2:51 PM
To: General Discussion of SQLite Databa
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Joanne Pham
Sent: Monday, May 04, 2009 2:51 PM
To: General Discussion of SQLite Database
Subject: [sqlite] SQL error: database disk image is malformed
Hi All,
I ran the
Hi All,
I ran the following sql statement:
select blobid, fbid from sig group by peerid;
return about 10 rows
22
...
33
return about 10 rows and I got the error message:
SQL error: database disk image is malformed
but when I ran the following sql
"Kees Nuyt" helped with...
Hi Jose,
On Sun, 13 Jan 2008 23:47:04 -0500, "jose isaias cabrera"
<[EMAIL PROTECTED]> wrote:
"Kees Nuyt" trying to help me said...
On Fri, 11 Jan 2008 15:32:28 -0500, "jose isaias cabrera"
<[EMAIL PROTECTED]> wrote:
Greetings.
I have a problem. I have thi
Hi Jose,
On Sun, 13 Jan 2008 23:47:04 -0500, "jose isaias cabrera"
<[EMAIL PROTECTED]> wrote:
>"Kees Nuyt" trying to help me said...
>
>> On Fri, 11 Jan 2008 15:32:28 -0500, "jose isaias cabrera"
>> <[EMAIL PROTECTED]> wrote:
>>
>>>
>>>Greetings.
>>>
>>>I have a problem. I have this shared DB a
"Kees Nuyt" trying to help me said...
On Fri, 11 Jan 2008 15:32:28 -0500, "jose isaias cabrera"
<[EMAIL PROTECTED]> wrote:
Greetings.
I have a problem. I have this shared DB amongst 4 co-workers where I am
getting this error:
SQL error: database disk image is malformed
that is after I do
On Fri, 11 Jan 2008 15:32:28 -0500, "jose isaias cabrera"
<[EMAIL PROTECTED]> wrote:
>
>Greetings.
>
>I have a problem. I have this shared DB amongst 4 co-workers where I am
>getting this error:
>
>SQL error: database disk image is malformed
>
>that is after I do a,
>
>select * from LSOpenProjec
Greetings.
I have a problem. I have this shared DB amongst 4 co-workers where I am
getting this error:
SQL error: database disk image is malformed
that is after I do a,
select * from LSOpenProjects;
and goes and display 1006 records and then I get that error above...
1006|1006|1006|NEW||
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: quinta-feira, 22 de novembro de 2007 12:58
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQL error: database disk image is malformed -
SQLITE3.5.1
>
>
> There is a good description of the things that
Salles, Joaquim Campos wrote:
Now running the command "PRAGMA integrity_check":
sqlite> PRAGMA integrity_check;
*** in database main ***
Main freelist: 138691677 of 4 pages missing from overflow list starting
at 2972
On tree page 322 cell 0: 3 of 4 pages missing from overflow list
starting at 2
I'm using SQLITE 3.5.1 - in Linux, Had Red 7.1, with a single thread
application - and 2 different programs accessing the same database. I am
getting the following message:
SQL error: database disk image is malformed.
I copy the database to windows and run with sqlite and also get the same
message
On 7/12/06, Bull219 <[EMAIL PROTECTED]> wrote:
In fact, I do not think the bug comes from these things as I can also
reproduce the bug without using my application but the command-line
program provided on the SQLite official website (see below "How to
reproduce the corruption").
You seem to be
First of, thank you very much Christian for replying so precisely to
my message.
Things to check:
- Multiple processes accessing the database file. SQLite will arbitrate
access using a well defined locking protocol. If a process does not
respect this protocol, or locking is defective (NFS
Bull219 uttered:
Dear all,
I am developping a freeware which uses SQLite. One of my beta testers
informed me about an issue he had: with his DB, following the query which is
sent to the DB, I have the error in the subject of this email. I did some
testing, and when I succeeded in reproducing
I am developping a freeware which uses SQLite. One of my beta testers
informed me about an issue he had: with his DB, following the query
which is sent to the DB, I have the error in the subject of this email.
I did some testing, and when I succeeded in reproducing the error just
by doing a VACUUM
Dear all,
I am developping a freeware which uses SQLite. One of my beta testers
informed me about an issue he had: with his DB, following the query
which is sent to the DB, I have the error in the subject of this email.
I did some testing, and when I succeeded in reproducing the error just
by
24 matches
Mail list logo
