YunoHost-Apps / friendica_ynh

Friendica package for YunoHost
http://friendi.ca/
Other
11 stars 13 forks source link

No backups can be created with Borg - we need to put Friendica in maintenance first! #100

Closed tio-trom closed 1 year ago

tio-trom commented 1 year ago

Basically it is because the database changes while it is preparing for a backup, from what I understand.

2023-08-19 00:35:12,150: WARNING - mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping tableinbox-entryat row: 0

Full log here https://paste.yunohost.org/raw/duceyedari

Can't we do it in a different way? Like put Friendica in maintenance mode then do a backup?

tio-trom commented 1 year ago

More info here https://github.com/friendica/friendica/issues/11822 - there seem to be ways to make it either retry multiple times or put friendica in maintenance mode. If anyone has any idea how to implement this into friendica's script itself....would be super duper amazing.

tio-trom commented 1 year ago

If you put friendica in maintenance mode before doing the backup all works fine.

To do that first cd /var/www/friendica then bin/console maintenance 1 to get it out of maintenance we can use 0 instead of 1.

tio-trom commented 1 year ago

This merge will fix it! https://github.com/YunoHost-Apps/friendica_ynh/pull/104 Please approve.