[DocDB] [DB Clone] Clone is failing with catalog snapshot invalidated, MISMATCHED_SCHEMA

[dhruva4869]

Jira Link: DB-15245

Description

Description:
Version: 2.25.1.0-b280

Steps:

1. Create tables, indexes (unique, partial, covering, expression, secondary), materialized views, FK and partitions.
2. Load data in all of them and create snapshot schedule
3. Validate snapshot schedule and take time t1
4. Do bunch of alters, delete some data and truncate some table
5. Drop some indexes, Create new indexes (on new column)
6. Load some data and take time t2
7. Clone to time t1

Clone doesn't go through with following Error:

[
    {
        "aggregate_state": "ABORTED",
        "source_namespace_id": "00004000000030008000000000000000",
        "seq_no": "1",
        "target_namespace_name": "db4",
        "restore_time": "2025-02-07 10:53:25.031021",
        "abort_message": "Runtime error (yb/util/subprocess.cc:632): Subprocess '/home/yugabyte/yb-software/yugabyte-2.25.1.0-b280-centos-x86_64/bin/../postgres/bin/ysql_dump' terminated with non-zero exit status 256: ysql_dump: error: query failed: ERROR:  The catalog snapshot used for this transaction has been invalidated: expected: 62, got: 37: MISMATCHED_SCHEMA\nysql_dump: detail: Query was: SELECT last_value, is_called FROM public.dummy_table_i2_seq\n"
    }
]

Minimal repro thanks to @yamen-haddad

CREATE DATABASE db4;
\q
./build/latest/bin/yb-admin --master_addresses 127.0.0.1:7100,127.0.0.2:7100,127.0.0.3:7100 create_snapshot_schedule 2 320 ysql.db4
./bin/ysqlsh -d db4

CREATE TABLE dummy_table(id text , i2 serial, name text);

SELECT (EXTRACT (EPOCH FROM CURRENT_TIMESTAMP)*1000000)::decimal(38,0);
-- t1= 1738966318840176

ALTER TABLE dummy_table RENAME COLUMN name TO text_column2;

CREATE DATABASE db5 TEMPLATE db4 AS OF 1738966318840176;

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.