[YSQL] TableLocks: Investigate missing object lock calls on statement/txn retries in extended query mode execution

[basavaraj29]

Jira Link: DB-13996

Description

Once #24596 lands, enable TEST_enable_object_locking_for_table_locks, and run the following

./yb_build.sh --java-test TestPgTransparentRestarts#update
./yb_build.sh --java-test TestPgTransparentRestarts#testUpdateLong

both the tests fail, but when we change the tests to use withPreferQueryMode("simple"), they pass.

In the former mode, the object lock calls aren't being issued for the retries.

More details.
For transparent statement retries from ysql, we seem to receive the object lock requests for statements being retried only in simple query execution mode. In extended mode, the object lock requests aren't being made on statement retries. This would cause issues since the object locks could be tied to a transaction that would get aborted on statement retry, and the new transaction would proceed to taking row-level locks without acquiring the required object locks.

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.