search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.11k stars 3.81k forks source link

configprofiles: TestProfilesValidSQL failed #130863

Closed cockroach-teamcity closed 4 days ago

cockroach-teamcity commented 1 month ago

configprofiles.TestProfilesValidSQL failed with artifacts on release-23.2.12-rc @ bf1ecaa86c48f31a0cfcc8e42b23fc856736554e:

F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx.func2()
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:484 +0x13a
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !created by github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunAsyncTaskEx in goroutine 31917
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/cockroach/pkg/util/stop/stopper.go:475 +0x415
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !goroutine 32853 [select]:
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !database/sql.(*DB).connectionOpener(0xc0056508f0, {0x7b5e878, 0xc005a5dc70})
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !    GOROOT/src/database/sql/sql.go:1218 +0x87
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !created by database/sql.OpenDB in goroutine 30379
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !    GOROOT/src/database/sql/sql.go:791 +0x165
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !For more context, check log files in: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+app+sharedservice3353598685
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !****************************************************************************
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !This node experienced a fatal error (printed above), and as a result the
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !process is terminating.
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !Fatal errors can occur due to faulty hardware (disks, memory, clocks) or a
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !problem in CockroachDB. With your help, the support team at Cockroach Labs
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !will try to determine the root cause, recommend next steps, and we can
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !improve CockroachDB based on your report.
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !Please submit a crash report by following the instructions here:
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !    https://github.com/cockroachdb/cockroach/issues/new/choose
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !If you would rather not post publicly, please contact us directly at:
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !    support@cockroachlabs.com
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:09:46.329923 33114 util/cidr/cidr.go:142  [T3,n1] 1 !The Cockroach Labs team appreciates your feedback.
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/4/create_an_application_virtual_cluster
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER application
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER application START SERVICE SHARED
=== RUN   TestProfilesValidSQL/virtual+noapp+repl
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+noapp+repl1608050796
    test_log_scope.go:81: use -show-logs to present logs inline
    profiles_test.go:71: -- test log scope end --
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/2/create_virtual_cluster_template
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+app+sharedservice3353598685
    test_log_scope.go:81: use -show-logs to present logs inline
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'

Parameters:

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #130659 configprofiles: TestProfilesValidSQL failed [A-multitenancy C-test-failure O-robot T-db-server branch-release-23.2 release-blocker]

/cc @cockroachdb/server

This test on roachdash | Improve this report!

Jira issue: CRDB-42274

cockroach-teamcity commented 1 month ago

configprofiles.TestProfilesValidSQL failed with artifacts on release-23.2.12-rc @ bf1ecaa86c48f31a0cfcc8e42b23fc856736554e:

F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/pebble/record/external/com_github_cockroachdb_pebble/record/log_writer.go:204
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !github.com/cockroachdb/pebble/record.(*LogWriter).flushLoop(0xc003ed8000, {0xc002380210, 0x9190160})
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/pebble/record/external/com_github_cockroachdb_pebble/record/log_writer.go:436 +0xbe5
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !runtime/pprof.Do({0xd33c848?, 0x125bb5a0}, {{0xc0013a63e0?, 0x45d4b5?, 0x8a5bef0?}}, 0xc0033c6fc0)
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    GOROOT/src/runtime/pprof/runtime.go:51 +0x143
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !github.com/cockroachdb/pebble/record.NewLogWriter.func2()
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/pebble/record/external/com_github_cockroachdb_pebble/record/log_writer.go:355 +0x92
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !created by github.com/cockroachdb/pebble/record.NewLogWriter in goroutine 40181
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/pebble/record/external/com_github_cockroachdb_pebble/record/log_writer.go:354 +0x6cd
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !goroutine 40307 [chan receive]:
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !github.com/cockroachdb/pebble.(*tableCacheShard).releaseLoop.func1({0xd33c9d0, 0xc00989e2d0})
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/pebble/external/com_github_cockroachdb_pebble/table_cache.go:385 +0xfc
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !runtime/pprof.Do({0xd33c848?, 0x125bb5a0}, {{0xc0013a6600?, 0xc00be20000?, 0x1ab13e0?}}, 0xc0056ecfa0)
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    GOROOT/src/runtime/pprof/runtime.go:51 +0x143
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !github.com/cockroachdb/pebble.(*tableCacheShard).releaseLoop(0xc0023e9290)
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/pebble/external/com_github_cockroachdb_pebble/table_cache.go:383 +0x92
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !created by github.com/cockroachdb/pebble.(*tableCacheShard).init in goroutine 40181
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/pebble/external/com_github_cockroachdb_pebble/table_cache.go:375 +0x19d
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !goroutine 40293 [select]:
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !github.com/cockroachdb/cockroach/pkg/util/admission.initWorkQueue.func2()
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/cockroach/pkg/util/admission/work_queue.go:425 +0xbd
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !created by github.com/cockroachdb/cockroach/pkg/util/admission.initWorkQueue in goroutine 40181
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    github.com/cockroachdb/cockroach/pkg/util/admission/work_queue.go:422 +0x645
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !For more context, check log files in: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+app+sharedservice273649807
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !****************************************************************************
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !This node experienced a fatal error (printed above), and as a result the
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !process is terminating.
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !Fatal errors can occur due to faulty hardware (disks, memory, clocks) or a
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !problem in CockroachDB. With your help, the support team at Cockroach Labs
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !will try to determine the root cause, recommend next steps, and we can
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !improve CockroachDB based on your report.
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !Please submit a crash report by following the instructions here:
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    https://github.com/cockroachdb/cockroach/issues/new/choose
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !If you would rather not post publicly, please contact us directly at:
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !    support@cockroachlabs.com
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 10:13:21.423614 43379 util/cidr/cidr.go:142  [T3,n1] 1 !The Cockroach Labs team appreciates your feedback.
=== RUN   TestProfilesValidSQL/virtual+noapp/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'

Parameters:

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #130659 configprofiles: TestProfilesValidSQL failed [A-multitenancy C-test-failure O-robot T-db-server branch-release-23.2 release-blocker]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 month ago

configprofiles.TestProfilesValidSQL failed with artifacts on release-23.2.12-rc @ bf1ecaa86c48f31a0cfcc8e42b23fc856736554e:

F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !Fatal errors can occur due to faulty hardware (disks, memory, clocks) or a
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !problem in CockroachDB. With your help, the support team at Cockroach Labs
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !will try to determine the root cause, recommend next steps, and we can
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !improve CockroachDB based on your report.
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !Please submit a crash report by following the instructions here:
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !    https://github.com/cockroachdb/cockroach/issues/new/choose
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !If you would rather not post publicly, please contact us directly at:
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !    support@cockroachlabs.com
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !
F240917 11:09:49.335448 8524863 util/cidr/cidr.go:142  [T3,n1] 1 !The Cockroach Labs team appreciates your feedback.
=== RUN   TestProfilesValidSQL/virtual+noapp+repl
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+noapp+repl3923729007
    test_log_scope.go:81: use -show-logs to present logs inline
    profiles_test.go:71: -- test log scope end --
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/2/create_virtual_cluster_template
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/4/enable_rangefeeds_and_replication
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING kv.rangefeed.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING physical_replication.enabled = true
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+app+sharedservice3187453132
    test_log_scope.go:81: use -show-logs to present logs inline
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/4/create_an_application_virtual_cluster
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER application
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER application START SERVICE SHARED
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/1/initial_cluster_config
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING trace.redact_at_virtual_cluster_boundary.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.zone_configs.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.zone_configs_unrestricted.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.multiregion.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING spanconfig.range_coalescing.system.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING spanconfig.range_coalescing.application.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.drop_virtual_cluster.enabled = false
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/2/create_virtual_cluster_template
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'

Parameters:

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #130659 configprofiles: TestProfilesValidSQL failed [A-multitenancy C-test-failure O-robot T-db-server branch-release-23.2 release-blocker]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 month ago

configprofiles.TestProfilesValidSQL failed with artifacts on release-23.2.12-rc @ d186c29796c0b1852113c5a13843e41f090616ee:

F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !will try to determine the root cause, recommend next steps, and we can
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !improve CockroachDB based on your report.
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !Please submit a crash report by following the instructions here:
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !    https://github.com/cockroachdb/cockroach/issues/new/choose
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !If you would rather not post publicly, please contact us directly at:
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !    support@cockroachlabs.com
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !
F240918 10:11:29.291223 38351 util/cidr/cidr.go:142  [T3,n1] 1 !The Cockroach Labs team appreciates your feedback.
=== RUN   TestProfilesValidSQL/virtual+noapp+repl
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+noapp+repl1346323681
    test_log_scope.go:81: use -show-logs to present logs inline
    profiles_test.go:71: -- test log scope end --
=== RUN   TestProfilesValidSQL/virtual+noapp/2/create_virtual_cluster_template
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+noapp/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'
=== RUN   TestProfilesValidSQL/example/1/create_an_example_database
    profiles_test.go:61: txn statement: CREATE DATABASE IF NOT EXISTS example
    profiles_test.go:61: txn statement: CREATE TABLE IF NOT EXISTS example.data AS SELECT 'hello' AS value
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/2/create_virtual_cluster_template
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+noapp
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+noapp2053301395
    test_log_scope.go:81: use -show-logs to present logs inline
    profiles_test.go:71: -- test log scope end --
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/2/create_virtual_cluster_template
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'
=== RUN   TestProfilesValidSQL/virtual+noapp/1/initial_cluster_config
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING trace.redact_at_virtual_cluster_boundary.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.zone_configs.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.zone_configs_unrestricted.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.multiregion.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING spanconfig.range_coalescing.system.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING spanconfig.range_coalescing.application.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.drop_virtual_cluster.enabled = false

Parameters:

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #130659 configprofiles: TestProfilesValidSQL failed [A-multitenancy C-test-failure O-robot T-db-server branch-release-23.2 release-blocker]

This test on roachdash | Improve this report!

cockroach-teamcity commented 1 month ago

configprofiles.TestProfilesValidSQL failed with artifacts on release-23.2.12-rc @ d186c29796c0b1852113c5a13843e41f090616ee:

F240918 10:17:15.928497 50615 util/cidr/cidr.go:142  [T3,n1] 1 !
F240918 10:17:15.928497 50615 util/cidr/cidr.go:142  [T3,n1] 1 !The Cockroach Labs team appreciates your feedback.
=== RUN   TestProfilesValidSQL/virtual+noapp
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+noapp3648274435
    test_log_scope.go:81: use -show-logs to present logs inline
    profiles_test.go:71: -- test log scope end --
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice+repl/6/enable_rangefeeds_and_replication
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING kv.rangefeed.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING physical_replication.enabled = true
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice+repl/1/initial_cluster_config
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING trace.redact_at_virtual_cluster_boundary.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.zone_configs.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.zone_configs_unrestricted.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.virtual_cluster.feature_access.multiregion.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING spanconfig.range_coalescing.system.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING spanconfig.range_coalescing.application.enabled = false
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.drop_virtual_cluster.enabled = false
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice+repl/4/create_an_application_virtual_cluster
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER application
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER application START SERVICE SHARED
=== RUN   TestProfilesValidSQL/virtual+noapp+repl
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+noapp+repl93094104
    test_log_scope.go:81: use -show-logs to present logs inline
    profiles_test.go:71: -- test log scope end --
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/2/create_virtual_cluster_template
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice+repl
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+app+sharedservice+repl392646932
    test_log_scope.go:81: use -show-logs to present logs inline
    profiles_test.go:71: -- test log scope end --
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice
    test_log_scope.go:170: test logs captured to: /artifacts/tmp/_tmp/f07519a9a253a7694f6e67cf7554fe40/logTestProfilesValidSQL_virtual+app+sharedservice596387920
    test_log_scope.go:81: use -show-logs to present logs inline
=== RUN   TestProfilesValidSQL/virtual+app+sharedservice+repl/3/use_the_application_virtual_cluster_template_by_default_in_CREATE_VIRTUAL_CLUSTER
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING sql.create_virtual_cluster.default_template = 'template'
=== RUN   TestProfilesValidSQL/virtual+noapp+repl/4/enable_rangefeeds_and_replication
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING kv.rangefeed.enabled = true
    profiles_test.go:52: non-txn statement: SET CLUSTER SETTING physical_replication.enabled = true
=== RUN   TestProfilesValidSQL/virtual+noapp/2/create_virtual_cluster_template
    profiles_test.go:61: txn statement: CREATE VIRTUAL CLUSTER template
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template GRANT ALL CAPABILITIES
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_scatter.enabled = true
    profiles_test.go:61: txn statement: ALTER VIRTUAL CLUSTER template SET CLUSTER SETTING sql.virtual_cluster.feature_access.manual_range_split.enabled = true

Parameters:

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #130659 configprofiles: TestProfilesValidSQL failed [A-multitenancy C-test-failure O-robot T-db-server branch-release-23.2 release-blocker]

This test on roachdash | Improve this report!

rimadeodhar commented 4 days ago

Closing as stale