-
Notifications
You must be signed in to change notification settings - Fork 4.1k
Jira to Potgresql Migration #46376
Replies: 1 comment · 1 reply
-
Hey! Can you share some of your jobs's logs? |
Beta Was this translation helpful? Give feedback.
All reactions
-
Hello , Sure, here are few parts of logs as logs file is around 5 to 6 MB.
`2024-10-04 10:15:53 �[43mdestination�[0m > ERROR type-and-dedupe i.a.c.i.d.j.t.JdbcDestinationHandler(execute):171 Sql c8b16993-3b05-49fa-a5ef-a96c9146e20c-fefb3f55-af9a-4dd1-9c03-f39da9ff40c3 failed org.postgresql.util.PSQLException: ERROR: relation "public.issue_link_types_airbyte_tmp" does not exist Stack Trace: org.postgresql.util.PSQLException: ERROR: relation "public.issue_link_types_airbyte_tmp" does not exist 2024-10-04 10:15:53 �[43mdestination�[0m > ERROR type-and-dedupe i.a.i.b.d.t.DefaultTyperDeduper(typeAndDedupeTask$lambda$5):269 Exception occurred while typing and deduping stream issue_link_types org.postgresql.util.PSQLException: ERROR: relation "public.issue_link_types_airbyte_tmp" does not exist Stack Trace: org.postgresql.util.PSQLException: ERROR: relation "public.issue_link_types_airbyte_tmp" does not exist 2024-10-04 10:15:53 �[43mdestination�[0m > ERROR type-and-dedupe i.a.c.i.d.j.t.JdbcDestinationHandler(execute):171 Sql cc74f4aa-50a4-45b1-8b97-d5c6391cf450-73eccc4c-d69e-4313-b99c-5090762ecc7f failed org.postgresql.util.PSQLException: ERROR: relation "public.issue_types_airbyte_tmp" does not exist Stack Trace: org.postgresql.util.PSQLException: ERROR: relation "public.issue_types_airbyte_tmp" does not exist 2024-10-04 10:15:53 �[43mdestination�[0m > ERROR type-and-dedupe i.a.i.b.d.t.DefaultTyperDeduper(typeAndDedupeTask$lambda$5):269 Exception occurred while typing and deduping stream issue_types org.postgresql.util.PSQLException: ERROR: relation "public.issue_types_airbyte_tmp" does not exist Stack Trace: org.postgresql.util.PSQLException: ERROR: relation "public.issue_types_airbyte_tmp" does not exist 2024-10-04 10:15:53 �[43mdestination�[0m > ERROR type-and-dedupe i.a.c.i.d.j.t.JdbcDestinationHandler(execute):171 Sql 9060c9e8-d3df-407d-a4a8-24f29ef3acf4-e6f66b0c-3eaf-4352-b392-ab5931d6f134 failed org.postgresql.util.PSQLException: ERROR: relation "public.workflow_schemes_airbyte_tmp" does not exist Stack Trace: org.postgresql.util.PSQLException: ERROR: relation "public.workflow_schemes_airbyte_tmp" does not exist 2024-10-04 10:15:53 �[43mdestination�[0m > ERROR type-and-dedupe i.a.i.b.d.t.DefaultTyperDeduper(typeAndDedupeTask$lambda$5):269 Exception occurred while typing and deduping stream workflow_schemes org.postgresql.util.PSQLException: ERROR: relation "public.workflow_schemes_airbyte_tmp" does not exist Stack Trace: org.postgresql.util.PSQLException: ERROR: relation "public.workflow_schemes_airbyte_tmp" does not exist 2024-10-04 10:15:53 �[43mdestination�[0m > ERROR main i.a.c.i.u.ConnectorExceptionUtil(logAllAndThrowFirst):115 The Following Exceptions were thrown while typing and deduping tables: org.postgresql.util.PSQLException: ERROR: relation "public.projects_airbyte_tmp" does not exist org.postgresql.util.PSQLException: ERROR: relation "public.issue_field_configurations_airbyte_tmp" does not exist org.postgresql.util.PSQLException: ERROR: relation "public.permissions_airbyte_tmp" does not exist org.postgresql.util.PSQLException: ERROR: relation "public.issue_notification_schemes_airbyte_tmp" does not exist org.postgresql.util.PSQLException: ERROR: relation "public.workflow_statuses_airbyte_tmp" does not exist org.postgresql.util.PSQLException: ERROR: relation "public.issue_transitions_airbyte_tmp" does not exist org.postgresql.util.PSQLException: ERROR: relation "public.screen_tabs_airbyte_tmp" does not exist Stack Trace: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: relation "public.issue_priorities_airbyte_tmp" does not exist 2024-10-04 10:15:53 �[46mplatform�[0m > readFromDestination: exception caught Hope this can help to find out issues. |
Beta Was this translation helpful? Give feedback.
-
Hi Team,
I am using Airbyte First time and am trying to load data from Jira to Postgresql. For me both source and destination connection is done successfully but as many time I run Sync it's always giving different number of records and always it's get failed and some table remain empty. (Note: I am every time dropping all table and re-creating for testing.) but it always gets failed and with different number of records.
I am not changing any settings I am running it as it is. And even it's taking around 15-20 mins (which is too much) for one sync with overall 4000 records including all tables. Could someone please help that how to resolve this issue and it get successfully synced?
Please help what should we do for it?
Beta Was this translation helpful? Give feedback.
All reactions