Component returned failure code

Jon Rubin
error code 566681700

[JavaScript Error: "[Exception... "'[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageStatement.execute]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: anonymous :: line 123" data: no] [QUERY: INSERT INTO tags (tagID, name, type, dateModified, key) VALUES (?, ?, ?, ?, ?)] [ERROR: constraint failed]' when calling method: [nsIDOMEventListener::handleEvent]" nsresult: "0x8057001e (NS_ERROR_XPC_JS_THREW_STRING)" location: "<unknown>" data: no]"]

portable firefox, zotero 1.5a1r3316


zotero(3): Saving tag 11756

zotero(5): INSERT INTO tags (tagID, name, type, dateModified, key) VALUES (?, ?, ?, ?, ?)

zotero(5): Binding parameter 1 of type int: 11756

zotero(5): Binding parameter 2 of type string: "Deinstitutionalisation "

zotero(5): Binding parameter 3 of type int: 0

zotero(5): Binding parameter 4 of type string: "2008-09-01 17:22:05"

zotero(5): Binding parameter 5 of type string: "8PXGZVNP"

zotero(5): Flagging nested transaction for rollback

zotero(5): Rolling back transaction

zotero(3): Resetting Notifier event queue

zotero(3): Releasing session lock

zotero(3): HTTP POST version=2&sessionid=bf271d2af1ece356b76253e6b7d7f210 to https://sync.zotero.org/unlock
  • dstillman
    Can you verify that this still occurs in 3317? Is this occurring during a sync or at another time? Do you have an existing "Deinstitutionalisation" tag (with or without a trailing space (which appears not to be being stripped currently))?
  • Jon Rubin
    edited September 1, 2008
    Hi Dan, switched to Ubuntu from windows as the time for the debug was just getting too painful.
    I do have the "Deinstitutionalisation" tag - I've deleted the trailing space and will try again.
    Updated to 3317. I'm not getting exactly the same error

    590359806

    [JavaScript Error: "tag.getLinkedItems is not a function" {file: "chrome://zotero/content/xpcom/sync.js" line: 2543}]


    zotero(3): HTTP POST version=2&sessionid=d7715a65a3c19531fe0912c02c4f4eab to https://sync.zotero.org/unlock

    zotero(1): 'message' => "tag.getLinkedItems is not a function"
    'fileName' => "chrome://zotero/content/xpcom/sync.js"
    'lineNumber' => 2543
    'stack' => "_deleteConflictingTag("Deinstitutionalisation ",0,[object Object])@chrome://zotero/content/xpcom/sync.js:2543
    processUpdatedXML([object XML],[object Date],[object Object])@chrome://zotero/content/xpcom/sync.js:1628

    [extra output removed by Dan]

    "
    'name' => "TypeError"


    zotero(3): <?xml version="1.0"?>
    <response version="2" timestamp="1220303867"><unlocked/></response>


    zotero(3): HTTP POST error=true&errorData=%5BJavaScript%20Error%3A%20%22tag.getLinkedItems%20is%20not%20a%20function%22%20%7Bfile%3A%20%22chrome%3A%2F%2Fzotero%2Fcontent%2Fxpcom%2Fsync.js%22%20line%3A%202543%7D%5D&extraData=&diagnostic=version%20%3D%3E%201.5a1.r3317%2C%20platform%20%3D%3E%20Linux%20i686%2C%20locale%20%3D%3E%20en-GB%2C%20appName%20%3D%3E%20Firefox%2C%20appVersion%20%3D%3E%203.0.1%2C%20extensions%20%3D%3E%20Firefox%20(en-GB)%20(3.0.1%2C%208)%2C%20Ubuntu%20Firefox%20Modifications%20(0.5)%2C%20Xulrunner%20(en-GB)%20(1.9.0.1%2C%208) to http://www.zotero.org/repo/report


    And then Firefox died on me.
    I can try killing that tag and see if that work?
    Regards, Jon.
  • dstillman
    Do you have the debug output directly above that (or can you reproduce it reliably between Firefox restarts)? Deleting the tag would probably fix it, but it might also prevent us from being able to test a possible fix.
  • Jon Rubin
    edited September 1, 2008
    Hi Dan, no sorry didn't keep the data and can't reproduce it.
    Do have a nice new shiny error though (actually after looking at the javascript, maybe it is the same / similar /related and I am reproducing it!).
    I've saved the debug output this time, so if you need more, let me know and I can post it or email it to you.

    588166919

    [JavaScript Error: "[Exception... "'Invalid response from server' when calling method: [nsIDOMEventListener::handleEvent]" nsresult: "0x8057001e (NS_ERROR_XPC_JS_THREW_STRING)" location: "<unknown>" data: no]"]



    zotero(5): REPLACE INTO version VALUES ('lastremotesync', ?)

    zotero(5): Binding parameter 1 of type int: 1220316566

    zotero(5): Committing transaction

    zotero(3): Resetting Notifier event queue

    zotero(3): HTTP POST 400019 bytes to https://sync.zotero.org/upload?gzip=1 (gzipped from 2829772 bytes; 86% savings)

    zotero(3): Server error (22ebd89cb7)

    Error: Incorrect string value: '\xE2\x80' for column 'title' at row 1

    Query: INSERT INTO itemNotes
    (userID, itemID, sourceItemID, note, title) VALUES
    (?,?,?,?,?)

    Params: Array
    (
    [0] => 82
    [1] => 4414
    [2] => 2275
    [3] => 4 Yet I do not reduce politics to a mere agonistic schema where the ↑content↓ is irrelevant. I am far away from the Sch
    mittian formalisation of antagonism. Politics, I argue, has its own universal, its own measure that is equality. The measure never
    applies directly. It does so only through the enactment of a wrong. However, not every wrong is necessarily political. It has bee
    n argued against my theses that there also anti-democratic forms of protest among the oppressed, shaped by religious fanaticism or
    ethnic identitarianism and intolerance. Ernesto Laclau put this as the blind spot of my conceptualisation of dissensus.

    But it is clear that in my view a wrong is political when it enacts the basis of political action, which is the mere contingency o
    f equality, which is evidently not the case of ↑popular↓ movements asking for the purity of the blood, the power of religion and s
    o on. But I also refuse a widespread tendency to stigmatize any form of protest under the name of ↑populism↓. The concept of ↑popu
    lism↓ is a hotchpotch which allows old Marxists and young liberals at once to put in the same basket struggles for maintaining the
    welfare system and ethnic or religious riots.
    [4] => 4 Yet I do not reduce politics to a mere agonistic schema where the ↑contenty
    )


    zotero(3): Releasing session lock

    zotero(3): HTTP POST version=2&sessionid=5926ddefc74862064ef442ff564dd7b6 to https://sync.zotero.org/unlock

    zotero(1): Invalid response from server

    zotero(3): <?xml version="1.0"?>
    <response version="2" timestamp="1220316771"><unlocked/></response>
  • Jon Rubin
    OK, deleted the note which seemed to be causing the problem (not a long term solution obviously!) and it seemed to sync OK - so why doesn't it like the note? I put it back in and Zotero sync died immediately. So it's definitely the note.
    On a probably unrelated issue: I had some dodgy e graves back in my data which caused the sync to choke until I cleaned them out. This had been fixed a while back?

    http://forums.zotero.org/discussion/3432/typeerror-oldidsmap-is-not-a-function/#Item_7
  • Jon Rubin
    Hi Dan, OK got the "deinstitutionaisation" tag bug again. dev build 3326.
    Don't think the first two errors are anything to do with Zotero but included them just in case.
    1412387539

    Failed to load XPCOM component: /usr/lib/xulrunner-1.9.0.1/components/pyabout.py

    Failed to load XPCOM component: /usr/lib/xulrunner-1.9.0.1/components/libpyloader.so

    [JavaScript Error: "[Exception... "'[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageStatement.execute]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: anonymous :: line 123" data: no] [QUERY: INSERT INTO tags (tagID, name, type, dateModified, key) VALUES (?, ?, ?, ?, ?)] [ERROR: constraint failed]' when calling method: [nsIDOMEventListener::handleEvent]" nsresult: "0x8057001e (NS_ERROR_XPC_JS_THREW_STRING)" location: "<unknown>" data: no]"]

    I saved the debug output and can send you it if you want but hopefully this is all you need:


    zotero(5): Binding parameter 2 of type string: "Eternal return"

    zotero(5): Binding parameter 3 of type int: 0

    zotero(5): Binding parameter 4 of type string: "2008-09-03 11:36:34"

    zotero(5): Binding parameter 5 of type string: "6TND4CI5"

    zotero(5): INSERT INTO itemTags (itemID, tagID) VALUES (?,?)

    zotero(3): Notifier.trigger('modify', 'item', [7565,1723785]) queued

    zotero(5): Decreasing transaction level to 1

    zotero(3): Notifier.trigger('add', 'tag', [11727]) queued

    zotero(5): Transaction in progress -- increasing level to 2

    zotero(5): SELECT COUNT(*) FROM tags WHERE tagID=?

    zotero(5): Binding parameter 1 of type int: 11756

    zotero(3): Saving tag 11756

    zotero(5): INSERT INTO tags (tagID, name, type, dateModified, key) VALUES (?, ?, ?, ?, ?)

    zotero(5): Binding parameter 1 of type int: 11756

    zotero(5): Binding parameter 2 of type string: "Deinstitutionalisation "

    zotero(5): Binding parameter 3 of type int: 0

    zotero(5): Binding parameter 4 of type string: "2008-09-01 22:35:07"

    zotero(5): Binding parameter 5 of type string: "DEWMZH77"

    zotero(5): Flagging nested transaction for rollback

    zotero(5): Rolling back transaction

    zotero(3): Resetting Notifier event queue

    zotero(3): Releasing session lock

    zotero(3): HTTP POST version=2&sessionid=230eefed6a6481dd2100a784ea489695 to https://sync.zotero.org/unlock

    zotero(1): [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageStatement.execute]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: anonymous :: line 123" data: no] [QUERY: INSERT INTO tags (tagID, name, type, dateModified, key) VALUES (?, ?, ?, ?, ?)] [ERROR: constraint failed]

    zotero(3): <?xml version="1.0"?>
    <response version="2" timestamp="1220442113"><unlocked/></response>
  • Jon Rubin
    This seems to be happening again - and I can't correct it because tag editing seems to be broken. I was trying to see if I could sync to an empty database and got the following error:

    zotero(3): Saving tag 11756

    zotero(5): INSERT INTO tags (tagID, name, type, dateModified, key) VALUES (?, ?, ?, ?, ?)

    zotero(5): Binding parameter 1 of type int: 11756

    zotero(5): Binding parameter 2 of type string: "Deinstitutionalisation "

    zotero(5): Binding parameter 3 of type int: 0

    zotero(5): Binding parameter 4 of type string: "2008-09-16 00:40:56"

    zotero(5): Binding parameter 5 of type string: "TH648JGV"

    zotero(5): Flagging nested transaction for rollback

    zotero(1): [Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageStatement.execute]" nsresult
    : "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: anonymous :: line 123" data: no]
    [QUERY: INSERT INTO tags (tagID, name, type, dateModified, key) VALUES (?, ?, ?, ?, ?)] [ERROR: constraint failed]

    zotero(5): Rolling back transaction

    zotero(3): Resetting Notifier event queue


    report id. 1127509202
  • dstillman
    Issues with leading and trailing spaces should be fixed in SP3, now available.

This is an old discussion that has not been active in a long time. Instead of commenting here, you should start a new discussion. If you think the content of this discussion is still relevant, you can link to it from your new discussion.