Debug ID D848621212: Indexing of PDFs fail Zotero 9.0.3

otexplorer
edited yesterday at 7:00pm
Since a few days new items/PDFs are not indexed. If clicking the wheel symbol under the attachment nothing at all happens (or the wheel disappears). Normally the wheel rotates while indexing.

(I tried advanced search to see if indexing anyway had occurred, but this was not so. There are error messages in Debug that should be easily understandable I think)
  • dstillman Zotero Team
    edited yesterday at 7:53pm
    Error: Error(s) encountered during statement execution: no such table: indexing.fulltextWords
    Your database is missing a table. Did you do something unusual to your database? Do you have your Zotero data directory in a cloud storage folder?

    Sorry, this is wrong. See below.
  • otexplorer
    Not cloud storage.
    But now when you ask: I tried to upload Zotero library to Consensus.app. Large database, it worked overnight but in the morning there was error message on Consensus that upload had failed. Maybe connected to that attempt?
  • dstillman Zotero Team
    edited yesterday at 7:53pm
    If it modified your local SQLite database. Something did, at least. Or it's DB corruption, though that's less likely to show as a missing table. You can check your database integrity from the Advanced → Files and Folders pane of the Zotero settings.

    But there's no safe way to recover from this, so you'd have to make sure all your data is synced to the online library, delete zotero.sqlite with Zotero closed, and then restart Zotero to create a new DB and pull down your data.
  • otexplorer
    Ok thanks, scary!

    (Consensus is supposed to create a one-directional copy, i.e. potential changes made at Consensus are not supposed to be reflected in Zotero later. But the timing of error probably fits when I think about it)
  • otexplorer
    Check database integrity:
    PASSED: No errors found in database.

    Well, that doesn't mean anything anyway?
  • dstillman Zotero Team
    edited yesterday at 7:51pm
    Wait, sorry, I actually misread the error message. It looks like there's just a bug here where indexing could fail for some large databases, and no more than once every couple weeks. Your database is fine. Sorry for the scare.

    Restarting Zotero should fix this temporarily. We'll put out a proper fix soon.
  • otexplorer
    Thanks,
    but this problem is not solved through restarting Zotero. I have done that a number of times, also restarted computer (macOS 26.5).

    Maybe further inspection of error codes could reveal something more than that bug.
  • dstillman Zotero Team
    Can you provide a Debug ID for Zotero startup through reproducing this, using the Help → Debug Output Logging → "Restart with Logging Enabled…" option?
Sign In or Register to comment.