[YSQL] TestPgReplicationSlot.replicationConnectionConsumptionAllDataTypes depends on TZ

[jasonyb]

Jira Link: DB-11544

Description

On Almalinux 8, 2349d7c2df5a519677b80a8eae902a816f34f95b (pg15)

TZ=Antarctica/Casey ./yb_build.sh fastdebug --gcc11 --java-test 'TestPgReplicationSlot#replicationConnectionConsumptionAllDataTypes'

fails with

[ERROR] Failures: 
[ERROR]   TestPgReplicationSlot.replicationConnectionConsumptionAllDataTypes:799 expected:<[BEGIN: (lsn = LSN{0/4}, xid = 2), TYPE: (name = coupon_discount_type, namespace = public), RELATION: (name = test_table, namespace = public, replica_identity = c, columns = [(name = a, data_type = 23), (name = col_bit, data_type = 1560), (name = col_boolean, data_type = 16), (name = col_box, data_type = 603), (name = col_bytea, data_type = 17), (name = col_cidr, data_type = 650), (name = col_circle, data_type = 718), (name = col_date, data_type = 1082), (name = col_float, data_type = 701), (name = col_double, data_type = 701), (name = col_inet, data_type = 869), (name = col_int, data_type = 23), (name = col_json, data_type = 114), (name = col_jsonb, data_type = 3802), (name = col_line, data_type = 628), (name = col_lseg, data_type = 601), (name = col_macaddr8, data_type = 774), (name = col_macaddr, data_type = 829), (name = col_money, data_type = 790), (name = col_numeric, data_type = 1700), (name = col_path, data_type = 602), (name = col_point, data_type = 600), (name = col_polygon, data_type = 604), (name = col_text, data_type = 25), (name = col_time, data_type = 1083), (name = col_timestamp, data_type = 1114), (name = col_timetz, data_type = 1266), (name = col_uuid, data_type = 2950), (name = col_varbit, data_type = 1562), (name = col_timestamptz, data_type = 1184), (name = col_int4range, data_type = 3904), (name = col_int8range, data_type = 3926), (name = col_tsrange, data_type = 3908), (name = col_tstzrange, data_type = 3910), (name = col_daterange, data_type = 3912), (name = col_discount, data_type = 0)]), INSERT: (tuple = (num_columns = 36, columns = [1, 110110, t, (1,1),(0,0), \x012345, 127.0.0.1/32, <(0,0),1>, 2024-02-01, 1.201, 3.14, 127.0.0.1, 42, {"key": "value"}, {"key": "value"}, {1,2,3}, [(0,0),(1,1)], 00:11:22:33:44:55:66:77, 00:11:22:33:44:55, $100.50, 123.456, ((0,0),(1,1)), (0,0), ((0,0),(1,1)), Sample Text, 12:34:56, 2024-02-01 12:34:56, 12:34:56+00, 550e8400-e29b-41d4-a716-446655440000, 101010, 2024-02-01 23:34:56+11:00, [1,10), [100,1000), ["2024-01-01 00:00:00","2024-12-31 00:00:00"), ["2024-01-01 11:00:00+11:00","2025-01-01 02:59:59+11:00"), [2024-01-01,2024-12-31), FIXED])), COMMIT: (commit_lsn = LSN{0/4}, end_lsn = LSN{0/5}, flag = 0)]> but was:<[BEGIN: (lsn = LSN{0/4}, xid = 2), TYPE: (name = coupon_discount_type, namespace = public), RELATION: (name = test_table, namespace = public, replica_identity = c, columns = [(name = a, data_type = 23), (name = col_bit, data_type = 1560), (name = col_boolean, data_type = 16), (name = col_box, data_type = 603), (name = col_bytea, data_type = 17), (name = col_cidr, data_type = 650), (name = col_circle, data_type = 718), (name = col_date, data_type = 1082), (name = col_float, data_type = 701), (name = col_double, data_type = 701), (name = col_inet, data_type = 869), (name = col_int, data_type = 23), (name = col_json, data_type = 114), (name = col_jsonb, data_type = 3802), (name = col_line, data_type = 628), (name = col_lseg, data_type = 601), (name = col_macaddr8, data_type = 774), (name = col_macaddr, data_type = 829), (name = col_money, data_type = 790), (name = col_numeric, data_type = 1700), (name = col_path, data_type = 602), (name = col_point, data_type = 600), (name = col_polygon, data_type = 604), (name = col_text, data_type = 25), (name = col_time, data_type = 1083), (name = col_timestamp, data_type = 1114), (name = col_timetz, data_type = 1266), (name = col_uuid, data_type = 2950), (name = col_varbit, data_type = 1562), (name = col_timestamptz, data_type = 1184), (name = col_int4range, data_type = 3904), (name = col_int8range, data_type = 3926), (name = col_tsrange, data_type = 3908), (name = col_tstzrange, data_type = 3910), (name = col_daterange, data_type = 3912), (name = col_discount, data_type = 16385)]), INSERT: (tuple = (num_columns = 36, columns = [1, 110110, t, (1,1),(0,0), \x012345, 127.0.0.1/32, <(0,0),1>, 2024-02-01, 1.201, 3.14, 127.0.0.1, 42, {"key": "value"}, {"key": "value"}, {1,2,3}, [(0,0),(1,1)], 00:11:22:33:44:55:66:77, 00:11:22:33:44:55, $100.50, 123.456, ((0,0),(1,1)), (0,0), ((0,0),(1,1)), Sample Text, 12:34:56, 2024-02-01 12:34:56, 12:34:56+00, 550e8400-e29b-41d4-a716-446655440000, 101010, 2024-02-01 23:34:56+11, [1,10), [100,1000), ["2024-01-01 00:00:00","2024-12-31 00:00:00"), ["2024-01-01 11:00:00+11","2025-01-01 02:59:59+11"), [2024-01-01,2024-12-31), FIXED])), COMMIT: (commit_lsn = LSN{0/4}, end_lsn = LSN{0/5}, flag = 0)]>

but

TZ=UTC ./yb_build.sh fastdebug --gcc11 --java-test 'TestPgReplicationSlot#replicationConnectionConsumptionAllDataTypes'

is fine. See also #22228.

Did not test master but it likely has the same issue.

Issue Type

kind/failing-test

Warning: Please confirm that this issue does not contain any sensitive information

• [X] I confirm this issue does not contain any sensitive information.

[foucher]

I'm hitting this also.