On 31 Oct 2009, at 3:22am, chen jia wrote:

> Before I ran vacuum, this table, firmsret11, has 2338120 rows.
>
> After I ran vacuum as follows,
> $ sqlite3 hq.db
> SQLite version 3.6.10
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> vacuum;
> sqlite> .exit
>
> and this table only had two rows,
> $ sqlite3 hq.db
> SQLite version 3.6.10
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> select count(*) from firmsret11;
> 2
>
> Dose anyone know how this could happen and how I can do to check what
> is causing this problem?  Thanks.

Please enter this line in the same sqlite3 tool you are using for  
vacuum:

PRAGMA integrity_check;

It appears that you have a copy of the database from before the  
'vacuum' command.  If you can, take another copy and run the PRAGMA  
command both before and after the 'vacuum'.  For more details see

<http://www.sqlite.org/pragma.html>

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to