Skip to content

2.25.2.0-b162

@pao214 pao214 tagged this 14 Mar 06:06
Summary:
The test PgAnalyzeReadTimeTest.AnalyzeMultipleTables relies on compaction finishing in 10s. However, compaction takes around 15s on dev server in TSAN mode.

```
2025-03-13 21:18:54.179 UTC [3641101] LOG:  statement: UPDATE values SET v = v + 1
...
I0313 21:19:08.751065 3641125 pg_analyze_read_time-test.cc:125] Compaction done!
```

This is ~14s, over 10s and leads to a snapshot too old error.

```
[ts-1] W0313 21:19:05.435123 3640962 tablet_rpc.cc:509] Snapshot too old (yb/tablet/tablet_retention_policy.cc:143): Failed Read(tablet: a6aaa350dc7c4619934858c27a145622, num_ops: 1, num_attempts: 1, txn: 8acbe305-75cd-4cd5-8bcc-749b84a8ae0a, subtxn: [none]) to tablet a6aaa350dc7c4619934858c27a145622 on tablet server { uuid: 7b434e7468254b71a69489dca09bf2ab private: [host: "127.0.0.4" port: 23992] public: [host: "127.0.0.5.ip.yugabyte" port: 23992] cloud_info: placement_cloud: "cloud1" placement_region: "rack2" placement_zone: "zone" after 1 attempt(s): Snapshot too old. Read point: { days: 20160 time: 21:19:05.204489 }, earliest read time allowed: { days: 20160 time: 21:19:05.311221 }, delta (usec): 106732: kSnapshotTooOld (transaction error 4)
2025-03-13 21:19:05.446 UTC [3641113] ERROR:  Snapshot too old. Read point: { days: 20160 time: 21:19:05.204489 }, earliest read time allowed: { days: 20160 time: 21:19:05.311221 }, delta (usec): 106732: kSnapshotTooOld
2025-03-13 21:19:05.446 UTC [3641113] STATEMENT:  ANALYZE keys, values
```

Reduce the number of rows to 1000 in sanitized builds to cut down the compaction time to well within 10s.

Fixes #25622.
Jira: DB-14873

Test Plan: Jenkins

Reviewers: sergei, pjain, smishra

Reviewed By: sergei

Subscribers: yql

Differential Revision: https://phorge.dev.yugabyte.com/D42528
Assets 2
Loading