[MacPorts] #71795: postgresql14 @14.15_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_postgresql14/postgresql14/work/.tmp/pg_regress-zxxtWE/.s.PGSQL.58095" is too long (maximum 103 bytes)

MacPorts noreply at macports.org
Thu Jan 9 13:29:38 UTC 2025


#71795: postgresql14 @14.15_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_postgresql14/postgresql14/work/.tmp
/pg_regress-zxxtWE/.s.PGSQL.58095" 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:  postgresql14  |
---------------------------+-------------------------

Comment (by ballapete):

 As with #71794 a "private" test/check succeeds:

 {{{
 -*- mode: compilation; default-directory:
 "/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14/postgresql14/work/postgresql-14.15/"
 -*-
 Compilation started at Thu Jan  9 13:47:48

 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_postgresql14/postgresql14/work/postgresql-14.15'/tmp_install
 /opt/local/bin/gmkdir -p
 '/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14/postgresql14/work/postgresql-14.15'/tmp_install/log
 gnumake -C '.'
 DESTDIR='/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14/postgresql14/work/postgresql-14.15'/tmp_install
 install
 >'/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14/postgresql14/work/postgresql-14.15'/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_postgresql14/postgresql14/work/postgresql-14.15'/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'.
 PATH="/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14/postgresql14/work/postgresql-14.15/tmp_install/opt/local/lib/postgresql14/bin:/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14/postgresql14/work/postgresql-14.15/src/test/regress:$PATH"
 DYLD_LIBRARY_PATH="/opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14/postgresql14/work/postgresql-14.15/tmp_install/opt/local/lib/postgresql14"
 ../../../src/test/regress/pg_regress --temp-instance=./tmp_check
 --inputdir=. --bindir=     --dlpath=. --max-concurrent-tests=20 --make-
 testtablespace-dir  --schedule=./parallel_schedule
 ============== removing existing temp instance        ==============
 ============== creating temporary instance            ==============
 ============== initializing database system           ==============
 ============== starting postmaster                    ==============
 running on port 58095 with PID 65302
 ============== creating database "regression"         ==============
 CREATE DATABASE
 ALTER DATABASE
 ============== running regression test queries        ==============
 test tablespace                   ... ok        15518 ms
 parallel group (20 tests):  int2 txid float4 int8 name int4 regproc char
 varchar text oid pg_lsn money float8 boolean uuid bit enum numeric
 rangetypes
      boolean                      ... ok         5327 ms
      char                         ... ok         3641 ms
      name                         ... ok         3308 ms
      varchar                      ... ok         3529 ms
      text                         ... ok         3738 ms
      int2                         ... ok         2207 ms
      int4                         ... ok         3354 ms
      int8                         ... ok         2967 ms
      oid                          ... ok         3771 ms
      float4                       ... ok         2806 ms
      float8                       ... ok         4634 ms
      bit                          ... ok         6273 ms
      numeric                      ... ok        11519 ms
      txid                         ... ok         2072 ms
      uuid                         ... ok         5694 ms
      enum                         ... ok         6103 ms
      money                        ... ok         4009 ms
      rangetypes                   ... ok        17205 ms
      pg_lsn                       ... ok         3511 ms
      regproc                      ... ok         2501 ms
 parallel group (20 tests):  lseg line path circle point time date timetz
 create_function_0 macaddr macaddr8 timestamp inet interval numerology
 timestamptz strings box multirangetypes polygon
      strings                      ... ok        10983 ms
      numerology                   ... ok         6400 ms
      point                        ... ok         3739 ms
      lseg                         ... ok         1512 ms
      line                         ... ok         2438 ms
      box                          ... ok        16840 ms
      path                         ... ok         2786 ms
      polygon                      ... ok        17131 ms
      circle                       ... ok         2930 ms
      date                         ... ok         3474 ms
      time                         ... ok         3413 ms
      timetz                       ... ok         3489 ms
      timestamp                    ... ok         5192 ms
      timestamptz                  ... ok         7920 ms
      interval                     ... ok         5394 ms
      inet                         ... ok         5255 ms
      macaddr                      ... ok         4775 ms
      macaddr8                     ... ok         4995 ms
      multirangetypes              ... ok        16038 ms
      create_function_0            ... ok         3296 ms
 parallel group (13 tests):  comments unicode tstypes horology xid geometry
 expressions misc_sanity mvcc type_sanity database opr_sanity regex
      geometry                     ... ok         5582 ms
      horology                     ... ok         4654 ms
      tstypes                      ... ok         3268 ms
      regex                        ... ok        25040 ms
      type_sanity                  ... ok         8885 ms
      opr_sanity                   ... ok        17710 ms
      misc_sanity                  ... ok         6231 ms
      comments                     ... ok         1908 ms
      expressions                  ... ok         6007 ms
      unicode                      ... ok         2319 ms
      xid                          ... ok         4840 ms
      mvcc                         ... ok         7940 ms
      database                     ... ok        12291 ms
 test create_function_1            ... ok          338 ms
 test create_type                  ... ok         1606 ms
 test create_table                 ... ok        28305 ms
 test create_function_2            ... ok          703 ms
 parallel group (5 tests):  copydml copyselect insert_conflict insert copy
      copy                         ... ok        29951 ms
      copyselect                   ... ok         2367 ms
      copydml                      ... ok         1861 ms
      insert                       ... ok        27897 ms
      insert_conflict              ... ok        12324 ms
 parallel group (4 tests):  create_operator create_schema create_procedure
 create_misc
      create_misc                  ... ok         3763 ms
      create_operator              ... ok          695 ms
      create_procedure             ... ok         2501 ms
      create_schema                ... ok         1904 ms
 parallel group (5 tests):  index_including index_including_gist
 create_view create_index_spgist create_index
      create_index                 ... ok        46113 ms
      create_index_spgist          ... ok        28371 ms
      create_view                  ... ok        20781 ms
      index_including              ... ok        10373 ms
      index_including_gist         ... ok        15765 ms
 parallel group (16 tests):  create_cast errors roleattributes hash_func
 create_aggregate select drop_if_exists create_am create_function_3
 typed_table constraints vacuum updatable_views infinite_recurse inherit
 triggers
      create_aggregate             ... ok         5837 ms
      create_function_3            ... ok        12992 ms
      create_cast                  ... ok         3062 ms
      constraints                  ... ok        23082 ms
      triggers                     ... ok        70981 ms
      select                       ... ok         6542 ms
      inherit                      ... ok        53150 ms
      typed_table                  ... ok        13276 ms
      vacuum                       ... ok        33953 ms
      drop_if_exists               ... ok         6570 ms
      updatable_views              ... ok        48908 ms
      roleattributes               ... ok         3415 ms
      create_am                    ... ok        11707 ms
      hash_func                    ... ok         5095 ms
      errors                       ... ok         2706 ms
      infinite_recurse             ... ok        49581 ms
 test sanity_check                 ... ok         8638 ms
 parallel group (20 tests):  select_distinct_on random select_having case
 select_implicit delete namespace prepared_xacts portals select_into
 transactions union arrays subselect select_distinct hash_index aggregates
 join update btree_index
      select_into                  ... ok        12984 ms
      select_distinct              ... ok        22594 ms
      select_distinct_on           ... ok         3341 ms
      select_implicit              ... ok         6755 ms
      select_having                ... ok         4319 ms
      subselect                    ... ok        22230 ms
      union                        ... ok        19759 ms
      case                         ... ok         6534 ms
      join                         ... ok        40329 ms
      aggregates                   ... ok        39586 ms
      transactions                 ... ok        12882 ms
      random                       ... ok         3795 ms
      portals                      ... ok        12576 ms
      arrays                       ... ok        21387 ms
      btree_index                  ... ok        56655 ms
      hash_index                   ... ok        29163 ms
      update                       ... ok        40429 ms
      delete                       ... ok         6132 ms
      namespace                    ... ok         7765 ms
      prepared_xacts               ... ok         9906 ms
 parallel group (20 tests):  init_privs drop_operator security_label lock
 tablesample object_address collate replica_identity password identity
 groupingsets matview generated spgist rowsecurity gin gist brin join_hash
 privileges
      brin                         ... ok        82409 ms
      gin                          ... ok        57970 ms
      gist                         ... ok        63314 ms
      spgist                       ... ok        50943 ms
      privileges                   ... ok        93235 ms
      init_privs                   ... ok         1236 ms
      security_label               ... ok         4391 ms
      collate                      ... ok        17911 ms
      matview                      ... ok        44731 ms
      lock                         ... ok         7247 ms
      replica_identity             ... ok        20038 ms
      rowsecurity                  ... ok        52063 ms
      object_address               ... ok        12433 ms
      tablesample                  ... ok         8968 ms
      groupingsets                 ... ok        32007 ms
      drop_operator                ... ok         2777 ms
      password                     ... ok        21962 ms
      identity                     ... ok        31592 ms
      generated                    ... ok        46332 ms
      join_hash                    ... ok        82356 ms
 parallel group (2 tests):  brin_bloom brin_multi
      brin_bloom                   ... ok         4456 ms
      brin_multi                   ... ok        10689 ms
 parallel group (14 tests):  async dbsize tidrangescan alter_operator tsrf
 tid tidscan alter_generic misc_functions sysviews incremental_sort misc
 create_table_like collate.icu.utf8
      create_table_like            ... ok        30704 ms
      alter_generic                ... ok         6517 ms
      alter_operator               ... ok         3642 ms
      misc                         ... ok        11364 ms
      async                        ... ok         1366 ms
      dbsize                       ... ok         1464 ms
      misc_functions               ... ok         7451 ms
      sysviews                     ... ok         7882 ms
      tsrf                         ... ok         4122 ms
      tid                          ... ok         4585 ms
      tidscan                      ... ok         4597 ms
      tidrangescan                 ... ok         3097 ms
      collate.icu.utf8             ... ok        32886 ms
      incremental_sort             ... ok        10273 ms
 parallel group (6 tests):  collate.linux.utf8 amutils psql_crosstab psql
 rules stats_ext
      rules                        ... ok        38332 ms
      psql                         ... ok        31975 ms
      psql_crosstab                ... ok         4101 ms
      amutils                      ... ok         2785 ms
      stats_ext                    ... ok       139702 ms
      collate.linux.utf8           ... ok         2088 ms
 test select_parallel              ... ok        34182 ms
 test write_parallel               ... ok         3278 ms
 test vacuum_parallel              ... ok         4464 ms
 parallel group (2 tests):  subscription publication
      publication                  ... ok         4573 ms
      subscription                 ... ok         1040 ms
 parallel group (17 tests):  portals_p2 advisory_lock combocid tsdicts guc
 xmlmap equivclass functional_deps dependency select_views window tsearch
 bitmapops cluster indirect_toast foreign_data foreign_key
      select_views                 ... ok        15450 ms
      portals_p2                   ... ok         3189 ms
      foreign_key                  ... ok        82307 ms
      cluster                      ... ok        29020 ms
      dependency                   ... ok        12424 ms
      guc                          ... ok         6317 ms
      bitmapops                    ... ok        28810 ms
      combocid                     ... ok         5359 ms
      tsearch                      ... ok        20388 ms
      tsdicts                      ... ok         5969 ms
      foreign_data                 ... ok        34809 ms
      window                       ... ok        19889 ms
      xmlmap                       ... ok         6263 ms
      functional_deps              ... ok        10293 ms
      advisory_lock                ... ok         3994 ms
      indirect_toast               ... ok        29632 ms
      equivclass                   ... ok         8854 ms
 parallel group (6 tests):  json_encoding jsonpath_encoding jsonpath
 jsonb_jsonpath json jsonb
      json                         ... ok         7766 ms
      jsonb                        ... ok        14975 ms
      json_encoding                ... ok          981 ms
      jsonpath                     ... ok         1423 ms
      jsonpath_encoding            ... ok         1046 ms
      jsonb_jsonpath               ... ok         3462 ms
 parallel group (18 tests):  prepare returning limit conversion plancache
 polymorphism largeobject copy2 temp sequence rowtypes with rangefuncs
 domain truncate plpgsql alter_table xml
      plancache                    ... ok        15859 ms
      limit                        ... ok        10365 ms
      plpgsql                      ... ok        62003 ms
      copy2                        ... ok        20576 ms
      temp                         ... ok        24034 ms
      domain                       ... ok        33999 ms
      rangefuncs                   ... ok        30506 ms
      prepare                      ... ok         4926 ms
      conversion                   ... ok        12428 ms
      truncate                     ... ok        37108 ms
      alter_table                  ... ok       146860 ms
      sequence                     ... ok        24442 ms
      polymorphism                 ... ok        16527 ms
      rowtypes                     ... ok        25122 ms
      returning                    ... ok         8946 ms
      largeobject                  ... ok        18742 ms
      with                         ... ok        27530 ms
      xml                          ... ok       202553 ms
 parallel group (11 tests):  explain hash_part reloptions partition_info
 memoize compression partition_aggregate partition_prune indexing
 partition_join tuplesort
      partition_join               ... ok        90153 ms
      partition_prune              ... ok        75647 ms
      reloptions                   ... ok         6650 ms
      hash_part                    ... ok         5504 ms
      indexing                     ... ok        85843 ms
      partition_aggregate          ... ok        60766 ms
      partition_info               ... ok         8363 ms
      tuplesort                    ... ok       116400 ms
      explain                      ... ok         4226 ms
      compression                  ... ok        14269 ms
      memoize                      ... ok        11606 ms
 parallel group (2 tests):  event_trigger oidjoins
      event_trigger                ... ok         9641 ms
      oidjoins                     ... ok        10764 ms
 test fast_default                 ... ok         9852 ms
 test stats                        ... ok         6024 ms
 ============== shutting down postmaster               ==============
 ============== removing temporary instance            ==============

 =======================
  All 212 tests passed.
 =======================


         Time spent in user mode   (CPU seconds) : 235.350s
         Time spent in kernel mode (CPU seconds) : 139.905s
         Total time                              : 20:53.04s
         CPU utilisation (percentage)            : 29.9%

 Compilation finished at Thu Jan  9 14:08:43
 }}}

 because `MacPorts` could not redirect the folder for temporary objects
 into its disaster area with insanely long path names. `gnumake -k check`
 was started from the remains of the `failing MacPorts test`, only
 ownership was changed from "macports" to me:

 {{{
 /opt/local/var/macports/build/nue.de.rsync.macports.org_macports_release_tarballs_ports_databases_postgresql14/postgresql14/work/postgresql-14.15/src/test/regress/log:
   insgesamt 1116
   drwxr-xr-x  2 pete admin     136  9. Jan 10:09 .
   drwxr-xr-x 11 pete admin    1088  9. Jan 13:48 ..
   -rw-r--r--  1 pete admin    1639  9. Jan 13:49 initdb.log
   -rw-r--r--  1 pete admin 1135886  9. Jan 13:56 postmaster.log
 }}}

-- 
Ticket URL: <https://trac.macports.org/ticket/71795#comment:4>
MacPorts <https://www.macports.org/>
Ports system for macOS


More information about the macports-tickets mailing list