-
Enhancement
-
Resolution: Done
-
Major
-
2.7.1.Final
-
None
-
False
-
None
-
False
Reselect column postprocessor does not support dtection of int/bigint unchanged value placeholders. In these two cases the placeholder is array of bytes representing ASCII value of the placeholder value.
In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.
Bug report
For bug reports, provide this information, please:
What Debezium connector do you use and what version?
debezium postgres 2.7.1
quay.io/debezium/connect:2.7.1.Final
What is the connector configuration?
{
"name": "pengys_test",
"config": {
"connector.class": "io.debezium.connector.postgresql.PostgresConnector",
"topic.prefix": "pengys_test",
"tasks.max": "1",
"plugin.name": "pgoutput",
"slot.name": "dbz_replica_slot",
"publication.name": "dbz_publication",
"publication.autocreate.mode": "filtered",
"key.converter": "org.apache.kafka.connect.json.JsonConverter",
"key.converter.schemas.enable": "true",
"value.converter": "org.apache.kafka.connect.json.JsonConverter",
"value.converter.schemas.enable": "false",
"time.precision.mode": "connect",
"decimal.handling.mode": "string",
"bigint.unsigned.handling.mode": "long",
"tombstones.on.delete": "true",
"database.hostname": "postgres.postgres.svc",
"database.port": "5432",
"database.user": "postgresadmin",
"database.password": "admin123",
"database.dbname": "postgresdb",
"schema.include.list": "public",
"table.include.list": "public.test",
"database.server.name": "pengys_test",
"snapshot.mode": "initial",
"snapshot.delay.ms": "5000",
"snapshot.locking.mode": "shared",
"snapshot.fetch.size": 20000,
"topic.creation.groups": "pengys_test",
"topic.creation.default.replication.factor": 2,
"topic.creation.default.partitions": 3,
"topic.creation.dbzcompact.include": "pengys_test.*"
}
}
What is the captured database version and mode of deployment?
(E.g. on-premises, with a specific cloud provider, etc.)
K8S 1.20.0
postgres 13.12
database config as bellow:
// code placeholder apiVersion: v1 kind: ConfigMap metadata: name: postgres-conf-config labels: app: postgres data: postgresql.conf: |- listen_addresses = '*' max_connections = 500 shared_buffers = 512MB dynamic_shared_memory_type = posix recovery_target_timeline='latest' wal_level = logical max_wal_senders = 10 max_replication_slots = 100 max_slot_wal_keep_size=10GB wal_keep_size = 5GB max_wal_size = 6GB min_wal_size = 1GB log_timezone = 'Asia/Shanghai' timezone = 'Asia/Shanghai' effective_cache_size = 4GB maintenance_work_mem = 1GB work_mem = 8MB
table schema as bellow:
CREATE TABLE IF NOT EXISTS "public"."test" ( "record_create_time" timestamptz(6) NOT NULL DEFAULT now(), "record_update_time" timestamptz(6) NOT NULL DEFAULT now(), "id" varchar(128) not null, "report_id" varchar(64) NOT NULL, "area" varchar(16) NOT NULL DEFAULT 'GuangZhou'::character varying, "plan_id" int8, "plan_name" varchar(64), "demand_ids" json, "case_ids" json, "script_ids" json, "project_id" int8, "bug_ids" json, PRIMARY KEY ("id") );
table dml as bellow:
-- add one record INSERT INTO "public"."test" ("record_create_time","record_update_time","id","report_id","area","plan_id","demand_ids","case_ids","script_ids","plan_name","project_id","bug_ids") VALUES ('2023-12-27T09:26:16.135161+09:00','2024-01-24T15:38:48.554696+09:00','test-1','cK_s9osBYBO77D0-DEno','DJ','15954',NULL,'{252216,253134,263412,336262,336263,336264,336265,336267,336268,336269,336270,336271,336272,336321,886701,918943,918944,918945,918946,918947,918948,918949,918950,918951,918952,918953,918954,918955,918956,918957,918958,918959,918960,918961,918962,918963,918964,918965,918966,918967,918968,918969,918970,918971,918972,918973,918974,918975,918976,918977,918978,918979,918980,918981,918982,918983,918984,918985,918986,918987,918988,918989,918990,918991,918992,918993,918994,918995,918996,918997,918998,918999,919000,919001,919002,919003,919004,919005,919006,919007,919008,919009,919010,919011,919012,919013,919014,919015,919016,919017,919018,919019,919020,919021,919022,919023,919024,919025,919026,919027,919028,919029,919030,919031,919032,919033,919034,919035,919036,919037,919038,919039,919040,919041,919042,919043,919044,919045,919046,919047,919048,919049,919050,919051,919052,919053,919054,919055,919056,919057,919058,919059,919060,919061,919062,919063,919064,919065,919066,919067,919068,919069,919070,919071,919072,919073,919074,919075,919076,919077,919078,925179,925180,925181,925182,925183,925184,925185,925186,925187,925188,925189,925190,925191,925192,925193,925194,925195,925196,925197,925198,925199,925200,925201,925202,925203,925204,925205,925206,925207,925208,925209,925210,925211,925212,925213,925214,925215,925216,925217,925218,925219,925220,925221,925222,925223,925224,925225,925226,925227,925228,925229,925230,925231,925232,925233,925234,925235,925236,925237,925238,925239,925240,925241,925242,925243,925244,925245,925246,925247,925248,925249,925250,925251,925252,925253,925254,925255,925256,925257,925258,925259,925260,925261,925262,925263,925264,925265,925266,925267,925268,925269,925270,925271,925272,925273,925274,925275,925276,925277,925278,925279,925280,925281,925282,925283,925284,925285,925286,925287,925288,925289,925290,925291,925292,925293,925294,925295,925296,925297,925298,925299,925300,925301,925302,925303,925304,925305,925306,925307,925308,925309,925310,925311,925312,925313,925314,925315,925316,925317,925318,925319,925320,925321,925322,925323,925324,925325,925326,925327,925328,925329,925330,925331,925332,925333,925334,925335,925336,925337,925338,925339,925340,925341,925342,925343,925344,925345,925346,925347,925348,925349,925350,925351,925352,925353,925354,925355,925356,925357,925358,925359,925360,925361,925362,925363,925364,925365,925366,925367,925368,925369,925370,925371,925372,925373,925374,925375,925376,925377,925378,925379,925380,925381,925382,925383,925384,925385,925386,925387,925388,925389,925390,925391,925392,925393,925394,925395,925396,925397,925398,925399,925400,925401,925402,925403,925404,925405,925406,925407,925408,925409,925410,925411,925412,925413,925414,925415,925416,925417,925418,925419,925420,925421,925422,925423,925424,925425,925426,925427,925428,925429,925430,925431,925432,925433,925434,925435,925436,925437,925438,925439,925440,925441,925442,925443,925444,925445,925446,925447,925448,925449,925450,925451,925452,925453,925454,925455,925456,925457,925458,925459,925460,925461,925462,925463,925464,925465,925466,925467,925468,925469,925470,925471,925472,925473,925474,925475,925476,925477,925478,925479,925480,925481,925482,925483,925484,925485,925486,925487,925488,925489,925490,925491,925492,925493,925494,925495,925496,925497,925498,925499,925500,925501,925502,925503,925504,925505,925506,925507,925508,925509,925510,925511,925512,925513,925514,925515,925516,925517,925518,925519,925520,925521,925522,925523,925524,925525,925526,925527,925528,925529,925530,925531,925532,925533,925534,925535,925536,925537,925538,925539,925540,925541,925542,925543,925544,925545,925546,925547,925548,925549,925550,925551,925552,925553,925554,925555,925556,925557,925558,925559,925560,925561,925562,925563,925564,925565,925566,925567,925568,925569,925570,925571,925572,925573,925574,925575,925576,925577,925578,925579,925580,925581,925582,925583,925584,925585,925586,925587,925588,925589,925590,925591,925592,925593,925594,925595,925596,925597,925598,925599,925600,925601,925602,925603,925604,925605,925606,925607,925608,925609,925610,925611,925612,925613,925614,925615,925616,925617,925618,925619,925620,925621,925622,925623,925624,925625,925626,925627,925628,925629,925630,925631,925632,925633,925634,925635,925636,925637,925638,925639,925640,925641,925642,925643,925644,925645,925646,925647,925648,925649,925650,925651,925652,925653,925654,925655,925656,925657,925658,925659,925660,925661,925662,925663,925664,925665,925666,925667,925668,925669,925670,925671,925672,925673,925674,925675,925676,925677,925678,925679,925680,925681,925682,925683,925684,925685,925686,925687,925688,925689,925690,925691,925692,925693,925694,925695,925696,925697,925698,925699,925700,925701,925702,925703,925704,925705,925706,925707,925708,925709,925710,925711,925712,925713,925714,925715,925716,925717,925718,925719,925720,925721,925722,925723,925724,925725,925726,925727,925728,925729,925730,925731,925732,925733,925734,925735,925736,925737,925738,925739,925740,925741,925742,925743,925744,925745,925746,925747,925748,925749,925750,925751,925752,925753,925754,925755,925756,925757,925758,925759,925760,925761,925762,925763,925764,925765,925766,925767,925768,925769,925770,925771,925772,925773,925774,925775,925776,925777,925778,251032,252104,252217,252107,252108,253133,336383,336266,336384,336387,336273,336274,336275,336276,336277,336278,336279,336280,336281,336282,336283,336284,336285,336286,336287,336288,336289,336290,336291,336292,336293,336294,336295,336296,336297,336298,336299,336300,336301,336302,336303,336304,336305,336306,336307,336308,336309,336310,336311,336312,336313,336314,336315,336316,336317,336318,336319,336320,336385,336386,886726,886727,252216,253134,263412,336262,336263,336264,336265,336267,336268,336269,336270,336271,336272,336321,886701,918943,918944,918945,918946,918947,918948,918949,918950,918951,918952,918953,918954,918955,918956,918957,918958,918959,918960,918961,918962,918963,918964,918965,918966,918967,918968,918969,918970,918971,918972,918973,918974,918975,918976,918977,918978,918979,918980,918981,918982,918983,918984,918985,918986,918987,918988,918989,918990,918991,918992,918993,918994,918995,918996,918997,918998,918999,919000,919001,919002,919003,919004,919005,919006,919007,919008,919009,919010,919011,919012,919013,919014,919015,919016,919017,919018,919019,919020,919021,919022,919023,919024,919025,919026,919027,919028,919029,919030,919031,919032,919033,919034,919035,919036,919037,919038,919039,919040,919041,919042,919043,919044,919045,919046,919047,919048,919049,919050,919051,919052,919053,919054,919055,919056,919057,919058,919059,919060,919061,919062,919063,919064,919065,919066,919067,919068,919069,919070,919071,919072,919073,919074,919075,919076,919077,919078,925179,925180,925181,925182,925183,925184,925185,925186,925187,925188,925189,925190,925191,925192,925193,925194,925195,925196,925197,925198,925199,925200,925201,925202,925203,925204,925205,925206,925207,925208,925209,925210,925211,925212,925213,925214,925215,925216,925217,925218,925219,925220,925221,925222,925223,925224,925225,925226,925227,925228,925229,925230,925231,925232,925233,925234,925235,925236,925237,925238,925239,925240,925241,925242,925243,925244,925245,925246,925247,925248,925249,925250,925251,925252,925253,925254,925255,925256,925257,925258,925259,925260,925261,925262,925263,925264,925265,925266,925267,925268,925269,925270,925271,925272,925273,925274,925275,925276,925277,925278,925279,925280,925281,925282,925283,925284,925285,925286,925287,925288,925289,925290,925291,925292,925293,925294,925295,925296,925297,925298,925299,925300,925301,925302,925303,925304,925305,925306,925307,925308,925309,925310,925311,925312,925313,925314,925315,925316,925317,925318,925319,925320,925321,925322,925323,925324,925325,925326,925327,925328,925329,925330,925331,925332,925333,925334,925335,925336,925337,925338,925339,925340,925341,925342,925343,925344,925345,925346,925347,925348,925349,925350,925351,925352,925353,925354,925355,925356,925357,925358,925359,925360,925361,925362,925363,925364,925365,925366,925367,925368,925369,925370,925371,925372,925373,925374,925375,925376,925377,925378,925379,925380,925381,925382,925383,925384,925385,925386,925387,925388,925389,925390,925391,925392,925393,925394,925395,925396,925397,925398,925399,925400,925401,925402,925403,925404,925405,925406,925407,925408,925409,925410,925411,925412,925413,925414,925415,925416,925417,925418,925419,925420,925421,925422,925423,925424,925425,925426,925427,925428,925429,925430,925431,925432,925433,925434,925435,925436,925437,925438,925439,925440,925441,925442,925443,925444,925445,925446,925447,925448,925449,925450,925451,925452,925453,925454,925455,925456,925457,925458,925459,925460,925461,925462,925463,925464,925465,925466,925467,925468,925469,925470,925471,925472,925473,925474,925475,925476,925477,925478,925479,925480,925481,925482,925483,925484,925485,925486,925487,925488,925489,925490,925491,925492,925493,925494,925495,925496,925497,925498,925499,925500,925501,925502,925503,925504,925505,925506,925507,925508,925509,925510,925511,925512,925513,925514,925515,925516,925517,925518,925519,925520,925521,925522,925523,925524,925525,925526,925527,925528,925529,925530,925531,925532,925533,925534,925535,925536,925537,925538,925539,925540,925541,925542,925543,925544,925545,925546,925547,925548,925549,925550,925551,925552,925553,925554,925555,925556,925557,925558,925559,925560,925561,925562,925563,925564,925565,925566,925567,925568,925569,925570,925571,925572,925573,925574,925575,925576,925577,925578,925579,925580,925581,925582,925583,925584,925585,925586,925587,925588,925589,925590,925591,925592,925593,925594,925595,925596,925597,925598,925599,925600,925601,925602,925603,925604,925605,925606,925607,925608,925609,925610,925611,925612,925613,925614,925615,925616,925617,925618,925619,925620,925621,925622,925623,925624,925625,925626,925627,925628,925629,925630,925631,925632,925633,925634,925635,925636,925637,925638,925639,925640,925641,925642,925643,925644,925645,925646,925647,925648,925649,925650,925651,925652,925653,925654,925655,925656,925657,925658,925659,925660,925661,925662,925663,925664,925665,925666,925667,925668,925669,925670,925671,925672,925673,925674,925675,925676,925677,925678,925679,925680,925681,925682,925683,925684,925685,925686,925687,925688,925689,925690,925691,925692,925693,925694,925695,925696,925697,925698,925699,925700,925701,925702,925703,925704,925705,925706,925707,925708,925709,925710,925711,925712,925713,925714,925715,925716,925717,925718,925719,925720,925721,925722,925723,925724,925725,925726,925727,925728,925729,925730,925731,925732,925733,925734,925735,925736,925737,925738,925739,925740,925741,925742,925743,925744,925745,925746,925747,925748,925749,925750,925751,925752,925753,925754,925755,925756,925757,925758,925759,925760,925761,925762,925763,925764,925765,925766,925767,925768,925769,925770,925771,925772,925773,925774,925775,925776,925777,925778,251032,252104,252217,252107,252108,253133,336383,336266,336384,336387,336273,336274,336275,336276,336277,336278,336279,336280,336281,336282,336283,336284,336285,336286,336287,336288,336289,336290,336291,336292,336293,336294,336295,336296,336297,336298,336299,336300,336301,336302,336303,336304,336305,336306,336307,336308,336309,336310,336311,336312,336313,336314,336315,336316,336317,336318,336319,336320,336385,336386,886726,886727,252216,253134,263412,336262,336263,336264,336265,336267,336268,336269,336270,336271,336272,336321,886701,918943,918944,918945,918946,918947,918948,918949,918950,918951,918952,918953,918954,918955,918956,918957,918958,918959,918960,918961,918962,918963,918964,918965,918966,918967,918968,918969,918970,918971,918972,918973,918974,918975,918976,918977,918978,918979,918980,918981,918982,918983,918984,918985,918986,918987,918988,918989,918990,918991,918992,918993,918994,918995,918996,918997,918998,918999,919000,919001,919002,919003,919004,919005,919006,919007,919008,919009,919010,919011,919012,919013,919014,919015,919016,919017,919018,919019,919020,919021,919022,919023,919024,919025,919026,919027,919028,919029,919030,919031,919032,919033,919034,919035,919036,919037,919038,919039,919040,919041,919042,919043,919044,919045,919046,919047,919048,919049,919050,919051,919052,919053,919054,919055,919056,919057,919058,919059,919060,919061,919062,919063,919064,919065,919066,919067,919068,919069,919070,919071,919072,919073,919074,919075,919076,919077,919078,925179,925180,925181,925182,925183,925184,925185,925186,925187,925188,925189,925190,925191,925192,925193,925194,925195,925196,925197,925198,925199,925200,925201,925202,925203,925204,925205,925206,925207,925208,925209,925210,925211,925212,925213,925214,925215,925216,925217,925218,925219,925220,925221,925222,925223,925224,925225,925226,925227,925228,925229,925230,925231,925232,925233,925234,925235,925236,925237,925238,925239,925240,925241,925242,925243,925244,925245,925246,925247,925248,925249,925250,925251,925252,925253,925254,925255,925256,925257,925258,925259,925260,925261,925262,925263,925264,925265,925266,925267,925268,925269,925270,925271,925272,925273,925274,925275,925276,925277,925278,925279,925280,925281,925282,925283,925284,925285,925286,925287,925288,925289,925290,925291,925292,925293,925294,925295,925296,925297,925298,925299,925300,925301,925302,925303,925304,925305,925306,925307,925308,925309,925310,925311,925312,925313,925314,925315,925316,925317,925318,925319,925320,925321,925322,925323,925324,925325,925326,925327,925328,925329,925330,925331,925332,925333,925334,925335,925336,925337,925338,925339,925340,925341,925342,925343,925344,925345,925346,925347,925348,925349,925350,925351,925352,925353,925354,925355,925356,925357,925358,925359,925360,925361,925362,925363,925364,925365,925366,925367,925368,925369,925370,925371,925372,925373,925374,925375,925376,925377,925378,925379,925380,925381,925382,925383,925384,925385,925386,925387,925388,925389,925390,925391,925392,925393,925394,925395,925396,925397,925398,925399,925400,925401,925402,925403,925404,925405,925406,925407,925408,925409,925410,925411,925412,925413,925414,925415,925416,925417,925418,925419,925420,925421,925422,925423,925424,925425,925426,925427,925428,925429,925430,925431,925432,925433,925434,925435,925436,925437,925438,925439,925440,925441,925442,925443,925444,925445,925446,925447,925448,925449,925450,925451,925452,925453,925454,925455,925456,925457,925458,925459,925460,925461,925462,925463,925464,925465,925466,925467,925468,925469,925470,925471,925472,925473,925474,925475,925476,925477,925478,925479,925480,925481,925482,925483,925484,925485,925486,925487,925488,925489,925490,925491,925492,925493,925494,925495,925496,925497,925498,925499,925500,925501,925502,925503,925504,925505,925506,925507,925508,925509,925510,925511,925512,925513,925514,925515,925516,925517,925518,925519,925520,925521,925522,925523,925524,925525,925526,925527,925528,925529,925530,925531,925532,925533,925534,925535,925536,925537,925538,925539,925540,925541,925542,925543,925544,925545,925546,925547,925548,925549,925550,925551,925552,925553,925554,925555,925556,925557,925558,925559,925560,925561,925562,925563,925564,925565,925566,925567,925568,925569,925570,925571,925572,925573,925574,925575,925576,925577,925578,925579,925580,925581,925582,925583,925584,925585,925586,925587,925588,925589,925590,925591,925592,925593,925594,925595,925596,925597,925598,925599,925600,925601,925602,925603,925604,925605,925606,925607,925608,925609,925610,925611,925612,925613,925614,925615,925616,925617,925618,925619,925620,925621,925622,925623,925624,925625,925626,925627,925628,925629,925630,925631,925632,925633,925634,925635,925636,925637,925638,925639,925640,925641,925642,925643,925644,925645,925646,925647,925648,925649,925650,925651,925652,925653,925654,925655,925656,925657,925658,925659,925660,925661,925662,925663,925664,925665,925666,925667,925668,925669,925670,925671,925672,925673,925674,925675,925676,925677,925678,925679,925680,925681,925682,925683,925684,925685,925686,925687,925688,925689,925690,925691,925692,925693,925694,925695,925696,925697,925698,925699,925700,925701,925702,925703,925704,925705,925706,925707,925708,925709,925710,925711,925712,925713,925714,925715,925716,925717,925718,925719,925720,925721,925722,925723,925724,925725,925726,925727,925728,925729,925730,925731,925732,925733,925734,925735,925736,925737,925738,925739,925740,925741,925742,925743,925744,925745,925746,925747,925748,925749,925750,925751,925752,925753,925754,925755,925756,925757,925758,925759,925760,925761,925762,925763,925764,925765,925766,925767,925768,925769,925770,925771,925772,925773,925774,925775,925776,925777,925778,251032,252104,252217,252107,252108,253133,336383,336266,336384,336387,336273,336274,336275,336276,336277,336278,336279,336280,336281,336282,336283,336284,336285,336286,336287,336288,336289,336290,336291,336292,336293,336294,336295,336296,336297,336298,336299,336300,336301,336302,336303,336304,336305,336306,336307,336308,336309,336310,336311,336312,336313,336314,336315,336316,336317,336318,336319,336320,336385,336386,886726,886727,252216,253134,263412,336262,336263,336264,336265,336267,336268,336269,336270,336271,336272,336321,886701,918943,918944,918945,918946,918947,918948,918949,918950,918951,918952,918953,918954,918955,918956,918957,918958,918959,918960,918961,918962,918963,918964,918965,918966,918967,918968,918969,918970,918971,918972,918973,918974,918975,918976,918977,918978,918979,918980,918981,918982,918983,918984,918985,918986,918987,918988,918989,918990,918991,918992,918993,918994,918995,918996,918997,918998,918999,919000,919001,919002,919003,919004,919005,919006,919007,919008,919009,919010,919011,919012,919013,919014,919015,919016,919017,919018,919019,919020,919021,919022,919023,919024,919025,919026,919027,919028,919029,919030,919031,919032,919033,919034,919035,919036,919037,919038,919039,919040,919041,919042,919043,919044,919045,919046,919047,919048,919049,919050,919051,919052,919053,919054,919055,919056,919057,919058,919059,919060,919061,919062,919063,919064,919065,919066,919067,919068,919069,919070,919071,919072,919073,919074,919075,919076,919077,919078,925179,925180,925181,925182,925183,925184,925185,925186,925187,925188,925189,925190,925191,925192,925193,925194,925195,925196,925197,925198,925199,925200,925201,925202,925203,925204,925205,925206,925207,925208,925209,925210,925211,925212,925213,925214,925215,925216,925217,925218,925219,925220,925221,925222,925223,925224,925225,925226,925227,925228,925229,925230,925231,925232,925233,925234,925235,925236,925237,925238,925239,925240,925241,925242,925243,925244,925245,925246,925247,925248,925249,925250,925251,925252,925253,925254,925255,925256,925257,925258,925259,925260,925261,925262,925263,925264,925265,925266,925267,925268,925269,925270,925271,925272,925273,925274,925275,925276,925277,925278,925279,925280,925281,925282,925283,925284,925285,925286,925287,925288,925289,925290,925291,925292,925293,925294,925295,925296,925297,925298,925299,925300,925301,925302,925303,925304,925305,925306,925307,925308,925309,925310,925311,925312,925313,925314,925315,925316,925317,925318,925319,925320,925321,925322,925323,925324,925325,925326,925327,925328,925329,925330,925331,925332,925333,925334,925335,925336,925337,925338,925339,925340,925341,925342,925343,925344,925345,925346,925347,925348,925349,925350,925351,925352,925353,925354,925355,925356,925357,925358,925359,925360,925361,925362,925363,925364,925365,925366,925367,925368,925369,925370,925371,925372,925373,925374,925375,925376,925377,925378,925379,925380,925381,925382,925383,925384,925385,925386,925387,925388,925389,925390,925391,925392,925393,925394,925395,925396,925397,925398,925399,925400,925401,925402,925403,925404,925405,925406,925407,925408,925409,925410,925411,925412,925413,925414,925415,925416,925417,925418,925419,925420,925421,925422,925423,925424,925425,925426,925427,925428,925429,925430,925431,925432,925433,925434,925435,925436,925437,925438,925439,925440,925441,925442,925443,925444,925445,925446,925447,925448,925449,925450,925451,925452,925453,925454,925455,925456,925457,925458,925459,925460,925461,925462,925463,925464,925465,925466,925467,925468,925469,925470,925471,925472,925473,925474,925475,925476,925477,925478,925479,925480,925481,925482,925483,925484,925485,925486,925487,925488,925489,925490,925491,925492,925493,925494,925495,925496,925497,925498,925499,925500,925501,925502,925503,925504,925505,925506,925507,925508,925509,925510,925511,925512,925513,925514,925515,925516,925517,925518,925519,925520,925521,925522,925523,925524,925525,925526,925527,925528,925529,925530,925531,925532,925533,925534,925535,925536,925537,925538,925539,925540,925541,925542,925543,925544,925545,925546,925547,925548,925549,925550,925551,925552,925553,925554,925555,925556,925557,925558,925559,925560,925561,925562,925563,925564,925565,925566,925567,925568,925569,925570,925571,925572,925573,925574,925575,925576,925577,925578,925579,925580,925581,925582,925583,925584,925585,925586,925587,925588,925589,925590,925591,925592,925593,925594,925595,925596,925597,925598,925599,925600,925601,925602,925603,925604,925605,925606,925607,925608,925609,925610,925611,925612,925613,925614,925615,925616,925617,925618,925619,925620,925621,925622,925623,925624,925625,925626,925627,925628,925629,925630,925631,925632,925633,925634,925635,925636,925637,925638,925639,925640,925641,925642,925643,925644,925645,925646,925647,925648,925649,925650,925651,925652,925653,925654,925655,925656,925657,925658,925659,925660,925661,925662,925663,925664,925665,925666,925667,925668,925669,925670,925671,925672,925673,925674,925675,925676,925677,925678,925679,925680,925681,925682,925683,925684,925685,925686,925687,925688,925689,925690,925691,925692,925693,925694,925695,925696,925697,925698,925699,925700,925701,925702,925703,925704,925705,925706,925707,925708,925709,925710,925711,925712,925713,925714,925715,925716,925717,925718,925719,925720,925721,925722,925723,925724,925725,925726,925727,925728,925729,925730,925731,925732,925733,925734,925735,925736,925737,925738,925739,925740,925741,925742,925743,925744,925745,925746,925747,925748,925749,925750,925751,925752,925753,925754,925755,925756,925757,925758,925759,925760,925761,925762,925763,925764,925765,925766,925767,925768,925769,925770,925771,925772,925773,925774,925775,925776,925777,925778,251032,252104,252217,252107,252108,253133,336383,336266,336384,336387,336273,336274,336275,336276,336277,336278,336279,336280,336281,336282,336283,336284,336285,336286,336287,336288,336289,336290,336291,336292,336293,336294,336295,336296,336297,336298,336299,336300,336301,336302,336303,336304,336305,336306,336307,336308,336309,336310,336311,336312,336313,336314,336315,336316,336317,336318,336319,336320,336385,336386,886726,886727}',NULL,'123143','14','[518867]'); -- update record, not update the array field, update non array field, example: project_id update public.test set project_id = project_id+1 where id ='test-1';
What behavior do you expect?
-- it very large see attachment file
What behavior do you see?
{
"before": null,
"after": {
"record_create_time": "2023-12-27T00:26:16.135161Z",
"record_update_time": "2024-09-06T09:21:51.798040Z",
"id": "test-1",
"report_id": "cK_s9osBYBO77D0-DEno",
"area": "DJ",
"plan_id": 15954,
"plan_name": "123143",
"demand_ids": null,
"case_ids": [
95,
95,
100,
101,
98,
101,
122,
105,
117,
109,
95,
117,
110,
97,
118,
97,
105,
108,
97,
98,
108,
101,
95,
118,
97,
108,
117,
101
],
"script_ids": null,
"project_id": 15,
"bug_ids": "[518867]"
},
"source": {
"version": "2.7.1.Final",
"connector": "postgresql",
"name": "pengys_test",
"ts_ms": 1725614511800,
"snapshot": "false",
"db": "postgresdb",
"sequence": "[\"23337576\",\"23337744\"]",
"ts_us": 1725614511800263,
"ts_ns": 1725614511800263000,
"schema": "public",
"table": "test",
"txId": 513,
"lsn": 23337744,
"xmin": null
},
"transaction": null,
"op": "u",
"ts_ms": 1725614512110,
"ts_us": 1725614512110601,
"ts_ns": 1725614512110601208
}
array field msg in kafka is wrong data, it should be very large like attament file or unavaliable value.
Do you see the same behaviour using the latest released Debezium version?
(Ideally, also verify with latest Alpha/Beta/CR version)
2.7.1 is the latest version
Do you have the connector logs, ideally from start till finish?
(You might be asked later to provide DEBUG/TRACE level log)
no warn or error logs
How to reproduce the issue using our tutorial deployment?
<Your answer>
Feature request or enhancement
For feature requests or enhancements, provide this information, please:
Which use case/requirement will be addressed by the proposed feature?
<Your answer>
Implementation ideas (optional)
<Your answer>
