[5.0 Beta] Grey progress bar on startup

dstillman

This discussion was created from comments split from: Zotero 5.0 Beta.

Greg

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/

dstillman

How long have you let it run? How large is your database?

Greg

The database file is about 170MB and I let it run for at least 5 min but will try a longer period.

Greg

I am still getting the progress bar after 30 min without any changes...

dstillman

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?

Greg

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

adamsmith

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

Greg

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

Greg

Check database integrity in 4.x does not show any problems.

dstillman

Thanks — this should be fixed in r63, now available.

Greg

Works, thanks!