Dotaz: MariaDB - problém s importem databáze Zabbixu

[Jirka]

Ahoj.
Neporadil by někdo, jak naimportovat 15GB databázi ?

>>> mysql zabbix < zabbix_prod.sql
ERROR 1118 (42000) at line 4044: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

Info o OS

Debian 10.3.
ii  mariadb-server-10.3             1:10.3.22-0+deb10u1         amd64        MariaDB database server binaries

Vše je ve výchozím stavu.

Díky,
Jirka

---

---

Odpovědi

[dustin]

První link na google https://www.google.com/search?q=Row+size+too+large+%28%3E+8126%29

https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/

S velkým souborem lze pracovat např. se skriptem LargeFile pro vim https://www.vim.org/scripts/script.php?script_id=1506

Automatizované nahrazení typu sloupce v dumpu pak zvládne např. sed.

[Jirka]

Děkuji, asi nejsem databázový specialista. Šlo by to prosím po lopatě ?

[kaaja]

https://www.zabbix.com/documentation/4.0/manual/installation/known_issues

MariaDB row size error

Prior to MariaDB 10.2.26, 10.3.17, and 10.4.7, MariaDB didn't properly calculate the row sizes while executing DDL, so “unsafe” tables could be created, even with innodb_strict_mode=ON set. This was fixed by MDEV-19292. As a side effect, tables that could be created in previous versions may get rejected after the latest releases.

Suggested database changes for existing 4.0 installations:

shell> mysql -uroot -p mysql> alter table `host_inventory` modify `name` varchar(128) default '' not null, modify `alias` varchar(128) default '' not null, modify `os` varchar(128) default '' not null, modify `os_short` varchar(128) default '' not null;

Suggested database changes for new 4.0 installations:

shell> mysql -uroot -p mysql> set global innodb_strict_mode='OFF';

Perform database creation as usual and fix schema after:

shell> mysql -uroot -p mysql> alter table `host_inventory` modify `name` varchar(128) default '' not null, modify `alias` varchar(128) default '' not null, modify `os` varchar(128) default '' not null, modify `os_short` varchar(128) default '' not null;

[Jirka]

Děkuju.
Tohle pomohlo a vyřešilo.

Díky moc.