Is this your first time deploying Airbyte: no
OS V...
# troubleshootingm
Muhammad Imtiaz
02/21/2022, 10:14 AMIs this your first time deploying Airbyte: no
OS Version / Instance: AWS EC2 t2.large
Deployment: Docker
Airbyte Version: 0.35.4-alpha
Is this your first time deploying Airbyte: no
OS Version / Instance: AWS EC2 t2.large
Deployment: Docker
Airbyte Version: 0.35.4-alpha
Source: postgres 0.4.7
Destination : BigQuery 0.6.8
Description:
Hi,
My Postgres to BigQuery connection is failing since this morning. Attached are the logs, I can't extract any valuable insights from it. Are you able to ?
Note that I upgraded the postgres source from 0.4.6 this morning, could it be the cause of this issue ? If yes, how can I downgrade it ?
Thanks
a
Anatole Callies
02/21/2022, 10:54 AMHey you can go to settings page and you will find destinations. you can update the version to older one and check if it working
Anatole Callies
02/21/2022, 10:55 AMYes, just did it, it's working now
Can you see what went wrong from the logs ?
Anatole Callies
02/21/2022, 11:05 AMLooks like something is wrong with latest version. Do you mind creating an issue and adding all these details there?
Anatole Callies
02/21/2022, 12:24 PM@Harshith (Airbyte), I had upgraded blindly as the latest changes are no longer reported here : https://docs.airbyte.com/integrations/sources/postgres#changelog
Do you know why ?
Anatole Callies
02/21/2022, 1:24 PM@Anatole Callies @Harshith (Airbyte) this error occurs because in the latest version microseconds were added for timestamps, and the string in the cursor is stored as a timestamp without them. this causes an error. If you select a new version and do a data reset, it will help you and the cursor will be saved in the correct format.
s
Sai Sriram
02/21/2022, 1:25 PMHi @Andrii Korotkov [GL],
Thanks for the explanation !
It is a bit disruptive though, isn't it possible to bypass the need for a reset ?
Sai Sriram
02/21/2022, 1:29 PMI'll see what I can do to help you. I'll try to add changes today or tomorrow that will fix this. I will keep you informed.
o
Ofek Katriel
02/21/2022, 1:33 PMThanks @Andrii Korotkov [GL], appreciate your reactivity !
Ofek Katriel
02/21/2022, 5:52 PM@Anatole Callies I created a pull request to fix this error - https://github.com/airbytehq/airbyte/pull/10508. Now I am finishing all the preparatory work so that it can be merged. When I receive an approval from the team members, a new version will be published that will work correctly with your cursor.
u
user
02/22/2022, 8:34 AMThis is great, thanks @Andrii Korotkov [GL]. Do you know why this has ceased being updated with new versions for the past months ? https://docs.airbyte.com/integrations/sources/postgres#changelog
Thanks
u
user
02/22/2022, 9:29 AMThank you for noticing this. We make changes to this document with every new version, but they don't really show up on this page. We will check all connectors and fix it.
n
Nathan Gold
02/22/2022, 10:33 AM@Anatole Callies I have already published a new version for postgres. Please try running the sync and use it. I think everything will go great. Please let me know about the results.
n
Nicholas de Roualle
02/22/2022, 11:02 AMHi,
It works, but note that it is still version 0.4.7 that appears as the latest version, I had to force it to 0.4.8
Nicholas de Roualle
02/22/2022, 11:05 AMYes that's right. Within half an hour, I will merge a pull request and 0.4.8 will appear as the latest version.
5 Views