Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3834

Row hashing in LogMiner Query not able to differentiate between rows of a statement.

    XMLWordPrintable

Details

    • Hide

      Setup oracle + debezium in a standard way

      CREATE TABLE CDCTEST.CUSTOMER2 (
                                         c_id integer NOT NULL,
                                         c_d_id integer NOT NULL,
                                         c_w_id int NOT NULL,
                                         c_first varchar(16)  DEFAULT NULL,
                                         c_middle char(2)  DEFAULT NULL,
                                         c_last varchar(16)  DEFAULT NULL,
                                         c_street_1 varchar(20)  DEFAULT NULL,
                                         c_street_2 varchar(20)  DEFAULT NULL,
                                         c_city varchar(20)  DEFAULT NULL,
                                         c_state char(2)  DEFAULT NULL,
                                         c_zip char(9)  DEFAULT NULL,
                                         c_phone char(16)  DEFAULT NULL,
                                         c_since timestamp(6) DEFAULT NULL,
                                         c_credit char(2)  DEFAULT NULL,
                                         c_credit_lim decimal(12,2) DEFAULT NULL,
                                         c_discount decimal(4,4) DEFAULT NULL,
                                         c_balance decimal(12,2) DEFAULT NULL,
                                         c_ytd_payment decimal(12,2) DEFAULT NULL,
                                         c_payment_cnt int DEFAULT NULL,
                                         c_delivery_cnt int DEFAULT NULL,
                                         c_data varchar(500)  DEFAULT NULL,
                                      PRIMARY KEY (c_w_id,c_d_id,c_id)) ;
      
      ALTER TABLE CDCTEST.CUSTOMER2 ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
      
      

      Start engine and insert 10 rows in streaming mode.
      Note below statment is altered becuase jira wont let me type U_N_I_O_N ALL SELECT

      INSERT INTO  CDCTEST.CUSTOMER2
      (c_id,
       c_d_id,
       c_w_id,
       c_first,
       c_middle,
       c_last,
       c_street_1,
       c_street_2,
       c_city,
       c_state,
       c_zip,
       c_phone,
       c_since,
       c_credit,
       c_credit_lim,
       c_discount,
       c_balance,
       c_ytd_payment,
       c_payment_cnt,
       c_delivery_cnt,
       c_data)
      SELECT '11', '1', '1', 'YPMEqJQ5IEP', 'OE', 'JAMIE 99', 'wa0VoV7bqHSzD', 'KnccHddq9hQOIJ0C9', 'Dmj3vz6HARRt1FfLOm9w', '8J', '599511111', '9649048615610128', TO_TIMESTAMP('2019-07-12 14:16:53.123456','YYYY-MM-DD HH24:MI:SS.FF6'), 'GC', '50000.00', '0.0100', '-10.00', '10.00', '1', '0', '2uugupWLaZRZ-truncated- FROM DUAL
      ONION ALL SELECT '12', '1', '1', 'abjLiHVtX7', 'OE', 'JAMIE 32', 'm8GZI5UurI7pbQn', 'Kc4X1KYH2e7r', '24vhA7CNiPVS4eO', 'MW', '470211111', '3097542740098740', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'GC', '50000.00', '0.4200', '1025.00', '10.00', '1', '0', '3cdfoAy1wdl8AjZhWuM6JsgJ1BLLkCd75VPjgnkO8IzbfUFs9tKcn0lhuUmlZavaQXyvOBReHJriG0kwRKoAJCXz7j3ypEao4Ukpt7vuzyvdHTl1CiMTr5Hp5yTdnbPv19zVowA09NhU8ZRm7LmXBthjm880NHcPSXXTcD6qN84wVLaDkjtI5oHqDaxwjAFDOA15ucC0XDiuH8U6U8whulQraAPMXOziCFC8k9xKyIoRO1wI437qTKdwuFoK9TqSAsHdp0xxRaa9wHnS6xRUkF6o7NtToaojOFT5hP31fsZTnMrGv1fwsMKZ2KfLFTg7fHG9mxhiBI17QqHAdSfUmcMqctJHOEa834dw5LNQkBEnh5s6DzISaJJazbMwzqIXfgjQD6oMopKeIBxccf1S2utAHqmawTGf79jzVcHb6z' FROM DUAL
      ONION ALL SELECT '13', '1', '1', 'zUopfB4OpFQVj54t', 'OE', 'JAMIE 32', '8oq3O01Uc5o7HQCjO', 'CMfV4MJvVKastzjDcc', 'Jlfj9uZ2NgN', 'L5', '929911111', '3706237873872500', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'GC', '50000.00', '0.4400', '-10.00', '10.00', '1', '0', 'V5FFBJvCzs82Ft9Tc8TNUfty195nLEmr2YtxbLer7ZSpUJHpVpIHwpjV4txsJpOtALGVzuC7AhTtVvQuLp0dHvXFz2wSqf3IzAmaS0BI8J6afvZpLXKGzjueUOHRiRdDokoC3OZgmdqdkpYYnbGZfJJnA6RAp4ZQFNFdXWDnCM1yPbIjBQWxo3eg9kJCwFCM20VtuPvGnGP5EtlfNlnCxSkcf2d45xxYnHMUsngz6cAW946FZZR0UINWX0d6SSan1ntpFFIRIm1RKNuBH4lYiB3sCI0SW4Cj8wxiDij4xwZGWvomTnleF8yES4t3IIjhhnoKHziQD9rG6HGuAPjtbtcHDBkyjT8wVshbKt1ATgIWPjgd4pt1KSWodPyyXqLNTN7CRBdIizWaVS24WOqLSf2ik3UkZuK6MrDnB9Y7ALuIHDWaTAuuJUAWjXpQmar' FROM DUAL
      ONION ALL SELECT '14', '1', '1', 'CsPuJqvoI1J', 'OE', 'JAMIE 32', 'c27rmEkoVqJYZ71Ggo', '0l3I3FMHcuC1NqB', 'S6CPNjNydqcNednml', 'hc', '611311111', '5505005826338725', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'GC', '50000.00', '0.3800', '-10.00', '10.00', '1', '0', '1qPxmch1cIN5tXnLD9sNlIB9Fkv7vRJdA7kVvDnCZRylJrNF8T6btvtcp0TFtd4jqmbKbbvLwLVn67oXUftpPb5CwykpkcLY5vpb7ldI1tgVFdSo0QIZ41HnO7ZqKjdC3HdHQKhjISr2qnzRQxo70TkEA7WuowteMMuXTKeGmBtpTiLW0MCEis5SxkdZb3RQ0PoXE0OjseU4x6VVZ05FscxBGYZYWr8MBhvfvX3jqj7WSUK7R4L05rspnDb5SgcNkZOL6ctu7jtZb2PT9KyWpbJtlJ9GrkXmVHBYicBRl1di0AycQDhNtuxXjAxkHgJZpD1QZzFIIO' FROM DUAL
      ONION ALL SELECT '15', '1', '1', 'AEW2DG6sX7e', 'OE', 'JAMIE 32', 'AxXqoHD5toGJuKj', 'SiyQapU9kf', 'fse4IfX9UvKnr8fhFyQ', 'qX', '497911111', '2495984918559300', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'BC', '50000.00', '0.1700', '-10.00', '10.00', '1', '0', 'fRdmoMKxIKQQRdqV50tM2Who9xj9hLKHg7qeywVgFAUAJT7kKaKhGFPGsqvf5r0DZSwg1pEYxzTROUcE0Q6kQKyLlc6Ls3bZh27B0ZYFscr4RbqDrdNTFd9C90QmIpzXpf39AMn47vdG7sUAMk9kzkIu0LeSisDbWyOxJZaMiljaPADLQgIVpGswWJemCHxCHLCjmsJAG8DLEkqxwshCVvFAaBBlNQPLYOTdzetUEBjW9P0Ks8tLFtvbKvhbYbRitRGE0vMA3VxorVvDcXEj5mt7gND7VsVPbl6mQyeEarX74cEqWe33IHfh5TiaEluBGOKGdLnOzzfbAyStNYUEqc70QH8n9DZ78pXLoduwQIHibO0FHyg3Bx1gz6LbasPsK2g2fzPw05CYaiXedj89OFlRwqlcszv6pRUAVctXLw7gF9uQm130N4C09ArN4EbECaCPhEf8w5U' FROM DUAL
      ONION ALL SELECT '16', '1', '1', 'ulBbR8TU7iQb99u', 'OE', 'JAMIE 32', 'R1Wflx5UA1oyENPab', 'j6hkkcwXdMqxIdvrJFe3', 'eIAGQlVXzQX8uUF', 'g8', '250111111', '3373213736026669', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'BC', '50000.00', '0.3800', '-10.00', '10.00', '1', '0', 'lUYWb2E2heTBCTOXbBTWlRjKWRjO3zHtB2eOXj5wUHIkbwiuWU9uPpjzqLBV71PcyNtINZlXHRM44xrHft8moxlTmNksSAPhAMOZ0lUPfC0Gspa5K9yWP8JmRxfvyxUnPKSGyvJeazi4mEkHeyBIXKz38OboCi43xslOz9DSlv1naYtWHBDaGbxprj44bkBIz4uNQBGSrSKU19pjyc7KzI0zijSDagXqTMUVVDqWkJefjC6RbD8WAi5d6kdguKkzWAen3wU9QxPnlJSGBaUk2aPxhffafFdaCM4GtT9KlUFja26R0CTwOzwc8GjSjKhVPUh848R2W9' FROM DUAL
      ONION ALL SELECT '17', '1', '1', 'BIafFFyLsy0J', 'OE', 'JAMIE 32', 'BFVRJmhmjuWVy', 'k1OU6fa3dU0YlLpVRPsL', 'RrkryfXyDVZh7Z', 'rN', '699611111', '2450903023267766', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'GC', '50000.00', '0.3600', '-10.00', '10.00', '1', '0', 'Gs6WGvwr5S0tNQBsTKAIbow5stnevfKlATK4JIUwJfVM2hkVJnms5A6mqU3GOChkrtNbrHj3qWonFh9xpsGmqarb4L58U2uyuaBti8fzjzJNaKO3fCdCPBC5aIJzWTfepMWFIojUW1pIxyHe2TE7yldYdL3ZEuOemBdHr6F766JXF9VVWWwwjx2ZbXkMWS9f1QcJu7AiSQZTe2VJk0UyQerUsQcPgfR1Z0IGfYfyLrdOXOWIpQoCKpAlDxvMydAhSfxXGF7NkX17oQXuOQWzzMur6OOLZcUaj5i5AKPgKwmRt2dkkCXc721oaQd5uJgSoy5QZPhbF2mdJszExgjOPLjs1fiz7vpZvuDkeB01dYGdtettJlO7476oymGJVVG5vCC6jOnNVPxGKnc7KYAoacu6tRhpkDHSYnfHGN1NFgNBkSTXZkOdWa8h461vAU9sd2ppjQaoFijkGQjEi8rCAw1dZlS673YY9RRwm8amu0' FROM DUAL
      ONION ALL SELECT '18', '1', '1', 'XwVhWChT4IoVi0v', 'OE', 'JAMIE 32', 'KdFUMTLgwP75Br', 'whvauesLLce', '6tLMB4JX66vE4', 'bX', '688411111', '3066490385028404', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'GC', '50000.00', '0.2400', '-10.00', '10.00', '1', '0', '6UaoGqTlQy6dghP2puMPwSfAm97jz4UyMxD9FTDetXPGhM0fKAuL4ki1lkVz5oS5Kvj83xCByNy2MGeguTYiQiHifbxSVsfG4A71f12LgFpWBzVEBBylcYZbfpiV1XQyzXqNjJpEfkX1O2Felahx2Pem4ukT0oQ5lgRBoytsOtfy7CZhf3sgkz7QCvuQJkOzViECc4uKVGjwTaoQBNDq2c7yIiDlkTBokczwJ9z30nTTCZtDsmgpvocMTQSG2SccqhYoYeh6vAphf41k0mspoTuBcLsz9HAzzs4U1pZuiMHkbqPMLkqxKyrCid6QzRqSTMBU9YeLnW3vTvE6EwYEq6VZfxUvXJxo178fa6IjlDVY4mDiIlvPd9YPcO2sUkA9UgPtvovmwDmk2S' FROM DUAL
      ONION ALL SELECT '19', '1', '1', 'pbVTUJJ17', 'OE', 'JAMIE 32', 'xBtvtdOLUwq', '5hcqnvVCz2GE2Px7tSJw', 'mXEmGh5p60ldqEmAq', 'Hf', '894711111', '4092852185655237', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'BC', '50000.00', '0.2900', '3720.00', '10.00', '1', '0', '9 1 1 1 1 3,730.002019-11-04hOxeLh I0g70QcgZzjAya8S09GPGCnKojjoZopo6OgVYc9DXoh7hU6MGtXAlUmFP4TyTJFDtIqSRMkctyeRoxN861hBg915r9Avn9oYxOAW7TZqoLB7ZmlN1WUHJ21VfokYlaAfwST6uPrzrQLfKJpvNiKHuYZ1FROi8E5cnX8bFQWCm5GHNxkaePjqOoEHataG0Nb9ZY7UCKFcjxzuuMi2xrnEaaq9Y8pCZFsTtAHor3SrAnqFuduk5q3wGR0qZ0pywCeJoGVk8bULI8dsH0q39EQ7CKR2XTFGoYGUHirZhsH776NsP7QSb7bVnjhzIvKGWNIvQTeVxJUDknW6KKpy05qWLrXVd98jxWImodCW7uDJpBnGVk3R8dorUBBEBSnejubvQKHhTxq6BFi4RgKUeYrORLgn1wCiwG5f' FROM DUAL
      ONION ALL SELECT '20', '1', '1', 'waEz5i5uDbmjiZ', 'OE', 'JAMIE 32', 'gTHsYIP7Yel', 'DltOIKCnAIZ70Lct5drO', 'jDFeY5LzC4ylYDObHs8', 'JK', '484711111', '1347174919698951', TO_TIMESTAMP('2019-07-12 14:16:53','YYYY-MM-DD HH24:MI:SS'), 'GC', '50000.00', '0.0100', '-10.00', '10.00', '1', '0', 'W6xny7pn3rlZ3AGYNYEpvwAaW5G5Cpl8No9QsYrDmLzTgD1uMAUV2nmR4q73b8RIDi5YydnJkzmbyUTbkG42QaQqKAcAIcrfJRv0RSjvtv5i6ORSGFlW8FQTKbeGzg0uXqy9lW2eRtNp5ppW7UaEvhcQlZU2rDAPnvDHA9aMBtv1MtrKj6eOJamLpHVGLq1g9wri1HV932bEDcvAqXZvPBBcBw5hnvE4Vr7RTdObVjCD9qgLAuobLQwrtTwrlGnQskRgrnw1TpfHAU8WZpFCpQLY3Y5bDddtY76lrUZ4g74XEqY1lxPciUrUAA6B0q68QM1LGfoI3c942mkEc0z4QUVnOrYwkAqDhk088jQrmOy' FROM DUAL;
      )
      )
      

      This results in 10 rows in the DML trace like this

       2021-08-09 11:05:34 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('11','1','1','YPMEqJQ5IEP','OE','JAMIE 99','wa0VoV7bqHSzD','KnccHddq9hQOIJ0C9','Dmj3vz6HARRt1FfLOm9w','8J','599511111','9649048615610128',TO_TIMESTAMP('2019-07-12 14:16:53.123456'),'GC','50000','.01','-10','10','1','0','2uugupWLaZRZBlBxWvPiaiR0HaNotpnmysPu02MO9SLNYFsmlU52vEYKOVDtZVSJEgwpyyGv1GXbu1GYBkLpcVYGBBKELe8LDn4JlTELYgxSSSLw6fTlu9O7RY2XP940DdcOPcQRJNXBnnKUl2EK2AZn3dlhW04ki6Q55qkTYbQu35rE183RR4ObRlmB182LcPe0AP8eUECiPaXfprPUTBVcLb1yZK0GEVop3WEEMVG27k2epsRNpHt5iDOqo59yRrh04xt4mk9cKRemSYkKzihcxbZQaWpZiTtb9GZGHBKlNyCrod9HRq7Vsu6X7g1Avq1VKmkZEHbUYV1S9iFr16DgDy8UFPiRqq4lq5rFcDiPUIw0zuYdSnekMBNOWqJA'); 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAB, rollbackFlag=0 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('12','1','1','abjLiHVtX7','OE','JAMIE 32','m8GZI5UurI7pbQn','Kc4X1KYH2e7r','24vhA7CNiPVS4eO','MW','470211111','3097542740098740',TO_TIMESTAMP('2019-07-12 14:16:53.'),'GC','50000','.42','1025','10','1','0','3cdfoAy1wdl8AjZhWuM6JsgJ1BLLkCd75VPjgnkO8IzbfUFs9tKcn0lhuUmlZavaQXyvOBReHJriG0kwRKoAJCXz7j3ypEao4Ukpt7vuzyvdHTl1CiMTr5Hp5yTdnbPv19zVowA09NhU8ZRm7LmXBthjm880NHcPSXXTcD6qN84wVLaDkjtI5oHqDaxwjAFDOA15ucC0XDiuH8U6U8whulQraAPMXOziCFC8k9xKyIoRO1wI437qTKdwuFoK9TqSAsHdp0xxRaa9wHnS6xRUkF6o7NtToaojOFT5hP31fsZTnMrGv1fwsMKZ2KfLFTg7fHG9mxhiBI17QqHAdSfUmcMqctJHOEa834dw5LNQkBEnh5s6DzISaJJazbMwzqIXfgjQD6oMopKeIBxccf1S2utAHqmawTGf79jzVcHb6z'); 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAC, rollbackFlag=0 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('13','1','1','zUopfB4OpFQVj54t','OE','JAMIE 32','8oq3O01Uc5o7HQCjO','CMfV4MJvVKastzjDcc','Jlfj9uZ2NgN','L5','929911111','3706237873872500',TO_TIMESTAMP('2019-07-12 14:16:53.'),'GC','50000','.44','-10','10','1','0','V5FFBJvCzs82Ft9Tc8TNUfty195nLEmr2YtxbLer7ZSpUJHpVpIHwpjV4txsJpOtALGVzuC7AhTtVvQuLp0dHvXFz2wSqf3IzAmaS0BI8J6afvZpLXKGzjueUOHRiRdDokoC3OZgmdqdkpYYnbGZfJJnA6RAp4ZQFNFdXWDnCM1yPbIjBQWxo3eg9kJCwFCM20VtuPvGnGP5EtlfNlnCxSkcf2d45xxYnHMUsngz6cAW946FZZR0UINWX0d6SSan1ntpFFIRIm1RKNuBH4lYiB3sCI0SW4Cj8wxiDij4xwZGWvomTnleF8yES4t3IIjhhnoKHziQD9rG6HGuAPjtbtcHDBkyjT8wVshbKt1ATgIWPjgd4pt1KSWodPyyXqLNTN7CRBdIizWaVS24WOqLSf2ik3UkZuK6MrDnB9Y7ALuIHDWaTAuuJUAWjXpQmar'); 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAD, rollbackFlag=0 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('14','1','1','CsPuJqvoI1J','OE','JAMIE 32','c27rmEkoVqJYZ71Ggo','0l3I3FMHcuC1NqB','S6CPNjNydqcNednml','hc','611311111','5505005826338725',TO_TIMESTAMP('2019-07-12 14:16:53.'),'GC','50000','.38','-10','10','1','0','1qPxmch1cIN5tXnLD9sNlIB9Fkv7vRJdA7kVvDnCZRylJrNF8T6btvtcp0TFtd4jqmbKbbvLwLVn67oXUftpPb5CwykpkcLY5vpb7ldI1tgVFdSo0QIZ41HnO7ZqKjdC3HdHQKhjISr2qnzRQxo70TkEA7WuowteMMuXTKeGmBtpTiLW0MCEis5SxkdZb3RQ0PoXE0OjseU4x6VVZ05FscxBGYZYWr8MBhvfvX3jqj7WSUK7R4L05rspnDb5SgcNkZOL6ctu7jtZb2PT9KyWpbJtlJ9GrkXmVHBYicBRl1di0AycQDhNtuxXjAxkHgJZpD1QZzFIIO'); 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAE, rollbackFlag=0 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('15','1','1','AEW2DG6sX7e','OE','JAMIE 32','AxXqoHD5toGJuKj','SiyQapU9kf','fse4IfX9UvKnr8fhFyQ','qX','497911111','2495984918559300',TO_TIMESTAMP('2019-07-12 14:16:53.'),'BC','50000','.17','-10','10','1','0','fRdmoMKxIKQQRdqV50tM2Who9xj9hLKHg7qeywVgFAUAJT7kKaKhGFPGsqvf5r0DZSwg1pEYxzTROUcE0Q6kQKyLlc6Ls3bZh27B0ZYFscr4RbqDrdNTFd9C90QmIpzXpf39AMn47vdG7sUAMk9kzkIu0LeSisDbWyOxJZaMiljaPADLQgIVpGswWJemCHxCHLCjmsJAG8DLEkqxwshCVvFAaBBlNQPLYOTdzetUEBjW9P0Ks8tLFtvbKvhbYbRitRGE0vMA3VxorVvDcXEj5mt7gND7VsVPbl6mQyeEarX74cEqWe33IHfh5TiaEluBGOKGdLnOzzfbAyStNYUEqc70QH8n9DZ78pXLoduwQIHibO0FHyg3Bx1gz6LbasPsK2g2fzPw05CYaiXedj89OFlRwqlcszv6pRUAVctXLw7gF9uQm130N4C09ArN4EbECaCPhEf8w5U'); 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAF, rollbackFlag=0 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('16','1','1','ulBbR8TU7iQb99u','OE','JAMIE 32','R1Wflx5UA1oyENPab','j6hkkcwXdMqxIdvrJFe3','eIAGQlVXzQX8uUF','g8','250111111','3373213736026669',TO_TIMESTAMP('2019-07-12 14:16:53.'),'BC','50000','.38','-10','10','1','0','lUYWb2E2heTBCTOXbBTWlRjKWRjO3zHtB2eOXj5wUHIkbwiuWU9uPpjzqLBV71PcyNtINZlXHRM44xrHft8moxlTmNksSAPhAMOZ0lUPfC0Gspa5K9yWP8JmRxfvyxUnPKSGyvJeazi4mEkHeyBIXKz38OboCi43xslOz9DSlv1naYtWHBDaGbxprj44bkBIz4uNQBGSrSKU19pjyc7KzI0zijSDagXqTMUVVDqWkJefjC6RbD8WAi5d6kdguKkzWAen3wU9QxPnlJSGBaUk2aPxhffafFdaCM4GtT9KlUFja26R0CTwOzwc8GjSjKhVPUh848R2W9'); 
      2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAG, rollbackFlag=0
      

       Its evident from the trace that 256 chars is not sufficient to disambiguate the rows and it appears all other values are the same.

      String ROW_HASH = "ORA_HASH(SCN||OPERATION||RS_ID||SEQUENCE#||RTRIM(SUBSTR(SQL_REDO,1,256)))";
      

      I am probably not qualified to suggest a fix here but I wondered if the developer didn't expect the SubString to be relied upon and it's there just in case.

       

      Looks like the change was introduced here:-

      https://github.com/debezium/debezium/pull/2347/files#diff-368116a398e866498f9047ace72eac4d98dc2dcce35780f245e642cf5eda6626

      Show
      Setup oracle + debezium in a standard way CREATE TABLE CDCTEST.CUSTOMER2 ( c_id integer NOT NULL , c_d_id integer NOT NULL , c_w_id int NOT NULL , c_first varchar (16) DEFAULT NULL , c_middle char (2) DEFAULT NULL , c_last varchar (16) DEFAULT NULL , c_street_1 varchar (20) DEFAULT NULL , c_street_2 varchar (20) DEFAULT NULL , c_city varchar (20) DEFAULT NULL , c_state char (2) DEFAULT NULL , c_zip char (9) DEFAULT NULL , c_phone char (16) DEFAULT NULL , c_since timestamp (6) DEFAULT NULL , c_credit char (2) DEFAULT NULL , c_credit_lim decimal (12,2) DEFAULT NULL , c_discount decimal (4,4) DEFAULT NULL , c_balance decimal (12,2) DEFAULT NULL , c_ytd_payment decimal (12,2) DEFAULT NULL , c_payment_cnt int DEFAULT NULL , c_delivery_cnt int DEFAULT NULL , c_data varchar (500) DEFAULT NULL , PRIMARY KEY (c_w_id,c_d_id,c_id)) ; ALTER TABLE CDCTEST.CUSTOMER2 ADD SUPPLEMENTAL LOG DATA ( ALL ) COLUMNS ; Start engine and insert 10 rows in streaming mode. Note below statment is altered becuase jira wont let me type U_N_I_O_N ALL SELECT INSERT INTO CDCTEST.CUSTOMER2 (c_id, c_d_id, c_w_id, c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_since, c_credit, c_credit_lim, c_discount, c_balance, c_ytd_payment, c_payment_cnt, c_delivery_cnt, c_data) SELECT '11' , '1' , '1' , 'YPMEqJQ5IEP' , 'OE' , 'JAMIE 99' , 'wa0VoV7bqHSzD' , 'KnccHddq9hQOIJ0C9' , 'Dmj3vz6HARRt1FfLOm9w' , '8J' , '599511111' , '9649048615610128' , TO_TIMESTAMP( '2019-07-12 14:16:53.123456' , 'YYYY-MM-DD HH24:MI:SS.FF6' ), 'GC' , '50000.00' , '0.0100' , '-10.00' , '10.00' , '1' , '0' , '2uugupWLaZRZ-truncated- FROM DUAL ONION ALL SELECT '12' , '1' , '1' , 'abjLiHVtX7' , 'OE' , 'JAMIE 32' , 'm8GZI5UurI7pbQn' , 'Kc4X1KYH2e7r' , '24vhA7CNiPVS4eO' , 'MW' , '470211111' , '3097542740098740' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'GC' , '50000.00' , '0.4200' , '1025.00' , '10.00' , '1' , '0' , '3cdfoAy1wdl8AjZhWuM6JsgJ1BLLkCd75VPjgnkO8IzbfUFs9tKcn0lhuUmlZavaQXyvOBReHJriG0kwRKoAJCXz7j3ypEao4Ukpt7vuzyvdHTl1CiMTr5Hp5yTdnbPv19zVowA09NhU8ZRm7LmXBthjm880NHcPSXXTcD6qN84wVLaDkjtI5oHqDaxwjAFDOA15ucC0XDiuH8U6U8whulQraAPMXOziCFC8k9xKyIoRO1wI437qTKdwuFoK9TqSAsHdp0xxRaa9wHnS6xRUkF6o7NtToaojOFT5hP31fsZTnMrGv1fwsMKZ2KfLFTg7fHG9mxhiBI17QqHAdSfUmcMqctJHOEa834dw5LNQkBEnh5s6DzISaJJazbMwzqIXfgjQD6oMopKeIBxccf1S2utAHqmawTGf79jzVcHb6z' FROM DUAL ONION ALL SELECT '13' , '1' , '1' , 'zUopfB4OpFQVj54t' , 'OE' , 'JAMIE 32' , '8oq3O01Uc5o7HQCjO' , 'CMfV4MJvVKastzjDcc' , 'Jlfj9uZ2NgN' , 'L5' , '929911111' , '3706237873872500' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'GC' , '50000.00' , '0.4400' , '-10.00' , '10.00' , '1' , '0' , 'V5FFBJvCzs82Ft9Tc8TNUfty195nLEmr2YtxbLer7ZSpUJHpVpIHwpjV4txsJpOtALGVzuC7AhTtVvQuLp0dHvXFz2wSqf3IzAmaS0BI8J6afvZpLXKGzjueUOHRiRdDokoC3OZgmdqdkpYYnbGZfJJnA6RAp4ZQFNFdXWDnCM1yPbIjBQWxo3eg9kJCwFCM20VtuPvGnGP5EtlfNlnCxSkcf2d45xxYnHMUsngz6cAW946FZZR0UINWX0d6SSan1ntpFFIRIm1RKNuBH4lYiB3sCI0SW4Cj8wxiDij4xwZGWvomTnleF8yES4t3IIjhhnoKHziQD9rG6HGuAPjtbtcHDBkyjT8wVshbKt1ATgIWPjgd4pt1KSWodPyyXqLNTN7CRBdIizWaVS24WOqLSf2ik3UkZuK6MrDnB9Y7ALuIHDWaTAuuJUAWjXpQmar' FROM DUAL ONION ALL SELECT '14' , '1' , '1' , 'CsPuJqvoI1J' , 'OE' , 'JAMIE 32' , 'c27rmEkoVqJYZ71Ggo' , '0l3I3FMHcuC1NqB' , 'S6CPNjNydqcNednml' , 'hc' , '611311111' , '5505005826338725' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'GC' , '50000.00' , '0.3800' , '-10.00' , '10.00' , '1' , '0' , '1qPxmch1cIN5tXnLD9sNlIB9Fkv7vRJdA7kVvDnCZRylJrNF8T6btvtcp0TFtd4jqmbKbbvLwLVn67oXUftpPb5CwykpkcLY5vpb7ldI1tgVFdSo0QIZ41HnO7ZqKjdC3HdHQKhjISr2qnzRQxo70TkEA7WuowteMMuXTKeGmBtpTiLW0MCEis5SxkdZb3RQ0PoXE0OjseU4x6VVZ05FscxBGYZYWr8MBhvfvX3jqj7WSUK7R4L05rspnDb5SgcNkZOL6ctu7jtZb2PT9KyWpbJtlJ9GrkXmVHBYicBRl1di0AycQDhNtuxXjAxkHgJZpD1QZzFIIO' FROM DUAL ONION ALL SELECT '15' , '1' , '1' , 'AEW2DG6sX7e' , 'OE' , 'JAMIE 32' , 'AxXqoHD5toGJuKj' , 'SiyQapU9kf' , 'fse4IfX9UvKnr8fhFyQ' , 'qX' , '497911111' , '2495984918559300' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'BC' , '50000.00' , '0.1700' , '-10.00' , '10.00' , '1' , '0' , 'fRdmoMKxIKQQRdqV50tM2Who9xj9hLKHg7qeywVgFAUAJT7kKaKhGFPGsqvf5r0DZSwg1pEYxzTROUcE0Q6kQKyLlc6Ls3bZh27B0ZYFscr4RbqDrdNTFd9C90QmIpzXpf39AMn47vdG7sUAMk9kzkIu0LeSisDbWyOxJZaMiljaPADLQgIVpGswWJemCHxCHLCjmsJAG8DLEkqxwshCVvFAaBBlNQPLYOTdzetUEBjW9P0Ks8tLFtvbKvhbYbRitRGE0vMA3VxorVvDcXEj5mt7gND7VsVPbl6mQyeEarX74cEqWe33IHfh5TiaEluBGOKGdLnOzzfbAyStNYUEqc70QH8n9DZ78pXLoduwQIHibO0FHyg3Bx1gz6LbasPsK2g2fzPw05CYaiXedj89OFlRwqlcszv6pRUAVctXLw7gF9uQm130N4C09ArN4EbECaCPhEf8w5U' FROM DUAL ONION ALL SELECT '16' , '1' , '1' , 'ulBbR8TU7iQb99u' , 'OE' , 'JAMIE 32' , 'R1Wflx5UA1oyENPab' , 'j6hkkcwXdMqxIdvrJFe3' , 'eIAGQlVXzQX8uUF' , 'g8' , '250111111' , '3373213736026669' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'BC' , '50000.00' , '0.3800' , '-10.00' , '10.00' , '1' , '0' , 'lUYWb2E2heTBCTOXbBTWlRjKWRjO3zHtB2eOXj5wUHIkbwiuWU9uPpjzqLBV71PcyNtINZlXHRM44xrHft8moxlTmNksSAPhAMOZ0lUPfC0Gspa5K9yWP8JmRxfvyxUnPKSGyvJeazi4mEkHeyBIXKz38OboCi43xslOz9DSlv1naYtWHBDaGbxprj44bkBIz4uNQBGSrSKU19pjyc7KzI0zijSDagXqTMUVVDqWkJefjC6RbD8WAi5d6kdguKkzWAen3wU9QxPnlJSGBaUk2aPxhffafFdaCM4GtT9KlUFja26R0CTwOzwc8GjSjKhVPUh848R2W9' FROM DUAL ONION ALL SELECT '17' , '1' , '1' , 'BIafFFyLsy0J' , 'OE' , 'JAMIE 32' , 'BFVRJmhmjuWVy' , 'k1OU6fa3dU0YlLpVRPsL' , 'RrkryfXyDVZh7Z' , 'rN' , '699611111' , '2450903023267766' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'GC' , '50000.00' , '0.3600' , '-10.00' , '10.00' , '1' , '0' , 'Gs6WGvwr5S0tNQBsTKAIbow5stnevfKlATK4JIUwJfVM2hkVJnms5A6mqU3GOChkrtNbrHj3qWonFh9xpsGmqarb4L58U2uyuaBti8fzjzJNaKO3fCdCPBC5aIJzWTfepMWFIojUW1pIxyHe2TE7yldYdL3ZEuOemBdHr6F766JXF9VVWWwwjx2ZbXkMWS9f1QcJu7AiSQZTe2VJk0UyQerUsQcPgfR1Z0IGfYfyLrdOXOWIpQoCKpAlDxvMydAhSfxXGF7NkX17oQXuOQWzzMur6OOLZcUaj5i5AKPgKwmRt2dkkCXc721oaQd5uJgSoy5QZPhbF2mdJszExgjOPLjs1fiz7vpZvuDkeB01dYGdtettJlO7476oymGJVVG5vCC6jOnNVPxGKnc7KYAoacu6tRhpkDHSYnfHGN1NFgNBkSTXZkOdWa8h461vAU9sd2ppjQaoFijkGQjEi8rCAw1dZlS673YY9RRwm8amu0' FROM DUAL ONION ALL SELECT '18' , '1' , '1' , 'XwVhWChT4IoVi0v' , 'OE' , 'JAMIE 32' , 'KdFUMTLgwP75Br' , 'whvauesLLce' , '6tLMB4JX66vE4' , 'bX' , '688411111' , '3066490385028404' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'GC' , '50000.00' , '0.2400' , '-10.00' , '10.00' , '1' , '0' , '6UaoGqTlQy6dghP2puMPwSfAm97jz4UyMxD9FTDetXPGhM0fKAuL4ki1lkVz5oS5Kvj83xCByNy2MGeguTYiQiHifbxSVsfG4A71f12LgFpWBzVEBBylcYZbfpiV1XQyzXqNjJpEfkX1O2Felahx2Pem4ukT0oQ5lgRBoytsOtfy7CZhf3sgkz7QCvuQJkOzViECc4uKVGjwTaoQBNDq2c7yIiDlkTBokczwJ9z30nTTCZtDsmgpvocMTQSG2SccqhYoYeh6vAphf41k0mspoTuBcLsz9HAzzs4U1pZuiMHkbqPMLkqxKyrCid6QzRqSTMBU9YeLnW3vTvE6EwYEq6VZfxUvXJxo178fa6IjlDVY4mDiIlvPd9YPcO2sUkA9UgPtvovmwDmk2S' FROM DUAL ONION ALL SELECT '19' , '1' , '1' , 'pbVTUJJ17' , 'OE' , 'JAMIE 32' , 'xBtvtdOLUwq' , '5hcqnvVCz2GE2Px7tSJw' , 'mXEmGh5p60ldqEmAq' , 'Hf' , '894711111' , '4092852185655237' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'BC' , '50000.00' , '0.2900' , '3720.00' , '10.00' , '1' , '0' , '9 1 1 1 1 3,730.002019-11-04hOxeLh I0g70QcgZzjAya8S09GPGCnKojjoZopo6OgVYc9DXoh7hU6MGtXAlUmFP4TyTJFDtIqSRMkctyeRoxN861hBg915r9Avn9oYxOAW7TZqoLB7ZmlN1WUHJ21VfokYlaAfwST6uPrzrQLfKJpvNiKHuYZ1FROi8E5cnX8bFQWCm5GHNxkaePjqOoEHataG0Nb9ZY7UCKFcjxzuuMi2xrnEaaq9Y8pCZFsTtAHor3SrAnqFuduk5q3wGR0qZ0pywCeJoGVk8bULI8dsH0q39EQ7CKR2XTFGoYGUHirZhsH776NsP7QSb7bVnjhzIvKGWNIvQTeVxJUDknW6KKpy05qWLrXVd98jxWImodCW7uDJpBnGVk3R8dorUBBEBSnejubvQKHhTxq6BFi4RgKUeYrORLgn1wCiwG5f' FROM DUAL ONION ALL SELECT '20' , '1' , '1' , 'waEz5i5uDbmjiZ' , 'OE' , 'JAMIE 32' , 'gTHsYIP7Yel' , 'DltOIKCnAIZ70Lct5drO' , 'jDFeY5LzC4ylYDObHs8' , 'JK' , '484711111' , '1347174919698951' , TO_TIMESTAMP( '2019-07-12 14:16:53' , 'YYYY-MM-DD HH24:MI:SS' ), 'GC' , '50000.00' , '0.0100' , '-10.00' , '10.00' , '1' , '0' , 'W6xny7pn3rlZ3AGYNYEpvwAaW5G5Cpl8No9QsYrDmLzTgD1uMAUV2nmR4q73b8RIDi5YydnJkzmbyUTbkG42QaQqKAcAIcrfJRv0RSjvtv5i6ORSGFlW8FQTKbeGzg0uXqy9lW2eRtNp5ppW7UaEvhcQlZU2rDAPnvDHA9aMBtv1MtrKj6eOJamLpHVGLq1g9wri1HV932bEDcvAqXZvPBBcBw5hnvE4Vr7RTdObVjCD9qgLAuobLQwrtTwrlGnQskRgrnw1TpfHAU8WZpFCpQLY3Y5bDddtY76lrUZ4g74XEqY1lxPciUrUAA6B0q68QM1LGfoI3c942mkEc0z4QUVnOrYwkAqDhk088jQrmOy' FROM DUAL ; ) ) This results in 10 rows in the DML trace like this  2021-08-09 11:05:34 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('11','1','1','YPMEqJQ5IEP','OE','JAMIE 99','wa0VoV7bqHSzD','KnccHddq9hQOIJ0C9','Dmj3vz6HARRt1FfLOm9w','8J','599511111','9649048615610128',TO_TIMESTAMP('2019-07-12 14:16:53.123456'),'GC','50000','.01','-10','10','1','0','2uugupWLaZRZBlBxWvPiaiR0HaNotpnmysPu02MO9SLNYFsmlU52vEYKOVDtZVSJEgwpyyGv1GXbu1GYBkLpcVYGBBKELe8LDn4JlTELYgxSSSLw6fTlu9O7RY2XP940DdcOPcQRJNXBnnKUl2EK2AZn3dlhW04ki6Q55qkTYbQu35rE183RR4ObRlmB182LcPe0AP8eUECiPaXfprPUTBVcLb1yZK0GEVop3WEEMVG27k2epsRNpHt5iDOqo59yRrh04xt4mk9cKRemSYkKzihcxbZQaWpZiTtb9GZGHBKlNyCrod9HRq7Vsu6X7g1Avq1VKmkZEHbUYV1S9iFr16DgDy8UFPiRqq4lq5rFcDiPUIw0zuYdSnekMBNOWqJA'); 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAB, rollbackFlag=0 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('12','1','1','abjLiHVtX7','OE','JAMIE 32','m8GZI5UurI7pbQn','Kc4X1KYH2e7r','24vhA7CNiPVS4eO','MW','470211111','3097542740098740',TO_TIMESTAMP('2019-07-12 14:16:53.'),'GC','50000','.42','1025','10','1','0','3cdfoAy1wdl8AjZhWuM6JsgJ1BLLkCd75VPjgnkO8IzbfUFs9tKcn0lhuUmlZavaQXyvOBReHJriG0kwRKoAJCXz7j3ypEao4Ukpt7vuzyvdHTl1CiMTr5Hp5yTdnbPv19zVowA09NhU8ZRm7LmXBthjm880NHcPSXXTcD6qN84wVLaDkjtI5oHqDaxwjAFDOA15ucC0XDiuH8U6U8whulQraAPMXOziCFC8k9xKyIoRO1wI437qTKdwuFoK9TqSAsHdp0xxRaa9wHnS6xRUkF6o7NtToaojOFT5hP31fsZTnMrGv1fwsMKZ2KfLFTg7fHG9mxhiBI17QqHAdSfUmcMqctJHOEa834dw5LNQkBEnh5s6DzISaJJazbMwzqIXfgjQD6oMopKeIBxccf1S2utAHqmawTGf79jzVcHb6z'); 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAC, rollbackFlag=0 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('13','1','1','zUopfB4OpFQVj54t','OE','JAMIE 32','8oq3O01Uc5o7HQCjO','CMfV4MJvVKastzjDcc','Jlfj9uZ2NgN','L5','929911111','3706237873872500',TO_TIMESTAMP('2019-07-12 14:16:53.'),'GC','50000','.44','-10','10','1','0','V5FFBJvCzs82Ft9Tc8TNUfty195nLEmr2YtxbLer7ZSpUJHpVpIHwpjV4txsJpOtALGVzuC7AhTtVvQuLp0dHvXFz2wSqf3IzAmaS0BI8J6afvZpLXKGzjueUOHRiRdDokoC3OZgmdqdkpYYnbGZfJJnA6RAp4ZQFNFdXWDnCM1yPbIjBQWxo3eg9kJCwFCM20VtuPvGnGP5EtlfNlnCxSkcf2d45xxYnHMUsngz6cAW946FZZR0UINWX0d6SSan1ntpFFIRIm1RKNuBH4lYiB3sCI0SW4Cj8wxiDij4xwZGWvomTnleF8yES4t3IIjhhnoKHziQD9rG6HGuAPjtbtcHDBkyjT8wVshbKt1ATgIWPjgd4pt1KSWodPyyXqLNTN7CRBdIizWaVS24WOqLSf2ik3UkZuK6MrDnB9Y7ALuIHDWaTAuuJUAWjXpQmar'); 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAD, rollbackFlag=0 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('14','1','1','CsPuJqvoI1J','OE','JAMIE 32','c27rmEkoVqJYZ71Ggo','0l3I3FMHcuC1NqB','S6CPNjNydqcNednml','hc','611311111','5505005826338725',TO_TIMESTAMP('2019-07-12 14:16:53.'),'GC','50000','.38','-10','10','1','0','1qPxmch1cIN5tXnLD9sNlIB9Fkv7vRJdA7kVvDnCZRylJrNF8T6btvtcp0TFtd4jqmbKbbvLwLVn67oXUftpPb5CwykpkcLY5vpb7ldI1tgVFdSo0QIZ41HnO7ZqKjdC3HdHQKhjISr2qnzRQxo70TkEA7WuowteMMuXTKeGmBtpTiLW0MCEis5SxkdZb3RQ0PoXE0OjseU4x6VVZ05FscxBGYZYWr8MBhvfvX3jqj7WSUK7R4L05rspnDb5SgcNkZOL6ctu7jtZb2PT9KyWpbJtlJ9GrkXmVHBYicBRl1di0AycQDhNtuxXjAxkHgJZpD1QZzFIIO'); 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAE, rollbackFlag=0 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('15','1','1','AEW2DG6sX7e','OE','JAMIE 32','AxXqoHD5toGJuKj','SiyQapU9kf','fse4IfX9UvKnr8fhFyQ','qX','497911111','2495984918559300',TO_TIMESTAMP('2019-07-12 14:16:53.'),'BC','50000','.17','-10','10','1','0','fRdmoMKxIKQQRdqV50tM2Who9xj9hLKHg7qeywVgFAUAJT7kKaKhGFPGsqvf5r0DZSwg1pEYxzTROUcE0Q6kQKyLlc6Ls3bZh27B0ZYFscr4RbqDrdNTFd9C90QmIpzXpf39AMn47vdG7sUAMk9kzkIu0LeSisDbWyOxJZaMiljaPADLQgIVpGswWJemCHxCHLCjmsJAG8DLEkqxwshCVvFAaBBlNQPLYOTdzetUEBjW9P0Ks8tLFtvbKvhbYbRitRGE0vMA3VxorVvDcXEj5mt7gND7VsVPbl6mQyeEarX74cEqWe33IHfh5TiaEluBGOKGdLnOzzfbAyStNYUEqc70QH8n9DZ78pXLoduwQIHibO0FHyg3Bx1gz6LbasPsK2g2fzPw05CYaiXedj89OFlRwqlcszv6pRUAVctXLw7gF9uQm130N4C09ArN4EbECaCPhEf8w5U'); 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAF, rollbackFlag=0 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:240 - DML, transactionId=0500140016040000, SCN=9669099, table_name=CUSTOMER2, segOwner=CDCTEST, operationCode=1, offsetSCN=9667176, commitOffsetSCN=null, sql insert into "CDCTEST"."CUSTOMER2"("C_ID","C_D_ID","C_W_ID","C_FIRST","C_MIDDLE","C_LAST","C_STREET_1","C_STREET_2","C_CITY","C_STATE","C_ZIP","C_PHONE","C_SINCE","C_CREDIT","C_CREDIT_LIM","C_DISCOUNT","C_BALANCE","C_YTD_PAYMENT","C_PAYMENT_CNT","C_DELIVERY_CNT","C_DATA") values ('16','1','1','ulBbR8TU7iQb99u','OE','JAMIE 32','R1Wflx5UA1oyENPab','j6hkkcwXdMqxIdvrJFe3','eIAGQlVXzQX8uUF','g8','250111111','3373213736026669',TO_TIMESTAMP('2019-07-12 14:16:53.'),'BC','50000','.38','-10','10','1','0','lUYWb2E2heTBCTOXbBTWlRjKWRjO3zHtB2eOXj5wUHIkbwiuWU9uPpjzqLBV71PcyNtINZlXHRM44xrHft8moxlTmNksSAPhAMOZ0lUPfC0Gspa5K9yWP8JmRxfvyxUnPKSGyvJeazi4mEkHeyBIXKz38OboCi43xslOz9DSlv1naYtWHBDaGbxprj44bkBIz4uNQBGSrSKU19pjyc7KzI0zijSDagXqTMUVVDqWkJefjC6RbD8WAi5d6kdguKkzWAen3wU9QxPnlJSGBaUk2aPxhffafFdaCM4GtT9KlUFja26R0CTwOzwc8GjSjKhVPUh848R2W9'); 2021-08-09 11:06:43 TRACE debezium-oracleconnector-debezium-change-event-source-coordinator LogMinerQueryResultProcessor:123 - scn=9669099, operationCode=1, operation=INSERT, table=CUSTOMER2, segOwner=CDCTEST, userName=CDCTEST, rowId=AAASMHAAMAAAAGzAAG, rollbackFlag=0  Its evident from the trace that 256 chars is not sufficient to disambiguate the rows and it appears all other values are the same. String ROW_HASH = "ORA_HASH(SCN||OPERATION||RS_ID||SEQUENCE#||RTRIM(SUBSTR(SQL_REDO,1,256)))" ; I am probably not qualified to suggest a fix here but I wondered if the developer didn't expect the SubString to be relied upon and it's there just in case.   Looks like the change was introduced here:- https://github.com/debezium/debezium/pull/2347/files#diff-368116a398e866498f9047ace72eac4d98dc2dcce35780f245e642cf5eda6626

    Description

      The oracle log miner uses a row hash

      1.6.1.Final -> LogMinerQueryBuilder:26

      This fails to differentiate between rows in quite limited and simple DML operations resulting in rows being missed.

      Attachments

        Issue Links

          Activity

            People

              ccranfor@redhat.com Chris Cranford
              ed.thompson Ed Thompson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: