Skip to content

sql/tests: TestRandomSyntaxSchemaChangeColumn failed #63202

@cockroach-teamcity

Description

@cockroach-teamcity

(sql/tests).TestRandomSyntaxSchemaChangeColumn failed on release-20.1@fc34bfc7449aa977172697eac6d5b7aea40e3c89:

Fatal error:

panic: statement exec timeout

Stack:

goroutine 10529233 [running]:
github.com/cockroachdb/cockroach/pkg/sql/tests_test.(*verifyFormatDB).exec(0xc01c1d50e0, 0x4a33b40, 0xc00afa1d00, 0xc015b1b290, 0x2b, 0x0, 0x0)
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/tests/rsg_test.go:188 +0xac5
github.com/cockroachdb/cockroach/pkg/sql/tests_test.TestRandomSyntaxSchemaChangeColumn.func2(0x4a33b40, 0xc00afa1d00, 0xc01c1d50e0, 0xc00d307cc0, 0x49c3500, 0xc01e8ce660)
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/tests/rsg_test.go:378 +0x13b
github.com/cockroachdb/cockroach/pkg/sql/tests_test.testRandomSyntax.func3(0x4a33b40, 0xc00afa1d00, 0x1, 0x459a970, 0x459aa30)
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/tests/rsg_test.go:726 +0xc7
github.com/cockroachdb/cockroach/pkg/util/ctxgroup.GroupWorkers.func1(0x4a33b40, 0xc00afa1d00, 0x4a33b80, 0xc000124010)
	/go/src/github.com/cockroachdb/cockroach/pkg/util/ctxgroup/ctxgroup.go:175 +0x42
github.com/cockroachdb/cockroach/pkg/util/ctxgroup.Group.GoCtx.func1(0xc01d7ffec0, 0x15)
	/go/src/github.com/cockroachdb/cockroach/pkg/util/ctxgroup/ctxgroup.go:166 +0x3a
github.com/cockroachdb/cockroach/vendor/golang.org/x/sync/errgroup.(*Group).Go.func1(0xc0178d06f0, 0xc0178d0750)
	/go/src/github.com/cockroachdb/cockroach/vendor/golang.org/x/sync/errgroup/errgroup.go:57 +0x59
created by github.com/cockroachdb/cockroach/vendor/golang.org/x/sync/errgroup.(*Group).Go
	/go/src/github.com/cockroachdb/cockroach/vendor/golang.org/x/sync/errgroup/errgroup.go:54 +0x66

Log preceding fatal error

	/go/src/github.com/cockroachdb/cockroach/vendor/github.com/lib/pq/conn.go:867 +0x28c
github.com/cockroachdb/cockroach/vendor/github.com/lib/pq.(*conn).ExecContext(0xc0021ea580, 0x4a33b40, 0xc00afa1d00, 0xc016619a00, 0x3e, 0x6881330, 0x0, 0x0, 0x0, 0x0, ...)
	/go/src/github.com/cockroachdb/cockroach/vendor/github.com/lib/pq/conn_go18.go:42 +0x1c9
database/sql.ctxDriverExec(0x4a33b40, 0xc00afa1d00, 0x7f8b26b35910, 0xc0021ea580, 0x0, 0x0, 0xc016619a00, 0x3e, 0x6881330, 0x0, ...)
	/usr/local/go/src/database/sql/ctxutil.go:31 +0x227
database/sql.(*DB).execDC.func2()
	/usr/local/go/src/database/sql/sql.go:1570 +0x1de
database/sql.withLock(0x49f81c0, 0xc01e704510, 0xc005bc0548)
	/usr/local/go/src/database/sql/sql.go:3284 +0x69
database/sql.(*DB).execDC(0xc016072f70, 0x4a33b40, 0xc00afa1d00, 0xc01e704510, 0xc005bc0670, 0xc016619a00, 0x3e, 0x0, 0x0, 0x0, ...)
	/usr/local/go/src/database/sql/sql.go:1565 +0x495
database/sql.(*DB).exec(0xc016072f70, 0x4a33b40, 0xc00afa1d00, 0xc016619a00, 0x3e, 0x0, 0x0, 0x0, 0x4a33b01, 0xc000124010, ...)
	/usr/local/go/src/database/sql/sql.go:1550 +0x139
database/sql.(*DB).ExecContext(0xc016072f70, 0x4a33b40, 0xc00afa1d00, 0xc016619a00, 0x3e, 0x0, 0x0, 0x0, 0x0, 0xc0116aaec0, ...)
	/usr/local/go/src/database/sql/sql.go:1528 +0xe5
github.com/cockroachdb/cockroach/pkg/sql/tests_test.(*verifyFormatDB).exec.func1(0xc01c1d50e0, 0x4a33b40, 0xc00afa1d00, 0xc016619a00, 0x3e, 0xc015571260)
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/tests/rsg_test.go:132 +0x7f
created by github.com/cockroachdb/cockroach/pkg/sql/tests_test.(*verifyFormatDB).exec
	/go/src/github.com/cockroachdb/cockroach/pkg/sql/tests/rsg_test.go:131 +0x18a

goroutine 10528559 [chan receive, 4 minutes]:
github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/cmux.muxListener.Accept(...)
	/go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/cmux/cmux.go:184
net/http.(*Server).Serve(0xc0002c7960, 0x4a1f7c0, 0xc00ae94fa0, 0x0, 0x0)
	/usr/local/go/src/net/http/server.go:2937 +0x266
github.com/cockroachdb/cockroach/pkg/server.(*Server).startServeUI.func3(0x4a33c00, 0xc02234bef0)
	/go/src/github.com/cockroachdb/cockroach/pkg/server/server.go:2046 +0x127
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunWorker.func1(0xc02679f0d0, 0xc003a4f830, 0xc006be51d0)
	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:198 +0xfd
created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunWorker
	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:191 +0xa8

goroutine 10528572 [select]:
github.com/cockroachdb/cockroach/pkg/gossip.(*Gossip).manage.func1(0x4a33c00, 0xc007d9f650)
	/go/src/github.com/cockroachdb/cockroach/pkg/gossip/gossip.go:1396 +0x345
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunWorker.func1(0xc02679f470, 0xc003a4f830, 0xc02679f460)
	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:198 +0xfd
created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunWorker
	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:191 +0xa8

goroutine 10528646 [select]:
github.com/cockroachdb/cockroach/pkg/kv/kvserver.(*Store).coalescedHeartbeatsLoop(0xc002121500, 0x4a33c00, 0xc01f298900)
	/go/src/github.com/cockroachdb/cockroach/pkg/kv/kvserver/store_raft.go:648 +0x135
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunWorker.func1(0xc00d40cdb0, 0xc003a4f830, 0xc00d40cda0)
	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:198 +0xfd
created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunWorker
	/go/src/github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:191 +0xa8

SELECT 1 executed successfully: probably a slow statement
timeout: "ALTER TABLE ident.ident DROP TREAT RESTRICT". currently executing: map[ALTER TABLE ident.ident ADD COLUMN IF INTERVAL ARRAY [ 327 ] CREATE IF NOT EXISTS FAMILY GREATEST:1 ALTER TABLE ident.ident ADD COLUMN STDIN VARCHAR ( 74 ) ARRAY CREATE FAMILY ENUM:1 ALTER TABLE ident.ident ADD MINVALUE INTERVAL [ ]:1 ALTER TABLE ident.ident ADD ident VARBIT ( 405 ) ARRAY [ 350 ]:1 ALTER TABLE ident.ident ALTER COLUMN ORDINALITY SET NOT NULL:1 ALTER TABLE ident.ident ALTER ident SET NOT NULL:1 ALTER TABLE ident.ident DROP COLUMN IF EXISTS CHARACTERISTICS:1 ALTER TABLE ident.ident DROP TREAT RESTRICT:1]

More

make stressrace TESTS=TestRandomSyntaxSchemaChangeColumn PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

See this test on roachdash
powered by pkg/cmd/internal/issues

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-test-failureBroken test (automatically or manually discovered).O-robotOriginated from a bot.

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions