Skip to content

sql/logictest: TestLogic/local-declarative-schema/new_schema_changer/drop_database flake #76237

@petermattis

Description

@petermattis

Looks like there is some non-determinism in this test.

=== RUN   TestLogic/local-declarative-schema/new_schema_changer/drop_database
[14:54:47] --- progress: /go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/testdata/logic_test/inverted_index_multi_column: 55 statements
[14:54:47] --- done: /go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/testdata/logic_test/inverted_index_multi_column with config local-declarative-schema: 56 tests, 0 failures
[14:54:47] --- done: /go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/testdata/logic_test/inverted_filter_geospatial with config local-declarative-schema: 23 tests, 0 failures
=== CONT  TestLogic/local-declarative-schema/new_schema_changer/drop_database
    logic.go:2493: 
         
        /go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/testdata/logic_test/new_schema_changer:684: SELECT database_id, role_name, settings FROM system.database_role_settings ORDER BY 1, 2
        expected:
            database_id  role_name      settings
            0            ·              {application_name=d}
            0            test_set_role  {application_name=a,custom_option.setting=e}
            183          ·              {application_name=c}
            183          test_set_role  {application_name=b}
            
        but found (query options: "colnames") :
            database_id  role_name      settings
            0            ·              {application_name=d}
            0            test_set_role  {application_name=a,custom_option.setting=e}
            184          ·              {application_name=c}
            184          test_set_role  {application_name=b}
    logic.go:2036: 
         /go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/testdata/logic_test/new_schema_changer:693: too many errors encountered, skipping the rest of the input
[14:54:52] --- done: /go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/testdata/logic_test/new_schema_changer with config local-declarative-schema: 189 tests, 2 failures
            --- FAIL: TestLogic/local-declarative-schema/new_schema_changer/drop_database (5.20s)

Metadata

Metadata

Assignees

Labels

C-test-failureBroken test (automatically or manually discovered).T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions