Re: [sqlite] VACUUM trouble

2008-09-20 Thread Zbigniew Baniewski
OK, the mystery has been solved: didn't notice, that disk just reached 100% usage... :D -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list

Re: [sqlite] VACUUM trouble

2008-09-20 Thread Zbigniew Baniewski
On Sun, Sep 21, 2008 at 12:26:32AM +0100, [EMAIL PROTECTED] wrote: > You know what disk IO error means, right? Run scandisk No, the disk is OK. > and try dumping the database and restoring it to a new file. Yes, I'm aware, that one can just create the database anew - but I was asking, why

Re: [sqlite] VACUUM trouble

2008-09-20 Thread seun . osewa
A 25mb file is nothing for SQLite; I vacuumed a 270mb test database a few hours ago with no problems. You know what disk IO error means, right? Run scandisk and try dumping the database and restoring it to a new file. On 9/21/08, Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > It seems, it's

[sqlite] VACUUM trouble

2008-09-20 Thread Zbigniew Baniewski
It seems, it's not possible to VACUUM a bit larger file? I tried to VACUUM a database file of 25 MB size, containing 75000 records (about 20 fields each). Unfortunately, each VACUUM attempt is interrupted with message: SQL error: disk I/O error No VACUUM allowed for such size? Linux 2.6.26,