On 2020-10-05 18:46, Patrick Goetz wrote:
We had a similar problem with Firefox, most notably with Mac OSX users
who have NFS-mounted home directories. There's an about:config
solution for Firefox; namely set
storage.nfs_filesystem: true
This forces a specific network file locking mechanism which makes
sqlite behave better. I'm guessing google chrome has something similar.
Since I have used chrome for years without any problems my guess it that
its something that changed with nfs in my setup.
I did a strace and the first -EIO I get look like this
fdatasync(94</home/kenjo/.config/google-chrome/Default/Login Data>) = -1
EIO (Input/output error)
then the same thing happens for other files like
fdatasync(83</home/kenjo/.config/google-chrome/Default/Web Data>) = -1
EIO (Input/output error)
fdatasync(74</home/kenjo/.config/google-chrome/Default/History>) = -1
EIO (Input/output error)
On 10/4/20 6:53 AM, Kenneth Johansson wrote:
So I have had for a long time problems with google chrome and suspend
resume causing it to mangle its sqlite database.
it looks to only happen if I use nfs mounted home directory. I'm not
sure exactly what is happening but lets first see if this happens to
anybody else.
How to get the error.
1. start google from a terminal with "google-chrome"
2. suspend the computer
3. wait a while. There is some type of minimum time here I do not
know what its is but I basically get the error every time of I
suspend in evening and resume in morning
4. look for printout that looks like something like this
[16789:18181:1004/125852.529750:ERROR:database.cc(1692)] Passwords
sqlite error 1034, errno 5: disk I/O error, sql: COMMIT
[16789:16829:1004/125852.529744:ERROR:database.cc(1692)] Web sqlite
error 1034, errno 5: disk I/O error, sql: COMMIT
[16789:16829:1004/125852.530261:ERROR:database.cc(1692)] Web sqlite
error 1034, errno 5: disk I/O error, sql: INSERT OR REPLACE INTO
autofill_model_type_state (model_type, value) VALUES(?,?)
[16789:16789:1004/125852.563571:ERROR:sync_metadata_store_change_list.cc(34)]
Autofill datatype error was encountered: Failed to update
ModelTypeState.
[16789:19002:1004/125902.534103:ERROR:database.cc(1692)] History
sqlite error 1034, errno 5: disk I/O error, sql: COMMIT
[16789:19002:1004/125902.536903:ERROR:database.cc(1692)] Thumbnail
sqlite error 778, errno 5: disk I/O error, sql: COMMIT
[16789:19002:1004/130044.120379:ERROR:database.cc(1692)] Passwords
sqlite error 1034, errno 5: disk I/O error, sql: INSERT OR REPLACE
INTO sync_model_metadata (id, model_metadata) VALUES(1, ?)
[16789:16829:1004/130044.120388:ERROR:database.cc(1692)] Web sqlite
error 1034, errno 5: disk I/O error, sql: INSERT OR REPLACE INTO
autofill_model_type_state (model_type, value) VALUES(?,?)
and so on. if you use google sync you can also check
"chrome://sync-internals" to see if something is wrong with the
database.
This message is from an external sender. Learn more about why this <<
matters at https://links.utexas.edu/rtyclf. <<
