[MacPorts] #71796: postgresql15 @15.10_1 fails test on PPC Leopard, Mac OS X 10.5.8, because Unix-domain socket path "/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/.tmp/pg_regress-INcw0M/.s.PGSQL.51706" is too long (maximum 103 bytes)
MacPorts
noreply at macports.org
Thu Jan 9 15:47:45 UTC 2025
#71796: postgresql15 @15.10_1 fails test on PPC Leopard, Mac OS X 10.5.8, because
Unix-domain socket path
"/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/.tmp
/pg_regress-INcw0M/.s.PGSQL.51706" is too long (maximum 103 bytes)
---------------------------+-------------------------
Reporter: ballapete | Owner: (none)
Type: defect | Status: new
Priority: Normal | Milestone:
Component: ports | Version: 2.10.5
Resolution: | Keywords: leopard ppc
Port: postgresql15 |
---------------------------+-------------------------
Comment (by ballapete):
As with issues #71794 and #71795 I can test the remains of the failing
MacPorts tests "privately" and successful:
{{{
-*- mode: compilation; default-directory:
"/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10/"
-*-
Compilation started at Thu Jan 9 15:22:42
time nice +11 gnumake -k check
gnumake -C ./src/backend generated-headers
gnumake -C catalog distprep generated-header-symlinks
gnumake[2]: Nothing to be done for `distprep'.
gnumake[2]: Nothing to be done for `generated-header-symlinks'.
gnumake -C utils distprep generated-header-symlinks
gnumake[2]: Nothing to be done for `distprep'.
gnumake[2]: Nothing to be done for `generated-header-symlinks'.
rm -rf
'/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10'/tmp_install
/opt/local/bin/gmkdir -p
'/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10'/tmp_install/log
gnumake -C '.'
DESTDIR='/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10'/tmp_install
install
>'/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10'/tmp_install/log/install.log
2>&1
gnumake -j1 -C src/test/regress checkprep
>>'/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10'/tmp_install/log/install.log
2>&1
gnumake -C src/test/regress check
gnumake -C ../../../src/port all
gnumake[2]: Nothing to be done for `all'.
gnumake -C ../../../src/common all
gnumake[2]: Nothing to be done for `all'.
gnumake -C ../../../contrib/spi
gnumake[2]: Nothing to be done for `all'.
echo "+++ regress check in src/test/regress +++" &&
PATH="/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10/tmp_install/opt/local/lib/postgresql15/bin:/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10/src/test/regress:$PATH"
DYLD_LIBRARY_PATH="/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10/tmp_install/opt/local/lib/postgresql15"
../../../src/test/regress/pg_regress --temp-instance=./tmp_check
--inputdir=. --bindir= --dlpath=. --max-concurrent-tests=20
--schedule=./parallel_schedule
+++ regress check in src/test/regress +++
============== removing existing temp instance ==============
============== creating temporary instance ==============
============== initializing database system ==============
============== starting postmaster ==============
running on port 51706 with PID 80872
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries ==============
test test_setup ... ok 18506 ms
test tablespace ... ok 32022 ms
parallel group (20 tests): char regproc oid int2 varchar int4 txid int8
text name money pg_lsn float4 float8 boolean uuid bit enum numeric
rangetypes
boolean ... ok 6868 ms
char ... ok 4447 ms
name ... ok 5276 ms
varchar ... ok 4799 ms
text ... ok 5228 ms
int2 ... ok 4722 ms
int4 ... ok 4764 ms
int8 ... ok 5123 ms
oid ... ok 4586 ms
float4 ... ok 5429 ms
float8 ... ok 6350 ms
bit ... ok 7599 ms
numeric ... ok 14911 ms
txid ... ok 4867 ms
uuid ... ok 6919 ms
enum ... ok 7929 ms
money ... ok 4878 ms
rangetypes ... ok 18526 ms
pg_lsn ... ok 4848 ms
regproc ... ok 3969 ms
parallel group (19 tests): line lseg time path timetz circle date point
macaddr macaddr8 timestamp numerology interval inet timestamptz strings
multirangetypes box polygon
strings ... ok 14027 ms
numerology ... ok 7839 ms
point ... ok 6193 ms
lseg ... ok 4136 ms
line ... ok 3555 ms
box ... ok 20060 ms
path ... ok 4897 ms
polygon ... ok 20175 ms
circle ... ok 5266 ms
date ... ok 5770 ms
time ... ok 4643 ms
timetz ... ok 5064 ms
timestamp ... ok 7280 ms
timestamptz ... ok 9583 ms
interval ... ok 8230 ms
inet ... ok 9087 ms
macaddr ... ok 6187 ms
macaddr8 ... ok 6714 ms
multirangetypes ... ok 17487 ms
parallel group (13 tests): comments misc_sanity unicode tstypes xid
horology expressions geometry mvcc type_sanity opr_sanity database regex
geometry ... ok 9699 ms
horology ... ok 7833 ms
tstypes ... ok 4310 ms
regex ... ok 22071 ms
type_sanity ... ok 11194 ms
opr_sanity ... ok 21558 ms
misc_sanity ... ok 2479 ms
comments ... ok 2425 ms
expressions ... ok 8635 ms
unicode ... ok 2919 ms
xid ... ok 5249 ms
mvcc ... ok 10642 ms
database ... ok 21678 ms
parallel group (5 tests): copydml copyselect copy insert_conflict insert
copy ... ok 6621 ms
copyselect ... ok 3552 ms
copydml ... ok 3245 ms
insert ... ok 32962 ms
insert_conflict ... ok 12243 ms
parallel group (7 tests): create_function_c create_operator create_type
create_schema create_procedure create_misc create_table
create_function_c ... ok 1777 ms
create_misc ... ok 5108 ms
create_operator ... ok 2252 ms
create_procedure ... ok 4978 ms
create_table ... ok 21583 ms
create_type ... ok 3777 ms
create_schema ... ok 4614 ms
parallel group (5 tests): index_including index_including_gist
create_view create_index_spgist create_index
create_index ... ok 38537 ms
create_index_spgist ... ok 29368 ms
create_view ... ok 23227 ms
index_including ... ok 18547 ms
index_including_gist ... ok 19113 ms
parallel group (16 tests): errors create_cast roleattributes
create_aggregate hash_func drop_if_exists select typed_table
create_function_sql create_am constraints infinite_recurse vacuum
updatable_views inherit triggers
create_aggregate ... ok 6409 ms
create_function_sql ... ok 15984 ms
create_cast ... ok 5071 ms
constraints ... ok 31000 ms
triggers ... ok 97360 ms
select ... ok 8384 ms
inherit ... ok 78206 ms
typed_table ... ok 14621 ms
vacuum ... ok 48113 ms
drop_if_exists ... ok 7293 ms
updatable_views ... ok 72803 ms
roleattributes ... ok 4890 ms
create_am ... ok 20293 ms
hash_func ... ok 6529 ms
errors ... ok 3034 ms
infinite_recurse ... ok 43415 ms
test sanity_check ... ok 5492 ms
parallel group (20 tests): select_distinct_on random select_having case
delete namespace select_implicit prepared_xacts select_into transactions
portals union arrays subselect select_distinct join aggregates update
hash_index btree_index
select_into ... ok 11363 ms
select_distinct ... ok 24092 ms
select_distinct_on ... ok 3389 ms
select_implicit ... ok 7017 ms
select_having ... ok 5022 ms
subselect ... ok 21758 ms
union ... ok 19263 ms
case ... ok 5604 ms
join ... ok 47786 ms
aggregates ... ok 51657 ms
transactions ... ok 11944 ms
random ... ok 4007 ms
portals ... ok 14281 ms
arrays ... ok 20882 ms
btree_index ... ok 71123 ms
hash_index ... ok 55739 ms
update ... ok 53534 ms
delete ... ok 6221 ms
namespace ... ok 6461 ms
prepared_xacts ... ok 10188 ms
parallel group (20 tests): init_privs drop_operator security_label lock
tablesample object_address collate password replica_identity groupingsets
identity generated matview spgist rowsecurity gin gist brin join_hash
privileges
brin ... ok 82229 ms
gin ... ok 67572 ms
gist ... ok 72719 ms
spgist ... ok 59043 ms
privileges ... ok 87271 ms
init_privs ... ok 3393 ms
security_label ... ok 6079 ms
collate ... ok 21122 ms
matview ... ok 58293 ms
lock ... ok 8873 ms
replica_identity ... ok 27151 ms
rowsecurity ... ok 60438 ms
object_address ... ok 13893 ms
tablesample ... ok 11940 ms
groupingsets ... ok 37081 ms
drop_operator ... ok 4839 ms
password ... ok 24801 ms
identity ... ok 49840 ms
generated ... ok 55542 ms
join_hash ... ok 82033 ms
parallel group (2 tests): brin_bloom brin_multi
brin_bloom ... ok 2096 ms
brin_multi ... ok 4117 ms
parallel group (16 tests): async dbsize alter_operator tidrangescan tsrf
tidscan tid create_role sysviews alter_generic misc_functions misc
incremental_sort merge collate.icu.utf8 create_table_like
create_table_like ... ok 21275 ms
alter_generic ... ok 8255 ms
alter_operator ... ok 2574 ms
misc ... ok 10675 ms
async ... ok 2283 ms
dbsize ... ok 2318 ms
merge ... ok 17192 ms
misc_functions ... ok 8607 ms
sysviews ... ok 7911 ms
tsrf ... ok 5206 ms
tid ... ok 6017 ms
tidscan ... ok 5617 ms
tidrangescan ... ok 3861 ms
collate.icu.utf8 ... ok 20414 ms
incremental_sort ... ok 10694 ms
create_role ... ok 6595 ms
parallel group (6 tests): collate.linux.utf8 amutils psql_crosstab rules
psql stats_ext
rules ... ok 24005 ms
psql ... ok 24733 ms
psql_crosstab ... ok 2777 ms
amutils ... ok 1838 ms
stats_ext ... ok 78924 ms
collate.linux.utf8 ... ok 1353 ms
test select_parallel ... ok 28210 ms
test write_parallel ... ok 2320 ms
test vacuum_parallel ... ok 2301 ms
parallel group (2 tests): subscription publication
publication ... ok 13062 ms
subscription ... ok 819 ms
parallel group (17 tests): portals_p2 advisory_lock combocid tsdicts
equivclass guc xmlmap functional_deps dependency select_views window
tsearch indirect_toast bitmapops cluster foreign_data foreign_key
select_views ... ok 10946 ms
portals_p2 ... ok 2972 ms
foreign_key ... ok 54960 ms
cluster ... ok 29065 ms
dependency ... ok 10007 ms
guc ... ok 7328 ms
bitmapops ... ok 23771 ms
combocid ... ok 4125 ms
tsearch ... ok 18283 ms
tsdicts ... ok 5069 ms
foreign_data ... ok 30860 ms
window ... ok 16477 ms
xmlmap ... ok 7589 ms
functional_deps ... ok 8601 ms
advisory_lock ... ok 3672 ms
indirect_toast ... ok 23078 ms
equivclass ... ok 6391 ms
parallel group (6 tests): jsonpath_encoding jsonpath json_encoding
jsonb_jsonpath json jsonb
json ... ok 5898 ms
jsonb ... ok 8152 ms
json_encoding ... ok 1385 ms
jsonpath ... ok 1179 ms
jsonpath_encoding ... ok 1009 ms
jsonb_jsonpath ... ok 2253 ms
parallel group (18 tests): prepare limit returning polymorphism plancache
conversion copy2 temp largeobject rowtypes sequence rangefuncs with domain
truncate plpgsql alter_table xml
plancache ... ok 12559 ms
limit ... ok 7290 ms
plpgsql ... ok 43322 ms
copy2 ... ok 17043 ms
temp ... ok 17214 ms
domain ... ok 25624 ms
rangefuncs ... ok 22915 ms
prepare ... ok 3773 ms
conversion ... ok 13660 ms
truncate ... ok 32065 ms
alter_table ... ok 79591 ms
sequence ... ok 20142 ms
polymorphism ... ok 12176 ms
rowtypes ... ok 19763 ms
returning ... ok 7301 ms
largeobject ... ok 16817 ms
with ... ok 22694 ms
xml ... ok 86171 ms
parallel group (12 tests): hash_part explain reloptions partition_info
memoize compression stats partition_aggregate partition_prune indexing
partition_join tuplesort
partition_join ... ok 69849 ms
partition_prune ... ok 59625 ms
reloptions ... ok 5595 ms
hash_part ... ok 4612 ms
indexing ... ok 68049 ms
partition_aggregate ... ok 50064 ms
partition_info ... ok 13873 ms
tuplesort ... ok 89107 ms
explain ... ok 4582 ms
compression ... ok 17849 ms
memoize ... ok 16381 ms
stats ... ok 36658 ms
parallel group (2 tests): event_trigger oidjoins
event_trigger ... ok 5856 ms
oidjoins ... ok 6232 ms
test fast_default ... ok 4731 ms
============== shutting down postmaster ==============
============== removing temporary instance ==============
=======================
All 213 tests passed.
=======================
Time spent in user mode (CPU seconds) : 235.902s
Time spent in kernel mode (CPU seconds) : 134.766s
Total time : 17:43.89s
CPU utilisation (percentage) : 34.8%
Compilation finished at Thu Jan 9 15:40:27
}}}
{{{
/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql15/postgresql15/work/postgresql-15.10/src/test/regress/log:
insgesamt 2252
drwxr-xr-x 2 pete admin 136 9. Jan 11:22 .
drwxr-xr-x 7 pete admin 850 9. Jan 15:40 ..
-rw-r--r-- 1 pete admin 1706 9. Jan 15:25 initdb.log
-rw-r--r-- 1 pete admin 2301223 9. Jan 15:40 postmaster.log
}}}
{{{
2025-01-09 15:25:12.021 CET postmaster[80872] LOG: starting PostgreSQL
15.10 on powerpc-apple-darwin9.8.0, compiled by powerpc-apple-
darwin9-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5577), 32-bit
2025-01-09 15:25:12.101 CET postmaster[80872] LOG: listening on Unix
socket "/var/folders/PR/PR9ZvjydEAmPxO7U5PFnBk+++TI/-Tmp-/pg_regress-
WShxOR/.s.PGSQL.51706"
}}}
It's reproducible, that MacPorts cannot test because it redirects the
creation of sockets (and lock files) into its disaster area of insanely
long path names, isn't it?
--
Ticket URL: <https://trac.macports.org/ticket/71796#comment:2>
MacPorts <https://www.macports.org/>
Ports system for macOS
More information about the macports-tickets
mailing list