Testing Test::PostgreSQL 1.29 on macOS Sonoma 14.8.5 (darwin 23.6.0) in MacPorts package manager with Perl 5.38.5 fails with "failed to chown dir"

[ballapete]

Hello!

MacPorts or its command line utility port is launched with elevated privileges, either with sudo or by the root super-user. It then creates kind of a sandbox in which an under-privileged user, macports without login shell, executes build or test. The working directory is below /opt/local/var/macports/build, here in /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29. A sandbox effect mostly bends /tmp to /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp.

The failures are:

--->  Testing p5.38-test-postgresql
Executing:  cd "/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29" && /opt/local/bin/perl5.38 Build test 
t/00-base.t .............. ok
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/01-raii.t .............. skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.IJFCI:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/02-multi.t ............. skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.f1q8o:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/04-multiprocess.t ...... skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.UJ6xy:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/05-recycle-base-dir.t .. skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/X93zHHilpJ:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/06-unix-socket.t ....... skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.43Nhx:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/07-configs.t ........... skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.iEXS5:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/08-postgresql_conf.t ... skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.fJ2kQ:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/09-run_psql.t .......... skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.lKEen:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/10-seed_scripts.t ...... skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.FTFT6:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/deadlock.t ............. skipped: failed to chown dir:/opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/.tmp/pgtest.nlcTk:Operation not permitted at /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
All tests successful.
Files=11, Tests=1,  3 wallclock secs ( 0.04 usr  0.03 sys +  2.35 cusr  0.44 csys =  2.86 CPU)
Result: PASS

[ballapete]

The permissions look like these:

  /opt/local/var/macports/build/p5.38-test-postgresql-4391f175/work:
  insgesamt 4
  drwxr-xr-x  7 macports wheel 224 27. Apr 12:13 .
  drwxr-xr-x  3 macports wheel  96 27. Apr 12:12 ..
  drwxr-xr-x  2 macports wheel  64 27. Apr 12:12 .home
  -rw-r--r--  1 macports wheel 313 27. Apr 12:13 .macports.p5.38-test-postgresql.state
  drwxr-xr-x  2 macports wheel  64 27. Apr 12:13 .tmp
  drwxr-xr-x 18 macports wheel 576 27. Apr 12:13 Test-PostgreSQL-1.29
  drwxr-xr-x  3 root     wheel  96 27. Apr 12:13 destroot

.tmp is completely empty.

[ballapete]

Setting TMPDIR='/tmp' still produces failures:

--->  Testing p5.34-test-postgresql
DEBUG: Executing org.macports.test (p5.34-test-postgresql)
DEBUG: elevating privileges for test: euid changed to 0, egid changed to 0.
DEBUG: dropping privileges: euid changed to 501, egid changed to 20.
DEBUG: Environment: 
CC_PRINT_OPTIONS='YES'
CC_PRINT_OPTIONS_FILE='/opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/.CC_PRINT_OPTIONS'
CPATH='/opt/local/include'
DEVELOPER_DIR='/Library/Developer/CommandLineTools'
LIBRARY_PATH='/opt/local/lib'
MACOSX_DEPLOYMENT_TARGET='14.0'
POSTGRES_HOME='/opt/local/var/db/postgresql16/defaultdb'
SDKROOT='/Library/Developer/CommandLineTools/SDKs/MacOSX14.sdk'
SOURCE_DATE_EPOCH='1777286457'
TMPDIR='/tmp'
Executing:  cd "/opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29" && /opt/local/bin/perl5.34 Build test 
DEBUG: system:  cd "/opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29" && /opt/local/bin/perl5.34 Build test 
t/00-base.t .............. ok
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/01-raii.t .............. skipped: failed to chown dir:/tmp/pgtest.H1sbU:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/02-multi.t ............. skipped: failed to chown dir:/tmp/pgtest.bPyEu:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/04-multiprocess.t ...... skipped: failed to chown dir:/tmp/pgtest.mbTuF:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/05-recycle-base-dir.t .. skipped: failed to chown dir:/tmp/rGYHSxTMoY:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/06-unix-socket.t ....... skipped: failed to chown dir:/tmp/pgtest.2_emR:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/07-configs.t ........... skipped: failed to chown dir:/tmp/pgtest.j1E8N:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/08-postgresql_conf.t ... skipped: failed to chown dir:/tmp/pgtest.jmW7X:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/09-run_psql.t .......... skipped: failed to chown dir:/tmp/pgtest.r8_jD:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/10-seed_scripts.t ...... skipped: failed to chown dir:/tmp/pgtest.gKKEe:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
Use of uninitialized value in chown at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
t/deadlock.t ............. skipped: failed to chown dir:/tmp/pgtest.s6iR9:Operation not permitted at /opt/local/var/macports/build/p5.34-test-postgresql-4391f175/work/Test-PostgreSQL-1.29/blib/lib/Test/PostgreSQL.pm line 622.
All tests successful.
Files=11, Tests=1,  3 wallclock secs ( 0.04 usr  0.03 sys +  2.37 cusr  0.45 csys =  2.89 CPU)
Result: PASS

/tmp has:

  /tmp:
  insgesamt 1448
  drwxrwxrwt 17 root          wheel     544 27. Apr 12:46 .
  srwxrwxrwx  1 postgres      wheel       0 27. Apr 11:52 .s.PGSQL.5432
  -rw-------  1 postgres      wheel      68 27. Apr 11:52 .s.PGSQL.5432.lock

(The socket is that of a running PostgreSQL 16 db, empty, could be used for tests, DBD::Pg simply uses it.)

[ballapete]

Possibly the cause is that Test::PostgreSQL tries to chown directories while it's not testing with elevated privileges. It anyway should not play a role when Test::PostgreSQL creates its own PostgreSQL db: the db user and the data files must not change, they can be owned by macports.

[TJC]

Thanks for raising the issue. I don't have an appropriate environment to test out or attempt to fix this, but hopefully someone else can come along and submit a fix.

[ballapete]

Is there a block of code concerning that chown issue that can be commented? In order to check whether the tests run at all inside the MacPorts package manager? (It is also used on BSD variants.)