Searching in statuses is failing for my instance currently
Running 2.3.0
Not sure what's caused this to start happening, but pleroma's throwing errors when doing searches and only for the content within statuses (users and hashtags appears to be OK).
When doing the search via Pleroma's web UI, I see in the logs:
[error] Elixir.Pleroma.Web.MastodonAPI.SearchController search error: %Postgrex.Error{connection_id: 441, message: nil, postgres: %{code: :undefined_function, file: "parse_oper.c", hint: "No operator matches the given name and argument types. You might need to add explicit type casts.", line: "722", message: "operator does not exist: timestamp without time zone <=> date", pg_code: "42883", position: "505", routine: "op_error", severity: "ERROR", unknown: "ERROR"}, query: "SELECT a0.\"id\", a0.\"data\", a0.\"local\", a0.\"actor\", a0.\"recipients\", a0.\"inserted_at\", a0.\"updated_at\", o1.\"id\", o1.\"data\", o1.\"inserted_at\", o1.\"updated_at\" FROM \"activities\" AS a0 INNER JOIN \"objects\" AS o1 ON (o1.\"data\"->>'id') = COALESCE(a0.\"data\"->'object'->>'id', a0.\"data\"->>'object') WHERE (NOT (a0.\"actor\" = ANY($1))) AND (a0.\"data\"->>'type' = 'Create') AND ($2 = ANY(a0.\"recipients\")) AND (o1.\"fts_content\" @@ websearch_to_tsquery($3)) AND (NOT (a0.\"actor\" = ANY($4))) ORDER BY o1.\"inserted_at\" <=> now()::date LIMIT $5 OFFSET $6"}
** I had previously also mentioned a timeout issue via one of the DB tasks, which I have resolved by adjusting DB timeout values **
This is running postgres 13.2, elixir 1.11.4, erlang 23.3.4