[YSQL] Postgres crash loop on tserver of master leader node leading to workload issues in CDC testcase

[shamanthchandra-yb]

Jira Link: DB-11383

Description

Please refer slack thread and stress run links in JIRA.

It is repro' very consistently about 50% of the times in CDC master cases.

W0521 08:32:14.421474  1411 pg_wrapper.cc:515] No hba configuration lines found, defaulting to trust all configuration.
I0521 08:32:14.421535  1411 pg_wrapper.cc:539] No user name mapping configuration lines found.
I0521 08:32:14.428617  1411 pg_wrapper.cc:732] PostgreSQL server running as pid 525184
W0521 08:32:14.496805  1411 subprocess.cc:141] PostgreSQL server returned with code 256, exited with status 1
I0521 08:32:14.496845  1411 process_wrapper.cc:90] Restarting PostgreSQLprocess
W0521 08:32:14.500006  1411 pg_wrapper.cc:515] No hba configuration lines found, defaulting to trust all configuration.
I0521 08:32:14.500073  1411 pg_wrapper.cc:539] No user name mapping configuration lines found.
I0521 08:32:14.507124  1411 pg_wrapper.cc:732] PostgreSQL server running as pid 525185
W0521 08:32:14.564682  1411 subprocess.cc:141] PostgreSQL server returned with code 256, exited with status 1
I0521 08:32:14.564715  1411 process_wrapper.cc:90] Restarting PostgreSQLprocess
W0521 08:32:14.567799  1411 pg_wrapper.cc:515] No hba configuration lines found, defaulting to trust all configuration.
I0521 08:32:14.567862  1411 pg_wrapper.cc:539] No user name mapping configuration lines found.
I0521 08:32:14.574992  1411 pg_wrapper.cc:732] PostgreSQL server running as pid 525186
W0521 08:32:14.631011  1411 subprocess.cc:141] PostgreSQL server returned with code 256, exited with status 1
I0521 08:32:14.631044  1411 process_wrapper.cc:90] Restarting PostgreSQLprocess
W0521 08:32:14.634006  1411 pg_wrapper.cc:515] No hba configuration lines found, defaulting to trust all configuration.
I0521 08:32:14.634068  1411 pg_wrapper.cc:539] No user name mapping configuration lines found.
I0521 08:32:14.640965  1411 pg_wrapper.cc:732] PostgreSQL server running as pid 525187

Source connector version

fourpointfour/ybdb-debezium:0.9

Connector configuration

add connector connector_name='ybconnector_cdc_8b378a_test_cdc_1b3026' stream_id='rs_cdc_8b378a_7d0a' db_name='cdc_8b378a' connector_host='172.151.17.101' table_list=['test_cdc_1b3026'] {'name': 'ybconnector_cdc_8b378a_test_cdc_1b3026', 'config': {'database.master.addresses': '172.151.19.32:7100,172.151.18.96:7100,172.151.25.227:7100', 'database.hostname': '172.151.19.32:5433,172.151.18.96:5433,172.151.25.227:5433', 'database.port': 5433, 'database.masterhost': '172.151.19.32', 'database.masterport': '7100', 'database.user': 'yugabyte', 'database.password': 'yugabyte', 'database.dbname': 'cdc_8b378a', 'snapshot.mode': 'initial', 'admin.operation.timeout.ms': 600000, 'socket.read.timeout.ms': 300000, 'max.connector.retries': '10', 'operation.timeout.ms': 600000, 'topic.creation.default.compression.type': 'lz4', 'topic.creation.default.cleanup.policy': 'delete', 'topic.creation.default.partitions': 2, 'topic.creation.default.replication.factor': '1', 'tasks.max': '5', 'connector.class': 'io.debezium.connector.postgresql.PostgresConnector', 'topic.prefix': 'ybconnector_cdc_8b378a_test_cdc_1b3026', 'plugin.name': 'pgoutput', 'slot.name': 'rs_cdc_8b378a_7d0a_from_con_0cfd', 'publication.autocreate.mode': 'filtered', 'publication.name': 'pn_ybconnector_cdc_8b378a_test_cdc_1b3026', 'table.include.list': 'public.test_cdc_1b3026'}}

YugabyteDB version

2024.1.1.0-b22

Issue Type

kind/bug

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

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