[YSQL] flaky test: org.yb.pgsql.TestPgRegressPgMisc.testPgRegressPgMisc

[bmatican]

Jira Link: DB-5620

Description

https://detective-gcp.dev.yugabyte.com/stability/test?analyze_trends=true&branch=master&build_type=all&class=org.yb.pgsql.TestPgRegressPgMisc&fail_tag=all&name=testPgRegressPgMisc&platform=linux

seems to point to d050f04

[bmatican]

@jason-yb seems this test is still failing consistently in ASAN. Is that some timing issue, or some legitimate memory issue?

[jasonyb]

@bmatican, it's an ASAN issue stack depth limit exceeded related to #15682.

[m-iancu]

I don't see this failing regularly in ASAN anymore so closing.
No failures in last 12 iterations (96 runs across 8 builds):
https://detective-gcp.dev.yugabyte.com/stability/test?analyze_trends=true&class=org.yb.pgsql.TestPgRegressPgMisc&name=testPgRegressPgMisc

[OlegLoginov]

Reopening due to the reproducible test failure:
ybd asan --java-test org.yb.pgsql.TestPgRegressPgMisc#testPgRegressPgMisc
the error is:

-- Check that stack depth detection mechanism works and                         -- Check that stack depth detection mechanism works and
-- max_stack_depth is not set too high                                          -- max_stack_depth is not set too high
create function infinite_recurse() returns int as                               create function infinite_recurse() returns int as
'select infinite_recurse()' language sql;                                       'select infinite_recurse()' language sql;
\set VERBOSITY terse                                                            \set VERBOSITY terse
select infinite_recurse();                                                      select infinite_recurse();
ERROR:  stack depth limit exceeded                                            | server closed the connection unexpectedly
                                                                              >         This probably means the server terminated abnormally
                                                                              >         before or while processing the request.
                                                                              > connection to server was lost

It should be investigated & fixed in another GHI.

[d-uspenskiy]

ASAN failure is fixed in context of c2e13ef