Unable to sync. Report ID: 84878493

bill@whirlwindwheelc
Report ID: 84878493

I've had trouble syncing for the last 3-4 days. When I tried again today, I received 50 conflict errors which I went through, selecting the appropriate version for each citation. Yesterday I went through 25 conflict resolutions. Both times the sync did not complete and I received the following error message:

[Exception... "Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]" nsresult: "0x80630003 (NS_ERROR_STORAGE_CONSTRAINT)" location: "JS frame :: chrome://zotero/content/xpcom/data/tag.js :: <TOP_LEVEL> :: line 423" data: no] [ERROR: columns itemID, tagID are not unique]

1.) Could not read chrome manifest file 'C:\Program Files (x86)\Mozilla Firefox\extensions\{972ce4c6-7e08-4474-a285-3208198ce6fd}\chrome.manifest'.

2.) [JavaScript Error: "uncaught exception: [Exception... "Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]" nsresult: "0x80630003 (NS_ERROR_STORAGE_CONSTRAINT)" location: "JS frame :: chrome://zotero/content/xpcom/data/tag.js :: <TOP_LEVEL> :: line 423" data: no] [ERROR: columns itemID, tagID are not unique]"]

Report ID: 84878493

Any assistance with this would be greatly appreciated. Thanks!
  • dstillman
    edited August 26, 2011
    Try the latest 2.1 Branch dev XPI. If that works, you should be able to switch back to the main release after syncing.
  • bill@whirlwindwheelc
    Report ID: 993400162

    Dan, thanks for your suggestion. I did try the 2.1 dev XPI and it resulted in running version 2.1.9.r10253 rather than the original 2.1.8 version of Zotero I had been using. Is this as is it should be? After working my way through 124 conflict resolutions, the sync did not complete and I got the following error message.

    [Exception... "Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]" nsresult: "0x80630003 (NS_ERROR_STORAGE_CONSTRAINT)" location: "JS frame :: chrome://zotero/content/xpcom/data/tag.js :: <TOP_LEVEL> :: line 423" data: no] [ERROR: insert on table "itemTags" violates foreign key constraint "fki_itemTags_libraryID"]

    Additionally, there were several pages of error statements beginning with "Security Error: Content at Zotero ..." following the initial error statement. I can provide these to you if you need them. Any advice at this point would be appreciated.

    Thanks.
  • dstillman
    Restart Firefox and provide a Debug ID for the sync attempt using the branch XPI.
  • dstillman
    Out of curiosity, what are the conflicts that are showing up? Do you see real differences between the versions? You can start with a Debug ID just up to the first conflict, at which point you can cancel.
  • bill@whirlwindwheelc
    Dan, thanks for you quick reply. Previously, with some conflict resolutions we had a difficult time discerning what the different was between the two versions, however, nearly all of these have distinct and intentional differences. My colleagues and I are making changes to the information in the language fields and the rights fields (among others) for our citations. These are changes we need to maintain. I'll take a look at the DeBug ID and see if I can get that started. Thanks!
  • bill@whirlwindwheelc
    The Debug ID is D117593222

    Dan I'm not sure if this ran long enough for you to get the information you need. Pleases let me know if I need to do it again.

    Thanks
  • dstillman
    No. That doesn't show anything. We'll need debug output for the entire sync session, up to the error.
  • dstillman
    edited August 30, 2011
    Your client is performing a full sync, though, and the debug output may be too big to submit, so if you have to go through the same conflicts each time you might want to hold off before you try. We're in the process of updating the debug output feature to limit the size of data it tries to send. I'll post here when that's ready.
  • dstillman
    OK, please install the latest 2.1 branch dev XPI and then submit debug output for the complete sync attempt, up to the error.
  • bill@whirlwindwheelc
    Dan,
    2.1 branch dev XPI installed already, For debug - logged 750153 lines (up to the appearance of the 1st conflict resolution) hit the submit to Zotero Server button and got a pop-up that said "Invalid Response From Server"

    What's next?

    Thanks
  • dstillman
    No, you need the latest version of the 2.1 branch XPI. Go to Tools -> Add-ons -> Extensions, click the gear menu in the top right, and select Check for Updates. Then update to the latest version.
  • bill@whirlwindwheelc
    Dan, thank you for the specifics provided above. I am now running Zotero version 2.1.9r10253. Tried to sync and create a Debug ID but each time I got the following error message:

    'The Zotero sync server did not accept your username and password.Please check that you have entered your zotero.org login information correctly in the Zotero sync preferences.'

    I reentered my user name and password in the preferences and checked to make sure my password still allowed me to log into the Zotero website - and it did.

    I tried the process 2 or 3 times more after restarting Firefox - all had the same result.

    I submitted the Debug ID to the server on the last attempt.

    The Debug ID is D1898901278.

    Thanks for you assistance on this.
  • dstillman
    Sorry about that—bug in the dev build. Grab the latest (2.1.9.r10346) and try again.
  • bill@whirlwindwheelc
    Dan, I updated and got Zotero Version 2.1.9.r10346. Started Sync process with Debug output logging enabled. When the first conflict resolution popped up I hit the Submit to Zotero Server button(at line 500440). I got a pop-up that said 'Invalid response from server' and no Debug ID was provided. Please advise.

    Thanks.
  • dstillman
    Type about:config into the Firefox address bar, click through the warning if one appears, and search for extensions.zotero.debug.store.submitLimit. Set that to, say, 50000, and then try submitting debug output. If that doesn't work, try something lower.
  • bill@whirlwindwheelc
    Dan, nothing so far:

    1st attempt
    Submit Limit set at 50,000
    Invalid Response from Server
    Lines logged 502898

    2nd attempt
    Submit Limit set at 40,000
    Invalid Response from Server
    Line logged 500262

    3rd attempt
    Submit Limit set at 30,000
    Invalid Response from Server
    Lines logged 500855

    In each case I hit send to server when the 1st conflict error popped up. Also, not sure if this matters, but the number of lines logged increases immediately when the first conflict error comes up (i.e. from ~120 lines to ~500,000)

    Please confirm if I need to continue with process or not. Also, can I reduce the limit more than 10,000 for each attempt?

    Thanks.
  • dstillman
    Try changing extensions.zotero.debug.store.submitLineLength to 1000 (instead of 10000).
  • bill@whirlwindwheelc
    Dan,

    4th attempt
    Submit Limit set at 1,000
    The Debug ID is D145930856.
    Line logged 502972

    What’s next?

    Thanks
  • dstillman
    No, not submitLimit—submitLineLength. Keep submitLimit at 50000.
  • dstillman
    (Just to clarify, these limits are a new feature I added to the branch to help debug issues such as yours, when there's otherwise too much debug output to submit. So we just need to figure out values that will allow you to submit the output, and then we can get back to figuring out what's wrong with your syncing.)
  • bill@whirlwindwheelc
    Dan,

    Please check #9 below for the Debug ID. I progressively decreased extensions.zotero.debug.store.submitLimit from 50000 to 10000 to get this. I hope this provides the information that you need to move forward on this.

    Thanks


    5th attempt
    Settings:
    extensions.zotero.debug.store.submitLimit 50000
    extensions.zotero.debug.store.submitLineLength 1000
    Invalid response from server
    Lines logged: 500723

    6th attempt
    Settings:
    extensions.zotero.debug.store.submitLimit 40000
    extensions.zotero.debug.store.submitLineLength 1000
    Invalid response from server
    Lines logged: 501392

    7th attempt
    Settings:
    extensions.zotero.debug.store.submitLimit 30000
    extensions.zotero.debug.store.submitLineLength 1000
    Invalid response from server
    Lines logged: 500133

    8th attempt
    Settings:
    extensions.zotero.debug.store.submitLimit 20000
    extensions.zotero.debug.store.submitLineLength 1000
    Invalid response from server
    Lines logged: 500739

    9th attempt
    Settings:
    extensions.zotero.debug.store.submitLimit 10000
    extensions.zotero.debug.store.submitLineLength 1000
    The Debug ID is D1491576736.
    Lines logged: 501595
  • dstillman
    edited September 2, 2011
    OK, now that we've found limit values that work for you, you'll need to reproduce the error, with debug output running, and then submit the output immediately afterward.

    Note, too, that the limit—which just controls how much of the output gets sent to us—takes effect only when you try to submit the output, so there's no need to perform the action more than once if you're having trouble submitting. Just adjust it down until the submission goes through.
  • bill@whirlwindwheelc
    Dan, by reproducing the error, I assumed you meant that I should run the full sync (including going through all of the conflict resolutions) and continuing to the point where the sync stops and the red exclamation point appears next to the sync arrow.

    I am still using Version 2.1.9.r10389. I ran a sync with the Debug Output enabled and I selected my way through 243 conflict errors. Additional pop-ups appeared noting various changes to citations and then the sync continued a while longer. Much to my surprise, this time, the sync completed with no error message. I clicked on the Submit to Zotero server and got the pop-up that says Invalid response from server.

    Do I need to do this differently to reproduce the error or is this now working as it should. Please advise.

    Thanks.
  • dstillman
    No, if it's working now, don't worry about it. Let us know if you run into further trouble.
  • bill@whirlwindwheelc
    Dan, should I continue with Zotero version 2.1.9r10253 or do I need to go to another version? If so what version? Also, do I continue with extensions.zotero.debug.store.submitLimit set at 10000 and extensions.zotero.debug.store.submitLineLength set at 1000, or do I need to go back to the default values? If so, what are the default values or the recommended settings for each?

    Thanks
Sign In or Register to comment.