cockroach-teamcity
commented
1 week ago ccl/changefeedccl.TestChangefeedRandomExpressions failed on release-24.1.7-rc @ 3613a619e327fb412ac62036ce2c7060c25e48db:
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT (netmask('4970:957c:f887:5e3:6b8:4ba4:b08a:c5c6/103':::INET::INET)::INET::INET << (seed._inet::INET | seed._inet::INET)::INET::INET)::BOOL)
changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (NOT (netmask('4970:957c:f887:5e3:6b8:4ba4:b08a:c5c6/103':::INET::INET)::INET::INET << (seed._inet::INET | seed._inet::INET)::INET::INET)::BOOL) to emit 94 events
testfeed_test.go:301: creating external connection
testfeed_test.go:304: ran create external connection
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE false
changefeed_test.go:1118: Skipping predicate false because it returned no rows
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT (e'V\x17d?F\x01':::STRING NOT LIKE NULL))
changefeed_test.go:1118: Skipping predicate (NOT (e'V\x17d?F\x01':::STRING NOT LIKE NULL)) because it returned no rows
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT NULL AS "cOl_138" FROM d.public.seed AS tab_48 JOIN d.public.seed AS tab_49 ON (((tab_48._int8) = (tab_49._int8)) AND ((tab_48._date) = (tab_49._date))) AND ((tab_48._float8) = (tab_49._float8)) GROUP BY seed._float8 HAVING EXISTS (SELECT 846643290:::REGPROC AS "%vcol_135", seed._bytes AS col_136, '{"AhLWFc1P": true, "ESN": true, "Rug": true, "hz": [null]}':::JSONB AS 😬col_137 FROM d.public.seed@[0] AS t😽ab_50 JOIN d.public.seed@[0] AS tab_51 JOIN d.public.seed@[0] AS tab_52 ON (((tab_51._float8) = (tab_52._float8)) AND ((tab_51._enum) = (tab_52._enum))) AND ((tab_51._timestamp) = (tab_52._timestamp)) ON ((t😽ab_50._float4) = (tab_52._float4)) AND ((t😽ab_50.crdb_internal_mvcc_timestamp) = (tab_52._decimal)) WHERE seed._bool))
changefeed_test.go:1118: Skipping predicate EXISTS (SELECT NULL AS "cOl_138" FROM d.public.seed AS tab_48 JOIN d.public.seed AS tab_49 ON (((tab_48._int8) = (tab_49._int8)) AND ((tab_48._date) = (tab_49._date))) AND ((tab_48._float8) = (tab_49._float8)) GROUP BY seed._float8 HAVING EXISTS (SELECT 846643290:::REGPROC AS "%vcol_135", seed._bytes AS col_136, '{"AhLWFc1P": true, "ESN": true, "Rug": true, "hz": [null]}':::JSONB AS 😬col_137 FROM d.public.seed@[0] AS t😽ab_50 JOIN d.public.seed@[0] AS tab_51 JOIN d.public.seed@[0] AS tab_52 ON (((tab_51._float8) = (tab_52._float8)) AND ((tab_51._enum) = (tab_52._enum))) AND ((tab_51._timestamp) = (tab_52._timestamp)) ON ((t😽ab_50._float4) = (tab_52._float4)) AND ((t😽ab_50.crdb_internal_mvcc_timestamp) = (tab_52._decimal)) WHERE seed._bool)) because it returned no rows
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._inet::INET >> seed._inet::INET)::BOOL
changefeed_test.go:1118: Skipping predicate (seed._inet::INET >> seed._inet::INET)::BOOL because it returned no rows
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (inet(((-1120025403343538171):::INT8::INT8 + '13.162.168.2/30':::INET::INET)::INET::INET)::INET::INET >> seed._inet::INET)::BOOL
changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (inet(((-1120025403343538171):::INT8::INT8 + '13.162.168.2/30':::INET::INET)::INET::INET)::INET::INET >> seed._inet::INET)::BOOL because error pq: result out of range
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT NULL AS " co͘😫l_167" FROM d.public.seed@[0] AS tab_68 JOIN d.public.seed@[0] AS "t)ab_69" ON (tab_68._int4) = ("t)ab_69"._int4) JOIN d.public.seed AS "
tab._70" JOIN d.public.seed AS tab_71 ON ("
tab._70"._jsonb) = (tab_71._jsonb) ON ("t)ab_69"._jsonb) = ("
tab._70"._jsonb) WHERE seed._bool ORDER BY seed._int8 DESC NULLS LAST, seed._int8 NULLS FIRST)
changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT NULL AS " co͘😫l_167" FROM d.public.seed@[0] AS tab_68 JOIN d.public.seed@[0] AS "t)ab_69" ON (tab_68._int4) = ("t)ab_69"._int4) JOIN d.public.seed AS "
tab._70" JOIN d.public.seed AS tab_71 ON ("
tab._70"._jsonb) = (tab_71._jsonb) ON ("t)ab_69"._jsonb) = ("
tab._70"._jsonb) WHERE seed._bool ORDER BY seed._int8 DESC NULLS LAST, seed._int8 NULLS FIRST) to emit 45 events
testfeed_test.go:301: creating external connection
testfeed_test.go:304: ran create external connection
changefeed_test.go:1125: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (true AND ((parse_interval('':::STRING::STRING, seed._string::STRING)::INTERVAL::INTERVAL + '13:14:43.584838+08:31':::TIMETZ::TIMETZ)::TIMETZ::TIMETZ NOT IN ('23:12:40.442461-04:23':::TIMETZ,)))
changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (true AND ((parse_interval('':::STRING::STRING, seed._string::STRING)::INTERVAL::INTERVAL + '13:14:43.584838+08:31':::TIMETZ::TIMETZ)::TIMETZ::TIMETZ NOT IN ('23:12:40.442461-04:23':::TIMETZ,))) because error pq: parse_interval(): invalid IntervalStyle: 1
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_containsproperly(COALESCE('010400008007000000010100008020D21CBB8937CA41603742CC45EFEAC19E19A3FD742702C20101000080F8DABDD33BAEFE4160EAC851350BC9C150131A9A399800C201010000804D3505574966FBC122FC6A42CBD4E5C1307DDD0AED87D1C101010000800C477DB0198E0242583797A6924C0142A80B71124A79E8410101000080B07B200B1A31FE4116F11C076D34FBC1C5CC143DE67A01C2010100008036BAF4F599A900C250525AC6611BEF410E95A003736DF041010100008036FDA87DA2BBE4C140D84ABF471CB44120AC44164B0BC141':::GEOMETRY, '010700004000000000':::GEOMETRY)::GEOMETRY, '010200000004000000E84960C16E07DB41B65B21EBB946EAC15016CF92A12ED941E0C4FCB0E1E8C341548376E90BC1EC41AAD6716F01440142648F9F5FA16CE3C1688943A4CC31D041':::GEOMETRY::GEOMETRY)::BOOL
changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_containsproperly(COALESCE('010400008007000000010100008020D21CBB8937CA41603742CC45EFEAC19E19A3FD742702C20101000080F8DABDD33BAEFE4160EAC851350BC9C150131A9A399800C201010000804D3505574966FBC122FC6A42CBD4E5C1307DDD0AED87D1C101010000800C477DB0198E0242583797A6924C0142A80B71124A79E8410101000080B07B200B1A31FE4116F11C076D34FBC1C5CC143DE67A01C2010100008036BAF4F599A900C250525AC6611BEF410E95A003736DF041010100008036FDA87DA2BBE4C140D84ABF471CB44120AC44164B0BC141':::GEOMETRY, '010700004000000000':::GEOMETRY)::GEOMETRY, '010200000004000000E84960C16E07DB41B65B21EBB946EAC15016CF92A12ED941E0C4FCB0E1E8C341548376E90BC1EC41AAD6716F01440142648F9F5FA16CE3C1688943A4CC31D041':::GEOMETRY::GEOMETRY)::BOOL because error pq: st_containsproperly(): geos: no locations to init GEOS
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT '':::VOID AS "{col_219" FROM d.public.seed@[0] AS tab_88 JOIN d.public.seed@[0] AS tab_89 ON ((tab_88._int8) = (tab_89._int4)) AND ((tab_88._timestamptz) = (tab_89._timestamptz)))
changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT '':::VOID AS "{col_219" FROM d.public.seed@[0] AS tab_88 JOIN d.public.seed@[0] AS tab_89 ON ((tab_88._int8) = (tab_89._int4)) AND ((tab_88._timestamptz) = (tab_89._timestamptz))) to emit 100 events
testfeed_test.go:301: creating external connection
testfeed_test.go:304: ran create external connection
changefeed_test.go:1125: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (false OR EXISTS (SELECT CASE WHEN seed._bool THEN ARRAY[]:::FLOAT4[] ELSE ARRAY[(-0.12115942686796188):::FLOAT8, 2.175978422164917:::FLOAT8] END AS "cOl _223" FROM d.public.seed@[0] AS tab̗_91 WHERE seed._bool ORDER BY seed._bool ASC NULLS FIRST))
changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (false OR EXISTS (SELECT CASE WHEN seed._bool THEN ARRAY[]:::FLOAT4[] ELSE ARRAY[(-0.12115942686796188):::FLOAT8, 2.175978422164917:::FLOAT8] END AS "cOl _223" FROM d.public.seed@[0] AS tab̗_91 WHERE seed._bool ORDER BY seed._bool ASC NULLS FIRST)) to emit 45 events
testfeed_test.go:301: creating external connection
testfeed_test.go:304: ran create external connection
changefeed_test.go:1125: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT seed._date AS "%11col_228", seed._int2 AS "%qcol_229")
changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT seed._date AS "%11col_228", seed._int2 AS "%qcol_229") to emit 100 events
testfeed_test.go:301: creating external connection
testfeed_test.go:304: ran create external connection
changefeed_test.go:1125: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_dwithinexclusive(seed._string::STRING, seed._string::STRING, (-1.4314917669211003):::FLOAT8::FLOAT8)::BOOL
changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_dwithinexclusive(seed._string::STRING, seed._string::STRING, (-1.4314917669211003):::FLOAT8::FLOAT8)::BOOL because error pq: st_dwithinexclusive(): error parsing EWKT: syntax error: unexpected NUM at line 1, pos 0
LINE 1: 1
^
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (('-infinity':::DATE::DATE IN (('1986-11-07':::DATE::DATE - setval(e'*S#\x0eRH9\'O':::STRING::STRING, COALESCE((-5731532031445566299):::INT8, (-4502446988366063976):::INT8)::INT8, false::BOOL)::INT8::INT8)::DATE, '1990-12-03':::DATE, COALESCE('1997-04-17':::DATE, date(1427735412769696788:::INT8::INT8)::DATE))) AND false)
changefeed_test.go:1118: Skipping predicate (('-infinity':::DATE::DATE IN (('1986-11-07':::DATE::DATE - setval(e'*S#\x0eRH9\'O':::STRING::STRING, COALESCE((-5731532031445566299):::INT8, (-4502446988366063976):::INT8)::INT8, false::BOOL)::INT8::INT8)::DATE, '1990-12-03':::DATE, COALESCE('1997-04-17':::DATE, date(1427735412769696788:::INT8::INT8)::DATE))) AND false) because it returned no rows
changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._date::DATE - seed._date::DATE)::INT8::INT8 IN (seed._int8, (-9206366187569490931):::INT8, seed._int8, seed._int8)
changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._date::DATE - seed._date::DATE)::INT8::INT8 IN (seed._int8, (-9206366187569490931):::INT8, seed._int8, seed._int8) to emit 2 events
testfeed_test.go:301: creating external connection
testfeed_test.go:304: ran create external connection
changefeed_test.go:1139: cannot subtract infinite dates
--- FAIL: TestChangefeedRandomExpressions/kafka (7.87s)Parameters:
attempt=1run=7shard=10Help
See also: How To Investigate a Go Test Failure (internal)
Same failure on other branches
- #135269 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.2.5-rc release-blocker] - #133049 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.3] - #132516 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-23.2.13-rc] - #131898 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc X-duplicate branch-release-24.1.6-rc release-blocker] - #131179 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.5-rc] - #129173 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.2.0-rc] - #128772 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.3-rc] - #127642 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.2] - #126889 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.2-rc] - #124738 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1]
ccl/changefeedccl.TestChangefeedRandomExpressions failed on release-24.1.7-rc @ 798ba33ba875ff220c7a5d06ccac31924ca38074:
Parameters:
attempt=1deadlock=truerun=2shard=10Help
See also: How To Investigate a Go Test Failure (internal)
Same failure on other branches
- #133049 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.3] - #132516 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-23.2.13-rc] - #131898 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc X-duplicate branch-release-24.1.6-rc release-blocker] - #131179 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.5-rc] - #129173 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.2.0-rc] - #128772 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.3-rc] - #127642 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.2] - #126889 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.2-rc] - #124738 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1] - #120174 ccl/changefeedccl: TestChangefeedRandomExpressions failed [test needs adjustment] [A-cdc C-test-failure O-robot P-3 T-cdc branch-master]
/cc @cockroachdb/cdc
This test on roachdash | Improve this report!
Jira issue: CRDB-44265