sql/logictest: TestLogic failed #46713

cockroach-teamcity · 2020-03-29T05:44:03Z

(sql/logictest).TestLogic failed on master@92495ffb2182671b3338a8c6cd2734cb6de5d392:

=== RUN   TestLogic
--- FAIL: TestLogic (1118.16s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic025788814
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/local/alter_table
=== PAUSE TestLogic/local/alter_table
=== CONT  TestLogic/local/alter_table
rewrote:
DROP TABLE IF EXISTS t;
CREATE TABLE t (k INT8 PRIMARY KEY, a INT8, b INT8, FAMILY (a, b), FAMILY (k));


--- done: testdata/logic_test/and_or with config local: 6 tests, 0 failures
        --- FAIL: TestLogic/local/alter_table (70.25s)
            logic.go:1843: 
                 
                testdata/logic_test/alter_table:556: SELECT a,b FROM add_default WHERE e > d AND e - d < interval '10s'
                expected:
                    2 42
                    3 10
                    5 NULL
                    
                but found (query options: "rowsort" -> ignore the following ordering of rows) :
                    
                
            logic.go:2409: 
                testdata/logic_test/alter_table:563: error while processing
            logic.go:2409: testdata/logic_test/alter_table:563: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/local
    --- FAIL: TestLogic/local (0.68s)

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3
sql/logictest: TestLogic failed #46268 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003181957_v20.1.0-beta.3

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

The text was updated successfully, but these errors were encountered:

cockroach-teamcity · 2020-04-03T13:01:49Z

(sql/logictest).TestLogic failed on master@1780a10cfb4cccdb54c7cb931ab872e7c421fe9f:

=== RUN   TestLogic
--- FAIL: TestLogic (1037.17s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic081583403
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/distsql_automatic_stats
=== PAUSE TestLogic/fakedist/distsql_automatic_stats
=== CONT  TestLogic/fakedist/distsql_automatic_stats
--- progress: testdata/logic_test/fk: 32 statements/queries
--- progress: testdata/logic_test/event_log: 64 statements/queries
--- progress: testdata/logic_test/family: 47 statements/queries
        --- FAIL: TestLogic/fakedist/distsql_automatic_stats (49.23s)
            logic.go:1831: condition failed to evaluate within 45s: 
                testdata/logic_test/distsql_automatic_stats:143: SELECT statistics_name, column_names, row_count, distinct_count, null_count
                FROM [SHOW STATISTICS FOR TABLE test_create] ORDER BY column_names::STRING, created
                expected:
                    statistics_name  column_names  row_count  distinct_count  null_count
                    __auto__         {x}           0          0               0
                    __auto__         {y}           0          0               0
                    
                but found (query options: "colnames,rowsort,retry" -> ignore the following ordering of rows) :
                    statistics_name  column_names  row_count  distinct_count  null_count
                    
                
                goroutine 2872990 [running]:
                runtime/debug.Stack(0xc019c0f600, 0x422f3a0, 0xc05fde1100)
                	/usr/local/go/src/runtime/debug/stack.go:24 +0x9d
                github.com/cockroachdb/cockroach/pkg/testutils.SucceedsSoon(0x4314600, 0xc0009abc00, 0xc019c0f600)
                	/go/src/github.com/cockroachdb/cockroach/pkg/testutils/soon.go:37 +0x6b
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).processSubtest(0xc04354b380, 0x0, 0x0, 0xc0476b82d0, 0x0, 0xc0000589f0, 0x2b, 0x3ac949f, 0x8, 0x3, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:1831 +0x1ea2
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).processTestFile(0xc04354b380, 0xc0000589f0, 0x2b, 0x3ac949f, 0x8, 0x3, 0x1, 0x3abfcd9, 0x2, 0x0, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:1390 +0x699
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).runFile(0xc04354b380, 0xc0000589f0, 0x2b, 0x3ac949f, 0x8, 0x3, 0x1, 0x3abfcd9, 0x2, 0x0, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:2408 +0x110
                github.com/cockroachdb/cockroach/pkg/sql/logictest.RunLogicTest.func1.1(0xc0009abc00)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:2532 +0x253
                testing.tRunner(0xc0009abc00, 0xc050769680)
                	/usr/local/go/src/testing/testing.go:909 +0xc9
                created by testing.(*T).Run
                	/usr/local/go/src/testing/testing.go:960 +0x350
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (1.00s)

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3
sql/logictest: TestLogic failed #46268 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003181957_v20.1.0-beta.3

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

cockroach-teamcity · 2020-04-03T16:18:30Z

(sql/logictest).TestLogic failed on master@5d33d44abe755effcf31b9cfd2d85274b530392a:

=== RUN   TestLogic
--- FAIL: TestLogic (1034.14s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic069055072
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist-vec/vectorize_types
=== PAUSE TestLogic/fakedist-vec/vectorize_types
=== CONT  TestLogic/fakedist-vec/vectorize_types
rewrote:
CREATE TABLE users (id INT8 PRIMARY KEY, name VARCHAR NOT NULL, title VARCHAR, INDEX foo (name), CONSTRAINT bar UNIQUE (id, name), FAMILY (title, id), FAMILY (name));


rewrote:
CREATE TABLE t (k INT8 PRIMARY KEY, v INT8, FAMILY (v), FAMILY (k));


rewrote:
CREATE TABLE users_dupe (id INT8 PRIMARY KEY, name VARCHAR NOT NULL, title VARCHAR, INDEX foo (name), CONSTRAINT bar UNIQUE (id, name), FAMILY (title), FAMILY (name), FAMILY (id));


        --- FAIL: TestLogic/fakedist-vec/vectorize_types (0.94s)
            logic.go:1564: 
                 
                testdata/logic_test/vectorize_types:82: 
                expected:
                pq: unable to vectorize execution plan: unhandled type int\[\]
                
                got:
                pq: unsupported type int[]
            logic.go:2409: 
                testdata/logic_test/vectorize_types:85: error while processing
            logic.go:2409: testdata/logic_test/vectorize_types:85: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist-vec
    --- FAIL: TestLogic/fakedist-vec (0.39s)

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3
sql/logictest: TestLogic failed #46268 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003181957_v20.1.0-beta.3

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

cockroach-teamcity · 2020-04-06T21:44:47Z

(sql/logictest).TestLogic failed on master@8db0d8ca7ff40b5f0076f5948a34efb0968e458e:

=== RUN   TestLogic/local-vec-off/cascade/UpdateCascade_PrimaryKeys
--- progress: testdata/logic_test/fk: 32 statements/queries
--- progress: testdata/logic_test/alter_table: 88 statements/queries
--- progress: testdata/logic_test/family: 39 statements/queries
rewrote:
CREATE TABLE "user content"."customer reviews" (id INT8 PRIMARY KEY, product STRING NOT NULL REFERENCES products, customer INT8, "order" INT8, shipment INT8, body STRING, CONSTRAINT customerfk FOREIGN KEY (customer) REFERENCES customers, CONSTRAINT orderfk FOREIGN KEY ("order", shipment) REFERENCES orders (id, shipment), INDEX (product), INDEX (customer), INDEX ("order"), FAMILY (shipment, product, body), FAMILY (id, "order", customer));


log: exiting because of error: write /tmp/logTestLogic095084688/logictesttest.467119d63158.roach.2020-04-06T21_41_20Z.012241.log: no space left on device
--- done: testdata/logic_test/interleaved with config local-vec-off: 90 tests, 0 failures
FAIL	github.com/cockroachdb/cockroach/pkg/sql/logictest	275.391s

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3
sql/logictest: TestLogic failed #46268 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003181957_v20.1.0-beta.3

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

cockroach-teamcity · 2020-04-07T12:06:25Z

(sql/logictest).TestLogic failed on master@5a3aae1a1aa9b170c5ab5e11f568c897cab58c3e:

=== RUN   TestLogic
--- FAIL: TestLogic (1173.44s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic805163858
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist-vec-off/schema_change_in_txn/delete_index_and_table_in_txn
rewrote:
CREATE TABLE people (id INT8 PRIMARY KEY, name STRING, FAMILY (name), FAMILY (id));


rewrote:
CREATE TABLE no_default_table_ref2_default_on_update (id INT8 PRIMARY KEY, ref1 INT8, ref2 INT8 DEFAULT 1, INDEX (ref1, ref2), FOREIGN KEY (ref1, ref2) REFERENCES a (id2, id1) ON UPDATE SET DEFAULT, FAMILY (ref1, id), FAMILY (ref2));


            --- FAIL: TestLogic/fakedist-vec-off/schema_change_in_txn/delete_index_and_table_in_txn (6.56s)
                logic.go:2104: 
                    
                    testdata/logic_test/schema_change_in_txn:1747: 
                    expected success, but found
                    (40001) restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): meta={id=8603b5fd key=/Table/SystemConfigSpan/Start pri=0.03761817 epo=0 ts=1586260642.126596898,2 min=1586260639.101498844,0 seq=25} lock=true stat=PENDING rts=1586260639.101498844,0 wto=false max=1586260639.101498844,0
                logic.go:1416: 
                     pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): meta={id=8603b5fd key=/Table/SystemConfigSpan/Start pri=0.03761817 epo=0 ts=1586260642.126596898,2 min=1586260639.101498844,0 seq=25} lock=true stat=PENDING rts=1586260639.101498844,0 wto=false max=1586260639.101498844,0
=== RUN   TestLogic/fakedist-vec-off/schema_change_in_txn
=== PAUSE TestLogic/fakedist-vec-off/schema_change_in_txn
=== CONT  TestLogic/fakedist-vec-off/schema_change_in_txn
rewrote:
DROP TABLE IF EXISTS t;
CREATE TABLE t (x INT8 PRIMARY KEY, y INT8 NOT NULL, FAMILY (x), FAMILY (y));


--- done: testdata/logic_test/secondary_index_column_families with config fakedist-vec-off: 17 tests, 0 failures
--- done: testdata/logic_test/function_lookup with config fakedist-vec-off: 10 tests, 0 failures
rewrote:
DROP TABLE IF EXISTS t;
CREATE TABLE t (x INT8 PRIMARY KEY, y INT8 NOT NULL, FAMILY (x, y));


        --- FAIL: TestLogic/fakedist-vec-off/schema_change_in_txn (35.12s)
=== RUN   TestLogic/fakedist-vec-off
    --- FAIL: TestLogic/fakedist-vec-off (0.64s)

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #47111 sql/logictest: TestLogic failed C-test-failure O-robot branch-release-20.1
sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3
sql/logictest: TestLogic failed #46268 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003181957_v20.1.0-beta.3

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

cockroach-teamcity · 2020-04-09T21:30:24Z

(sql/logictest).TestLogic failed on master@3ff65cdd9114ee427d744d6643347fd9311039f7:

=== RUN   TestLogic
--- FAIL: TestLogic (1056.27s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic159002991
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/distsql_automatic_stats
=== PAUSE TestLogic/fakedist/distsql_automatic_stats
=== CONT  TestLogic/fakedist/distsql_automatic_stats
        --- FAIL: TestLogic/fakedist/distsql_automatic_stats (48.70s)
            logic.go:1276: randomize batchSize to 1024
                
            logic.go:1846: condition failed to evaluate within 45s: 
                testdata/logic_test/distsql_automatic_stats:143: SELECT statistics_name, column_names, row_count, distinct_count, null_count
                FROM [SHOW STATISTICS FOR TABLE test_create] ORDER BY column_names::STRING, created
                expected:
                    statistics_name  column_names  row_count  distinct_count  null_count
                    __auto__         {x}           0          0               0
                    __auto__         {y}           0          0               0
                    
                but found (query options: "colnames,rowsort,retry" -> ignore the following ordering of rows) :
                    statistics_name  column_names  row_count  distinct_count  null_count
                    
                
                goroutine 2912866 [running]:
                runtime/debug.Stack(0xc02e5375f0, 0x42c6740, 0xc061f65b60)
                	/usr/local/go/src/runtime/debug/stack.go:24 +0x9d
                github.com/cockroachdb/cockroach/pkg/testutils.SucceedsSoon(0x43ad2a0, 0xc013199700, 0xc02e5375f0)
                	/go/src/github.com/cockroachdb/cockroach/pkg/testutils/soon.go:37 +0x6b
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).processSubtest(0xc02ad2e4e0, 0x0, 0x0, 0xc0208d04e0, 0x0, 0xc0008a65d0, 0x2b, 0x3b4d27a, 0x8, 0x3, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:1846 +0x1ea2
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).processTestFile(0xc02ad2e4e0, 0xc0008a65d0, 0x2b, 0x3b4d27a, 0x8, 0x3, 0x1, 0x3b43a5b, 0x2, 0x0, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:1405 +0x699
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).runFile(0xc02ad2e4e0, 0xc0008a65d0, 0x2b, 0x3b4d27a, 0x8, 0x3, 0x1, 0x3b43a5b, 0x2, 0x0, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:2423 +0x110
                github.com/cockroachdb/cockroach/pkg/sql/logictest.RunLogicTest.func1.1(0xc013199700)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:2560 +0x288
                testing.tRunner(0xc013199700, 0xc03840df80)
                	/usr/local/go/src/testing/testing.go:909 +0xc9
                created by testing.(*T).Run
                	/usr/local/go/src/testing/testing.go:960 +0x350
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.73s)

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3
sql/logictest: TestLogic failed #46268 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003181957_v20.1.0-beta.3

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

RaduBerinde · 2020-04-17T23:13:16Z

Some failures in here (but not all) are the same with #46268.

cockroach-teamcity · 2020-04-21T10:57:56Z

(sql/logictest).TestLogic failed on master@184391b0405e63d1f0b7211781c24d3a4b6db57d:

=== RUN   TestLogic
--- FAIL: TestLogic (1060.62s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic138781930
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/local/schema_change_in_txn/create_as_drop_and_create_in_txn
rewrote:
CREATE TABLE hood (item, quantity, FAMILY (item, quantity)) AS VALUES ('cups', 10), ('plates', 30), ('forks', 15);


            --- FAIL: TestLogic/local/schema_change_in_txn/create_as_drop_and_create_in_txn (11.41s)
                logic.go:2103: 
                    
                    testdata/logic_test/schema_change_in_txn:425: 
                    expected success, but found
                    (40001) restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): meta={id=986664b4 key=/Table/SystemConfigSpan/Start pri=0.01789997 epo=0 ts=1587465603.307192207,2 min=1587465595.096919901,0 seq=37} lock=true stat=PENDING rts=1587465595.096919901,0 wto=false max=1587465595.096919901,0
                logic.go:1415: 
                     pq: restart transaction: TransactionRetryWithProtoRefreshError: TransactionRetryError: retry txn (RETRY_SERIALIZABLE): meta={id=986664b4 key=/Table/SystemConfigSpan/Start pri=0.01789997 epo=0 ts=1587465603.307192207,2 min=1587465595.096919901,0 seq=37} lock=true stat=PENDING rts=1587465595.096919901,0 wto=false max=1587465595.096919901,0
=== RUN   TestLogic/local/schema_change_in_txn
=== PAUSE TestLogic/local/schema_change_in_txn
=== CONT  TestLogic/local/schema_change_in_txn
rewrote:
CREATE TABLE a (k INT8, v INT8, FAMILY (v, k));


        --- FAIL: TestLogic/local/schema_change_in_txn (14.26s)
=== RUN   TestLogic/local
    --- FAIL: TestLogic/local (0.23s)

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3
sql/logictest: TestLogic failed #46268 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003181957_v20.1.0-beta.3

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

cockroach-teamcity · 2020-05-13T15:26:18Z

(sql/logictest).TestLogic failed on master@c40343e7b9cb266d2fcc44f15eacf5998a1b38af:

=== RUN   TestLogic
--- FAIL: TestLogic (985.72s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic560633516
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/inner-join
=== PAUSE TestLogic/fakedist/inner-join
=== CONT  TestLogic/fakedist/inner-join
        --- FAIL: TestLogic/fakedist/inner-join (2.34s)
            logic.go:1881: 
                 
                testdata/logic_test/inner-join:69: SELECT a, b, c FROM abc_decimal WHERE EXISTS (SELECT * FROM def_decimal WHERE a::string=d::string)
                expected:
                    1     1     1
                    1     1     1
                    1.0   1.0   1.0
                    1.00  1.00  1.00
                but found (query options: "rowsort" -> ignore the following ordering of rows) :
                    1.00  1.00  1.00
                    
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.73s)

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3

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

cockroach-teamcity · 2020-05-13T16:42:42Z

(sql/logictest).TestLogic failed on master@845a170e82feb6bb5edb41523267d678f7706439:

=== RUN   TestLogic
--- FAIL: TestLogic (991.65s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic738356502
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
        --- FAIL: TestLogic/fakedist/join (3.27s)
            logic.go:1881: 
                 
                testdata/logic_test/join:435: SELECT a.x AS s, b.x, c.x, a.y, b.y, c.y FROM (twocolumn AS a JOIN twocolumn AS b USING(x) JOIN twocolumn AS c USING(x)) ORDER BY s
                expected:
                     s   x   x   y   y   y
                     42  42  42  53  53  53
                     44  44  44  51  51  51
                     45  45  45  45  45  45
                    
                but found (query options: "colnames") :
                    s   x   x   y   y   y
                    44  44  44  51  51  51
                    
            logic.go:2459: 
                testdata/logic_test/join:443: error while processing
            logic.go:2459: testdata/logic_test/join:443: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.80s)

More

Parameters:

GOFLAGS=-json

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

sql/logictest: TestLogic failed #46424 sql/logictest: TestLogic failed C-test-failure O-robot branch-provisional_202003231705_v20.1.0-beta.3

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

cockroach-teamcity · 2020-05-15T02:11:14Z

(sql/logictest).TestLogic failed on master@08107a4e30110ea95d41ce7989c061fd7c015adc:

rewrote:
DROP TABLE t;
CREATE TABLE t (x INT8 PRIMARY KEY, y INT8 NOT NULL, FAMILY (y), FAMILY (x));


rewrote:
CREATE TABLE pairs (id INT8 PRIMARY KEY, src INT8, dest STRING, UNIQUE (src, dest), FAMILY (id), FAMILY (dest), FAMILY (src));


rewrote:
CREATE TABLE multiple (a JSONB, b JSONB, FAMILY (b), FAMILY (a));


--- done: testdata/logic_test/json_builtins with config fakedist: 223 tests, 0 failures
rewrote:
CREATE TABLE foo (a INT8, b INT8, FAMILY (a), FAMILY (b));
INSERT INTO foo VALUES (0, 1), (0, 2), (1, 1);


rewrote:
CREATE TABLE refpairs (a INT8, b STRING, CONSTRAINT fk FOREIGN KEY (b) REFERENCES pairs, FAMILY (a, b));


rewrote:
CREATE TABLE refpairs (a INT8, b STRING, CONSTRAINT fk FOREIGN KEY (a, b) REFERENCES pairs, FAMILY (a, b));


rewrote:
CREATE TABLE refpairs_wrong_order (a INT8, b STRING, FOREIGN KEY (a, b) REFERENCES pairs (src, dest), INDEX (b, a), FAMILY (b), FAMILY (a));


rewrote:
CREATE TABLE bar (a INT8 PRIMARY KEY, c INT8, FAMILY (a, c));
INSERT INTO bar VALUES (0, 1), (1, 2), (2, 1);


        --- FAIL: TestLogic/fakedist/join (3.47s)
            logic.go:1952: 
                 
                testdata/logic_test/join:476: SELECT x FROM (onecolumn JOIN othercolumn USING (x)) JOIN (onecolumn AS a JOIN othercolumn AS b USING(x)) USING(x)
                expected:
                    42
                    
                but found (query options: "") :
                    
            logic.go:2530: 
                testdata/logic_test/join:481: error while processing
            logic.go:2530: testdata/logic_test/join:481: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.76s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-15T17:48:32Z

(sql/logictest).TestLogic failed on master@1bd006c3a9f90cc8072d941089a5ebecff051a3e:

=== RUN   TestLogic
--- FAIL: TestLogic (1811.14s)
    logic.go:2614: randomize batchSize to 3
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic113908125
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/inner-join
=== PAUSE TestLogic/fakedist/inner-join
=== CONT  TestLogic/fakedist/inner-join
        --- FAIL: TestLogic/fakedist/inner-join (1.04s)
            logic.go:1952: 
                 
                testdata/logic_test/inner-join:69: SELECT a, b, c FROM abc_decimal WHERE EXISTS (SELECT * FROM def_decimal WHERE a::string=d::string)
                expected:
                    1     1     1
                    1     1     1
                    1.0   1.0   1.0
                    1.00  1.00  1.00
                but found (query options: "rowsort" -> ignore the following ordering of rows) :
                    1  1  1
                    
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.41s)

More

Parameters:

TAGS=
GOFLAGS=-parallel=2

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

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

cockroach-teamcity · 2020-05-16T03:09:03Z

(sql/logictest).TestLogic failed on master@f6978468ec4968555ea27032e8bd183680171f55:

=== RUN   TestLogic
--- FAIL: TestLogic (1137.68s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic967174945
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/subquery_correlated
=== PAUSE TestLogic/fakedist/subquery_correlated
=== CONT  TestLogic/fakedist/subquery_correlated
rewrote:
CREATE TABLE f (a INT8, b INT8, c INT8, PRIMARY KEY (a, b, c), FAMILY (a), FAMILY (c, b));


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


rewrote:
CREATE TABLE test.dupe_generated (foo INT8 CHECK (foo > 1), bar INT8 CHECK (bar > 2), CHECK (foo > 2), CHECK (foo < 10), FAMILY (bar), FAMILY (foo));


        --- FAIL: TestLogic/fakedist/subquery_correlated (1.89s)
            logic.go:1952: 
                 
                testdata/logic_test/subquery_correlated:84: SELECT *
                FROM c
                WHERE
                    'CA' IN (SELECT ship FROM o WHERE o.c_id=c.c_id)
                    AND 'TX' NOT IN (SELECT ship FROM o WHERE o.c_id=c.c_id);
                expected:
                    1  CA
                    
                but found (query options: "rowsort" -> ignore the following ordering of rows) :
                    2  TX
                    1  CA
                    
            logic.go:2530: 
                testdata/logic_test/subquery_correlated:93: error while processing
            logic.go:2530: testdata/logic_test/subquery_correlated:93: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.68s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-16T04:58:34Z

(sql/logictest).TestLogic failed on master@5156843cc23adecb6a70fabf19f51f46de1241ec:

=== RUN   TestLogic
--- FAIL: TestLogic (1058.63s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic914928072
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/subquery_correlated
=== PAUSE TestLogic/fakedist/subquery_correlated
=== CONT  TestLogic/fakedist/subquery_correlated
--- progress: testdata/logic_test/fk_opt: 257 statements/queries
        --- FAIL: TestLogic/fakedist/subquery_correlated (1.88s)
            logic.go:1952: 
                 
                testdata/logic_test/subquery_correlated:84: SELECT *
                FROM c
                WHERE
                    'CA' IN (SELECT ship FROM o WHERE o.c_id=c.c_id)
                    AND 'TX' NOT IN (SELECT ship FROM o WHERE o.c_id=c.c_id);
                expected:
                    1  CA
                    
                but found (query options: "rowsort" -> ignore the following ordering of rows) :
                    
            logic.go:2530: 
                testdata/logic_test/subquery_correlated:93: error while processing
            logic.go:2530: testdata/logic_test/subquery_correlated:93: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.64s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-16T06:11:11Z

(sql/logictest).TestLogic failed on master@5156843cc23adecb6a70fabf19f51f46de1241ec:

=== RUN   TestLogic
--- FAIL: TestLogic (1696.51s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic562434446
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
        --- FAIL: TestLogic/fakedist/join (0.83s)
            logic.go:1952: 
                 
                testdata/logic_test/join:429: SELECT * FROM (twocolumn AS a JOIN twocolumn AS b USING(x) JOIN twocolumn AS c USING(x)) ORDER BY x LIMIT 1
                expected:
                    x  y  y  y
                    42 53 53 53
                    
                but found (query options: "colnames") :
                    x   y   y   y
                    44  51  51  51
                    
            logic.go:2530: 
                testdata/logic_test/join:435: error while processing
            logic.go:2530: testdata/logic_test/join:435: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.31s)

More

Parameters:

TAGS=
GOFLAGS=-parallel=2

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

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

cockroach-teamcity · 2020-05-16T08:11:34Z

(sql/logictest).TestLogic failed on master@d3177465b64491ed44fd86bd5d22cf5d521f9887:

=== RUN   TestLogic
--- FAIL: TestLogic (1155.25s)
    logic.go:2614: randomize batchSize to 1
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic116666159
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
        --- FAIL: TestLogic/fakedist/join (44.21s)
            logic.go:1952: 
                 
                testdata/logic_test/join:429: SELECT * FROM (twocolumn AS a JOIN twocolumn AS b USING(x) JOIN twocolumn AS c USING(x)) ORDER BY x LIMIT 1
                expected:
                    x  y  y  y
                    42 53 53 53
                    
                but found (query options: "colnames") :
                    x   y   y   y
                    44  51  51  51
                    
            logic.go:2530: 
                testdata/logic_test/join:435: error while processing
            logic.go:2530: testdata/logic_test/join:435: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.53s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-16T10:45:47Z

(sql/logictest).TestLogic failed on master@d3177465b64491ed44fd86bd5d22cf5d521f9887:

=== RUN   TestLogic
--- FAIL: TestLogic (1015.67s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic791688330
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
        --- FAIL: TestLogic/fakedist/join (3.96s)
            logic.go:1952: 
                 
                testdata/logic_test/join:435: SELECT a.x AS s, b.x, c.x, a.y, b.y, c.y FROM (twocolumn AS a JOIN twocolumn AS b USING(x) JOIN twocolumn AS c USING(x)) ORDER BY s
                expected:
                     s   x   x   y   y   y
                     42  42  42  53  53  53
                     44  44  44  51  51  51
                     45  45  45  45  45  45
                    
                but found (query options: "colnames") :
                    s   x   x   y   y   y
                    42  42  42  53  53  53
                    44  44  44  51  51  51
                    
            logic.go:2530: 
                testdata/logic_test/join:443: error while processing
            logic.go:2530: testdata/logic_test/join:443: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.64s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-16T18:53:23Z

(sql/logictest).TestLogic failed on master@29239a4f760385a8417cd67d4759bad606ea3997:



--- progress: testdata/logic_test/interleaved: 15 statements/queries
rewrote:
CREATE TABLE del_cascade_test (delete_cascade INT8 NOT NULL REFERENCES update_test ON DELETE CASCADE, j JSONB, INVERTED INDEX (j), FAMILY (j, delete_cascade));


rewrote:
CREATE TABLE kv2 (k CHAR, v CHAR, CONSTRAINT a UNIQUE (v), PRIMARY KEY (k, v), FAMILY (v, k));


--- progress: testdata/logic_test/interleaved_join: 34 statements/queries
rewrote:
CREATE TABLE a (a STRING, b STRING, PRIMARY KEY (a, b), FAMILY (b, a));


rewrote:
CREATE TABLE b (a STRING, b STRING, PRIMARY KEY (a, b), FAMILY (b, a)) INTERLEAVE IN PARENT a (a, b);


rewrote:
CREATE TABLE update_cascade_test (update_cascade INT8 NOT NULL REFERENCES update_test ON UPDATE CASCADE, j JSONB, INVERTED INDEX (j), FAMILY (update_cascade, j));


rewrote:
CREATE TABLE kv3 (k CHAR PRIMARY KEY, v CHAR NOT NULL, FAMILY (k, v));


rewrote:
CREATE TABLE kv4 ("int" INT8 PRIMARY KEY, "bit" BIT, bool BOOL, "char" CHAR, "float" FLOAT8, FAMILY ("float", "bit"), FAMILY ("int", "char", bool));


--- progress: testdata/logic_test/lookup_join: 67 statements/queries
--- progress: testdata/logic_test/inverted_index: 141 statements/queries
        --- FAIL: TestLogic/fakedist/inner-join (3.36s)
            logic.go:1952: 
                 
                testdata/logic_test/inner-join:69: SELECT a, b, c FROM abc_decimal WHERE EXISTS (SELECT * FROM def_decimal WHERE a::string=d::string)
                expected:
                    1     1     1
                    1     1     1
                    1.0   1.0   1.0
                    1.00  1.00  1.00
                but found (query options: "rowsort" -> ignore the following ordering of rows) :
                    1.00  1.00  1.00
                    1     1     1
                    1.0   1.0   1.0
                    
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.94s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-17T05:50:18Z

(sql/logictest).TestLogic failed on master@2cbf620cd229a55622fe17fb15d20ada1dbcccd3:

=== RUN   TestLogic/fakedist/interleaved_join/regression_42609
rewrote:
CREATE TABLE parent (a STRING, b STRING, extraparent STRING, PRIMARY KEY (a, b), FAMILY (extraparent), FAMILY (a), FAMILY (b));


rewrote:
CREATE TABLE child (a STRING, b STRING, c STRING, extra STRING, PRIMARY KEY (a, b, c), FAMILY (a, c, extra, b)) INTERLEAVE IN PARENT parent (a, b);


--- progress: testdata/logic_test/join: 94 statements/queries
--- done: testdata/logic_test/interleaved_join with config fakedist: 61 tests, 0 failures
--- total progress: 46395 statements/queries

More

Parameters:

TAGS=
GOFLAGS=-parallel=2

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

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

cockroach-teamcity · 2020-05-17T20:23:29Z

(sql/logictest).TestLogic failed on master@7ab7fb86f0634df1f5a0b04460e1f3a1d6bead1f:

=== RUN   TestLogic
--- FAIL: TestLogic (1109.89s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic278566046
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/inner-join
=== PAUSE TestLogic/fakedist/inner-join
=== CONT  TestLogic/fakedist/inner-join
rewrote:
CREATE TABLE u (a INT8 PRIMARY KEY, b TIMESTAMP, c TIMESTAMPTZ, d DATE, e INTERVAL, FAMILY (c, e, b, a), FAMILY (d));


rewrote:
CREATE TABLE t (d DECIMAL, v DECIMAL(3,1), FAMILY (v), FAMILY (d));


rewrote:
CREATE TABLE t2 (d DECIMAL, v DECIMAL(3,1), PRIMARY KEY (d, v), FAMILY (v), FAMILY (d));


rewrote:
CREATE TABLE level3 (k1 INT8, k2 INT8, k3 INT8, PRIMARY KEY (k1, k2, k3), CONSTRAINT fk2 FOREIGN KEY (k1) REFERENCES level2, FAMILY (k3, k1, k2)) INTERLEAVE IN PARENT level2 (k1);


--- progress: testdata/logic_test/truncate: 36 statements/queries
        --- FAIL: TestLogic/fakedist/inner-join (2.29s)
            logic.go:1952: 
                 
                testdata/logic_test/inner-join:69: SELECT a, b, c FROM abc_decimal WHERE EXISTS (SELECT * FROM def_decimal WHERE a::string=d::string)
                expected:
                    1     1     1
                    1     1     1
                    1.0   1.0   1.0
                    1.00  1.00  1.00
                but found (query options: "rowsort" -> ignore the following ordering of rows) :
                    1    1    1
                    1.0  1.0  1.0
                    
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.78s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-18T14:52:07Z

(sql/logictest).TestLogic failed on master@c21c3ca033165fcdb0f264dfee431a5db30bbb07:

=== RUN   TestLogic
--- FAIL: TestLogic (1104.85s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic994606714
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
rewrote:
CREATE TABLE t_47283 (k INT8 PRIMARY KEY, a INT8, FAMILY (a, k));


        --- FAIL: TestLogic/fakedist/join (3.63s)
            logic.go:1952: 
                 
                testdata/logic_test/join:429: SELECT * FROM (twocolumn AS a JOIN twocolumn AS b USING(x) JOIN twocolumn AS c USING(x)) ORDER BY x LIMIT 1
                expected:
                    x  y  y  y
                    42 53 53 53
                    
                but found (query options: "colnames") :
                    x   y   y   y
                    44  51  51  51
                    
            logic.go:2530: 
                testdata/logic_test/join:435: error while processing
            logic.go:2530: testdata/logic_test/join:435: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.63s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-18T17:07:43Z

(sql/logictest).TestLogic failed on master@313424e06b365f1f237107db7a39a86208192556:

=== RUN   TestLogic
--- FAIL: TestLogic (1114.82s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic379981358
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
rewrote:
CREATE TABLE users (id INT8 NOT NULL DEFAULT unique_rowid(), name VARCHAR(50), PRIMARY KEY (id), FAMILY (id, name));
INSERT INTO users(id, name) VALUES (1, 'user1');
INSERT INTO users(id, name) VALUES (2, 'user2');
INSERT INTO users(id, name) VALUES (3, 'user3');


rewrote:
CREATE TABLE stuff (id INT8 NOT NULL DEFAULT unique_rowid(), date DATE, user_id INT8, PRIMARY KEY (id), FOREIGN KEY (user_id) REFERENCES users (id), FAMILY (user_id, id), FAMILY (date));
INSERT INTO stuff(id, date, user_id) VALUES (1, '2007-10-15'::DATE, 1);
INSERT INTO stuff(id, date, user_id) VALUES (2, '2007-12-15'::DATE, 1);
INSERT INTO stuff(id, date, user_id) VALUES (3, '2007-11-15'::DATE, 1);
INSERT INTO stuff(id, date, user_id) VALUES (4, '2008-01-15'::DATE, 2);
INSERT INTO stuff(id, date, user_id) VALUES (5, '2007-06-15'::DATE, 3);
INSERT INTO stuff(id, date, user_id) VALUES (6, '2007-03-15'::DATE, 3);


        --- FAIL: TestLogic/fakedist/join (4.17s)
            logic.go:1952: 
                 
                testdata/logic_test/join:435: SELECT a.x AS s, b.x, c.x, a.y, b.y, c.y FROM (twocolumn AS a JOIN twocolumn AS b USING(x) JOIN twocolumn AS c USING(x)) ORDER BY s
                expected:
                     s   x   x   y   y   y
                     42  42  42  53  53  53
                     44  44  44  51  51  51
                     45  45  45  45  45  45
                    
                but found (query options: "colnames") :
                    s   x   x   y   y   y
                    42  42  42  53  53  53
                    44  44  44  51  51  51
                    
            logic.go:2530: 
                testdata/logic_test/join:443: error while processing
            logic.go:2530: testdata/logic_test/join:443: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.71s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-18T18:53:29Z

(sql/logictest).TestLogic failed on master@eeefaad881419035a6a05ef25c2d839c410fb10a:

=== RUN   TestLogic
--- FAIL: TestLogic (1128.56s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic500393617
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
--- progress: testdata/logic_test/schema_change_in_txn: 379 statements/queries
        --- FAIL: TestLogic/fakedist/join (3.15s)
            logic.go:1952: 
                 
                testdata/logic_test/join:435: SELECT a.x AS s, b.x, c.x, a.y, b.y, c.y FROM (twocolumn AS a JOIN twocolumn AS b USING(x) JOIN twocolumn AS c USING(x)) ORDER BY s
                expected:
                     s   x   x   y   y   y
                     42  42  42  53  53  53
                     44  44  44  51  51  51
                     45  45  45  45  45  45
                    
                but found (query options: "colnames") :
                    s   x   x   y   y   y
                    44  44  44  51  51  51
                    45  45  45  45  45  45
                    
            logic.go:2530: 
                testdata/logic_test/join:443: error while processing
            logic.go:2530: testdata/logic_test/join:443: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.77s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-18T22:55:25Z

(sql/logictest).TestLogic failed on master@f575fa85475311b9482f434bdd0220b6fccf6032:

=== RUN   TestLogic
--- FAIL: TestLogic (1267.98s)
    logic.go:2614: randomize batchSize to 1
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic480030881
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
rewrote:
CREATE TABLE family_interleave_2 (x INT8, y INT8, PRIMARY KEY (x, y), FAMILY (y, x)) INTERLEAVE IN PARENT family_interleave_1 (x);


--- done: testdata/logic_test/lookup_join with config fakedist: 99 tests, 0 failures
rewrote:
DROP TABLE IF EXISTS t;
CREATE TABLE t (x INT8 PRIMARY KEY, y INT8 NOT NULL, FAMILY (x, y));


--- done: testdata/logic_test/show_create with config fakedist: 5 tests, 0 failures
--- done: testdata/logic_test/alias_types with config fakedist: 10 tests, 0 failures
rewrote:
DROP TABLE IF EXISTS t;
CREATE TABLE t (x INT8 PRIMARY KEY, y INT8 NOT NULL, FAMILY (y), FAMILY (x));


        --- FAIL: TestLogic/fakedist/join (17.38s)
            logic.go:1952: 
                 
                testdata/logic_test/join:402: SELECT * FROM (onecolumn CROSS JOIN twocolumn JOIN onecolumn AS a(b) ON a.b=twocolumn.x JOIN twocolumn AS c(d,e) ON a.b=c.d AND c.d=onecolumn.x) ORDER BY 1 LIMIT 1
                expected:
                    x  x  y  b  d  e
                    42 42 53 42 42 53
                    
                but found (query options: "colnames") :
                    x   x   y   b   d   e
                    44  44  51  44  44  51
                    
            logic.go:2530: 
                testdata/logic_test/join:408: error while processing
            logic.go:2530: testdata/logic_test/join:408: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.65s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-19T00:34:19Z

(sql/logictest).TestLogic failed on master@91ee79ff3b7bdb3453be249761898d590df715b6:

=== RUN   TestLogic
--- FAIL: TestLogic (1136.95s)
    logic.go:2614: randomize batchSize to 2
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic586486896
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/inner-join
=== PAUSE TestLogic/fakedist/inner-join
=== CONT  TestLogic/fakedist/inner-join
rewrote:
CREATE TABLE kv2 (k CHAR, v CHAR, CONSTRAINT a UNIQUE (v), PRIMARY KEY (k, v), FAMILY (v), FAMILY (k));


rewrote:
CREATE TABLE kv3 (k CHAR PRIMARY KEY, v CHAR NOT NULL, FAMILY (k, v));


rewrote:
CREATE TABLE small_parent_fam (a STRING, b STRING, c STRING, PRIMARY KEY (a, b), FAMILY (a), FAMILY (c), FAMILY (b));
INSERT INTO small_parent_fam VALUES ('first', 'second', 'third');


rewrote:
CREATE TABLE kv4 ("int" INT8 PRIMARY KEY, "bit" BIT, bool BOOL, "char" CHAR, "float" FLOAT8, FAMILY (bool), FAMILY ("int", "float"), FAMILY ("char", "bit"));


--- done: testdata/logic_test/int_size with config fakedist: 32 tests, 0 failures
        --- FAIL: TestLogic/fakedist/inner-join (3.34s)
            logic.go:1952: 
                 
                testdata/logic_test/inner-join:69: SELECT a, b, c FROM abc_decimal WHERE EXISTS (SELECT * FROM def_decimal WHERE a::string=d::string)
                expected:
                    1     1     1
                    1     1     1
                    1.0   1.0   1.0
                    1.00  1.00  1.00
                but found (query options: "rowsort" -> ignore the following ordering of rows) :
                    1.00  1.00  1.00
                    
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.89s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-19T06:21:36Z

(sql/logictest).TestLogic failed on master@73631089c58554c289d0fb1b26cad62667388335:

=== RUN   TestLogic
--- FAIL: TestLogic (1131.40s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic901048162
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/join
=== PAUSE TestLogic/fakedist/join
=== CONT  TestLogic/fakedist/join
rewrote:
CREATE TABLE def (d INT8, e INT8, f INT8, PRIMARY KEY (f, e), FAMILY (e), FAMILY (f, d));
INSERT INTO def VALUES (1, 1, 2), (2, 1, 1), (NULL, 2, 1);


rewrote:
CREATE TABLE gh (g INT8, h INT8, INDEX g_idx (g), FAMILY (g), FAMILY (h));
INSERT INTO gh VALUES (NULL, 1);


        --- FAIL: TestLogic/fakedist/join (3.54s)
            logic.go:1952: 
                 
                testdata/logic_test/join:435: SELECT a.x AS s, b.x, c.x, a.y, b.y, c.y FROM (twocolumn AS a JOIN twocolumn AS b USING(x) JOIN twocolumn AS c USING(x)) ORDER BY s
                expected:
                     s   x   x   y   y   y
                     42  42  42  53  53  53
                     44  44  44  51  51  51
                     45  45  45  45  45  45
                    
                but found (query options: "colnames") :
                    s   x   x   y   y   y
                    44  44  44  51  51  51
                    
            logic.go:2530: 
                testdata/logic_test/join:443: error while processing
            logic.go:2530: testdata/logic_test/join:443: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.65s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-19T18:05:32Z

(sql/logictest).TestLogic failed on master@2235a757f07ccac74bf01e1a527148fedfea6af5:

=== RUN   TestLogic
--- FAIL: TestLogic (1032.82s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic780975791
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/local/set
=== PAUSE TestLogic/local/set
=== CONT  TestLogic/local/set
--- done: testdata/logic_test/shift with config local: 12 tests, 0 failures
        --- FAIL: TestLogic/local/set (1.38s)
            logic.go:2197: 
                
                testdata/logic_test/set:288: SHOW statement_timeout
                expected success, but found
                (57014) query execution canceled due to statement timeout
                errors.go:192: in init()
            logic.go:1952: 
                 pq: query execution canceled due to statement timeout
            logic.go:2530: 
                testdata/logic_test/set:293: error while processing
            logic.go:2530: testdata/logic_test/set:293: too many errors encountered, skipping the rest of the input
=== RUN   TestLogic/local
    --- FAIL: TestLogic/local (0.52s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-20T03:40:11Z

(sql/logictest).TestLogic failed on master@ed273c544465773560a0f44e18e6458d0fbc7850:

=== RUN   TestLogic
--- FAIL: TestLogic (1125.96s)
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic560681277
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist/distsql_automatic_stats
=== PAUSE TestLogic/fakedist/distsql_automatic_stats
=== CONT  TestLogic/fakedist/distsql_automatic_stats
        --- FAIL: TestLogic/fakedist/distsql_automatic_stats (49.90s)
            logic.go:1947: condition failed to evaluate within 45s: 
                testdata/logic_test/distsql_automatic_stats:200: SELECT statistics_name, column_names, row_count, null_count
                FROM [SHOW STATISTICS FOR TABLE et] WHERE histogram_id IS NOT NULL
                ORDER BY column_names::STRING, created
                expected:
                    statistics_name  column_names  row_count  null_count
                    __auto__         {x}           3          0
                    __auto__         {y}           3          0
                but found (query options: "colnames,rowsort,retry" -> ignore the following ordering of rows) :
                    statistics_name  column_names  row_count  null_count
                    __auto__         {x}           3          0
                    __auto__         {x}           3          0
                    __auto__         {y}           3          0
                    __auto__         {y}           3          0
                    
                goroutine 2986754 [running]:
                runtime/debug.Stack(0xc05a195420, 0x447ee80, 0xc037e741a0)
                	/usr/local/go/src/runtime/debug/stack.go:24 +0x9d
                github.com/cockroachdb/cockroach/pkg/testutils.SucceedsSoon(0x4572d20, 0xc026973100, 0xc05a195420)
                	/go/src/github.com/cockroachdb/cockroach/pkg/testutils/soon.go:36 +0x6b
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).processSubtest(0xc06a9e0000, 0x0, 0x0, 0xc0486376e0, 0x0, 0xc0005ea6c0, 0x2b, 0x3ca2a21, 0x8, 0x3, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:1947 +0x1e0b
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).processTestFile(0xc06a9e0000, 0xc0005ea6c0, 0x2b, 0x3ca2a21, 0x8, 0x3, 0x1, 0x3c98d08, 0x2, 0x0, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:1506 +0x699
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).runFile(0xc06a9e0000, 0xc0005ea6c0, 0x2b, 0x3ca2a21, 0x8, 0x3, 0x1, 0x3c98d08, 0x2, 0x0, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:2536 +0x110
                github.com/cockroachdb/cockroach/pkg/sql/logictest.RunLogicTest.func1.1(0xc026973100)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:2685 +0x2a4
                testing.tRunner(0xc026973100, 0xc03f8121c0)
                	/usr/local/go/src/testing/testing.go:909 +0xc9
                created by testing.(*T).Run
                	/usr/local/go/src/testing/testing.go:960 +0x350
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.68s)

More

Parameters:

GOFLAGS=-json

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

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

cockroach-teamcity · 2020-05-20T07:32:36Z

(sql/logictest).TestLogic failed on master@8fec3f4c6d136a86f472c975edd36b75e5ab9a8c:

=== RUN   TestLogic
--- FAIL: TestLogic (1402.87s)
    logic.go:2630: randomize batchSize to 1
    test_log_scope.go:77: test logs captured to: /tmp/logTestLogic346900679
    test_log_scope.go:58: use -show-logs to present logs inline
=== RUN   TestLogic/fakedist
    --- FAIL: TestLogic/fakedist (0.68s)
=== RUN   TestLogic/fakedist/distsql_automatic_stats
=== PAUSE TestLogic/fakedist/distsql_automatic_stats
=== CONT  TestLogic/fakedist/distsql_automatic_stats
--- progress: testdata/logic_test/fk_opt: 123 statements/queries
        --- FAIL: TestLogic/fakedist/distsql_automatic_stats (51.78s)
            logic.go:1947: condition failed to evaluate within 45s: 
                testdata/logic_test/distsql_automatic_stats:200: SELECT statistics_name, column_names, row_count, null_count
                FROM [SHOW STATISTICS FOR TABLE et] WHERE histogram_id IS NOT NULL
                ORDER BY column_names::STRING, created
                expected:
                    statistics_name  column_names  row_count  null_count
                    __auto__         {x}           3          0
                    __auto__         {y}           3          0
                but found (query options: "colnames,rowsort,retry" -> ignore the following ordering of rows) :
                    statistics_name  column_names  row_count  null_count
                    __auto__         {x}           3          0
                    __auto__         {x}           3          0
                    __auto__         {y}           3          0
                    __auto__         {y}           3          0
                    
                goroutine 2997512 [running]:
                runtime/debug.Stack(0xc003541420, 0x4482580, 0xc09bf13760)
                	/usr/local/go/src/runtime/debug/stack.go:24 +0x9d
                github.com/cockroachdb/cockroach/pkg/testutils.SucceedsSoon(0x4576580, 0xc009c1b800, 0xc003541420)
                	/go/src/github.com/cockroachdb/cockroach/pkg/testutils/soon.go:36 +0x6b
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).processSubtest(0xc058cfdc00, 0x0, 0x0, 0xc01e461ad0, 0x0, 0xc00056a4e0, 0x2b, 0x3ca4a01, 0x8, 0x3, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:1947 +0x1e0b
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).processTestFile(0xc058cfdc00, 0xc00056a4e0, 0x2b, 0x3ca4a01, 0x8, 0x3, 0x1, 0x3c9ace8, 0x2, 0x0, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:1506 +0x699
                github.com/cockroachdb/cockroach/pkg/sql/logictest.(*logicTest).runFile(0xc058cfdc00, 0xc00056a4e0, 0x2b, 0x3ca4a01, 0x8, 0x3, 0x1, 0x3c9ace8, 0x2, 0x0, ...)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:2536 +0x110
                github.com/cockroachdb/cockroach/pkg/sql/logictest.RunLogicTest.func1.1(0xc009c1b800)
                	/go/src/github.com/cockroachdb/cockroach/pkg/sql/logictest/logic.go:2685 +0x2a4
                testing.tRunner(0xc009c1b800, 0xc007030940)
                	/usr/local/go/src/testing/testing.go:909 +0xc9
                created by testing.(*T).Run
                	/usr/local/go/src/testing/testing.go:960 +0x350

More

Parameters:

GOFLAGS=-json

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

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

yuzefovich · 2020-05-20T18:35:30Z

cc @rohany distsql_automatic_stats logic test is flaking on enums (I've hit it twice on CI builds, e.g. https://teamcity.cockroachdb.com/viewLog.html?buildId=1957061&buildTypeId=Cockroach_UnitTests)

rohany · 2020-05-20T18:58:53Z

Yup, I just landed a fix for this.

yuzefovich · 2020-05-20T19:53:37Z

I'm going to close this issue since it's "polluted" with different failures (most - and maybe all - of which have been addressed).

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 Mar 29, 2020

cockroach-teamcity added this to the 20.1 milestone Mar 29, 2020

cockroach-teamcity assigned jordanlewis Mar 29, 2020

cockroach-teamcity mentioned this issue Apr 7, 2020

sql/logictest: TestLogic failed #47111

Closed

ajwerner mentioned this issue Apr 8, 2020

kvserver,roachtest/hotspotsplits: adjust constants to ensure backpressure #47164

Merged

yuzefovich closed this as completed May 20, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

sql/logictest: TestLogic failed #46713

sql/logictest: TestLogic failed #46713

cockroach-teamcity commented Mar 29, 2020

cockroach-teamcity commented Apr 3, 2020

cockroach-teamcity commented Apr 3, 2020

cockroach-teamcity commented Apr 6, 2020

cockroach-teamcity commented Apr 7, 2020

cockroach-teamcity commented Apr 9, 2020

RaduBerinde commented Apr 17, 2020

cockroach-teamcity commented Apr 21, 2020

cockroach-teamcity commented May 13, 2020

cockroach-teamcity commented May 13, 2020

cockroach-teamcity commented May 15, 2020

cockroach-teamcity commented May 15, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 17, 2020

cockroach-teamcity commented May 17, 2020

cockroach-teamcity commented May 18, 2020

cockroach-teamcity commented May 18, 2020

cockroach-teamcity commented May 18, 2020

cockroach-teamcity commented May 18, 2020

cockroach-teamcity commented May 19, 2020

cockroach-teamcity commented May 19, 2020

cockroach-teamcity commented May 19, 2020

cockroach-teamcity commented May 20, 2020

cockroach-teamcity commented May 20, 2020

yuzefovich commented May 20, 2020 •

edited

Loading

rohany commented May 20, 2020

yuzefovich commented May 20, 2020

sql/logictest: TestLogic failed #46713

sql/logictest: TestLogic failed #46713

Comments

cockroach-teamcity commented Mar 29, 2020

cockroach-teamcity commented Apr 3, 2020

cockroach-teamcity commented Apr 3, 2020

cockroach-teamcity commented Apr 6, 2020

cockroach-teamcity commented Apr 7, 2020

cockroach-teamcity commented Apr 9, 2020

RaduBerinde commented Apr 17, 2020

cockroach-teamcity commented Apr 21, 2020

cockroach-teamcity commented May 13, 2020

cockroach-teamcity commented May 13, 2020

cockroach-teamcity commented May 15, 2020

cockroach-teamcity commented May 15, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 16, 2020

cockroach-teamcity commented May 17, 2020

cockroach-teamcity commented May 17, 2020

cockroach-teamcity commented May 18, 2020

cockroach-teamcity commented May 18, 2020

cockroach-teamcity commented May 18, 2020

cockroach-teamcity commented May 18, 2020

cockroach-teamcity commented May 19, 2020

cockroach-teamcity commented May 19, 2020

cockroach-teamcity commented May 19, 2020

cockroach-teamcity commented May 20, 2020

cockroach-teamcity commented May 20, 2020

yuzefovich commented May 20, 2020 • edited Loading

rohany commented May 20, 2020

yuzefovich commented May 20, 2020

yuzefovich commented May 20, 2020 •

edited

Loading