1 Topic by specu

  • specu
  • Member
  • Offline
  • Registered: 2021-04-27
  • Posts: 8

Topic: MariaDB backend 1.7.3 upgrade

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.7.2
- Deployed with iRedMail Easy or the downloadable installer? downloaded
- Linux/BSD distribution name and version: Ubuntu 22.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): nginx
- Manage mail accounts with iRedAdmin-Pro? NO
====

Hi, I cant import upgrade to MariaDB backend (mysql vmail < /tmp/vmail.mysql)

error:
--------------
call irm173_schema_change()
--------------

ERROR 1118 (42000) at line 57: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,340

Re: MariaDB backend 1.7.3 upgrade

Could you please show me full console output of command below? Run as root user:

mysql vmail -e "SHOW TABLE STATUS LIKE 'mailbox' \G"

3 Reply by specu

  • specu
  • Member
  • Offline
  • Registered: 2021-04-27
  • Posts: 8

Re: MariaDB backend 1.7.3 upgrade

mysql vmail -e "SHOW TABLE STATUS LIKE 'mailbox' \G"
*************************** 1. row ***************************
            Name: mailbox
          Engine: InnoDB
         Version: 10
      Row_format: Compact
            Rows: 6
  Avg_row_length: 2730
     Data_length: 16384
 Max_data_length: 0
    Index_length: 491520
       Data_free: 0
  Auto_increment: NULL
     Create_time: 2022-11-15 11:29:58
     Update_time: NULL
      Check_time: NULL
       Collation: utf8mb3_general_ci
        Checksum: NULL
  Create_options: 
         Comment: 
Max_index_length: 0
       Temporary: N

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,340

Re: MariaDB backend 1.7.3 upgrade

Change the Row_format from Compact to DYNAMIC first, then import the sql file again:

mysql vmail -e "ALTER TABLE mailbox ROW_FORMAT=DYNAMIC;"

5 Reply by specu

  • specu
  • Member
  • Offline
  • Registered: 2021-04-27
  • Posts: 8

Re: MariaDB backend 1.7.3 upgrade

Thanks file imported without any errors.

What about rest of the tables in vmail, row_format is also Compact. Should I change it to Dynamic?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,340

Re: MariaDB backend 1.7.3 upgrade

specu wrote:

What about rest of the tables in vmail, row_format is also Compact. Should I change it to Dynamic?

It's ok.