Re: [sqlite] Error: database disk image is malformed

2015-01-05 Thread Neo Anderson
> Are you using the same sqlite3 binary for both operations? > > If a database has a table definition that an older version of SQLite does not > understand, it will sometimes give this error. If you’re using a newer > version of SQLite to dump/load the files, there will be no error. > Yes, I am

Re: [sqlite] Error: database disk image is malformed

2015-01-05 Thread Jay Kreibich
On Jan 4, 2015, at 3:31 AM, Neo Anderson wrote: > I have a customer database which appears corrupt. When I run sqlite3 mydb and > PRAGMA integrity_check I got (literally, no other lines): > > Error: database disk image is malformed > > However, I can .dump and .read

Re: [sqlite] Error: database disk image is malformed

2015-01-05 Thread Eduardo Morras
On Sun, 4 Jan 2015 17:31:14 +0800 Neo Anderson wrote: > I have a customer database which appears corrupt. When I run sqlite3 > mydb and PRAGMA integrity_check I got (literally, no other lines): > > Error: database disk image is malformed > > However, I can .dump and

[sqlite] Error: database disk image is malformed

2015-01-05 Thread Neo Anderson
I have a customer database which appears corrupt. When I run sqlite3 mydb and PRAGMA integrity_check I got (literally, no other lines): Error: database disk image is malformed However, I can .dump and .read to create a new database. The new database works fine and the most surprising result is

[sqlite] Error: database disk image is malformed

2012-08-18 Thread Tal Tabakman
Hi Richard, *Just for getting better understanding* you wrote: " Consider using the "unix-dotfile" VFS instead of the standard "unix" VFS. (Add the string "unix-dotfile" as the 4th argument to sqlite3_open_v2().) The unix-dotfile VFS will use dot-file locking instead of posix advisory

Re: [sqlite] Error: database disk image is malformed

2012-08-17 Thread Richard Hipp
On Fri, Aug 17, 2012 at 8:08 AM, Tal Tabakman wrote: > > 7. file system is NFS. > Consider using the "unix-dotfile" VFS instead of the standard "unix" VFS. (Add the string "unix-dotfile" as the 4th argument to sqlite3_open_v2().) The unix-dotfile VFS will use dot-file

Re: [sqlite] Error: database disk image is malformed

2012-08-16 Thread Simon Slavin
On 16 Aug 2012, at 10:14pm, Tal Tabakman wrote: > Answering your question below, > > yes , I believe that the costumer is using network You can read section 6.0 of to learn some of the problems involved. If you need any

[sqlite] Error: database disk image is malformed

2012-08-16 Thread Tal Tabakman
Answering your question below, yes , I believe that the costumer is using network On 16 Aug 2012, at 6:52pm, Tal Tabakman http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>> wrote: >* we get the following error:*Error: database disk image is malformed*>* >Extended Error code: 11**

Re: [sqlite] Error: database disk image is malformed

2012-08-16 Thread Brandon Pimenta
Have you tried reinstalling SQLite? On Thu, Aug 16, 2012 at 2:52 PM, Tal Tabakman <tal.tabak...@gmail.com>wrote: > Error: database disk image is malformed _______ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bi

Re: [sqlite] Error: database disk image is malformed

2012-08-16 Thread Simon Slavin
On 16 Aug 2012, at 6:52pm, Tal Tabakman wrote: > we get the following error:*Error: database disk image is malformed > Extended Error code: 11* Is network or remote access involved in any part of this ? Or is the database file on the hard disk of the computer running

Re: [sqlite] Error: database disk image is malformed

2012-08-16 Thread David Barrett
On 08/16/2012 11:19 AM, Richard Hipp wrote: On Thu, Aug 16, 2012 at 1:52 PM, Tal Tabakman wrote: Hi. we are writing an application that in runtime produces a sqlite database. we get the following error:*Error: database disk image is malformed Extended Error code: 11* *

Re: [sqlite] Error: database disk image is malformed

2012-08-16 Thread Richard Hipp
On Thu, Aug 16, 2012 at 1:52 PM, Tal Tabakman wrote: > Hi. > we are writing an application that in runtime produces a sqlite database. > > we get the following error:*Error: database disk image is malformed > Extended Error code: 11* > * > * > *what can cause this error ?

[sqlite] Error: database disk image is malformed

2012-08-16 Thread Tal Tabakman
Hi. we are writing an application that in runtime produces a sqlite database. we are using this set of pragmas:( and also the CEROD extension for compression purposes). "PRAGMA cache_size=1;" "PRAGMA synchronous = 0;"; "PRAGMA temp_store=MEMORY"; "PRAGMA journal_mode = MEMORY;" "PRAGMA