Forum

PostgreSQL is failing with:

pq: MultiXactId 14 has not been created yet -- apparent wraparound

This indicates a MultiXact wraparound protection state.

SQL commands fail, including VACUUM.

Please run a VACUUM FREEZE or maintenance on the database cluster and reset datminmxid.

Database used by n8n is: zeabur

This is urgent to avoid data loss.

Hi there, couple things I want to make sure here:

• did you change the version of postgres of n8n prior to facing this issue?
• is this our official template?

If you are worried about data loss. I would recommend setting up a daily backup first so you don't lose the data while in this process.

I made a quick round of consultation on the web and it seems like this is a known issue with Postgres when handling a large amount of concurrent workload, it is not related to Zeabur service.

You may follow the instructions and do a manual vacuum

Hello I tried to do a manual vaccum but as I said before it doesn"t work. can you do : Please run a VACUUM FREEZE or maintenance on the database cluster and reset datminmxid.

Thanks

Hi there due to our policy we are unable to run commands on users' services. However, we can try to guide you and trouble shoot with you. What is the error when you tried manual vacuum?

Hello here is the error message I got when trying to execute SQL command "VACUUM (FREEZE, VERBOSE);"

Error: Failed to execute database command Code: INTERNAL Description: execute sql command: pq: MultiXactId 14 has not been created yet -- apparent wraparound Trace ID: 538d89f2b61bd146e79abac620061a03

Hi there, this seems to be a severe data corruption. I would recommend doing a full backup and redeploy a new pg instance and fully restore it afterwards

the problem is that I cannot do a backup. It's not propose to me Is it because I am on a free account ?

Yes I do see it! Please go to the service and see the backup tab. You may generate a backup for both n8n and postgres

Any news, How can I do with a free account ? Thanks

This post has been inactive for a while. We will be closing it in 2 days if there is no new activity.