Import from .nbib (PMID Export) repeated failures

Multiple attempts to import collections exported from PMID

Sample Report ID: 1961950917

Client is fully synced with Web; running updated Beta version
  • can you reproduce this with a minimal example (e.g., just the first entry from an .nbib) file? Import of .nbib works in general in the beta.
  • Original logging:

    07:50:45.391 Storing invalid field 'place' for type journalArticle in Extra for item 1/null 180
    07:50:55.703 Transaction timeout, most likely caused by unresolved pending work. Sqlite.jsm:1036
    07:51:20.523 item.isRegularItem is not a function retractions.js:841
    07:51:22.784 Component returned failure code: 0x8052000e (NS_ERROR_FILE_IS_LOCKED) [mozIStorageService.backupDatabaseFile] db.js:1058
    07:51:22.969 Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: INSERT OR REPLACE INTO itemTags (itemID, tagID, type) VALUES (?, ?, ?)] [PARAMS: 249821, 30318, 0] [ERROR: FOREIGN KEY constraint failed] db.js:686
    07:55:57.806 Component returned failure code: 0x8052000e (NS_ERROR_FILE_IS_LOCKED) [mozIStorageService.backupDatabaseFile] db.js:1058
    07:58:05.606 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{cc1b050e-c1ea-44b0-ab5f-185f008a3628}
    Line Number 1, Column 1: {cc1b050e-c1ea-44b0-ab5f-185f008a3628}:1:1
    07:58:05.747 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{06932cad-727b-41f9-863d-fde41afe65fb}
    Line Number 1, Column 1: {06932cad-727b-41f9-863d-fde41afe65fb}:1:1
    07:58:06.020 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{d7b2bf89-642c-4a6b-a8f3-a5529250137a}
    Line Number 1, Column 1: {d7b2bf89-642c-4a6b-a8f3-a5529250137a}:1:1
    07:58:09.624 Storing invalid field 'place' for type journalArticle in Extra for item 1/null 12
    07:58:10.336 Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: INSERT OR REPLACE INTO itemTags (itemID, tagID, type) VALUES (?, ?, ?)] [PARAMS: 249833, 322413, 0] [ERROR: FOREIGN KEY constraint failed] 2 db.js:686
    07:58:10.764 item.isRegularItem is not a function retractions.js:841
    08:05:09.510 Component returned failure code: 0x8052000e (NS_ERROR_FILE_IS_LOCKED) [mozIStorageService.backupDatabaseFile] 2 db.js:1058
    10:09:19.308 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{d68b86da-16e6-448d-8502-e017cd2a075e}
    Line Number 1, Column 1: {d68b86da-16e6-448d-8502-e017cd2a075e}:1:1
    10:09:19.419 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{a57f82b5-dbd3-4a95-880c-b26580bf1745}
    Line Number 1, Column 1: {a57f82b5-dbd3-4a95-880c-b26580bf1745}:1:1
    10:09:19.686 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{7ea0824a-233e-42a9-ace3-5a4d2d73bda1}
    Line Number 1, Column 1: {7ea0824a-233e-42a9-ace3-5a4d2d73bda1}:1:1
    10:09:23.630 Storing invalid field 'place' for type journalArticle in Extra for item 1/null 11
    10:09:24.920 Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: INSERT OR REPLACE INTO itemTags (itemID, tagID, type) VALUES (?, ?, ?)] [PARAMS: 249844, 322218, 0] [ERROR: FOREIGN KEY constraint failed] 2 db.js:686
    10:09:28.680 item.isRegularItem is not a function retractions.js:841
    10:14:26.046 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{1547c3d4-1efa-4e70-b800-3567de362459}
    Line Number 1, Column 1: {1547c3d4-1efa-4e70-b800-3567de362459}:1:1
    10:14:26.161 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{2e0506a9-fa36-4c08-aff3-d87b45362cc2}
    Line Number 1, Column 1: {2e0506a9-fa36-4c08-aff3-d87b45362cc2}:1:1
    10:14:26.466 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{0348dad4-28da-480b-8fd5-55540118da2a}
    Line Number 1, Column 1: {0348dad4-28da-480b-8fd5-55540118da2a}:1:1
    10:14:30.432 Storing invalid field 'place' for type journalArticle in Extra for item 1/null 5
    10:14:30.931 Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: INSERT OR REPLACE INTO itemTags (itemID, tagID, type) VALUES (?, ?, ?)] [PARAMS: 249849, 331655, 0] [ERROR: FOREIGN KEY constraint failed] 2 db.js:686
    10:14:31.218 item.isRegularItem is not a function retractions.js:841
    10:14:34.283 Missing resource in locale en-AU: toolkit/global/wizard.ftl
    10:14:34.283 Missing resource in locale en-CA: toolkit/global/wizard.ftl
    10:14:34.284 Missing resource in locale en-NZ: toolkit/global/wizard.ftl
    10:41:01.170 Component returned failure code: 0x8052000e (NS_ERROR_FILE_IS_LOCKED) [mozIStorageService.backupDatabaseFile] 3 db.js:1058
    13:19:43.710 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{0480e16c-31be-44e6-8999-daf4e0c3c8e9}
    Line Number 1, Column 1: {0480e16c-31be-44e6-8999-daf4e0c3c8e9}:1:1
    13:19:43.834 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{2e606bae-b3c6-40cb-a93f-ac04a38a9dad}
    Line Number 1, Column 1: {2e606bae-b3c6-40cb-a93f-ac04a38a9dad}:1:1
    13:19:44.085 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{77a6e8d0-7230-48af-9dd9-3bbc4ac45b28}
    Line Number 1, Column 1: {77a6e8d0-7230-48af-9dd9-3bbc4ac45b28}:1:1
    13:19:48.228 Storing invalid field 'place' for type journalArticle in Extra for item 1/null
    13:19:48.704 Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: INSERT OR REPLACE INTO itemTags (itemID, tagID, type) VALUES (?, ?, ?)] [PARAMS: 249850, 331641, 0] [ERROR: FOREIGN KEY constraint failed] 2 db.js:686
    13:19:48.948 item.isRegularItem is not a function retractions.js:841
    13:19:52.534 Missing resource in locale en-AU: toolkit/global/wizard.ftl
    13:19:52.534 Missing resource in locale en-CA: toolkit/global/wizard.ftl
    13:19:52.534 Missing resource in locale en-NZ: toolkit/global/wizard.ftl
    13:24:53.496 Unknown property ‘-moz-binding’. Declaration dropped. zotero.css:1:330737
    13:24:53.500 Expected media feature name but found ‘-moz-bool-pref’. zotero.css:1:428820
    13:24:53.514 stylesheets actor: fetch failed for chrome://zotero-platform-version/content/style.css, using system principal instead. style-sheet.js:178:13
    13:24:53.516 stylesheets actor: fetch failed for chrome://zotero-platform/content/itemPane.css, using system principal instead. style-sheet.js:178:13
    13:24:53.538 Unknown property ‘-moz-binding’. Declaration dropped. zotero.css:1:330737
    13:24:53.541 Expected media feature name but found ‘-moz-bool-pref’. zotero.css:1:428820
    13:24:53.583 Unknown property ‘-moz-border-radius’. Declaration dropped. codemirror.css:244:22
    13:24:53.603 Error while parsing stylesheet 2 window-global.js:1255:31

  • Single entry .nbib Retest = PASS

    Console:
    14:21:12.243 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{f70107d7-1c45-4333-ae36-64659e1b327a}
    Line Number 1, Column 1: {f70107d7-1c45-4333-ae36-64659e1b327a}:1:1
    14:21:12.313 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{c311853b-e2bf-4fb4-b723-8a20632b0905}
    Line Number 1, Column 1: {c311853b-e2bf-4fb4-b723-8a20632b0905}:1:1
    14:21:12.444 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{c44b118e-0f3a-441d-aff0-da1818293fd3}
    Line Number 1, Column 1: {c44b118e-0f3a-441d-aff0-da1818293fd3}:1:1
    14:21:13.481 Storing invalid field 'place' for type journalArticle in Extra for item 1/null
    14:21:18.329 XHRGEThttps://api.zotero.org/keys/current
    [HTTP/2 200 OK 932ms]

    14:21:19.122 XHRGEThttps://api.zotero.org/users/6212901/groups?format=versions
    [HTTP/2 200 OK 155ms]

    14:21:19.390 XHRPOSThttps://api.zotero.org/users/6212901/collections
    [HTTP/2 200 OK 182ms]

    14:21:20.497 XHRPOSThttps://api.zotero.org/users/6212901/items
    [HTTP/2 200 OK 4109ms]
  • Next Import Test
    .nbib file, 32,000 Kb
    Report ID Submitted: 930169702

    Result=FAIL

    BROWSER CONSOLE:

    15:10:41.286 Component returned failure code: 0x8052000e (NS_ERROR_FILE_IS_LOCKED) [mozIStorageService.backupDatabaseFile] 3 db.js:1058
    16:29:50.916 WebSocket connection closed: 1006
    16:50:06.837 Component returned failure code: 0x8052000e (NS_ERROR_FILE_IS_LOCKED) [mozIStorageService.backupDatabaseFile] 17 db.js:1058
    07:43:24.808 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{3046b61d-188b-406e-9b5f-ea46cc274b7a}
    Line Number 1, Column 1: {3046b61d-188b-406e-9b5f-ea46cc274b7a}:1:1
    07:43:25.071 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{161ae720-e8fd-49c4-995c-b6e2f2aaeca0}
    Line Number 1, Column 1: {161ae720-e8fd-49c4-995c-b6e2f2aaeca0}:1:1
    07:43:25.825 XML Parsing Error: syntax error
    Location: moz-nullprincipal:{a7f4e941-b4c9-4db3-a515-faae191a31fc}
    Line Number 1, Column 1: {a7f4e941-b4c9-4db3-a515-faae191a31fc}:1:1
    07:43:31.263 Storing invalid field 'place' for type journalArticle in Extra for item 1/null 5
    07:43:32.907 Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: INSERT OR REPLACE INTO itemTags (itemID, tagID, type) VALUES (?, ?, ?)] [PARAMS: 249856, 331655, 0] [ERROR: FOREIGN KEY constraint failed] 2 db.js:686
    07:43:33.734 item.isRegularItem is not a function retractions.js:841
    07:48:33.301 Component returned failure code: 0x8052000e (NS_ERROR_FILE_IS_LOCKED) [mozIStorageService.backupDatabaseFile] db.js:1058
    07:57:46.785 Missing resource in locale en-AU: toolkit/global/wizard.ftl
    07:57:46.786 Missing resource in locale en-CA: toolkit/global/wizard.ftl
    07:57:46.786 Missing resource in locale en-NZ: toolkit/global/wizard.ftl
  • (better to just post debug output IDs and not clutter the forum with tons of logging).
    @dstillman -- could you take a look at the initial error report?
    There's one other almost identical error report from last summer: https://forums.zotero.org/discussion/comment/437437#Comment_437437
  • Continued failure attempting larger .nbib

    Most recent report: 1179976096
  • Can you send an .nbib file with which you can reproduce this to support@zotero.org with a link to this thread?
Sign In or Register to comment.