Comments (3)
yuzefovich
commented on July 17, 2024
This reproduces on gceworker (but might take a while) with
./dev test pkg/sql/importer -f=TestImportComputed/import-into-csv-expression-index -v --stress --deadlock
This seems like a race in the schema changer during index creation, so sending it to Foundations.
from cockroach.
rafiss
commented on July 17, 2024
This failed while running the schema change:
CREATE TABLE users (a INT, b INT, INDEX ((a + b)))
From the CRDB logs, it seems like the schema changer tried to execute a CREATE that directly references crdb_internal_idx_expr. I would have expected that to reference the (a+b) expression, but I'm not sure if this is the issue.
I240609 19:38:50.146712 176252440 5@util/log/event_log.go:32 ⋮ [T10,Vtest-tenant,n1,client=127.0.0.1:33212,hostssl,user=root] 1028 ={"Timestamp":1717961930109321724,"EventType":"create_table","Statement":"CREATE TABLE ‹defaultdb›.public.‹users› (‹a› INT8, ‹b› INT8, INDEX (‹crdb_internal_idx_expr›))","Tag":"CREATE TABLE","User":"root","DescriptorID":111,"TableName":"‹defaultdb.public.users›"}
from cockroach.
rafiss
commented on July 17, 2024
Closing in favor of #125619
from cockroach.
Related Issues (20)
- roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed HOT 1
- roachtest: cluster_creation failed
- sqlstats: internal sql stats queries should have background qos level HOT 1
- sql: ALTER COLUMN TYPE on virtual column fails HOT 3
- Sentry: catch.go:29: while building cascade expression: runtime error: invalid memory address or nil pointer dereference (1) attached stack trace -- stack trace: | github.com/cockroachdb/cockroach... HOT 1
- sql: ALTER COULMN TYPE of stored computed column drops default value HOT 2
- Sentry: panic.go:884: panic: × (1) attached stack trace -- stack trace: | runtime.gopanic | GOROOT/src/runtime/panic.go:884 | github.com/cockroachdb/cockroach/pkg/storage.(*pebbleBatch).Clos... HOT 1
- Sentry: error.go:89: unexpected error from the vectorized engine: runtime error: slice bounds out of range [2689:15] (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.... HOT 1
- Sentry: error.go:89: unexpected error from the vectorized engine: runtime error: slice bounds out of range [18:9] (1) assertion failure Wraps: (2) attached stack trace -- stack trace: | github.com... HOT 2
- Sentry: error.go:89: unexpected error from the vectorized engine: runtime error: slice bounds out of range [18:9] (1) Wraps: (2) assertion failure Wraps: (3) attached stack trace -- stack trace: |... HOT 2
- Sentry: error.go:89: unexpected error from the vectorized engine: runtime error: slice bounds out of range [2689:15] (1) Wraps: (2) assertion failure Wraps: (3) attached stack trace -- stack trace: ... HOT 2
- pkg/sql/logictest/tests/cockroach-go-testserver-23.1/cockroach-go-testserver-23_1_test: TestLogic_upgrade_skip_version failed [node unavailable in KV NodeLiveness even though it started up] HOT 2
- ldr: allow for multiple urls on job creation HOT 1
- sql/schemachanger: Need Size Estimation & Warnings for Schema Changes HOT 1
- kv/kvserver/loqrecovery: TestRejectBadVersionApplication failed
- kv/kvserver/protectedts/ptstorage: TestStorage failed HOT 1
- sql: crdb_internal.ranges_no_leases fetches all descriptors needlesly HOT 1
- schemachanger: zone config schema changes do not need to check out descriptors
- changefeedccl: warn or error when user specifies `resolved` < `min_checkpoint_frequency` HOT 1
- : failed
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cockroach.