I got this message and all my workflows disappear, how can I do ?
pq: MultiXactId 14 has not been created yet -- apparent wraparound
I got this message and all my workflows disappear, how can I do ?
pq: MultiXactId 14 has not been created yet -- apparent wraparound
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:
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
When I go to the service and click on backup tab, it asked me to upgrade ? is this normal ? I cannot do it with free service ? Can you help me ?
Any news, How can I do with a free account ? Thanks
At this moment we do not support backups for free plan users. We would recommend upgrading to our developer plan or use the terminal to manually create a backup.
This post has been inactive for a while. We will be closing it in 2 days if there is no new activity.
New replies are disabled for resolved issues.