SyncDirectory sqlite error 1, errno 0: cannot rollback - no transaction is active, sql: ROLLBACK |
|||||||||
Issue descriptionUserAgent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.40 Safari/537.36 Steps to reproduce the problem: As explained in https://bugs.chromium.org/p/chromium/issues/detail?id=738961 I get all kinds of unexpected errors in chrome after a crash on my laptop. However when I opened that other bug, I said I had sqlite issues while in fact I posted logs showing leveldb issues. However, here is one with sqlite which I posted on chrome-discuss@ and where Primiano suggested that I open a bug. I will paste the logs from that Email, showing sqlite issues. To be honest, I think the sqlite issues are likely less common but chrome outputs so many lines of warnings and errors every time I restart it that I've kind of stopped paying attention to which ones were which (sorry), so maybe sqlite issues are actually very rare. What is the expected behavior? What went wrong? [16822:16921:0703/113309.832253:ERROR:connection.cc(1954)] SyncDirectory sqlite error 1802, errno 0: disk I/O error, sql: INSERT OR REPLACE INTO metas ( metahandle, base_version, server_version, local_external_id, transaction_version, mtime, server_mtime, ctime, server_ctime, id, parent_id, server_parent_id, is_unsynced, is_unapplied_update, is_del, is_dir, server_is_dir, server_is_del, non_unique_name, server_non_unique_name, unique_server_tag, unique_client_tag, unique_bookmark_tag, specifics, server_specifics, base_server_specifics, server_unique_position, unique_position, attachment_metadata, server_attachment_metadata ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) [16822:16921:0703/113309.832328:ERROR:connection.cc(1954)] SyncDirectory sqlite error 1, errno 0: cannot rollback - no transaction is active, sql: ROLLBACK [16822:16851:0703/113309.919971:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113310.921689:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113311.923007:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113312.932979:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113313.933809:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113314.941802:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113315.948908:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113316.958493:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113317.966084:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113318.974455:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16921:0703/113319.832149:ERROR:connection.cc(1954)] SyncDirectory sqlite error 1802, errno 0: disk I/O error, sql: INSERT OR REPLACE INTO metas ( metahandle, base_version, server_version, local_external_id, transaction_version, mtime, server_mtime, ctime, server_ctime, id, parent_id, server_parent_id, is_unsynced, is_unapplied_update, is_del, is_dir, server_is_dir, server_is_del, non_unique_name, server_non_unique_name, unique_server_tag, unique_client_tag, unique_bookmark_tag, specifics, server_specifics, base_server_specifics, server_unique_position, unique_position, attachment_metadata, server_attachment_metadata ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) [16822:16921:0703/113319.832194:ERROR:connection.cc(1954)] SyncDirectory sqlite error 1, errno 0: cannot rollback - no transaction is active, sql: ROLLBACK [16822:16851:0703/113319.983192:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113320.993604:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113322.001722:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113323.010231:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113324.020272:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113325.023336:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113326.029147:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113327.030731:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113328.032124:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113329.041811:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16921:0703/113329.832522:ERROR:connection.cc(1954)] SyncDirectory sqlite error 1802, errno 0: disk I/O error, sql: INSERT OR REPLACE INTO metas ( metahandle, base_version, server_version, local_external_id, transaction_version, mtime, server_mtime, ctime, server_ctime, id, parent_id, server_parent_id, is_unsynced, is_unapplied_update, is_del, is_dir, server_is_dir, server_is_del, non_unique_name, server_non_unique_name, unique_server_tag, unique_client_tag, unique_bookmark_tag, specifics, server_specifics, base_server_specifics, server_unique_position, unique_position, attachment_metadata, server_attachment_metadata ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) [16822:16921:0703/113329.832573:ERROR:connection.cc(1954)] SyncDirectory sqlite error 1, errno 0: cannot rollback - no transaction is active, sql: ROLLBACK [16822:16851:0703/113330.043314:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113331.053232:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113332.054743:ERROR:value_store_frontend.cc(55)] Error while writing anadfmbemnidomdljfcdgdoomhghoclk.browser_action to [16822:16851:0703/113333.064469:ERROR:value_store_frontend.cc(55)] Error while writing elicpjhcidhpjomhibiffojpinpmmpil.browser_action to [16822:16851:0703/113334.073069:ERROR:value_store_frontend.cc(55)] Err Did this work before? No Chrome version: 60.0.3112.40 Channel: beta OS Version: debian/testing Flash Version:
,
Jul 7 2017
The issue seems to be out of TE-scope. Hence, adding label TE-NeedsTriagehelp for further investigation. Thanks...!!
,
Jul 11 2017
,
Jul 11 2017
Oh, hey, I didn't realize you're a Googler. Sweet! I can ask for more data :D Can you please zip your entire profile, upload it to a Drive, and share it with me (costan@google.com)? Your profile path should show up under "Profile Path" in chrome://version/. Based on Issue 738961 , it seems like your profile is at /var/change/merlin-change/.config/google-chrome-dir/google-chrome-beta/Default/
,
Jul 12 2017
,
Jul 12 2017
Sorry for the short delay, it was a big-ish archive (1GB after tar.bz2). I've shared the link with you directly. However my profile is in an ok state right now, so you may just end up with totally clean files. If that's the case, you could close this as not reproducible, and next time my laptop crashes (good news is that it hasn't right now, maybe thanks to the hyperthreading microcode fix I applied), I'll tar up my profile before restarting chrome.
,
Jul 12 2017
mmmh, maybe I need to reply with this email for needs feedback to go away.
,
Jul 12 2017
Thank you for providing more feedback. Adding requester "pwnall@chromium.org" to the cc list and removing "Needs-Feedback" label. For more details visit https://www.chromium.org/issue-tracking/autotriage - Your friendly Sheriffbot
,
Jul 26 2017
,
Jul 28 2017
@pwnall: Could you please respond to comment #7. Thank You!
,
Aug 9 2017
@pwnall -- Could you please provide the updates on this issue if we have any. Thanks!
,
Sep 5 2017
@pwnall et all: I just had my laptop crash and refuse to reopen the saved profile, saying it was corrupted. It could totally be a different problem, but it's in the same class. I opened https://bugs.chromium.org/p/chromium/issues/detail?id=762027 , please have a look
,
Nov 2 2017
pwnall@, Friendly ping to get an update on this issue as there was no update for the past few months. Thanks in advance..!
,
Nov 10 2017
Since this seems to be profile specific and already being investigated by pwnall@, adding 'TE-NeedsTriageHelp' to move this out of TE Unconfirmed triaging bucket and requesting to please help in further debugging of this or Issue 762027.
,
Nov 10 2017
Sorry, everyone! I unfortunately didn't have time to look at this yet.
,
Nov 12
Issue has not been modified or commented on in the last 365 days, please re-open or file a new bug if this is still an issue. For more details visit https://www.chromium.org/issue-tracking/autotriage - Your friendly Sheriffbot |
|||||||||
►
Sign in to add a comment |
|||||||||
Comment 1 by merlin@google.com
, Jul 6 2017