[YSQL][LST] ERROR: Not implemented: Not supported to restart DDL transaction

[def-]

Jira Link: DB-2915

Description

$ cd ~/code/yugabyte-db
$ git checkout 226465305d
$ ./yb_build.sh release
$ bin/yb-ctl --replication_factor 3 create --tserver_flags=yb_enable_read_committed_isolation=true,ysql_num_shards_per_tserver=1,enable_stream_compression=true,stream_compression_algo=1,yb_num_shards_per_tserver=1 --master_flags=yb_enable_read_committed_isolation=true,enable_stream_compression=true,stream_compression_algo=1,enable_automatic_tablet_splitting=true,tablet_split_low_phase_shard_count_per_node=40,tablet_split_high_phase_shard_count_per_node=50
$ cd ~/code/yb-long-system-test
$ git checkout 1113bd28
$ python3.9 ./long_system_test.py --nodes=127.0.0.1:5433,127.0.0.2:5433,127.0.0.3:5433 --threads=20 --runtime=60 --max-columns=20 --complexity=full --seed=358184
2022-07-12 15:36:12,545 MainThread INFO     Reproduce with: git checkout 1113bd28 && ./long_system_test.py --nodes=127.0.0.1:5433,127.0.0.2:5433,127.0.0.3:5433 --threads=20 --runtime=60 --max-columns=20 --complexity=full --seed=358184
2022-07-12 15:36:12,998 MainThread INFO     Database version: PostgreSQL 11.2-YB-2.15.1.0-b0 on x86_64-pc-linux-gnu, compiled by clang version 13.0.1 (https://github.com/yugabyte/llvm-project.git 191e3a05a55c8671bcc88d7387c04c55a4310500), 64-bit
2022-07-12 15:36:13,001 MainThread INFO     Creating tables for database db_lst_358184
2022-07-12 15:36:34,511 MainThread INFO     Starting worker_0: SingleInsertAction, SingleUpdateAction, SingleDeleteAction, BulkInsertAction, BulkUpdateAction, SetConfigAction
2022-07-12 15:36:34,512 MainThread INFO     Starting worker_1: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,515 MainThread INFO     Starting worker_2: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,517 MainThread INFO     Starting worker_3: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,518 MainThread INFO     Starting worker_4: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,519 MainThread INFO     Starting worker_5: CreateIndexAction, DropIndexAction, SetConfigAction, AddColumnAction
2022-07-12 15:36:34,520 MainThread INFO     Starting worker_6: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,521 MainThread INFO     Starting worker_7: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,521 MainThread INFO     Starting worker_8: SingleInsertAction, SingleUpdateAction, SingleDeleteAction, BulkInsertAction, BulkUpdateAction, SetConfigAction
2022-07-12 15:36:34,523 MainThread INFO     Starting worker_9: SingleInsertAction, SingleUpdateAction, SingleDeleteAction, BulkInsertAction, BulkUpdateAction, SetConfigAction
2022-07-12 15:36:34,523 MainThread INFO     Starting worker_10: CreateIndexAction, DropIndexAction, SetConfigAction, AddColumnAction
2022-07-12 15:36:34,524 MainThread INFO     Starting worker_11: CreateIndexAction, DropIndexAction, SetConfigAction, AddColumnAction
2022-07-12 15:36:34,525 MainThread INFO     Starting worker_12: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,526 MainThread INFO     Starting worker_13: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,528 MainThread INFO     Starting worker_14: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,529 MainThread INFO     Starting worker_15: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,530 MainThread INFO     Starting worker_16: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,532 MainThread INFO     Starting worker_17: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,533 MainThread INFO     Starting worker_18: RandomSelectAction, SetConfigAction
2022-07-12 15:36:34,534 MainThread INFO     Starting worker_19: CreateIndexAction, DropIndexAction, SetConfigAction, AddColumnAction
2022-07-12 15:36:44,544 MainThread INFO     Worker queries/s: [001.0][000.2][000.9][000.8][000.5][000.1][000.7][000.2][001.6][001.3][000.1][000.2][000.2][000.5][000.8][000.4][000.3][000.8][000.3][000.1]
[...]
2022-07-12 15:52:05,578 MainThread INFO     Worker queries/s: [001.5][000.2][000.6][001.0][000.2][000.0][000.4][000.4][000.7][001.4][000.1][000.0][000.4][000.3][001.4][000.3][001.2][000.9][000.5][000.3]
2022-07-12 15:52:09,450 worker_11  ERROR    Unexpected query failure: InternalError_
Query: CREATE INDEX NONCONCURRENTLY idx_tg1_2_c4_text_c9_date ON tg1_2 USING lsm (c4_text DESC NULLS FIRST, c9_date ASC NULLS LAST) WHERE FALSE;
  values: None
  runtime: 2022-07-12 15:52:06.661 - 2022-07-12 15:52:09.449
  supports explain: False
  supports rollback: False
  affected rows: None
Action: CreateIndexAction
Error class: InternalError_
Error code: XX000
Error message: ERROR:  Not implemented: Not supported to restart DDL transaction
    @           0x9b2908  errmsg
    @           0x9de0f5  HandleYBStatusAtErrorLevel
    @           0x56c477  ybc_getnext_heaptuple
    @           0x56cc2e  ybc_systable_getnext
    @           0x648e1b  GetDefaultOpClass
    @           0x648a82  ResolveOpClass
    @           0x6450e5  ComputeIndexAttrs
    @           0x646e13  DefineIndex
    @           0x857a88  ProcessUtilitySlow
    @           0x856010  standard_ProcessUtility
    @           0x8555fe  YBProcessUtilityDefaultHook
    @     0x7fed33ec5e70  pgss_ProcessUtility
    @     0x7fed33ebcad7  ybpgm_ProcessUtility
    @     0x7fed33ea072e  pg_hint_plan_ProcessUtility
    @           0x9e19f7  YBTxnDdlProcessUtility
    @           0x85524a  PortalRunUtility
    @           0x854937  PortalRunMulti
    @           0x8541f6  PortalRun
    @           0x851976  yb_exec_simple_query_impl
    @           0x851f16  yb_exec_query_wrapper_one_attempt
    @           0x84ea8b  PostgresMain
    @           0x7bab8c  BackendRun
    @           0x7b9fe0  ServerLoop
    @           0x7b659b  PostmasterMain
    @           0x7177ad  PostgresServerProcessMain
    @           0x717c52  main
    @     0x7fed386cc825  __libc_start_main
    @           0x4c6409  _start
Transaction isolation level: committed
DB Node: host: 127.0.0.3, port: 5433
DB Backend PID: 145305

Internal error sounds like it should not happen, no similar bugs yet.
lst_2022-07-12_15:36:12_358184.zip