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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users