MySQL - Maximum call stack size exceeded

Questions
,
1

Hello.

We get the following error in MySQL node when we try to feth 180k rows with 10 columns.

I played a little with LIMIT and managed to fetch only 120k rows.

Above that we get the error Maximum call stack size exceeded.

Our VM has enough RAM and it is not utilized fully.

We are running the 1.58.1 version.

Is there any workaround?

Other info

Item Index

0

Node type

n8n-nodes-base.mySql

Node version

2.4 (Latest)

n8n version

1.58.1 (Self Hosted)

Time

9/24/2024, 6:51:17 PM

Stack trace

NodeOperationError: Maximum call stack size exceeded at Object.parseMySqlError (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/helpers/utils.js:80:12) at /usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/helpers/utils.js:189:47 at processTicksAndRejections (node:internal/process/task_queues:95:5) at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/actions/database/executeQuery.operation.js:64:18) at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/actions/router.js:48:30) at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/MySqlV2.node.js:16:16) at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:722:19) at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:670:51 at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1100:20
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Updated to latest version. Same thing happens. For some reason MySQL node can not handle so many rows? Even if i put only 1 column to the SELECT statement, same error happens.

4

I narrow it down to

SELECT 1 FROM my_table LIMIT 123316; – runs successfully

SELECT 1 FROM my_table LIMIT 123317; – error Maximum call stack size exceeded

5

Thanks for reporting this issue.
This will be fixed in PR 10965.

6

New version n8n@1.61.0 got released which includes the GitHub PR 10965.