Can't Compile develop on mingw64 - SYNCHRONIZE reserved keyword? about mobilitydb

[robe2]

I think SYNCHRONIZE might be a reserved keyword. If I replace it with something like SYNCHRONIZE_NOCROSS then I get past that step.

[estebanzimanyi]

It seems that is indeed the case. In the file \mingw-w64-v9.0.0\mingw-w64-headers\include\winnt.h there is the following definition
#define SYNCHRONIZE (__MSABI_LONG(0x00100000))
I changed the definition in MobilityDB as you suggested. This is already in the develop branch.

[estebanzimanyi]

BTW when using mingw (the traditional 32 bit version) for running the tests it is necessary to create the database and this is done calling initdb. However, this complains about the permissions of the repertory used for initdb.

esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ initdb -D db
The files belonging to this database system will be owned by user "esteban".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory db ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 20
selecting default shared_buffers ... 400kB
selecting default time zone ... Europe/Brussels
creating configuration files ... ok
running bootstrap script ... 2021-07-22 11:21:25.046 CEST [3929] FATAL:  data directory "/mnt/c/MobilityDB-develop/build/tmptest/db" has invalid permissions
2021-07-22 11:21:25.046 CEST [3929] DETAIL:  Permissions should be u=rwx (0700) or u=rwx,g=rx (0750).
child process exited with exit code 1
initdb: removing contents of data directory "db"
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$

However, it is reported that chmod does not work for windows

esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build$ ls
CMakeCache.txt       DartConfiguration.tcl  cmake_install.cmake   mobilitydb--1.0.sql    sqlin
CMakeFiles           Makefile               install_manifest.txt  mobilitydb--1.0.sql.c  tmptest
CTestTestfile.cmake  Testing                libMobilityDB.so      mobilitydb.control
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build$ cd tmptest
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ ls
db  lock  log  out
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ ls -l
total 0
drwxrwxrwx 1 esteban esteban 512 Jul 21 15:32 db
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 lock
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 log
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 out
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ chmod 700 db
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ ls -l
total 0
drwxrwxrwx 1 esteban esteban 512 Jul 21 15:32 db
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 lock
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 log
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 out
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$

Maybe you know how to cope with this issue

[cvvergara]

ah, nice catch @robe2
Without the need to modify postgresql.conf, I can do this in my computer

create extension mobilitydb CASCADE;
NOTICE:  installing required extension "postgis"
CREATE EXTENSION
mobtest=# select mobilitydb_version();
  mobilitydb_version   
-----------------------
 MobilityDB 1.0 beta 3
(1 row)

Will add a test on the actions that displays the version, on my next PR

[robe2]

BTW when using mingw (the traditional 32 bit version) for running the tests it is necessary to create the database and this is done calling initdb. However, this complains about the permissions of the repertory used for initdb.

esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ initdb -D db
The files belonging to this database system will be owned by user "esteban".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory db ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 20
selecting default shared_buffers ... 400kB
selecting default time zone ... Europe/Brussels
creating configuration files ... ok
running bootstrap script ... 2021-07-22 11:21:25.046 CEST [3929] FATAL:  data directory "/mnt/c/MobilityDB-develop/build/tmptest/db" has invalid permissions
2021-07-22 11:21:25.046 CEST [3929] DETAIL:  Permissions should be u=rwx (0700) or u=rwx,g=rx (0750).
child process exited with exit code 1
initdb: removing contents of data directory "db"
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$

However, it is reported that chmod does not work for windows

esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build$ ls
CMakeCache.txt       DartConfiguration.tcl  cmake_install.cmake   mobilitydb--1.0.sql    sqlin
CMakeFiles           Makefile               install_manifest.txt  mobilitydb--1.0.sql.c  tmptest
CTestTestfile.cmake  Testing                libMobilityDB.so      mobilitydb.control
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build$ cd tmptest
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ ls
db  lock  log  out
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ ls -l
total 0
drwxrwxrwx 1 esteban esteban 512 Jul 21 15:32 db
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 lock
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 log
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 out
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ chmod 700 db
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$ ls -l
total 0
drwxrwxrwx 1 esteban esteban 512 Jul 21 15:32 db
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 lock
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 log
drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 out
esteban@DESKTOP-9FBND60:/mnt/c/MobilityDB-develop/build/tmptest$

Maybe you know how to cope with this issue

Yah chmod isn't supported under windows to my knowledge but I use msys2 for my tool chain and it understands chmod. That said I've never had to use that command. So not sure it really works under msys2 either, might just fake it. Are you only getting this on 32-bit chain? I don't ship any new major releases of anything on the 32-bit chain anymore because EDB stopped supporting 32-bit since so few people use it. So 32-bit is only relevant for supporting PG 10 and lower on windows - https://www.enterprisedb.com/download-postgresql-binaries

[estebanzimanyi]

I just started using MinGW and therefore it was easy to start with the traditional/old version. I will install the new mingw-w64 version and try again soon.

…

------------------------------------------------------------ Prof. Esteban Zimanyi Department of Computer & Decision Engineering (CoDE) CP 165/15 Universite Libre de Bruxelles Avenue F. D. Roosevelt 50 B-1050 Brussels, Belgium fax: + 32.2.650.47.13 tel: + 32.2.650.31.85 e-mail: ***@***.*** Internet: http://cs.ulb.ac.be/members/esteban/ ------------------------------------------------------------

On Thu, Jul 22, 2021 at 9:26 PM Regina Obe ***@***.***> wrote: BTW when using mingw (the traditional 32 bit version) for running the tests it is necessary to create the database and this is done calling initdb. However, this complains about the permissions of the repertory used for initdb. ***@***.***:/mnt/c/MobilityDB-develop/build/tmptest$ initdb -D db The files belonging to this database system will be owned by user "esteban". This user must also own the server process. The database cluster will be initialized with locale "C.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory db ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 20 selecting default shared_buffers ... 400kB selecting default time zone ... Europe/Brussels creating configuration files ... ok running bootstrap script ... 2021-07-22 11:21:25.046 CEST [3929] FATAL: data directory "/mnt/c/MobilityDB-develop/build/tmptest/db" has invalid permissions 2021-07-22 11:21:25.046 CEST [3929] DETAIL: Permissions should be u=rwx (0700) or u=rwx,g=rx (0750). child process exited with exit code 1 initdb: removing contents of data directory "db" ***@***.***:/mnt/c/MobilityDB-develop/build/tmptest$ However, it is reported that chmod does not work for windows ***@***.***:/mnt/c/MobilityDB-develop/build$ ls CMakeCache.txt DartConfiguration.tcl cmake_install.cmake mobilitydb--1.0.sql sqlin CMakeFiles Makefile install_manifest.txt mobilitydb--1.0.sql.c tmptest CTestTestfile.cmake Testing libMobilityDB.so mobilitydb.control ***@***.***:/mnt/c/MobilityDB-develop/build$ cd tmptest ***@***.***:/mnt/c/MobilityDB-develop/build/tmptest$ ls db lock log out ***@***.***:/mnt/c/MobilityDB-develop/build/tmptest$ ls -l total 0 drwxrwxrwx 1 esteban esteban 512 Jul 21 15:32 db drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 lock drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 log drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 out ***@***.***:/mnt/c/MobilityDB-develop/build/tmptest$ chmod 700 db ***@***.***:/mnt/c/MobilityDB-develop/build/tmptest$ ls -l total 0 drwxrwxrwx 1 esteban esteban 512 Jul 21 15:32 db drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 lock drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 log drwxrwxrwx 1 esteban esteban 512 Jul 21 14:54 out ***@***.***:/mnt/c/MobilityDB-develop/build/tmptest$ Maybe you know how to cope with this issue Yah chmod isn't supported under windows to my knowledge but I use msys2 for my tool chain and it understands chmod. That said I've never had to use that command. So not sure it really works under msys2 either, might just fake it. Are you only getting this on 32-bit chain? I don't ship any new major releases of anything on the 32-bit chain anymore because EDB stopped supporting 32-bit since so few people use it. So 32-bit is only relevant for supporting PG 10 and lower on windows - https://www.enterprisedb.com/download-postgresql-binaries — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#91 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AGNHMBRB77AMA4C3C65FFZLTZBWFFANCNFSM5AZD2LOQ> .