ietf / authors.ietf.org

Content of authors.ietf.org
https://authors.ietf.org
Other
38 stars 50 forks source link

Searching causes error #21

Closed larseggert closed 2 years ago

larseggert commented 2 years ago
Screen Shot 2022-04-08 at 9 57 12
JayDaley commented 2 years ago

i will escalate this.

larseggert commented 2 years ago

14 seems related (this may be a duplicate)

NGPixel commented 2 years ago

Was the database migrated recently?

Only thing I can think of is that the pg_trgm extension is not enabled in postgres. It gets created when enabling Postgres search the first time.

Basic search works, so the issue is within the postgres search module and rebuilding the index doesn't solve it. The only difference between init() and rebuild() is the creation of the pg_trgm extension.

So running CREATE EXTENSION IF NOT EXISTS pg_trgm on the database could be worth a try.

NGPixel commented 2 years ago

pg_trgm extension has been installed on the server by Glen and I've run an index rebuild. Search results now appear correctly.