Introduction
During the Xray DB Sync running, the following error may appear in the xray-server-service.log:
[jfxr ] [INFO ] Will run vacuum-analyze on all PublicData updates related tables
[jfxr ] [ERROR] Failed vacuum-analyze on all PublicData updates related tables ERROR: canceling statement due to statement timeout (SQLSTATE 57014)
Root Cause
The root cause of the issue is that the PostgreSQL VACUUM ANALYZE operation exceeds the configured statement_timeout value.
As a result, PostgreSQL automatically canceled the query and returned:
SQLSTATE 57014
Resolution
Permanent Recommendation
To increase the PostgreSQL statement_timeout value appropriately for maintenance operations or scheduling VACUUM ANALYZE during low-traffic maintenance windows.
Temporary Workaround
Temporarily workaround is to disable the statement timeout for the current session and rerun the maintenance command manually:
SET statement_timeout = 0;
VACUUM ANALYZE public.public_components_versions_files;
Additional Notes:
- statement_timeout = 0 disables timeout enforcement only for the current session.
- This workaround should be used carefully in production environments.
- Restore the original timeout configuration after maintenance if necessary.