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

[PITR-YSQL-Tablet Splitting] After restore, select data from table throws Illegal state error #72

Open
Arjun-yb opened this issue Oct 20, 2021 · 0 comments
Assignees

Comments

@Arjun-yb
Copy link

DB Version: 2.8.0.0-b2

Steps:

  1. Create database and table(employees)
  2. Create snapshot schedule
  3. Collect time(t1) and number of tablets(n).
  4. Start workload and observe the tablet splitting count increases(>n)
  5. Stop the workload and restore to the time(t1) which is collected at step:3
  6. Then select the data from the table(employees)
demo=# select count(*) from employees;
ERROR:  Illegal state: [Illegal state (yb/client/meta_cache.cc:909): GetTableLocations { table_name: demo.employees, table_id: 00004000000030008000000000004001, partition_start_key: Pgsql Hash, partition_list_version: 66, request_no: 2, num_attempts: 1 } failed: Wrong order or overlaps in partitions]

Observations:

  1. Tablet count increases after running workload.
  2. If user restores data and select data from table, it throws above error(if the tablets count is increases in between collect time and restore time)
  3. If the tablets count is same(in between collect time and restore time) restore works fine and user can able to select data from table.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants