BUG #14286: PostgreSQL build tests segfaulting

The following bug has been logged on the website:

Bug reference: 14286
Logged by: Regina Obe
Email address: lr(at)pcorp(dot)us
PostgreSQL version: 9.6beta3
Operating system: Debian 8
Description:

This could be something wrong in my config, but since August 8th, our
PostGIS Debian build bot has been segfaulting in the PostgreSQL tests
packaged with PostgreSQL. I hadn't changed anything so not sure what could
have caused this.

The issue started somewhere between:

a1f8b6bd14adb724365d91dcc58079ac3a2293e7 (last successful one where all
tests past)

and

this is when things go downhill:
-- one of these changes --
Changes

Sort out paired double quotes in \connect, \password and \crosstabview.
(detail)
Introduce a psql "\connect -reuse-previous=on|off" option. (detail)
Field conninfo strings throughout src/bin/scripts. (detail)
Reject, in pg_dumpall, names containing CR or LF. (detail)
Fix Windows shell argument quoting. (detail)
Promote pg_dumpall shell/connstr quoting functions to src/fe_utils.
(detail)
Obstruct shell, SQL, and conninfo injection via database and role names.
(detail)
Fix two errors with nested CASE/WHEN constructs. (detail)
Translation updates (detail)
Fix several one-byte buffer over-reads in to_number (detail)

Revision: 9a46324fd46506c86b190d3163902ed90072c53c

----

PATH="/var/lib/jenkins/workspace/pg/pg96git/tmp_install/var/lib/jenkins/workspace/pg/rel/pg9.6w64/bin:$PATH"
LD_LIBRARY_PATH="/var/lib/jenkins/workspace/pg/pg96git/tmp_install/var/lib/jenkins/workspace/pg/rel/pg9.6w64/lib"
../../../src/test/regress/pg_regress --inputdir=.
--temp-instance=./tmp_check --bindir= --dlpath=.
--schedule=./parallel_schedule
============== creating temporary instance ==============
============== initializing database system ==============
============== starting postmaster ==============
running on port 57832 with PID 18592
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test tablespace ... ok
parallel group (20 tests): float4 oid pg_lsn txid int2 char varchar money
name int4 regproc boolean float8 text uuid bit int8 enum numeric
rangetypes
boolean ... ok
char ... ok
name ... ok
varchar ... ok
text ... ok
int2 ... ok
int4 ... ok
int8 ... ok
oid ... ok
float4 ... ok
float8 ... ok
bit ... ok
numeric ... ok
txid ... ok
uuid ... ok
enum ... ok
money ... ok
rangetypes ... ok
pg_lsn ... ok
regproc ... ok
test strings ... FAILED (test process was terminated by
signal 11: Segmentation fault)
test numerology ... ok
parallel group (20 tests): comments timetz lseg circle polygon reltime
abstime time macaddr path tinterval box line point inet interval tstypes
date timestamp timestamptz
point ... ok
lseg ... ok
line ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
macaddr ... ok
tstypes ... ok
comments ... ok
parallel group (6 tests): geometry horology type_sanity oidjoins opr_sanity
regex
geometry ... ok
horology ... ok
regex ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... FAILED (test process was terminated by
signal 11: Segmentation fault)
test insert ... FAILED (test process was terminated by
signal 11: Segmentation fault)
test insert_conflict ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
parallel group (3 tests): copydml copyselect copy
copy ... ok
copyselect ... FAILED (test process was terminated by
signal 11: Segmentation fault)
copydml ... FAILED (test process was terminated by
signal 11: Segmentation fault)
parallel group (2 tests): create_operator create_misc
create_misc ... ok
create_operator ... ok
parallel group (2 tests): create_view create_index
create_index ... FAILED (test process was terminated by
signal 11: Segmentation fault)
create_view ... FAILED (test process was terminated by
signal 11: Segmentation fault)
parallel group (14 tests): typed_table create_aggregate rolenames
roleattributes create_cast drop_if_exists create_am create_function_3
create_table_like vacuum inherit constraints triggers updatable_views
create_aggregate ... FAILED (test process was terminated by
signal 11: Segmentation fault)
create_function_3 ... ok
create_cast ... ok
constraints ... ok
triggers ... FAILED (test process was terminated by
signal 11: Segmentation fault)
inherit ... FAILED (test process was terminated by
signal 11: Segmentation fault)
create_table_like ... FAILED (test process was terminated by
signal 11: Segmentation fault)
typed_table ... FAILED (test process was terminated by
signal 11: Segmentation fault)
vacuum ... ok
drop_if_exists ... ok
updatable_views ... FAILED (test process was terminated by
signal 11: Segmentation fault)
rolenames ... FAILED (test process was terminated by
signal 11: Segmentation fault)
roleattributes ... ok
create_am ... ok
test sanity_check ... FAILED (test process was terminated by
signal 11: Segmentation fault)
test errors ... FAILED (test process was terminated by
signal 11: Segmentation fault)
test select ... ok
parallel group (20 tests): select_distinct_on random select_having delete
select_distinct update select_implicit namespace case btree_index hash_index
select_into union transactions portals subselect arrays aggregates join
prepared_xacts
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... ok
aggregates ... ok
transactions ... ok
random ... ok
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
prepared_xacts ... FAILED (test process was terminated by
signal 11: Segmentation fault)
delete ... ok
parallel group (16 tests): init_privs drop_operator security_label
tablesample lock collate replica_identity matview groupingsets
object_address privileges spgist gin rowsecurity gist brin
brin ... ok
gin ... ok
gist ... ok
spgist ... ok
privileges ... FAILED (test process was terminated by
signal 11: Segmentation fault)
init_privs ... ok
security_label ... ok
collate ... FAILED (test process was terminated by
signal 11: Segmentation fault)
matview ... FAILED (test process was terminated by
signal 11: Segmentation fault)
lock ... ok
replica_identity ... FAILED (test process was terminated by
signal 11: Segmentation fault)
rowsecurity ... ok
object_address ... ok
tablesample ... FAILED (test process was terminated by
signal 11: Segmentation fault)
groupingsets ... ok
drop_operator ... ok
parallel group (7 tests): async alter_operator dbsize psql misc_functions
misc alter_generic
alter_generic ... ok
alter_operator ... ok
misc ... FAILED
psql ... FAILED (test process was terminated by
signal 11: Segmentation fault)
async ... ok
dbsize ... ok
misc_functions ... ok
parallel group (3 tests): psql_crosstab select_parallel rules
rules ... FAILED (test process was terminated by
signal 11: Segmentation fault)
psql_crosstab ... FAILED (test process was terminated by
signal 11: Segmentation fault)
select_parallel ... ok
parallel group (20 tests): json_encoding portals_p2 foreign_data combocid
advisory_lock dependency xmlmap tsdicts guc equivclass functional_deps json
tsearch select_views window jsonb cluster indirect_toast foreign_key
bitmapops
select_views ... ok
portals_p2 ... ok
foreign_key ... ok
cluster ... ok
dependency ... FAILED (test process was terminated by
signal 11: Segmentation fault)
guc ... ok
bitmapops ... ok
combocid ... ok
tsearch ... FAILED (test process was terminated by
signal 11: Segmentation fault)
tsdicts ... ok
foreign_data ... FAILED (test process was terminated by
signal 11: Segmentation fault)
window ... ok
xmlmap ... ok
functional_deps ... ok
advisory_lock ... ok
json ... ok
jsonb ... ok
json_encoding ... ok
indirect_toast ... ok
equivclass ... ok
parallel group (19 tests): conversion temp prepare largeobject limit copy2
xml with returning plancache alter_table polymorphism sequence without_oid
rowtypes truncate domain rangefuncs plpgsql
plancache ... ok
limit ... ok
plpgsql ... ok
copy2 ... FAILED (test process was terminated by
signal 11: Segmentation fault)
temp ... FAILED (test process was terminated by
signal 11: Segmentation fault)
domain ... ok
rangefuncs ... ok
prepare ... ok
without_oid ... ok
conversion ... ok
truncate ... ok
alter_table ... FAILED (test process was terminated by
signal 11: Segmentation fault)
sequence ... ok
polymorphism ... FAILED (test process was terminated by
signal 11: Segmentation fault)
rowtypes ... ok
returning ... ok
largeobject ... FAILED (test process was terminated by
signal 11: Segmentation fault)
with ... FAILED (test process was terminated by
signal 11: Segmentation fault)
xml ... FAILED (test process was terminated by
signal 11: Segmentation fault)
test event_trigger ... ok
test stats ... ok
============== shutting down postmaster ==============

=========================
36 of 166 tests failed.
=========================

--- And as such our PostGIS tests are crashing too now --

-- Configure is done with

--enable-cassert --enable-debug --without-zlib

The only thing I can think of is maybe the make clean is not cleaning out
everything because I don't seem to be able to replicate on my mingw install
with the most recent tar ball.

I do have the Debian bot set to remove the install and cluster and
reinstall.