gbif / registry

GBIF Registry
Apache License 2.0
35 stars 15 forks source link

Postgresql errors being logged #525

Open MattBlissett opened 1 year ago

MattBlissett commented 1 year ago

An error is being logged, which seems to come from the registry although the log isn't clear.

Sep 26 08:11:17 merlin postgres[3290]: [48-1] user=,db= ERROR:  function unaccent(text) does not exist at character 37
Sep 26 08:11:17 merlin postgres[3290]: [48-2] user=,db= HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Sep 26 08:11:17 merlin postgres[3290]: [48-3] user=,db= QUERY:  SELECT regexp_replace(quote_literal(unaccent(lower(trim(input)))),'\s+','','g')
Sep 26 08:11:17 merlin postgres[3290]: [48-4] user=,db= CONTEXT:  PL/pgSQL function public.normalize_name(text) line 3 at RETURN

(This isn't new.)

MattBlissett commented 2 months ago
Jul 14 08:29:21 merlin postgres[14706]: [58-1] user=,db= ERROR:  function unaccent(text) does not exist at character 37
Jul 14 08:29:21 merlin postgres[14706]: [58-2] user=,db= HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Jul 14 08:29:21 merlin postgres[14706]: [58-3] user=,db= QUERY:  SELECT regexp_replace(quote_literal(unaccent(lower(trim(input)))),'\s+','','g')
Jul 14 08:29:21 merlin postgres[14706]: [58-4] user=,db= CONTEXT:  PL/pgSQL function public.normalize_name(text) line 3 at RETURN
Jul 14 08:29:21 merlin postgres[14706]: [58-5] #011automatic analyze of table "prod_b_registry.public.institution"
Jul 14 08:29:22 merlin postgres[14706]: [59-1] user=,db= ERROR:  function unaccent(text) does not exist at character 37
Jul 14 08:29:22 merlin postgres[14706]: [59-2] user=,db= HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Jul 14 08:29:22 merlin postgres[14706]: [59-3] user=,db= QUERY:  SELECT regexp_replace(quote_literal(unaccent(lower(trim(input)))),'\s+','','g')
Jul 14 08:29:22 merlin postgres[14706]: [59-4] user=,db= CONTEXT:  PL/pgSQL function public.normalize_name(text) line 3 at RETURN
Jul 14 08:29:22 merlin postgres[14706]: [59-5] #011automatic analyze of table "prod_b_registry.public.collection"

The function definition is https://github.com/gbif/registry/blob/c1d4db06ea5087dba29450fa842ce9512472cc87/registry-persistence/src/main/resources/liquibase/082-functions-migrated-to-plpgsql.xml