Couldn't prepare query, error:1->'no such table: Certs'

Seafile Client
1

I see the warning

Couldn't prepare query, error:1->'no such table: Certs'

in .ccnet/logs/seafile.log repeating multiple times a minute. I’m running the latest version of seaf-daemon (9.0.16), compiled form source. This issue on GitHub seems to be abut that, but it has been closed. Anyone knows whether that means that there is something wrong with my setup, or is it that the warning is simply supposed to be there?

Thanks for you attention, and thanks to the Seafile team for their work.

2

Regarding the warning Couldn't prepare query, error:1->'no such table: Certs' you are seeing in your .ccnet/logs/seafile.log with seaf-daemon version 9.0.16, I’ve looked into this issue, and it appears to be a known, benign warning for Seafile CLI clients.

Here’s a summary of the situation:

  1. Client-Side Behavior: For Command Line Interface (CLI) Seafile clients, seaf-daemon attempts to load user-accepted certificates. However, the SQLite database that would contain the Certs table is typically not created for CLI clients, unlike for GUI clients.
  2. Functionality Unaffected: This error message does not impact the core functionality of your Seafile client. Your file syncing and other operations should continue to work correctly despite these warnings appearing in the log.
  3. Root Cause: The daemon is designed to look for this Certs table as part of its certificate handling logic. When running a CLI-only setup, this table (and its associated database) is simply not present, leading to the “no such table” error.

In essence, while the log message might seem concerning, it indicates a specific behavior in CLI Seafile clients and does not suggest a problem with your setup or data integrity. The GitHub issue you referenced was likely closed because this behavior, while noisy in logs, doesn’t represent a functional defect.

See related issue: Error in seafile.log Couldn't prepare query, error:1->'no such table: Certs' after init via seaf-cli · Issue #1348 · haiwen/seafile · GitHub

3

We’ll improve handling in future versions.

4

Thans a lot @Jonathan.

To get rid of that warning in my logs, I decided to add a check in http-tx-mgr.c to ensure that the table Certs exists before performing the database query. Pull request is here if you want to include this check: Add check to silence “Couldn’t prepare query” #3001.