Failed to initialize indexer, syntax error

[RonRahaman]

Hi all,

I'm running Clair on our workstation for the first time, and I'm experiencing the following initialization error.

$ clair -conf config.yml -mode "combo"
{"level":"debug","component":"initialize/Logging","time":"2022-04-20T14:36:45-04:00","message":"logging initialized"}
{"level":"info","component":"main","version":"","time":"2022-04-20T14:36:45-04:00","message":"starting"}
{"level":"info","component":"main","lint":"automatically sizing number of concurrent requests (at $.indexer.index_report_request_concurrency)","time":"2022-04-20T14:36:45-04:00"}
{"level":"info","component":"main","lint":"this parameter will be ignored in a future release (at $.matcher.max_conn_pool)","time":"2022-04-20T14:36:45-04:00"}
{"level":"info","component":"main","lint":"connection string is empty and no relevant environment variables found (at $.notifier.connstring)","time":"2022-04-20T14:36:45-04:00"}
{"level":"info","component":"main","lint":"no delivery mechanisms specified (at $.notifier)","time":"2022-04-20T14:36:45-04:00"}
{"level":"debug","component":"main","time":"2022-04-20T14:36:45-04:00","message":"found cgroups v1 and cpu controller"}
{"level":"debug","component":"main","time":"2022-04-20T14:36:45-04:00","message":"falling back to root hierarchy"}
{"level":"error","component":"main","error":"open //sys/fs/cgroup/cpuacct,cpu/cpu.cfs_quota_us: no such file or directory","time":"2022-04-20T14:36:45-04:00","message":"unable to guess GOMAXPROCS value"}
{"level":"info","component":"main","version":"","time":"2022-04-20T14:36:45-04:00","message":"ready"}
{"level":"info","component":"main","time":"2022-04-20T14:36:45-04:00","message":"launching introspection server"}
{"level":"info","component":"main","time":"2022-04-20T14:36:45-04:00","message":"launching http transport"}
{"level":"info","component":"main","time":"2022-04-20T14:36:45-04:00","message":"registered signal handler"}
{"level":"info","component":"initialize/Services","time":"2022-04-20T14:36:45-04:00","message":"begin service initialization"}
{"level":"warn","component":"introspection/New","time":"2022-04-20T14:36:45-04:00","message":"no health check configured; unconditionally reporting OK"}
{"level":"info","component":"introspection/Server.withPrometheus","endpoint":"/metrics","server":"localhost:8089","time":"2022-04-20T14:36:45-04:00","message":"configuring prometheus"}
{"level":"info","component":"introspection/New","time":"2022-04-20T14:36:45-04:00","message":"configuring jaeger exporter to push to agent"}
{"level":"info","component":"introspection/New","time":"2022-04-20T14:36:45-04:00","message":"distributed tracing configured"}
{"level":"info","component":"libindex/New","time":"2022-04-20T14:36:45-04:00","message":"created database connection"}
{"level":"info","component":"initialize/Services","time":"2022-04-20T14:36:45-04:00","message":"end service initialization"}
{"level":"error","component":"main","error":"service initialization failed: failed to initialize indexer: failed to perform migrations: migration 1 failed: ERROR: syntax error at or near \"NOT\" (SQLSTATE 42601)","time":"2022-04-20T14:36:45-04:00","message":"fatal error"}

I'm running without a container using the following:

• Clair 4.1.4 built with Go 1.8
• PostgreSQL 9.2.24
• RHEL 7.9

Here is my config.yml file. I changed the extension so GitHub would allow me to upload it.
config.yml.txt

I was wondering if my postgres version is too out-of-date. I'm aware that some significant new syntax has been introduced since 9.2.24 (2017-11-09), but I'm by no means a postgres guru. :) We're only using 9.2.24 because it's the version provided by RHEL.

Many thanks,
Ron

[hdonnay]

It's likely because of the PostgreSQL version, yeah. I think we test on 11 as the oldest.

[RonRahaman]

Thanks, I'll take a look at that