The n8n stopped unexpectedly, and since then, the PostgreSQL nodes are not functioning correctly. Whenever I run any workflow that includes a query on a table with a timestamp column, I encounter the error “NodeOperationError: Invalid time value.”
I’ve tried creating new instances of n8n, and even after restoring the database backup, the error persists.
{
"errorMessage": "Invalid time value",
"errorDescription": "Failed query: select nome, \"dhUltimaAtualizacao\" from cliente.cliente limit 10",
"errorDetails": {},
"n8nDetails": {
"nodeName": "Postgres",
"nodeType": "n8n-nodes-base.postgres",
"nodeVersion": 2.3,
"resource": "database",
"operation": "executeQuery",
"time": "09/04/2024, 10:23:26",
"n8nVersion": "1.34.2 (Self Hosted)",
"binaryDataMode": "default",
"stackTrace": [
"NodeOperationError: Invalid time value",
" at parsePostgresError (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/helpers/utils.js:68:12)",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/helpers/utils.js:175:31",
" 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/Postgres/v2/actions/database/executeQuery.operation.js:79:12)",
" at Object.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/actions/router.js:49:30)",
" at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/PostgresV2.node.js:16:16)",
" at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:724:19)",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:660:53",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1062:20"
]
}
}
Please share your workflow
Below is a simple test node that is returning the error:
Without the date column, it works:
n8n version: 1.34.2 (Self Hosted)
Database : PostgreSQL 16.0 (Debian 16.0-1.pgdg120+1) on x86_64-pc-linux-gnu
n8n EXECUTIONS_PROCESS setting (default: own, main): default
Running n8n via Railway
Linux