Warning when calling healthz endpoint after update to v0.22.0

[alspires]

Hello,

I noticed I've been getting this warning when calling the new /healthz endpoint after updating to v.22.0:

2025-11-17 11:54:31,498 INFO     50 127.0.0.1 - - [17/Nov/2025 11:54:31] "GET /v1/system/healthz HTTP/1.1" 200 -
2025-11-17 11:54:32,713 WARNING  51 DB is not ready yet: syntax error at or near "."
LINE 1: ...) AND ("t1"."update_date" < (NOW() - INTERVAL `t2`.`refresh_...

It wasn't happening before.

Is this a newly introduced issue?

Thanks.

[dosubot[bot]]

This is a newly introduced issue in v0.22.0. The warning comes from a SQL query that now uses MySQL-specific syntax (with backticks and the INTERVAL keyword) that isn't compatible with PostgreSQL, specifically in the form INTERVAL \t2`.`refresh_freq` MINUTE. This causes the "syntax error at or near '.'" when RagFlow tries to run the query on Postgres. The problematic query is in the list_sync_tasksmethod ofSyncLogsService` and is triggered by background sync workers, not directly by the /healthz endpoint, but the timing can make it look related. There's currently no logic to adapt the SQL for different databases, so PostgreSQL users will see this error until it's fixed in the codebase. More details are in this issue: #11293.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}