Connecting Shopify connector to Postgres: Database Error in model abandoned_checkouts_customer

[SofianeDjellouli]

Hi,

I ran the Airbyte dashboard by cloning the repo and running docker-compose up.

I'm trying to establish a sync a Shopify connector to a Postgres DB locally. After around 10 hours of sync, I got an error stopping the process (see the logs below). It went into another attempt but with the same result. I then cancelled the process.

However, when I look at the DB, I see some data in it, which is probably incomplete.

End of the logs:

2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.104722 (MainThread): 12:45:31 | 
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.104971 (MainThread): 12:45:31 | Finished running 220 incremental models in 113.21s.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.105182 (MainThread): Connection 'master' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.105394 (MainThread): Connection 'model.airbyte_utils.orders_refunds_refund_da3_presentment_money' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.105546 (MainThread): Connection 'model.airbyte_utils.orders_refunds_refun__amount_set_shop_money' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.105750 (MainThread): Connection 'model.airbyte_utils.orders_refunds_refund_15a_presentment_money' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.105898 (MainThread): Connection 'model.airbyte_utils.orders_refunds_refund_line_i_d02_shop_money' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.106035 (MainThread): Connection 'model.airbyte_utils.orders_fulfillments_line_ite_e79_shop_money' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.106172 (MainThread): Connection 'model.airbyte_utils.orders_fulfillments_l_f44_presentment_money' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.106309 (MainThread): Connection 'model.airbyte_utils.orders_fulfillments_line_ite_e79_shop_money_ab1' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.106445 (MainThread): Connection 'model.airbyte_utils.orders_fulfillments_l_f44_presentment_money_ab3' was properly closed.
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.392717 (MainThread): 
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.393059 (MainThread): Completed with 1 error and 0 warnings:
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.393315 (MainThread): 
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.393564 (MainThread): Database Error in model abandoned_checkouts_customer (models/generated/airbyte_incremental/public/abandoned_checkouts_customer.sql)
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.393800 (MainThread):   invalid input syntax for type boolean: "[]"
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.394006 (MainThread):   compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/public/abandoned_checkouts_customer.sql
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.395068 (MainThread): 
2022-02-15 12:45:37 normalization > Done. PASS=217 WARN=0 ERROR=1 SKIP=2 TOTAL=220
2022-02-15 12:45:37 normalization > 2022-02-15 12:45:31.395493 (MainThread): Flushing usage events

[bazarnov]

Fixed in #10419