cockroachdb / cockroachdb/cockroach
sql: investigate "view is already being refreshed" error during prepared statement session migration
- 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
Assessment
This issue has not been assessed yet.