[5.0 Beta] Grey progress bar on startup

This discussion was created from comments split from: Zotero 5.0 Beta.
  • I am having problems with the Zotero Standalone beta. I only get the progress bar and Zotero remains grey and unresponsive. Here is a screenshot: https://postimg.org/image/y05e8016n/
  • How long have you let it run? How large is your database?
  • The database file is about 170MB and I let it run for at least 5 min but will try a longer period.
  • I am still getting the progress bar after 30 min without any changes...
  • Could you 1) see if you're getting any startup errors and 2) try to generate real-time debug output for Zotero startup and see if it's actually logging anything during the time that it's stalled? If it stops, can you send the output to support@zotero.org with a link to this thread?
  • edited October 20, 2016
    Here are the startup errors. Looking into real-time debug now.


    [warn] kq_init: detected broken kqueue; not using.: Undefined error: 0
    console.error:
    Message: Error: Error(s) encountered during statement execution: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode [QUERY: INSERT INTO creators SELECT creatorDataID, firstName, lastName, fieldMode FROM creatorData] [PARAMS: ] [ERROR: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode]
    Stack:
    Error: Error(s) encountered during statement execution: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode [QUERY: INSERT INTO creators SELECT creatorDataID, firstName, lastName, fieldMode FROM creatorData] [PARAMS: ] [ERROR: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode]
    Zotero.DBConnection.prototype.queryAsync<@chrome://zotero/content/xpcom/db.js:694:10
    From previous event:
    Zotero.Schema</_migrateUserDataSchema<@chrome://zotero/content/xpcom/schema.js:2051:11
    From previous event:
    Zotero.Schema</this.updateSchema</updated<@chrome://zotero/content/xpcom/schema.js:136:21
    TaskImpl_run@resource://gre/modules/Task.jsm:319:40
    From previous event:
    TaskImpl_handleResultValue@resource://gre/modules/Task.jsm:395:7
    TaskImpl_run@resource://gre/modules/Task.jsm:327:13
    TaskImpl@resource://gre/modules/Task.jsm:280:3
    createAsyncFunction/asyncFunction@resource://gre/modules/Task.jsm:254:14
    Task_spawn@resource://gre/modules/Task.jsm:168:12
    ConnectionData.prototype<.executeTransaction/promise</transactionPromise<@resource://gre/modules/Sqlite.jsm:593:28
    TaskImpl_run@resource://gre/modules/Task.jsm:319:40
  • If you still have an instance of Zotero 4.0.x installed, could you check database integrity there in the advanced tab.
    This is a relatively wild guess, so if this is a hassle for you (i.e. involves reverting/re-installing), wait for Dan who'd be able to present you with more precise instructions
  • Thanks! Here is the end of the real-time debug output. Now it hangs. Before it's mostly things like "zotero(4)(+0000001): DROP TRIGGER IF EXISTS fki_itemTags_itemID_items_itemID". I will look into getting the entire output in a file.


    zotero(4)(+0000001): INSERT INTO creators SELECT creatorDataID, firstName, lastName, fieldMode FROM creatorData

    console.error:
    Message: Error: Error(s) encountered during statement execution: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode [QUERY: INSERT INTO creators SELECT creatorDataID, firstName, lastName, fieldMode FROM creatorData] [PARAMS: ] [ERROR: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode]
    Stack:
    Error: Error(s) encountered during statement execution: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode [QUERY: INSERT INTO creators SELECT creatorDataID, firstName, lastName, fieldMode FROM creatorData] [PARAMS: ] [ERROR: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode]
    Zotero.DBConnection.prototype.queryAsync<@chrome://zotero/content/xpcom/db.js:694:10
    From previous event:
    Zotero.Schema</_migrateUserDataSchema<@chrome://zotero/content/xpcom/schema.js:2051:11
    From previous event:
    Zotero.Schema</this.updateSchema</updated<@chrome://zotero/content/xpcom/schema.js:136:21
    TaskImpl_run@resource://gre/modules/Task.jsm:319:40
    From previous event:
    TaskImpl_handleResultValue@resource://gre/modules/Task.jsm:395:7
    TaskImpl_run@resource://gre/modules/Task.jsm:327:13
    TaskImpl@resource://gre/modules/Task.jsm:280:3
    createAsyncFunction/asyncFunction@resource://gre/modules/Task.jsm:254:14
    Task_spawn@resource://gre/modules/Task.jsm:168:12
    ConnectionData.prototype<.executeTransaction/promise</transactionPromise<@resource://gre/modules/Sqlite.jsm:593:28
    TaskImpl_run@resource://gre/modules/Task.jsm:319:40
    zotero(1)(+0000013): Rolled back DB transaction eCuwd5Wu

    zotero(1)(+0000000): Error(s) encountered during statement execution: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode [QUERY: INSERT INTO creators SELECT creatorDataID, firstName, lastName, fieldMode FROM creatorData] [PARAMS: ] [ERROR: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode]

    zotero(4)(+0000000): PRAGMA foreign_keys = true

    zotero(1)(+0000002): Error: Error(s) encountered during statement execution: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode [QUERY: INSERT INTO creators SELECT creatorDataID, firstName, lastName, fieldMode FROM creatorData] [PARAMS: ] [ERROR: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode]

    Error: Error(s) encountered during statement execution: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode [QUERY: INSERT INTO creators SELECT creatorDataID, firstName, lastName, fieldMode FROM creatorData] [PARAMS: ] [ERROR: UNIQUE constraint failed: creators.lastName, creators.firstName, creators.fieldMode]
    Zotero.DBConnection.prototype.queryAsync<@chrome://zotero/content/xpcom/db.js:694:10
    From previous event:
    Zotero.Schema</_migrateUserDataSchema<@chrome://zotero/content/xpcom/schema.js:2051:11
    From previous event:
    Zotero.Schema</this.updateSchema</updated<@chrome://zotero/content/xpcom/schema.js:136:21
    TaskImpl_run@resource://gre/modules/Task.jsm:319:40
    From previous event:
    TaskImpl_handleResultValue@resource://gre/modules/Task.jsm:395:7
    TaskImpl_run@resource://gre/modules/Task.jsm:327:13
    TaskImpl@resource://gre/modules/Task.jsm:280:3
    createAsyncFunction/asyncFunction@resource://gre/modules/Task.jsm:254:14
    Task_spawn@resource://gre/modules/Task.jsm:168:12
    ConnectionData.prototype<.executeTransaction/promise</transactionPromise<@resource://gre/modules/Sqlite.jsm:593:28
    TaskImpl_run@resource://gre/modules/Task.jsm:319:40

    zotero(3)(+0000002): Initialized in 2684 ms

    zotero(3)(+0001693): No general proxy or PAC file found -- assuming direct connection
  • Check database integrity in 4.x does not show any problems.
  • Thanks — this should be fixed in r63, now available.
  • Works, thanks!
Sign In or Register to comment.