Skip to content
New issue

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

Sign up for GitHub

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

Already on GitHub? Sign in to your account

Jump to bottom

roachtest: tlp failed #74675

Closed
cockroach-teamcity opened this issue Jan 11, 2022 · 35 comments · Fixed by #76236
Closed

roachtest: tlp failed #74675

cockroach-teamcity opened this issue Jan 11, 2022 · 35 comments · Fixed by #76236
Labels
branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
Projects
SQL Queries

Comments

@cockroach-teamcity
Copy link
Member

roachtest.tlp failed with artifacts on master @ fdd672fed84323279f7070127f36cdbdc5c26b03:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	... // 2 identical elements
		  |   	"NULL,1983-07-27 20:48:39.000809 +0000 +0000,NULL,NULL,1110011000"...,
		  |   	"NULL,2032-09-25 09:43:06.000039 +0000 +0000,NULL,NULL,NULL,NULL,"...,
		  |   	strings.Join({
		  |   		... // 6160 identical bytes
		  |   		"8BEA441A2F59C0EE2C0BE2B9F95540FE45D3902212F8C1604367DF0E4EE6C18C",
		  |   		"10F9D37F6163C010543320B472264088247521E79CD341CE63030AE27BE1C1,-",
		  | - 		"8335",
		  | + 		"1",
		  |   		",-8335",
		  |   	}, ""),
		  |   	"NULL,NULL,2539119333,0000-01-01 13:01:09.950446 +0000 UTC,001010"...,
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table2 AS tab_23091
		  | (SELECT * FROM defaultdb.public.table2 AS tab_23091 WHERE ((NOT $1) OR $2)) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_23091 WHERE NOT (((NOT $1) OR $2))) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_23091 WHERE (((NOT $1) OR $2)) IS NULL)
		  | with args: [true false]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!
@cockroach-teamcity cockroach-teamcity added branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels Jan 11, 2022
@cockroach-teamcity cockroach-teamcity added this to Triage in SQL Queries Jan 11, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Jan 11, 2022
@rytaft rytaft moved this from Triage to 22.1 January Milestone in SQL Queries Jan 11, 2022
@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ bbd8658d09681135c30e07650798768ca0063f09:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		... // 122 identical bytes
		  |   		``\\x5c0bb2df985974","\\x4a15d06006d671e1","\\x23340045f557"},0106``,
		  |   		"0000A0E610000000000000,0000-01-01 22:29:24.206673 -0425 -0425,-1",
		  | - 		"3467",
		  |   		",1612362393",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table3 AS tab_3857
		  | (SELECT * FROM defaultdb.public.table3 AS tab_3857 WHERE ($1 AND (tab_3857.col3_5 AND NULL))) UNION ALL (SELECT * FROM defaultdb.public.table3 AS tab_3857 WHERE NOT (($1 AND (tab_3857.col3_5 AND NULL)))) UNION ALL (SELECT * FROM defaultdb.public.table3 AS tab_3857 WHERE (($1 AND (tab_3857.col3_5 AND NULL))) IS NULL)
		  | with args: [false]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ d6b99e92bf55b6f4a0d79800d67924e04d0b2a6d:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		... // 516 identical bytes
		  |   		"E8A3E2F1410887DA61FFFFF5C19465C7C9936E0042010200000002000000D0B0",
		  |   		"92F54443D741A82B989D051FDE4170055BC7C0BDFBC1007F975BAF01B941,0,-",
		  | - 		"32509",
		  | + 		"1",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table3 AS tab_8580
		  | (SELECT * FROM defaultdb.public.table3 AS tab_8580 WHERE ($1 OR $2)) UNION ALL (SELECT * FROM defaultdb.public.table3 AS tab_8580 WHERE NOT (($1 OR $2))) UNION ALL (SELECT * FROM defaultdb.public.table3 AS tab_8580 WHERE (($1 OR $2)) IS NULL)
		  | with args: [true true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@mgartner
Copy link
Collaborator

I'm struggling to understand this output:

		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	... // 2 identical elements
		  |   	"NULL,1983-07-27 20:48:39.000809 +0000 +0000,NULL,NULL,1110011000"...,
		  |   	"NULL,2032-09-25 09:43:06.000039 +0000 +0000,NULL,NULL,NULL,NULL,"...,
		  |   	strings.Join({
		  |   		... // 6160 identical bytes
		  |   		"8BEA441A2F59C0EE2C0BE2B9F95540FE45D3902212F8C1604367DF0E4EE6C18C",
		  |   		"10F9D37F6163C010543320B472264088247521E79CD341CE63030AE27BE1C1,-",
		  | - 		"8335",
		  | + 		"1",
		  |   		",-8335",
		  |   	}, ""),
		  |   	"NULL,NULL,2539119333,0000-01-01 13:01:09.950446 +0000 UTC,001010"...,
		  |   }

This comes from the error returned here, which occurs when cmp.Diff finds a difference in two []strings here.

But looking at this code, how is it possible that the strings.Join are preserved for the cmp.Diff??? These are functions that return strings, so how is it possible that the output of cmp.Diff includes a string representation of the function calls?

pkg/cmd/roachtest/tests/tlp.go#L245-L244

func unsortedMatricesDiff(rowMatrix1, rowMatrix2 [][]string) string {
	var rows1 []string
	for _, row := range rowMatrix1 {
		rows1 = append(rows1, strings.Join(row[:], ","))
	}
	var rows2 []string
	for _, row := range rowMatrix2 {
		rows2 = append(rows2, strings.Join(row[:], ","))
	}
	sort.Strings(rows1)
	sort.Strings(rows2)
	return cmp.Diff(rows1, rows2)
}

@mgartner
Copy link
Collaborator

The output shows strings.Join(..., "") with an empty separator, but the code above has strings.Join(..., ",") with a comma separator. So maybe the string.Join in the output is unrelated to the strings.Join in the code. Maybe this is some bizarre bug in cmp.Diff?

@mgartner
Copy link
Collaborator

Ahh it looks like its some special output from cmp.Diff that is supposed to make it easier to read: google/go-cmp#274 (comment)

@mgartner
Copy link
Collaborator

I'm not sure what's going on here. It's possible these aren't real failures, and bugs in the TLP logic. I was unable to reproduce with the TLP logs in the builds above. I also ran tlp locally for ~30 minutes and couldn't produce a failure.

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 78419450178335b31f542bd1b14fefdf4ecee0e8:

The test failed on branch=master, cloud=gce:
test timed out (see artifacts for details)
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 5ad21e3896ee809e9c3ebc28bb22166f1275acca:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  | - 	"-0.28741492546451,-616032757,-701283589",
		  | + 	"-0.28741492546451,-616032757,-1",
		  | - 	"1.8962324868374156,-1241857874,-1327108706",
		  | + 	"1.8962324868374156,-1241857874,-1",
		  | - 	"2.057283215857098,-1985889298,-2071140130",
		  | + 	"2.057283215857098,-1985889298,-1",
		  | - 	"NULL,-1,-85250833",
		  | + 	"NULL,-1,-1",
		  | - 	"NULL,-689742872,-774993704",
		  | + 	"NULL,-689742872,-1",
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table1 AS tab_2046
		  | (SELECT * FROM defaultdb.public.table1 AS tab_2046 WHERE ($1 OR (2419565919 IS NOT DISTINCT FROM tab_2046.tableoid))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_2046 WHERE NOT (($1 OR (2419565919 IS NOT DISTINCT FROM tab_2046.tableoid)))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_2046 WHERE (($1 OR (2419565919 IS NOT DISTINCT FROM tab_2046.tableoid))) IS NULL)
		  | with args: [false]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 4b41789120e019ab015e6dbb924df763897ebadb:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  | - 	"\re3,1509728173,NULL,<B``\x19wS8C,-18828179",
		  | + 	"\re3,1509728173,NULL,<B``\x19wS8C,-1",
		  | - 	"\x0e1O,1469257218,-1643966527,UWc-,-59299134",
		  | + 	"\x0e1O,1469257218,-1643966527,UWc-,-1",
		  | - 	"\x15;fvA\x195\n ,1025038263,NULL,\x02UXF_%,-503518089",
		  | + 	"\x15;fvA\x195\n ,1025038263,NULL,\x02UXF_%,-1",
		  |   	"+\x0ebDj,NULL,NULL,\x19,NULL",
		  |   	"X,NULL,270676950,-Kg5\x138,NULL",
		  | - 	"|8X,1206231143,1040937907,=3M\x1bs\x06*R8,-322325209",
		  | + 	"|8X,1206231143,1040937907,=3M\x1bs\x06*R8,-1",
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table2 AS tab_6403
		  | (SELECT * FROM defaultdb.public.table2 AS tab_6403 WHERE (NOT $1)) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_6403 WHERE NOT ((NOT $1))) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_6403 WHERE ((NOT $1)) IS NULL)
		  | with args: [true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 365b4da8bd02c06ee59d2130a56dec74ffc9ce21:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		... // 175 identical bytes
		  |   		"83994584 -1.1264713509108841,-0.20677892762653516 0.130777763792",
		  |   		"64316),1979-07-05 04:10:42.000565 +0000 UTC,00:00:00,447163428,-",
		  | - 		"896110",
		  |   		"1",
		  | - 		"39",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table1 AS tab_3086
		  | (SELECT * FROM defaultdb.public.table1 AS tab_3086 WHERE (tab_3086.col1_4 OR $1)) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_3086 WHERE NOT ((tab_3086.col1_4 OR $1))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_3086 WHERE ((tab_3086.col1_4 OR $1)) IS NULL)
		  | with args: [false]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity cockroach-teamcity mentioned this issue Jan 19, 2022
Closed
@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 912964e02ddd951c77d4f71981ae18b3894e9084:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		"1981-12-27 17:36:52.000889 +0000 +0000,NULL,NULL,1228376045,",
		  | - 		"1228376",
		  |   		"0",
		  | - 		"45",
		  |   		",1981-12-27 17:36:52.000889,NULL",
		  |   	}, ""),
		  | - 	"NULL,NULL,NULL,1456834483,1456834483,NULL,NULL",
		  | + 	"NULL,NULL,NULL,1456834483,0,NULL,NULL",
		  |   	"NULL,NULL,NULL,NULL,NULL,NULL,NULL",
		  |   	"NULL,NULL,NULL,NULL,NULL,NULL,NULL",
		  |   	... // 2 identical elements
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table1 AS tab_2000
		  | (SELECT * FROM defaultdb.public.table1 AS tab_2000 WHERE '64ac500b-68eb-44c8-bdbd-34875b643a38'::UUID NOT IN (WITH with_390 (col_1684) AS (SELECT * FROM (VALUES (CASE WHEN st_dwithin((SELECT '0101000080CE849AA10B4BE6C1C0864EA7EB4FBAC1B962767F366CF3C1' AS col_1683 FROM defaultdb.public.table2@[0] AS tab_2001 LIMIT $2)::GEOMETRY, st_generatepoints('01030000C00100000006000000BC5BE994FF71DDC12051325ACBD2E7C1D80304E302D3ED4140F3C2BEFDCEE841E0FBC1A2BCF2E7C1E280FF14546002C224F60840D1C7F5C1E11D0CAE9024F7C1D2AB043F8F95F141C89CF0D81612FC4170EFA79DCB9AFA412E549C47DB9BF041A0B06D6A725FB1C1B87B17A9A590D041EACC1DEC6C740242F461FDA6146FF8C1A0E00D93F5ACD7C160BC0485B39EBCC180AB90F9D805B041017FA87BDB71F9C1BC5BE994FF71DDC12051325ACBD2E7C1D80304E302D3ED4140F3C2BEFDCEE841'::GEOMETRY, NULL::INT4, $3::INT4)::GEOMETRY::GEOMETRY, $4::FLOAT8)::BOOL THEN '01050000C000000000' ELSE '010200008002000000B41EF0369820FAC1AE1E147B5D42F8C19A2E56DF305B0242D24C78630534ECC19AB763BB214801C2803FC1BD2BB0E641' END), ('010200000000000000'), (NULL), ('01070000C00400000001040000C00900000001010000C0349BA1F62497F84104B698C35D60FF41F0CA2035DAB1D24182BAAA93FF73F24101010000C000EFF629FCC2F7C12E5FC1499239F741D6409792DC86E6C1E072463DA6F3B4C101010000C0C0FDB3CDDF67F9C15C50B0958996FE41267351FC8D40E2C1ACD040A6ED9DD5C101010000C01A9C6F2B279800C2789FB45CB079FB418820621A4EECE34128331D3E2B8FEA4101010000C0C2020EE8E6FAF8C1FCE8EE7227A9E64184769BDA6349FD410A296992072AEEC101010000C09840772BCFA6F541D601FFE8C0DEF0C1A804CCE58FE7ED411C7BDA81D769FD4101010000C0009B2CF09F3AEF417E4D97E354F3F441349556D43374024258FC2D951BBAD04101010000C064D888F35DEEFC41F0DFF0CA845DD441F0A03AF544FCE1416C01777C0E73E1C101010000C0956482567EB6FFC15CBA65724FE9E54150F962496EEFE6C1A8FBB31A4E70FE4101010000C05AA81E20A321F841D8A7D94B684DF7410C9A22C65CAAF8C13A1B75C40CEDE8C101050000C00200000001020000C0020000003CAB2764A4C9FF41B3549263F917F0C11EBA29A19F080242F43F1FE41B6AFCC10C387B8E6547E1419E677576331EE0C1283926AC1603FD414B11BCCF76C1F3C101020000C00200000010C93DFF3CAAF34166735A174A43FDC1105A1AF24845E8413CA851B51BD2EC41000AB3D01123C34148863842AEA6E2417ECC248A3F9E0242432079D889F7FCC101020000C0060000004606053E0F6DF641ABE8938B415BFFC1ED5FED7C4849F4C118880C3FBB55D7C1BC9606782EA8FF410E89A454D410F7C130B5B8412622FFC17A4FB312CC1EEDC1ACA64CE510ECFD41B8CBAA02F15CE6C14AE2C09AC5FEF2412CF9A0A93A29FE4138B23AFFD86CFE41F6174B2FD8CEF5417CEE8C3D5DCEEEC17C8DAD8E4B10F6C160FB6D2E2A5CD641B617E112C734F74112A331676539FA41AC42CAEA8E53FB4128A453FCC2FDD641B0012BE64B21F341B83A137D948FF64194D11E06086ADEC1')) AS tab_2002 (col_1684)), with_391 (col_1685) AS (SELECT * FROM (VALUES (NULL)) AS tab_2003 (col_1685) INTERSECT ALL SELECT * FROM (VALUES (NULL)) AS tab_2004 (col_1686)) SELECT '8b0049e9-c875-44ec-8545-871ba9d990b5'::UUID AS col_1687 FROM with_391 AS cte_ref_133, defaultdb.public.table3@[0] AS tab_2005 GROUP BY tab_2005.tableoid, cte_ref_133.col_1685 HAVING bool_or($1::BOOL)::BOOL)) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_2000 WHERE NOT ('64ac500b-68eb-44c8-bdbd-34875b643a38'::UUID NOT IN (WITH with_390 (col_1684) AS (SELECT * FROM (VALUES (CASE WHEN st_dwithin((SELECT '0101000080CE849AA10B4BE6C1C0864EA7EB4FBAC1B962767F366CF3C1' AS col_1683 FROM defaultdb.public.table2@[0] AS tab_2001 LIMIT $2)::GEOMETRY, st_generatepoints('01030000C00100000006000000BC5BE994FF71DDC12051325ACBD2E7C1D80304E302D3ED4140F3C2BEFDCEE841E0FBC1A2BCF2E7C1E280FF14546002C224F60840D1C7F5C1E11D0CAE9024F7C1D2AB043F8F95F141C89CF0D81612FC4170EFA79DCB9AFA412E549C47DB9BF041A0B06D6A725FB1C1B87B17A9A590D041EACC1DEC6C740242F461FDA6146FF8C1A0E00D93F5ACD7C160BC0485B39EBCC180AB90F9D805B041017FA87BDB71F9C1BC5BE994FF71DDC12051325ACBD2E7C1D80304E302D3ED4140F3C2BEFDCEE841'::GEOMETRY, NULL::INT4, $3::INT4)::GEOMETRY::GEOMETRY, $4::FLOAT8)::BOOL THEN '01050000C000000000' ELSE '010200008002000000B41EF0369820FAC1AE1E147B5D42F8C19A2E56DF305B0242D24C78630534ECC19AB763BB214801C2803FC1BD2BB0E641' END), ('010200000000000000'), (NULL), ('01070000C00400000001040000C00900000001010000C0349BA1F62497F84104B698C35D60FF41F0CA2035DAB1D24182BAAA93FF73F24101010000C000EFF629FCC2F7C12E5FC1499239F741D6409792DC86E6C1E072463DA6F3B4C101010000C0C0FDB3CDDF67F9C15C50B0958996FE41267351FC8D40E2C1ACD040A6ED9DD5C101010000C01A9C6F2B279800C2789FB45CB079FB418820621A4EECE34128331D3E2B8FEA4101010000C0C2020EE8E6FAF8C1FCE8EE7227A9E64184769BDA6349FD410A296992072AEEC101010000C09840772BCFA6F541D601FFE8C0DEF0C1A804CCE58FE7ED411C7BDA81D769FD4101010000C0009B2CF09F3AEF417E4D97E354F3F441349556D43374024258FC2D951BBAD04101010000C064D888F35DEEFC41F0DFF0CA845DD441F0A03AF544FCE1416C01777C0E73E1C101010000C0956482567EB6FFC15CBA65724FE9E54150F962496EEFE6C1A8FBB31A4E70FE4101010000C05AA81E20A321F841D8A7D94B684DF7410C9A22C65CAAF8C13A1B75C40CEDE8C101050000C00200000001020000C0020000003CAB2764A4C9FF41B3549263F917F0C11EBA29A19F080242F43F1FE41B6AFCC10C387B8E6547E1419E677576331EE0C1283926AC1603FD414B11BCCF76C1F3C101020000C00200000010C93DFF3CAAF34166735A174A43FDC1105A1AF24845E8413CA851B51BD2EC41000AB3D01123C34148863842AEA6E2417ECC248A3F9E0242432079D889F7FCC101020000C0060000004606053E0F6DF641ABE8938B415BFFC1ED5FED7C4849F4C118880C3FBB55D7C1BC9606782EA8FF410E89A454D410F7C130B5B8412622FFC17A4FB312CC1EEDC1ACA64CE510ECFD41B8CBAA02F15CE6C14AE2C09AC5FEF2412CF9A0A93A29FE4138B23AFFD86CFE41F6174B2FD8CEF5417CEE8C3D5DCEEEC17C8DAD8E4B10F6C160FB6D2E2A5CD641B617E112C734F74112A331676539FA41AC42CAEA8E53FB4128A453FCC2FDD641B0012BE64B21F341B83A137D948FF64194D11E06086ADEC1')) AS tab_2002 (col_1684)), with_391 (col_1685) AS (SELECT * FROM (VALUES (NULL)) AS tab_2003 (col_1685) INTERSECT ALL SELECT * FROM (VALUES (NULL)) AS tab_2004 (col_1686)) SELECT '8b0049e9-c875-44ec-8545-871ba9d990b5'::UUID AS col_1687 FROM with_391 AS cte_ref_133, defaultdb.public.table3@[0] AS tab_2005 GROUP BY tab_2005.tableoid, cte_ref_133.col_1685 HAVING bool_or($1::BOOL)::BOOL))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_2000 WHERE ('64ac500b-68eb-44c8-bdbd-34875b643a38'::UUID NOT IN (WITH with_390 (col_1684) AS (SELECT * FROM (VALUES (CASE WHEN st_dwithin((SELECT '0101000080CE849AA10B4BE6C1C0864EA7EB4FBAC1B962767F366CF3C1' AS col_1683 FROM defaultdb.public.table2@[0] AS tab_2001 LIMIT $2)::GEOMETRY, st_generatepoints('01030000C00100000006000000BC5BE994FF71DDC12051325ACBD2E7C1D80304E302D3ED4140F3C2BEFDCEE841E0FBC1A2BCF2E7C1E280FF14546002C224F60840D1C7F5C1E11D0CAE9024F7C1D2AB043F8F95F141C89CF0D81612FC4170EFA79DCB9AFA412E549C47DB9BF041A0B06D6A725FB1C1B87B17A9A590D041EACC1DEC6C740242F461FDA6146FF8C1A0E00D93F5ACD7C160BC0485B39EBCC180AB90F9D805B041017FA87BDB71F9C1BC5BE994FF71DDC12051325ACBD2E7C1D80304E302D3ED4140F3C2BEFDCEE841'::GEOMETRY, NULL::INT4, $3::INT4)::GEOMETRY::GEOMETRY, $4::FLOAT8)::BOOL THEN '01050000C000000000' ELSE '010200008002000000B41EF0369820FAC1AE1E147B5D42F8C19A2E56DF305B0242D24C78630534ECC19AB763BB214801C2803FC1BD2BB0E641' END), ('010200000000000000'), (NULL), ('01070000C00400000001040000C00900000001010000C0349BA1F62497F84104B698C35D60FF41F0CA2035DAB1D24182BAAA93FF73F24101010000C000EFF629FCC2F7C12E5FC1499239F741D6409792DC86E6C1E072463DA6F3B4C101010000C0C0FDB3CDDF67F9C15C50B0958996FE41267351FC8D40E2C1ACD040A6ED9DD5C101010000C01A9C6F2B279800C2789FB45CB079FB418820621A4EECE34128331D3E2B8FEA4101010000C0C2020EE8E6FAF8C1FCE8EE7227A9E64184769BDA6349FD410A296992072AEEC101010000C09840772BCFA6F541D601FFE8C0DEF0C1A804CCE58FE7ED411C7BDA81D769FD4101010000C0009B2CF09F3AEF417E4D97E354F3F441349556D43374024258FC2D951BBAD04101010000C064D888F35DEEFC41F0DFF0CA845DD441F0A03AF544FCE1416C01777C0E73E1C101010000C0956482567EB6FFC15CBA65724FE9E54150F962496EEFE6C1A8FBB31A4E70FE4101010000C05AA81E20A321F841D8A7D94B684DF7410C9A22C65CAAF8C13A1B75C40CEDE8C101050000C00200000001020000C0020000003CAB2764A4C9FF41B3549263F917F0C11EBA29A19F080242F43F1FE41B6AFCC10C387B8E6547E1419E677576331EE0C1283926AC1603FD414B11BCCF76C1F3C101020000C00200000010C93DFF3CAAF34166735A174A43FDC1105A1AF24845E8413CA851B51BD2EC41000AB3D01123C34148863842AEA6E2417ECC248A3F9E0242432079D889F7FCC101020000C0060000004606053E0F6DF641ABE8938B415BFFC1ED5FED7C4849F4C118880C3FBB55D7C1BC9606782EA8FF410E89A454D410F7C130B5B8412622FFC17A4FB312CC1EEDC1ACA64CE510ECFD41B8CBAA02F15CE6C14AE2C09AC5FEF2412CF9A0A93A29FE4138B23AFFD86CFE41F6174B2FD8CEF5417CEE8C3D5DCEEEC17C8DAD8E4B10F6C160FB6D2E2A5CD641B617E112C734F74112A331676539FA41AC42CAEA8E53FB4128A453FCC2FDD641B0012BE64B21F341B83A137D948FF64194D11E06086ADEC1')) AS tab_2002 (col_1684)), with_391 (col_1685) AS (SELECT * FROM (VALUES (NULL)) AS tab_2003 (col_1685) INTERSECT ALL SELECT * FROM (VALUES (NULL)) AS tab_2004 (col_1686)) SELECT '8b0049e9-c875-44ec-8545-871ba9d990b5'::UUID AS col_1687 FROM with_391 AS cte_ref_133, defaultdb.public.table3@[0] AS tab_2005 GROUP BY tab_2005.tableoid, cte_ref_133.col_1685 HAVING bool_or($1::BOOL)::BOOL)) IS NULL)
		  | with args: [false 1 -787084029 1.217942144948232]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ da01e4c0545f191a0573e1d097ff0366769e0d6b:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		... // 268 identical bytes
		  |   		"25954258441925,{\"%tC\": {}, \"P~\\\"&Raz``\": {\"R|ZZ\": true}, \"c\": nul",
		  |   		"l},0000-01-01 00:00:00 +0000 UTC,1995-03-21,0.2748483717441559,-",
		  | - 		"2920",
		  |   		"1",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 282 identical bytes
		  |   		``335372925,{"*_j1L": [0.014671692171796119, []], "b": false},0000``,
		  |   		"-01-01 20:57:35.947385 +0000 UTC,1974-03-04,0.9577140808105469,-",
		  | - 		"29",
		  |   		"1",
		  | - 		"99",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 344 identical bytes
		  |   		`` []], [[], [], {"a": {"foo": null, "mf*#ayO y": []}}], {}],0000-``,
		  |   		"01-01 10:44:48.892346 +0000 UTC,1987-10-14,0.39239829778671265,-",
		  | - 		"1641",
		  |   		"1",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table1 AS tab_3786
		  | (SELECT * FROM defaultdb.public.table1 AS tab_3786 WHERE ($1 AND $2)) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_3786 WHERE NOT (($1 AND $2))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_3786 WHERE (($1 AND $2)) IS NULL)
		  | with args: [false true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 58ceac139a7e83052171121b28026a7366f16f7e:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		... // 403 identical bytes
		  |   		"0101000000b8eb4d258a9f45c0734e50b6429453c00101000000223b2bfae3f7",
		  |   		"58c0ae12c8e45f9b4fc00101000000638648535b8665c04fb477fcf80846c0,-",
		  | - 		"69811909,1662567178,-69779142",
		  | + 		"1,0,-1",
		  |   		",1662534410,NHPHX\x16(v0",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table5 AS tab_16290
		  | (SELECT * FROM defaultdb.public.table5 AS tab_16290 WHERE ($1::FLOAT8 - $2::FLOAT8)::FLOAT8::FLOAT8 IN (SELECT tab_16291.col1_7::FLOAT8 AS col_5815 FROM defaultdb.public.table1@table1_pkey AS tab_16291 LIMIT $3)) UNION ALL (SELECT * FROM defaultdb.public.table5 AS tab_16290 WHERE NOT (($1::FLOAT8 - $2::FLOAT8)::FLOAT8::FLOAT8 IN (SELECT tab_16291.col1_7::FLOAT8 AS col_5815 FROM defaultdb.public.table1@table1_pkey AS tab_16291 LIMIT $3))) UNION ALL (SELECT * FROM defaultdb.public.table5 AS tab_16290 WHERE (($1::FLOAT8 - $2::FLOAT8)::FLOAT8::FLOAT8 IN (SELECT tab_16291.col1_7::FLOAT8 AS col_5815 FROM defaultdb.public.table1@table1_pkey AS tab_16291 LIMIT $3)) IS NULL)
		  | with args: [-0.8152742674814152 -0.896041224053816 21]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ dc07599dc9db1acd5afa3a6537297815f25c1fca:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		"0101000060E6100000000000000000F87F000000000000F87F000000000000F8",
		  |   		"7F,12575,NULL,",
		  | - 		"28",
		  |   		"0",
		  | - 		"37",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table2 AS tab_1843
		  | (SELECT * FROM defaultdb.public.table2 AS tab_1843 WHERE st_box2dfromgeohash(tab_1843.col2_2::STRING, $1::INT8)::BOX2D::BOX2D IN (st_expand('BOX(-0.3909709853662299 -0.8435928385118793,-0.024556890797075903 1.5124505059593312)'::BOX2D, $2::FLOAT8)::BOX2D, NULL, 'BOX(0.26163884882724187 0.6102812430287974,0.8356363655774343 0.9202076332851126)')) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_1843 WHERE NOT (st_box2dfromgeohash(tab_1843.col2_2::STRING, $1::INT8)::BOX2D::BOX2D IN (st_expand('BOX(-0.3909709853662299 -0.8435928385118793,-0.024556890797075903 1.5124505059593312)'::BOX2D, $2::FLOAT8)::BOX2D, NULL, 'BOX(0.26163884882724187 0.6102812430287974,0.8356363655774343 0.9202076332851126)'))) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_1843 WHERE (st_box2dfromgeohash(tab_1843.col2_2::STRING, $1::INT8)::BOX2D::BOX2D IN (st_expand('BOX(-0.3909709853662299 -0.8435928385118793,-0.024556890797075903 1.5124505059593312)'::BOX2D, $2::FLOAT8)::BOX2D, NULL, 'BOX(0.26163884882724187 0.6102812430287974,0.8356363655774343 0.9202076332851126)')) IS NULL)
		  | with args: [2131648912234713510 -1.7797406911513463]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ e1068d77afbd39b162978281c9da7cbea49c1c3a:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  | - 	"32767,165677287,oq,-13141,165696913",
		  | + 	"32767,165677287,oq,-13141,0",
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table5 AS tab_25024
		  | (SELECT * FROM defaultdb.public.table5 AS tab_25024 WHERE ($1 OR $2)) UNION ALL (SELECT * FROM defaultdb.public.table5 AS tab_25024 WHERE NOT (($1 OR $2))) UNION ALL (SELECT * FROM defaultdb.public.table5 AS tab_25024 WHERE (($1 OR $2)) IS NULL)
		  | with args: [false true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 8cd28089c6c7333615ba3201e841839001d2f0e1:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		"1971-01-13 00:00:00 +0000 +0000,-414520826,NULL,NULL,\x1d,{24709054",
		  |   		"39,3949540417,1716417240,762687995},true,1981-05-29 00:00:00 +00",
		  |   		"00 +0000,-1",
		  | - 		"103372218",
		  |   		",X",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table1 AS tab_2797
		  | (SELECT * FROM defaultdb.public.table1 AS tab_2797 WHERE (tab_2797.col1_6 AND $1)) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_2797 WHERE NOT ((tab_2797.col1_6 AND $1))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_2797 WHERE ((tab_2797.col1_6 AND $1)) IS NULL)
		  | with args: [true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ c4c5ca2fdd5a641433a85a28d4dfd3bd4443015d:

		  |   []string{
		  |   	strings.Join({
		  |   		... // 1034 identical bytes
		  |   		"44F01D89F8C16E6347D8B6C856C060C8EFB007624B40ACAEC6EA894FE6417232",
		  |   		"7EC1E518E4C1,NULL,j\x13\x13vJ-\t[,2027-04-22 12:58:08.000109 +0000 UTC,",
		  | - 		"128328947",
		  | + 		"0",
		  |   		",false,0101010100111100110101001011001111",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 344 identical bytes
		  |   		``\\W\"d_TM1": {}}}, {"baz": {"bar": null}}], []],m,0105000060E610``,
		  |   		"000000000000,false,O&/-Z -,2027-04-22 12:58:08.000109 +0000 UTC,",
		  | - 		"198299226",
		  | + 		"0",
		  |   		",false,1000001101101100011110110010110001",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 5264 identical bytes
		  |   		"2C2E40EFB0E1915EA4162715220CF1262C0F1764AD3C30451C070EEB52E39BDC",
		  |   		"AC140766DDACBBAC641,NULL, ,2027-04-22 12:58:08.000109 +0000 UTC,",
		  | - 		"377083",
		  |   		"0",
		  | - 		"61",
		  |   		",true,1110111011011000000110100010000001",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 527 identical bytes
		  |   		"40FE1E01F23426F2410101000080E422E41A53CB5340E4725A46ECE537C04CE7",
		  |   		"1B94B804EF41,NULL,Rt?\x0eB\x05=+,1980-02-22 15:40:03.000094 +0000 UTC,",
		  | - 		"659452626",
		  | + 		"0",
		  |   		",false,0100011101100010011101111100100110",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 470 identical bytes
		  |   		"058E98B72BA2B32400ACFA8279B1FFCC1F46B5B71095F4BC008DF994FF9BC32C",
		  |   		``0984AC022DF5FD741,false,",2027-04-22 12:58:08.000109 +0000 UTC,-``,
		  | - 		"280329640",
		  | + 		"1",
		  |   		",NULL,1110000000011101111101111101111010",
		  |   	}, ""),
		  |   	"NULL,0010010000111000101100110111100001,NULL,[0.0158959699660607"...,
		  |   	``NULL,0011111001101010011000010011100000,NULL,[{"+9f!4X,_pYs": []``...,
		  |   	... // 6 identical elements
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table5 AS tab_2543
		  | (SELECT * FROM defaultdb.public.table5 AS tab_2543 WHERE (NULL OR $1)) UNION ALL (SELECT * FROM defaultdb.public.table5 AS tab_2543 WHERE NOT ((NULL OR $1))) UNION ALL (SELECT * FROM defaultdb.public.table5 AS tab_2543 WHERE ((NULL OR $1)) IS NULL)
		  | with args: [false]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@mgartner mgartner moved this from 22.1 January Milestone to Triage in SQL Queries Jan 25, 2022
@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ e5d1c374c31dc0e80a596c570da8dc45d73f80b8:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	"-4713-11-24 00:00:00 +0000 UTC,\x11otq,-0.017759878848842947,NULL,8"...,
		  |   	"1979-05-02 06:33:45.000613 +0000 UTC,.\x02,NULL,0106000000050000000"...,
		  |   	strings.Join({
		  |   		"2004-05-23 01:46:58.000656 +0000 UTC,\x172e``7\x03\ns,NULL,NULL,33194367",
		  |   		"66,11100,false,4909,NULL,-8662,2.606901903968581246E+36,1981-07-",
		  |   		"27 00:00:00 +0000 +0000,-",
		  | - 		"3753,-3753,11100,-21093",
		  | + 		"1,-1,11100,-1",
		  |   	}, ""),
		  |   	"2012-01-02 00:09:58.000654 +0000 UTC,(,0.852700015694824,NULL,NU"...,
		  |   	"2012-09-05 01:46:56.000201 +0000 UTC,/L\x06H\x04*\x01\x0f,NULL,0104000040080"...,
		  |   	"294276-12-31 23:59:59.999999 +0000 UTC,AH>;\f,NULL,01070000800300"...,
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table1 AS tab_2676
		  | (SELECT * FROM defaultdb.public.table1 AS tab_2676 WHERE ($1 AND ('04:25:17.23911+08:06:00'::TIMETZ IN (SELECT ('66 years 6 mons 898 days 05:20:23.059898'::INTERVAL + ('58 years 7 mons 113 days 00:03:47.48447'::INTERVAL + ('10:50:49.844484+12:09:00'::TIMETZ - '-60 years -2 mons -580 days -16:26:26.605403'::INTERVAL)::TIMETZ::TIMETZ)::TIMETZ::TIMETZ)::TIMETZ::TIMETZ AS col_4604)))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_2676 WHERE NOT (($1 AND ('04:25:17.23911+08:06:00'::TIMETZ IN (SELECT ('66 years 6 mons 898 days 05:20:23.059898'::INTERVAL + ('58 years 7 mons 113 days 00:03:47.48447'::INTERVAL + ('10:50:49.844484+12:09:00'::TIMETZ - '-60 years -2 mons -580 days -16:26:26.605403'::INTERVAL)::TIMETZ::TIMETZ)::TIMETZ::TIMETZ)::TIMETZ::TIMETZ AS col_4604))))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_2676 WHERE (($1 AND ('04:25:17.23911+08:06:00'::TIMETZ IN (SELECT ('66 years 6 mons 898 days 05:20:23.059898'::INTERVAL + ('58 years 7 mons 113 days 00:03:47.48447'::INTERVAL + ('10:50:49.844484+12:09:00'::TIMETZ - '-60 years -2 mons -580 days -16:26:26.605403'::INTERVAL)::TIMETZ::TIMETZ)::TIMETZ::TIMETZ)::TIMETZ::TIMETZ AS col_4604)))) IS NULL)
		  | with args: [false]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@mgartner mgartner removed their assignment Jan 26, 2022
@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 83e2df701688745fe7e7d8a0d0e5e7a4ba8633c8:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		... // 123 identical bytes
		  |   		"22153,-2137582331,60 years 5 mons 878 days 19:42:29.849633,NULL,",
		  |   		"NULL,148178202,1997-05-13 17:40:39.000273 +0000 +0000,NULL,NULL,",
		  | - 		"99",
		  |   		"0",
		  | - 		"1316",
		  |   		",X",
		  |   	}, ""),
		  |   	"0000-01-01 11:44:34.760799 -0618 -0618,2010-10-29 03:10:58.00021"...,
		  |   	"0000-01-01 11:44:34.760799 -0618 -0618,2013-11-20 03:51:37.00053"...,
		  |   	... // 5 identical elements
		  |   	"0000-01-01 11:44:34.760799 -0618 -0618,2022-01-27 14:59:53.67143"...,
		  |   	"0000-01-01 11:44:34.760799 -0618 -0618,3000-01-01 00:00:00 +0000"...,
		  |   	strings.Join({
		  |   		"0000-01-01 11:44:34.760799 -0618 -0618,NULL,NULL,1858388873,0.82",
		  |   		"06132185240855,NULL,239301826,-454379154,-27 years -8 mons -622 ",
		  |   		"days -21:50:45.72202,NULL,NULL,93222154,NULL,NULL,NULL,",
		  | - 		"14",
		  |   		"0",
		  | - 		"4009719",
		  |   		",X",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 80 identical bytes
		  |   		"206,-10 years -8 mons -575 days -04:15:06.568518,NULL,0011010000",
		  |   		"01100000011111111010,0,NULL,001101000001100000011111111010,NULL,",
		  | - 		"152735031",
		  |   		"0,X",
		  |   	}, ""),
		  |   	"NULL,NULL,NULL,-648487091,0.12389336170217163,NULL,2806344659,NU"...,
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table3 AS tab_1935
		  | (SELECT * FROM defaultdb.public.table3 AS tab_1935 WHERE (NULL AND $1)) UNION ALL (SELECT * FROM defaultdb.public.table3 AS tab_1935 WHERE NOT ((NULL AND $1))) UNION ALL (SELECT * FROM defaultdb.public.table3 AS tab_1935 WHERE ((NULL AND $1)) IS NULL)
		  | with args: [true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 71becf337d9d2731298dc092f3ce9cf0f0eedb2c:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	"\x00,NULL,NULL,NULL,NULL,0.6001525194767039,-78 years -6 mons -757 "...,
		  |   	"\x1a,NULL,NULL,0000-01-01 14:15:43.74635 +0436 +0436,NULL,0.3262220"...,
		  |   	strings.Join({
		  |   		"6,NULL,NULL,NULL,NULL,NULL,52 years 844 days 16:44:53.037099,765",
		  |   		"0,,NULL,NULL,NULL,NULL,",
		  | - 		"28474",
		  | + 		"0",
		  |   		",NULL, \x19,,NULL",
		  |   	}, ""),
		  |   	"o,1989-04-25 02:01:52.000987 +0000 UTC,NULL,NULL,NULL,0.54785526"...,
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table1 AS tab_4778
		  | (SELECT * FROM defaultdb.public.table1 AS tab_4778 WHERE (tab_4778.col1_11 OR $1)) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_4778 WHERE NOT ((tab_4778.col1_11 OR $1))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_4778 WHERE ((tab_4778.col1_11 OR $1)) IS NULL)
		  | with args: [true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ bb85ddc4fc0ad8761d7aba61315da22b433022e3:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		... // 193 identical bytes
		  |   		``0:00","2015-07-20 05:20:32.000003+00:00","1974-01-07 19:33:31.00``,
		  |   		``0693+00:00"},NULL,-38 years -8 mons -825 days -07:54:16.312337,-``,
		  | - 		"27764",
		  | + 		"1",
		  |   		",01010000a0e6100000167bfacdbdf764c09c834d5255a44640b8cfbaf62d98d",
		  |   		"641,FG2",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table4 AS tab_1927
		  | (SELECT * FROM defaultdb.public.table4 AS tab_1927 WHERE ($1 OR $2)) UNION ALL (SELECT * FROM defaultdb.public.table4 AS tab_1927 WHERE NOT (($1 OR $2))) UNION ALL (SELECT * FROM defaultdb.public.table4 AS tab_1927 WHERE (($1 OR $2)) IS NULL)
		  | with args: [true true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ a5158c4c93e9dca858b38ef7e94321f0a0a2b5c5:

		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		"1966607624,true,4225492979,true,NULL,5874897-12-31 00:00:00 +000",
		  |   		"0 +0000,197.229.129.73,t,13826,2016-12-18 13:14:48.000207 +0000 ",
		  |   		"UTC,-1",
		  | - 		"5473",
		  |   		",\x12,cj,NULL,197.229.129.73,true,true,+P",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		"1967123099,false,4287991873,true,NULL,1972-07-03 00:00:00 +0000 ",
		  |   		"+0000,NULL,|,30230,2015-01-13 12:09:07.000648 +0000 UTC,",
		  | - 		"931",
		  | + 		"0",
		  |   		",\x12,cj,NULL,NULL,false,false,+P",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		"287783161,true,2668821467,NULL,NULL,1981-05-20 00:00:00 +0000 +0",
		  |   		"000,NULL,C,-965,1984-08-09 17:49:49.000863 +0000 UTC,-",
		  | - 		"30264",
		  | + 		"1",
		  |   		",\x12,cj,NULL,NULL,true,true,+P",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		"2936334746,false,3005099932,true,NULL,1974-08-01 00:00:00 +0000 ",
		  |   		"+0000,NULL,7,16518,2026-04-19 20:54:00.000863 +0000 UTC,-",
		  | - 		"1278",
		  |   		"1,\x12,cj,NULL,NULL,false,false,+P",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		"6425799,true,2493585372,NULL,{-0.33826817591199665},1985-11-07 0",
		  |   		"0:00:00 +0000 +0000,NULL,h,1,1998-05-29 23:18:44.000948 +0000 UT",
		  |   		"C,-",
		  | - 		"29298",
		  | + 		"1",
		  |   		",\x12,cj,NULL,NULL,true,true,+P",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table2 AS tab_4426
		  | (SELECT * FROM defaultdb.public.table2 AS tab_4426 WHERE ($1 AND tab_4426.col2_1)) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_4426 WHERE NOT (($1 AND tab_4426.col2_1))) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_4426 WHERE (($1 AND tab_4426.col2_1)) IS NULL)
		  | with args: [true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 95c82a7dbc6d6fecb63edbd666c9986d1ad3885b:

		  | - 		"85",
		  |   		``,1627004352,{",o.3qoz|axg": [], "a": [], "b": "kfxa7-qfs}", "bar``,
		  |   		``": [0.29496719397212323, false], "cx}(q2e)w'k": [{}], "foobar": ``,
		  |   		"[], \"m(|hi\": [{\"bar\": \"c\"}, []]},\x00",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 1063 identical bytes
		  |   		"2F841F8A8DEFEBC14DFC1AA281B9DA200F6410A39D5453875F7C1,\x15o,3644336",
		  |   		"829,000000100001011010000110010000011110001011,-846997834,v\x1cjb,-",
		  | - 		"846997835",
		  | + 		"1",
		  |   		``,-503207568,{"hbrm": {"+.g!nc2": false, "a": false, "baz": false``,
		  |   		``, "c": true, "yb4zsc": {"8@c-,{bt7": {}}}, "hr%qa": {}, "jlxo>":``,
		  |   		" [[{}], 0.09087505964025333, {}, true]},\x00",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 1689 identical bytes
		  |   		"C2FAC50F9B9899F5C1EE785B98D553F741ECCE9A0047E8F4C1,1\tQ(>\x11/B\x11,127",
		  |   		"7857138,010111000001111110101000000011011100010001,1315270434,0,",
		  | - 		"131527",
		  |   		"0",
		  | - 		"433",
		  |   		",1659060700,[[{\"$s|5jm\": [], \"baz\": {\"3qre'#1``\": \"b\", \"c\": [fals",
		  |   		``e, {"b": false, "q9(t'3x": {}}]}}, [], {}, {}], [false], {}, {}]``,
		  |   		",\x00",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 141 identical bytes
		  |   		"true],0000-01-01 12:32:07.884413 -0627 -0627,zs3h,NULL,\x02%\x12\",9890",
		  |   		"96493,110100101011011101001011011010100110111010,923229493,zs3h,",
		  | - 		"923229492",
		  | + 		"0",
		  |   		``,1267019759,[{"=[v(<xgxnznj": null, "?z]qp*/66wi": {}, "jgl": []``,
		  |   		``, "b": [[]], "p'm%\\dxgu,ze": {"foobar": "_pu"}, "u9jzo=b": fals``,
		  |   		"e}, [{}], true],\x00",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		... // 1286 identical bytes
		  |   		"7C34190AEDFB67302C74150A2C94B84B3D5C180916D69C0F2E141,Nxz\x05,25297",
		  |   		"69988,110111100111001111000111000011100011001011,485989715,oq0i,",
		  | - 		"485989714",
		  | + 		"0",
		  |   		``,829779981,{"1\\+\\y": {}, "d:^3k\\": [[]], "baz": {"z0qy": {}},``,
		  |   		" \"c\": \"baz\"},\x00",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table2 AS tab_2134
		  | (SELECT * FROM defaultdb.public.table2 AS tab_2134 WHERE (((st_minimumclearance('01050000800700000001020000800200000006F73BF8F13BF741393E7FE66E5BF1C188D5B200C438DBC1C8284E2D2250FC41B08D55D1DF3BF1412C1447546FFCF441010200008007000000C0F0038C4C35C9C128A210357307FCC166D3BEA3189BF341A01ADA98DB20B9C11CF826DA31F5F4C14CCAFB614659F3C13C2DD05F52A9E441E83419C8B89CE9C1914FF930B542FDC188BCB1AE06A2F6412C16C4EC86E9E641C8D523323FA3DEC1607731BBD80CFE4116951C08DA03F841DB9E4449180F01C21033B92BFBC10042B0D8F6DDE197FB412C4FAD99E47EF0C1603F0D851A75F941382C1C9DCE6CF94128CD47B76904E8410102000080040000003057AA617E09E9410865AD1602EDF2410AFF584E2273F841503D4523E9E6E34172F4B620616CF241201949A37E76B4C10474C0169107E9C11CDCEF949B7A0142D856654CD89DFF41C482C56C0270EAC1503F4523BF84F641A0BE052B6144CE41010200008002000000743ADE64F804F04110EAE3077EC8C4C1DA2BB0357688EAC1601FAB02F1F4FF4138365BE65D30E741A8C2085B3442F9C101020000800400000010BC4603511FCCC1F27955F78945EFC1B2A490D2131EF0C17011607231B5CBC1835788CD45F900C2E0118DA0928EB4C1789FE245ABA1E741FAE4B07CB146E8C1D839FEB804A0FCC19826D32BCD13EF41509F4FC130DDCBC186773965642DF14101020000800400000040D44611468CD2C102DA8D3AA63EFEC110076F7BB038DB4168E36BF36A07E641C7FA878D3D0501C2748BC4140D37FB417C97C91CE649FA4188009BA02D2101C2C0D7A11B68C8F7C1EC4167FE16D4F641ED11C1F1E58CF1C104FCA54263F2FE41010200008002000000D0C5F016B7B9E2C16030FE0E84A9B1C15C02E35E634BE341B40971A29DE2F54180261271126DAB41247E692DBF05F141'::GEOMETRY)::FLOAT8::FLOAT8 NOT IN (SELECT $1::FLOAT8 AS col_3034)) OR $2) OR $3)) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_2134 WHERE NOT ((((st_minimumclearance('01050000800700000001020000800200000006F73BF8F13BF741393E7FE66E5BF1C188D5B200C438DBC1C8284E2D2250FC41B08D55D1DF3BF1412C1447546FFCF441010200008007000000C0F0038C4C35C9C128A210357307FCC166D3BEA3189BF341A01ADA98DB20B9C11CF826DA31F5F4C14CCAFB614659F3C13C2DD05F52A9E441E83419C8B89CE9C1914FF930B542FDC188BCB1AE06A2F6412C16C4EC86E9E641C8D523323FA3DEC1607731BBD80CFE4116951C08DA03F841DB9E4449180F01C21033B92BFBC10042B0D8F6DDE197FB412C4FAD99E47EF0C1603F0D851A75F941382C1C9DCE6CF94128CD47B76904E8410102000080040000003057AA617E09E9410865AD1602EDF2410AFF584E2273F841503D4523E9E6E34172F4B620616CF241201949A37E76B4C10474C0169107E9C11CDCEF949B7A0142D856654CD89DFF41C482C56C0270EAC1503F4523BF84F641A0BE052B6144CE41010200008002000000743ADE64F804F04110EAE3077EC8C4C1DA2BB0357688EAC1601FAB02F1F4FF4138365BE65D30E741A8C2085B3442F9C101020000800400000010BC4603511FCCC1F27955F78945EFC1B2A490D2131EF0C17011607231B5CBC1835788CD45F900C2E0118DA0928EB4C1789FE245ABA1E741FAE4B07CB146E8C1D839FEB804A0FCC19826D32BCD13EF41509F4FC130DDCBC186773965642DF14101020000800400000040D44611468CD2C102DA8D3AA63EFEC110076F7BB038DB4168E36BF36A07E641C7FA878D3D0501C2748BC4140D37FB417C97C91CE649FA4188009BA02D2101C2C0D7A11B68C8F7C1EC4167FE16D4F641ED11C1F1E58CF1C104FCA54263F2FE41010200008002000000D0C5F016B7B9E2C16030FE0E84A9B1C15C02E35E634BE341B40971A29DE2F54180261271126DAB41247E692DBF05F141'::GEOMETRY)::FLOAT8::FLOAT8 NOT IN (SELECT $1::FLOAT8 AS col_3034)) OR $2) OR $3))) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_2134 WHERE ((((st_minimumclearance('01050000800700000001020000800200000006F73BF8F13BF741393E7FE66E5BF1C188D5B200C438DBC1C8284E2D2250FC41B08D55D1DF3BF1412C1447546FFCF441010200008007000000C0F0038C4C35C9C128A210357307FCC166D3BEA3189BF341A01ADA98DB20B9C11CF826DA31F5F4C14CCAFB614659F3C13C2DD05F52A9E441E83419C8B89CE9C1914FF930B542FDC188BCB1AE06A2F6412C16C4EC86E9E641C8D523323FA3DEC1607731BBD80CFE4116951C08DA03F841DB9E4449180F01C21033B92BFBC10042B0D8F6DDE197FB412C4FAD99E47EF0C1603F0D851A75F941382C1C9DCE6CF94128CD47B76904E8410102000080040000003057AA617E09E9410865AD1602EDF2410AFF584E2273F841503D4523E9E6E34172F4B620616CF241201949A37E76B4C10474C0169107E9C11CDCEF949B7A0142D856654CD89DFF41C482C56C0270EAC1503F4523BF84F641A0BE052B6144CE41010200008002000000743ADE64F804F04110EAE3077EC8C4C1DA2BB0357688EAC1601FAB02F1F4FF4138365BE65D30E741A8C2085B3442F9C101020000800400000010BC4603511FCCC1F27955F78945EFC1B2A490D2131EF0C17011607231B5CBC1835788CD45F900C2E0118DA0928EB4C1789FE245ABA1E741FAE4B07CB146E8C1D839FEB804A0FCC19826D32BCD13EF41509F4FC130DDCBC186773965642DF14101020000800400000040D44611468CD2C102DA8D3AA63EFEC110076F7BB038DB4168E36BF36A07E641C7FA878D3D0501C2748BC4140D37FB417C97C91CE649FA4188009BA02D2101C2C0D7A11B68C8F7C1EC4167FE16D4F641ED11C1F1E58CF1C104FCA54263F2FE41010200008002000000D0C5F016B7B9E2C16030FE0E84A9B1C15C02E35E634BE341B40971A29DE2F54180261271126DAB41247E692DBF05F141'::GEOMETRY)::FLOAT8::FLOAT8 NOT IN (SELECT $1::FLOAT8 AS col_3034)) OR $2) OR $3)) IS NULL)
		  | with args: [-1.007896547665084 false false]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		"001101110011110011,0.9656838774681091,?,3282562578,true,06b5b35d",
		  |   		"-7d5e-4685-802c-ecde6b48b397,",
		  | + 		"-",
		  |   		"0,BOX(0.19165184070958408 0.1764170732412108,1.1256017778774345 ",
		  |   		"0.6567656713781511),\x1c,true,-1564886152,1129849995,0,80fda057-03e",
		  |   		... // 183 identical bytes
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table4 AS tab_66276
		  | (SELECT * FROM defaultdb.public.table4 AS tab_66276 WHERE tab_66276.col4_9) UNION ALL (SELECT * FROM defaultdb.public.table4 AS tab_66276 WHERE NOT (tab_66276.col4_9)) UNION ALL (SELECT * FROM defaultdb.public.table4 AS tab_66276 WHERE (tab_66276.col4_9) IS NULL)
		  | with args: []
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity cockroach-teamcity mentioned this issue Feb 2, 2022
Closed
@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 16859b99637d1adedb915a67998749dbfa4c0663:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tlp/run_1
	tlp.go:157,tlp.go:70,test_runner.go:780: expected unpartitioned and partitioned results to be equal
		(1) attached stack trace
		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	/home/agent/work/.go/src/github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	/usr/local/go/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		"NULL,-189287829,990874835,NULL,127,1989-06-01 00:00:00 +0000 +00",
		  |   		"00,NULL,NULL,NULL,-189287702,-189287702,-189287702,NULL,-1",
		  | - 		"89287702",
		  |   	}, ""),
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table2 AS tab_9758
		  | (SELECT * FROM defaultdb.public.table2 AS tab_9758 WHERE ($1 OR $2)) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_9758 WHERE NOT (($1 OR $2))) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_9758 WHERE (($1 OR $2)) IS NULL)
		  | with args: [true true]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

The test failed on branch=master, cloud=gce:
test timed out (see artifacts for details)
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

The test failed on branch=master, cloud=gce:
test timed out (see artifacts for details)
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

		  -- stack trace:
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runTLPQuery.func2
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:230
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:255
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	"1974-02-20 19:58:10.000995 +0000 +0000,NULL,NULL,0000-01-01 21:1"...,
		  |   	strings.Join({
		  |   		... // 75 identical bytes
		  |   		"+1451 +1451,NULL,NULL,#Ifjh>B,0000-01-01 20:23:46.491022 +0712 +",
		  |   		"0712,7144,w,1975-01-23 00:00:00 +0000 +0000,NULL,d,NULL,#ifjh>b,",
		  | - 		"26861",
		  | + 		"0",
		  |   		",X\x1e\x1f\ri<Xc",
		  |   	}, ""),
		  |   	"2014-02-02 11:15:02.000657 +0000 +0000,NULL,true,0000-01-01 22:3"...,
		  |   	"2014-04-28 04:05:55.00089 +0000 +0000,null,1,0000-01-01 04:44:25"...,
		  |   	``2021-09-20 14:16:23.000826 +0000 +0000,{"#$BqG": [], "CXUSk": [{``...,
		  |   	"NULL,0.1796195439401533,NULL,0000-01-01 05:28:46.981666 -0202 -0"...,
		  |   	strings.Join({
		  |   		"NULL,NULL,NULL,0000-01-01 09:17:45.468255 -0635 -0635,NULL,-1.92",
		  |   		"31640100479126,NULL,NULL,9926, ,NULL,3344757055,\x0f,iuAr,\x13h,NULL,",
		  | - 		"29643",
		  | + 		"0",
		  |   		",``B}d",
		  |   	}, ""),
		  |   	strings.Join({
		  |   		"NULL,NULL,NULL,0000-01-01 12:59:16.28028 -0557 -0557,NULL,NULL,N",
		  |   		"ULL,0000-01-01 20:45:02.852248 -0321 -0321,-19748,~,NULL,3536523",
		  |   		"941,NULL,iuAr,\x13h,NULL,-",
		  | - 		"3",
		  |   		"1,``B}d",
		  |   	}, ""),
		  |   	``NULL,[{" os^-\"sf(4Fy": [], "L#!Hg,<#yO": {"~M(XX|": [{}]}, "baz``...,
		  |   	strings.Join({
		  |   		... // 147 identical bytes
		  |   		": true}},0000-01-01 18:17:48.210592 -0121 -0121,NULL,NULL,$B,NUL",
		  |   		"L,-15437,R,1981-05-08 00:00:00 +0000 +0000,2336421801,X,NULL,$b,",
		  | - 		"428",
		  |   		"0,``B}d",
		  |   	}, ""),
		  |   	``NULL,{"test": "json"},NULL,0000-01-01 12:26:35.766411 +0147 +014``...,
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table3 AS tab_2019
		  | (SELECT * FROM defaultdb.public.table3 AS tab_2019 WHERE st_dwithinexclusive('01020000E0E61000000B00000030DD3DDB4A6D56C0785BF76A30B728C04429E37436B2FD41EC3DCEFCBEF5F3C13CC84FE8F27756C034055045F5B64BC090AB37580C73EE41CC8039706DACF941A0D341229168574003A3D710C9CB55C0F07E63EE47DDE1414E0C119F143EEAC120EE4BEA24D75440A0B89C2353C10F40F456301BA94E024220804F97B9F6D541CEBB4B4ED8E661401C2BDA5D9D20434010E077C9EE17C6C1D658B4CEB150F241C8DF2FEF657B5340C00A6D282C494340A0D6D980914BCE41EC006F113C49E2C1F81D158D044A64404477BB0BAF715240104C69CF002E024282E94337C1ED0142F4094B8381CC4E401059296040A8474080AC24E455F293C150FEF8E7F53ADDC1C8A788A4F46839C0D84885EC39E14C40F53101A99A22F0C188DC81DF44D4E84168347D5060CB4AC07246A7D964F450401A02E124B63A0242F2FF534FF351E5C106E3FB784D0662C0CC095C0DDAFA53405090B0C50F52F241207282FE77550142'::GEOGRAPHY, NULL::GEOGRAPHY, $1::FLOAT8)::BOOL) UNION ALL (SELECT * FROM defaultdb.public.table3 AS tab_2019 WHERE NOT (st_dwithinexclusive('01020000E0E61000000B00000030DD3DDB4A6D56C0785BF76A30B728C04429E37436B2FD41EC3DCEFCBEF5F3C13CC84FE8F27756C034055045F5B64BC090AB37580C73EE41CC8039706DACF941A0D341229168574003A3D710C9CB55C0F07E63EE47DDE1414E0C119F143EEAC120EE4BEA24D75440A0B89C2353C10F40F456301BA94E024220804F97B9F6D541CEBB4B4ED8E661401C2BDA5D9D20434010E077C9EE17C6C1D658B4CEB150F241C8DF2FEF657B5340C00A6D282C494340A0D6D980914BCE41EC006F113C49E2C1F81D158D044A64404477BB0BAF715240104C69CF002E024282E94337C1ED0142F4094B8381CC4E401059296040A8474080AC24E455F293C150FEF8E7F53ADDC1C8A788A4F46839C0D84885EC39E14C40F53101A99A22F0C188DC81DF44D4E84168347D5060CB4AC07246A7D964F450401A02E124B63A0242F2FF534FF351E5C106E3FB784D0662C0CC095C0DDAFA53405090B0C50F52F241207282FE77550142'::GEOGRAPHY, NULL::GEOGRAPHY, $1::FLOAT8)::BOOL)) UNION ALL (SELECT * FROM defaultdb.public.table3 AS tab_2019 WHERE (st_dwithinexclusive('01020000E0E61000000B00000030DD3DDB4A6D56C0785BF76A30B728C04429E37436B2FD41EC3DCEFCBEF5F3C13CC84FE8F27756C034055045F5B64BC090AB37580C73EE41CC8039706DACF941A0D341229168574003A3D710C9CB55C0F07E63EE47DDE1414E0C119F143EEAC120EE4BEA24D75440A0B89C2353C10F40F456301BA94E024220804F97B9F6D541CEBB4B4ED8E661401C2BDA5D9D20434010E077C9EE17C6C1D658B4CEB150F241C8DF2FEF657B5340C00A6D282C494340A0D6D980914BCE41EC006F113C49E2C1F81D158D044A64404477BB0BAF715240104C69CF002E024282E94337C1ED0142F4094B8381CC4E401059296040A8474080AC24E455F293C150FEF8E7F53ADDC1C8A788A4F46839C0D84885EC39E14C40F53101A99A22F0C188DC81DF44D4E84168347D5060CB4AC07246A7D964F450401A02E124B63A0242F2FF534FF351E5C106E3FB784D0662C0CC095C0DDAFA53405090B0C50F52F241207282FE77550142'::GEOGRAPHY, NULL::GEOGRAPHY, $1::FLOAT8)::BOOL) IS NULL)
		  | with args: [0.07168772721217781]
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
	test_runner.go:909,test_runner.go:808: test timed out (1h0m0s)
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
	test_runner.go:909,test_runner.go:808: test timed out (1h0m0s)
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 8548987813ff9e1b8a9878023d3abfc6911c16db:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
	test_runner.go:909,test_runner.go:808: test timed out (1h0m0s)
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@rytaft
Copy link
Collaborator

rytaft commented Feb 7, 2022

I wonder why we keep getting timeouts. Didn't we make a change to make this test run longer recently? Should we make a corresponding change to the timeout?

@mgartner
Copy link
Collaborator

mgartner commented Feb 7, 2022

Recent changes to TLP were in #74569 and #74581. There should be 5 minutes that allow the test to cool down and exit cleanly. Maybe that's not enough time, but I'm skeptical that any queries in a 10 minute TLP run would take longer than 5 minutes.

@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ a7b1c17c240c935056f87f29dfc1ee75611c371e:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
	test_runner.go:909,test_runner.go:808: test timed out (1h0m0s)
Help

See: roachtest README

See: How To Investigate (internal)

Same failure on other branches

This test on roachdash | Improve this report!

@jordanlewis
Copy link
Member

Here's the last chunk of the test log:

14:16:47 tlp.go:132: test status: running TLP
14:16:50 tlp.go:145: test status: running TLP: 1000 statements completed
14:16:57 tlp.go:145: test status: running TLP: 2000 statements completed
14:17:05 tlp.go:145: test status: running TLP: 3000 statements completed
14:17:13 tlp.go:145: test status: running TLP: 4000 statements completed
14:17:20 tlp.go:145: test status: running TLP: 5000 statements completed
14:17:27 tlp.go:145: test status: running TLP: 6000 statements completed
14:17:34 tlp.go:145: test status: running TLP: 7000 statements completed
14:17:42 tlp.go:145: test status: running TLP: 8000 statements completed
14:17:49 tlp.go:145: test status: running TLP: 9000 statements completed
14:17:56 tlp.go:145: test status: running TLP: 10000 statements completed
14:18:04 tlp.go:145: test status: running TLP: 11000 statements completed
14:18:11 tlp.go:145: test status: running TLP: 12000 statements completed
14:18:19 tlp.go:145: test status: running TLP: 13000 statements completed
14:18:26 tlp.go:145: test status: running TLP: 14000 statements completed
14:18:35 tlp.go:145: test status: running TLP: 15000 statements completed
14:18:42 tlp.go:145: test status: running TLP: 16000 statements completed
14:18:51 tlp.go:145: test status: running TLP: 17000 statements completed
14:18:59 tlp.go:145: test status: running TLP: 18000 statements completed
14:19:07 tlp.go:145: test status: running TLP: 19000 statements completed
14:19:16 tlp.go:145: test status: running TLP: 20000 statements completed
14:19:24 tlp.go:145: test status: running TLP: 21000 statements completed
14:19:33 tlp.go:145: test status: running TLP: 22000 statements completed
14:19:41 tlp.go:145: test status: running TLP: 23000 statements completed
14:19:50 tlp.go:145: test status: running TLP: 24000 statements completed
14:19:58 tlp.go:145: test status: running TLP: 25000 statements completed
14:20:07 tlp.go:145: test status: running TLP: 26000 statements completed
14:20:16 tlp.go:145: test status: running TLP: 27000 statements completed
14:20:25 tlp.go:145: test status: running TLP: 28000 statements completed
14:20:34 tlp.go:145: test status: running TLP: 29000 statements completed
14:20:43 tlp.go:145: test status: running TLP: 30000 statements completed
14:20:52 tlp.go:145: test status: running TLP: 31000 statements completed
14:21:01 tlp.go:145: test status: running TLP: 32000 statements completed
14:21:11 tlp.go:145: test status: running TLP: 33000 statements completed
14:21:20 tlp.go:145: test status: running TLP: 34000 statements completed
14:21:29 tlp.go:145: test status: running TLP: 35000 statements completed
14:21:39 tlp.go:145: test status: running TLP: 36000 statements completed
14:21:49 tlp.go:145: test status: running TLP: 37000 statements completed
14:21:59 tlp.go:145: test status: running TLP: 38000 statements completed
14:22:09 tlp.go:145: test status: running TLP: 39000 statements completed
14:22:18 tlp.go:145: test status: running TLP: 40000 statements completed
14:22:28 tlp.go:145: test status: running TLP: 41000 statements completed
14:22:37 tlp.go:145: test status: running TLP: 42000 statements completed
14:22:47 tlp.go:145: test status: running TLP: 43000 statements completed
14:22:57 tlp.go:145: test status: running TLP: 44000 statements completed
14:23:06 tlp.go:145: test status: running TLP: 45000 statements completed
14:23:16 tlp.go:145: test status: running TLP: 46000 statements completed
14:23:27 tlp.go:145: test status: running TLP: 47000 statements completed
14:23:37 tlp.go:145: test status: running TLP: 48000 statements completed
14:23:48 tlp.go:145: test status: running TLP: 49000 statements completed
14:23:58 tlp.go:145: test status: running TLP: 50000 statements completed
14:24:08 tlp.go:145: test status: running TLP: 51000 statements completed
14:24:19 tlp.go:145: test status: running TLP: 52000 statements completed
14:24:29 tlp.go:145: test status: running TLP: 53000 statements completed
14:24:40 tlp.go:145: test status: running TLP: 54000 statements completed
14:24:52 tlp.go:145: test status: running TLP: 55000 statements completed
14:25:05 tlp.go:145: test status: running TLP: 56000 statements completed
14:25:16 tlp.go:145: test status: running TLP: 57000 statements completed
14:25:26 tlp.go:145: test status: running TLP: 58000 statements completed
14:25:36 tlp.go:145: test status: running TLP: 59000 statements completed
14:25:47 tlp.go:145: test status: running TLP: 60000 statements completed
14:25:57 tlp.go:145: test status: running TLP: 61000 statements completed
14:26:06 test_runner.go:794: test timed out after 1h0m0s; check __stacks.log and CRDB logs for goroutine dumps

The issue is that the test stops running new iterations at 5 minutes before the whole test ends, but iterations are 10 minutes long, so that 5 minute check never gets hit.

@jordanlewis jordanlewis mentioned this issue Feb 8, 2022
Merged
@craig craig bot closed this as completed in 4d95f56 Feb 8, 2022
SQL Queries automation moved this from Triage to Done Feb 8, 2022
@mgartner mgartner mentioned this issue Feb 15, 2022
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-master Failures on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. T-sql-queries SQL Queries Team
Projects
SQL Queries
Archived in project
SQL Queries
Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

tlp: respect test shutdown deadline jordanlewis/cockroach
4 participants
@jordanlewis @mgartner @rytaft @cockroach-teamcity