ccl/changefeedccl: TestChangefeedRandomExpressions failed #96532
Description
ccl/changefeedccl.TestChangefeedRandomExpressions failed with artifacts on master @ 68a1beda50f32bb20ecc50010e3eeff25d3a0d8e:
Fatal error:
panic: test timed out after 59m55s
Stack:
goroutine 3328129 [running]:
testing.(*M).startAlarm.func1()
GOROOT/src/testing/testing.go:2036 +0x88
created by time.goFunc
GOROOT/src/time/sleep.go:176 +0x38
Log preceding fatal error
=== RUN TestChangefeedRandomExpressions
test_log_scope.go:161: test logs captured to: /artifacts/tmp/_tmp/51fe861426dc77645f2622be784d4d3c/logTestChangefeedRandomExpressions2028518085
test_log_scope.go:79: use -show-logs to present logs inline
=== RUN TestChangefeedRandomExpressions/kafka
helpers_test.go:807: making server as secondary tenant
helpers_test.go:893: making kafka feed factory
changefeed_test.go:927: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE true
changefeed_test.go:940: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE true to emit 100 events
testfeed_test.go:278: creating external connection
testfeed_test.go:281: ran create external connection
changefeed_test.go:927: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._bool
changefeed_test.go:940: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._bool to emit 46 events
testfeed_test.go:278: creating external connection
testfeed_test.go:281: ran create external connection
changefeed_test.go:927: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (('786e:fe43:bc99:d6e:8afc:3a01:91c4:738/0':::INET::INET >> (('94cd:d801:ce48:3e8c:6470:6c75:2716:f36b/67':::INET::INET | '1227:6263:63a2:9d55:203e:1fa7:9894:f75/121':::INET::INET)::INET::INET | COALESCE('92.106.85.52/19':::INET, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET)::INET)::INET::INET)::BOOL OR true)
changefeed_test.go:940: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (('786e:fe43:bc99:d6e:8afc:3a01:91c4:738/0':::INET::INET >> (('94cd:d801:ce48:3e8c:6470:6c75:2716:f36b/67':::INET::INET | '1227:6263:63a2:9d55:203e:1fa7:9894:f75/121':::INET::INET)::INET::INET | COALESCE('92.106.85.52/19':::INET, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET)::INET)::INET::INET)::BOOL OR true) to emit 100 events
testfeed_test.go:278: creating external connection
testfeed_test.go:281: ran create external connection
changefeed_test.go:927: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT 'd376:4c80:e190:ecc2:c218:5ea7:4025:8094/104':::INET AS "co?l28", seed._string AS col29, NULL AS "-co'l30" FROM d.public.seed@[0] AS " t̲a�b17")
changefeed_test.go:940: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT 'd376:4c80:e190:ecc2:c218:5ea7:4025:8094/104':::INET AS "co?l28", seed._string AS col29, NULL AS "-co'l30" FROM d.public.seed@[0] AS " t̲a�b17") to emit 100 events
testfeed_test.go:278: creating external connection
testfeed_test.go:281: ran create external connection
changefeed_test.go:943: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
changefeed_test.go:927: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE NULL
changefeed_test.go:936: Skipping predicate NULL because it returned no rows
changefeed_test.go:927: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE false
changefeed_test.go:936: Skipping predicate false because it returned no rows
changefeed_test.go:927: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ('0001-01-01 00:00:00+00:00':::TIMESTAMPTZ <= '2017-04-29 21:10:59.000043+00:00':::TIMESTAMPTZ)
changefeed_test.go:940: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE ('0001-01-01 00:00:00+00:00':::TIMESTAMPTZ <= '2017-04-29 21:10:59.000043+00:00':::TIMESTAMPTZ) to emit 100 events
testfeed_test.go:278: creating external connection
testfeed_test.go:281: ran create external connection
changefeed_test.go:927: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT (true AND EXISTS (SELECT '08:23:56.141153':::TIME AS col82, '20:34:46.707065+02:32:00':::TIMETZ AS "'co,l83" FROM d.public.seed@[0] AS tab30 WHERE seed._float8::FLOAT8 IN (SELECT seed._float8::FLOAT8 AS col81 FROM d.public.seed AS ")tab31" JOIN d.public.seed AS tab32 ON (((")tab31"._int8) = (tab32._int8)) AND ((")tab31"._date) = (tab32._date))) AND ((")tab31"._float8) = (tab32._float8)) ORDER BY seed._float8 DESC NULLS FIRST, seed._float8))))
This test on roachdash | Improve this report!
Jira issue: CRDB-24169
Epic CRDB-11732