airbytehq / airbytehq/airbyte

[source-mongo] Connector stores the `_id` of deleted rows as a raw JSON object

未關閉
#60,903 3 則留言 0 個 reaction 已指派 0 人 在 GitHub 檢視
area/connectors community connectors/source/mongodb-v2 team/db-dw-sources type/bug
主要語言
Python
星號
22.1k
分支
5.4k
平均合併
5 小時
30 天內合併 PR
671

描述

### Connector Name

source-mongo

### Connector Version

1.5.17

### What step the error happened?

During the sync

### Relevant information

During CDC incremental syncs, the connector stores the `_id` of deleted rows as a raw JSON object:
```json
{
"_id": "{\"$binary\": {\"base64\": \"k7N/P5EMF4SZmAGW2Hx4sg==\",\"subType\": \"03\"}}",
"_ab_cdc_updated_at": "2025-05-22T17:19:42Z",
"_ab_cdc_cursor": 174793503000000271,
"_ab_cdc_deleted_at": "2025-05-22T17:19:42Z"
}
```

For rows that aren’t deleted, the `_id` field contains the expected Base64 string:
```json
{
"_id": "9gi3oVVEm42XxgGW9/YrGg==",
"Liked": true,
"Text": null,
"UpdatedAt": {
"DateTime": "2025-05-22T12:27:07.418Z",
"Ticks": 638835136274184098,
"Offset": 0
},
"_ab_cdc_updated_at": "2025-05-22T12:27:07Z",
"_ab_cdc_cursor": 174791722900000287,
"_ab_cdc_deleted_at": null
}
```

These examples come from destination-mssql v1.0.2, because I encountered issues with newest version of connector due to this behavior.

### Relevant log output

```shell

```

### Contribute

- [ ] Yes, I want to contribute

貢獻指南

開啟貢獻指南

評估

這個 Issue 還沒有評估資料。

把新 issue 寄到你的電子郵件信箱

精選適合新手參與的 GitHub issue 摘要。