MySQL 4-byte support on maria-db 10.1 4 tables do not alter to barracuda

ℹ️ Support
1

Nextcloud version (eg, 12.0.2): 16.0.1
Operating system and version (eg, Ubuntu 17.04): debian 9.8
Apache or nginx version (eg, Apache 2.4.25): 2.4.25
PHP version (eg, 7.1): 7.3.6.1
mariadb version: 10.1.38

i am trying to enable 4-bit support.
i altered all tables of the db to barracuda except of the last 4 tables
| nextcloud2/oc_accounts | 119 | Antelope |
| nextcloud2/oc_activity | 120 | Antelope |
| nextcloud2/oc_activity_mq | 121 | Antelope |
| nextcloud2/oc_addressbookchanges | 122 | Antelope |
they for wont alter neither using
ALTER TABLE nextcloud.oc_accounts ROW_FORMAT=DYNAMIC;
nor using
ALTER TABLE nextcloud.oc_accounts ROW_FORMAT=DYNAMIC, ALGORITHM=COPY;

any suggestions ?

(meanwhile updated to nextcloud 16.0.2, no changes though)

2
3

i did exactly what is described there.

MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
.....
| nextcloud/oc_whats_new                   |   147 | Barracuda   |
| nextcloud2/oc_accounts                   |   119 | Antelope    |
| nextcloud2/oc_activity                   |   120 | Antelope    |
| nextcloud2/oc_activity_mq                |   121 | Antelope    |
| nextcloud2/oc_addressbookchanges         |   122 | Antelope    |
+------------------------------------------+-------+-------------+
76 rows in set (0.01 sec)

MariaDB [(none)]> ALTER TABLE nextcloud.oc_accounts ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.08 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [(none)]> ALTER TABLE nextcloud.oc_activity ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (8.99 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [(none)]> ALTER TABLE nextcloud.oc_activity_mq ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.10 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [(none)]> ALTER TABLE nextcloud.oc_addressbookchanges ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected (0.09 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
.....
| nextcloud/oc_whats_new                   |   147 | Barracuda   |
| nextcloud2/oc_accounts                   |   119 | Antelope    |
| nextcloud2/oc_activity                   |   120 | Antelope    |
| nextcloud2/oc_activity_mq                |   121 | Antelope    |
| nextcloud2/oc_addressbookchanges         |   122 | Antelope    |

as you can see, these 4 tables did NOT alter, rest ist fine.
so i did whats mentioned on https://docs.nextcloud.com/server/15/admin_manual/configuration_database/mysql_4byte_support.html at the bottom

MariaDB [(none)]> ALTER TABLE `nextcloud`.`oc_accounts` ROW_FORMAT=DYNAMIC, ALGORITHM=COPY;
Query OK, 3 rows affected (0.21 sec)
Records: 3  Duplicates: 0  Warnings: 0

MariaDB [(none)]> ALTER TABLE `nextcloud`.`oc_activity` ROW_FORMAT=DYNAMIC, ALGORITHM=COPY;
Query OK, 255923 rows affected (8.18 sec)
Records: 255923  Duplicates: 0  Warnings: 0

MariaDB [(none)]> ALTER TABLE `nextcloud`.`oc_activity_mq` ROW_FORMAT=DYNAMIC, ALGORITHM=COPY;
Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [(none)]> ALTER TABLE `nextcloud`.`oc_addressbookchanges` ROW_FORMAT=DYNAMIC, ALGORITHM=COPY;
Query OK, 26 rows affected (0.18 sec)
Records: 26  Duplicates: 0  Warnings: 0

MariaDB [(none)]> SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
.....
| nextcloud/oc_whats_new                   |   147 | Barracuda   |
| nextcloud2/oc_accounts                   |   119 | Antelope    |
| nextcloud2/oc_activity                   |   120 | Antelope    |
| nextcloud2/oc_activity_mq                |   121 | Antelope    |
| nextcloud2/oc_addressbookchanges         |   122 | Antelope    |

as you can see, there are still no changes at those 4 tables.

any idea how to alter this 4 tables to barracuda as well ?

4

Looks like the name of your nextcloud database is nextcloud2 and not nextcloud. So you need to adapt the sql-commands accordingly.

2 Likes
5

damn it and thak you.
my db-name is nextcloud, those 4 tables are in an old db of a previous installation.
i simply deleted the nextcloud2-dband everythings fine now.
sometimes you do not the the easiest mistakes
thanks again

1 Like