Backup fails about 50-60% of the time

[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@ ?

[bazinga]

After some time, Girish has added extra code that would increase re-tries count and timeouts, so eventually B2 started working, more or less.

With this said, I've just switched over to Hetzner and will see how that will work for me. Don't feel like paying money to B2 if their backend is overloaded and constantly results in various issues.

[girish]

The multi-part copy was just hanging. If someone hits the same issue, you can just apply this one liner https://git.cloudron.io/platform/box/-/commit/b4d58f0609b1c252fa44799eccbbd9c691c7c2ac . The file is /home/yellowtent/box/src/storage/s3.js