ccl/crosscluster/logical: TestRandomTables failed

ccl/crosscluster/logical.TestRandomTables failed on release-24.2 @ 742a2251a05088a238fc6eb4c2466dace3cb1bb2:

=== RUN   TestRandomTables
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestRandomTables462894766
    test_log_scope.go:81: use -show-logs to present logs inline
    test_server_shim.go:93: cluster virtualization disabled due to issue: #127241 (expected label: C-bug)
    logical_replication_job_test.go:466: CREATE TABLE rand_table ("😄col1""_0" VARCHAR NULL, "�c ol1_1" NAME NOT NULL, "co%!v(MISSING)l1\f_2" BYTES NOT NULL, "col1 _3" VECTOR NOT NULL, col1_4 BOOL, "%!p(MISSING)col'1_5" JSONB NOT NULL, cõl1_6 TIME, "col1\\x84_7" FLOAT8 NULL, col1_8 UUID NULL, col1_9 INTERVAL NOT NULL, co̊l1_10 REGROLE NULL, col1_11 STRING NOT NULL AS (lower(CAST("col1 _3" AS STRING))) VIRTUAL, col1_12 STRING NULL AS (lower(CAST(col1_8 AS STRING))) VIRTUAL, col1_13 STRING NOT NULL AS (lower(CAST("col1 _3" AS STRING))) STORED, "c ol1_14" FLOAT8 NULL AS (abs("col1\\x84_7")) STORED, "col1(_15" STRING AS (lower(CAST(cõl1_6 AS STRING))) VIRTUAL, col1_16 STRING NOT NULL AS (CASE WHEN "co%!v(MISSING)l1\f_2" IS NULL THEN '':::STRING ELSE e'i\x19c':::STRING END) STORED, col1_17 STRING AS (lower(CAST(cõl1_6 AS STRING))) STORED, INDEX (col1_4) STORING ("col1 _3", col1_8), UNIQUE ("�c ol1_1" DESC) STORING (cõl1_6, col1_8, col1_17), INDEX ("%!p(MISSING)col'1_5" ASC), INDEX ("😄col1""_0" DESC) PARTITION BY LIST ("😄col1""_0") (PARTITION rand_table_part_0 VALUES IN (('"':::STRING,), (e'>\x06\x0bbT':::STRING,), (e'G\x1b2^\x13\x17 B':::STRING,), (',]um':::STRING,)), PARTITION "�r'a͉nd%!q(MISSING)_table_pa
        rt_1" VALUES IN ((e'\x0fd':::STRING,), (e'l[X\b} ':::STRING,), ('neYg':::STRING,), ('HXC':::STRING,)), PARTITION "rand_table_part\n_2" VALUES IN ((e'\\f2\x0f\x07\x15|\\f':::STRING,), (e'\'':::STRING,), (e'-,>\x1d\x1f\x0b\x13':::STRING,), ('6c@':::STRING,))), INVERTED INDEX ("😄col1""_0" gin_trgm_ops), UNIQUE ("%!p(MISSING)col'1_5" DESC), UNIQUE ("c ol1_14" ASC), UNIQUE (abs("col1\\x84_7") DESC), INVERTED INDEX (cõl1_6 ASC, col1_13 DESC, col1_11 gin_trgm_ops ASC))
    logical_replication_job_test.go:486: waiting for replication job 989565163735646209

Parameters:

attempt=1
run=11
shard=1
Help

Same failure on other branches

- #127239 ccl/crosscluster/logical: TestRandomTables failed [C-test-failure O-robot T-disaster-recovery branch-master release-blocker]

/cc @cockroachdb/disaster-recovery

This test on roachdash | Improve this report!

Jira issue: CRDB-40611

ccl/crosscluster/logical.TestRandomTables failed on release-24.2 @ 544673f4fc982fbb3abdd2824f09282f668d2959:

=== RUN   TestRandomTables
    test_log_scope.go:170: test logs captured to: outputs.zip/logTestRandomTables730918419
    test_log_scope.go:81: use -show-logs to present logs inline
    test_server_shim.go:93: cluster virtualization disabled due to issue: #127241 (expected label: C-bug)
    logical_replication_job_test.go:526: CREATE TABLE rand_table (col1_0 "char" NOT NULL, col1_1 INT8 NOT NULL, col1_2 CHAR, "\\x52col1_3" TIMESTAMP NULL, col1_4 BYTES NOT NULL, col1_5 UUID NOT NULL, "c\\U00031728o!l1_6" BIT(6) NOT NULL, col1_7 TIME, col1_8 BYTES NOT NULL, "c'o,l1_9" PG_LSN NOT NULL, col1_10 BOX2D NOT NULL, col1_11 TSVECTOR NOT NULL, " col1_12" BYTES NOT NULL, PRIMARY KEY (" col1_12" ASC), INDEX ("\\x52col1_3", col1_2 ASC, col1_5, col1_4 ASC) STORING (col1_0, "c\\U00031728o!l1_6", col1_7, col1_8, col1_10), INDEX (col1_2 ASC, col1_4))
    logical_replication_job_test.go:557: waiting for replication job 1001439506202918913
    logical_replication_job_test.go:926: fingerprinting index rand_table_pkey
    logical_replication_job_test.go:926: fingerprinting index rand_table_\\x52col1_3_col1_2_col1_5_col1_4_idx
    logical_replication_job_test.go:926: fingerprinting index rand_table_col1_2_col1_4_idx
    logical_replication_job_test.go:927: error executing 'SELECT
              xor_agg(fnv64(col1_2:::string::bytes,col1_4:::bytes," col1_12":::bytes))::string AS fingerprint
              FROM [110 AS t]@{FORCE_INDEX=[3]}
            ': pq: bytea encoded value ends with escape character
    panic.go:626: -- test log scope end --
test logs left over in: outputs.zip/logTestRandomTables730918419
--- FAIL: TestRandomTables (2.01s)

Parameters:

attempt=1
run=18
shard=1
Help

_{This test on roachdash | Improve this report!}

cockroachdb / cockroach

ccl/crosscluster/logical: TestRandomTables failed #127804