On Tue, 25 Sep 2007, Joe Wilson wrote:
What happens when you run "PRAGMA integrity_check;" ?
If all else fails, use strace or truss to see what's going on.
Ah hah! That got it. vacuum is creating temporary files in /tmp, but on
the computers in question /tmp is mounted on a really small file system
and it's getting filled by whatever vacuum is doing there. Thanks!
Doesn't explain the occasional segfault, but I can't reproduce those
easily. I'll keep my eye out. Probably something that only happens in
the out-of-disk-space code path, so I might not see it again after I'm
not running out of disk space. OK, great, thanks again.
-Kipp
--- Kipp Cannon <[EMAIL PROTECTED]> wrote:
I have some database files, and I'm getting reproducible "disk I/O error"
problems when trying to vacuum them. Occasionally I'll get a segfault or
bus error. This is with sqlite 3.4.1 and 3.4.2 and gcc 4.0.2.
There is no "real" disk I/O error: there's plenty of disk space, and I'm
able to read the files without any problem, and I can copy them around to
different computers and get the same error message.
____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
