PostGIS 2.4 and 2.5 address_standardizer on windows won't compile anymore

[robe]

Sadly I'm still having issue on winnie with address_standardizer compiling on 2.4 and 2.5. The PostGIS 3 series is fine.

  C compiler:           x86_64-w64-mingw32-gcc -Wall -fno-omit-frame-pointer
  SQL preprocessor:     /mingw/bin/cpp -traditional-cpp -w -P

 -------------- Additional Info ------------- 
  Interrupt Tests:   DISABLED use: --with-interrupt-tests to enable

 -------------- Dependencies -------------- 
  GEOS config:          /projects/geos/rel-3.8.1w64gcc81/bin/geos-config
  GEOS version:         3.8.1
  GDAL config:          /projects/gdal/rel-2.4.4w64gcc81/bin/gdal-config
  GDAL version:         2.4.4
  SFCGAL config:        /projects/CGAL/rel-sfcgal-1.3.8w64gcc81/bin/sfcgal-config
  SFCGAL version:       1.3.8
  PostgreSQL config:    /projects/postgresql/rel/pg10w64gcc81/bin/pg_config
  PostgreSQL version:   PostgreSQL 10.15
  PROJ4 version:        52
  Libxml2 config:       /projects/libxml/rel-libxml2-2.7.8w64gcc81/bin/xml2-config
  Libxml2 version:      2.9.9
  JSON-C support:       yes
  protobuf-c support:   yes
  protobuf-c version:   1002001
  PCRE support:         yes
  Perl:                 /bin/perl

 --------------- Extensions --------------- 
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       enabled
  Address Standardizer support:       enabled

 -------- Documentation Generation -------- 

libxml2-2.9.9w64gcc81/include -I./src/include/port/win32 -DEXEC_BACKEND -I/projects/libxml/rel-libxml2-2.9.9w64gcc81/include/libxml2  -IE:/jenkins/postgresql/rel/pg10w64gcc81/include/server/port/win32 -DWIN32_STACK_RLIMIT=4194304  -c -o pagc_tools.o pagc_tools.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 -O2  -Wall -fno-omit-frame-pointer  -IE:/jenkins/geos/rel-3.8.1w64gcc81/include -I/projects/proj/rel-5.2.0w64gcc81/include -DACCEPT_USE_OF_DEPRECATED_PROJ_API_H=1 -I/projects/protobuf/rel-3.2.0w64gcc81/include -I/projects/libxml/rel-libxml2-2.7.8w64gcc81/include/libxml2 -I/projects/CGAL/rel-sfcgal-1.3.8w64gcc81/include -DHAVE_SFCGAL -I/projects/json-c/rel-0.12w64gcc81/include -I/projects/pcre/rel-8.33w64gcc81/include -I/projects/postgresql/rel/pg10w64gcc81/include -I/projects/rel-libiconv-1.13.1w64gcc81/include -I. -I./ -IE:/jenkins/postgresql/rel/pg10w64gcc81/include/server -IE:/jenkins/postgresql/rel/pg10w64gcc81/include/internal  -I/projects/zlib/rel-zlib-1.2.11w64gcc81/include  -I/projects/libxml/rel-libxml2-2.9.9w64gcc81/include -I./src/include/port/win32 -DEXEC_BACKEND -I/projects/libxml/rel-libxml2-2.9.9w64gcc81/include/libxml2  -IE:/jenkins/postgresql/rel/pg10w64gcc81/include/server/port/win32 -DWIN32_STACK_RLIMIT=4194304  -c -o parseaddress-api.o parseaddress-api.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 -O2  -Wall -fno-omit-frame-pointer  -IE:/jenkins/geos/rel-3.8.1w64gcc81/include -I/projects/proj/rel-5.2.0w64gcc81/include -DACCEPT_USE_OF_DEPRECATED_PROJ_API_H=1 -I/projects/protobuf/rel-3.2.0w64gcc81/include -I/projects/libxml/rel-libxml2-2.7.8w64gcc81/include/libxml2 -I/projects/CGAL/rel-sfcgal-1.3.8w64gcc81/include -DHAVE_SFCGAL -I/projects/json-c/rel-0.12w64gcc81/include -I/projects/pcre/rel-8.33w64gcc81/include -I/projects/postgresql/rel/pg10w64gcc81/include -I/projects/rel-libiconv-1.13.1w64gcc81/include -I. -I./ -IE:/jenkins/postgresql/rel/pg10w64gcc81/include/server -IE:/jenkins/postgresql/rel/pg10w64gcc81/include/internal  -I/projects/zlib/rel-zlib-1.2.11w64gcc81/include  -I/projects/libxml/rel-libxml2-2.9.9w64gcc81/include -I./src/include/port/win32 -DEXEC_BACKEND -I/projects/libxml/rel-libxml2-2.9.9w64gcc81/include/libxml2  -IE:/jenkins/postgresql/rel/pg10w64gcc81/include/server/port/win32 -DWIN32_STACK_RLIMIT=4194304  -c -o standard.o standard.c

during RTL pass: final
standard.c: In function 'std_standardize':
standard.c:535:1: internal compiler error: in based_loc_descr, at dwarf2out.c:14264
 }
 ^
libbacktrace could not find executable to open
Please submit a full bug report,
with preprocessed source if appropriate.
See <https://sourceforge.net/projects/mingw-w64> for instructions.
make[2]: *** [<builtin>: standard.o] Error 1
make[2]: Leaving directory '/projects/postgis/branches/2.4/extensions/address_standardizer'
make[1]: *** [Makefile:26: all] Error 1
make[1]: Leaving directory '/projects/postgis/branches/2.4/extensions'
make: *** [GNUmakefile:16: all] Error 1

I'm not sure how long it's been broken since I haven't shipped 2.4 and 2.5 in quite sometime, preferring to ship the newer PostGIS even for older PostgreSQL.

[pramsey]

According to blame nothing in that file has changed in 5 years... any way to bump your compiler version up a notch or two?

[robe]

It's using the same compiler as PostGIS 3 so the issue might be related to the autoconf upgrades in mingw64. I'll check and see what I missed backporting. I had to backport autoconf fixes for PostGIS 2.4 and PostGIS 2.5 to compile at all.

[robe]

still failing. Going to try and fix. But must be autoconf at fault.

[Regina Obe <lr@…>]

In cbb2c95/git:

1. Allow detection of pcre using pkg-config
2. Change windows build to use pkg-config for pcre. References #4980 for PostGIS 2.5.6

[robe]

Okay the changes to use pkg-config seemed to do the trick of compiling for mingw64. Will try to do the same for 2.4 branch.

[robe]

Should be fixed at [bee56fc7dd/git] for PostGIS 2.4.10