[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] disk image malformed
From:       Kevin Schmeichel <schmeic () yahoo ! com>
Date:       2005-06-28 17:54:36
Message-ID: 20050628175436.76497.qmail () web32914 ! mail ! mud ! yahoo ! com
[Download RAW message or body]


  I recently reported a similar error.  After
upgrading to sqlite3, I noticed that I would
occassionally get the "database disk image is
malformed" errors using the library code.  I just
closed/reopened the db, retried the query and always
had success on the retry.  No idea why - D. Richard
Hipp says that it's not possible for a database to be
temporarily corrupt.

  I've also sometimes observed a "some_table doesn't
exist" error.  Closing/reopening and retrying the
query also always works.

  I think that it's a good idea to have a wrapper
around the sqlite library that will retry queries a
few times if they don't return SQLITE_OK.  This is
especially useful in the cases when the db is busy but
the busy handler isn't called (because apparently that
would cause deadlock).

Kevin

--- Leander Gillard <leander@vianet.ca> wrote:

> Hello,
> 
> Just wondering why I get this error when trying to
> open the DB with the Binary interface. It has
> actually worked on the odd occasion.
> 
>  sqlite l_main.dbl
> Unable to open database "l_main.dbl": database disk
> image is malformed
> 
> 
> Regards,
> 
> 
> Leander


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
[prev in list] [next in list] [prev in thread] [next in thread]