Issue 126590 in chromium: sync broken on my chromebox

[chro...@googlecode.com]

Status: Assigned
Owner: tmc...@chromium.org
CC: ko...@chromium.org, anna...@chromium.org, zeli...@chromium.org
Labels: Type-Bug Pri-2 Area-UI OS-Chrome Feature-Sync

New issue 126590 by kan...@chromium.org: sync broken on my chromebox
http://code.google.com/p/chromium/issues/detail?id=126590

here's my chrome:sync info

Summary
Summary Unrecoverable error detected
Version Info
Client Version Google Chrome Chrome OS 20.0.1123.3 (135005) dev
Server URL https://clients4.google.com/chrome-sync/dev
Credentials
Client ID none
Username kan...@google.com
Sync Token Available true
Local State
Last Synced 3 days ago
Sync First-Time Setup Complete true
Initial Download Complete false
Sync Backend Initialized false
Syncing false
Network
Throttled false
Notifications Enabled false
Encryption
Passphrase Required false
Cryptographer Ready false
Cryptographer Has Pending Keys false
Encrypted Types
Status from Last Completed Session
Sync Source UNKNOWN
Download Updates UNSET
Post Commit UNSET
Process Commit Response UNSET

Running Totals
Notifications Received 0
Cycles Without Updates 0
Cycles With Updates 0
Cycles Without Commits 0
Cycles With Commits 0
Cycles Without Commits or Updates 0
Cycles With Commit or Update 0
Updates Downloaded 0
Tombstone Updates 0
Reflected Updates 0
Conflict Resolved: Client Wins 0
Conflict Resolved: Server Wins 0
Transient Counters (this cycle)
Unsynced Count (before commit) 0
Encryption Conflicts 0
Hierarchy Conflicts 0
Simple Conflicts 0
Server Conflicts 0
Committed Items 0
Updates Remaining 0
Transient Counters (last cycle of last completed session)
Updates Downloaded 0
Committed Count 0
Entries 0
Routing Info
Unrecoverable error detected at
chrome/browser/sync/profile_sync_service.cc[659] OnBackendInitialized :
BackendInitialize failure

[chro...@googlecode.com]

Updates:
Owner: rlaroc...@chromium.org
Labels: Mstone-20

Comment #1 on issue 126590 by tmc...@chromium.org: sync broken on my
chromebox
http://code.google.com/p/chromium/issues/detail?id=126590

Richard, you'd posted about the ordering of backend initialization back a
couple months ago. Any thoughts here? Have you seen this error before?

[chro...@googlecode.com]

Comment #3 on issue 126590 by rlaroc...@chromium.org: sync broken on my
chromebox
http://code.google.com/p/chromium/issues/detail?id=126590

I believe this is a case of directory corruption. This type of error looks
different since Tim reduced the severity of these errors to
UnrecoverableErrors. I'm tempted to ask for a copy of the database, but
that database is likely to contain private information.

kanliu: Can you save a backup copy of your profile directory for debugging
purposes? I'd like to get you to run a few SQL commands on the database to
debug the cause of this issue.

This issue should go away if you log out and log back into sync. Doing so
will delete all your local data, so I'd appreciate it if you backed up that
data first.

[chro...@googlecode.com]

Updates:
Owner: kan...@chromium.org
Labels: -Mstone-21 Mstone-22 Action-FeedbackNeeded

Comment #4 on issue 126590 by rlaroc...@chromium.org: sync broken on my
chromebox
http://code.google.com/p/chromium/issues/detail?id=126590

Sorry for the delay, this bug fell off my radar for a bit.

If you still have the old profile directory, could you try running the
following queries on your SyncData.sqlite3 file from the corrupt profile?
You can find it in your user-data-dir under '$PROFILE_NAME/Sync
Data/SyncData.sqlite3'.

select * from metas where next_id not in (select id from metas);
select * from metas where prev_id not in (select id from metas);
select * from metas where parent_id not in (select id from metas);

They should return nothing on a healthy database, so it may be the case
that you see no results.

(Also bumping to M22, since I doubt this will be fixed before the cutoff
point.)

[chro...@googlecode.com]

Updates:
Owner: rlaroc...@chromium.org

Comment #5 on issue 126590 by kan...@chromium.org: sync broken on my
chromebox
http://code.google.com/p/chromium/issues/detail?id=126590

unfortunately, my box was not in dev mode so i couldn't get a shell to run
those queries. i've since switched to dev mode but unfortunately it wiped
my device so i don't have that profile anymore. i can reopen this bug if i
run into it again, do you want me to close this bug for now? or do you have
other ideas/ways to investigate this in the mean time?

[chro...@googlecode.com]

Comment #7 on issue 126590 by rlaroc...@chromium.org: sync broken on my
chromebox
http://code.google.com/p/chromium/issues/detail?id=126590

Closing. There's nothing more we can investigate here.

This bug is either related to sync bugs (like issue 125301) or sqlite
corruption (as in issue 132999). We have no way to figure out which it is,
though.

Thanks for the report. If this happens again, please preserve your profile
directory and file a new bug.

[chro...@googlecode.com]

Updates:
Status: WontFix

Comment #8 on issue 126590 by rlaroc...@chromium.org: sync broken on my
chromebox
http://code.google.com/p/chromium/issues/detail?id=126590

(No comment was entered for this change.)