Error with SQL Query and Resource Allocation in Airbyte

Slack Knowledge Base Q&A API, Terraform and Other Topics
, , , ,
1

Summary

User encounters a 500 Internal Server Error related to a missing SQL column after installing a specific chart version. Additionally, there are issues with insufficient CPU resources when attempting to sync after an upgrade.


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>
['abctl', 'chart-version', 'sql-error', 'insufficient-cpu', 'sync-issue']
</sub>
2

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

3

Standard B2ms (2 vcpus, 8 GiB memory)

4

Ok i will try thank you

5

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

6

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

7

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

8

Standard B2ms (2 vcpus, 8 GiB memory)

9

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

10

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 ??
11

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

12

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

13

Inside abctl docker container i have to install k9s??

14

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

15

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

16

Ok i will try thank you