SQL error

[joseph]

@jcalag I think I have replied to your email.

[jcalag]

@joseph

I’d like to inform everyone that our current backup takes approximately 3 hours and 45 minutes to complete.

In the event that the server goes down, the full restoration process could take 8–9 hours or possibly longer, depending on the situation.

With this in mind, I would like to ask for your recommendation on how we should proceed. Would it be better to schedule this activity over the weekend to minimize disruption to our employees and clients in case a restore is required?

If we are confident that this will not cause any issues or downtime, we can proceed today.

Please advise on the best course of action.

[jcalag]

also just to add, the last time this cloudron was updated was on july 2024

[james]

Hello @jcalag
Is this still an issue?
Depending on your hosting provider you might be able to create a server snapshot as an alternative backup method for a fast restoration if something goes wrong.

[jcalag]

@james Yeah, for now we can only do it in weekend because if we fcked up restoration it's gonna take around 17 hours like last time,

Also maybe you got something we can test or any article we can try to use in the weekend that would be helpful;

Last time we tried updating ubuntu to 22 but these are the error's

"When we update the ubuntu to 22 it shows these error and we tried to update it to 24 to see if it might fix but it still shows the same error."

Errors were encountered while processing:
nginx-core
nginx-common

[OK] node version is correct
Docker is down. Trying to restart docker ...
[OK] docker is running
[OK] MySQL is running
[OK] nginx is running
[FAIL] Could not load dashboard website with loopback check

[jcalag]

@james maybe you got something that could help us in the weekend sorry I can't give much details because we already restored it.

[james]

Hello @jcalag
If you have an active cloudron subscription you can contact support@cloudron.io.
When you have a restored state, which is failing on cloudron-support --troubleshoot that is where you should send the mail so we can have a look.

[jcalag]

@james Hello james we can only do troubleshooting in weekends if you got time in weekend maybe I can give you access to the server.

But I just saw this blog https://forum.cloudron.io/topic/14045/services-and-all-apps-down-due-to-cgroups-error/7?_=1771850781969 it has the same issue with us and you guys fixed it maybe you can give me some details on how it was fixed maybe I can do it if you guys are not available in weekend.

[girish]

@jcalag did you get this sorted out? Unfortunately, we don't provide this kind of support (troubleshooting over weekends). But if you write to support@ , we can look into your server.

[jcalag]

@girish yeah did found a solution,

I only did recreate container before updating and it fixed the mysql issue.