"optimizer.h" not found when building FDW for postgreSQL 11

[ifarcher]

When we try to build the db2_fdw for PostgreSQL 11, the make process stops with the error telling that file "optimizer.h" is not found.

I had a look at the files contained in the postgresql-server-11-dev package (for debian) and the named file seems not to be part of this package, in contrast to ostgresql-server-12-dev, where it exists.

So maybe db2_fdw can currently not be built for PostgreSQL 10 and 11 because of missing optimizer.h.

Regards,
Ingo

[wolfgangbrandl]

I will check. But comment the headerline out please . Mit freundlichen Grüßen Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911 From: ifarcher <notifications@github.com> Reply to: wolfgangbrandl/db2_fdw <reply@reply.github.com> Date: Monday, 6. July 2020 at 16:14 To: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com> Cc: Subscribed <subscribed@noreply.github.com> Subject: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) When we try to build the db2_fdw for PostgreSQL 11, the make process stops with the error telling that file "optimizer.h" is not found. I had a look at the files contained in the postgresql-server-11-dev package (for debian) and the named file seems not to be part of this package, in contrast to ostgresql-server-12-dev, where it exists. So maybe db2_fdw can currently not be built for PostgreSQL 10 and 11 because of missing optimizer.h. Regards, Ingo — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[ifarcher]

Thank you for the answer!
We already did that, but that lead to another problem: then in the generated .so-file a symbol was missing, but I cannot exactly remember its name, it was something like "table_...". This "follow-up-error" was thrown on "create extension".
I did not mention that because when I don't know the precise effect of a change (commenting out a header without any knowledge) any resulting error is not significant, i thought.
Regards,
Ingo

[wolfgangbrandl]

Please try the attached zip file Mit freundlichen Grüßen Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911 From: ifarcher <notifications@github.com> Reply to: wolfgangbrandl/db2_fdw <reply@reply.github.com> Date: Tuesday, 7. July 2020 at 10:36 To: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com> Cc: Brandl Wolfgang <wolfgang.brandl@chello.at>, Comment <comment@noreply.github.com> Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) Thank you for the answer! We already did that, but that lead to another problem: then in the generated .so-file a symbol was missing, but I cannot exactly remember its name, it was something like "table_...". This "follow-up-error" was thrown on "create extension". I did not mention that because when I don't know the precise effect of a change (commenting out a header without any knowledge) any resulting error is not significant, i thought. Regards, Ingo — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[ifarcher]

Sorry, I cannot find any attachment … Ingo Von: Wolfgang Brandl <notifications@github.com> Gesendet: Dienstag, 7. Juli 2020 11:02 An: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com> Cc: Farcher, Ingo (DCCS) <Ingo.Farcher@dccs.at>; Author <author@noreply.github.com> Betreff: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) Please try the attached zip file Mit freundlichen Grüßen Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at<mailto:wolfgang.brandl@chello.at> Mobil: +43 660 7132911 From: ifarcher <notifications@github.com<mailto:notifications@github.com>> Reply to: wolfgangbrandl/db2_fdw <reply@reply.github.com<mailto:reply@reply.github.com>> Date: Tuesday, 7. July 2020 at 10:36 To: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com<mailto:db2_fdw@noreply.github.com>> Cc: Brandl Wolfgang <wolfgang.brandl@chello.at<mailto:wolfgang.brandl@chello.at>>, Comment <comment@noreply.github.com<mailto:comment@noreply.github.com>> Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) Thank you for the answer! We already did that, but that lead to another problem: then in the generated .so-file a symbol was missing, but I cannot exactly remember its name, it was something like "table_...". This "follow-up-error" was thrown on "create extension". I did not mention that because when I don't know the precise effect of a change (commenting out a header without any knowledge) any resulting error is not significant, i thought. Regards, Ingo — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#28 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AQGAFOKDQNXNHMY7D77RLYTR2LQAZANCNFSM4ORUYI5A>.

[wolfgangbrandl]

Go to https://github.com/wolfgangbrandl/db2_fdw and download the zip file Mit freundlichen Grüßen Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911 From: ifarcher <notifications@github.com> Reply to: wolfgangbrandl/db2_fdw <reply@reply.github.com> Date: Tuesday, 7. July 2020 at 15:14 To: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com> Cc: Brandl Wolfgang <wolfgang.brandl@chello.at>, Comment <comment@noreply.github.com> Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) Sorry, I cannot find any attachment … Ingo Von: Wolfgang Brandl <notifications@github.com> Gesendet: Dienstag, 7. Juli 2020 11:02 An: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com> Cc: Farcher, Ingo (DCCS) <Ingo.Farcher@dccs.at>; Author <author@noreply.github.com> Betreff: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) Please try the attached zip file Mit freundlichen Grüßen Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at<mailto:wolfgang.brandl@chello.at> Mobil: +43 660 7132911 From: ifarcher <notifications@github.com<mailto:notifications@github.com>> Reply to: wolfgangbrandl/db2_fdw <reply@reply.github.com<mailto:reply@reply.github.com>> Date: Tuesday, 7. July 2020 at 10:36 To: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com<mailto:db2_fdw@noreply.github.com>> Cc: Brandl Wolfgang <wolfgang.brandl@chello.at<mailto:wolfgang.brandl@chello.at>>, Comment <comment@noreply.github.com<mailto:comment@noreply.github.com>> Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) Thank you for the answer! We already did that, but that lead to another problem: then in the generated .so-file a symbol was missing, but I cannot exactly remember its name, it was something like "table_...". This "follow-up-error" was thrown on "create extension". I did not mention that because when I don't know the precise effect of a change (commenting out a header without any knowledge) any resulting error is not significant, i thought. Regards, Ingo — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#28 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AQGAFOKDQNXNHMY7D77RLYTR2LQAZANCNFSM4ORUYI5A>. — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[ifarcher]

I assume, for the ZIP file you mean the file you can download when clicking the green "Code" Icon - I cannot see any other ZIP file.

So I did that, but there is no difference to the previous behavior.
We commented out all occurrences of optimizer.h.
The we started make => resulting in a lot of warnings, eg. mentioning "table_open", "table_close" etc.
Then we invoked make install.
Then we created the extension:

Error: could not create extension, symbol "table_open" not found in ___.so.

So I cannot see a difference to previous behavior.
Maybe there should be another ZIP file that i cannot see/find?

[wolfgangbrandl]

It seems you have several postgresql installation on the same server. When you compile which pg_setup is executed in the make. What is the output of “which pg_setup” and is this the executable of postgres 12.3? Mit freundlichen Grüßen Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911 From: ifarcher <notifications@github.com> Reply to: wolfgangbrandl/db2_fdw <reply@reply.github.com> Date: Wednesday, 8. July 2020 at 11:57 To: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com> Cc: Brandl Wolfgang <wolfgang.brandl@chello.at>, Comment <comment@noreply.github.com> Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) I assume, for the ZIP file you mean the file you can download when clicking the green "Code" Icon - I cannot see any other ZIP file. So I did that, but there is no difference to the previous behavior. We commented out all occurrences of optimizer.h. The we started make => resulting in a lot of warnings, eg. mentioning "table_open", "table_close" etc. Then we invoked make install. Then we created the extension: Error: could not create extension, symbol "table_open" not found in ___.so. So I cannot see a difference to previous behavior. Maybe there should be another ZIP file that i cannot see/find? — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[wolfgangbrandl]

Where in Austria are you located with dccs.at? Mit freundlichen Grüßen Ing. Wolfgang Brandl Email: wolfgang.brandl@chello.at Mobil: +43 660 7132911 From: ifarcher <notifications@github.com> Reply to: wolfgangbrandl/db2_fdw <reply@reply.github.com> Date: Wednesday, 8. July 2020 at 11:57 To: wolfgangbrandl/db2_fdw <db2_fdw@noreply.github.com> Cc: Brandl Wolfgang <wolfgang.brandl@chello.at>, Comment <comment@noreply.github.com> Subject: Re: [wolfgangbrandl/db2_fdw] "optimizer.h" not found when building FDW for postgreSQL 11 (#28) I assume, for the ZIP file you mean the file you can download when clicking the green "Code" Icon - I cannot see any other ZIP file. So I did that, but there is no difference to the previous behavior. We commented out all occurrences of optimizer.h. The we started make => resulting in a lot of warnings, eg. mentioning "table_open", "table_close" etc. Then we invoked make install. Then we created the extension: Error: could not create extension, symbol "table_open" not found in ___.so. So I cannot see a difference to previous behavior. Maybe there should be another ZIP file that i cannot see/find? — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or unsubscribe.

[ifarcher]

Hi, we dont't have concurrent installations - we did all tries on separate ones. (Would you still need the output of "which pg_setup"?
And we are located in Graz.

Greetings,
Ingo

[wolfgangbrandl]

I unzipped the package. and tested it with postgresql 12.3 No problem just 4 warnings which i have to correct. What is the output of the following: gmake clean gmake -n and the Output of psql

ifarcher ***@***.***> hat am 9. Juli 2020 um 07:11 geschrieben: Hi, we dont't have concurrent installations - we did all tries on separate ones. (Would you still need the output of "which pg_setup"? And we are located in Graz. Greetings, Ingo — You are receiving this because you commented. Reply to this email directly, view it on GitHub #28 (comment) , or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMUXO2ETBLVWQR4VVXK543R2VGOJANCNFSM4ORUYI5A .

mfg. Ing. Wolfgang Brandl Mobil: +43 660 7132911

[ifarcher]

Hi,
yes, with PostgreSQL 12 make runs quite fine but "import schema" fails (see my other issue-posting).
Assuming that "import schema" could be working for older postgreSQL versions, we tried it with PG 11.
But for PostgreSQL 11 make fails because of missing optimizer.h, and when we comment that out, it throws a large number of warnings (more than 30).
Trying to create the extension afterwards fails, mentioning missing symbols in the .so file.
The missing symbols seem to correspond to the previous warnings.

Below you can find the requested output of make (gmake not installed):

root@db1:/opt/install/db2_fdw-master# make clean
rm -f db2_fdw.so   libdb2_fdw.a  libdb2_fdw.pc
rm -f db2_fdw.o db2_utils.o db2_fdw.bc db2_utils.bc
rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/

root@ db1:/opt/install/db2_fdw-master# make -n
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -g -fPIC -I/include -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5  -c -o db2_fdw.o db2_fdw.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -g -fPIC -I/include -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5  -c -o db2_utils.o db2_utils.c
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -shared -o db2_fdw.so db2_fdw.o db2_utils.o -L/usr/lib/x86_64-linux-gnu  -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-7/lib  -L/usr/lib/x86_64-linux-gnu/mit-krb5 -Wl,--as-needed  -fPIC -L/lib64 -L/bin  -ldb2ci
/usr/bin/clang-7 -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2  -g -fPIC -I/include -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5 -flto=thin -emit-llvm -c -o db2_fdw.bc db2_fdw.c
/usr/bin/clang-7 -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2  -g -fPIC -I/include -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal  -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/mit-krb5 -flto=thin -emit-llvm -c -o db2_utils.bc db2_utils.c

… and the output of psql:

root@db1:/opt/install/db2_fdw-master# psql -U postgres
psql (11.8 (Debian 11.8-1.pgdg100+1))
Type "help" for help.

postgres=#

[devrimgunduz]

Hi,

3.0.1 cannot be built against v11 (optimizer.h does not exist in versions less than 12). You will need to add a check around relevant lines.

[wolfgangbrandl]

korrekted

Devrim Gündüz ***@***.***> hat am 29. Juli 2020 um 13:06 geschrieben: Hi, 3.0.1 cannot be built against v11 (optimizer.h does not exist in versions less than 12). You will need to add a check around relevant lines. — You are receiving this because you commented. Reply to this email directly, view it on GitHub #28 (comment) , or unsubscribe https://github.com/notifications/unsubscribe-auth/ACMUXO24GOAMZF5NB7TEZI3R577DDANCNFSM4ORUYI5A .

mfg. Ing. Wolfgang Brandl Mobil: +43 660 7132911