Move to new Server destroyed Baserow

[nebulon]

@pbischoff can you try to increase the postgres service memory limit for the import, maybe the sqldump to import is very large?

[girish]

@pbischoff said in Move to new Server destroyed Baserow:

The step "Restoring addons" fails after 30 minutes to hours (don't know exactly)

Most likely the database needs more memory. It's under Services -> Edit -> bump the memory limit a lot and then trigger a restore of the app again (App -> Backups -> the latest backup -> restore).

[pbischoff]

Thanks for your quick reply @nebulon and @girish

I increased the memory of postgres to 1 GB and triggered restore again, but got the same behavior.
After that I observed that mysql also seems to reach the memory limit and so I increased mysql limit to 1 GB as well.
I triggered the restore and have the same behavior. The task gets stuck in "Restoring addons" for hours now.

Memory utilization of services

This is a screenshot of the services page.
Mysql and postgres are not reaching their memory limits.
But the server has 4 GB of RAM overall. Maybe this is the limiting factor?

Thanks for help
Philipp

[nebulon]

@pbischoff baserow is using postgres and an initial import of a sql dump can take a lot more memory than 1Gb temporarily. Can you try to put the limit for that much higher just for the time during the app restore?

[pbischoff]

@nebulon Yes, I put the Limit to almost 3 GB and got the same behavior. Maybe there is a way to look in the logs to see way the task fails?

[pbischoff]

@nebulon also in services ist looks like postgres is only using 0,5 of the 3 GB.

[girish]

@pbischoff Not sure what is going on, can you write to us at support@cloudron.io , so we can investigate further?

[nebulon]

This hit a known postgres issue which is fixed in Cloudron 7.3

[pbischoff]

@nebulon thanks to your advice.

I was wondering how I can update to a "stable" 7.3 version. Normally it should update automatically to the newest version, when I'm getting your knowledge base right. But my Cloudron has version 7.2.5. for a while now and is not automatically updating. Am I doing something wrong here in any config or setting?

When I check for updates, it says that I can update to version 7.3.2, but that it is a prerelease and updating would be on my own risk.

[nebulon]

@pbischoff that is correct, until we have released the hopefully final 7.3 patch release, it is not automatically updated.

[pbischoff]

@nebulon you were right.
With the new version 7.3 the restore worked immediately and now baserow is running again.
Thank you for the great support!