-
Problem report
-
Resolution: Won't fix
-
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