Skip to content

Error: failure to invoke API when deploying a connection with s3 and google sheets #205

@rmaxu

Description

@rmaxu

I have this error when deploying changes to the a connection in airbyte cloud:

unknown status code returned: Status 500
{"status":500,"type":"https://reference.airbyte.com/reference/errors","title":"unexpected-problem","detail":"An
unexpected problem has occurred. If this is an error that needs to be
addressed, please submit a pull request or github
issue.","documentationUrl":null,"data":{"message":"SQL [SELECT DISTINCT\n
c.namespace_definition,\n    c.namespace_format,\n    c.prefix,\n
stream_element->'stream'->>'name' AS stream_name,\n
stream_element->'stream'->>'namespace' AS stream_namespace,\n
array_agg(c.id) AS connection_ids\nFROM connection c,\nLATERAL
jsonb_array_elements(c.catalog->'streams') AS stream_element\nWHERE
c.destination_id = ?\nAND c.status = cast(? as \"public\".\"status_type\")\n
AND c.id != ?GROUP BY\n    c.namespace_definition,\n    c.namespace_format,\n
c.prefix,\n    stream_element->'stream'->>'name',\n
stream_element->'stream'->>'namespace'\n]; ERROR: trailing junk after
parameter at or near \"$3GROUP\"\n  Position: 418"}}

This started today, previously the connection was working and being deployed normally. The connection was made with AWS S3 as source and Google Sheets as destination.
The error came out with both provider version 0.9.0 and 0.13.0.

Making some investigation found that some changes were made in the airbyte-platform repository that matches the error message.
I created the PR for a possible fix: airbytehq/airbyte-platform#417

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions