Hello after upgrading to latest 0.221.2, all of sudden my code function node which its pervious node is a sql query returns the below error.
There might not be enough memory to finish the execution. Tips for avoiding this [here](https://docs.n8n.io/flow-logic/error-handling/memory-errors/)
I have drilled it down the issue is that something is not handling created_at and updated_at fields that is returned correctly, attaching the sql query to another node such as a list node produces no errors… interstingly enough, if I have the node open and excute the node, no issues, it is only when I run the workflow manually or via cron or another workflow trigger.
Simple querey throws the below error
SELECT updated_at, created_at FROM TABLE
This is the schema for created_at and updated_at (defualt mysql)
CREATE TABLE t1 (
created_at TIMESTAMP DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP
);
here are sample values
updated_at: 2023-03-27 03:00:18
created_at: 2023-03-26 08:01:42
mysql node returns
[
{
"updated_at":
"2023-03-27T03:00:18.000Z",
"created_at":
"2023-03-25T22:31:42.000Z"
},
]
at Proxy.toISOString (<anonymous>)
at Proxy.toJSON (<anonymous>)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:182:21)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:256:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:256:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:217:25)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:221:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:256:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:256:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:221:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:256:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:256:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:256:23)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:217:25)
at stringifyFnReplacer (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:256:23)
at stringify (/usr/local/lib/node_modules/n8n/node_modules/safe-stable-stringify/index.js:598:18)
at Format.transform (/usr/local/lib/node_modules/n8n/node_modules/logform/json.js:28:19)
at DerivedLogger._transform (/usr/local/lib/node_modules/n8n/node_modules/winston/lib/winston/logger.js:313:29)
at DerivedLogger.Transform._read (/usr/local/lib/node_modules/n8n/node_modules/winston/node_modules/readable-stream/lib/_stream_transform.js:166:10)
at DerivedLogger.Transform._write (/usr/local/lib/node_modules/n8n/node_modules/winston/node_modules/readable-stream/lib/_stream_transform.js:155:83)
at doWrite (/usr/local/lib/node_modules/n8n/node_modules/winston/node_modules/readable-stream/lib/_stream_writable.js:390:139)
at writeOrBuffer (/usr/local/lib/node_modules/n8n/node_modules/winston/node_modules/readable-stream/lib/_stream_writable.js:381:5)
at DerivedLogger.Writable.write (/usr/local/lib/node_modules/n8n/node_modules/winston/node_modules/readable-stream/lib/_stream_writable.js:302:11)
at DerivedLogger.log (/usr/local/lib/node_modules/n8n/node_modules/winston/lib/winston/logger.js:252:14)
at Logger.log (/usr/local/lib/node_modules/n8n/dist/Logger.js:57:21)
at Logger.error (/usr/local/lib/node_modules/n8n/dist/Logger.js:66:14)
at WorkflowRunnerProcess.sendHookToParentProcess (/usr/local/lib/node_modules/n8n/dist/WorkflowRunnerProcess.js:215:25)
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at WorkflowHooks.hookFunctions.workflowExecuteAfter (/usr/local/lib/node_modules/n8n/dist/WorkflowRunnerProcess.js:237:21)
at WorkflowHooks.executeHookFunctions (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/WorkflowHooks.js:17:17)
at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:774:17
Method Date.prototype.toISOString called on incompatible receiver [object Date]