Octavia Squidington III
06/19/2023, 7:45 PMMatheus Barbosa
06/19/2023, 9:13 PM20:17:09.821209 [error] [MainThread]: Database Error in model AW_campaigns_scd (models/generated/airbyte_incremental/scd/metrito_airbyte/AW_campaigns_scd.sql)
20:17:09.821596 [error] [MainThread]: :HTTPDriver for <https://rtswk5h81k.us-east-2.aws.clickhouse.cloud:8443> returned response code 500)
20:17:09.821870 [error] [MainThread]: Code: 190. DB::Exception: Elements 'campaign.excluded_parent_asset_field_types' and 'campaign.targeting_s__g.target_restrictions' of Nested data structure 'campaign' (Array columns) have different array sizes. (SIZES_OF_ARRAYS_DONT_MATCH) (
20:17:09.822422 [error] [MainThread]: Database Error in model AW_display_topics_performance_report (models/generated/airbyte_tables/metrito_airbyte/AW_display_topics_performance_report.sql)
20:17:09.822815 [error] [MainThread]: :HTTPDriver for <https://rtswk5h81k.us-east-2.aws.clickhouse.cloud:8443> returned response code 500)
20:17:09.823084 [error] [MainThread]: Code: 190. DB::Exception: Elements 'ad_group_criterion.final_urls' and 'ad_group_criterion.topic.path' of Nested data structure 'ad_group_criterion' (Array columns) have different array sizes. (SIZES_OF_ARRAYS_DONT_MATCH) (version 23.5.1.34
20:17:09.823501 [error] [MainThread]: compiled Code at ../build/run/airbyte_utils/models/generated/airbyte_tables/metrito_airbyte/AW_display_topics_performance_report.sql,retryable=<null>,timestamp=1686946637696,additionalProperties={}]],additionalProperties={}]
These are part our logsnanggardev
06/20/2023, 3:27 AMLenin Mishra
06/20/2023, 6:42 AMFile "/root/.pyenv/versions/3.9.11/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/requests_native_auth/abstract_oauth.py", line 33, in get_auth_header
return {"Authorization": f"Bearer {self.get_access_token()}"}
File "/root/.pyenv/versions/3.9.11/lib/python3.9/site-packages/airbyte_cdk/sources/streams/http/requests_native_auth/abstract_oauth.py", line 38, in get_access_token
token, expires_in = self.refresh_access_token()
File "/root/.pyenv/versions/3.9.11/lib/python3.9/site-packages/airbyte_cdk/sources/declarative/auth/oauth.py", line 116, in refresh_access_token
return response_json[self.get_access_token_name()], response_json[self.get_expires_in_name()]
KeyError: 'access_token'
Now, when I run the above query in Postman I get all my results. Seems like something is going wrong with generation of new access token. For some reason, the token_refresh_endpoint is not returning a json with the access_token key.
can someone help me with it?Nikolai Nergård
06/20/2023, 8:58 AMupstream request timeout
with a 504 status. The endpoint failing is /api/v1/source_definitions/update
.
The weird thing is, if I wait about 1 minute and click again, it works. However it fails the first time for every connector with the same response. I also get this response from the /api/v1/scheduler/sources/check_connection
endpoint.Sebastien HO
06/20/2023, 10:15 AMHiroto Yamakawa
06/20/2023, 11:04 AM_AIRBYTE_ROW_TABLE
itself.
I've deleted, created the source and connection from zero in production, reseted everything. Still, I miss like 5 rows out of 55k rows. But cannot tell why.Octavia Squidington III
06/20/2023, 1:45 PMBryce Arden
06/20/2023, 2:30 PMAman Kesharwani
06/20/2023, 3:27 PMSrikanth Sudhindra
06/20/2023, 6:12 PM2023-06-20 18:03:55 ERROR o.f.c.i.l.s.Slf4jLog(error):57 - Migration of schema "public" to version "0.50.1.001 - NotificationSettingsBackfill" failed! Changes successfully rolled back.
2023-06-20 18:03:55 ERROR i.a.b.Application(main):25 - Unable to bootstrap Airbyte environment.
Anyone encountered this ?james truty
06/20/2023, 8:31 PMMadison Mae
06/20/2023, 8:37 PMRyan Roline
06/20/2023, 9:33 PMAkilesh V
06/21/2023, 6:47 AMtext
field in the body?Ignacio Valdelvira
06/21/2023, 10:34 AMpostgres
from 1.0.45 to 2.0.34 and got the error java.lang.IllegalStateException: Get Spec job failed
When running docker run --rm airbyte/source-postgres:2.0.34 check
check I get the following:
{
"type": "LOG",
"log": {
"level": "ERROR",
"message": "ERROR i.a.i.b.AirbyteExceptionHandler(uncaughtException):26 Something went wrong in the connector. See the logs for more details. java.lang.IllegalArgumentException: org.apache.commons.cli.MissingArgumentException: Missing argument for option: config\n\tat io.airbyte.commons.cli.Clis.parse(Clis.java:34) ~[io.airbyte-airbyte-commons-cli-20.10.23.jar:?]\n\tat io.airbyte.commons.cli.Clis.parse(Clis.java:39) ~[io.airbyte-airbyte-commons-cli-20.10.23.jar:?]\n\tat io.airbyte.integrations.base.IntegrationCliParser.parseOptions(IntegrationCliParser.java:120) ~[io.airbyte.airbyte-integrations.bases-base-java-20.10.23.jar:?]\n\tat io.airbyte.integrations.base.IntegrationCliParser.parse(IntegrationCliParser.java:61) ~[io.airbyte.airbyte-integrations.bases-base-java-20.10.23.jar:?]\n\tat io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:99) ~[io.airbyte.airbyte-integrations.bases-base-java-20.10.23.jar:?]\n\tat io.airbyte.integrations.destination.bigquery.BigQueryDestination.main(BigQueryDestination.java:380) ~[io.airbyte.airbyte-integrations.connectors-destination-bigquery-20.10.23.jar:?]\nCaused by: org.apache.commons.cli.MissingArgumentException: Missing argument for option: config\n\tat org.apache.commons.cli.DefaultParser.checkRequiredArgs(DefaultParser.java:211) ~[commons-cli-1.4.jar:1.4]\n\tat org.apache.commons.cli.DefaultParser.parse(DefaultParser.java:125) ~[commons-cli-1.4.jar:1.4]\n\tat org.apache.commons.cli.DefaultParser.parse(DefaultParser.java:76) ~[commons-cli-1.4.jar:1.4]\n\tat org.apache.commons.cli.DefaultParser.parse(DefaultParser.java:60) ~[commons-cli-1.4.jar:1.4]\n\tat io.airbyte.commons.cli.Clis.parse(Clis.java:29) ~[io.airbyte-airbyte-commons-cli-20.10.23.jar:?]\n\t... 5 more\n",
"stack_trace": "java.lang.IllegalArgumentException: org.apache.commons.cli.MissingArgumentException: Missing argument for option: config\n\tat io.airbyte.commons.cli.Clis.parse(Clis.java:34)\n\tat io.airbyte.commons.cli.Clis.parse(Clis.java:39)\n\tat io.airbyte.integrations.base.IntegrationCliParser.parseOptions(IntegrationCliParser.java:120)\n\tat io.airbyte.integrations.base.IntegrationCliParser.parse(IntegrationCliParser.java:61)\n\tat io.airbyte.integrations.base.IntegrationRunner.run(IntegrationRunner.java:99)\n\tat io.airbyte.integrations.destination.bigquery.BigQueryDestination.main(BigQueryDestination.java:380)\nCaused by: org.apache.commons.cli.MissingArgumentException: Missing argument for option: config\n\tat org.apache.commons.cli.DefaultParser.checkRequiredArgs(DefaultParser.java:211)\n\tat org.apache.commons.cli.DefaultParser.parse(DefaultParser.java:125)\n\tat org.apache.commons.cli.DefaultParser.parse(DefaultParser.java:76)\n\tat org.apache.commons.cli.DefaultParser.parse(DefaultParser.java:60)\n\tat io.airbyte.commons.cli.Clis.parse(Clis.java:29)\n\t... 5 more\n"
}
}
My Airbyte version is 0.42.1. Any ideas what could be the issue here or what should I try?Haim Beyhan
06/21/2023, 11:40 AMaidan
06/21/2023, 11:47 AMsrivani karade
06/21/2023, 11:47 AMOhad Feiner
06/21/2023, 12:09 PMIvan Sinitsyn
06/21/2023, 12:20 PMJohn Wessel
06/21/2023, 12:44 PMcom.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'EXISTS'
Haim Beyhan
06/21/2023, 12:47 PMLuis Felipe Oliveira
06/21/2023, 1:47 PMJonathan Linford
06/21/2023, 2:45 PMairbyte/source-postgres:2.0.30
-> airbyte/source-postgres:2.0.34
. And now the connection test fails. Same with destination connector snowflake airbyte/destination-snowflake:1.0.4
-> airbyte/destination-snowflake:1.0.5
Jesus Rivero
06/21/2023, 2:47 PMGabriel Levine
06/21/2023, 3:21 PMJoel
06/21/2023, 7:44 PMOctavia Squidington III
06/21/2023, 7:45 PMChidambara Ganapathy
06/22/2023, 6:56 AM