Several server crashes when running tests in parallel about age HOT 4 OPEN

It seems that the server crashes occur when running tests using a specific Makefile setup and iterating through the tests multiple times. Here's a summary of the issue and the steps leading to the server crashes:

Bug Description:

Several server crashes occur when running tests in a loop with the specified Makefile setup.
Steps to Reproduce:

Modify the Makefile to run tests in a loop multiple times.
Start tests using the modified Makefile.
Iterate through the tests multiple times, possibly hundreds of iterations.
Observe server crashes occurring during the test iterations.
Expected Behavior:

Tests should execute successfully without causing server crashes even when run multiple times in a loop.
Environment:

Apache AGE (PG16 branch) with PostgreSQL (REL_16_STABLE).
Makefile Modification:

REGRESS=--schedule=schedule
Modified Test Execution:

for i in seq 100000; do
echo "ITER $i"
make -s installcheck
if coredumpctl; then
break
fi
done
Actual Outcome:

Server crashes occur during the test iterations, leading to failed tests and potential instability.
Workaround:

Since the issue seems related to running tests repeatedly in a loop, you might consider running the tests individually or in smaller batches to mitigate the likelihood of server crashes until the root cause of the crashes can be identified and resolved. Additionally, analyzing the server logs and core dumps generated during the crashes could provide insights into the underlying cause.

from age.

@saygoodbyye We do not support user modified Makefiles. The Makefile is only for installing AGE and is only intended to test what was just installed.

If you want to run those specific checks in parallel to highlight an issue, please write a separate script to do so.

from age.

@jrgemignani, I was able to reproduce this bug in a different way using pgreplay utility.
To reproduce bug follow steps:

*** configure and install pgreplay ***
*** then replay attached postmaster.log file ***
./pgreplay -j postmaster.log

postmaster.log

from age.

This issue is stale because it has been open 60 days with no activity. Remove "Abondoned" label or comment or this will be closed in 14 days.

from age.