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

[DocDB][LST] Upgrade: ERROR: Service unavailable: GetTableLocations(<table>.pg_type, , 1) failed: Shutdown connection #12693

Closed
def- opened this issue May 27, 2022 · 1 comment
Assignees
Labels
area/docdb YugabyteDB core features kind/bug This issue is a bug priority/medium Medium priority issue qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures qa_lst Bugs identified using lst automation

Comments

@def-
Copy link
Contributor

def- commented May 27, 2022

Jira Link: DB-585

Description

LST fails during upgrade from 2.0.9.0-b13 to 2.13.3.0-b81:

2022-05-27 13:01:00,190 worker_2   ERROR    Unexpected query failure: InternalError_
Query: SELECT 53.79156011691495, '1953-09-27' FROM t0 WHERE ('[1999-11-25,2021-04-12)'::DATERANGE) >= (daterange(NULL, (coalesce(upper(('[1908-02-05,1948-02-06]'::DATERANGE)), (coalesce(upper(('(1915-02-23,2009-05-07]'::DATERANGE)), (coalesce(lower(('(1950-03-11,1980-06-11)'::DATERANGE)), (coalesce(upper((daterange(('1902-03-01'), NULL))), ('1980-06-17'))))))))))) LIMIT 12 OFFSET 8;
  values: None
  runtime: 2022-05-27 13:01:00.155 - 2022-05-27 13:01:00.190
  supports explain: True
  supports rollback: True
  affected rows: None
Action: RandomSelectAction
Error class: InternalError_
Error code: XX000
Error message: ERROR:  Service unavailable: GetTableLocations(db_lst_401991.pg_type, , 1) failed: Shutdown connection
LINE 1: ...'[1908-02-05,1948-02-06]'::DATERANGE)), (coalesce(upper(('(1...
                                                             ^
Transaction isolation level: committed
DB Node: host: 10.9.85.18, port: 5433
DB Backend PID: 18035

While #12650 happens when upgrading from higher versions, on 2.0 I'm getting this error. I'll add logs on Jira.

@def- def- added area/ysql Yugabyte SQL (YSQL) status/awaiting-triage Issue awaiting triage labels May 27, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels May 27, 2022
@def- def- added area/docdb YugabyteDB core features and removed kind/bug This issue is a bug area/ysql Yugabyte SQL (YSQL) priority/medium Medium priority issue labels May 27, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels May 27, 2022
@yugabyte-ci yugabyte-ci assigned rthallamko3 and unassigned bmatican May 31, 2022
@yugabyte-ci yugabyte-ci removed the status/awaiting-triage Issue awaiting triage label May 31, 2022
@rthallamko3 rthallamko3 assigned arybochkin and unassigned rthallamko3 Jun 8, 2022
@kripasreenivasan kripasreenivasan added the qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures label Sep 13, 2022
@Arjun-yb Arjun-yb added the qa_lst Bugs identified using lst automation label Dec 11, 2023
@rthallamko3
Copy link
Contributor

Resolving old issues. Let us know if this is a problem worthwhile investigating.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/docdb YugabyteDB core features kind/bug This issue is a bug priority/medium Medium priority issue qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures qa_lst Bugs identified using lst automation
Projects
None yet
Development

No branches or pull requests

7 participants