Broken GC?

[igcherkaev]

Hello,

We recently ran into a disk space issue on our pgsql server, which holds the db for clair, and after investigation we discovered that GC is broken for some reason in clair 4.8.0:

dockerregistry-corp-clair-5788d775fd-4c4gc projectquay-clair {"level":"info","component":"libvuln/updates/Manager.Run","retention":2,"time":"2025-10-13T17:04:50Z","message":"GC started"}
dockerregistry-corp-clair-5788d775fd-4c4gc projectquay-clair {"level":"error","component":"libvuln/updates/Manager.Run","error":"error querying for update operations: ERROR: syntax error at or near \"]\" (SQLSTATE 42601)","time":"2025-10-13T17:04:50Z","message":"error while performing GC"}
dockerregistry-corp-clair-5788d775fd-vj8tj projectquay-clair {"level":"info","component":"libvuln/updates/Manager.Run","retention":2,"time":"2025-10-13T17:23:58Z","message":"GC started"}
dockerregistry-corp-clair-5788d775fd-vj8tj projectquay-clair {"level":"error","component":"libvuln/updates/Manager.Run","error":"error querying for update operations: ERROR: syntax error at or near \"]\" (SQLSTATE 42601)","time":"2025-10-13T17:23:58Z","message":"error while performing GC"}

Not sure what exact SQL command it tries to execute on the server, but it clearly fails. What troubleshooting steps should we take?