Skip to content

sql/tests: TestRandomSyntaxSchemaChangeColumn failed #63393

@rafiss

Description

@rafiss

sql/tests.TestRandomSyntaxSchemaChangeColumn failed with artifacts on master @ 9a335c3b2eaac8a5b36ed4e4299be0bbb3d9f548:

[14:52:40]
[post issues]
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:346 +0xfc
[14:52:40]
[post issues]         
[14:52:40]
[post issues]         goroutine 8553553 [select, 2 minutes]:
[14:52:40]
[post issues]         github.com/cockroachdb/cockroach/pkg/kv/kvserver/protectedts/ptcache.(*Cache).periodicallyRefreshProtectedtsCache(0xc01a8acbb0, 0x5bcca60, 0xc00b9329f0)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/kv/kvserver/protectedts/ptcache/cache.go:160 +0x25b
[14:52:40]
[post issues]         github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTask.func1(0xc007dda200, 0x5bcca60, 0xc00b9329f0, 0x0, 0xc017a32600)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:351 +0xb9
[14:52:40]
[post issues]         created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTask
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:346 +0xfc
[14:52:40]
[post issues]         
[14:52:40]
[post issues]         goroutine 8553583 [select, 1 minutes]:
[14:52:40]
[post issues]         github.com/cockroachdb/cockroach/pkg/sql/catalog/lease.(*Manager).PeriodicallyRefreshSomeLeases.func1(0x5bcca60, 0xc00b9329f0)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/sql/catalog/lease/lease.go:1808 +0x285
[14:52:40]
[post issues]         github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTask.func1(0xc007dda200, 0x5bcca60, 0xc00b9329f0, 0x0, 0xc017a32e50)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:351 +0xb9
[14:52:40]
[post issues]         created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTask
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:346 +0xfc
[14:52:40]
[post issues]         
[14:52:40]
[post issues]         goroutine 8553324 [select, 5 minutes]:
[14:52:40]
[post issues]         google.golang.org/grpc.(*ccBalancerWrapper).watcher(0xc008ed7ac0)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/balancer_conn_wrappers.go:69 +0xc8
[14:52:40]
[post issues]         created by google.golang.org/grpc.newCCBalancerWrapper
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/balancer_conn_wrappers.go:60 +0x172
[14:52:40]
[post issues]         
[14:52:40]
[post issues]         goroutine 8553286 [select, 5 minutes]:
[14:52:40]
[post issues]         github.com/cockroachdb/cockroach/pkg/sql.(*DistSQLPlanner).initRunners.func1(0x5bcca60, 0xc00b9329f0)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/sql/distsql_running.go:105 +0x13d
[14:52:40]
[post issues]         github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTask.func1(0xc007dda200, 0x5bcca60, 0xc00b9329f0, 0x0, 0xc006286c10)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:351 +0xb9
[14:52:40]
[post issues]         created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTask
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:346 +0xfc
[14:52:40]
[post issues]         
[14:52:40]
[post issues]         goroutine 8553316 [chan receive, 5 minutes]:
[14:52:40]
[post issues]         github.com/cockroachdb/cockroach/pkg/server.(*Server).startServeUI.func1(0x5bcca60, 0xc00b9329f0)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/server/server.go:2022 +0x53
[14:52:40]
[post issues]         github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTask.func1(0xc007dda200, 0x5bcca60, 0xc00b9329f0, 0x0, 0xc004556160)
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:351 +0xb9
[14:52:40]
[post issues]         created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTask
[14:52:40]
[post issues]         	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:346 +0xfc
[14:52:40]
[post issues]         
[14:52:40]
[post issues]     rsg_test.go:186: SELECT 1 executed successfully: probably a slow statement
[14:52:40]
[post issues]     rsg_test.go:755: Crash detected: 
[14:52:40]
[post issues]         ALTER TABLE ident.ident ADD IF NOT EXISTS SURVIVE INTERVAL DAY TO MINUTE [ ]
[14:52:40]
[post issues]         
[14:52:40]
[post issues]         Stack trace:
[14:52:40]
[post issues]         timeout: "ALTER TABLE ident.ident ADD IF NOT EXISTS SURVIVE INTERVAL DAY TO MINUTE [ ]". currently executing: map[ALTER TABLE ident.ident ADD IF NOT EXISTS SURVIVE INTERVAL DAY TO MINUTE [ ]:1]
[14:52:40]
[post issues]     rsg_test.go:764: 6923 executions, 1292 successful
[14:52:40]
[post issues]     rsg_test.go:401: -- test log scope end --
[14:52:40]
[post issues] test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxSchemaChangeColumn880718491
[14:52:40]
[post issues] --- FAIL: TestRandomSyntaxSchemaChangeColumn (357.99s)
[14:52:40]
[post issues] ```
[14:52:40]
[post issues] <details><summary>Reproduce</summary>
[14:52:40]
[post issues] <p>
[14:52:40]
[post issues] <p>To reproduce, try:
[14:52:40]
[post issues] ```bash
[14:52:40]
[post issues] make stressrace TESTS=TestRandomSyntaxSchemaChangeColumn PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
[14:52:40]
[post issues] ```
[14:52:40]
[post issues] </p>
[14:52:40]
[post issues] </p>
[14:52:40]
[post issues] </details>
[14:52:40]
[post issues] <details><summary>Same failure on other branches</summary>
[14:52:40]
[post issues] <p>
[14:52:40]
[post issues] - #63202 sql/tests: TestRandomSyntaxSchemaChangeColumn failed [C-test-failure O-robot branch-release-20.1]</p>
[14:52:40]
[post issues] </details>
[14:52:40]
[post issues] [See this test on roachdash](https://roachdash.crdb.dev/?filter=status:open%20t:.*TestRandomSyntaxSchemaChangeColumn.*&sort=title+created&display=lastcommented+project)
[14:52:40]
[post issues] <sub>[Improve this report!](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)</sub>
[14:52:40]
[post issues] ", Labels:["O-robot" "C-test-failure" "branch-master"], Assignee:"mjibson"}: POST https://api.github.com/repos/cockroachdb/cockroach/issues: 422 Validation Failed [{Resource:Issue Field:assignee Code:invalid Message:}]
[14:52:40]
[Run Random Syntax tests] artifacts (7s)
[14:52:47]
[Run Random Syntax tests] exit status
[14:52:47]
[Run Random Syntax tests] Process exited with code 2
[14:52:47]
[Step 2/2] Process exited with code 2 (Step: Command Line)
[14:52:47]
[Step 2/2] Step Command Line failed
[14:52:47]
Publishing internal artifacts (4s)
[14:52:47]
Publishing artifacts (5s)
[14:52:53]
Build finished

cc @ajwerner

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).branch-masterFailures and bugs on the master branch.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions