[YSQL] ERROR: Timed out waiting kResponseSent, state: kRequestSent

[jasonyb]

Jira Link: DB-11347

Description

Looking at internal detective, Java test org.yb.pgsql.TestPgRegressColocatedTablesWithTablespaces#testPgRegressColocatedTablesWithTablespaces used to fail 90% on alma8-gcc-fastdebug, alma8-clang17-release, alma8-clang17-release-aarch64 (mac12-clang-release-x86_64 and alma8-clang17-asan were fine) until somewhere between 015ba47..7de8ff7 (likely 1bbe619). From that point, it has been passing except one failure on test yb_colocated_tables_with_tablespaces in alma8-gcc-fastdebug (internal link):

SET SESSION ROLE user1;                                                         SET SESSION ROLE user1;
DROP TABLE s1.t1;                                                               DROP TABLE s1.t1;
-- Implicit tablegroup must be deleted since it has no tables                 | ERROR:  Timed out waiting kResponseSent, state: kRequestSent
SELECT COUNT(*) FROM pg_yb_tablegroup;                                        | ERROR:  Shutdown connection
 count                                                                        | PANIC:  ERRORDATA_STACK_SIZE exceeded
-------                                                                       | server closed the connection unexpectedly
     1                                                                        |         This probably means the server terminated abnormally
(1 row)                                                                       |         before or while processing the request.
                                                                              | connection to server was lost

Might be related to issue #21064.

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.