-
Incident report
-
Resolution: Fixed
-
Trivial
-
None
-
5.0.2, 5.0.3
-
None
hello,
just to report a small bug.
when importing the tables in mariadb, i got this error.
it looks like there is a strange character.
zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix5
INSERT INTO `items` (`itemid`,`type`,`snmp_oid`,`hostid`,`name`,`key_`,`delay`,`history`,`trends`,`status`,`value_type`,`trapper_hosts`,`units`,`formula`,`logtimefmt`,`templateid`,`valuemapid`,`params`,`ipmi_sensor`,`authtype`,`username`,`password`,`publickey`,`privatekey`,`flags`,`interfaceid`,`description`,`inventory_link`,`lifetime`,`evaltype`,`jmx_endpoint`,`master_itemid`,`timeout`,`url`,`query_fields`,`posts`,`status_codes`,`follow_redirects`,`post_type`,`headers`,`retrieve_mode`,`request_method`,`output_format`,`verify_peer`,`verify_host`,`allow_traps`,`discover`) values ('31243','0','','10328','DB
{#DBNAME}: Get bloating tables','pgsql.db.bloating_tables["{$PG.URI}","{$PG.USER}","{$PG.PASSWORD}","{#DBNAME}"]','1m','7d','365d','0','3','','','','',NULL,NULL,'','','0','','','','','2',NULL,'Number оf bloating tables','0','30d','0','',NULL,'3s','','','','200','1','0','','0','0','0','0','0','0','0');
ERROR 1366 (22007) at line 6596: Incorrect string value: '\xD0\xBEf bl...' for column `zabbix5`.`items`.`description` at row 1
i fix it with
sed -i "s|Number оf bloating tables|Number of bloating tables|" /usr/share/doc/zabbix-server-mysql-5.0.2/create.sql
mysql -V
mysql Ver 15.1 Distrib 10.2.25-MariaDB, for Linux (x86_64) using readline 5.1