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

Cannot add field `date_hw_purchase`

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 4.0.16
    • None
    • None
    • Debian 10, Zabbix 4.0.16, PHP 7.3.11-1~deb10u1, MartiaDB 10.3.18-MariaDB-0+deb10u1

      Hello,

      i just get SMS from my Zabbix with information Zabbix database is not available.

      After login i see MariaDB working all the time but in mariadb logs i got it:

      2020-01-19 15:38:34 36 [Warning] InnoDB: Cannot add field `date_hw_purchase` in table `zabbix`.`host_inventory` because after adding it, the row size is 8133 which is greater than maximum allowed size (8126) for a record on index leaf page.
      2020-01-19 15:38:34 36 [Warning] InnoDB: Cannot add field `url` in table `zabbix`.`items` because after adding it, the row size is 8182 which is greater than maximum allowed size (8126) for a record on index leaf page.
      2020-01-19 15:39:18 0 [Note] InnoDB: Buffer pool(s) load completed at 200119 15:39:18
      

      In zabbix-server logs:

      738:20200119:152507.911 executing housekeeper
       738:20200119:152514.361 housekeeper [deleted 146115 hist/trends, 10000 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 6.449778 sec, idle for 1 hour(s)]
       751:20200119:153824.732 [Z3005] query failed: [2013] Lost connection to MySQL server during query [select h.hostid,h.host,h.name,t.httptestid,t.name,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries,t.ssl_cert_file,t.ssl_key_file,t.ssl_key_password,t.verify_peer,t.verify_host,t.delay from httptest t,hosts h where t.hostid=h.hostid and t.nextcheck<=1579444703 and mod(t.httptestid,20)=6 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
       778:20200119:153824.747 [Z3005] query failed: [2006] MySQL server has gone away [insert into history_uint (itemid,clock,ns,value) values (27952,1579444702,463871063,0);]
       876:20200119:153824.748 [Z3005] query failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) [select h.hostid,h.status,h.tls_accept,h.tls_issuer,h.tls_subject,h.tls_psk_identity,a.host_metadata from hosts h left join autoreg_host a on a.proxy_hostid is null and a.host=h.host where h.host='radvd.taken.pl' and h.status in (0,1) and h.flags<>2 and h.proxy_hostid is null]
      

      I don`t change anything i was not logged in this is old instalation and first time i got problem like this.

       

      Best Regards

      TaKeN

       

            igorbach Igor Gorbach
            TaKeN Marek Krolikowski
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: