Upgrade StorageDatabase upgrade error
EDIT: Issues fixed by restoring from Zotero server. Thanks for everything!
Hi,
I haven't launched Zotero in a while, and FF has been upgraded since last time I did, and I get the error "Database upgrade error" and Zotero will not launch.
DB Repair Tool & re-installing Zotero did not fix the issue. Checking the DB integrity in Zotero-Preferences was fine.
Thanks in advance for your time!
Upload ID is 4fc23eb1ac06a and debugging output is as follows:
Could not read chrome manifest 'jar:file:///usr/lib/firefox/extensions/langpack-en-GB@firefox.mozilla.org.xpi!/chrome/en-GB.manifest'.
Could not read chrome manifest 'jar:file:///usr/lib/firefox/extensions/langpack-en-ZA@firefox.mozilla.org.xpi!/chrome/en-ZA.manifest'.
Could not read chrome manifest 'file:///usr/lib/firefox/extensions/%7B972ce4c6-7e08-4474-a285-3208198ce6fd%7D/chrome.manifest'.
[JavaScript Error: "[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.rollbackTransaction]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: <TOP_LEVEL> :: line 537" data: no] [ERROR: cannot rollback - no transaction is active]" {file: "chrome://zotero/content/xpcom/zotero.js" line: 639}]
No chrome package registered for chrome://zotfile/locale/zotfile.dtd
[JavaScript Error: "Zotero.Proxies.proxies.slice is not a function" {file: "chrome://zotero/content/preferences/preferences.js" line: 1799}]
version => 3.0.7, platform => Linux x86_64, oscpu => Linux x86_64, locale => en-US, appName => Firefox, appVersion => 12.0
=========================================================
(3)(+0000000): Using data directory /home/christian/Documents/Zotero/zotero
(3)(+0000000): IPC: Initializing pipe at /home/christian/Documents/Zotero/zotero/pipes/1338130510511
(3)(+0000001): Loading in full mode
(3)(+0000000): Opening database 'zotero'
(5)(+0000005): PRAGMA locking_mode=EXCLUSIVE
(3)(+0000001): pdftotext version 3.02 registered at /home/christian/Documents/Zotero/zotero/pdftotext-Linux-x86_64
(3)(+0000000): pdfinfo version 3.02 registered at /home/christian/Documents/Zotero/zotero/pdfinfo-Linux-x86_64
(5)(+0000000): SELECT version FROM version WHERE schema='userdata'
(5)(+0000001): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): SELECT version FROM version WHERE schema='system'
(3)(+0000000): Updating custom tables
(5)(+0000000): DELETE FROM itemTypesCombined
(3)(+0000000): [Exception... "Component returned failure code: 0x80630002 (NS_ERROR_STORAGE_IOERR) [mozIStorageConnection.executeSimpleSQL]" nsresult: "0x80630002 (NS_ERROR_STORAGE_IOERR)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: <TOP_LEVEL> :: line 149" data: no] [QUERY: DELETE FROM itemTypesCombined] [ERROR: disk I/O error]
(5)(+0000000): Rolling back transaction
(3)(+0000002): Initialized in 214 ms
(3)(+0000207): ZoteroOpenOfficeIntegration: Communication server listening on 127.0.0.1:19876
(3)(+0000000): ZoteroOpenOfficeIntegration: Registering shutdown listener
(3)(+0076024): Getting Zotero sync password
(5)(+0000006): SELECT COUNT(*) FROM fulltextItems WHERE (indexedPages IS NOT NULL AND indexedPages=totalPages) OR (indexedChars IS NOT NULL AND indexedChars=totalChars)
(5)(+0000025): SELECT COUNT(*) FROM fulltextItems WHERE (indexedPages IS NOT NULL AND indexedPages<totalPages) OR (indexedChars IS NOT NULL AND indexedChars<totalChars)
(5)(+0000001): SELECT COUNT(*) FROM itemAttachments WHERE itemID NOT IN (SELECT itemID FROM fulltextItems WHERE indexedPages IS NOT NULL OR indexedChars IS NOT NULL)
(5)(+0000002): SELECT COUNT(*) FROM fulltextWords
(3)(+0000083): Cached 15 styles in 17 ms
(3)(+0000000): DATE: retrieved with algorithms: {"year":2010,"month":6,"day":26}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2010,"month":2,"day":15}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2010,"month":0,"day":14}
(3)(+0000001): DATE: retrieved with algorithms: {"year":2011,"month":7,"day":18}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2009,"month":11,"day":1}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2012,"month":0,"day":1}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2009,"month":11,"day":15}
(3)(+0000001): DATE: retrieved with algorithms: {"year":2010,"month":0,"day":27}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2012,"month":0,"day":1}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":4,"day":28}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":7,"day":26}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2008,"month":8,"day":16}
(3)(+0000001): DATE: retrieved with algorithms: {"year":2008,"month":10,"day":11}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":11,"day":5}
Hi,
I haven't launched Zotero in a while, and FF has been upgraded since last time I did, and I get the error "Database upgrade error" and Zotero will not launch.
DB Repair Tool & re-installing Zotero did not fix the issue. Checking the DB integrity in Zotero-Preferences was fine.
Thanks in advance for your time!
Upload ID is 4fc23eb1ac06a and debugging output is as follows:
Could not read chrome manifest 'jar:file:///usr/lib/firefox/extensions/langpack-en-GB@firefox.mozilla.org.xpi!/chrome/en-GB.manifest'.
Could not read chrome manifest 'jar:file:///usr/lib/firefox/extensions/langpack-en-ZA@firefox.mozilla.org.xpi!/chrome/en-ZA.manifest'.
Could not read chrome manifest 'file:///usr/lib/firefox/extensions/%7B972ce4c6-7e08-4474-a285-3208198ce6fd%7D/chrome.manifest'.
[JavaScript Error: "[Exception... "Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.rollbackTransaction]" nsresult: "0x80004005 (NS_ERROR_FAILURE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: <TOP_LEVEL> :: line 537" data: no] [ERROR: cannot rollback - no transaction is active]" {file: "chrome://zotero/content/xpcom/zotero.js" line: 639}]
No chrome package registered for chrome://zotfile/locale/zotfile.dtd
[JavaScript Error: "Zotero.Proxies.proxies.slice is not a function" {file: "chrome://zotero/content/preferences/preferences.js" line: 1799}]
version => 3.0.7, platform => Linux x86_64, oscpu => Linux x86_64, locale => en-US, appName => Firefox, appVersion => 12.0
=========================================================
(3)(+0000000): Using data directory /home/christian/Documents/Zotero/zotero
(3)(+0000000): IPC: Initializing pipe at /home/christian/Documents/Zotero/zotero/pipes/1338130510511
(3)(+0000001): Loading in full mode
(3)(+0000000): Opening database 'zotero'
(5)(+0000005): PRAGMA locking_mode=EXCLUSIVE
(3)(+0000001): pdftotext version 3.02 registered at /home/christian/Documents/Zotero/zotero/pdftotext-Linux-x86_64
(3)(+0000000): pdfinfo version 3.02 registered at /home/christian/Documents/Zotero/zotero/pdfinfo-Linux-x86_64
(5)(+0000000): SELECT version FROM version WHERE schema='userdata'
(5)(+0000001): Beginning DB transaction
(3)(+0000000): Beginning Notifier event queue
(5)(+0000000): SELECT version FROM version WHERE schema='system'
(3)(+0000000): Updating custom tables
(5)(+0000000): DELETE FROM itemTypesCombined
(3)(+0000000): [Exception... "Component returned failure code: 0x80630002 (NS_ERROR_STORAGE_IOERR) [mozIStorageConnection.executeSimpleSQL]" nsresult: "0x80630002 (NS_ERROR_STORAGE_IOERR)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: <TOP_LEVEL> :: line 149" data: no] [QUERY: DELETE FROM itemTypesCombined] [ERROR: disk I/O error]
(5)(+0000000): Rolling back transaction
(3)(+0000002): Initialized in 214 ms
(3)(+0000207): ZoteroOpenOfficeIntegration: Communication server listening on 127.0.0.1:19876
(3)(+0000000): ZoteroOpenOfficeIntegration: Registering shutdown listener
(3)(+0076024): Getting Zotero sync password
(5)(+0000006): SELECT COUNT(*) FROM fulltextItems WHERE (indexedPages IS NOT NULL AND indexedPages=totalPages) OR (indexedChars IS NOT NULL AND indexedChars=totalChars)
(5)(+0000025): SELECT COUNT(*) FROM fulltextItems WHERE (indexedPages IS NOT NULL AND indexedPages<totalPages) OR (indexedChars IS NOT NULL AND indexedChars<totalChars)
(5)(+0000001): SELECT COUNT(*) FROM itemAttachments WHERE itemID NOT IN (SELECT itemID FROM fulltextItems WHERE indexedPages IS NOT NULL OR indexedChars IS NOT NULL)
(5)(+0000002): SELECT COUNT(*) FROM fulltextWords
(3)(+0000083): Cached 15 styles in 17 ms
(3)(+0000000): DATE: retrieved with algorithms: {"year":2010,"month":6,"day":26}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2010,"month":2,"day":15}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2010,"month":0,"day":14}
(3)(+0000001): DATE: retrieved with algorithms: {"year":2011,"month":7,"day":18}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2009,"month":11,"day":1}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2012,"month":0,"day":1}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2009,"month":11,"day":15}
(3)(+0000001): DATE: retrieved with algorithms: {"year":2010,"month":0,"day":27}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2012,"month":0,"day":1}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":4,"day":28}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":7,"day":26}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2008,"month":8,"day":16}
(3)(+0000001): DATE: retrieved with algorithms: {"year":2008,"month":10,"day":11}
(3)(+0000000): DATE: retrieved with algorithms: {"year":2011,"month":11,"day":5}