Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] Client \copy command can hit Snapshot too old exception during import data #15134

Open
qvad opened this issue Nov 24, 2022 · 0 comments
Open
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue

Comments

@qvad
Copy link
Contributor

qvad commented Nov 24, 2022

Jira Link: DB-4334

Description

hits.tsv is a 80Gb tsv file. In progress in can be imported in 1h.
Need to define yb_client_admin_operation_timeout_sec=3600, otherwise copy will fail with 120 seconds timeout.

During importing data snapshot too old error may occur.

taqo=# \copy hits FROM '/mnt/d0/data/hits.tsv';
ERROR:  Snapshot too old: [Snapshot too old (yb/tablet/tablet_retention_policy.cc:117): Snapshot too old. Read point: { physical: 1669250301024215 }, earliest read time allowed: { physical: 1669250518548004 }, delta (usec): 217523789: kSnapshotTooOld (transaction error 4)]
@qvad qvad added area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels Nov 24, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Nov 24, 2022
@yugabyte-ci yugabyte-ci removed the status/awaiting-triage Issue awaiting triage label Jan 23, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue
Projects
None yet
Development

No branches or pull requests

4 participants