Tatiane Corrêa da Costa e Silva
07/18/2024, 12:42 PM(21, 'persistence error: exception 70029020: ltt::exception caught while operating on DISK_NCLOB:3:1090948412471\nexception 1000002: Allocation failed ; $size$=262144; $name$=Page; $type$=pool; $inuse_count$=50341; $allocated_size$=849608704\n: at function __trex_field_HybridNCLob__()')
kapa.ai
07/18/2024, 12:42 PMTatiane Corrêa da Costa e Silva
07/18/2024, 12:43 PMkapa.ai
07/18/2024, 12:43 PMTatiane Corrêa da Costa e Silva
07/18/2024, 12:51 PMkapa.ai
07/18/2024, 12:51 PMkapa.ai
07/18/2024, 12:51 PMTatiane Corrêa da Costa e Silva
07/18/2024, 2:07 PMkapa.ai
07/18/2024, 2:07 PMkapa.ai
07/18/2024, 2:08 PMcpuRequest
and cpuLimit
values you're seeing in the log are the minimum and maximum CPU resources that are allocated for the connection. In the knowledge sources, there are a few instances where CPU allocation is discussed: 1. In a GitHub issue, the Airbyte team discussed provisioning a runner with 32 CPUs to assess if giving more CPU to Java connector tests would make them faster [[source]](https://github.com/airbytehq/airbyte/issues/31443). 2. In a forum post, a user suggested increasing the resources (memory and CPU) to resolve errors with a custom destination connector [[source]](https://discuss.airbyte.io/t/678). 3. In the Airbyte documentation, it's recommended to scale up your Airbyte deployment to a larger number of nodes or reduce the maximum resource usage by any given connector pod if your nodes are under high CPU or Memory usage [[source]](https://docs.airbyte.com/enterprise-setup/scaling-airbyte#concurrent-syncs). If you're experiencing performance issues or errors, you might consider increasing the cpuLimit
for your connection. However, it's important to monitor the impact of this change on your system's overall performance and adjust as necessary. If you're unsure about the ideal CPU allocation for your specific use case, consider reaching out to the Airbyte community or support for more personalized advice.Tatiane Corrêa da Costa e Silva
07/18/2024, 2:17 PMWhen I make a request at <http://localhost>:PORT/api/v1/connections/get passing the connection_id in the body, I get "resourceRequirements": {
"memory_request": "4096Mi",
"memory_limit": "8192Mi"
},
But when I see the connection log in the UI I get
main=io.airbyte.config.ResourceRequirements@125f4b6a[cpuRequest=100m,cpuLimit=500m,memoryRequest=256Mi,memoryLimit=1024Mi,additionalProperties={}],
Why are the values different from memory?kapa.ai
07/18/2024, 2:17 PMkapa.ai
07/18/2024, 2:18 PMkapa.ai
07/18/2024, 2:18 PM/api/v1/connections/get
endpoint, the response includes the current configuration for the connection, which includes the memory_request
and memory_limit
values. These values represent the minimum and maximum memory that is allocated for the connection when it's running. On the other hand, the values you're seeing in the connection log (memoryRequest=256Mi,memoryLimit=1024Mi
) are the default resource requirements that are set for the connection. These values are used when the connection is created, and they can be overridden by the specific configuration for the connection. If you've updated the memory allocation for the connection after it was created, this could explain why the values are different. The /api/v1/connections/get
endpoint would return the updated values, while the connection log would still show the original default values. If you want to update the memory allocation for the connection, you can do so by making a request to the /api/v1/connections/update
endpoint with the updated memory_request
and memory_limit
values in the request body. After updating the configuration, the /api/v1/connections/get
endpoint should return the updated values. Please note that increasing the memory allocation can improve the performance of the connection, but it can also increase the load on your system. Therefore, it's important to monitor the impact of any changes on your system's overall performance.kapa.ai
07/18/2024, 2:18 PMResourceRequirements
you see in the connection log from the UI are the default resource requirements set for the connection. These values are set in the code and apply to all connections unless specifically overridden. In your case, the default memory request is 256Mi
and the memory limit is 1024Mi
. On the other hand, the memory_request
and memory_limit
values you're seeing from the API response are likely specific to the connection you're querying. These values are set when you create or update the connection and can be used to override the default resource requirements. In your case, the memory request is 4096Mi
and the memory limit is 8192Mi
. If you want the values to match, you would need to update the connection's specific resource requirements to match the default values, or vice versa. You can do this through the Airbyte API or UI. Please note that adjusting these values should be done carefully, considering the specific needs of your connection and the resources available on your system. If you're unsure, it's recommended to start with the default values and adjust as necessary based on the performance and resource usage you observe.kapa.ai
07/18/2024, 2:18 PMkapa.ai
07/18/2024, 2:18 PMResourceRequirements
you see in the connection log from the UI are the default resource requirements set for the connection. These values are set in the code and apply to all connections unless specifically overridden. In your case, the default memory request is 256Mi
and the memory limit is 1024Mi
. On the other hand, the memory_request
and memory_limit
values you're seeing from the API response are likely specific to the connection you're querying. These values are set when you create or update the connection and can be used to override the default resource requirements. In your case, the memory request is 4096Mi
and the memory limit is 8192Mi
. If you want the values to match, you would need to update the connection's specific resource requirements to match the default values, or vice versa. You can do this through the Airbyte API or UI. Please note that adjusting these values should be done carefully, considering the specific needs of your connection and the resources available on your system. If you're unsure, it's recommended to start with the default values and adjust as necessary based on the performance and resource usage you observe.