cockroachdb / cockroachdb/cockroach

sql: investigate "view is already being refreshed" error during prepared statement session migration

Open
#122,382 0 comments 0 reactions 0 assignees View on GitHub
C-bug C-investigation T-sql-foundations
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

We have seen the error `could not prepare statement during session migration (REFRESH MATERIALIZED VIEW ?view?): view is already being refreshed` during session migrations in serverless. Let's understand why it failed, and determine if we need to handle REFRESH statements differently.

https://cockroachlabsgcp.splunkcloud.com/en-US/app/search/search?earliest=-7d%40h&latest=now&q=search%20index%3Dcc-app-crdb*%20%22could%20not%20prepare%20statement%20during%20session%20migration%22%20AND%20(NOT%20%22does%20not%20exist%22)%20%7C%20timechart%20span%3D1h%20count%20by%20friendly_id&display.page.search.mode=verbose&dispatch.sample_ratio=1&display.general.type=statistics&display.page.search.tab=events&sid=1713210479.370980&workload_pool=

Jira issue: CRDB-37846

Epic CRDB-60943

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.