roachtest: tlp failed on complex join condition involving geometry #84957
Description
roachtest.tlp failed with artifacts on release-22.1 @ 3fbf4a9d769e6db6aafd8a241a2a09b7c5e33738:
The test failed on branch=release-22.1, cloud=gce:
test artifacts and logs in: /artifacts/tlp/run_1
tlp.go:179,tlp.go:76,test_runner.go:883: 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:266
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests.runWithTimeout.func1
| github.com/cockroachdb/cockroach/pkg/cmd/roachtest/tests/tlp.go:289
| runtime.goexit
| GOROOT/src/runtime/asm_amd64.s:1581
Wraps: (2) expected unpartitioned and partitioned results to be equal
| []string{
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| ... // 11 identical elements
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| + "105.62.204.94/25,1973-06-22 00:00:00 +0000 +0000,BOX(0.014666717427117393 -0.17670277548785074,1.3762302200845573 1.9520902929095347),0106000000090000000103000000010000000B000000062BEC748F1DFDC140EB1CC33E3FA7C143D20AA19059F8C100CC1E9BEF7777C179CD21AB5AFDF2"...,
| ... // 656 identical and 656 inserted elements
| }
| sql: SELECT * FROM defaultdb.public.table1 AS tab_13521 JOIN defaultdb.public.table1 AS tab_13522 ON true
| (SELECT * FROM defaultdb.public.table1 AS tab_13521 JOIN defaultdb.public.table1 AS tab_13522 ON tab_13521.col1_3::GEOMETRY NOT IN (WITH with_341 (col_893) AS (SELECT tab_13523.col1_4 AS col_893 FROM defaultdb.public.table1@table1_col1_0_key AS tab_13523 WHERE true) SELECT st_makeline('01030000C0010000000A000000E3541998A11EF4C1C67BC6F18E0CECC16004C47A6465BEC16261323B0A0B02C2A33FBDE96D28FAC129F4CF457C3CF3C1F0140B9AFE96CB41FECB17EE639BF5C1FC247EB9A4A1F14109C4D1CC823CF3C10C0DFBF987C1F0C1702A1D6536E6EDC1EAD22042D4950142EFEBD6B09485FBC13C047ED673D8E14180C023B327CDB6416090BD005C36FC4100CB95253527994110AD54A4EFF5DB4138A60149E149FD41367E609059ADF741A05C761FB9ACB74117BB44BCE60AFBC18E7212E96300EBC182F302118343F0417883F37F03D2E54120F5A6A828C1EB411812EB8CC687DB416047BC2FA05BE9C1D8280DA81393FB410044FB875BBAEE41264046DE3D4D00C29BCEDD83824C01C270909E5D4896FF4144A4A6C7236FEE4130F610770050DCC1E3541998A11EF4C1C67BC6F18E0CECC16004C47A6465BEC16261323B0A0B02C2'::GEOMETRY)::GEOMETRY::GEOMETRY AS col_894 FROM with_341 AS cte_ref_115 WHERE true GROUP BY cte_ref_115.col_893 LIMIT 23)) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_13521 JOIN defaultdb.public.table1 AS tab_13522 ON NOT (tab_13521.col1_3::GEOMETRY NOT IN (WITH with_341 (col_893) AS (SELECT tab_13523.col1_4 AS col_893 FROM defaultdb.public.table1@table1_col1_0_key AS tab_13523 WHERE true) SELECT st_makeline('01030000C0010000000A000000E3541998A11EF4C1C67BC6F18E0CECC16004C47A6465BEC16261323B0A0B02C2A33FBDE96D28FAC129F4CF457C3CF3C1F0140B9AFE96CB41FECB17EE639BF5C1FC247EB9A4A1F14109C4D1CC823CF3C10C0DFBF987C1F0C1702A1D6536E6EDC1EAD22042D4950142EFEBD6B09485FBC13C047ED673D8E14180C023B327CDB6416090BD005C36FC4100CB95253527994110AD54A4EFF5DB4138A60149E149FD41367E609059ADF741A05C761FB9ACB74117BB44BCE60AFBC18E7212E96300EBC182F302118343F0417883F37F03D2E54120F5A6A828C1EB411812EB8CC687DB416047BC2FA05BE9C1D8280DA81393FB410044FB875BBAEE41264046DE3D4D00C29BCEDD83824C01C270909E5D4896FF4144A4A6C7236FEE4130F610770050DCC1E3541998A11EF4C1C67BC6F18E0CECC16004C47A6465BEC16261323B0A0B02C2'::GEOMETRY)::GEOMETRY::GEOMETRY AS col_894 FROM with_341 AS cte_ref_115 WHERE true GROUP BY cte_ref_115.col_893 LIMIT 23))) UNION ALL (SELECT * FROM defaultdb.public.table1 AS tab_13521 JOIN defaultdb.public.table1 AS tab_13522 ON (tab_13521.col1_3::GEOMETRY NOT IN (WITH with_341 (col_893) AS (SELECT tab_13523.col1_4 AS col_893 FROM defaultdb.public.table1@table1_col1_0_key AS tab_13523 WHERE true) SELECT st_makeline('01030000C0010000000A000000E3541998A11EF4C1C67BC6F18E0CECC16004C47A6465BEC16261323B0A0B02C2A33FBDE96D28FAC129F4CF457C3CF3C1F0140B9AFE96CB41FECB17EE639BF5C1FC247EB9A4A1F14109C4D1CC823CF3C10C0DFBF987C1F0C1702A1D6536E6EDC1EAD22042D4950142EFEBD6B09485FBC13C047ED673D8E14180C023B327CDB6416090BD005C36FC4100CB95253527994110AD54A4EFF5DB4138A60149E149FD41367E609059ADF741A05C761FB9ACB74117BB44BCE60AFBC18E7212E96300EBC182F302118343F0417883F37F03D2E54120F5A6A828C1EB411812EB8CC687DB416047BC2FA05BE9C1D8280DA81393FB410044FB875BBAEE41264046DE3D4D00C29BCEDD83824C01C270909E5D4896FF4144A4A6C7236FEE4130F610770050DCC1E3541998A11EF4C1C67BC6F18E0CECC16004C47A6465BEC16261323B0A0B02C2'::GEOMETRY)::GEOMETRY::GEOMETRY AS col_894 FROM with_341 AS cte_ref_115 WHERE true GROUP BY cte_ref_115.col_893 LIMIT 23)) IS NULL)
| with args: []
Error types: (1) *withstack.withStack (2) *errutil.leafError
This test on roachdash | Improve this report!
Jira issue: CRDB-17971
Metadata
Metadata
Assignees
Labels
Type
Projects
Status