Azure function outputs "Database Error DBSAllocHandle" error when triggered, what may be causing the issue?

Question

Hello,

I am successfully deploying an Azure function via PyCharm, however even though the function runs with no issues locally when triggering the function after deploying it to Azure it outputs the following error:

Failure Exception: DatabaseError: DBSAllocHandle invoked failed. Stack: File "/azure-functions-host/workers/python/3.7/LINUX/X64/azure_functions_worker/dispatcher.py", line 482, in _handle__invocation_request invocation_id, fi_context, fi.func, args) File "/usr/local/lib/python3.7/concurrent/futures/thread.py", line 57, in run result = self.fn(*self.args, **self.kwargs) File "/azure-functions-host/workers/python/3.7/LINUX/X64/azure_functions_worker/dispatcher.py", line 753, in _run_sync_func func)(params) File "/azure-functions-host/workers/python/3.7/LINUX/X64/azure_functions_worker/extension.py", line 215, in _raw_invocation_wrapper result = function(**args) File "/home/site/wwwroot/HttpTrigger/__init__.py", line 32, in main ctx = get_connection() File "/home/site/wwwroot/HttpTrigger/__init__.py", line 7, in get_connection return mod.connect("AuthScheme=Password;

I am using a snowflake connector to access certain data and print them as HTTP Response.

I am importing the external library via the requirements .txt accordingly and the deployment log does not report any issue.

Any idea on what might be the issue here?

Thank you in advance!

Answer 1

If your function runs locally but not in Azure Function runtime, it might indicate that you hit some limits (e.g. RAM) in there. For the sake of experiment, try to deploy it in App plan.