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.tenth...@usetechnology.nl <mailto: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
