Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ccl/logictestccl: TestCCLLogic failed #59511

Closed
cockroach-teamcity opened this issue Jan 28, 2021 · 7 comments · Fixed by #59580
Closed

ccl/logictestccl: TestCCLLogic failed #59511

cockroach-teamcity opened this issue Jan 28, 2021 · 7 comments · Fixed by #59580
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot.

Comments

@cockroach-teamcity
Copy link
Member

(ccl/logictestccl).TestCCLLogic failed on master@1a459a81dba35b6a091f0a2954aa33d50f1e5d24:

               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213;
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418
        but found (query options: "") :
            t  CREATE TABLE public.t (
               x INT8 NOT NULL,
               y INT8 NOT NULL,
               z INT8 NULL,
               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418;
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213
--- done: testdata/logic_test/zone with config 5node: 144 tests, 1 failures
--- total progress: 571 statements/queries
            --- FAIL: TestCCLLogic/5node/zone/authorization (1.27s)
=== RUN   TestCCLLogic/5node/zone
=== PAUSE TestCCLLogic/5node/zone
=== CONT  TestCCLLogic/5node/zone
        --- FAIL: TestCCLLogic/5node/zone (3.05s)
=== RUN   TestCCLLogic/5node
    --- FAIL: TestCCLLogic/5node (0.00s)
More

Parameters:

  • TAGS=
  • GOFLAGS=-parallel=4
make stressrace TESTS=TestCCLLogic PKG=./pkg/ccl/logictestccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

See this test on roachdash
powered by pkg/cmd/internal/issues
@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Jan 28, 2021
@cockroach-teamcity
Copy link
Member Author

(ccl/logictestccl).TestCCLLogic failed on master@1413f686db7b70a3b25cf336baa283a7767027e1:

               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213;
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418
        but found (query options: "") :
            t  CREATE TABLE public.t (
               x INT8 NOT NULL,
               y INT8 NOT NULL,
               z INT8 NULL,
               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418;
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213
--- done: testdata/logic_test/zone with config 5node: 144 tests, 1 failures
--- total progress: 579 statements/queries
            --- FAIL: TestCCLLogic/5node/zone/authorization (2.46s)
=== RUN   TestCCLLogic/5node/zone
=== PAUSE TestCCLLogic/5node/zone
=== CONT  TestCCLLogic/5node/zone
        --- FAIL: TestCCLLogic/5node/zone (5.93s)
=== RUN   TestCCLLogic/5node
    --- FAIL: TestCCLLogic/5node (0.00s)
More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestCCLLogic PKG=./pkg/ccl/logictestccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

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

@cockroach-teamcity
Copy link
Member Author

(ccl/logictestccl).TestCCLLogic failed on master@86c619f768a4d6f4cc80efb5c9479e5fc0fd72c1:

                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213;
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418
        but found (query options: "") :
            t  CREATE TABLE public.t (
               x INT8 NOT NULL,
               y INT8 NOT NULL,
               z INT8 NULL,
               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418;
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213
--- done: testdata/logic_test/zone with config 5node: 144 tests, 1 failures
            --- FAIL: TestCCLLogic/5node/zone/authorization (1.34s)
=== RUN   TestCCLLogic/5node/zone
=== PAUSE TestCCLLogic/5node/zone
=== CONT  TestCCLLogic/5node/zone
        --- FAIL: TestCCLLogic/5node/zone (4.21s)
=== RUN   TestCCLLogic/5node
    --- FAIL: TestCCLLogic/5node (0.00s)
More

Parameters:

  • TAGS=
  • GOFLAGS=-parallel=4
make stressrace TESTS=TestCCLLogic PKG=./pkg/ccl/logictestccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

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

@stevendanna stevendanna mentioned this issue Jan 29, 2021
Merged
@cockroach-teamcity
Copy link
Member Author

(ccl/logictestccl).TestCCLLogic failed on master@70e72e9b833c763fd933cd752283d556d1faa785:

               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213;
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418
        but found (query options: "") :
            t  CREATE TABLE public.t (
               x INT8 NOT NULL,
               y INT8 NOT NULL,
               z INT8 NULL,
               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418;
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213
--- done: testdata/logic_test/zone with config 5node: 144 tests, 1 failures
--- total progress: 579 statements/queries
            --- FAIL: TestCCLLogic/5node/zone/authorization (2.18s)
=== RUN   TestCCLLogic/5node/zone
=== PAUSE TestCCLLogic/5node/zone
=== CONT  TestCCLLogic/5node/zone
        --- FAIL: TestCCLLogic/5node/zone (5.34s)
=== RUN   TestCCLLogic/5node
    --- FAIL: TestCCLLogic/5node (0.00s)
More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestCCLLogic PKG=./pkg/ccl/logictestccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

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

@cockroach-teamcity
Copy link
Member Author

(ccl/logictestccl).TestCCLLogic failed on master@70e72e9b833c763fd933cd752283d556d1faa785:

               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213;
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418
        but found (query options: "") :
            t  CREATE TABLE public.t (
               x INT8 NOT NULL,
               y INT8 NOT NULL,
               z INT8 NULL,
               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418;
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213
--- done: testdata/logic_test/zone with config 5node: 144 tests, 1 failures
--- total progress: 579 statements/queries
            --- FAIL: TestCCLLogic/5node/zone/authorization (2.17s)
=== RUN   TestCCLLogic/5node/zone
=== PAUSE TestCCLLogic/5node/zone
=== CONT  TestCCLLogic/5node/zone
        --- FAIL: TestCCLLogic/5node/zone (5.68s)
=== RUN   TestCCLLogic/5node
    --- FAIL: TestCCLLogic/5node (0.00s)
More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestCCLLogic PKG=./pkg/ccl/logictestccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

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

@cockroach-teamcity
Copy link
Member Author

(ccl/logictestccl).TestCCLLogic failed on master@ac799bd8f330f47b08b8e0958e3ede0e542b2acc:

               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213;
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418
        but found (query options: "") :
            t  CREATE TABLE public.t (
               x INT8 NOT NULL,
               y INT8 NOT NULL,
               z INT8 NULL,
               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418;
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213
--- done: testdata/logic_test/zone with config 5node: 144 tests, 1 failures
--- total progress: 579 statements/queries
            --- FAIL: TestCCLLogic/5node/zone/authorization (2.93s)
=== RUN   TestCCLLogic/5node/zone
=== PAUSE TestCCLLogic/5node/zone
=== CONT  TestCCLLogic/5node/zone
        --- FAIL: TestCCLLogic/5node/zone (6.49s)
=== RUN   TestCCLLogic/5node
    --- FAIL: TestCCLLogic/5node (0.00s)
More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestCCLLogic PKG=./pkg/ccl/logictestccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

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

@cockroach-teamcity
Copy link
Member Author

(ccl/logictestccl).TestCCLLogic failed on master@171cc86d6d84c110197485b5d886d77cddc12399:

               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213;
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418
        but found (query options: "") :
            t  CREATE TABLE public.t (
               x INT8 NOT NULL,
               y INT8 NOT NULL,
               z INT8 NULL,
               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418;
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213
--- done: testdata/logic_test/zone with config 5node: 144 tests, 1 failures
E210130 00:32:15.134316 66425 sql/stats/automatic_stats.go:302  [-] 4  failed to refresh stats: node unavailable; try another peer
--- total progress: 579 statements/queries
            --- FAIL: TestCCLLogic/5node/zone/authorization (2.13s)
=== RUN   TestCCLLogic/5node/zone
=== PAUSE TestCCLLogic/5node/zone
=== CONT  TestCCLLogic/5node/zone
        --- FAIL: TestCCLLogic/5node/zone (5.57s)
=== RUN   TestCCLLogic/5node
    --- FAIL: TestCCLLogic/5node (0.00s)
More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestCCLLogic PKG=./pkg/ccl/logictestccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

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

@cockroach-teamcity
Copy link
Member Author

(ccl/logictestccl).TestCCLLogic failed on master@171cc86d6d84c110197485b5d886d77cddc12399:

               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213;
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418
        but found (query options: "") :
            t  CREATE TABLE public.t (
               x INT8 NOT NULL,
               y INT8 NOT NULL,
               z INT8 NULL,
               w INT8 NULL,
               CONSTRAINT "primary" PRIMARY KEY (y ASC),
               UNIQUE INDEX t_x_key (x ASC),
               INDEX i1 (z ASC) PARTITION BY LIST (z) (
                 PARTITION p1 VALUES IN ((1), (2)),
                 PARTITION p2 VALUES IN ((3), (4))
               ),
               INDEX i2 (w ASC) PARTITION BY LIST (w) (
                 PARTITION p3 VALUES IN ((5), (6)),
                 PARTITION p4 VALUES IN ((7), (8))
               ),
               FAMILY fam_0_x_y_z_w (x, y, z, w)
            );
            ALTER PARTITION p3 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15411;
            ALTER PARTITION p4 OF INDEX test.public.t@i2 CONFIGURE ZONE USING
              gc.ttlseconds = 15418;
            ALTER PARTITION p1 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15210;
            ALTER PARTITION p2 OF INDEX test.public.t@i1 CONFIGURE ZONE USING
              gc.ttlseconds = 15213
--- done: testdata/logic_test/zone with config 5node: 144 tests, 1 failures
--- total progress: 579 statements/queries
            --- FAIL: TestCCLLogic/5node/zone/authorization (1.16s)
More

Parameters:

  • TAGS=
  • GOFLAGS=-parallel=4
make stressrace TESTS=TestCCLLogic PKG=./pkg/ccl/logictestccl TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

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

craig bot pushed a commit that referenced this issue Jan 31, 2021
@stevendanna
Merge #59580
b8c47c8 
59580: sql: deterministic zone config output for SHOW CREATE r=otan a=stevendanna

Previously, tests that depended on the order of the ALTER PARTITION
statements generated as part of SHOW CREATE would occasionally
fail. This change sorts the zone_configs CTE by the partition_name and
index_name, leading to more deterministic output.

With this in place, I was able to run the previously flaky test 500
times without failure, whereas it previously would fail after 10 or so
runs.

Fixes #59511

Release note (sql change): The SHOW CREATE statement now lists ALTER
PARTITION statements sorted by the partition name and index_name.

Co-authored-by: Steven Danna <[email protected]>
@craig craig bot closed this as completed in 121375a Jan 31, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

sql: deterministic zone config output for SHOW CREATE stevendanna/cockroach
1 participant
@cockroach-teamcity