NodeOperationError: Invalid time value at parsePostgresError

c3service

PROOP

2 years ago

My project with 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.

If I execute a query on a table without a timestamp column, the node works.

Has anyone experienced a similar issue like this?

Thanks.

2 Replies

brody

EMPLOYEE

2 years ago

Are you using the data tab of the Postgres database?

c3service

PROOP

2 years ago

Hi Brody,

I ran several tests, and after setting up three different environments, I was able to identify the issue. It worked when I created a new database and restored a backup. For some reason, the n8n nodes encounter problems when running on the old database after the crash. There was no need to reinstall PostgreSQL or n8n.

Thanks.