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

[Voyager] Insertion into ybvoyager_visualizer.ybvoyager_visualizer_table_metrics (YUGABYTED UI) fails for tables with large amount of rows #1926

Open
1 task done
yugabyte-ci opened this issue Nov 20, 2024 · 0 comments

Comments

@yugabyte-ci
Copy link

yugabyte-ci commented Nov 20, 2024

Jira Link: DB-14132

Description

Sample logs:
2024-11-16 18:16:47.214310 WARN yugabyted.go:683 Error while running [INSERT INTO ybvoyager_visualizer.ybvoyager_visualizer_table_metrics (migration_uuid, table_name, schema_name,migration_phase, status, count_live_rows, count_total_rows, invocation_timestamp) VALUES ('afefd241-6921-43bf-970d-7818b47bd7ca', '"table_big"', 'public', 4, 1, 8333567534, 8596474086, '2024-11-16 17:58:40') ON CONFLICT (migration_uuid, table_name, schema_name, migration_phase) DO UPDATE SET status = EXCLUDED.status,count_live_rows = EXCLUDED.count_live_rows,count_total_rows = EXCLUDED.count_total_rows,invocation_timestamp = EXCLUDED.invocation_timestamp;] attempt 4: ERROR: integer out of range (SQLSTATE 22003)

row count exceeded the size of integer used for the count_live_rows and count_total_rows columns. We should use BIGINT here.

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.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants