PGsqlVector

Hello, I’m facing a problem that I haven’t been able to identify yet. The PGVECTOR node that inserts information into Postgress simply freezes after 90 to 100 pieces of data.

What has already been done:

Adjustments to Postgress connections. As a test, I set them to 10,000, even though the database only shows one connection.

The Postgress timeout and buffer settings are absurdly high.

In BOTH cases, there is a lot of RAM and CPU left over.

I’ve come to the conclusion that Postgres is not crashing on the server side.

I’ve changed the NODE in different ways. I tested it by sending EVERYTHING, and also by sending files one at a time and 10 at a time.

The Node simply freezes. It doesn’t generate any errors, not even the debug generates an error. It just keeps showing up (when running the node).

I would like to point out that it works perfectly well up to 90~100 pieces of data on average, but afterwards it simply looks like the attached image.

I would appreciate it if you could tell me where my mistake is in this case.




Information on your n8n setup

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

After a few days of racking my brains I managed to understand the problem and it is some missing treatment within N8N in the postgress folder.

The problem is quite simple, n8n for some reason when you DO NOT set the connection to (Ignore SSL Issues (Insecure) and mark it as (DISABLED) after X connections ex: 90 ~ 100 it simply tries a connection with SSL

what does a tail in postgres return:

FATAL:  unsupported frontend protocol 0.0: server supports 3.0 to 3.0
FATAL:  unsupported frontend protocol 255.255: server supports 3.0 to 3.0

Now if we mark it to ignore completely, it does not return errors and we can have the output of all files.