I am using airbyte for mysql binlog incremental da...
# ask-community-for-troubleshootingr
Rahul Vishnoi
07/27/2021, 6:29 AMI am using airbyte for mysql binlog incremental data and facing issue (Exception in thread "main" tech.allegro.schema.json2avro.converter.AvroConversionException: Failed to convert JSON to Avro:) could anyone help me on this.
c
Chris (deprecated profile)
07/27/2021, 9:48 AM
Can you refer to this thread and share your catalog.json?
https://airbytehq.slack.com/archives/C019WEENQRM/p1627316883251000?thread_ts=1627245078.241300&cid=C019WEENQRM
r
Rahul Vishnoi
07/29/2021, 4:03 AM Copy code
{
"streams": [
{
"stream": {
"name": "fin_b2c_invoices",
"json_schema": {
"type": "object",
"properties": {
"status": {
"type": "number"
},
"currency": {
"type": "string"
},
"client_id": {
"type": "string"
},
"is_active": {
"type": "boolean"
},
"created_on": {
"type": "string"
},
"invoice_id": {
"type": "number"
},
"payment_mode": {
"type": "string"
},
"billing_cycle": {
"type": "string"
},
"pickup_country": {
"type": "string"
},
"consignee_country": {
"type": "string"
},
"invoice_display_id": {
"type": "string"
}
}
},
"supported_sync_modes": [
"full_refresh",
"incremental"
],
"default_cursor_field": [],
"source_defined_primary_key": [
[
"invoice_id"
]
],
"namespace": "janio_finance"
},
"sync_mode": "full_refresh",
"cursor_field": [],
"destination_sync_mode": "overwrite",
"primary_key": [
[
"invoice_id"
]
]
}
]
}c
Chris (deprecated profile)
07/29/2021, 8:38 AM
cc @Liren Tu
l
Liren Tu
07/29/2021, 6:01 PM
@Rahul Vishnoi, could you provide more detailed logs?
The catalog looks fine. My guess is that there may be extra fields that are not defined in the catalog, and we currently don’t support extra fields:
https://github.com/airbytehq/airbyte/issues/4608
6 Views