Can you please try running "pragma integrity_check;" on the original database? That will give an indication of whether the original database has any data corruption.
On Fri, Dec 21, 2012 at 4:13 AM, Marco ten Thije < marco.tenth...@usetechnology.nl> wrote: > Hello, > > We are facing a problem with the '.backup' command using the SQLite > command line interface. The resulting backup-database seems to be corrupt. > > We ran into this problem on a ARM9 platform using SQLite 3.7.5, but it can > also be reproduced on the latest 3.7.15.1 version on Intel. > > I have attached our database to this email. These are the steps to > reproduce it: > > ./sqlite3 energy.sqlite > SQLite version 3.7.15.1 2012-12-19 20:39:10 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> select count(*) from EnergyLogData; > 3306 > sqlite> .backup backup.sqlite > sqlite> .exit > > The above shows the number of records in one of the tables and creates a > backup to a new 'backup.sqlite' database file. But this new file > seems to be corrupt: > > ./sqlite3 backup.sqlite > SQLite version 3.7.15.1 2012-12-19 20:39:10 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> select count(*) from EnergyLogData; > Error: database disk image is malformed > sqlite> .exit > > I have look into the Bug database and found ticket 3858, but that one > should already be fixed and we are not writing to the database during > the backup. > > Is this a bug or some other problem? > > -- > Regards, > Marco ten Thije > ------------------------------**------------------------------** > ------------ > > *Use system engineering bv* > Loc: Industriestraat 77 - 7482 EW HAAKSBERGEN - The Netherlands Mail > Address: Postbus 236 - 7480 AE HAAKSBERGEN - The Netherlands > T: +31 53 5741456 F: +31 53 5741458 E: marco.tenthije@usetechnology.** > nl <marco.tenth...@usetechnology.nl> <mailto:marco.tenthije@** > usetechnology.nl <marco.tenth...@usetechnology.nl>> I: > www.usetechnology.nl <http://www.usetechnology.nl/> > Chamber of Commerce nr: Veluwe en Twente 528 98210 VAT nr.: NL > 8506.54.713B01 > ------------------------------**------------------------------** > ------------ > /This message (including any attachments) is confidential and may be > privileged. If you have received it by mistake please notify the sender by > return e-mail and delete this message from your system. Any unauthorised > use or dissemination of this message in whole or in part is strictly > prohibited. Please note that e-mails are susceptible to change. Use system > engineering bv shall not be liable for the improper or incomplete > transmission of the information contained in this communication nor for any > delay in its receipt or damage to your system. Use system engineering bv > does not guarantee that the integrity of this communication has been > maintained nor that this communication is free of viruses, interceptions or > interference. / > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
