cockroach
cockroach copied to clipboard
compose: TestComposeCompare failed
compose.TestComposeCompare failed with artifacts on release-21.2 @ 8fdbf4dacfdf3c2032937fe5359255f3dc13c61a:
postgres_1 | AS tab_33492
postgres_1 | ORDER BY
postgres_1 | col_59994 NULLS FIRST, col_59995 NULLS FIRST, col_59996 NULLS FIRST, col_59997 NULLS FIRST, col_59998 NULLS FIRST
test_1 | --- FAIL: TestCompare (658.61s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (56.01s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:183: compare cockroach1 to postgres:
test_1 | unexpected diff:
test_1 | []interface{}(Inverse(func1, []interface{}{
test_1 | pgtype.Numeric{
test_1 | - Int: s"17320508075688772935",
test_1 | + Int: s"1732050807568877",
test_1 | - Exp: -19,
test_1 | + Exp: -15,
test_1 | Status: 2,
test_1 | NaN: false,
test_1 | },
test_1 | }))
test_1 | cockroach1:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT sqrt(3:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL AS col_60044) AS tab_33521
test_1 | ORDER BY
test_1 | col_60044 NULLS FIRST;
test_1 |
test_1 | postgres:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT sqrt(3::DECIMAL::DECIMAL::DECIMAL)::DECIMAL AS col_60044) AS tab_33521
test_1 | ORDER BY
test_1 | col_60044 NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
This test on roachdash | Improve this report!
Jira issue: CRDB-11579
compose.TestComposeCompare failed with artifacts on release-21.2 @ de4cc9bf7f6719ef198958de984ab861ca02a8c5:
postgres_1 | col_46382 NULLS FIRST,
postgres_1 | col_46383 NULLS FIRST,
postgres_1 | col_46384 NULLS FIRST
test_1 | --- FAIL: TestCompare (636.17s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (32.82s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:183: compare cockroach1 to postgres:
test_1 | unexpected diff:
test_1 | []interface{}(Inverse(func1, []interface{}{
test_1 | pgtype.Numeric{
test_1 | - Int: s"22360679774997896964",
test_1 | + Int: s"2236067977499790",
test_1 | - Exp: -19,
test_1 | + Exp: -15,
test_1 | Status: 2,
test_1 | NaN: false,
test_1 | },
test_1 | }))
test_1 | postgres:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT sqrt(5::DECIMAL::DECIMAL::DECIMAL)::DECIMAL AS col_46397) AS tab_24404
test_1 | ORDER BY
test_1 | col_46397 NULLS FIRST;
test_1 |
test_1 | cockroach1:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT sqrt(5:::DECIMAL::DECIMAL::DECIMAL)::DECIMAL AS col_46397) AS tab_24404
test_1 | ORDER BY
test_1 | col_46397 NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 8343f0aed1a685b7a90ea37b10bd3e0ed85e654e:
test_1 | --- FAIL: TestCompare (624.30s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (21.48s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:183: compare postgres to cockroach1:
test_1 | unexpected diff:
test_1 | []interface{}(Inverse(func1, []interface{}{
test_1 | pgtype.Numeric{
test_1 | - Int: s"100776960000000000000000",
test_1 | + Int: s"10077696",
test_1 | - Exp: -16,
test_1 | + Exp: 0,
test_1 | Status: 2,
test_1 | NaN: false,
test_1 | },
test_1 | nil,
test_1 | }))
test_1 | postgres:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT (6::DECIMAL::DECIMAL::DECIMAL ^ 9::INT8::INT8::INT8)::DECIMAL AS col_20591, NULL::rand_typ_3 AS col_20592)
test_1 | AS tab_15422
test_1 | ORDER BY
test_1 | col_20591 NULLS FIRST, col_20592 NULLS FIRST;
test_1 |
test_1 | cockroach1:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT (6:::DECIMAL::DECIMAL::DECIMAL ^ 9:::INT8::INT8::INT8)::DECIMAL AS col_20591, NULL::rand_typ_3 AS col_20592)
test_1 | AS tab_15422
test_1 | ORDER BY
test_1 | col_20591 NULLS FIRST, col_20592 NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 5c388180155f306a1685ac88bfbeeb03785313dd:
test_1 |
test_1 | goroutine 25 [running]:
test_1 | testing.tRunner.func1.2(0x1ee3e00, 0x4055dd0)
test_1 | /usr/local/go/src/testing/testing.go:1143 +0x332
test_1 | testing.tRunner.func1(0xc000d02180)
test_1 | /usr/local/go/src/testing/testing.go:1146 +0x4b6
test_1 | panic(0x1ee3e00, 0x4055dd0)
test_1 | /usr/local/go/src/runtime/panic.go:965 +0x1b9
test_1 | math/big.(*Int).Set(...)
test_1 | /usr/local/go/src/math/big/int.go:75
test_1 | github.com/cockroachdb/apd/v2.NewWithBigInt(0x0, 0x0, 0x1)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/v2/decimal.go:95 +0x58
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.glob..func1(0xc000414290, 0x1, 0x1, 0x0, 0x0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:118 +0x29e
test_1 | reflect.Value.call(0x1e7b7e0, 0x26b1208, 0x13, 0x214629f, 0x4, 0xc000fd5028, 0x1, 0x1, 0xc000fd4f68, 0x43170b, ...)
test_1 | /usr/local/go/src/reflect/value.go:476 +0x8e7
test_1 | reflect.Value.Call(0x1e7b7e0, 0x26b1208, 0x13, 0xc000fd5028, 0x1, 0x1, 0xc00000f710, 0x1, 0x1)
test_1 | /usr/local/go/src/reflect/value.go:337 +0xb9
test_1 | github.com/google/go-cmp/cmp.(*state).callTRFunc(0xc00028bd60, 0x1e7b7e0, 0x26b1208, 0x13, 0x1e3c760, 0xc00000f698, 0x97, 0xc0004f94a0, 0x0, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:333 +0x265
test_1 | github.com/google/go-cmp/cmp.(*transformer).apply(0xc00052d500, 0xc00028bd60, 0x1e3c760, 0xc00000f698, 0x97, 0x1e3c760, 0xc00000f6b0, 0x97)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/options.go:320 +0x12c
test_1 | github.com/google/go-cmp/cmp.(*state).tryOptions(0xc00028bd60, 0x31bd258, 0x1e3c760, 0x1e3c760, 0xc00000f698, 0x97, 0x1e3c760, 0xc00000f6b0, 0x97, 0x7f9f093204a0)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:303 +0x132
test_1 | github.com/google/go-cmp/cmp.(*state).compareAny(0xc00028bd60, 0x30d88d0, 0xc00035cfc0)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:258 +0x2f2
test_1 | github.com/google/go-cmp/cmp.Diff(0x1e3c760, 0xc00000f698, 0x1e3c760, 0xc00000f6b0, 0x438eb00, 0x7, 0x7, 0x6436805b8fa97d0d, 0x30d8c30)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:119 +0xab
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareVals(0xc000414290, 0x1, 0x1, 0xc0004142b0, 0x1, 0x1, 0x1, 0x20)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:39 +0xed
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.compareRows(0xc000fd5880, 0xc000fd5801, 0x2150c8b, 0xa, 0xc000fd5ab8)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:251 +0x225
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareConns(0x30e1390, 0xc000d9aae0, 0x6fc23ac00, 0xc000fd5da0, 0x0, 0x0, 0xc000c37c00, 0x2aa, 0x1, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:213 +0x571
test_1 | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000d02180)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:176 +0xabe
test_1 | testing.tRunner(0xc000d02180, 0xc000c7c660)
test_1 | /usr/local/go/src/testing/testing.go:1193 +0xef
test_1 | created by testing.(*T).Run
test_1 | /usr/local/go/src/testing/testing.go:1238 +0x2b3
compare_test_1 exited with code 2
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 2
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 81d49bd3d2e8ee3da4a5800043b94aa174127ab7:
test_1 |
test_1 | goroutine 130033 [running]:
test_1 | testing.tRunner.func1.2(0x1ee3e60, 0x4055dd0)
test_1 | /usr/local/go/src/testing/testing.go:1143 +0x332
test_1 | testing.tRunner.func1(0xc000c28c00)
test_1 | /usr/local/go/src/testing/testing.go:1146 +0x4b6
test_1 | panic(0x1ee3e60, 0x4055dd0)
test_1 | /usr/local/go/src/runtime/panic.go:965 +0x1b9
test_1 | math/big.(*Int).Set(...)
test_1 | /usr/local/go/src/math/big/int.go:75
test_1 | github.com/cockroachdb/apd/v2.NewWithBigInt(0x0, 0x0, 0x1)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/v2/decimal.go:95 +0x58
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.glob..func1(0xc00044fa50, 0x1, 0x1, 0x0, 0x0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:118 +0x29e
test_1 | reflect.Value.call(0x1e7b840, 0x26b1298, 0x13, 0x21462ff, 0x4, 0xc001029028, 0x1, 0x1, 0xc001028f68, 0x43170b, ...)
test_1 | /usr/local/go/src/reflect/value.go:476 +0x8e7
test_1 | reflect.Value.Call(0x1e7b840, 0x26b1298, 0x13, 0xc001029028, 0x1, 0x1, 0xc000696708, 0x1, 0x1)
test_1 | /usr/local/go/src/reflect/value.go:337 +0xb9
test_1 | github.com/google/go-cmp/cmp.(*state).callTRFunc(0xc000286d20, 0x1e7b840, 0x26b1298, 0x13, 0x1e3c7c0, 0xc000696690, 0x97, 0xc000c4f860, 0x0, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:333 +0x265
test_1 | github.com/google/go-cmp/cmp.(*transformer).apply(0xc000779500, 0xc000286d20, 0x1e3c7c0, 0xc000696690, 0x97, 0x1e3c7c0, 0xc0006966a8, 0x97)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/options.go:320 +0x12c
test_1 | github.com/google/go-cmp/cmp.(*state).tryOptions(0xc000286d20, 0x31bd2f8, 0x1e3c7c0, 0x1e3c7c0, 0xc000696690, 0x97, 0x1e3c7c0, 0xc0006966a8, 0x97, 0x7ff5728613b8)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:303 +0x132
test_1 | github.com/google/go-cmp/cmp.(*state).compareAny(0xc000286d20, 0x30d8970, 0xc000cb5640)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:258 +0x2f2
test_1 | github.com/google/go-cmp/cmp.Diff(0x1e3c7c0, 0xc000696690, 0x1e3c7c0, 0xc0006966a8, 0x438eb00, 0x7, 0x7, 0x19ff45d5377496cb, 0x30d8cd0)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:119 +0xab
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareVals(0xc00044fa50, 0x1, 0x1, 0xc00044fa70, 0x1, 0x1, 0x1, 0x20)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:39 +0xed
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.compareRows(0xc001029880, 0xc001029801, 0x2150cf5, 0xa, 0xc001029ab8)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:251 +0x225
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareConns(0x30e1430, 0xc0002f9560, 0x6fc23ac00, 0xc001029da0, 0x0, 0x0, 0xc0004bec00, 0x320, 0x1, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:213 +0x571
test_1 | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000c28c00)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:176 +0xabe
test_1 | testing.tRunner(0xc000c28c00, 0xc000cb1890)
test_1 | /usr/local/go/src/testing/testing.go:1193 +0xef
test_1 | created by testing.(*T).Run
test_1 | /usr/local/go/src/testing/testing.go:1238 +0x2b3
compare_test_1 exited with code 2
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 2
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 1bb94b40c519b775d99dffe64435f968206ced4b:
test_1 |
test_1 | goroutine 605505 [running]:
test_1 | testing.tRunner.func1.2(0x1ee3e60, 0x4055dd0)
test_1 | /usr/local/go/src/testing/testing.go:1143 +0x332
test_1 | testing.tRunner.func1(0xc0003fea80)
test_1 | /usr/local/go/src/testing/testing.go:1146 +0x4b6
test_1 | panic(0x1ee3e60, 0x4055dd0)
test_1 | /usr/local/go/src/runtime/panic.go:965 +0x1b9
test_1 | math/big.(*Int).Set(...)
test_1 | /usr/local/go/src/math/big/int.go:75
test_1 | github.com/cockroachdb/apd/v2.NewWithBigInt(0x0, 0x0, 0x1)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/v2/decimal.go:95 +0x58
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.glob..func1(0xc000e5c020, 0x1, 0x1, 0x0, 0x0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:118 +0x29e
test_1 | reflect.Value.call(0x1e7b840, 0x26b1298, 0x13, 0x21462ff, 0x4, 0xc001101028, 0x1, 0x1, 0xc001100f68, 0x43170b, ...)
test_1 | /usr/local/go/src/reflect/value.go:476 +0x8e7
test_1 | reflect.Value.Call(0x1e7b840, 0x26b1298, 0x13, 0xc001101028, 0x1, 0x1, 0xc000e440c0, 0x1, 0x1)
test_1 | /usr/local/go/src/reflect/value.go:337 +0xb9
test_1 | github.com/google/go-cmp/cmp.(*state).callTRFunc(0xc000c960a0, 0x1e7b840, 0x26b1298, 0x13, 0x1e3c7c0, 0xc000e44000, 0x97, 0xc000e560a0, 0x0, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:333 +0x265
test_1 | github.com/google/go-cmp/cmp.(*transformer).apply(0xc000687500, 0xc000c960a0, 0x1e3c7c0, 0xc000e44000, 0x97, 0x1e3c7c0, 0xc000e44030, 0x97)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/options.go:320 +0x12c
test_1 | github.com/google/go-cmp/cmp.(*state).tryOptions(0xc000c960a0, 0x31bd2f8, 0x1e3c7c0, 0x1e3c7c0, 0xc000e44000, 0x97, 0x1e3c7c0, 0xc000e44030, 0x97, 0x7f3440c92ec8)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:303 +0x132
test_1 | github.com/google/go-cmp/cmp.(*state).compareAny(0xc000c960a0, 0x30d8970, 0xc000b74040)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:258 +0x2f2
test_1 | github.com/google/go-cmp/cmp.Diff(0x1e3c7c0, 0xc000e44000, 0x1e3c7c0, 0xc000e44030, 0x438eb00, 0x7, 0x7, 0x3d0d6d3571fdfc6f, 0x30d8cd0)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:119 +0xab
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareVals(0xc000e5c020, 0x1, 0x1, 0xc000e5c040, 0x1, 0x1, 0x1, 0x40)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:39 +0xed
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.compareRows(0xc001101880, 0xc001101801, 0x2150ceb, 0xa, 0xc001101ab8)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:251 +0x225
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareConns(0x30e1430, 0xc00108c840, 0x6fc23ac00, 0xc001101da0, 0x0, 0x0, 0xc000d62200, 0x18d, 0x1, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:213 +0x571
test_1 | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc0003fea80)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:176 +0xabe
test_1 | testing.tRunner(0xc0003fea80, 0xc00079fe00)
test_1 | /usr/local/go/src/testing/testing.go:1193 +0xef
test_1 | created by testing.(*T).Run
test_1 | /usr/local/go/src/testing/testing.go:1238 +0x2b3
compare_test_1 exited with code 2
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 2
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ cb0222a1980b96ad59c181c96fab8340aa252571:
test_1 |
test_1 | goroutine 6 [running]:
test_1 | testing.tRunner.func1.2(0x1ee4aa0, 0x4057dd0)
test_1 | /usr/local/go/src/testing/testing.go:1143 +0x332
test_1 | testing.tRunner.func1(0xc0003e9e00)
test_1 | /usr/local/go/src/testing/testing.go:1146 +0x4b6
test_1 | panic(0x1ee4aa0, 0x4057dd0)
test_1 | /usr/local/go/src/runtime/panic.go:965 +0x1b9
test_1 | math/big.(*Int).Set(...)
test_1 | /usr/local/go/src/math/big/int.go:75
test_1 | github.com/cockroachdb/apd/v2.NewWithBigInt(0x0, 0x0, 0x1)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/v2/decimal.go:95 +0x58
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.glob..func1(0xc0003c0850, 0x1, 0x1, 0x0, 0x0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:118 +0x29e
test_1 | reflect.Value.call(0x1e7c4e0, 0x26b2100, 0x13, 0x214707f, 0x4, 0xc0012db028, 0x1, 0x1, 0xc0012daf68, 0x43170b, ...)
test_1 | /usr/local/go/src/reflect/value.go:476 +0x8e7
test_1 | reflect.Value.Call(0x1e7c4e0, 0x26b2100, 0x13, 0xc0012db028, 0x1, 0x1, 0xc000c1c078, 0x1, 0x1)
test_1 | /usr/local/go/src/reflect/value.go:337 +0xb9
test_1 | github.com/google/go-cmp/cmp.(*state).callTRFunc(0xc000d5a000, 0x1e7c4e0, 0x26b2100, 0x13, 0x1e3d460, 0xc000c1c000, 0x97, 0xc000c3a280, 0x0, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:333 +0x265
test_1 | github.com/google/go-cmp/cmp.(*transformer).apply(0xc00059d540, 0xc000d5a000, 0x1e3d460, 0xc000c1c000, 0x97, 0x1e3d460, 0xc000c1c018, 0x97)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/options.go:320 +0x12c
test_1 | github.com/google/go-cmp/cmp.(*state).tryOptions(0xc000d5a000, 0x31be498, 0x1e3d460, 0x1e3d460, 0xc000c1c000, 0x97, 0x1e3d460, 0xc000c1c018, 0x97, 0x7fdcb776faa8)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:303 +0x132
test_1 | github.com/google/go-cmp/cmp.(*state).compareAny(0xc000d5a000, 0x30d9b10, 0xc000b64080)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:258 +0x2f2
test_1 | github.com/google/go-cmp/cmp.Diff(0x1e3d460, 0xc000c1c000, 0x1e3d460, 0xc000c1c018, 0x4390b80, 0x7, 0x7, 0x1e980f350b5ad105, 0x30d9e70)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:119 +0xab
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareVals(0xc0003c0850, 0x1, 0x1, 0xc0003c0880, 0x1, 0x1, 0x1, 0x20)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:39 +0xed
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.compareRows(0xc0012db880, 0xc0012db801, 0x2151a75, 0xa, 0xc0012dbab8)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:251 +0x225
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareConns(0x30e25d0, 0xc000afef00, 0x6fc23ac00, 0xc0012dbda0, 0x0, 0x0, 0xc000af8c00, 0x1fb, 0x1, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:213 +0x571
test_1 | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc0003e9e00)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:176 +0xabe
test_1 | testing.tRunner(0xc0003e9e00, 0xc000b50570)
test_1 | /usr/local/go/src/testing/testing.go:1193 +0xef
test_1 | created by testing.(*T).Run
test_1 | /usr/local/go/src/testing/testing.go:1238 +0x2b3
compare_test_1 exited with code 2
Stopping compare_postgres_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 2
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 3cf7ac914c42bb024c688564983445f3eb5da58a:
test_1 |
test_1 | goroutine 27 [running]:
test_1 | testing.tRunner.func1.2(0x1ee5a20, 0x4058dd0)
test_1 | /usr/local/go/src/testing/testing.go:1143 +0x332
test_1 | testing.tRunner.func1(0xc000954780)
test_1 | /usr/local/go/src/testing/testing.go:1146 +0x4b6
test_1 | panic(0x1ee5a20, 0x4058dd0)
test_1 | /usr/local/go/src/runtime/panic.go:965 +0x1b9
test_1 | math/big.(*Int).Set(...)
test_1 | /usr/local/go/src/math/big/int.go:75
test_1 | github.com/cockroachdb/apd/v2.NewWithBigInt(0x0, 0x0, 0xc0005650e0)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/cockroachdb/apd/v2/decimal.go:95 +0x58
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.glob..func1(0xc000b8bc40, 0x2, 0x2, 0x0, 0x0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:118 +0x29e
test_1 | reflect.Value.call(0x1e7d460, 0x26b3190, 0x13, 0x21480df, 0x4, 0xc0010d5028, 0x1, 0x1, 0xc0010d4f68, 0x43170b, ...)
test_1 | /usr/local/go/src/reflect/value.go:476 +0x8e7
test_1 | reflect.Value.Call(0x1e7d460, 0x26b3190, 0x13, 0xc0010d5028, 0x1, 0x1, 0xc000a219c8, 0x1, 0x1)
test_1 | /usr/local/go/src/reflect/value.go:337 +0xb9
test_1 | github.com/google/go-cmp/cmp.(*state).callTRFunc(0xc000d675e0, 0x1e7d460, 0x26b3190, 0x13, 0x1e3e3e0, 0xc000a21950, 0x97, 0xc0006c4af0, 0x0, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:333 +0x265
test_1 | github.com/google/go-cmp/cmp.(*transformer).apply(0xc000613540, 0xc000d675e0, 0x1e3e3e0, 0xc000a21950, 0x97, 0x1e3e3e0, 0xc000a21968, 0x97)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/options.go:320 +0x12c
test_1 | github.com/google/go-cmp/cmp.(*state).tryOptions(0xc000d675e0, 0x31bf5b8, 0x1e3e3e0, 0x1e3e3e0, 0xc000a21950, 0x97, 0x1e3e3e0, 0xc000a21968, 0x97, 0x7f6b20c3d4a0)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:303 +0x132
test_1 | github.com/google/go-cmp/cmp.(*state).compareAny(0xc000d675e0, 0x30dac30, 0xc000be5d40)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:258 +0x2f2
test_1 | github.com/google/go-cmp/cmp.Diff(0x1e3e3e0, 0xc000a21950, 0x1e3e3e0, 0xc000a21968, 0x4391b80, 0x7, 0x7, 0x1f156267b36c7212, 0x30daf90)
test_1 | /go/src/github.com/cockroachdb/cockroach/vendor/github.com/google/go-cmp/cmp/compare.go:119 +0xab
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareVals(0xc000b8bc40, 0x2, 0x2, 0xc000b8bc60, 0x2, 0x2, 0x2, 0x20)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/compare.go:39 +0xed
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.compareRows(0xc0010d5880, 0xc0010d5801, 0x2152ad5, 0xa, 0xc0010d5ab8)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:251 +0x225
test_1 | github.com/cockroachdb/cockroach/pkg/cmd/cmpconn.CompareConns(0x30e36f0, 0xc000111bc0, 0x6fc23ac00, 0xc0010d5da0, 0x0, 0x0, 0xc000e4f000, 0x3e3, 0x1, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/cmd/cmpconn/conn.go:213 +0x571
test_1 | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000954780)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:176 +0xabe
test_1 | testing.tRunner(0xc000954780, 0xc00095c180)
test_1 | /usr/local/go/src/testing/testing.go:1193 +0xef
test_1 | created by testing.(*T).Run
test_1 | /usr/local/go/src/testing/testing.go:1238 +0x2b3
compare_test_1 exited with code 2
Stopping compare_postgres_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 2
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ c754d101ccd7541b0f597dac2f37809c1a859bf2:
postgres_1 | col_16367 NULLS FIRST,
postgres_1 | col_16368 NULLS FIRST,
postgres_1 | col_16369 NULLS FIRST,
postgres_1 | col_16370 NULLS FIRST,
postgres_1 | col_16371 NULLS FIRST,
postgres_1 | col_16372 NULLS FIRST,
postgres_1 | col_16373 NULLS FIRST,
postgres_1 | col_16374 NULLS FIRST,
postgres_1 | col_16375 NULLS FIRST
test_1 | --- FAIL: TestCompare (621.98s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (17.26s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:183: compare cockroach1 to postgres:
test_1 | unexpected diff:
test_1 | []interface{}(Inverse(func1, []interface{}{
test_1 | - nil,
test_1 | + string("BOX(-45 0,0 45)"),
test_1 | }))
test_1 | cockroach1:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('E':::STRING::STRING::STRING, NULL::INT4::INT4)::BOX2D AS col_16390) AS tab_8434
test_1 | ORDER BY
test_1 | CAST(col_16390 AS STRING) NULLS FIRST;
test_1 |
test_1 | postgres:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('E'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::BOX2D AS col_16390) AS tab_8434
test_1 | ORDER BY
test_1 | CAST(col_16390 AS TEXT) NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ f963a1eb6daa99bd5fd2c43771773473cdf361f7:
test_1 | JOIN postgres.public.table2@primary AS tab_417629 ON
test_1 | (tab_417628.col4_8) = (tab_417629.crdb_internal_idx_expr_1)
test_1 | AND (tab_417628.col4_2) = (tab_417629.crdb_internal_idx_expr_1)
test_1 | AND (tab_417627.col4_2) = (tab_417629.col2_3)
test_1 | JOIN postgres.public.table2@primary AS tab_417630
test_1 | JOIN postgres.public.table2 AS tab_417631
test_1 | JOIN postgres.public.table2 AS tab_417632 ON (tab_417631.col2_2) = (tab_417632.col2_2)
test_1 | JOIN postgres.public.table2@table2_col2_2_col2_1_col2_3_col2_0_col2_5_col2_4_key AS tab_417633
test_1 | JOIN postgres.public.table2@[0] AS tab_417634
test_1 | JOIN postgres.public.table2@[0] AS tab_417635 ON (tab_417634.col2_4) = (tab_417635.col2_4)
test_1 | JOIN postgres.public.table4 AS tab_417636
test_1 | JOIN postgres.public.table4 AS tab_417637 ON
test_1 | (tab_417636.col4_6) = (tab_417637.col4_6)
test_1 | AND (tab_417636.col4_2) = (tab_417637.col4_2)
test_1 | AND (tab_417636.col4_8) = (tab_417637.col4_8) ON
test_1 | (tab_417635.crdb_internal_idx_expr_1) = (tab_417636.col4_8) ON
test_1 | (tab_417633.crdb_internal_idx_expr) = (tab_417635.crdb_internal_idx_expr)
test_1 | AND (tab_417633.col2_0) = (tab_417635.crdb_internal_idx_expr)
test_1 | AND (tab_417633.col2_3) = (tab_417635.col2_3)
test_1 | AND (tab_417633.col2_5) = (tab_417634.col2_5) ON
test_1 | (tab_417632.col2_2) = (tab_417634.col2_2) ON
test_1 | (tab_417630.col2_5) = (tab_417633.crdb_internal_idx_expr)
test_1 | AND (tab_417630.col2_3) = (tab_417635.crdb_internal_idx_expr_1)
test_1 | AND (tab_417630.col2_4) = (tab_417634.col2_4)
test_1 | AND (tab_417630.col2_1) = (tab_417633.col2_1)
test_1 | AND (tab_417630.col2_4) = (tab_417633.col2_1)
test_1 | AND (tab_417630.crdb_internal_idx_expr) = (tab_417634.crdb_internal_idx_expr)
test_1 | AND (tab_417630.col2_0) = (tab_417633.col2_0) ON
test_1 | (tab_417626.col1_0) = (tab_417633.col2_5)
test_1 | AND (tab_417629.col2_5) = (tab_417633.crdb_internal_idx_expr)
test_1 | AND (tab_417628.col4_8) = (tab_417637.col4_8)
test_1 | AND (tab_417626.col1_1) = (tab_417634.tableoid)
test_1 | WHERE
test_1 | true::BOOL
test_1 | )
test_1 | AS tab_417638
test_1 | ORDER BY
test_1 | col_722735 NULLS FIRST, col_722736 NULLS FIRST
test_1 | compare_test.go:193: cockroach1: ping: conn closed
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 3adc6da4ccdf80618e6bbcee5ee9e503a92517e7:
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('f', 'whuhic', 'bo', 'cwnq', 'ifx');
test_1 | CREATE TYPE rand_typ_3 AS ENUM ('x', 'i');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: functions in index expression must be marked IMMUTABLE (SQLSTATE 42P17)
test_1 | --- FAIL: TestCompare/mutators (0.00s)
test_1 | compare_test.go:125: starting test: mutators
test_1 | panic: geos: no locations to init GEOS [recovered]
test_1 | panic: geos: no locations to init GEOS
test_1 |
test_1 | goroutine 51 [running]:
test_1 | testing.tRunner.func1.2(0x1fb8ac0, 0xc000cbe5e0)
test_1 | /usr/local/go/src/testing/testing.go:1143 +0x332
test_1 | testing.tRunner.func1(0xc000603c80)
test_1 | /usr/local/go/src/testing/testing.go:1146 +0x4b6
test_1 | panic(0x1fb8ac0, 0xc000cbe5e0)
test_1 | /usr/local/go/src/runtime/panic.go:965 +0x1b9
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x406df60, 0x31b8bd8, 0xc000dbd950, 0x31b8bd8, 0xc000dbd950, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:368 +0x5d3
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0xc000caa5d0, 0x406df60, 0x0, 0x0, 0x0, 0x0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:301 +0x17f
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc0004f6480)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:220 +0x9e
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc000caa5d0, 0xc000756640, 0x5, 0x5, 0x0, 0x0, 0x0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:251 +0xbeb
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x26b38e0, 0xc000caa5d0, 0xc000756640, 0x5, 0x5, 0x0, 0xc0004aa320, 0xe0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:97 +0x4e
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.RandCreateTables(0xc000caa5d0, 0x214a516, 0x5, 0x5, 0xc0005bfa30, 0x3, 0x3, 0xe0, 0x4436d7, 0x8)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/schema.go:89 +0x163
test_1 | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTablesN(0xc000caa5d0, 0x5, 0x4, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:91 +0x19e
test_1 | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.randTables(0xc000caa5d0, 0x4394f8, 0x30)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:77 +0x4f
test_1 | github.com/cockroachdb/cockroach/pkg/internal/sqlsmith.wrapCommonSetup.func1(0xc000caa5d0, 0xc45d5533c412c4b3, 0x11)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/internal/sqlsmith/setup.go:43 +0x44
test_1 | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000603c80)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:127 +0x113
test_1 | testing.tRunner(0xc000603c80, 0xc000caa570)
test_1 | /usr/local/go/src/testing/testing.go:1193 +0xef
test_1 | created by testing.(*T).Run
test_1 | /usr/local/go/src/testing/testing.go:1238 +0x2b3
compare_test_1 exited with code 2
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 2
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 999d35029f33a9b35dde0599c952efc83ed726a7:
postgres_1 | postgres.public.table3 AS tab_29840
postgres_1 | WHERE
postgres_1 | false::BOOL
postgres_1 | ORDER BY
postgres_1 | tab_29840.crdb_internal_idx_expr ASC, tab_29840.crdb_internal_idx_expr
postgres_1 | )
postgres_1 | AS tab_29841
postgres_1 | ORDER BY
postgres_1 | col_43121 NULLS FIRST, col_43122 NULLS FIRST, col_43123 NULLS FIRST
test_1 | --- FAIL: TestCompare (638.45s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (34.40s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:183: compare cockroach1 to postgres:
test_1 | unexpected diff:
test_1 | []interface{}(Inverse(func1, []interface{}{
test_1 | - nil,
test_1 | + string("BOX(-90 0,-45 45)"),
test_1 | }))
test_1 | postgres:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('D'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::BOX2D AS col_43124) AS tab_29842
test_1 | ORDER BY
test_1 | CAST(col_43124 AS TEXT) NULLS FIRST;
test_1 |
test_1 | cockroach1:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('D':::STRING::STRING::STRING, NULL::INT4::INT4)::BOX2D AS col_43124) AS tab_29842
test_1 | ORDER BY
test_1 | CAST(col_43124 AS STRING) NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ f51352920c0af2bbede32dab8fee6424fc27a911:
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (18.30s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:183: compare cockroach1 to postgres:
test_1 | unexpected diff:
test_1 | []interface{}(Inverse(func1, []interface{}{
test_1 | - nil,
test_1 | + string("BOX(-180 45,-135 90)H"),
test_1 | }))
test_1 | cockroach1:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (
test_1 | SELECT
test_1 | (st_box2dfromgeohash('B':::STRING::STRING::STRING, NULL::INT4::INT4)::BOX2D::BOX2D || 'H':::STRING::STRING::STRING)::STRING
test_1 | AS col_18185
test_1 | )
test_1 | AS tab_10018
test_1 | ORDER BY
test_1 | col_18185 NULLS FIRST;
test_1 |
test_1 | postgres:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (
test_1 | SELECT
test_1 | (st_box2dfromgeohash('B'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::BOX2D::BOX2D || 'H'::TEXT::TEXT::TEXT)::TEXT
test_1 | AS col_18185
test_1 | )
test_1 | AS tab_10018
test_1 | ORDER BY
test_1 | col_18185 NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 4d0b749d263b95baf3054607d5f13a92cbb6a055:
postgres_1 | 2021-12-20 06:14:46.524 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1 | 2021-12-20 06:14:46.529 UTC [68] LOG: database system was shut down at 2021-12-20 06:14:46 UTC
postgres_1 | 2021-12-20 06:14:46.534 UTC [1] LOG: database system is ready to accept connections
postgres_1 | 2021-12-20 06:14:49.352 UTC [78] ERROR: functions in index expression must be marked IMMUTABLE
postgres_1 | 2021-12-20 06:14:49.352 UTC [78] STATEMENT: CREATE TABLE table1 (col1_0 TIMESTAMP NOT NULL, col1_1 INT2, col1_2 INT8 NULL, col1_3 NAME NOT NULL, col1_4 DATE, col1_5 BYTEA, col1_6 OID NULL, col1_7 INT8[] NOT NULL, col1_8 FLOAT4, col1_9 GEOGRAPHY, col1_10 REGPROCEDURE, col1_11 BOOL NULL, col1_12 DECIMAL NOT NULL, col1_13 NAME NOT NULL, col1_14 OID NULL, col1_15 BOX2D, col1_16 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_7 IS NULL THEN ''::TEXT ELSE e'Hf6\x11MIW'::TEXT END) STORED);
postgres_1 | CREATE UNIQUE INDEX ON table1 (col1_1 ASC, col1_14);
postgres_1 | CREATE UNIQUE INDEX ON table1 ((CASE WHEN col1_0 IS NULL THEN e'\x15\x1e\x05Q+2'::TEXT ELSE e'?sR\n!)s*'::TEXT END), col1_13, col1_1 ASC, col1_14 ASC, col1_10 DESC, col1_11 DESC) INCLUDE (col1_0, col1_3, col1_4, col1_5, col1_12);
postgres_1 | CREATE TABLE table2 (col2_0 TEXT NOT NULL, col2_1 TIMESTAMPTZ NOT NULL, col2_2 REGROLE NOT NULL, col2_3 "char" NOT NULL, PRIMARY KEY (col2_3, col2_1, col2_0, col2_2));
postgres_1 | CREATE INDEX ON table2 (col2_0 ASC, col2_3);
postgres_1 | CREATE INDEX ON table2 (col2_0 ASC, col2_2 ASC, col2_1 ASC);
postgres_1 | CREATE INDEX ON table2 (lower(CAST(col2_2 AS TEXT)) DESC, col2_0 ASC);
postgres_1 | CREATE INDEX ON table2 (lower(col2_3) ASC, col2_2, lower(col2_0) ASC);
postgres_1 | CREATE TYPE rand_typ_0 AS ENUM ('tok', 'k', 'w', 'icjc');
postgres_1 | CREATE TYPE rand_typ_1 AS ENUM ('i', 'tia', 'nx', 'lftb', 'qqawsd', 'h');
postgres_1 | CREATE TYPE rand_typ_2 AS ENUM ('ucmxf', 'xkg', 'ey', 'ijfj');
postgres_1 | CREATE TYPE rand_typ_3 AS ENUM ('nsklw', 'zj', 'gtldxn', 'ybj', 'p');
postgres_1 |
test_1 | --- FAIL: TestCompare (607.76s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (2.39s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 TIMESTAMP NOT NULL, col1_1 INT2, col1_2 INT8 NULL, col1_3 NAME NOT NULL, col1_4 DATE, col1_5 BYTEA, col1_6 OID NULL, col1_7 INT8[] NOT NULL, col1_8 FLOAT4, col1_9 GEOGRAPHY, col1_10 REGPROCEDURE, col1_11 BOOL NULL, col1_12 DECIMAL NOT NULL, col1_13 NAME NOT NULL, col1_14 OID NULL, col1_15 BOX2D, col1_16 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_7 IS NULL THEN ''::TEXT ELSE e'Hf6\x11MIW'::TEXT END) STORED);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_1 ASC, col1_14);
test_1 | CREATE UNIQUE INDEX ON table1 ((CASE WHEN col1_0 IS NULL THEN e'\x15\x1e\x05Q+2'::TEXT ELSE e'?sR\n!)s*'::TEXT END), col1_13, col1_1 ASC, col1_14 ASC, col1_10 DESC, col1_11 DESC) INCLUDE (col1_0, col1_3, col1_4, col1_5, col1_12);
test_1 | CREATE TABLE table2 (col2_0 TEXT NOT NULL, col2_1 TIMESTAMPTZ NOT NULL, col2_2 REGROLE NOT NULL, col2_3 "char" NOT NULL, PRIMARY KEY (col2_3, col2_1, col2_0, col2_2));
test_1 | CREATE INDEX ON table2 (col2_0 ASC, col2_3);
test_1 | CREATE INDEX ON table2 (col2_0 ASC, col2_2 ASC, col2_1 ASC);
test_1 | CREATE INDEX ON table2 (lower(CAST(col2_2 AS TEXT)) DESC, col2_0 ASC);
test_1 | CREATE INDEX ON table2 (lower(col2_3) ASC, col2_2, lower(col2_0) ASC);
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('tok', 'k', 'w', 'icjc');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('i', 'tia', 'nx', 'lftb', 'qqawsd', 'h');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('ucmxf', 'xkg', 'ey', 'ijfj');
test_1 | CREATE TYPE rand_typ_3 AS ENUM ('nsklw', 'zj', 'gtldxn', 'ybj', 'p');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: functions in index expression must be marked IMMUTABLE (SQLSTATE 42P17)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 33ec37ae94ff96d2f5804506810fb436b186bc32:
postgres_1 | 2021-12-21 06:15:41.484 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1 | 2021-12-21 06:15:41.488 UTC [68] LOG: database system was shut down at 2021-12-21 06:15:41 UTC
postgres_1 | 2021-12-21 06:15:41.492 UTC [1] LOG: database system is ready to accept connections
postgres_1 | 2021-12-21 06:15:43.340 UTC [78] ERROR: syntax error at or near "ASC" at character 773
postgres_1 | 2021-12-21 06:15:43.340 UTC [78] STATEMENT: CREATE TABLE table1 (col1_0 OID, col1_1 TIMETZ NULL, col1_2 VARCHAR NOT NULL, col1_3 GEOMETRY NOT NULL, col1_4 FLOAT4 NULL, col1_5 CHAR NULL, col1_6 REGPROCEDURE NOT NULL, col1_7 REGCLASS NOT NULL, col1_8 REGROLE, col1_9 GEOGRAPHY NOT NULL, col1_10 DATE NULL, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_3 AS TEXT))) STORED, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_7 AS TEXT))) STORED, UNIQUE (col1_2), UNIQUE (col1_10));
postgres_1 | CREATE TABLE table2 (col2_0 DECIMAL NOT NULL, col2_1 CHAR NULL, col2_2 NAME NOT NULL, col2_3 INET[], col2_4 INTERVAL NULL, col2_5 BIT(37) NOT NULL, col2_6 "char" NOT NULL, col2_7 TIMESTAMP, col2_8 OID, col2_9 REGCLASS NULL, col2_10 REGNAMESPACE NOT NULL, col2_11 DATE NULL, col2_12 OID NOT NULL, PRIMARY KEY (col2_2 ASC, col2_10 DESC, col2_6, col2_0 DESC, col2_12, col2_5 DESC), col2_13 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_4 AS TEXT))) STORED, col2_14 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_11 AS TEXT))) STORED, col2_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(col2_6)) STORED, UNIQUE (col2_5));
postgres_1 | CREATE TABLE table3 (col3_0 DECIMAL NOT NULL, col3_1 GEOGRAPHY NOT NULL, col3_2 FLOAT4 NULL, col3_3 INET NOT NULL, UNIQUE (col3_2 DESC, (col3_0 + 2.473344391090436850E+29::DECIMAL) DESC) WHERE (table3.col3_0 != 1::DECIMAL) OR (table3.col3_2 <= '-Inf'::FLOAT8), UNIQUE (col3_0, lower(CAST(col3_1 AS TEXT)) ASC, col3_3), INVERTED INDEX (col3_1 DESC) WHERE (table3.col3_2 > 0.0::FLOAT8) AND (table3.col3_0 >= '-Infinity'::DECIMAL));
postgres_1 | CREATE TABLE table4 (col4_0 BOOL[] NULL, col4_1 REGCLASS, col4_2 "char" NULL, col4_3 DATE NULL, col4_4 INTERVAL NULL, col4_5 BIT(40), col4_6 INET NOT NULL, col4_7 TEXT GENERATED ALWAYS AS (lower(CAST(col4_1 AS TEXT))) STORED, col4_8 TEXT GENERATED ALWAYS AS (lower(CAST(col4_5 AS TEXT))) STORED, UNIQUE (col4_7, lower(col4_2) ASC, col4_4 ASC, col4_3 DESC, col4_2, col4_1, col4_8 DESC, lower(col4_2)));
postgres_1 | CREATE TABLE table5 (col5_0 DATE NOT NULL, col5_1 INT8, col5_2 INET NULL, col5_3 BOOL, col5_4 FLOAT8, col5_5 JSONB, col5_6 CHAR NOT NULL, col5_7 DATE NULL, col5_8 BOX2D, col5_9 TEXT GENERATED ALWAYS AS (lower(CAST(col5_3 AS TEXT))) STORED, col5_10 TEXT GENERATED ALWAYS AS (lower(CAST(col5_3 AS TEXT))) STORED);
postgres_1 | ALTER TABLE table2 ADD FOREIGN KEY (col2_6) REFERENCES table1 (col1_2);
postgres_1 | ALTER TABLE table4 ADD FOREIGN KEY (col4_5) REFERENCES table2 (col2_5) ON DELETE CASCADE;
postgres_1 | ALTER TABLE table4 ADD FOREIGN KEY (col4_3) REFERENCES table1 (col1_10) ON DELETE RESTRICT;
postgres_1 | CREATE TYPE rand_typ_0 AS ENUM ('ndoew', 'g', 'nefwvv', 'ngq');
postgres_1 | CREATE TYPE rand_typ_1 AS ENUM ('nhvfz', 'zx');
postgres_1 | CREATE TYPE rand_typ_2 AS ENUM ('n', 'c', 'f', 'qwwf');
postgres_1 | CREATE TYPE rand_typ_3 AS ENUM ('qwvs');
postgres_1 |
test_1 | --- FAIL: TestCompare (607.85s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (1.28s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 OID, col1_1 TIMETZ NULL, col1_2 VARCHAR NOT NULL, col1_3 GEOMETRY NOT NULL, col1_4 FLOAT4 NULL, col1_5 CHAR NULL, col1_6 REGPROCEDURE NOT NULL, col1_7 REGCLASS NOT NULL, col1_8 REGROLE, col1_9 GEOGRAPHY NOT NULL, col1_10 DATE NULL, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_3 AS TEXT))) STORED, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_7 AS TEXT))) STORED, UNIQUE (col1_2), UNIQUE (col1_10));
test_1 | CREATE TABLE table2 (col2_0 DECIMAL NOT NULL, col2_1 CHAR NULL, col2_2 NAME NOT NULL, col2_3 INET[], col2_4 INTERVAL NULL, col2_5 BIT(37) NOT NULL, col2_6 "char" NOT NULL, col2_7 TIMESTAMP, col2_8 OID, col2_9 REGCLASS NULL, col2_10 REGNAMESPACE NOT NULL, col2_11 DATE NULL, col2_12 OID NOT NULL, PRIMARY KEY (col2_2 ASC, col2_10 DESC, col2_6, col2_0 DESC, col2_12, col2_5 DESC), col2_13 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_4 AS TEXT))) STORED, col2_14 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_11 AS TEXT))) STORED, col2_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(col2_6)) STORED, UNIQUE (col2_5));
test_1 | CREATE TABLE table3 (col3_0 DECIMAL NOT NULL, col3_1 GEOGRAPHY NOT NULL, col3_2 FLOAT4 NULL, col3_3 INET NOT NULL, UNIQUE (col3_2 DESC, (col3_0 + 2.473344391090436850E+29::DECIMAL) DESC) WHERE (table3.col3_0 != 1::DECIMAL) OR (table3.col3_2 <= '-Inf'::FLOAT8), UNIQUE (col3_0, lower(CAST(col3_1 AS TEXT)) ASC, col3_3), INVERTED INDEX (col3_1 DESC) WHERE (table3.col3_2 > 0.0::FLOAT8) AND (table3.col3_0 >= '-Infinity'::DECIMAL));
test_1 | CREATE TABLE table4 (col4_0 BOOL[] NULL, col4_1 REGCLASS, col4_2 "char" NULL, col4_3 DATE NULL, col4_4 INTERVAL NULL, col4_5 BIT(40), col4_6 INET NOT NULL, col4_7 TEXT GENERATED ALWAYS AS (lower(CAST(col4_1 AS TEXT))) STORED, col4_8 TEXT GENERATED ALWAYS AS (lower(CAST(col4_5 AS TEXT))) STORED, UNIQUE (col4_7, lower(col4_2) ASC, col4_4 ASC, col4_3 DESC, col4_2, col4_1, col4_8 DESC, lower(col4_2)));
test_1 | CREATE TABLE table5 (col5_0 DATE NOT NULL, col5_1 INT8, col5_2 INET NULL, col5_3 BOOL, col5_4 FLOAT8, col5_5 JSONB, col5_6 CHAR NOT NULL, col5_7 DATE NULL, col5_8 BOX2D, col5_9 TEXT GENERATED ALWAYS AS (lower(CAST(col5_3 AS TEXT))) STORED, col5_10 TEXT GENERATED ALWAYS AS (lower(CAST(col5_3 AS TEXT))) STORED);
test_1 | ALTER TABLE table2 ADD FOREIGN KEY (col2_6) REFERENCES table1 (col1_2);
test_1 | ALTER TABLE table4 ADD FOREIGN KEY (col4_5) REFERENCES table2 (col2_5) ON DELETE CASCADE;
test_1 | ALTER TABLE table4 ADD FOREIGN KEY (col4_3) REFERENCES table1 (col1_10) ON DELETE RESTRICT;
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('ndoew', 'g', 'nefwvv', 'ngq');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('nhvfz', 'zx');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('n', 'c', 'f', 'qwwf');
test_1 | CREATE TYPE rand_typ_3 AS ENUM ('qwvs');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: syntax error at or near "ASC" (SQLSTATE 42601)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 2282896401079fef362d5456b71b32dd600e52b0:
test_1 | 'H':::STRING::STRING AS col_286789
test_1 | FROM
test_1 | postgres.public.table4@[0] AS tab_165167
test_1 | JOIN postgres.public.table3 AS tab_165168
test_1 | JOIN postgres.public.table3 AS tab_165169 ON (tab_165168.col3_0) = (tab_165169.col3_0)
test_1 | JOIN postgres.public.table4@[0] AS tab_165170
test_1 | JOIN postgres.public.table3@[0] AS tab_165171 ON (tab_165170.tableoid) = (tab_165171.col3_0)
test_1 | JOIN postgres.public.table4@[0] AS tab_165172 ON (tab_165170.col4_10) = (tab_165172.col4_4) ON
test_1 | (tab_165168.col3_2) = (tab_165172.col4_6) AND (tab_165169.col3_2) = (tab_165172.col4_6)
test_1 | JOIN postgres.public.table3@[0] AS tab_165173 ON
test_1 | (tab_165171.col3_2) = (tab_165173.col3_2)
test_1 | AND (tab_165171.col3_3) = (tab_165173.col3_3)
test_1 | AND (tab_165172.col4_1) = (tab_165173.col3_0)
test_1 | JOIN postgres.public.table3@table3_col3_0_col3_2_col3_3_key AS tab_165174 ON
test_1 | (tab_165171.col3_3) = (tab_165174.col3_2)
test_1 | AND (tab_165172.tableoid) = (tab_165174.col3_0)
test_1 | AND (tab_165171.col3_0) = (tab_165174.col3_0)
test_1 | JOIN postgres.public.table5@table5_col5_3_col5_2_col5_8_expr_key AS tab_165175 ON
test_1 | (tab_165173.col3_2) = (tab_165175.col5_0)
test_1 | AND (tab_165169.col3_2) = (tab_165175.col5_0)
test_1 | AND (tab_165174.col3_0) = (tab_165175.col5_1)
test_1 | AND (tab_165168.col3_2) = (tab_165175.crdb_internal_idx_expr)
test_1 | AND (tab_165170.col4_2) = (tab_165175.col5_5) ON
test_1 | (tab_165167.col4_8) = (tab_165170.col4_9)
test_1 | AND (tab_165167.col4_9) = (tab_165170.col4_8)
test_1 | AND (tab_165167.col4_4) = (tab_165172.col4_8),
test_1 | postgres.public.table4@[0] AS tab_165176
test_1 | ORDER BY
test_1 | tab_165167.col4_2 DESC, tab_165167.col4_4 ASC
test_1 | )
test_1 | AS tab_165177
test_1 | ORDER BY
test_1 | col_286784 NULLS FIRST,
test_1 | col_286785 NULLS FIRST,
test_1 | col_286786 NULLS FIRST,
test_1 | col_286787 NULLS FIRST,
test_1 | col_286788 NULLS FIRST,
test_1 | col_286789 NULLS FIRST
test_1 | compare_test.go:193: cockroach1: ping: conn closed
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 147ca220b715dbaadef5a8689e1894feecda5358:
postgres_1 | CREATE INDEX ON table1 (col1_1, lower(CAST(col1_6 AS TEXT)) ASC, col1_9 DESC, col1_7, col1_11, col1_2 ASC);
postgres_1 | CREATE INDEX ON table1 (col1_9, col1_6 DESC, col1_10 ASC, col1_12, lower(CAST(col1_4 AS TEXT)), lower(CAST(col1_0 AS TEXT)) ASC, col1_7, col1_11 DESC, col1_1 ASC, col1_3 ASC, col1_4);
postgres_1 | CREATE INDEX ON table1 (col1_5, col1_8 ASC, col1_11 ASC);
postgres_1 | CREATE INDEX ON table1 (lower(CAST(col1_0 AS TEXT)) ASC, col1_7 DESC);
postgres_1 | CREATE INDEX ON table1 (col1_3 ASC, col1_4 ASC, col1_6, col1_5 DESC, col1_2, col1_11 ASC, col1_12 ASC, col1_1, col1_10 ASC, col1_7 DESC, col1_9 ASC, col1_8 ASC);
postgres_1 | CREATE INDEX ON table1 (col1_5 ASC, col1_1 ASC, col1_2 DESC);
postgres_1 | CREATE TABLE table2 (col2_0 REGROLE NULL, col2_1 REGCLASS NULL, col2_2 INT2[], col2_3 TIME NULL, col2_4 INT8 NULL, col2_5 FLOAT8 NULL, col2_6 REGNAMESPACE NOT NULL, col2_7 REGROLE NULL, col2_8 CHAR NULL, col2_9 GEOGRAPHY, col2_10 REGROLE NOT NULL, col2_11 DECIMAL NOT NULL, col2_12 GEOGRAPHY NULL, col2_13 REGPROC NOT NULL, col2_14 INT8 NULL GENERATED ALWAYS AS (col2_4 + (-9022043841025872529)::INT8) STORED, col2_15 DECIMAL NOT NULL GENERATED ALWAYS AS (col2_11 + 54980389502053.99772::DECIMAL) STORED, col2_16 TEXT GENERATED ALWAYS AS (lower(CAST(col2_9 AS TEXT))) STORED, col2_17 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_6 IS NULL THEN 'LW'::TEXT ELSE '=ph/=SFiD'::TEXT END) STORED, col2_18 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col2_1 IS NULL THEN 'SY?X:'::TEXT ELSE 'U'::TEXT END) STORED);
postgres_1 | CREATE TABLE table3 (col3_0 INT2 NULL, col3_1 GEOMETRY NOT NULL, col3_2 INT2 NULL GENERATED ALWAYS AS (col3_0 + 11822::INT8) STORED);
postgres_1 | CREATE UNIQUE INDEX ON table3 (col3_0, col3_2);
postgres_1 | CREATE UNIQUE INDEX ON table3 (col3_0 DESC);
postgres_1 | CREATE INDEX ON table3 (lower(CAST(col3_1 AS TEXT)) ASC, col3_0 ASC);
postgres_1 | CREATE TYPE rand_typ_0 AS ENUM ('djmsir', 'bvhqf', 'r', 'mmfxgz');
postgres_1 |
test_1 | --- FAIL: TestCompare (608.26s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (5.14s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 BOX2D NOT NULL, col1_1 CHAR NOT NULL, col1_2 BOOL NOT NULL, col1_3 INET NOT NULL, col1_4 TIMESTAMP NOT NULL, col1_5 INTERVAL NOT NULL, col1_6 TIMETZ NOT NULL, PRIMARY KEY (col1_6, col1_3, col1_5, col1_4, col1_1, col1_2), col1_7 TEXT NOT NULL GENERATED ALWAYS AS (lower(col1_1)) STORED, col1_8 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_4 IS NULL THEN e'\t{9'::TEXT ELSE e'q\x06*Sl'::TEXT END) STORED, col1_9 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_5 AS TEXT))) STORED, col1_10 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_0 AS TEXT))) STORED, col1_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_5 AS TEXT))) STORED, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_5 AS TEXT))) STORED);
test_1 | CREATE INDEX ON table1 (col1_1 DESC, col1_9 DESC, col1_6 ASC, lower(CAST(col1_3 AS TEXT)) ASC, col1_3, col1_2 DESC, col1_11, col1_7 ASC, col1_10) INCLUDE (col1_0, col1_8);
test_1 | CREATE UNIQUE INDEX ON table1 ((CASE WHEN col1_4 IS NULL THEN '%y#Ie'::TEXT ELSE e'\x03\'\x05s'::TEXT END) ASC, col1_7, col1_10 ASC, col1_1 ASC, col1_3, col1_5, col1_9 DESC, col1_11 ASC, col1_12 ASC, col1_2 DESC, col1_6 ASC, col1_4, col1_8 DESC);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_11, col1_5, col1_4 ASC, col1_7 ASC, col1_1, col1_6 DESC, col1_10 ASC, col1_8 ASC, col1_3 ASC, col1_9, col1_12, lower(CAST(col1_2 AS TEXT)) DESC);
test_1 | CREATE INDEX ON table1 (col1_1, lower(CAST(col1_6 AS TEXT)) ASC, col1_9 DESC, col1_7, col1_11, col1_2 ASC);
test_1 | CREATE INDEX ON table1 (col1_9, col1_6 DESC, col1_10 ASC, col1_12, lower(CAST(col1_4 AS TEXT)), lower(CAST(col1_0 AS TEXT)) ASC, col1_7, col1_11 DESC, col1_1 ASC, col1_3 ASC, col1_4);
test_1 | CREATE INDEX ON table1 (col1_5, col1_8 ASC, col1_11 ASC);
test_1 | CREATE INDEX ON table1 (lower(CAST(col1_0 AS TEXT)) ASC, col1_7 DESC);
test_1 | CREATE INDEX ON table1 (col1_3 ASC, col1_4 ASC, col1_6, col1_5 DESC, col1_2, col1_11 ASC, col1_12 ASC, col1_1, col1_10 ASC, col1_7 DESC, col1_9 ASC, col1_8 ASC);
test_1 | CREATE INDEX ON table1 (col1_5 ASC, col1_1 ASC, col1_2 DESC);
test_1 | CREATE TABLE table2 (col2_0 REGROLE NULL, col2_1 REGCLASS NULL, col2_2 INT2[], col2_3 TIME NULL, col2_4 INT8 NULL, col2_5 FLOAT8 NULL, col2_6 REGNAMESPACE NOT NULL, col2_7 REGROLE NULL, col2_8 CHAR NULL, col2_9 GEOGRAPHY, col2_10 REGROLE NOT NULL, col2_11 DECIMAL NOT NULL, col2_12 GEOGRAPHY NULL, col2_13 REGPROC NOT NULL, col2_14 INT8 NULL GENERATED ALWAYS AS (col2_4 + (-9022043841025872529)::INT8) STORED, col2_15 DECIMAL NOT NULL GENERATED ALWAYS AS (col2_11 + 54980389502053.99772::DECIMAL) STORED, col2_16 TEXT GENERATED ALWAYS AS (lower(CAST(col2_9 AS TEXT))) STORED, col2_17 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_6 IS NULL THEN 'LW'::TEXT ELSE '=ph/=SFiD'::TEXT END) STORED, col2_18 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col2_1 IS NULL THEN 'SY?X:'::TEXT ELSE 'U'::TEXT END) STORED);
test_1 | CREATE TABLE table3 (col3_0 INT2 NULL, col3_1 GEOMETRY NOT NULL, col3_2 INT2 NULL GENERATED ALWAYS AS (col3_0 + 11822::INT8) STORED);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_0, col3_2);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_0 DESC);
test_1 | CREATE INDEX ON table3 (lower(CAST(col3_1 AS TEXT)) ASC, col3_0 ASC);
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('djmsir', 'bvhqf', 'r', 'mmfxgz');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: functions in index expression must be marked IMMUTABLE (SQLSTATE 42P17)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ ec9330f86763371c445acdc317088e24cbcbaac3:
postgres_1 | 2021-12-24 06:15:44.532 UTC [50] LOG: shutting down
postgres_1 | 2021-12-24 06:15:44.631 UTC [48] LOG: database system is shut down
postgres_1 | done
postgres_1 | server stopped
postgres_1 |
postgres_1 | PostgreSQL init process complete; ready for start up.
postgres_1 |
postgres_1 | 2021-12-24 06:15:44.749 UTC [1] LOG: starting PostgreSQL 13.5 (Debian 13.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
postgres_1 | 2021-12-24 06:15:44.749 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
postgres_1 | 2021-12-24 06:15:44.749 UTC [1] LOG: listening on IPv6 address "::", port 5432
postgres_1 | 2021-12-24 06:15:44.753 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1 | 2021-12-24 06:15:44.758 UTC [67] LOG: database system was shut down at 2021-12-24 06:15:44 UTC
postgres_1 | 2021-12-24 06:15:44.763 UTC [1] LOG: database system is ready to accept connections
postgres_1 | 2021-12-24 06:15:46.216 UTC [77] ERROR: syntax error at or near "(" at character 498
postgres_1 | 2021-12-24 06:15:46.216 UTC [77] STATEMENT: CREATE TABLE table1 (col1_0 GEOGRAPHY NOT NULL, col1_1 REGNAMESPACE, col1_2 REGCLASS, col1_3 INT4);
postgres_1 | CREATE TABLE table2 (col2_0 REGROLE NOT NULL, col2_1 BOX2D NULL, col2_2 JSONB NULL, col2_3 GEOMETRY NULL, col2_4 OID, col2_5 TIMESTAMP NULL, col2_6 UUID NULL, col2_7 GEOMETRY, col2_8 BYTEA, col2_9 TIMETZ NOT NULL, col2_10 BOOL, col2_11 BIT(49) NOT NULL, col2_12 FLOAT8, col2_13 UUID, col2_14 TIMESTAMP, col2_15 FLOAT4 NOT NULL, col2_16 FLOAT4 GENERATED ALWAYS AS (col2_15 + col2_12) STORED, INDEX (col2_14) WHERE (((((((table2.col2_9 = '00:00:00+15:59:00'::TIMETZ) AND (table2.col2_15 > 1.0::FLOAT8)) OR (table2.col2_16 > 1.0::FLOAT8)) OR table2.col2_10) OR (table2.col2_14 = '0001-01-01 00:00:00'::TIMESTAMP)) OR (table2.col2_12 >= 1.7976931348623157e+308::FLOAT8)) AND (table2.col2_8 >= e'\\x27'::BYTEA)) AND (table2.col2_5 >= '-2000-01-01 00:00:00'::TIMESTAMP));
postgres_1 | CREATE TABLE table3 (col3_0 REGPROC NOT NULL, col3_1 "char" NOT NULL, col3_2 TIMESTAMP NULL, col3_3 VARCHAR NULL, col3_4 "char" NULL, col3_5 BOX2D, col3_6 NAME NOT NULL, col3_7 JSONB, col3_8 INTERVAL NOT NULL, col3_9 TIMESTAMP NULL, col3_10 DATE NULL, col3_11 REGPROC, col3_12 REGPROCEDURE NULL, col3_13 GEOMETRY NOT NULL, col3_14 TEXT NOT NULL GENERATED ALWAYS AS (lower(col3_6)) STORED, col3_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(col3_6)) STORED, col3_16 TEXT NULL GENERATED ALWAYS AS (lower(col3_4)) STORED, col3_17 TEXT GENERATED ALWAYS AS (lower(CAST(col3_7 AS TEXT))) STORED);
postgres_1 | CREATE TYPE rand_typ_0 AS ENUM ('kfrlk', 'lbue');
postgres_1 | CREATE TYPE rand_typ_1 AS ENUM ('wpij', 'pctfsr', 'jkcyc', 'db', 'cfp');
postgres_1 | CREATE TYPE rand_typ_2 AS ENUM ('d', 'vjohj');
postgres_1 | CREATE TYPE rand_typ_3 AS ENUM ('bjl', 'brlty', 'tl', 'vl', 'o', 'qyck');
postgres_1 |
test_1 | --- FAIL: TestCompare (604.46s)
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | --- FAIL: TestCompare/postgres (0.88s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 GEOGRAPHY NOT NULL, col1_1 REGNAMESPACE, col1_2 REGCLASS, col1_3 INT4);
test_1 | CREATE TABLE table2 (col2_0 REGROLE NOT NULL, col2_1 BOX2D NULL, col2_2 JSONB NULL, col2_3 GEOMETRY NULL, col2_4 OID, col2_5 TIMESTAMP NULL, col2_6 UUID NULL, col2_7 GEOMETRY, col2_8 BYTEA, col2_9 TIMETZ NOT NULL, col2_10 BOOL, col2_11 BIT(49) NOT NULL, col2_12 FLOAT8, col2_13 UUID, col2_14 TIMESTAMP, col2_15 FLOAT4 NOT NULL, col2_16 FLOAT4 GENERATED ALWAYS AS (col2_15 + col2_12) STORED, INDEX (col2_14) WHERE (((((((table2.col2_9 = '00:00:00+15:59:00'::TIMETZ) AND (table2.col2_15 > 1.0::FLOAT8)) OR (table2.col2_16 > 1.0::FLOAT8)) OR table2.col2_10) OR (table2.col2_14 = '0001-01-01 00:00:00'::TIMESTAMP)) OR (table2.col2_12 >= 1.7976931348623157e+308::FLOAT8)) AND (table2.col2_8 >= e'\\x27'::BYTEA)) AND (table2.col2_5 >= '-2000-01-01 00:00:00'::TIMESTAMP));
test_1 | CREATE TABLE table3 (col3_0 REGPROC NOT NULL, col3_1 "char" NOT NULL, col3_2 TIMESTAMP NULL, col3_3 VARCHAR NULL, col3_4 "char" NULL, col3_5 BOX2D, col3_6 NAME NOT NULL, col3_7 JSONB, col3_8 INTERVAL NOT NULL, col3_9 TIMESTAMP NULL, col3_10 DATE NULL, col3_11 REGPROC, col3_12 REGPROCEDURE NULL, col3_13 GEOMETRY NOT NULL, col3_14 TEXT NOT NULL GENERATED ALWAYS AS (lower(col3_6)) STORED, col3_15 TEXT NOT NULL GENERATED ALWAYS AS (lower(col3_6)) STORED, col3_16 TEXT NULL GENERATED ALWAYS AS (lower(col3_4)) STORED, col3_17 TEXT GENERATED ALWAYS AS (lower(CAST(col3_7 AS TEXT))) STORED);
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('kfrlk', 'lbue');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('wpij', 'pctfsr', 'jkcyc', 'db', 'cfp');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('d', 'vjohj');
test_1 | CREATE TYPE rand_typ_3 AS ENUM ('bjl', 'brlty', 'tl', 'vl', 'o', 'qyck');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: syntax error at or near "(" (SQLSTATE 42601)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 2c4bb88e5318fe187e1bf6cb134b31bd63f63528:
postgres_1 | (
postgres_1 | SELECT
postgres_1 | (NULL::GEOMETRY::GEOMETRY || tab_32733.col2_18::TEXT)::TEXT AS col_63396
postgres_1 | FROM
postgres_1 | postgres.public.table2 AS tab_32733
postgres_1 | )
postgres_1 | AS tab_32734
postgres_1 | ORDER BY
postgres_1 | col_63396 NULLS FIRST
test_1 | --- FAIL: TestCompare (684.74s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (80.59s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:183: compare cockroach1 to postgres:
test_1 | unexpected diff:
test_1 | []interface{}(Inverse(func1, []interface{}{
test_1 | - nil,
test_1 | + string("BOX(-135 45,-90 90)"),
test_1 | }))
test_1 | cockroach1:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('C':::STRING::STRING::STRING, NULL::INT4::INT4)::BOX2D AS col_63659) AS tab_32879
test_1 | ORDER BY
test_1 | CAST(col_63659 AS STRING) NULLS FIRST;
test_1 |
test_1 | postgres:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('C'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::BOX2D AS col_63659) AS tab_32879
test_1 | ORDER BY
test_1 | CAST(col_63659 AS TEXT) NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_postgres_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ c22ac33a023323cb76fde367b766ef988d6e27f7:
postgres_1 | 2021-12-30 06:16:31.524 UTC [1] LOG: database system is ready to accept connections
postgres_1 | 2021-12-30 06:16:34.609 UTC [78] ERROR: functions in index expression must be marked IMMUTABLE
postgres_1 | 2021-12-30 06:16:34.609 UTC [78] STATEMENT: CREATE TABLE table1 (col1_0 "char" NULL, col1_1 BYTEA, col1_2 REGPROC, col1_3 TEXT GENERATED ALWAYS AS (CASE WHEN col1_2 IS NULL THEN e'\x7fL\x1aH}EUyP'::TEXT ELSE e'ZI%6\x13w3h{'::TEXT END) STORED);
postgres_1 | CREATE INDEX ON table1 ((CASE WHEN col1_1 IS NULL THEN e'\f'::TEXT ELSE '}n0-y7J'::TEXT END) ASC, lower(CAST(col1_2 AS TEXT)) ASC) INCLUDE (col1_2);
postgres_1 | CREATE TABLE table2 (col2_0 CHAR NOT NULL, col2_1 GEOGRAPHY, col2_2 OID NULL, col2_3 REGPROC NOT NULL, col2_4 TIME, col2_5 BOOL NULL, col2_6 VARCHAR, col2_7 UUID NOT NULL, col2_8 TEXT[] NULL, col2_9 BYTEA NULL, col2_10 FLOAT8 NULL, col2_11 REGROLE, col2_12 BIT(11), col2_13 REGPROC NULL, col2_14 TEXT GENERATED ALWAYS AS (lower(CAST(col2_12 AS TEXT))) STORED, col2_15 TEXT GENERATED ALWAYS AS (lower(CAST(col2_4 AS TEXT))) STORED);
postgres_1 | CREATE INDEX ON table2 (col2_15 ASC, col2_13, col2_9, col2_12 DESC, col2_5 ASC, col2_10 ASC, col2_4 DESC, col2_11) INCLUDE (col2_1, col2_2, col2_7);
postgres_1 | CREATE UNIQUE INDEX ON table2 (col2_5 DESC, (CASE WHEN col2_8 IS NULL THEN 'c8Tb-'::TEXT ELSE e'^\x17Y\x19B!\tq$'::TEXT END), col2_6 DESC, col2_11, col2_7 DESC, col2_2, col2_12 ASC, col2_10 ASC, col2_9 DESC, col2_15 ASC) INCLUDE (col2_0, col2_3, col2_4);
postgres_1 | CREATE UNIQUE INDEX ON table2 (col2_0);
postgres_1 | CREATE UNIQUE INDEX ON table2 (col2_9, col2_2);
postgres_1 | ALTER TABLE table1 ADD FOREIGN KEY (col1_0) REFERENCES table2 (col2_0) ON DELETE CASCADE ON UPDATE CASCADE;
postgres_1 | ALTER TABLE table1 ADD FOREIGN KEY (col1_1, col1_2) REFERENCES table2 (col2_9, col2_2);
postgres_1 | CREATE TYPE rand_typ_0 AS ENUM ('ur', 'nf', 'j', 'yiom', 'an');
postgres_1 | CREATE TYPE rand_typ_1 AS ENUM ('xnoc', 'nthxum');
postgres_1 | CREATE TYPE rand_typ_2 AS ENUM ('j', 'rrj', 'wupct', 'kiygk', 'tznppo');
postgres_1 | CREATE TYPE rand_typ_3 AS ENUM ('xawf', 'uapx');
postgres_1 |
test_1 | --- FAIL: TestCompare (604.81s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (2.80s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 "char" NULL, col1_1 BYTEA, col1_2 REGPROC, col1_3 TEXT GENERATED ALWAYS AS (CASE WHEN col1_2 IS NULL THEN e'\x7fL\x1aH}EUyP'::TEXT ELSE e'ZI%6\x13w3h{'::TEXT END) STORED);
test_1 | CREATE INDEX ON table1 ((CASE WHEN col1_1 IS NULL THEN e'\f'::TEXT ELSE '}n0-y7J'::TEXT END) ASC, lower(CAST(col1_2 AS TEXT)) ASC) INCLUDE (col1_2);
test_1 | CREATE TABLE table2 (col2_0 CHAR NOT NULL, col2_1 GEOGRAPHY, col2_2 OID NULL, col2_3 REGPROC NOT NULL, col2_4 TIME, col2_5 BOOL NULL, col2_6 VARCHAR, col2_7 UUID NOT NULL, col2_8 TEXT[] NULL, col2_9 BYTEA NULL, col2_10 FLOAT8 NULL, col2_11 REGROLE, col2_12 BIT(11), col2_13 REGPROC NULL, col2_14 TEXT GENERATED ALWAYS AS (lower(CAST(col2_12 AS TEXT))) STORED, col2_15 TEXT GENERATED ALWAYS AS (lower(CAST(col2_4 AS TEXT))) STORED);
test_1 | CREATE INDEX ON table2 (col2_15 ASC, col2_13, col2_9, col2_12 DESC, col2_5 ASC, col2_10 ASC, col2_4 DESC, col2_11) INCLUDE (col2_1, col2_2, col2_7);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_5 DESC, (CASE WHEN col2_8 IS NULL THEN 'c8Tb-'::TEXT ELSE e'^\x17Y\x19B!\tq$'::TEXT END), col2_6 DESC, col2_11, col2_7 DESC, col2_2, col2_12 ASC, col2_10 ASC, col2_9 DESC, col2_15 ASC) INCLUDE (col2_0, col2_3, col2_4);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_0);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_9, col2_2);
test_1 | ALTER TABLE table1 ADD FOREIGN KEY (col1_0) REFERENCES table2 (col2_0) ON DELETE CASCADE ON UPDATE CASCADE;
test_1 | ALTER TABLE table1 ADD FOREIGN KEY (col1_1, col1_2) REFERENCES table2 (col2_9, col2_2);
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('ur', 'nf', 'j', 'yiom', 'an');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('xnoc', 'nthxum');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('j', 'rrj', 'wupct', 'kiygk', 'tznppo');
test_1 | CREATE TYPE rand_typ_3 AS ENUM ('xawf', 'uapx');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: functions in index expression must be marked IMMUTABLE (SQLSTATE 42P17)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_postgres_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ dc72c17f280dc20fa59970209c0e975e4072f91e:
test_1 | (
test_1 | SELECT
test_1 | 3::OID::OID AS col_242312,
test_1 | tab_125396.col1_3 AS col_242313,
test_1 | tab_125396.col1_4 AS col_242314,
test_1 | tab_125396.col1_11 AS col_242315,
test_1 | tab_125396.col1_12 AS col_242316,
test_1 | tab_125396.col1_2 AS col_242317,
test_1 | (tab_125396.col1_6::INET[] || '::/0'::INET::INET::INET)::INET[] AS col_242318
test_1 | FROM
test_1 | (
test_1 | VALUES
test_1 | (NULL::TIMESTAMPTZ),
test_1 | ('2000-01-01 07:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
test_1 | ('2000-01-01 02:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
test_1 | ('2000-01-01 08:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ),
test_1 | ('2000-01-01 07:00:00+00:00'::TIMESTAMPTZ::TIMESTAMPTZ)
test_1 | )
test_1 | AS tab_125395 (col_242311)
test_1 | LEFT JOIN postgres.public.table1 AS tab_125396 ON NULL::BOOL
test_1 | WHERE
test_1 | true::BOOL
test_1 | ORDER BY
test_1 | tab_125396.col1_7,
test_1 | tab_125395.col_242311 ASC,
test_1 | tab_125396.col1_4 DESC,
test_1 | tab_125396.col1_2 DESC,
test_1 | tab_125396.col1_3
test_1 | )
test_1 | AS tab_125397
test_1 | ORDER BY
test_1 | col_242312 NULLS FIRST,
test_1 | col_242313 NULLS FIRST,
test_1 | col_242314 NULLS FIRST,
test_1 | col_242315 NULLS FIRST,
test_1 | col_242316 NULLS FIRST,
test_1 | col_242317 NULLS FIRST,
test_1 | col_242318 NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ fb88f951323864fafd104e132cbf1f2f22f2e3ac:
postgres_1 | st_relatematch('C'::TEXT::TEXT::TEXT, 'D'::TEXT::TEXT::TEXT)::BOOL
postgres_1 | GROUP BY
postgres_1 | tab_29169.col4_1, tab_29169.col4_0
postgres_1 | ORDER BY
postgres_1 | tab_29169.col4_1 ASC, tab_29169.col4_0 DESC
postgres_1 | )
postgres_1 | AS tab_29170
postgres_1 | ORDER BY
postgres_1 | col_43080 NULLS FIRST
test_1 | --- FAIL: TestCompare (649.40s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (45.96s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:183: compare postgres to cockroach1:
test_1 | unexpected diff:
test_1 | []interface{}(Inverse(func1, []interface{}{
test_1 | - string("BOX(0 -90,45 -45)"),
test_1 | + nil,
test_1 | }))
test_1 | cockroach1:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('H':::STRING::STRING::STRING, NULL::INT4::INT4)::BOX2D AS col_43188) AS tab_29244
test_1 | ORDER BY
test_1 | CAST(col_43188 AS STRING) NULLS FIRST;
test_1 |
test_1 | postgres:
test_1 | SELECT
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('H'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::BOX2D AS col_43188) AS tab_29244
test_1 | ORDER BY
test_1 | CAST(col_43188 AS TEXT) NULLS FIRST;
test_1 |
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 0c8df44947208da2f6234d2736e8ab6d3b0937c0:
test_1 | (
test_1 | VALUES
test_1 | ('01:33:22.376917':::TIME),
test_1 | ('04:03:27.172455':::TIME),
test_1 | ('18:38:45.555543':::TIME)
test_1 | )
test_1 | AS tab_176813 (col_258104)
test_1 | )
test_1 | SELECT
test_1 | tab_176810.col1_3::INT8 AS col_258105
test_1 | FROM
test_1 | postgres.public.table2@table2_col2_0_idx1 AS tab_176814
test_1 | WHERE
test_1 | true
test_1 | )
test_1 | )
test_1 | AS tab_176815
test_1 | ORDER BY
test_1 | col_258106 NULLS FIRST,
test_1 | col_258107 NULLS FIRST,
test_1 | col_258108 NULLS FIRST,
test_1 | col_258109 NULLS FIRST,
test_1 | col_258110 NULLS FIRST,
test_1 | col_258111 NULLS FIRST,
test_1 | col_258112 NULLS FIRST,
test_1 | col_258113 NULLS FIRST,
test_1 | col_258114 NULLS FIRST,
test_1 | col_258115 NULLS FIRST,
test_1 | col_258116 NULLS FIRST,
test_1 | col_258117 NULLS FIRST,
test_1 | col_258118 NULLS FIRST,
test_1 | col_258119 NULLS FIRST,
test_1 | col_258120 NULLS FIRST,
test_1 | col_258121 NULLS FIRST,
test_1 | col_258122 NULLS FIRST,
test_1 | col_258123 NULLS FIRST,
test_1 | col_258124 NULLS FIRST,
test_1 | col_258125 NULLS FIRST
test_1 | compare_test.go:193: cockroach1: ping: conn closed
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_postgres_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 12c606395dc2cfb35bd82972ab65c4453f33c400:
test_1 | JOIN postgres.public.table1@[0] AS tab_196483
test_1 | JOIN postgres.public.table1@[0] AS tab_196484
test_1 | JOIN postgres.public.table1@primary AS tab_196485 ON
test_1 | (tab_196484.col1_11) = (tab_196485.col1_12) ON
test_1 | (tab_196483.col1_5) = (tab_196485.col1_5) ON
test_1 | (tab_196482.col1_12) = (tab_196485.col1_14) ON
test_1 | (tab_196478.col1_12) = (tab_196485.col1_12)
test_1 | AND (tab_196478.tableoid) = (tab_196484.tableoid)
test_1 | AND (tab_196478.col1_12) = (tab_196481.col1_11)
test_1 | AND (tab_196478.col1_9) = (tab_196481.col1_9) ON
test_1 | (tab_196477.col1_14) = (tab_196478.col1_13)
test_1 | AND (tab_196477.col1_7) = (tab_196483.col1_7)
test_1 | AND (tab_196477.col1_13) = (tab_196483.col1_13),
test_1 | postgres.public.table1@[0] AS tab_196486
test_1 | ORDER BY
test_1 | tab_196478.col1_1,
test_1 | tab_196484.col1_1 ASC,
test_1 | tab_196478.crdb_internal_mvcc_timestamp DESC,
test_1 | tab_196482.col1_0 ASC
test_1 | )
test_1 | AS tab_196487
test_1 | ORDER BY
test_1 | col_340147 NULLS FIRST,
test_1 | col_340148 NULLS FIRST,
test_1 | col_340149 NULLS FIRST,
test_1 | col_340150 NULLS FIRST,
test_1 | col_340151 NULLS FIRST,
test_1 | col_340152 NULLS FIRST,
test_1 | col_340153 NULLS FIRST,
test_1 | col_340154 NULLS FIRST,
test_1 | col_340155 NULLS FIRST,
test_1 | col_340156 NULLS FIRST,
test_1 | col_340157 NULLS FIRST,
test_1 | col_340158 NULLS FIRST,
test_1 | col_340159 NULLS FIRST,
test_1 | col_340160 NULLS FIRST,
test_1 | col_340161 NULLS FIRST,
test_1 | col_340162 NULLS FIRST
test_1 | compare_test.go:193: cockroach1: ping: conn closed
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ f26513f0b00c95e2e98d5ce3032abd7e65ff0e3d:
postgres_1 | CREATE TYPE rand_typ_1 AS ENUM ('f', 'idg', 'xhh');
postgres_1 | CREATE TYPE rand_typ_2 AS ENUM ('xyo', 'zpy', 'qbua', 'cvh');
postgres_1 | CREATE TYPE rand_typ_3 AS ENUM ('czvtx', 'bw', 'q');
postgres_1 |
test_1 | --- FAIL: TestCompare (608.98s)
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | --- FAIL: TestCompare/postgres (5.55s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 REGPROCEDURE NULL, col1_1 INT4, col1_2 "char", col1_3 GEOMETRY NULL, col1_4 REGPROCEDURE NULL, col1_5 UUID NULL, col1_6 BIT(43) NULL, col1_7 REGNAMESPACE, col1_8 GEOMETRY, col1_9 TIMESTAMP NULL, col1_10 REGROLE NULL, col1_11 FLOAT8 NOT NULL, col1_12 "char", col1_13 INT2 NULL, col1_14 BYTEA NULL, col1_15 TEXT, col1_16 FLOAT4 NULL, col1_17 REGROLE NULL, col1_18 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col1_0 IS NULL THEN e'jz(\x1ef>\x1b/}'::TEXT ELSE e'\''::TEXT END) STORED);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_6 DESC, col1_12, col1_10 ASC, (col1_11 + col1_16) ASC, col1_13, col1_4 ASC, (CASE WHEN col1_14 IS NULL THEN 'Q;pCfI;gG'::TEXT ELSE e'\rba3\x10j'::TEXT END) DESC) INCLUDE (col1_1, col1_3, col1_5, col1_8, col1_16);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_11, col1_16, col1_2 ASC, col1_14 ASC, col1_12 DESC, col1_5 ASC, col1_18, col1_6 DESC, col1_17 ASC, col1_7 DESC, col1_13 ASC, col1_9 DESC, (CASE WHEN col1_14 IS NULL THEN e'-\x19\x02dP~>!%'::TEXT ELSE ''::TEXT END) ASC) INCLUDE (col1_0, col1_1, col1_4, col1_10);
test_1 | CREATE TABLE table2 (col2_0 DECIMAL NULL, col2_1 GEOGRAPHY NULL, col2_2 INT2, col2_3 BOOL NULL, col2_4 BOX2D NULL, col2_5 OID NOT NULL, col2_6 DATE NULL, col2_7 BOOL NOT NULL, col2_8 INT2 GENERATED ALWAYS AS (col2_2 + 2509::INT8) STORED, col2_9 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_1 AS TEXT))) STORED, col2_10 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_3 AS TEXT))) STORED, col2_11 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col2_4 AS TEXT))) STORED, col2_12 TEXT NULL GENERATED ALWAYS AS (CASE WHEN col2_6 IS NULL THEN e'Sa\\'::TEXT ELSE e'\x10t'::TEXT END) STORED, col2_13 DECIMAL NULL GENERATED ALWAYS AS (col2_0 + (-3.282095538818727175E+30)::DECIMAL) STORED);
test_1 | CREATE INDEX ON table2 (col2_13, col2_9 ASC, (col2_0 + 64483532720.89331766::DECIMAL) ASC, col2_11, col2_3 ASC, col2_7, col2_10 DESC) INCLUDE (col2_1, col2_2, col2_4, col2_6);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_11 ASC, lower(CAST(col2_7 AS TEXT)) ASC);
test_1 | CREATE INDEX ON table2 (col2_9 ASC, lower(CAST(col2_6 AS TEXT)) DESC, col2_6 DESC) INCLUDE (col2_1, col2_2, col2_3, col2_5, col2_7, col2_12, col2_13);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_9) INCLUDE (col2_1, col2_4, col2_5, col2_6, col2_7, col2_13);
test_1 | CREATE INDEX ON table2 ((col2_0 + 'Infinity'::DECIMAL), col2_0 ASC, col2_10 DESC, col2_3 DESC, col2_2 ASC, col2_5 ASC, col2_7 DESC, lower(CAST(col2_1 AS TEXT)) ASC, col2_13 ASC, col2_9 DESC);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_2 ASC, col2_12 DESC, lower(CAST(col2_7 AS TEXT)), col2_3 DESC, col2_5, col2_8 DESC, col2_7 DESC, col2_0, col2_6 ASC, col2_9 ASC, col2_13 ASC, col2_10 ASC);
test_1 | CREATE TABLE table3 (col3_0 TEXT, col3_1 REGNAMESPACE NULL, col3_2 OID NOT NULL, col3_3 INT2 NULL, col3_4 OID NULL, col3_5 REGNAMESPACE, col3_6 TIMESTAMP, col3_7 REGTYPE, col3_8 FLOAT8 NULL, col3_9 BOX2D NOT NULL, col3_10 CHAR NOT NULL, PRIMARY KEY (col3_10), col3_11 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col3_9 AS TEXT))) STORED);
test_1 | CREATE INDEX ON table3 (col3_11 ASC, col3_7, (col3_3 + 16218::INT8), col3_6 DESC, col3_2 ASC) INCLUDE (col3_0, col3_1, col3_3, col3_4, col3_8);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_10 DESC);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_2, (CASE WHEN col3_2 IS NULL THEN '3``lP&{'::TEXT ELSE e'\x05\x1a\x06'::TEXT END) ASC, col3_7 DESC, col3_0 ASC, col3_10 ASC, col3_3 DESC, col3_8, col3_6 DESC, col3_1 ASC, col3_5 DESC, col3_4 ASC);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_5, col3_4 DESC) INCLUDE (col3_1, col3_2, col3_6, col3_9);
test_1 | CREATE INDEX ON table3 (col3_6, col3_11, col3_5 DESC, col3_8 DESC, col3_2 ASC, col3_1 ASC, col3_10, col3_0 ASC, lower(col3_10) ASC, col3_4 ASC);
test_1 | CREATE TABLE table4 (col4_0 "char"[] NOT NULL, col4_1 INT8 NOT NULL, col4_2 REGROLE NOT NULL, col4_3 REGCLASS, col4_4 DECIMAL NOT NULL, col4_5 GEOMETRY NOT NULL, col4_6 INT8, col4_7 UUID NOT NULL, col4_8 BOOL, col4_9 GEOGRAPHY, col4_10 DATE NOT NULL, col4_11 OID NULL, col4_12 TEXT GENERATED ALWAYS AS (lower(CAST(col4_9 AS TEXT))) STORED, col4_13 INT8 GENERATED ALWAYS AS (col4_6 + col4_1) STORED);
test_1 | CREATE UNIQUE INDEX ON table4 ((col4_1 + col4_6) ASC, col4_1 ASC) INCLUDE (col4_3, col4_4, col4_8, col4_13);
test_1 | CREATE INDEX ON table4 (col4_3 DESC, col4_11);
test_1 | CREATE UNIQUE INDEX ON table4 (col4_2);
test_1 | ALTER TABLE table3 ADD FOREIGN KEY (col3_1) REFERENCES table4 (col4_2) ON UPDATE CASCADE;
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('qlplih');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('f', 'idg', 'xhh');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('xyo', 'zpy', 'qbua', 'cvh');
test_1 | CREATE TYPE rand_typ_3 AS ENUM ('czvtx', 'bw', 'q');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: functions in index expression must be marked IMMUTABLE (SQLSTATE 42P17)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_postgres_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ aabce20e9f7a7f00323605d976c8d4db799273c9:
postgres_1 | CREATE TYPE rand_typ_1 AS ENUM ('iv', 'mnhs', 'hte', 'ysni', 'hgkzpw');
postgres_1 | CREATE TYPE rand_typ_2 AS ENUM ('dt', 'qn');
postgres_1 | CREATE TYPE rand_typ_3 AS ENUM ('umctxx', 'ino', 'tysmj', 'cugtbn', 'su', 'egnzp');
postgres_1 |
test_1 | --- FAIL: TestCompare (609.67s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (5.70s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 DECIMAL NOT NULL, col1_1 REGCLASS NOT NULL, col1_2 CHAR NOT NULL, col1_3 BOX2D NOT NULL, col1_4 REGPROCEDURE NOT NULL, col1_5 INT2 NOT NULL, col1_6 REGNAMESPACE NOT NULL, col1_7 BYTEA NOT NULL, col1_8 "char" NOT NULL, col1_9 REGCLASS NOT NULL, col1_10 UUID NOT NULL, PRIMARY KEY (col1_9, col1_1, col1_0, col1_7, col1_4, col1_6, col1_10, col1_2, col1_5), col1_11 DECIMAL NOT NULL GENERATED ALWAYS AS (col1_0 + (-2.891998222617653437E+30)::DECIMAL) STORED, col1_12 TEXT NOT NULL GENERATED ALWAYS AS (lower(col1_8)) STORED, col1_13 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_7 IS NULL THEN ''::TEXT ELSE '~cLQRYPA'::TEXT END) STORED, col1_14 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_1 IS NULL THEN ''::TEXT ELSE ''::TEXT END) STORED, col1_15 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col1_7 IS NULL THEN e'qE\x0f}|\x1e\x05<z'::TEXT ELSE 'GlnW]'::TEXT END) STORED, col1_16 INT2 NOT NULL GENERATED ALWAYS AS (col1_5 + (-7498)::INT8) STORED, col1_17 DECIMAL NOT NULL GENERATED ALWAYS AS (col1_0 + 7.659054876802400882::DECIMAL) STORED, col1_18 TEXT NOT NULL GENERATED ALWAYS AS (lower(CAST(col1_10 AS TEXT))) STORED);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_4, col1_11 ASC, col1_7 DESC, lower(CAST(col1_3 AS TEXT)) DESC, col1_16 ASC, col1_15 DESC, col1_14 ASC, col1_0 ASC, col1_5 DESC, col1_13, col1_1);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_10 ASC, lower(col1_8) ASC, col1_4 DESC, col1_0, col1_18 DESC, col1_15, col1_2 ASC, col1_5 ASC, col1_17) INCLUDE (col1_8, col1_16);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_14 ASC, col1_15 ASC);
test_1 | CREATE INDEX ON table1 (col1_10, col1_5 DESC, col1_0 DESC, col1_7 ASC, col1_12 ASC, col1_15 ASC, col1_13, col1_17 DESC, col1_2 DESC, col1_18 DESC) INCLUDE (col1_8);
test_1 | CREATE UNIQUE INDEX ON table1 (lower(CAST(col1_3 AS TEXT)), col1_9 DESC, col1_2 DESC, col1_15 ASC, col1_11 ASC, col1_14 ASC) INCLUDE (col1_16);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_8 DESC, col1_15, col1_6, col1_7 DESC, col1_2 ASC, col1_1 ASC, col1_0 DESC, lower(col1_8) ASC, col1_11 ASC, col1_5 DESC, col1_12 DESC) INCLUDE (col1_16);
test_1 | CREATE INDEX ON table1 (col1_8 ASC, col1_17 DESC, col1_7 ASC) INCLUDE (col1_16);
test_1 | CREATE INDEX ON table1 (col1_9 DESC, col1_16 ASC, col1_10 ASC, col1_7 ASC, col1_18, col1_17, col1_13);
test_1 | CREATE TABLE table2 (col2_0 VARCHAR NOT NULL, col2_1 INT8 NOT NULL, col2_2 DECIMAL NOT NULL, col2_3 TIME NOT NULL, col2_4 REGROLE NOT NULL, col2_5 TEXT NOT NULL, col2_6 FLOAT4 NOT NULL, col2_7 REGNAMESPACE, col2_8 CHAR NOT NULL, col2_9 DECIMAL NOT NULL, col2_10 BIT(17) NULL, col2_11 REGPROCEDURE NOT NULL, PRIMARY KEY (col2_3, col2_9, col2_5, col2_4, col2_2, col2_6, col2_0), col2_12 DECIMAL NOT NULL GENERATED ALWAYS AS (col2_2 + col2_9) STORED, col2_13 DECIMAL NOT NULL GENERATED ALWAYS AS (col2_9 + col2_2) STORED, col2_14 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_4 IS NULL THEN e',\x13vS( '::TEXT ELSE e'3\x16\x1ab}In\x1f'::TEXT END) STORED, col2_15 TEXT NOT NULL GENERATED ALWAYS AS (CASE WHEN col2_4 IS NULL THEN e'\x1f'::TEXT ELSE ''::TEXT END) STORED, col2_16 FLOAT4 NOT NULL GENERATED ALWAYS AS (col2_6 + 0.09077384322881699::FLOAT8) STORED);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_16 DESC, col2_9 DESC, col2_11, col2_1 ASC, col2_7 ASC, col2_10, col2_3 ASC, col2_15, col2_13 DESC) INCLUDE (col2_8);
test_1 | CREATE INDEX ON table2 (col2_11, col2_1 DESC, col2_13 ASC, (col2_1 + 1::INT8) ASC, lower(col2_5) ASC, col2_0 DESC, col2_14, col2_9 DESC, col2_4 ASC, col2_16 DESC);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_10 DESC, col2_13 ASC, lower(col2_5) ASC, col2_8 DESC, (col2_6 + 0.8334824442863464::FLOAT8) ASC, col2_5, col2_15 DESC) INCLUDE (col2_7, col2_11, col2_16);
test_1 | CREATE INDEX ON table2 (col2_8 DESC, lower(CAST(col2_4 AS TEXT)));
test_1 | CREATE UNIQUE INDEX ON table2 (col2_0 ASC, col2_1 DESC, col2_4, col2_2, col2_10 ASC, col2_3, col2_9 ASC, col2_16 ASC, col2_12 DESC, col2_7 ASC, col2_6 ASC, (col2_2 + col2_9), col2_5 ASC, col2_15, col2_11 ASC) INCLUDE (col2_8);
test_1 | CREATE TABLE table3 (col3_0 CHAR NOT NULL, col3_1 REGTYPE, col3_2 INT8, col3_3 BOOL, col3_4 TIMETZ NULL, col3_5 GEOMETRY[], col3_6 REGCLASS, col3_7 INET, col3_8 REGNAMESPACE, col3_9 REGNAMESPACE NOT NULL, col3_10 "char" NULL, col3_11 "char" NULL, col3_12 TEXT GENERATED ALWAYS AS (CASE WHEN col3_1 IS NULL THEN e'a\x07\x1fy\x18\x117F\x1d'::TEXT ELSE e'\b?n0DotY'::TEXT END) STORED);
test_1 | CREATE INDEX ON table3 (col3_12 DESC, col3_6 ASC, col3_10 ASC, col3_2 DESC, col3_4, col3_3 ASC, col3_9 DESC, col3_11 DESC, col3_8 DESC);
test_1 | CREATE TABLE table4 (col4_0 INT2 NOT NULL, col4_1 REGNAMESPACE, col4_2 UUID NULL, col4_3 REGCLASS NULL, col4_4 GEOMETRY NOT NULL, col4_5 BYTEA NULL, col4_6 TEXT NULL GENERATED ALWAYS AS (lower(CAST(col4_2 AS TEXT))) STORED);
test_1 | CREATE INDEX ON table4 (col4_2 DESC) INCLUDE (col4_0, col4_6);
test_1 | CREATE UNIQUE INDEX ON table4 (col4_6 DESC, col4_2 DESC, col4_0 ASC, col4_3 ASC) INCLUDE (col4_1);
test_1 | CREATE INDEX ON table4 (col4_6, col4_0 ASC) INCLUDE (col4_1, col4_3, col4_4);
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('hne', 'svjjf', 'ngizkl', 'wru', 'kqkzfl');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('iv', 'mnhs', 'hte', 'ysni', 'hgkzpw');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('dt', 'qn');
test_1 | CREATE TYPE rand_typ_3 AS ENUM ('umctxx', 'ino', 'tysmj', 'cugtbn', 'su', 'egnzp');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: functions in index expression must be marked IMMUTABLE (SQLSTATE 42P17)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_postgres_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 3082c28f2dae9540c4f69ab2ffd6a1d92982b4fe:
test_1 | *
test_1 | FROM
test_1 | (SELECT st_box2dfromgeohash('H'::TEXT::TEXT::TEXT, NULL::INT4::INT4)::BOX2D AS col_256928) AS tab_169408
test_1 | ORDER BY
test_1 | CAST(col_256928 AS TEXT) NULLS FIRST;
test_1 |
test_1 | --- FAIL: TestCompare/mutators (0.55s)
test_1 | compare_test.go:125: starting test: mutators
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: cockroach2
test_1 | panic: geos: no locations to init GEOS [recovered]
test_1 | panic: geos: no locations to init GEOS
test_1 |
test_1 | goroutine 316361 [running]:
test_1 | testing.tRunner.func1.2(0x1fbd3c0, 0xc000c70be0)
test_1 | /usr/local/go/src/testing/testing.go:1143 +0x332
test_1 | testing.tRunner.func1(0xc000af2000)
test_1 | /usr/local/go/src/testing/testing.go:1146 +0x4b6
test_1 | panic(0x1fbd3c0, 0xc000c70be0)
test_1 | /usr/local/go/src/runtime/panic.go:965 +0x1b9
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.encodeInvertedIndexHistogramUpperBounds(0x4079fc0, 0x31c3198, 0xc000c98f00, 0x31c3198, 0xc000c98f00, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:368 +0x5d3
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.randHistogram(0xc000d06060, 0x4079fc0, 0x0, 0x0, 0x0, 0x0, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:301 +0x17f
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator.func1(0xc000c14000)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:220 +0x9e
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.statisticsMutator(0xc000d06060, 0xc0004abe00, 0x13, 0x13, 0x80, 0xc000bcd100, 0xc000a1b998, 0x4358bf)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:251 +0xbeb
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.MultiStatementMutation.Mutate(0x26b8c10, 0xc000d06060, 0xc0004abe00, 0x13, 0x13, 0x7fa42fee5ed0, 0xc000a1b9c8, 0x436cca, 0x1f02900)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:97 +0x4e
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.Apply(0xc000d06060, 0xc0004abe00, 0x13, 0x13, 0xc000bcd100, 0x6, 0x8, 0x8, 0x0, 0x0, ...)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:108 +0xad
test_1 | github.com/cockroachdb/cockroach/pkg/sql/randgen.ApplyString(0xc000d06060, 0xc0009e8000, 0x5546, 0xc000382c60, 0x6, 0x6, 0x0, 0x6, 0x0)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/sql/randgen/mutator.go:159 +0x2e5
test_1 | github.com/cockroachdb/cockroach/pkg/compose/compare/compare.TestCompare.func2(0xc000af2000)
test_1 | /go/src/github.com/cockroachdb/cockroach/pkg/compose/compare/compare/compare_test.go:151 +0x2db
test_1 | testing.tRunner(0xc000af2000, 0xc000d06000)
test_1 | /usr/local/go/src/testing/testing.go:1193 +0xef
test_1 | created by testing.(*T).Run
test_1 | /usr/local/go/src/testing/testing.go:1238 +0x2b3
compare_test_1 exited with code 2
Stopping compare_postgres_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 2
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ f6e5974d563c2700dc68c2f71d4fc05ee1adea6b:
postgres_1 | CREATE TYPE rand_typ_4 AS ENUM ('bv', 'ei', 'kgkb');
postgres_1 |
test_1 | --- FAIL: TestCompare (609.63s)
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | --- FAIL: TestCompare/postgres (5.88s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 BOX2D NOT NULL);
test_1 | CREATE UNIQUE INDEX ON table1 (lower(CAST(col1_0 AS TEXT)));
test_1 | CREATE TABLE table2 (col2_0 "char" NOT NULL, col2_1 "char" NULL, PRIMARY KEY (col2_0), col2_2 TEXT NULL GENERATED ALWAYS AS (lower(col2_1)) STORED);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_1, col2_2 DESC);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_0, col2_2 ASC);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_2 ASC, col2_1 ASC, col2_0);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_1 ASC, col2_0 ASC) INCLUDE (col2_2);
test_1 | CREATE UNIQUE INDEX ON table2 (col2_0, col2_1 ASC, col2_2);
test_1 | CREATE TABLE table3 (col3_0 NAME, col3_1 CHAR, col3_2 NAME NOT NULL, col3_3 TEXT, col3_4 INTERVAL, col3_5 TIMESTAMP, col3_6 BOX2D, col3_7 TEXT GENERATED ALWAYS AS (lower(CAST(col3_6 AS TEXT))) STORED, col3_8 TEXT GENERATED ALWAYS AS (lower(CAST(col3_6 AS TEXT))) STORED, col3_9 TEXT GENERATED ALWAYS AS (lower(CAST(col3_4 AS TEXT))) STORED);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_2 DESC, col3_3, (CASE WHEN col3_5 IS NULL THEN e'_D \nD3k.'::TEXT ELSE e'\x14T?{d\x137'::TEXT END) ASC, col3_1 ASC, col3_0 DESC, col3_8) INCLUDE (col3_4, col3_6, col3_9);
test_1 | CREATE INDEX ON table3 (col3_8 ASC, col3_2 DESC, col3_9 DESC, col3_7, col3_0 DESC, lower(col3_1) ASC, col3_3 DESC, col3_4 DESC);
test_1 | CREATE INDEX ON table3 (col3_8 DESC, lower(CAST(col3_5 AS TEXT)) DESC, col3_4 ASC, lower(col3_2), col3_1 ASC);
test_1 | CREATE INDEX ON table3 (col3_8, lower(col3_2), col3_0 ASC, col3_2 DESC, col3_4 ASC, col3_5 ASC, col3_3 ASC);
test_1 | CREATE INDEX ON table3 (lower(col3_2) ASC, col3_4 DESC, col3_3, lower(col3_1), col3_1 ASC, col3_0 DESC, col3_2 ASC, col3_7 DESC, lower(CAST(col3_6 AS TEXT)) DESC);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_2 ASC, col3_7 DESC, col3_5, col3_3 DESC, col3_9, col3_4 ASC, col3_1 ASC, lower(col3_3)) INCLUDE (col3_0);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_4, col3_7 DESC, col3_3) INCLUDE (col3_5, col3_9);
test_1 | CREATE TABLE table4 (col4_0 TIMETZ[], col4_1 BOOL NOT NULL, col4_2 INT4 NOT NULL, PRIMARY KEY (col4_1), col4_3 TEXT GENERATED ALWAYS AS (CASE WHEN col4_0 IS NULL THEN e'WA?k\t'::TEXT ELSE ''::TEXT END) STORED, col4_4 INT4 NOT NULL GENERATED ALWAYS AS (col4_2 + 382394639::INT8) STORED);
test_1 | CREATE INDEX ON table4 (col4_4, col4_2, col4_1);
test_1 | CREATE UNIQUE INDEX ON table4 (col4_2);
test_1 | CREATE TABLE table5 (col5_0 INT2, col5_1 UUID NOT NULL, col5_2 NAME, col5_3 BIT(6) NULL, col5_4 GEOGRAPHY NOT NULL, col5_5 TIMESTAMPTZ NOT NULL, col5_6 INT2 NOT NULL, col5_7 BIT(46), col5_8 INT2 NULL, col5_9 GEOGRAPHY, col5_10 INT2 GENERATED ALWAYS AS (col5_0 + col5_6) STORED, col5_11 INT2 NULL GENERATED ALWAYS AS ((col5_6 + col5_8) + col5_0) STORED, col5_12 INT2 NULL GENERATED ALWAYS AS ((col5_8 + col5_0) + col5_6) STORED, col5_13 TEXT GENERATED ALWAYS AS (lower(col5_2)) STORED, col5_14 TEXT GENERATED ALWAYS AS (lower(col5_2)) STORED, col5_15 INT2 GENERATED ALWAYS AS ((col5_0 + col5_6) + col5_8) STORED, col5_16 INT2 NULL GENERATED ALWAYS AS (col5_8 + (-9526)::INT8) STORED);
test_1 | CREATE UNIQUE INDEX ON table5 (col5_13, col5_14 DESC);
test_1 | ALTER TABLE table5 ADD FOREIGN KEY (col5_0) REFERENCES table4 (col4_2);
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('ehyd', 'xiri', 'k', 'deh');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('ae', 'k');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('pqxj', 'ev', 'qb', 'lt', 's');
test_1 | CREATE TYPE rand_typ_3 AS ENUM ('ars', 'ai');
test_1 | CREATE TYPE rand_typ_4 AS ENUM ('bv', 'ei', 'kgkb');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: functions in index expression must be marked IMMUTABLE (SQLSTATE 42P17)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_postgres_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ b4a27f3634e3e41dc3966214cf05ff6870c055c5:
test_1 | tab_131882.tableoid AS col_176814,
test_1 | '':::STRING AS col_176815,
test_1 | tab_131881.col1_1 AS col_176816
test_1 | FROM
test_1 | postgres.public.table1@table1_col1_0_col1_2_idx AS tab_131875,
test_1 | postgres.public.table1@primary AS tab_131876,
test_1 | postgres.public.table1 AS tab_131877
test_1 | JOIN postgres.public.table1 AS tab_131878 ON (tab_131877.col1_0) = (tab_131878.col1_0)
test_1 | JOIN postgres.public.table1@table1_col1_0_col1_1_col1_2_idx AS tab_131879
test_1 | JOIN postgres.public.table1 AS tab_131880
test_1 | JOIN postgres.public.table1 AS tab_131881 ON (tab_131880.col1_2) = (tab_131881.col1_2)
test_1 | JOIN postgres.public.table1@[0] AS tab_131882 ON
test_1 | (tab_131880.col1_1) = (tab_131882.col1_1) AND (tab_131881.col1_1) = (tab_131882.col1_1) ON
test_1 | (tab_131879.col1_0) = (tab_131882.col1_0)
test_1 | AND (tab_131879.col1_1) = (tab_131881.col1_1)
test_1 | AND (tab_131879.col1_2) = (tab_131881.col1_1)
test_1 | JOIN postgres.public.table1@table1_col1_0_col1_2_idx AS tab_131883 ON true ON
test_1 | (tab_131877.col1_0) = (tab_131883.col1_0) AND (tab_131877.col1_0) = (tab_131882.col1_0)
test_1 | WHERE
test_1 | true
test_1 | ORDER BY
test_1 | tab_131880.col1_1 DESC, tab_131882.col1_1
test_1 | )
test_1 | AS tab_131884
test_1 | ORDER BY
test_1 | col_176804 NULLS FIRST,
test_1 | col_176805 NULLS FIRST,
test_1 | col_176806 NULLS FIRST,
test_1 | col_176807 NULLS FIRST,
test_1 | col_176808 NULLS FIRST,
test_1 | col_176809 NULLS FIRST,
test_1 | col_176810 NULLS FIRST,
test_1 | col_176811 NULLS FIRST,
test_1 | col_176812 NULLS FIRST,
test_1 | col_176813 NULLS FIRST,
test_1 | col_176814 NULLS FIRST,
test_1 | col_176815 NULLS FIRST,
test_1 | col_176816 NULLS FIRST
test_1 | compare_test.go:193: cockroach1: ping: conn closed
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 66442488fcc9c61af6ce438d1bac91cd47f74529:
postgres_1 | CREATE TABLE table2 (col2_0 OID NOT NULL, col2_1 DECIMAL, col2_2 INET NOT NULL, col2_3 DATE NULL, col2_4 GEOGRAPHY NULL, col2_5 DATE NOT NULL, col2_6 REGPROC NOT NULL, col2_7 CHAR, col2_8 REGNAMESPACE NOT NULL, PRIMARY KEY (col2_6), col2_9 TEXT GENERATED ALWAYS AS (lower(col2_7)) STORED);
postgres_1 | CREATE TABLE table3 (col3_0 OID NULL, col3_1 BIT(49) NOT NULL, col3_2 FLOAT8 NULL, col3_3 REGNAMESPACE, col3_4 DECIMAL NOT NULL, col3_5 TIMESTAMP NULL, col3_6 TIMESTAMPTZ NOT NULL, col3_7 GEOGRAPHY, col3_8 "char" NULL, col3_9 REGNAMESPACE, col3_10 DECIMAL NOT NULL GENERATED ALWAYS AS (col3_4 + 3.972812815656753664E+27::DECIMAL) STORED, col3_11 FLOAT8 NULL GENERATED ALWAYS AS (col3_2 + '+Inf'::FLOAT8) STORED);
postgres_1 | CREATE UNIQUE INDEX ON table3 (col3_9, col3_0, col3_2 DESC, (CASE WHEN col3_0 IS NULL THEN e'c-\r\'3\x1f'::TEXT ELSE e'\x07\x10'::TEXT END) ASC, col3_11 DESC, col3_1 ASC, col3_6 DESC, col3_10 ASC, col3_4 DESC, (col3_4 + 36217802999305706.21::DECIMAL) DESC, col3_5 DESC, col3_8 ASC);
postgres_1 | CREATE TABLE table4 (col4_0 FLOAT4 NOT NULL, col4_1 JSONB NULL, col4_2 INT4 NOT NULL);
postgres_1 | CREATE TABLE table5 (col5_0 INT2 NOT NULL, PRIMARY KEY (col5_0));
postgres_1 | CREATE UNIQUE INDEX ON table5 (col5_0 DESC);
postgres_1 | CREATE INDEX ON table5 (col5_0);
postgres_1 | CREATE INDEX ON table5 (col5_0);
postgres_1 | CREATE INDEX ON table5 (col5_0 ASC);
postgres_1 | CREATE UNIQUE INDEX ON table5 (col5_0);
postgres_1 | ALTER TABLE table2 ADD FOREIGN KEY (col2_0) REFERENCES table1 (col1_2);
postgres_1 | CREATE TYPE rand_typ_0 AS ENUM ('umqia');
postgres_1 |
test_1 | --- FAIL: TestCompare (607.21s)
test_1 | compare_test.go:116: Checking connection to: postgres
test_1 | compare_test.go:116: Checking connection to: cockroach1
test_1 | compare_test.go:116: Checking connection to: cockroach2
test_1 | --- FAIL: TestCompare/postgres (3.51s)
test_1 | compare_test.go:125: starting test: postgres
test_1 | compare_test.go:132: initializing connection: cockroach1
test_1 | compare_test.go:132: initializing connection: postgres
test_1 | compare_test.go:153: CREATE TABLE table1 (col1_0 INT2 NOT NULL, col1_1 JSONB, col1_2 REGROLE NOT NULL, col1_3 INET NOT NULL, col1_4 TIME NOT NULL, col1_5 REGTYPE NULL, col1_6 REGROLE, col1_7 BIT(31) NULL, col1_8 OID, col1_9 BIT(45) NULL, col1_10 GEOMETRY[], col1_11 REGCLASS NULL, col1_12 BIT(17) NOT NULL, col1_13 OID NOT NULL);
test_1 | CREATE INDEX ON table1 (col1_5 DESC, col1_8, col1_4 DESC, col1_9 ASC, col1_0 ASC, col1_13 ASC, col1_11 ASC, col1_6 ASC, col1_7 ASC, col1_12 ASC) INCLUDE (col1_10);
test_1 | CREATE INDEX ON table1 (col1_6 ASC, col1_8 DESC, lower(CAST(col1_6 AS TEXT)) DESC, col1_4 ASC) INCLUDE (col1_1, col1_2, col1_9, col1_10, col1_12);
test_1 | CREATE UNIQUE INDEX ON table1 (col1_2);
test_1 | CREATE TABLE table2 (col2_0 OID NOT NULL, col2_1 DECIMAL, col2_2 INET NOT NULL, col2_3 DATE NULL, col2_4 GEOGRAPHY NULL, col2_5 DATE NOT NULL, col2_6 REGPROC NOT NULL, col2_7 CHAR, col2_8 REGNAMESPACE NOT NULL, PRIMARY KEY (col2_6), col2_9 TEXT GENERATED ALWAYS AS (lower(col2_7)) STORED);
test_1 | CREATE TABLE table3 (col3_0 OID NULL, col3_1 BIT(49) NOT NULL, col3_2 FLOAT8 NULL, col3_3 REGNAMESPACE, col3_4 DECIMAL NOT NULL, col3_5 TIMESTAMP NULL, col3_6 TIMESTAMPTZ NOT NULL, col3_7 GEOGRAPHY, col3_8 "char" NULL, col3_9 REGNAMESPACE, col3_10 DECIMAL NOT NULL GENERATED ALWAYS AS (col3_4 + 3.972812815656753664E+27::DECIMAL) STORED, col3_11 FLOAT8 NULL GENERATED ALWAYS AS (col3_2 + '+Inf'::FLOAT8) STORED);
test_1 | CREATE UNIQUE INDEX ON table3 (col3_9, col3_0, col3_2 DESC, (CASE WHEN col3_0 IS NULL THEN e'c-\r\'3\x1f'::TEXT ELSE e'\x07\x10'::TEXT END) ASC, col3_11 DESC, col3_1 ASC, col3_6 DESC, col3_10 ASC, col3_4 DESC, (col3_4 + 36217802999305706.21::DECIMAL) DESC, col3_5 DESC, col3_8 ASC);
test_1 | CREATE TABLE table4 (col4_0 FLOAT4 NOT NULL, col4_1 JSONB NULL, col4_2 INT4 NOT NULL);
test_1 | CREATE TABLE table5 (col5_0 INT2 NOT NULL, PRIMARY KEY (col5_0));
test_1 | CREATE UNIQUE INDEX ON table5 (col5_0 DESC);
test_1 | CREATE INDEX ON table5 (col5_0);
test_1 | CREATE INDEX ON table5 (col5_0);
test_1 | CREATE INDEX ON table5 (col5_0 ASC);
test_1 | CREATE UNIQUE INDEX ON table5 (col5_0);
test_1 | ALTER TABLE table2 ADD FOREIGN KEY (col2_0) REFERENCES table1 (col1_2);
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('umqia');
test_1 |
test_1 | compare_test.go:154: postgres: exec: ERROR: functions in index expression must be marked IMMUTABLE (SQLSTATE 42P17)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_cockroach2_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss
compose.TestComposeCompare failed with artifacts on release-21.2 @ 4df1305911133426c8c5bb2983048c4486a52cfa:
test_1 | JOIN postgres.public.table1@[0] AS tab_226501 ON
test_1 | (tab_226500.tableoid) = (tab_226501.col1_2)
test_1 | AND (tab_226500.crdb_internal_mvcc_timestamp) = (tab_226501.crdb_internal_mvcc_timestamp) ON
test_1 | (tab_226499.tableoid) = (tab_226501.col1_2)
test_1 | AND (tab_226497.crdb_internal_mvcc_timestamp) = (tab_226500.crdb_internal_mvcc_timestamp)
test_1 | JOIN postgres.public.table4@[0] AS tab_226502
test_1 | JOIN postgres.public.table3@[0] AS tab_226503 ON
test_1 | (tab_226502.col4_6) = (tab_226503.tableoid)
test_1 | AND (tab_226502.tableoid) = (tab_226503.tableoid)
test_1 | AND (tab_226502.col4_0) = (tab_226503.col3_0) ON
test_1 | (tab_226501.col1_5) = (tab_226502.col4_8) AND (tab_226497.col4_6) = (tab_226503.tableoid) ON
test_1 | (tab_226496.tableoid) = (tab_226497.col4_6)
test_1 | AND (tab_226496.crdb_internal_mvcc_timestamp) = (tab_226497.crdb_internal_mvcc_timestamp)
test_1 | ORDER BY
test_1 | tab_226503.crdb_internal_mvcc_timestamp DESC, tab_226496.col5_0 ASC
test_1 | )
test_1 | AS tab_226504
test_1 | ORDER BY
test_1 | col_310956 NULLS FIRST,
test_1 | col_310957 NULLS FIRST,
test_1 | col_310958 NULLS FIRST,
test_1 | col_310959 NULLS FIRST,
test_1 | col_310960 NULLS FIRST,
test_1 | col_310961 NULLS FIRST,
test_1 | col_310962 NULLS FIRST,
test_1 | col_310963 NULLS FIRST,
test_1 | col_310964 NULLS FIRST,
test_1 | col_310965 NULLS FIRST,
test_1 | col_310966 NULLS FIRST,
test_1 | col_310967 NULLS FIRST,
test_1 | col_310968 NULLS FIRST,
test_1 | col_310969 NULLS FIRST,
test_1 | col_310970 NULLS FIRST,
test_1 | col_310971 NULLS FIRST,
test_1 | col_310972 NULLS FIRST,
test_1 | col_310973 NULLS FIRST,
test_1 | col_310974 NULLS FIRST,
test_1 | col_310975 NULLS FIRST
test_1 | compare_test.go:193: cockroach1: ping: conn closed
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_postgres_1 ...
Stopping compare_postgres_1 ... done
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
Reproduce
To reproduce, try:
make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1
Same failure on other branches
- #67844 compose: TestComposeCompare failed [C-test-failure O-robot branch-release-21.1]
- #67791 compose: TestComposeCompare failed [C-test-failure O-robot branch-master]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @cockroachdb/sql-experience rafiss