Hi Tom,
> Also we ran it on master and all the tests are passing
>> douc:HEAD [15:30:25] running make PL installcheck (C)...
>> douc:HEAD [15:30:29] restarting db (C)...
>> douc:HEAD [15:30:32] running make contrib installcheck (C)...
>> douc:HEAD [15:31:20] restarting db (C)...
>> douc:HEAD [15:31:22] running make test-modules installcheck (C)...
>> douc:HEAD [15:31:59] stopping db (C)...
>> douc:HEAD [15:32:08] running make ecpg check ...
>> douc:HEAD [15:32:29] OK
>> Branch: HEAD
>> All stages succeeded
>Good, but I don't see a report on the buildfarm server?
This was run locally on the node.
Today I ran the test locally first and all tests passed. Logs at below location
on p9-aix1-postgres1
pgsql@p9-aix1-postgres1::bfarm19
## pwd
/tmp/bfarm19
pgsql@p9-aix1-postgres1::bfarm19
## ls
bfarm19.send.26020449.log
douc.lastrun-logs/ <<<<< All logs
pgsql@p9-aix1-postgres1::bfarm19
## tail bfarm19.send.26020449.log
douc:HEAD [06:03:54] running make PL installcheck (C)...
douc:HEAD [06:03:58] restarting db (C)...
douc:HEAD [06:04:00] running make contrib installcheck (C)...
douc:HEAD [06:04:44] restarting db (C)...
douc:HEAD [06:04:47] running make test-modules installcheck
(C)...
douc:HEAD [06:05:24] stopping db (C)...
douc:HEAD [06:05:25] running make ecpg check ...
douc:HEAD [06:05:45] OK
Branch: HEAD
All stages succeeded
In the next run I tried to push the logs to server, but the last test case
failed.
douc:HEAD [08:13:29] restarting db (C)...
douc:HEAD [08:13:32] running make test-modules installcheck
(C)...
douc:HEAD [08:14:31] failed at stage TestModulesCheck-C
The logs are pushed to the server
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=douc&dt=2026-02-26%2006%3A58%3A38
I see below errors in the log file
# +++ tap install-check in src/test/modules/worker_spi +++
not ok 1 - test_shm_mq 483 ms
1..1
# 1 of 1 tests failed.
# The differences that caused some tests to fail can be viewed in the
file
"/home/pgsql/buildFarm/bfarm-19.1/buildroot/HEAD/pgsql.build/src/test/modules/test_shm_mq/regression.diffs".
# A copy of the test summary that you see above is saved in the file
"/home/pgsql/buildFarm/bfarm-19.1/buildroot/HEAD/pgsql.build/src/test/modules/test_shm_mq/regression.out".
gmake[1]: *** [../../../../src/makefiles/pgxs.mk:433: installcheck]
Error 1
gmake[1]: Leaving directory
'/home/pgsql/buildFarm/bfarm-19.1/buildroot/HEAD/pgsql.build/src/test/modules/test_shm_mq'
gmake: *** [Makefile:84: installcheck-test_shm_mq-recurse] Error 2
Below is the error in the diff file
+ERROR: could not register background process
+HINT: You may need to increase "max_worker_processes".
After setting the ‘max_worker_processes=16”, in the
"./inst/data-C/postgresql.conf” and ran
## gmake check installcheck-C
All the tests passed. Below is the log
/tmp/bfarm19/installcheck-C.log
The above test_shm_mq pased here
# +++ regress check in src/test/modules/test_shm_mq +++
# initializing database system by copying initdb template
# using temp instance on port 58928 with PID 41156962
ok 1 - test_shm_mq 6307 ms
1..1
# All 1 tests passed.
Warm regards,
Sriram.
