[Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu
Regina Obe
lr at pcorp.us
Wed May 25 06:41:53 PDT 2022
I put the postgis-3.0 in shared libraries and I tried and restarted my service but I get the same issue failing at CREATE EXTENSION on my PG14.3 instance during the tests.
Works fine when I run things.
I see you are creating a new cluster and have the shared happen during that. All paths at a in the test.sh look okay.
The logs show:
3/112 Testing: create_extension
3/112 Test: create_extension
Command: "/home/robe/projects/MobilityDB/build/test/scripts/test.sh" "create_ext"
Directory: /home/robe/projects/MobilityDB/build/test/scripts
"create_extension" start time: May 25 13:31 UTC
Output:
----------------------------------------------------------
pg_ctl: server is running (PID: 7237)
/usr/lib/postgresql/14/bin/postgres "-D" "/home/robe/projects/MobilityDB/build/tmptest/db" "-k" "/home/robe/projects/MobilityDB/build/tmptest/lock" "-h" ""
<end of output>
Test time = 18.62 sec
----------------------------------------------------------
Test Failed.
"create_extension" end time: May 25 13:31 UTC
"create_extension" time elapsed: 00:00:18
----------------------------------------------------------
BTW is there a reason you removed your PG15 patch fix branch. I didn’t see the code committed anywhere yet and I made the mistake of updating and now can’t CREATE EXTENSION against PG15 doesn’t work anymore :(
From: Esteban Zimanyi [mailto:estebanzimanyi at gmail.com]
Sent: Monday, May 23, 2022 4:19 PM
To: Regina Obe <lr at pcorp.us>
Cc: SAKR Mahmoud <mahmoud.sakr at ulb.be>; SCHOEMANS Maxime <Maxime.Schoemans at ulb.be>; mobilitydb-dev at lists.osgeo.org
Subject: Re: [Mobilitydb-dev] Configuring for a Particular PostgreSQL on Ubuntu
Maybe you can test on your PG 14 installation to preload PostGIS and run the tests. This should work
https://github.com/MobilityDB/MobilityDB/runs/6557831697?check_suite_focus=true
On Mon, May 23, 2022, 22:11 Esteban Zimanyi <estebanzimanyi at gmail.com <mailto:estebanzimanyi at gmail.com> > wrote:
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 <mailto: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 <mailto:lr at pcorp.us> ]
Sent: Monday, May 23, 2022 11:49 AM
To: 'Esteban Zimanyi' <estebanzimanyi at gmail.com <mailto:estebanzimanyi at gmail.com> >
Cc: 'SAKR Mahmoud' <mahmoud.sakr at ulb.be <mailto:mahmoud.sakr at ulb.be> >; 'SCHOEMANS Maxime' <Maxime.Schoemans at ulb.be <mailto:Maxime.Schoemans at ulb.be> >; 'mobilitydb-dev at lists.osgeo.org <mailto:mobilitydb-dev at lists.osgeo.org> ' <mobilitydb-dev at lists.osgeo.org <mailto: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]
Sent: Monday, May 23, 2022 11:38 AM
To: Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> >
Cc: SAKR Mahmoud <mahmoud.sakr at ulb.be <mailto:mahmoud.sakr at ulb.be> >; SCHOEMANS Maxime <Maxime.Schoemans at ulb.be <mailto: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 <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 <mailto: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 <mailto: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/20220525/4c012f0d/attachment-0001.htm>
More information about the Mobilitydb-dev
mailing list