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 #78327

Closed
cockroach-teamcity opened this issue Mar 23, 2022 · 2 comments
Closed

roachtest: tlp failed #78327

cockroach-teamcity opened this issue Mar 23, 2022 · 2 comments
Labels
branch-master Failures and bugs 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

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Mar 23, 2022 •
edited by cockroach-jira-scripts
Loading

roachtest.tlp failed with artifacts on master @ e02793d3e214c5b716149963369aa72f9338ac0d:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
	tlp.go:172,tlp.go:76,test_runner.go:875: 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:245
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:270
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  | + 	"-0,NULL,NULL,-34 years -10 mons -57 days -05:03:57.537221,3688022088,true,NULL,0,1100010000000101000111000101,8d8f:4c45:6afb:5b71:adf9:8b67:acf4:88b6/99,0000-01-01 05:22:46.095244 +0000 UTC,c1756fdd-1fd6-4016-a914-a676eb3e94e0,05:22:46.095244,8d8f:4c45:6af"...,
		  | + 	"-0,NULL,NULL,-34 years -10 mons -57 days -05:03:57.537221,3688022088,true,NULL,NULL,0010010110111100110101001010,192.168.87.86/31,0000-01-01 13:49:21.258349 +0000 UTC,5293b7da-9524-4a48-b960-51803f3243cb,13:49:21.258349,192.168.87.86/31,5293b7da-9524-4a48-"...,
		  | + 	"-0,NULL,NULL,-34 years -10 mons -57 days -05:03:57.537221,3688022088,true,NULL,NULL,1000100011101110000101100001,ca5:aa4b:ef75:b238:e097:503:121d:7375/76,0000-01-01 07:02:07.211704 +0000 UTC,2c1a0c72-d900-4609-8354-4a3debdc0734,07:02:07.211704,ca5:aa4b:ef7"...,
		  | + 	"-0,NULL,NULL,-34 years -10 mons -57 days -05:03:57.537221,3688022088,true,NULL,NULL,1001101000111110000000010000,8e69:76fd:b734:44e2:5942:957e:bf4f:a532/93,0000-01-01 12:16:45.991813 +0000 UTC,f39aa0db-cb6c-4362-8e02-541ac4509e20,12:16:45.991813,8e69:76fd:"...,
		  |   	"-1.3773848405010947,1669498689,NULL,21 years 6 mons 761 days 01:"...,
		  |   	"-1.3773848405010947,1669498689,NULL,21 years 6 mons 761 days 01:"...,
		  |   	"-1.3773848405010947,1669498689,NULL,21 years 6 mons 761 days 01:"...,
		  |   	"-1.3773848405010947,1669498689,NULL,21 years 6 mons 761 days 01:"...,
		  | - 	"0,NULL,NULL,-34 years -10 mons -57 days -05:03:57.537221,3688022088,true,NULL,0,1100010000000101000111000101,8d8f:4c45:6afb:5b71:adf9:8b67:acf4:88b6/99,0000-01-01 05:22:46.095244 +0000 UTC,c1756fdd-1fd6-4016-a914-a676eb3e94e0,05:22:46.095244,8d8f:4c45:6afb"...,
		  | - 	"0,NULL,NULL,-34 years -10 mons -57 days -05:03:57.537221,3688022088,true,NULL,NULL,0010010110111100110101001010,192.168.87.86/31,0000-01-01 13:49:21.258349 +0000 UTC,5293b7da-9524-4a48-b960-51803f3243cb,13:49:21.258349,192.168.87.86/31,5293b7da-9524-4a48-b"...,
		  | - 	"0,NULL,NULL,-34 years -10 mons -57 days -05:03:57.537221,3688022088,true,NULL,NULL,1000100011101110000101100001,ca5:aa4b:ef75:b238:e097:503:121d:7375/76,0000-01-01 07:02:07.211704 +0000 UTC,2c1a0c72-d900-4609-8354-4a3debdc0734,07:02:07.211704,ca5:aa4b:ef75"...,
		  | - 	"0,NULL,NULL,-34 years -10 mons -57 days -05:03:57.537221,3688022088,true,NULL,NULL,1001101000111110000000010000,8e69:76fd:b734:44e2:5942:957e:bf4f:a532/93,0000-01-01 12:16:45.991813 +0000 UTC,f39aa0db-cb6c-4362-8e02-541ac4509e20,12:16:45.991813,8e69:76fd:b"...,
		  |   	"0.0014548777504855281,NULL,NULL,-31 years -11 mons -850 days -18"...,
		  |   	"0.0014548777504855281,NULL,NULL,-31 years -11 mons -850 days -18"...,
		  |   	... // 6 identical elements
		  |   }
		  | sql: SELECT * FROM defaultdb.public.table2 AS tab_33469 JOIN defaultdb.public.table3 AS tab_33470 ON true
		  | (SELECT * FROM defaultdb.public.table2 AS tab_33469 JOIN defaultdb.public.table3 AS tab_33470 ON tab_33469.col2_5) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_33469 JOIN defaultdb.public.table3 AS tab_33470 ON NOT (tab_33469.col2_5)) UNION ALL (SELECT * FROM defaultdb.public.table2 AS tab_33469 JOIN defaultdb.public.table3 AS tab_33470 ON (tab_33469.col2_5) IS NULL)
		  | with args: []
		Error types: (1) *withstack.withStack (2) *errutil.leafError
Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-14068
@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs 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 Mar 23, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Mar 23, 2022
@cockroach-teamcity cockroach-teamcity mentioned this issue Mar 25, 2022
Closed
@cockroach-teamcity
Copy link
Member Author

roachtest.tlp failed with artifacts on master @ 32b45c4bcf1ab41f0ba3abd36cb670eea7f450fd:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
	tlp.go:172,tlp.go:76,test_runner.go:875: 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:245
		  | github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
		  | 	github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:270
		  | runtime.goexit
		  | 	GOROOT/src/runtime/asm_amd64.s:1581
		Wraps: (2) expected unpartitioned and partitioned results to be equal
		  |   []string{
		  |   	strings.Join({
		  |   		"1347813876,NULL,0000-01-01 05:22:26.028612 +0000 UTC,w,",
		  | - 		"-",
		  |   		"0,\x11,true,false,false,true,false,false",
		  |   	}, ""),
		  |   }
		  | sql: SELECT *, tab_31837.col4_3 NOT LIKE tab_31837.col4_5, NOT (tab_31837.col4_3 NOT LIKE tab_31837.col4_5), (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) IS NULL, true, false, false FROM defaultdb.public.table4 AS tab_31837
		  | (SELECT *,
		  | tab_31837.col4_3 NOT LIKE tab_31837.col4_5, NOT (tab_31837.col4_3 NOT LIKE tab_31837.col4_5), (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) IS NULL,
		  | tab_31837.col4_3 NOT LIKE tab_31837.col4_5, NOT (tab_31837.col4_3 NOT LIKE tab_31837.col4_5), (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) IS NULL
		  | FROM defaultdb.public.table4 AS tab_31837
		  | WHERE tab_31837.col4_3 NOT LIKE tab_31837.col4_5)
		  | UNION ALL (SELECT *,
		  | tab_31837.col4_3 NOT LIKE tab_31837.col4_5, NOT (tab_31837.col4_3 NOT LIKE tab_31837.col4_5), (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) IS NULL,
		  | NOT (tab_31837.col4_3 NOT LIKE tab_31837.col4_5), tab_31837.col4_3 NOT LIKE tab_31837.col4_5, (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) IS NULL
		  | FROM defaultdb.public.table4 AS tab_31837
		  | WHERE NOT (tab_31837.col4_3 NOT LIKE tab_31837.col4_5))
		  | UNION ALL (SELECT *,
		  | tab_31837.col4_3 NOT LIKE tab_31837.col4_5, NOT (tab_31837.col4_3 NOT LIKE tab_31837.col4_5), (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) IS NULL,
		  | (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) IS NULL, (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) IS NOT NULL, (NOT (tab_31837.col4_3 NOT LIKE tab_31837.col4_5)) IS NOT NULL
		  | FROM defaultdb.public.table4 AS tab_31837
		  | WHERE (tab_31837.col4_3 NOT LIKE tab_31837.col4_5) 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!

@rytaft
Copy link
Collaborator

rytaft commented Mar 28, 2022

Dup of #77279

@rytaft rytaft closed this as completed Mar 28, 2022
@mgartner mgartner moved this to Done in SQL Queries Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-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
Milestone
No milestone
Development

No branches or pull requests
2 participants
@rytaft @cockroach-teamcity