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.
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. ; <<
