Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18318

error when importing create.sql in mariadb

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 5.0.2, 5.0.3
    • Server (S)
    • 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

            elina.kuzyutkina Elina Kuzyutkina (Inactive)
            olivier E olivier E
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: