When running an SQL query or API call in workflow from within the self-hosted Retool setup, we get the following error:
"Internal Error running a block: Error: An internal server error occurred"
We checked our logs and the first error type we had was that you support only absolute URLs.
When we changed our DB connection string to use an absolute URL we still had an internal server error:
{“error”:{“code”:“ENOTFOUND”,“errno”:-3008,“hostname”:“our_db_host_name”,“message”:“getaddrinfo ENOTFOUND”,“name”:“Error”,“stack”:“Error: getaddrinfo ENOTFOUND our_db_connection_string\n at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:108:26)\n at GetAddrInfoReqWrap.callbackTrampoline (node:internal/async_hooks:130:17)“,”syscall”:“getaddrinfo”},“level”:“error”,“message”:“[postgres] error in getSchema/connect”,“pid”:105,“source”:“postgres”}
Our JS runs properly from within the workflows, and the only issue we have is with the resources (DB queries / API calls).
Please advise us on how we proceed and fix the usage of our resources in the workflows.