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!