Internal Database Column Order and JDBC Index Issue After Airbyte Upgrade

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

After an Airbyte upgrade, encountering an internal server error related to SQL query, column order, and JDBC index issue when accessing the database.


Question

I have got quite a serious issue where my internal database after an airbyte upgrade is column about column order and a JDBC index issue. Is there anyone who can please please help

{
  "i18nKey": "errors.http.internalServerError",
  "i18nParams": {
    "status": 500
  },
  "name": "HttpError",
  "requestId": "kjpogfWd9HKe4N9fx9YSmT",
  "request": {
    "url": "/api/v1/web_backend/connections/list",
    "method": "post",
    "headers": {
      "Content-Type": "application/json"
    },
    "data": {
      "workspaceId": "ff7f9b10-d309-4314-84e6-d265cdb37932"
    }
  },
  "status": 500,
  "response": {
    "message": "Internal Server Error: SQL [select \"public\".\"actor\".*, \"public\".\"actor_definition\".* from \"public\".\"actor\" join \"public\".\"actor_definition\" on \"public\".\"actor\".\"actor_definition_id\" = \"public\".\"actor_definition\".\"id\" where (\"public\".\"actor\".\"actor_type\" = cast(? as \"public\".\"actor_type\") and \"public\".\"actor\".\"id\" in (cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as uuid)))]; Error while reading field: \"public\".\"actor_definition\".\"created_at\", at JDBC index: 15",
    "exceptionClassName": "org.jooq.exception.DataAccessException",```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1723993770054189) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["internal-database", "column-order", "jdbc-index", "airbyte-upgrade", "internal-server-error"]
</sub>