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.

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

ccl/changefeedccl: TestChangefeedRandomExpressions failed #96532

Closed
cockroach-teamcity opened this issue Feb 3, 2023 · 2 comments
Closed

ccl/changefeedccl: TestChangefeedRandomExpressions failed #96532

cockroach-teamcity opened this issue Feb 3, 2023 · 2 comments
Assignees
Labels
A-cdc Change Data Capture branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-cdc
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Feb 3, 2023

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))))

Help

See also: How To Investigate a Go Test Failure (internal)

/cc @cockroachdb/cdc

This test on roachdash | Improve this report!

Jira issue: CRDB-24169

Epic CRDB-11732

@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Feb 3, 2023
@cockroach-teamcity cockroach-teamcity added this to the 23.1 milestone Feb 3, 2023
HonoreDB added a commit to HonoreDB/cockroach that referenced this issue Feb 4, 2023
Apparently we're not quite at the point where
this can be in CI.
Informs cockroachdb#96532

Release note: None
HonoreDB added a commit to HonoreDB/cockroach that referenced this issue Mar 9, 2023
TestChangefeedRandomExpressions was occasionally timing out when doing
the regular SELECT query--it's tricky to get sqlsmith not to generate
complex expressions that are likely to not be valid for changefeeds
anyway, so this PR just skips predicates that take more than a second
to process.

Informs cockroachdb#96532.

Release note: None
HonoreDB added a commit to HonoreDB/cockroach that referenced this issue Mar 9, 2023
TestChangefeedRandomExpressions was occasionally timing out when doing
the regular SELECT query--it's tricky to get sqlsmith not to generate
complex expressions that are likely to not be valid for changefeeds
anyway, so this PR just skips predicates that take more than 2 seconds
to process.

Informs cockroachdb#96532.

Release note: None
craig bot pushed a commit that referenced this issue Mar 9, 2023
96967: changefeedccl: skip testing queries that are too slow as regular SQL r=[samiskin] a=HonoreDB

TestChangefeedRandomExpressions was occasionally timing out when doing the regular SELECT query--it's tricky to get sqlsmith not to generate complex expressions that are likely to not be valid for changefeeds anyway, so this PR just skips predicates that take more than a second to process.

Informs #96532.

Release note: None

97860: jobs: add VIEWJOB global privilege, remove role option r=jayshrivastava a=jayshrivastava

This change updates `VIEWJOB` to be a global privilege instead of a role option so that it can be inherited from roles to their members.

Previously, `VIEWJOB` was a role option which could be granted to users. Now, `VIEWJOB` is a global privilege. Granting this privilege to a user or role has the syntax `GRANT SYSTEM VIEWJOB TO user`. Using `VIEWJOB` as a role option is deprecated.

Note that the `VIEWJOB` role option was not included in any release so far. It was queued up to be released in 23.1, but was not. This change is also being queued for 23.1, so there should not be any backwards compatibility issues.

Informs: #96382
Epic: None
Release Note: None

98135: cdc: copy request body when registering schemas r=jayshrivastava a=jayshrivastava

cdc: copy request body when registering schemas
  
Previously, when the schema registry encountered an error when
registering a schema, it would retry the request. The problem
is that upon hitting an error, we clean the body before retrying.
Retrying with an empty body results in a obscure error message.
With this change, we now retry with the original request body
so the original error is sustained.

This change also adds the metric `changefeed.schema_registry.retry_count`
which is a counter for the number of retries performed by the schema
registry. Seeing nonzero values indicates that there is an issue
with contacting the schema registry and/or registering schemas.

Release note (ops change): A new metric `changefeed.schema_registry.retry_count`
is added. This measures the number of request retries performed when
sending requests to the schema registry. Observing a nonzero value may indicate
improper configuration of the schema registry or changefeed parameters.
Epic: None

98212: authors: add Mira Radeva to authors r=miraradeva a=miraradeva

Release note: None
Epic: None

98249: backupccl: incremental schedules always wait on_previous_running r=benbardin a=adityamaru

An incremental backup schedule must always wait if there is a running job
that was previously scheduled by this incremental schedule. This is
because until the previous incremental backup job completes, all future
incremental jobs will attempt to backup data from the same `StartTime`
corresponding to the `EndTime` of the last incremental layer. In this
case only the first incremental job to complete will succeed, while the
remaining jobs will either be rejected or worse corrupt the chain of
backups.

This change overrides the Wait behaviour for an incremental schedule to
always default to `wait` during schedule creation or in an alter statement.
Note the user specified value will still be applied to the full backup schedule.

Ideally we'd have a way to configure options for both the full and
incremental schedule separately, in which case we could reject the
`on_previous_running` configuration for incremental schedules.
Until then this workaround will have to do and we should call out this
known limitation.

Fixes: #96110

Release note (enterprise change): backup schedules created or altered to
have the option `on_previous_running` will have the full backup
schedule created with the user specified option, but will override the
incremental backup schedule to always default to `on_previous_running = wait`.
This ensures correctness of the backup chains created by the incremental
schedule by preventing duplicate incremental jobs from racing against each
other.

98307: ui: fix txn aggregations in txns fingerprints page r=xinhaoz a=xinhaoz

This commit addresses 2 issues on the txns overview page:
1. We were previously grouping txns by txn fingerprint id, agg time, agg interval, and app name. This is from a time when we wanted all these fields, but recently we only want to aggregate on txn fingerprint id.
This commit changes the grouping to only the txn id.

2. Stats aggregation causing undesired data mutations: We were seeing that in the txns fingerprint page,
stats columns would seemingly randomly continue to increase while on the page (e.g. exec count, bytes read). During stats aggregation after grouping by
the fields mentioned above, we were using the first txn in the grouping  as the base object for stats
aggregation, meaning we inherited and mutated the stats object of that txn. Since we aggregate on every re-render, This meant that we were using the result of any previous aggregations as the base for our current aggregation in the re-render. This explains the never-ending incrementing stats. This commit addresses this bug by ensuring we don't re-use the stats object between re-renders by creating a new copy of the stats for every aggregation.

Fixes: #96186
Fixes: #68375

Release note (bug fix): stats columns in txns fingerprint overview page does not continuously increment



BEFORE
https://www.loom.com/share/d9bbd98ced2742dd899031fbc16df6af	

AFTER
https://www.loom.com/share/5407fbbad086404c8d9d63e7f5ef15dd

98321: backupccl: add restore/pause/tpce/80GB/aws/nodes=4/cpus=8 to aws nightlies r=lidorcarmel a=msbutler


Epic: none

Release note: None

Co-authored-by: Aaron Zinger <[email protected]>
Co-authored-by: Jayant Shrivastava <[email protected]>
Co-authored-by: Mira Radeva <[email protected]>
Co-authored-by: adityamaru <[email protected]>
Co-authored-by: Xin Hao Zhang <[email protected]>
Co-authored-by: Michael Butler <[email protected]>
@cockroach-teamcity
Copy link
Member Author

ccl/changefeedccl.TestChangefeedRandomExpressions failed with artifacts on master @ b89fa2cc4bc1fb9447ab1009b34b6f354f9618f0:

    changefeed_test.go:938: Skipping predicate NULL because it returned no rows
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NULL::INET >> seed._inet::INET)::BOOL
    changefeed_test.go:938: Skipping predicate (NULL::INET >> seed._inet::INET)::BOOL because it returned no rows
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool OR (NULL IS NOT DISTINCT FROM seed._string))
    changefeed_test.go:942: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool OR (NULL IS NOT DISTINCT FROM seed._string)) to emit 52 events
    testfeed_test.go:279: creating external connection
    testfeed_test.go:282: ran create external connection
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT B'0111111111' AS col166 FROM d.public.seed@[0] AS "t ab̃70" WHERE (false OR seed._bool))
    changefeed_test.go:942: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT B'0111111111' AS col166 FROM d.public.seed@[0] AS "t ab̃70" WHERE (false OR seed._bool)) to emit 50 events
    testfeed_test.go:279: creating external connection
    testfeed_test.go:282: ran create external connection
    changefeed_test.go:945: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (false AND seed._bool)
    changefeed_test.go:938: Skipping predicate (false AND seed._bool) because it returned no rows
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ('fb1b:1750:d4e2:e00a:a204:3cbc:e04e:b080/86':::INET::INET >> '250.135.99.101/27':::INET::INET)::BOOL
    changefeed_test.go:938: Skipping predicate ('fb1b:1750:d4e2:e00a:a204:3cbc:e04e:b080/86':::INET::INET >> '250.135.99.101/27':::INET::INET)::BOOL because it returned no rows
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT '0102000040020000007E3E2EC1D5C800428B500C4DE40D02C255F54B6629B001C24A0B7D537275E841376FE7E56B9B0142464C38E07D4CE241':::GEOMETRY AS col225 FROM d.public.seed AS tab98 JOIN d.public.seed AS "/tab99" ON (((tab98._int8) = ("/tab99"._int8)) AND ((tab98._date) = ("/tab99"._date))) AND ((tab98._float8) = ("/tab99"._float8)))
    changefeed_test.go:942: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT '0102000040020000007E3E2EC1D5C800428B500C4DE40D02C255F54B6629B001C24A0B7D537275E841376FE7E56B9B0142464C38E07D4CE241':::GEOMETRY AS col225 FROM d.public.seed AS tab98 JOIN d.public.seed AS "/tab99" ON (((tab98._int8) = ("/tab99"._int8)) AND ((tab98._date) = ("/tab99"._date))) AND ((tab98._float8) = ("/tab99"._float8))) to emit 100 events
    testfeed_test.go:279: creating external connection
    testfeed_test.go:282: ran create external connection
    changefeed_test.go:945: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND false)
    changefeed_test.go:938: Skipping predicate (seed._bool AND false) because it returned no rows
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._bool::BOOL IN (SELECT false::BOOL AS co😔l345 FROM d.public.seed@[0] AS tab137 GROUP BY seed._int8)
    changefeed_test.go:942: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._bool::BOOL IN (SELECT false::BOOL AS co😔l345 FROM d.public.seed@[0] AS tab137 GROUP BY seed._int8) to emit 44 events
    testfeed_test.go:279: creating external connection
    testfeed_test.go:282: ran create external connection
    changefeed_test.go:945: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND (seed._bool OR _st_containsproperly('010500000006000000010200000006000000B857524DE504E24150D08567BB34EFC11030A619F338FC414154D6369276FCC1C7946C7EA4AFFD412CBE7B5586CBF3C1A81ECEE71A31FB4105145B1B280EF0C14C5F0E7A241102425214EA05DAE5A2418736A1CFFEA5FE41920932F51DAEF541010200000002000000AD609053C14CD6410CD87D04A516C9C175939A21CCB9F3C16B24B9E5CA17D4C1010200000002000000FE8B356AD279D9C11972A9BE0E1CFB41823BB0FD8F4702C2BF97E513C5340142010200000008000000DCDFF3A52ABACCC1012093B1F1E900C2440EF771C275F6417E808BD1E098F9C11EAB41121EF4F2418F293556DC07C8C1C72CB86B2ED8F44196418442EA92BD41D2FE95715940FA41C12665FB65BBF141B05359D2118BD7C138228931E27FE5410380ED152613E5C1E69A53026F5AFC41564A07E1325CFAC1C29F2DED28500042010200000002000000237D5BD8EB7AE141C8CA96B5C850F5C187184FF687C5F5411DF006AFE113D8C10102000000050000007C12DDCA3BEEEB419554E57B4760EDC14AD3625025DDFB41C044F53A0DADB8411D1CD43F2DFBF54178DC9DAD563ECE4122243910C4E4FEC1ED5DA810DC4A0242D4702D18E1A3F2C1720CCD4FFB71F341':::GEOMETRY::GEOMETRY, st_addmeasure('01030000C001000000090000009919FE18829AF9C1DBDB72058EADE3C14F30D1A618DBC44123566DB717E5E0C1A492434886CC00C2631F0E42C278FAC1566333DF80A4CB418AB4A42D172ED9C1D0A51BA7915DE341A6A42AEBDD8402C238C6B8CB1080EEC144BAFCAFAAC0F0417A25FE8FD92DC34124E4D9792459EBC1FF308F0FFC1EE8C1861ED91816B9C2C1BACC5127387D0142136A5AE50FDFF7C12CFFE119A97DFCC13EB8840F2BDDD3C12E302B72AC400242B72627C0E7C0D141E15441E0E8E1EB419C71C757C958FBC1B8D2BAF1E429F4C1F5AB11EA3C4F0242A66049F67C7F02C26BA741639710EFC1D6A4481EA937F1C13CA5AAE11F43FD41E1F7459E8406E1411E627B3B500EE1419919FE18829AF9C1DBDB72058EADE3C14F30D1A618DBC44123566DB717E5E0C1':::GEOMETRY::GEOMETRY, (-2.1640923848244995):::FLOAT8::FLOAT8, 0.10539122302522724:::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::BOOL))
    changefeed_test.go:942: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND (seed._bool OR _st_containsproperly('010500000006000000010200000006000000B857524DE504E24150D08567BB34EFC11030A619F338FC414154D6369276FCC1C7946C7EA4AFFD412CBE7B5586CBF3C1A81ECEE71A31FB4105145B1B280EF0C14C5F0E7A241102425214EA05DAE5A2418736A1CFFEA5FE41920932F51DAEF541010200000002000000AD609053C14CD6410CD87D04A516C9C175939A21CCB9F3C16B24B9E5CA17D4C1010200000002000000FE8B356AD279D9C11972A9BE0E1CFB41823BB0FD8F4702C2BF97E513C5340142010200000008000000DCDFF3A52ABACCC1012093B1F1E900C2440EF771C275F6417E808BD1E098F9C11EAB41121EF4F2418F293556DC07C8C1C72CB86B2ED8F44196418442EA92BD41D2FE95715940FA41C12665FB65BBF141B05359D2118BD7C138228931E27FE5410380ED152613E5C1E69A53026F5AFC41564A07E1325CFAC1C29F2DED28500042010200000002000000237D5BD8EB7AE141C8CA96B5C850F5C187184FF687C5F5411DF006AFE113D8C10102000000050000007C12DDCA3BEEEB419554E57B4760EDC14AD3625025DDFB41C044F53A0DADB8411D1CD43F2DFBF54178DC9DAD563ECE4122243910C4E4FEC1ED5DA810DC4A0242D4702D18E1A3F2C1720CCD4FFB71F341':::GEOMETRY::GEOMETRY, st_addmeasure('01030000C001000000090000009919FE18829AF9C1DBDB72058EADE3C14F30D1A618DBC44123566DB717E5E0C1A492434886CC00C2631F0E42C278FAC1566333DF80A4CB418AB4A42D172ED9C1D0A51BA7915DE341A6A42AEBDD8402C238C6B8CB1080EEC144BAFCAFAAC0F0417A25FE8FD92DC34124E4D9792459EBC1FF308F0FFC1EE8C1861ED91816B9C2C1BACC5127387D0142136A5AE50FDFF7C12CFFE119A97DFCC13EB8840F2BDDD3C12E302B72AC400242B72627C0E7C0D141E15441E0E8E1EB419C71C757C958FBC1B8D2BAF1E429F4C1F5AB11EA3C4F0242A66049F67C7F02C26BA741639710EFC1D6A4481EA937F1C13CA5AAE11F43FD41E1F7459E8406E1411E627B3B500EE1419919FE18829AF9C1DBDB72058EADE3C14F30D1A618DBC44123566DB717E5E0C1':::GEOMETRY::GEOMETRY, (-2.1640923848244995):::FLOAT8::FLOAT8, 0.10539122302522724:::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::BOOL)) to emit 50 events
    testfeed_test.go:279: creating external connection
    testfeed_test.go:282: ran create external connection
    changefeed_test.go:959: st_addmeasure(): input geometry must be LINESTRING or MULTILINESTRING
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND EXISTS (SELECT seed._jsonb AS col370 FROM d.public.seed@[0] AS tab147 WHERE true))
    changefeed_test.go:942: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND EXISTS (SELECT seed._jsonb AS col370 FROM d.public.seed@[0] AS tab147 WHERE true)) to emit 50 events
    testfeed_test.go:279: creating external connection
    testfeed_test.go:282: ran create external connection
    changefeed_test.go:945: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT e'\\x64887249':::BYTES AS col375 FROM d.public.seed@[0] AS "tAb149" WHERE seed._bool ORDER BY seed._timestamptz NULLS FIRST, seed._float4 DESC NULLS LAST, seed._int2 ASC NULLS LAST)
    changefeed_test.go:942: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT e'\\x64887249':::BYTES AS col375 FROM d.public.seed@[0] AS "tAb149" WHERE seed._bool ORDER BY seed._timestamptz NULLS FIRST, seed._float4 DESC NULLS LAST, seed._int2 ASC NULLS LAST) to emit 50 events
    testfeed_test.go:279: creating external connection
    testfeed_test.go:282: ran create external connection
    changefeed_test.go:945: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
    changefeed_test.go:926: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT 'BOX(-0.2386492799118647 -0.32664244031094497,0.12310024533818148 -0.2574470120878649)':::BOX2D AS "co l394" FROM d.public.seed@[0] AS "ta b156" ORDER BY seed._enum ASC NULLS FIRST)
    changefeed_test.go:942: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT 'BOX(-0.2386492799118647 -0.32664244031094497,0.12310024533818148 -0.2574470120878649)':::BOX2D AS "co l394" FROM d.public.seed@[0] AS "ta b156" ORDER BY seed._enum ASC NULLS FIRST) to emit 100 events
    testfeed_test.go:279: creating external connection
    testfeed_test.go:282: ran create external connection
    changefeed_test.go:945: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
    changefeed_test.go:965: 7 predicates checked: all had the same result in SELECT and CHANGEFEED
    --- FAIL: TestChangefeedRandomExpressions/kafka (13.13s)
Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@jayshrivastava
Copy link
Contributor

Closing as stale. No failure since March.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-cdc Change Data Capture branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. T-cdc
Projects
None yet
Development

No branches or pull requests

3 participants