Initial installation - getting .pbf - st_asmvtgeom() does not exist error

[Kuba Łobodecki]

Hello,

I have another problem with initial arches installation.

After adding a resource and displaying that in the search panel the shape layer is not showed on the map box.

In browser console it is showed as errors in downloading /mvt/#####.pbf files.

Error states that function st_asmvtgeom(geometry, geometry) does not exist probably there is something wrong with arguments types. Maybe some libraries incompatibility? 

I am on Ubuntu 16.04 and already checked that PostgreSQL, Postgis, GDAL are in proper versions.

I will be very grateful for any hint what can be wrong. 

Best regards,

Kuba

[Angela Labrador]

Hi Kuba,

I have not encountered this error before, but I believe this function is part of PostGIS. Do you get any errors in your console when you go to the /search page and view your map? Is it just an error with this one resource or with all? If you trigger the error again, can you send a full screenshot of the gray traceback area?

Thanks,

Angela

[Kuba Łobodecki]

Hi Angela,

thank you for your answer.

In the meantime I encountered another problem "MapboxGeocoder is not a constructor" in map.js file. I fixed that by changing version of @mapbox/mapbox-gl-geocoder in package.json from "^4.4.0" to "4.4.0" and running 'yarn install' - it looks like newest version 4.6.0 cause some problem (maybe difference in importing method).

Returning to the thread topic - I attach file with full error log.

In console I see that it is http 500 - Internal server error.

In server log only addition is information that error is thrown by psycopg2.errors.UndefinedFunction.

And yes - it is with all resources and many .pbf files at once.

Best regards,

Kuba

[Asaf Kali]

Hi,

Were you able to solve this issue?

Thanks

[Kuba Łobodecki]

Unfortunately not yet.

Angela, can you take a look at error traceback?

Thanks

[Adam Cox]

Hey all, it looks like this is an issue with the Postgres/PostGIS installation. Can you check what versions you have of that software and extension? As the Arches documentation states, you need to use Postgres 12 with PostGIS 3. The function that the original error message mentioned (st_asmvtgeom) only became available in PostGIS 3.

Adam

--
-- To post, send email to arches...@googlegroups.com. To unsubscribe, send email to archesprojec...@googlegroups.com. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en
---
You received this message because you are subscribed to the Google Groups "Arches Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to archesprojec...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/14438ad6-6216-4cf2-84e2-12a2feafe52ao%40googlegroups.com.

[Asaf Kali]

1. "SELECT version();" resulted with "PostgreSQL 12.3 ...."
2. "SELECT PostGIS_Version();" resulted with "3.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1".

Just to be clear, my issue was with the "MapboxGeocoder is not a constructor" issue.

After messing a bit with the javascript files in the project (and reverting my changes), and changing "@mapbox/mapbox-gl-geocoder" to "4.4.0", it is gone  ¯\_(ツ)_/¯

[Kuba Łobodecki]

Ok, so I am still the only one with st_asmvtgeom problem.

As I mentioned in the first post Postgres and Postgis are in proper versions.  

Dependencies installed with installation script which states versions directly:

https://raw.githubusercontent.com/archesproject/arches/master/arches/install/ubuntu_setup.sh

[Kuba Łobodecki]

Problem solved!

Finally that actually was a problem with posgresql version. :(
There was another version installed in the same time and that second was working on the default port.

I deleted everything connected with the old one and change the server port in posgresql 12 config.

Thanks everyone for help! 

[Adam Cox]

Ah, good work figuring that out. Those phantom installations can be very tricky to track down.

--

-- To post, send email to arches...@googlegroups.com. To unsubscribe, send email to archesprojec...@googlegroups.com. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en
---
You received this message because you are subscribed to the Google Groups "Arches Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to archesprojec...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/80fa45f2-534d-4375-8099-285735a3ec41o%40googlegroups.com.