Re: [sqlite] VACUUM trouble
OK, the mystery has been solved: didn't notice, that disk just reached 100% usage... :D -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VACUUM trouble
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 VACUUM is giving up. No, it's not hardware-related trouble. Meanwhile I've found something related: http://www.mail-archive.com/sqlite-users@sqlite.org/msg24905.html Is it filesystem-related problem? Is it possible, that SQLite just "doesn't like" Reiserfs? -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] VACUUM trouble
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 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, SQLite 3.6.1, 256 MB RAM > -- > pozdrawiam / regards > > Zbigniew Baniewski > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Seun Osewa http://www.nairaland.com/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users