MySQL - Maximum call stack size exceeded - Again!

Questions
, ,
1

Hello.

We have updated to latest version 1.62.5.

Although you mentioned on the previous post that this issue has been fixed

I tried again and the same thing happens.

I attach the debug log

14T08:35:11.524Z
|
debug
|
Workflow execution finished with error
{
   "error":{
      "level":"error",
      "tags":{
         
      },
      "context":{
         "itemIndex":0
      },
      "functionality":"regular",
      "name":"NodeOperationError",
      "timestamp":1728894911520,
      "node":{
         "parameters":{
            "notice":"",
            "descriptionType":"auto",
            "resource":"database",
            "operation":"executeQuery",
            "query":"SELECT * FROM orders WHERE order_id >= (SELECT MIN(order_id) FROM a_orders WHERE dispatch_time >= '{{ $now.minus(3, 'days').format('yyyyMMdd000000') }}');",
            "options":{
               
            }
         },
         "id":"407a04bb-b740-48b8-84e5-6d9e6296b837",
         "name":"Get orders",
         "type":"n8n-nodes-base.mySql",
         "typeVersion":2.4,
         "position":[
            1160,
            1160
         ],
         "credentials":{
            "mySql":{
               "id":"LclDDl3WaI6kbjGn",
               "name":"thirdrepl"
            }
         }
      },
      "messages":[
         
      ],
      "description":"sql: undefined, code: undefined",
      "message":"Maximum call stack size exceeded",
      "stack":"NodeOperationError: Maximum call stack size exceeded\n    at Object.parseMySqlError (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/helpers/utils.js:80:12)\n    at /usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/helpers/utils.js:189:47\n    at processTicksAndRejections (node:internal/process/task_queues:95:5)\n    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)\n    at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/actions/router.js:48:30)\n    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/MySql/v2/MySqlV2.node.js:16:16)\n    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:722:19)\n    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:711:51\n    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1141:20"
   },
   "workflowId":"dnkN2cv3kMWrEGlh",
   "file":"LoggerProxy.js",
   "function":"exports.debug"
}
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

Looks like I failed at a simple search-and-replace :person_facepalming: .
Fixing this in another PR now.

Thanks for reporting this :heart_decoration:

4

New version n8n@1.64.0 got released which includes the GitHub PR 11242.