On Fri, Jul 9, 2010 at 3:21 PM, Jim Wilcoxson <pri...@gmail.com> wrote:
> On Fri, Jul 9, 2010 at 10:38 AM, Ke Tao <kota...@gmail.com> wrote: > >> >> HI All , >> >> I have sqlite db name "wdb" and "wdb-journal" file was created by power >> failure something , when I do any db operation sqlite always prompt "disk >> I/O error" , but when I delete the "wdb-journal" ,there is no errors >> prompted. I think maybe the wdb-journal file was corrupted , does anyone >> have any idea on this ? >> I used sqlite on linux system. >> >> Best Regards, >> Ke Tao >> > > Permission problems can cause this. The "disk I/O error" actually means "I > can't do a rollback", maybe because root created the journal and owns the > database, then another user is trying to do things with it. Just a guess. > This "disk I/O error" message is very confusing. Been there! > > Jim > -- > HashBackup: easy onsite and offsite Unix backup > http://sites.google.com/site/hashbackup > Also, by deleting the journal, you are likely to corrupt your database. You can't delete the journal! Jim _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users