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.

Sign up for GitHub

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

Jump to bottom

[YSQL][LST] ERROR: could not open relation with OID 55086 #12883

Closed
def- opened this issue Jun 14, 2022 · 1 comment · May be fixed by ryan-ally/yugabyte-db#150 or ryan-ally/yugabyte-db#154
Closed

[YSQL][LST] ERROR: could not open relation with OID 55086 #12883

def- opened this issue Jun 14, 2022 · 1 comment · May be fixed by ryan-ally/yugabyte-db#150 or ryan-ally/yugabyte-db#154
Assignees
@m-iancu
Labels
area/docdb YugabyteDB core features kind/bug This issue is a bug priority/medium Medium priority issue

Comments

@def-
Copy link
Contributor

def- commented Jun 14, 2022 •
edited by yugabyte-ci

Jira Link: DB-2634

Description

On a universe created with bin/yb-ctl --replication_factor 3 create --tserver_flags=ysql_enable_packed_row=true,ysql_packed_row_size_limit=1700 --master_flags=ysql_enable_packed_row=true,ysql_packed_row_size_limit=1700
Not sure if this is related to packed rows, couldn't reproduce it. Using LST against current master state (50cbd58) fails with internal errors:

2022-06-14 14:59:44,904 MainThread INFO
2022-06-14 14:59:44,904 MainThread INFO     --------------------------------------------------------------------------------
2022-06-14 14:59:44,904 MainThread INFO     Running Long System Test 0.1
2022-06-14 14:59:44,904 MainThread INFO     --------------------------------------------------------------------------------
2022-06-14 14:59:44,904 MainThread INFO
2022-06-14 14:59:44,967 MainThread INFO     Reproduce with: git checkout 28535cc6 && ./long_system_test.py --nodes=127.0.0.1:5433,127.0.0.2:5433,127.0.0.3:5433 --threads=4 --runtime=0 --complexity=full --max-columns=500 --seed=320365
2022-06-14 14:59:45,102 MainThread INFO     Database version: PostgreSQL 11.2-YB-2.15.1.0-b0 on arm-apple-darwin21.5.0, compiled by Apple clang version 13.1.6 (clang-1316.0.21.2.5), 64-bit
2022-06-14 14:59:45,119 MainThread INFO     Creating tables for database db_lst_320365
2022-06-14 14:59:54,962 MainThread INFO     Starting worker_0: RandomSelectAction, SetConfigAction
2022-06-14 14:59:54,963 MainThread INFO     Starting worker_1: RandomSelectAction, SetConfigAction
2022-06-14 14:59:54,963 MainThread INFO     Starting worker_2: RandomSelectAction, SetConfigAction
2022-06-14 14:59:54,964 MainThread INFO     Starting worker_3: CreateIndexAction, DropIndexAction, SetConfigAction, AddColumnAction
2022-06-14 15:00:04,969 MainThread INFO     Worker queries/s: [066.5][086.9][083.8][006.8]
2022-06-14 15:00:14,975 MainThread INFO     Worker queries/s: [067.7][084.9][082.1][007.5]
2022-06-14 15:00:24,980 MainThread INFO     Worker queries/s: [120.8][152.6][165.4][001.8]
2022-06-14 15:00:34,983 MainThread INFO     Worker queries/s: [072.7][086.4][077.5][006.4]
2022-06-14 15:00:44,984 MainThread INFO     Worker queries/s: [120.9][169.8][142.5][002.0]
2022-06-14 15:00:54,988 MainThread INFO     Worker queries/s: [081.1][129.8][111.8][004.0]
2022-06-14 15:01:04,995 MainThread INFO     Worker queries/s: [091.4][140.2][117.1][003.2]
2022-06-14 15:01:14,995 MainThread INFO     Worker queries/s: [073.4][087.0][089.3][005.6]
2022-06-14 15:01:24,997 MainThread INFO     Worker queries/s: [033.0][035.4][034.0][009.3]
2022-06-14 15:01:34,997 MainThread INFO     Worker queries/s: [101.6][105.0][095.7][003.9]
2022-06-14 15:01:45,000 MainThread INFO     Worker queries/s: [093.0][099.4][098.3][004.5]
2022-06-14 15:01:55,003 MainThread INFO     Worker queries/s: [057.2][066.2][062.0][006.4]
2022-06-14 15:02:05,007 MainThread INFO     Worker queries/s: [089.7][112.3][114.6][001.8]
2022-06-14 15:02:15,011 MainThread INFO     Worker queries/s: [046.0][059.3][069.4][004.0]
2022-06-14 15:02:25,012 MainThread INFO     Worker queries/s: [053.7][064.9][093.3][005.5]
2022-06-14 15:02:35,019 MainThread INFO     Worker queries/s: [052.1][057.0][074.3][004.6]
2022-06-14 15:02:45,024 MainThread INFO     Worker queries/s: [117.4][128.6][156.7][002.1]
2022-06-14 15:02:55,027 MainThread INFO     Worker queries/s: [107.0][135.0][168.4][001.3]
2022-06-14 15:03:05,032 MainThread INFO     Worker queries/s: [097.3][121.6][140.7][002.4]
2022-06-14 15:03:15,039 MainThread INFO     Worker queries/s: [083.8][081.7][102.5][005.6]
2022-06-14 15:03:25,041 MainThread INFO     Worker queries/s: [069.2][078.0][084.6][006.3]
2022-06-14 15:03:35,043 MainThread INFO     Worker queries/s: [126.6][148.3][148.6][002.1]
2022-06-14 15:03:45,054 MainThread INFO     Worker queries/s: [067.0][085.0][094.9][006.1]
2022-06-14 15:03:55,054 MainThread INFO     Worker queries/s: [110.0][145.3][153.5][002.1]
2022-06-14 15:04:05,060 MainThread INFO     Worker queries/s: [061.8][084.6][067.1][004.8]
2022-06-14 15:04:15,065 MainThread INFO     Worker queries/s: [040.9][057.3][050.3][006.2]
2022-06-14 15:04:25,068 MainThread INFO     Worker queries/s: [075.2][099.6][083.8][004.6]
2022-06-14 15:04:35,070 MainThread INFO     Worker queries/s: [061.8][082.2][073.2][005.9]
2022-06-14 15:04:45,071 MainThread INFO     Worker queries/s: [115.8][142.0][133.2][001.1]
2022-06-14 15:04:55,076 MainThread INFO     Worker queries/s: [064.5][067.8][073.3][005.9]
2022-06-14 15:05:05,079 MainThread INFO     Worker queries/s: [092.5][086.6][095.9][004.9]
2022-06-14 15:05:15,084 MainThread INFO     Worker queries/s: [108.6][100.9][112.6][004.2]
2022-06-14 15:05:25,088 MainThread INFO     Worker queries/s: [085.0][068.1][086.3][002.0]
2022-06-14 15:05:35,092 MainThread INFO     Worker queries/s: [109.8][090.5][107.3][004.1]
2022-06-14 15:05:45,098 MainThread INFO     Worker queries/s: [068.5][059.9][068.1][004.3]
2022-06-14 15:05:55,102 MainThread INFO     Worker queries/s: [074.7][060.6][074.5][006.1]
2022-06-14 15:06:05,102 MainThread INFO     Worker queries/s: [130.6][112.9][126.2][002.4]
2022-06-14 15:06:15,105 MainThread INFO     Worker queries/s: [074.3][068.8][073.4][004.3]
2022-06-14 15:06:25,108 MainThread INFO     Worker queries/s: [074.3][064.5][077.3][004.8]
2022-06-14 15:06:35,113 MainThread INFO     Worker queries/s: [065.1][059.1][062.7][006.8]
2022-06-14 15:06:45,113 MainThread INFO     Worker queries/s: [066.6][063.9][070.7][004.8]
2022-06-14 15:06:55,119 MainThread INFO     Worker queries/s: [071.9][064.1][072.1][005.2]
2022-06-14 15:07:05,126 MainThread INFO     Worker queries/s: [003.5][004.4][003.0][008.6]
2022-06-14 15:07:15,130 MainThread INFO     Worker queries/s: [069.8][062.8][067.0][005.0]
2022-06-14 15:07:25,136 MainThread INFO     Worker queries/s: [092.0][089.8][094.7][002.6]
2022-06-14 15:07:35,141 MainThread INFO     Worker queries/s: [073.8][078.4][082.5][003.8]
2022-06-14 15:07:45,144 MainThread INFO     Worker queries/s: [053.4][060.8][068.4][004.3]
2022-06-14 15:07:55,145 MainThread INFO     Worker queries/s: [045.2][046.0][057.6][004.6]
2022-06-14 15:08:05,147 MainThread INFO     Worker queries/s: [050.3][051.5][062.1][004.8]
2022-06-14 15:08:15,151 MainThread INFO     Worker queries/s: [050.5][051.1][064.7][004.9]
2022-06-14 15:08:25,152 MainThread INFO     Worker queries/s: [107.2][108.0][140.8][001.5]
2022-06-14 15:08:35,153 MainThread INFO     Worker queries/s: [049.2][057.6][069.4][004.7]
2022-06-14 15:08:45,155 MainThread INFO     Worker queries/s: [062.5][071.0][082.2][003.3]
2022-06-14 15:08:55,165 MainThread INFO     Worker queries/s: [080.9][097.0][122.0][002.6]
2022-06-14 15:09:05,168 MainThread INFO     Worker queries/s: [042.4][046.4][060.0][004.2]
2022-06-14 15:09:15,170 MainThread INFO     Worker queries/s: [051.5][052.8][068.6][005.0]
2022-06-14 15:09:25,171 MainThread INFO     Worker queries/s: [037.8][049.8][056.9][004.2]
2022-06-14 15:09:35,172 MainThread INFO     Worker queries/s: [001.8][002.7][001.4][006.6]
2022-06-14 15:09:45,175 MainThread INFO     Worker queries/s: [046.1][072.0][067.1][004.4]
2022-06-14 15:09:55,178 MainThread INFO     Worker queries/s: [048.0][062.8][065.0][003.2]
2022-06-14 15:10:05,179 MainThread INFO     Worker queries/s: [069.2][087.7][098.9][002.6]
2022-06-14 15:10:15,187 MainThread INFO     Worker queries/s: [016.7][020.0][024.2][006.3]
2022-06-14 15:10:25,187 MainThread INFO     Worker queries/s: [036.8][039.6][051.3][004.1]
2022-06-14 15:10:35,192 MainThread INFO     Worker queries/s: [027.3][030.8][038.9][005.4]
2022-06-14 15:10:45,197 MainThread INFO     Worker queries/s: [022.9][026.3][029.6][005.5]
2022-06-14 15:10:55,201 MainThread INFO     Worker queries/s: [067.4][084.7][100.4][001.7]
2022-06-14 15:11:05,207 MainThread INFO     Worker queries/s: [051.0][071.3][069.0][003.6]
2022-06-14 15:11:15,208 MainThread INFO     Worker queries/s: [003.3][003.2][001.6][007.3]
2022-06-14 15:11:25,209 MainThread INFO     Worker queries/s: [029.5][035.3][032.5][005.5]
2022-06-14 15:11:35,212 MainThread INFO     Worker queries/s: [036.7][049.4][045.6][004.4]
2022-06-14 15:11:45,217 MainThread INFO     Worker queries/s: [026.3][038.2][034.3][006.5]
2022-06-14 15:11:55,218 MainThread INFO     Worker queries/s: [040.5][059.4][054.0][004.6]
2022-06-14 15:12:05,225 MainThread INFO     Worker queries/s: [082.8][123.3][106.8][001.3]
2022-06-14 15:12:15,228 MainThread INFO     Worker queries/s: [082.7][119.1][098.1][001.2]
2022-06-14 15:12:25,233 MainThread INFO     Worker queries/s: [045.9][065.4][063.7][004.2]
2022-06-14 15:12:35,234 MainThread INFO     Worker queries/s: [069.1][092.3][092.8][002.3]
2022-06-14 15:12:45,242 MainThread INFO     Worker queries/s: [080.5][101.1][095.6][003.1]
2022-06-14 15:12:55,246 MainThread INFO     Worker queries/s: [058.1][079.4][059.8][003.4]
2022-06-14 15:13:05,251 MainThread INFO     Worker queries/s: [099.3][127.4][089.0][002.1]
2022-06-14 15:13:15,254 MainThread INFO     Worker queries/s: [035.8][038.1][027.4][004.5]
2022-06-14 15:13:25,258 MainThread INFO     Worker queries/s: [094.7][112.5][098.5][000.8]
2022-06-14 15:13:35,259 MainThread INFO     Worker queries/s: [064.3][065.2][055.6][003.1]
2022-06-14 15:13:45,259 MainThread INFO     Worker queries/s: [054.9][062.6][058.1][003.9]
2022-06-14 15:13:55,263 MainThread INFO     Worker queries/s: [002.4][002.5][002.8][006.0]
2022-06-14 15:14:05,270 MainThread INFO     Worker queries/s: [002.5][002.4][001.2][007.0]
2022-06-14 15:14:15,275 MainThread INFO     Worker queries/s: [001.6][003.1][001.9][007.3]
2022-06-14 15:14:25,286 MainThread INFO     Worker queries/s: [044.1][055.4][056.9][004.6]
2022-06-14 15:14:35,287 MainThread INFO     Worker queries/s: [058.3][062.7][076.4][003.9]
2022-06-14 15:14:45,288 MainThread INFO     Worker queries/s: [045.6][046.1][057.9][004.1]
2022-06-14 15:14:55,289 MainThread INFO     Worker queries/s: [096.3][099.6][120.4][001.1]
2022-06-14 15:15:05,291 MainThread INFO     Worker queries/s: [079.0][086.7][099.3][001.8]
2022-06-14 15:15:15,296 MainThread INFO     Worker queries/s: [076.4][073.0][099.3][002.0]
2022-06-14 15:15:25,298 MainThread INFO     Worker queries/s: [094.4][090.0][103.9][000.6]
2022-06-14 15:15:35,301 MainThread INFO     Worker queries/s: [049.2][039.1][055.2][003.7]
2022-06-14 15:15:45,307 MainThread INFO     Worker queries/s: [002.0][002.5][001.4][006.0]
2022-06-14 15:15:55,311 MainThread INFO     Worker queries/s: [045.6][051.0][060.1][003.8]
2022-06-14 15:16:05,317 MainThread INFO     Worker queries/s: [045.9][043.7][060.2][004.0]
2022-06-14 15:16:15,327 MainThread INFO     Worker queries/s: [103.2][117.4][131.6][000.9]
2022-06-14 15:16:25,332 MainThread INFO     Worker queries/s: [055.8][052.1][059.1][003.6]
2022-06-14 15:16:35,337 MainThread INFO     Worker queries/s: [001.9][002.2][001.1][006.3]
2022-06-14 15:16:45,342 MainThread INFO     Worker queries/s: [052.9][055.1][059.2][003.6]
2022-06-14 15:16:55,347 MainThread INFO     Worker queries/s: [001.4][001.5][001.4][005.7]
2022-06-14 15:17:05,352 MainThread INFO     Worker queries/s: [003.2][002.0][001.0][005.6]
2022-06-14 15:17:15,358 MainThread INFO     Worker queries/s: [092.4][098.5][127.2][001.2]
2022-06-14 15:17:25,361 MainThread INFO     Worker queries/s: [002.3][001.9][001.3][006.0]
2022-06-14 15:17:35,368 MainThread INFO     Worker queries/s: [058.1][045.5][058.8][002.4]
2022-06-14 15:17:45,371 MainThread INFO     Worker queries/s: [059.5][057.1][074.4][003.1]
2022-06-14 15:17:55,375 MainThread INFO     Worker queries/s: [045.6][045.4][065.1][003.5]
2022-06-14 15:18:05,378 MainThread INFO     Worker queries/s: [084.8][096.9][119.0][002.1]
2022-06-14 15:18:15,383 MainThread INFO     Worker queries/s: [050.2][055.2][070.7][003.5]
2022-06-14 15:18:25,385 MainThread INFO     Worker queries/s: [054.1][056.7][054.1][003.6]
2022-06-14 15:18:27,963 worker_1   ERROR    Unexpected query failure: InternalError_
Query: EXPLAIN (ANALYZE FALSE, VERBOSE TRUE, COSTS TRUE, BUFFERS FALSE, TIMING FALSE, SUMMARY TRUE, FORMAT YAML)
EXECUTE stmt;
  values: None
  runtime: 2022-06-14 15:18:27.955 - 2022-06-14 15:18:27.962
  supports explain: False
  supports rollback: False
  affected rows: None
Action: RandomSelectAction
Error class: InternalError_
Error code: XX000
Error message: ERROR:  could not open relation with OID 55086
CONTEXT:  Catalog Version Mismatch: A DDL occurred while processing this query. Try again.
Transaction isolation level: repeatable read
DB Node: host: 127.0.0.2, port: 5433
DB Backend PID: 4664

postgresql-2022-06-14_151819.log.zip
lst.zip
@def- def- added area/docdb YugabyteDB core features status/awaiting-triage Issue awaiting triage labels Jun 14, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 14, 2022
@def-
Copy link
Contributor Author

def- commented Jun 14, 2022

Duplicate of #11225

@def- def- marked this as a duplicate of #11225 Jun 14, 2022
@def- def- closed this as completed Jun 14, 2022
@yugabyte-ci yugabyte-ci removed the status/awaiting-triage Issue awaiting triage label Jul 9, 2022
This was referenced Jun 22, 2023
Open
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@m-iancu m-iancu

Labels
area/docdb YugabyteDB core features kind/bug This issue is a bug priority/medium Medium priority issue
Projects
None yet
Milestone
No milestone
3 participants
@def- @m-iancu @yugabyte-ci