Error with Connection Page and Sync not Starting After Upgrading Airbyte Version

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

Summary

User is facing an internal server error on the Connection page due to a SQL query issue. Additionally, after upgrading to the latest version, the sync is not starting due to insufficient CPU resources. User is seeking help to fix the configuration issue and determine the stable version to use.


Question

abctl local install --insecure-cookies --chart-version=0.620.2
I have installed above chart version
When i open Connection page ,i am getting below error

  "response": {
    "message": "Internal Server Error: Error executing SQL Query: ERROR: column job_with_attempts_attempts_.temporal_workflow_id does not exist\n Position: 780",
    "exceptionClassName": "io.micronaut.data.exceptions.DataAccessException",
    "exceptionStack": [
      "io.micronaut.data.exceptions.DataAccessException: Error executing SQL Query: ERROR: column job_with_attempts_attempts_.temporal_workflow_id does not exist"```
How to fix above configuration issue and continue sync ??
When i have upgraded to latest version ,Sync is not starting,when i check logs showing insufficient cpu,even 2cpu's and 8GB memory was given

Which version is stable and correct one to use ,please help me???

<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/p1731932598979869) if you want 
to access the original thread.

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

<sub>
["error", "connection-page", "sync", "upgrade", "cpu", "memory", "stable-version"]
</sub>
2

Check this thread https://airbytehq.slack.com/archives/C021JANJ6TY/p1728562294190379?thread_ts=1728561176.853139&amp;cid=C021JANJ6TY
It’s related to synchronizations and memory/cpu limits/requests for jobs

3

Thanks for reply,
in new version ,i have mentioned below configs ,

JOB_MAIN_CONTAINER_CPU_LIMIT=0.5
JOB_MAIN_CONTAINER_MEMORY_REQUEST=500Mi
JOB_MAIN_CONTAINER_MEMORY_LIMIT=800Mi```
Above env's i have added in docker-compose airbyte which was working fine ,but through abctl after adding above configs , i have deleted pods to  reflect new change,but still same insufficient cpu error,
Why 2 minimum cpu and 8gb memory is not sufficient to start sync ??
4

again, read the whole thread I mentioned before, also I recommend installing k9s
https://airbytehq.slack.com/archives/C021JANJ6TY/p1728564710581679?thread_ts=1728561176.853139&amp;cid=C021JANJ6TY

5

when you sum up all the requests I expect that this is more than 2 for CPU, and that’s why pod cannot be scheduled

6

Inside abctl docker container i have to install k9s??

7

I understood i will increase vm size and i will try ,Thank you so much

8

k9s should be installed on host VM level, the same as abctl
https://airbytehq.slack.com/archives/C021JANJ6TY/p1730560758218659?thread_ts=1730472253.783009&amp;cid=C021JANJ6TY

9

Ok i will try thank you

10

I recommend using 1.0.0 or newer.
For limited resources you might try to use --low-resource-mode flag for abctl local install

11

When possible, I recommend abctl local uninstall --persisted and new fresh installation

12

How much CPU and memory do you have on your machine?

13

Standard B2ms (2 vcpus, 8 GiB memory)