Backup fails about 50-60% of the time

[djxx]

My main finding was that the backup job (which worked fine before) has started to require about 8x of the size of the backup to run successfully. This means if your backup size is 1GB it won't have enough memory.

[nebulon]

Something is not working correctly with the buffering then either on the local server or at the backup storage remote. This should definitely not require even close the amount of memory of the backup itself to be in memory.

[bazinga]

@djxx Sorry, I don't know what you mean exactly. If we're talking about backup configuration, then I have memory limit set to 1.5GB and upload part size to 10MB. Don't think I've changed any of these values, when setting up Backblaze as a target.

If what your second message says about RAM required > projected backup size, then I would see it as a problem with Cloudron. I cannot imagine how that could be the case with installs with data in tens of gigabytes in size. @nebulon is that really the case?

My backups are about 6.5 GB, if I were to trust Backblaze console.

[bazinga]

@scooke Yeah, I was just hoping that logging would be sufficient to point to either side of this equation as a root cause. Maybe with a way to change log level or something like that.

As far as change the destination for the backups. Well, I used Minio on a separate Azure VM for years and it was all good, except then something happened and I needed to update Minio. Only to find that Minio was no longer either supporting S3 APIs or something to that extent. So I picked something that I've heard a lot about over the years - Backblaze.

The bigger question here - if Cloudron is at fault (one way or another) then changing the provider wouldn't solve the issue.

[bazinga]

Today the backup failed again - was stuck and i had to cancel it. Same sort of issue:

Sep 28 01:09:00 box:tasks update 15221: {"percent":43.85714285714286,"message":"Copying part 4 - Etag: \"1cfa597bd5187486ed3704d6a556f513\""}
Sep 28 09:08:09 box:database Connection 350 error: Packets out of order. Got: 0 Expected: 2 PROTOCOL_PACKETS_OUT_OF_ORDER
Sep 28 09:08:09 box:database Connection 344 error: Packets out of order. Got: 0 Expected: 2 PROTOCOL_PACKETS_OUT_OF_ORDER
Sep 28 09:08:49 box:database Connection 347 error: Packets out of order. Got: 0 Expected: 2 PROTOCOL_PACKETS_OUT_OF_ORDER
Sep 28 09:09:01 box:database Connection 345 error: Packets out of order. Got: 0 Expected: 2 PROTOCOL_PACKETS_OUT_OF_ORDER

Sigh. This is very annoying as I don't even know which system / component is at fault. But judging by "box:database" component name in the logs - it seems this is some error withing Cloudron. Even though I'm not sure what database this refers to.

[Nozy]

@bazinga do you have IPV6 running on that server ? ( after I turn it off backup worked ok after that )

[bazinga]

@Nozy Thanks for letting me know about IPv6. Didn't event think whether it's enabled or not, and turns out it is.

Would turning it off have any detrimental effects on Cloudron, do you know? Do I need to be aware of something before switching it off?

[joseph]

@bazinga turning off ipv6 should be safe. Do this at interface level instead of server level. See https://superuser.com/questions/575684/how-to-disable-ipv6-on-a-specific-interface-in-linux . That said, I am not sure how it helps here though...

Even though I'm not sure what database this refers to.

The Cloudron 'box' code connects to the local MySQL database. It is losing the connection and/or getting that error from the database in the logs. It's not clear why. Can you also check /var/log/mysql/error.log maybe ?

[bazinga]

@joseph I cannot even fathom how switching off IPv6 would help with this issue, but since you're saying that backup task uses MySQL db and connects to it - who knows, maybe IPv6 might have some effect there.

I've checked logs for mysql. There are few of them there zipped and they all are 0 bytes / empty, even on the days when backup task fails.

Backup keeps failing - in the past 4 days it succeeded only once. This is getting really annoying as not having backups for DR is a problem.

[joseph]

@bazinga fwiw, I didn't recommend switching off IPv6. I only said it's safe to switch it off

Unfortunately, given the information, I cannot make out what the issue is. Can you write to support@cloudron.io and we can debug what's going on.

[SansGuidon]

@bazinga I had similar issues in recent days using Contabo Object Storage on a Contabo VPS.
I ended up fixing it all simply switching to a different storage solution, here Hetzner Storage Box through SSHFS, and that solved most of my pains.
If you can, try that and save yourself some time and suffering.

[bazinga]

@joseph I've sent an email to the address you've provided. Hopefully there is something we can do about this. Thank you!

[joseph]

Bumping the memory limit to 4GB seems to alleviate the issue. Let's see

[bazinga]

No, doesn't help. The backup keeps failing most of the time. When initiated manually it take 3-5 tries before it succeeds.

[joseph]

@bazinga sorry, did this get solved? If not can you please ping me again on support@ ?