[MacPorts] #71794: postgresql13 @13.18_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_postgresql13/postgresql13/work/.tmp/pg_regress-eAkCXI/.s.PGSQL.64482" is too long (maximum 103 bytes)
MacPorts
noreply at macports.org
Thu Jan 9 12:33:00 UTC 2025
#71794: postgresql13 @13.18_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_postgresql13/postgresql13/work/.tmp
/pg_regress-eAkCXI/.s.PGSQL.64482" 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: postgresql13 |
---------------------------+-------------------------
Comment (by ballapete):
I performed an alternative test (or check) to that one, failing with
MacPorts: Make me owner of the build area (`chown -R pete:admin
/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13/postgresql13`),
save the original `log files in
/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13/postgresql13/work/postgresql-13.18/src/test/regress/log`
and then use my own "private" instance of `GNU Emacs` to perform:
{{{
-*- mode: compilation; default-directory:
"/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13/postgresql13/work/postgresql-13.18/"
-*-
Compilation started at Thu Jan 9 13:07:22
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_postgresql13/postgresql13/work/postgresql-13.18'/tmp_install
/opt/local/bin/gmkdir -p
'/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13/postgresql13/work/postgresql-13.18'/tmp_install/log
gnumake -C '.'
DESTDIR='/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13/postgresql13/work/postgresql-13.18'/tmp_install
install
>'/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13/postgresql13/work/postgresql-13.18'/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_postgresql13/postgresql13/work/postgresql-13.18'/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'.
rm -rf ./testtablespace
mkdir ./testtablespace
PATH="/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13/postgresql13/work/postgresql-13.18/tmp_install/opt/local/lib/postgresql13/bin:$PATH"
DYLD_LIBRARY_PATH="/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql13/postgresql13/work/postgresql-13.18/tmp_install/opt/local/lib/postgresql13"
../../../src/test/regress/pg_regress --temp-instance=./tmp_check
--inputdir=. --bindir= --dlpath=. --max-concurrent-tests=20
--schedule=./parallel_schedule
============== removing existing temp instance ==============
============== creating temporary instance ==============
============== initializing database system ==============
============== starting postmaster ==============
running on port 64482 with PID 59148
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test tablespace ... ok 10418 ms
parallel group (20 tests): int4 regproc name char int2 money varchar oid
pg_lsn boolean text txid int8 float4 float8 uuid bit enum numeric
rangetypes
boolean ... ok 3757 ms
char ... ok 2169 ms
name ... ok 2011 ms
varchar ... ok 3327 ms
text ... ok 3598 ms
int2 ... ok 2088 ms
int4 ... ok 1573 ms
int8 ... ok 3804 ms
oid ... ok 3343 ms
float4 ... ok 4039 ms
float8 ... ok 4170 ms
bit ... ok 5683 ms
numeric ... ok 9372 ms
txid ... ok 3573 ms
uuid ... ok 5140 ms
enum ... ok 5870 ms
money ... ok 2401 ms
rangetypes ... ok 13220 ms
pg_lsn ... ok 3036 ms
regproc ... ok 1273 ms
parallel group (20 tests): circle lseg line time path date timetz tstypes
macaddr8 interval point macaddr numerology timestamp xid inet timestamptz
strings box polygon
strings ... ok 7865 ms
numerology ... ok 4889 ms
point ... ok 4438 ms
lseg ... ok 1661 ms
line ... ok 1773 ms
box ... ok 11884 ms
path ... ok 2621 ms
polygon ... ok 13860 ms
circle ... ok 1345 ms
date ... ok 2689 ms
time ... ok 2081 ms
timetz ... ok 2903 ms
timestamp ... ok 4686 ms
timestamptz ... ok 6131 ms
interval ... ok 3736 ms
inet ... ok 5046 ms
macaddr ... ok 3568 ms
macaddr8 ... ok 3271 ms
tstypes ... ok 2834 ms
xid ... ok 4344 ms
parallel group (11 tests): comments unicode geometry horology expressions
misc_sanity type_sanity oidjoins database opr_sanity regex
geometry ... ok 5330 ms
horology ... ok 5612 ms
regex ... ok 21283 ms
oidjoins ... ok 10437 ms
type_sanity ... ok 8993 ms
opr_sanity ... ok 16800 ms
misc_sanity ... ok 6078 ms
comments ... ok 1968 ms
expressions ... ok 5214 ms
unicode ... ok 1836 ms
database ... ok 11086 ms
test create_function_1 ... ok 721 ms
test create_type ... ok 932 ms
test create_table ... ok 19098 ms
test create_function_2 ... ok 268 ms
parallel group (5 tests): copydml copyselect insert_conflict copy insert
copy ... ok 24165 ms
copyselect ... ok 2127 ms
copydml ... ok 2035 ms
insert ... ok 25483 ms
insert_conflict ... ok 10013 ms
parallel group (4 tests): create_operator create_schema create_procedure
create_misc
create_misc ... ok 3895 ms
create_operator ... ok 1148 ms
create_procedure ... ok 2556 ms
create_schema ... ok 2346 ms
parallel group (5 tests): index_including index_including_gist
create_view create_index_spgist create_index
create_index ... ok 46620 ms
create_index_spgist ... ok 27281 ms
create_view ... ok 17482 ms
index_including ... ok 10464 ms
index_including_gist ... ok 16200 ms
parallel group (16 tests): create_cast errors hash_func roleattributes
create_aggregate drop_if_exists create_function_3 select create_am
typed_table constraints infinite_recurse vacuum updatable_views inherit
triggers
create_aggregate ... ok 5627 ms
create_function_3 ... ok 7014 ms
create_cast ... ok 3048 ms
constraints ... ok 24583 ms
triggers ... ok 64152 ms
select ... ok 7102 ms
inherit ... ok 51478 ms
typed_table ... ok 15933 ms
vacuum ... ok 32757 ms
drop_if_exists ... ok 6479 ms
updatable_views ... ok 48885 ms
roleattributes ... ok 4280 ms
create_am ... ok 14972 ms
hash_func ... ok 3578 ms
errors ... ok 3167 ms
infinite_recurse ... ok 31656 ms
test sanity_check ... ok 5517 ms
parallel group (20 tests): select_distinct_on select_having random
select_implicit delete case prepared_xacts namespace select_into portals
transactions union arrays subselect select_distinct hash_index aggregates
join update btree_index
select_into ... ok 12799 ms
select_distinct ... ok 20613 ms
select_distinct_on ... ok 3134 ms
select_implicit ... ok 5840 ms
select_having ... ok 4125 ms
subselect ... ok 18878 ms
union ... ok 13996 ms
case ... ok 7143 ms
join ... ok 37460 ms
aggregates ... ok 35912 ms
transactions ... ok 13467 ms
random ... ok 4437 ms
portals ... ok 12930 ms
arrays ... ok 17922 ms
btree_index ... ok 53626 ms
hash_index ... ok 26197 ms
update ... ok 41030 ms
delete ... ok 6818 ms
namespace ... ok 7847 ms
prepared_xacts ... ok 7768 ms
parallel group (20 tests): init_privs drop_operator security_label lock
tablesample password object_address collate replica_identity groupingsets
identity matview generated spgist rowsecurity gin gist brin join_hash
privileges
brin ... ok 82624 ms
gin ... ok 60456 ms
gist ... ok 77980 ms
spgist ... ok 54548 ms
privileges ... ok 93567 ms
init_privs ... ok 3187 ms
security_label ... ok 6011 ms
collate ... ok 24420 ms
matview ... ok 45566 ms
lock ... ok 7842 ms
replica_identity ... ok 24746 ms
rowsecurity ... ok 54474 ms
object_address ... ok 12091 ms
tablesample ... ok 9117 ms
groupingsets ... ok 33977 ms
drop_operator ... ok 3984 ms
password ... ok 9643 ms
identity ... ok 36994 ms
generated ... ok 47620 ms
join_hash ... ok 82224 ms
parallel group (13 tests): async dbsize alter_operator tsrf tidscan tid
misc_functions sysviews alter_generic misc incremental_sort
collate.icu.utf8 create_table_like
create_table_like ... ok 21255 ms
alter_generic ... ok 8083 ms
alter_operator ... ok 2595 ms
misc ... ok 9620 ms
async ... ok 1008 ms
dbsize ... ok 1494 ms
misc_functions ... ok 6805 ms
sysviews ... ok 7027 ms
tsrf ... ok 3571 ms
tid ... ok 4319 ms
tidscan ... ok 3780 ms
collate.icu.utf8 ... ok 20229 ms
incremental_sort ... ok 9412 ms
parallel group (6 tests): collate.linux.utf8 amutils psql_crosstab psql
rules stats_ext
rules ... ok 19580 ms
psql ... ok 12676 ms
psql_crosstab ... ok 4344 ms
amutils ... ok 4026 ms
stats_ext ... ok 58110 ms
collate.linux.utf8 ... ok 3233 ms
test select_parallel ... ok 27765 ms
test write_parallel ... ok 1576 ms
parallel group (2 tests): subscription publication
publication ... ok 3408 ms
subscription ... ok 497 ms
parallel group (17 tests): portals_p2 advisory_lock combocid xmlmap guc
tsdicts equivclass functional_deps select_views dependency window tsearch
indirect_toast bitmapops cluster foreign_data foreign_key
select_views ... ok 19177 ms
portals_p2 ... ok 3029 ms
foreign_key ... ok 72530 ms
cluster ... ok 40601 ms
dependency ... ok 20667 ms
guc ... ok 15589 ms
bitmapops ... ok 38437 ms
combocid ... ok 6600 ms
tsearch ... ok 28151 ms
tsdicts ... ok 16318 ms
foreign_data ... ok 44678 ms
window ... ok 22275 ms
xmlmap ... ok 14522 ms
functional_deps ... ok 18499 ms
advisory_lock ... ok 5925 ms
indirect_toast ... ok 36636 ms
equivclass ... ok 16455 ms
parallel group (6 tests): jsonpath_encoding json_encoding jsonpath
jsonb_jsonpath json jsonb
json ... ok 3989 ms
jsonb ... ok 7817 ms
json_encoding ... ok 874 ms
jsonpath ... ok 1271 ms
jsonpath_encoding ... ok 778 ms
jsonb_jsonpath ... ok 1995 ms
parallel group (18 tests): conversion prepare returning limit plancache
polymorphism largeobject copy2 with temp sequence rowtypes rangefuncs
domain truncate plpgsql alter_table xml
plancache ... ok 12232 ms
limit ... ok 9454 ms
plpgsql ... ok 44444 ms
copy2 ... ok 17841 ms
temp ... ok 20400 ms
domain ... ok 28782 ms
rangefuncs ... ok 25824 ms
prepare ... ok 5125 ms
conversion ... ok 3210 ms
truncate ... ok 30726 ms
alter_table ... ok 91249 ms
sequence ... ok 21804 ms
polymorphism ... ok 14232 ms
rowtypes ... ok 23080 ms
returning ... ok 7861 ms
largeobject ... ok 16965 ms
with ... ok 17944 ms
xml ... ok 99166 ms
parallel group (9 tests): explain hash_part reloptions partition_info
partition_aggregate partition_prune indexing partition_join tuplesort
partition_join ... ok 70136 ms
partition_prune ... ok 56233 ms
reloptions ... ok 4973 ms
hash_part ... ok 4275 ms
indexing ... ok 67384 ms
partition_aggregate ... ok 41967 ms
partition_info ... ok 5299 ms
tuplesort ... ok 77876 ms
explain ... ok 3561 ms
test event_trigger ... ok 13502 ms
test fast_default ... ok 6595 ms
test stats ... ok 2199 ms
============== shutting down postmaster ==============
============== removing temporary instance ==============
=======================
All 203 tests passed.
=======================
Time spent in user mode (CPU seconds) : 217.488s
Time spent in kernel mode (CPU seconds) : 129.384s
Total time : 14:46.14s
CPU utilisation (percentage) : 39.1%
Compilation finished at Thu Jan 9 13:22:12
}}}
This is quite close to MacPorts' performance – but a successful one!
I am going to attach "my" `log files` from the successful test…
--
Ticket URL: <https://trac.macports.org/ticket/71794#comment:3>
MacPorts <https://www.macports.org/>
Ports system for macOS
More information about the macports-tickets
mailing list