[Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu
Esteban Zimanyi
estebanzimanyi at gmail.com
Mon May 23 13:11:59 PDT 2022
Dear Regina
I suspect that a possible cause for this problem is that PG 15 does not
really preload the postgis-3 extension. This is why you have the output as
myself that the MobilityDB extension failed at test 3/114. The output I
sent you in the previous email was the log of this operation.
How to test whether the PostGIS extension is fully loaded before running
the SQL script of the MobilityDB extension ?
On Mon, May 23, 2022, 21:50 Regina Obe <lr at pcorp.us> wrote:
> Esteban,
>
>
>
> I tried your branch and was able to do
>
>
>
> CREATE EXTENSION mobilitydb;
>
>
>
> It took longer than the PG14 install though for that to run. Noticably
> slower but not a hug deal:
>
>
>
> CREATE EXTENSION Query returned successfully in 6 secs 898 msec.
>
>
>
> As far as running the tests, it fails for me too, but I’m not sure it’s
> targeting the right thing, is there a debug setting (sorry not too familiar
> with cmake).
>
> I however did not bother pre-loading postgis-3, the PG14, PG15 tests I did
> worked without preload, but maybe it was because I had run some postgis
> stuff beforehand.
>
>
>
> Test project /home/robe/projects/MobilityDB/build
>
> Start 1: build
>
> 1/114 Test #1: build .............................. Passed 0.35
> sec
>
> Start 2: setup
>
> 2/114 Test #2: setup .............................. Passed 5.03
> sec
>
> Start 3: create_extension
>
> 3/114 Test #3: create_extension ...................***Failed 18.16
> sec
>
> Start 5: load_tables
>
> Failed test dependencies: create_extension
>
> 4/114 Test #5: load_tables ........................***Not Run 0.00
> sec
>
> Start 6: 001_period
>
>
>
>
>
>
>
>
>
> *From:* Regina Obe [mailto:lr at pcorp.us]
> *Sent:* Monday, May 23, 2022 11:49 AM
> *To:* 'Esteban Zimanyi' <estebanzimanyi at gmail.com>
> *Cc:* 'SAKR Mahmoud' <mahmoud.sakr at ulb.be>; 'SCHOEMANS Maxime' <
> Maxime.Schoemans at ulb.be>; 'mobilitydb-dev at lists.osgeo.org' <
> mobilitydb-dev at lists.osgeo.org>
> *Subject:* RE: [Mobilitydb-dev] Configuring for a Particular PostgreSQL
> on Ubuntu
>
>
>
> Great news. Thanks. I’ll give it another try. I’ll check on the tests.
>
>
>
> I couldn’t run the tests when I changed to compile against PG14 (but
> queries ran fine), so I suspect the tests might be hard-wired to run
> against your default PostgreSQL, which in my case is PG15.
>
>
>
> *From:* Esteban Zimanyi [mailto:estebanzimanyi at gmail.com
> <estebanzimanyi at gmail.com>]
> *Sent:* Monday, May 23, 2022 11:38 AM
> *To:* Regina Obe <lr at pcorp.us>
> *Cc:* SAKR Mahmoud <mahmoud.sakr at ulb.be>; SCHOEMANS Maxime <
> Maxime.Schoemans at ulb.be>
> *Subject:* Re: [Mobilitydb-dev] Configuring for a Particular PostgreSQL
> on Ubuntu
>
>
>
> Dear Regina
>
>
>
> Many thanks for giving such detailed feedback for solving the issue of the
> pg_atoi missing function in PG_15. For a quick solution I have copy/pasted
> the original function that I only enable if PG version >= 15.
>
>
>
>
> https://github.com/estebanzimanyi/MobilityDB/blob/pgcall/src/point/tpoint.c#L49
>
>
>
> Now I can compile and use MobilityDB on PG 15 and PGIS 3.3 without any
> problem
>
>
>
>
> --------------------------------------------------------------------------------------------------------------
>
> esteban at ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ psql test
> psql (15beta1)
> Type "help" for help.
>
> test=# create extension mobilitydb cascade;
> NOTICE: installing required extension "postgis"
> CREATE EXTENSION
> test=# select mobilitydb_full_version();
> mobilitydb_full_version
> -----------------------------------------------------
> MobilityDB 1.0.0, PostgreSQL 15beta1, PostGIS 3.3.0
> (1 row)
>
> test=# select tintersects(tgeompoint '[Point(1 1)@2000-01-01, Point(3
> 3)@2000-01-03]',
> tgeompoint '[Point(1 3)@2000-01-01, Point(3 1)@2000-01-03]');
> tintersects
>
> --------------------------------------------------------------------------------------------------------------
> {[f at 2000-01-01 00:00:00+01, t at 2000-01-02 00:00:00+01], (f at 2000-01-02
> 00:00:00+01, f at 2000-01-03 00:00:00+01]}
> (1 row)
>
> test=#
>
>
> --------------------------------------------------------------------------------------------------------------
>
>
>
> However, I cannot run the MobilityDB regression tests
>
>
>
>
> --------------------------------------------------------------------------------------------------------------
>
>
>
> esteban at ESTEBAN-WORKSTATION:~/src/MobilityDB/build$ make test
> Running tests...
> Test project /home/esteban/src/MobilityDB/build
> Start 1: build
> 1/114 Test #1: build .............................. Passed 0.17
> sec
> Start 2: setup
> 2/114 Test #2: setup .............................. Passed 2.97
> sec
> Start 3: create_extension
> 3/114 Test #3: create_extension ...................***Failed 16.41
> sec
> Start 5: load_tables
> Failed test dependencies: create_extension
>
>
> --------------------------------------------------------------------------------------------------------------
>
>
>
> despite I have modified the postgresql.conf file as required by setting
>
>
>
> shared_preload_libraries = 'postgis-3'
>
>
>
> I have the following errors in the file
> \\wsl$\Ubuntu\home\esteban\src\MobilityDB\build\tmptest\log\create_ext.log
>
>
>
>
> --------------------------------------------------------------------------------------------------------------
>
> ...
>
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17652:
> NOTICE: argument type stbox is only a shell
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17736:
> ERROR: type box2d does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17740:
> ERROR: type box3d does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17744:
> ERROR: type geometry does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17748:
> ERROR: type geography does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17768:
> ERROR: type geometry does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17772:
> ERROR: type geography does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17776:
> ERROR: type geometry does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17780:
> ERROR: type geography does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17782:
> ERROR: type "box2d" does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17783:
> ERROR: type "box3d" does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17784:
> ERROR: type "geometry" does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17785:
> ERROR: type "geography" does not exist
> psql:/home/esteban/src/MobilityDB/build/test_mobilitydb--1.0.0.sql:17800:
> NOTICE: type "geometry" is not yet defined
>
> ...
>
>
> --------------------------------------------------------------------------------------------------------------
>
>
>
> Do you have any idea why this is the case ?
>
>
>
> Many thanks for your help
>
>
>
> Esteban
>
>
>
>
>
> On Sun, May 22, 2022 at 9:12 PM Regina Obe <lr at pcorp.us> wrote:
>
> I have multiple versions of PostgreSQL installed on my Ubuntu server.
>
> I can't figure out how to install against a particular version.
>
> I've tried this:
>
> cd MobilityDB
> export PGVER=14
> export PGPATH=/usr/lib/postgresql/${PGVER}
> export PATH=$PATH:/usr/lib/postgresql/${PGVER}/bin
> rm -rf build
> mkdir build
> cd build
> cmake -DPOSTGRES_PG_CONFIG=$PGPATH/bin/pg_config ..
>
> and I tried this:
>
> cd MobilityDB
> export PGVER=14
> export PGPATH=/usr/lib/postgresql/${PGVER}
> export PATH=$PATH:/usr/lib/postgresql/${PGVER}/bin
> rm -rf build
> mkdir build
> cd build
> cmake -DPOSTGRES_PG_CONFIG=$PGPATH/bin/pg_config ..
>
>
> #I also explicitly tried setting the POSTGRESQL_BIN_DIR via cmake.
> Regardless what I do it still outputs:
>
> -- POSTGRESQL_VERSION_MAJOR=15
> -- POSTGRESQL_VERSION_MINOR=0
> -- POSTGRESQL_BIN_DIR: /usr/lib/postgresql/15/bin
> -- POSTGRESQL_INCLUDE_DIR: /usr/include/postgresql/15/server
> -- POSTGRESQL_LIBRARIES: /usr/lib/aarch64-linux-gnu
> -- POSTGRESQL_SHARE_DIR: /usr/share/postgresql/15
> -- POSTGRESQL_DYNLIB_DIR: /usr/lib/postgresql/15/lib
> -- POSTGRESQL_VERSION: 15.0
>
> As I mentioned in this issue, mobilitydb does not work against PostgreSQL
> 15
>
> https://github.com/MobilityDB/MobilityDB/issues/218
>
> Thanks,
> Regina
>
>
>
> _______________________________________________
> Mobilitydb-dev mailing list
> Mobilitydb-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mobilitydb-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-dev/attachments/20220523/48175b89/attachment-0001.htm>
More information about the Mobilitydb-dev
mailing list