jdemaeyer/brightsky-infrastructure

Error "type "earth" does not exist at character 136" when starting a fresh instance

Opened this issue · 1 comments

Hi, thank you for your nice work!

I'm trying to run an instance of on a fresh copy of Ubuntu LTS.
When I view the logs, I see this error coming often.

postgres_1   | 2021-05-23 08:41:09.899 UTC [663] ERROR:  type "earth" does not exist at character 136
postgres_1   | 2021-05-23 08:41:09.899 UTC [663] QUERY:  SELECT cube(cube(cube(earth()*cos(radians($1))*cos(radians($2))),earth()*cos(radians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth
postgres_1   | 2021-05-23 08:41:09.899 UTC [663] CONTEXT:  SQL function "ll_to_earth" during inlining
postgres_1   |  automatic analyze of table "postgres.public.sources"

Hi,

I have here the same problem. But the weird thing is that it has worked for six month and then stopped without any error message. What I only see is

2023-01-05 08:09:17.552 UTC [31] ERROR: type "earth" does not exist at character 136 2023-01-05 08:09:17.552 UTC [31] QUERY: SELECT cube(cube(cube(earth()*cos(radians($1))*cos(radians($2))),earth()*cos(radians($1))*sin(radians($2))),earth()*sin(radians($1)))::earth 2023-01-05 08:09:17.552 UTC [31] CONTEXT: SQL function "ll_to_earth" during inlining automatic analyze of table "postgres.public.sources"

Thanks for your help!