Skip to content

sql/logictest: TestLogic failed #58269

@cockroach-teamcity

Description

@cockroach-teamcity

(sql/logictest).TestLogic failed on release-20.1@6e7ac59f0ac2af21c810ad22503f2a4fbdff3836:

CREATE TABLE parent2 (p1 INT8, p2 INT8, other INT8, PRIMARY KEY (p1, p2), FAMILY (p1, other, p2));


rewrote:
CREATE TABLE child2 (c INT8 PRIMARY KEY, p1 INT8, p2 INT8, FOREIGN KEY (p1, p2) REFERENCES parent2 (p1, p2), FAMILY (c, p2), FAMILY (p1));


rewrote:
CREATE TABLE str (k INT8 PRIMARY KEY, v STRING, INDEX (v), FAMILY (v, k));


rewrote:
DROP TABLE IF EXISTS t;
CREATE TABLE t (x INT8 PRIMARY KEY, y INT8, z STRING, v INT8, CONSTRAINT i UNIQUE (y) STORING (z, v), FAMILY (z), FAMILY (v), FAMILY (x, y));
INSERT INTO t VALUES (1, 2, '3', 4), (5, 6, '7', 8);
INSERT INTO t VALUES (10, 2, '10', 10) ON CONFLICT (y) DO NOTHING;


rewrote:
CREATE TABLE test.xyz (x INT8 PRIMARY KEY, y INT8, z INT8, INDEX foo (z, y), FAMILY (z), FAMILY (x), FAMILY (y));


rewrote:
CREATE TABLE xy (x INT8, y INT8, INDEX (y), FAMILY (x, y));


rewrote:
CREATE TABLE xyzw (x INT8 PRIMARY KEY, y INT8, z INT8, w INT8, INDEX foo (z, y), FAMILY (x), FAMILY (z), FAMILY (w, y));


rewrote:
CREATE TABLE test.xz (y INT8, z INT8, INDEX foo (z, y), FAMILY (y), FAMILY (z));


rewrote:
CREATE TABLE test.fk_child (id INT8 PRIMARY KEY, v INT8, UNIQUE (id, v), FAMILY (v, id));


        --- FAIL: TestLogic/local/schema_change_retry (17.04s)
            logic.go:1854: 
                 
                testdata/logic_test/schema_change_retry:41: RELEASE SAVEPOINT cockroach_restart
                expected:
                TransactionRetryError
                
                got:
                pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionAbortedError(ABORT_REASON_ABORT_SPAN): "sql txn" meta={id=2269edc9 key=/Table/SystemConfigSpan/Start pri=99.99999995 epo=1 ts=1608790652.353748489,0 min=1608790635.992855038,0 seq=16} lock=true stat=ABORTED rts=1608790652.353748489,0 wto=false max=1608790635.992855038,0
            logic.go:2420: 
                testdata/logic_test/schema_change_retry:44: error while processing
            logic.go:2420: testdata/logic_test/schema_change_retry:44: too many errors encountered, skipping the rest of the input

More

Parameters:

  • GOFLAGS=-json
make stressrace TESTS=TestLogic PKG=./pkg/sql/logictest TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Related:

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

Jira issue: CRDB-3414

Metadata

Metadata

Assignees

No one assigned

    Labels

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

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions