When attempting to migrate to NS8, I am getting this error when migrating SOGo:
Cannot add field c_description in table sogo.sogojeff0024f7c2cac_quick because after adding it, the row size is 8670 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
ERROR 1118 (42000) at line 1977: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
The migration then fails. I can the abort the migration and continue using the old server, however I need to get past this.
OK, so it had been working fine on the NS7 VM. How do I get the NS8 VM to accept it since the database isn’t setup until the migration is started? Reading the through that link, it is a little passed my expertise, but I can follow it.
yes, by the sogo10 you know I’ve tried this a few times…
I added these two lines to the [mysqld] section:
innodb_log_file_size = 512M
innodb_strict_mode = 0
I then rebooted, because I was not sure how to get just that container instance of mariadb to restart.
That seems to have allowed me to get past that error as I was able to sync the data but it now fails with simply this at the end of the ns8-migration log file.
rsync: failed to connect to 10.5.4.1 (10.5.4.1): Connection refused (111)
rsync error: error in socket IO (code 10) at clientserver.c(126) [sender=3.1.2]
mysqldump --single-transaction --quick --add-drop-table -QB "sogo" -r sogo.sql
# SOGo strore the protocol of connection of users in the database : mysql://sogo:password@localhost/
old_password=$(cat /var/lib/nethserver/secrets/sogo)
sed -i "s|mysql://sogo:$old_password@localhost/|mysql://sogo:Nethesis,1234@127.0.0.1:3306/|g" sogo.sql
the actions/restore-module/40restoreDB is also used to restore the table from the backup, it means for a restoration you will fails. In fact you were probably not aware about you database corrupted status because you probably never restored your database on NS7
I am not a gambler but in you case I am close to bet
I was able to get through that, and we are migrated. Thank you for your help. Looks like I’ll be starting a new thread though, as my group folders in nextcloud migrated the data, but the app in Nextcloud doesn’t seem to be working.
Edit Just had to disable then download and enable Group Folders. Talk as well, I’m not sure which other apps may need that.
