Zabbix crashed

[vsmjoao]

Yesterday the Zabbix server was connecting normally, after a while the computer crashed.

After I restarted the computer, the Zabbix service did not work.



zabbix-server.service - Zabbix Server
Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; enabled; vendor preset: disabled)
Active: activating (auto-restart) (Result: exit-code) since Tue 2020-10-06 17:50:36 -03; 17ms ago
Process: 3932 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=1/FAILURE)




How do I solve it?

[Atsushi]

Check Zabbix server and OS logs.
ex. /var/log/zabbix/zabbix_server.log, /var/log/messages, /var/log/audit/audit.log

[vsmjoao]

Result:

[root@zabbix ~]# tail -n10 /var/log/zabbix/zabbix_server.log
198377:20201006:155404.858 current database version (mandatory/optional): 05000000/05000002
198377:20201006:155404.858 required mandatory version: 05000000
198377:20201006:155542.919 slow query: 49.518183 sec, "select default_character_set_name,default_collation_name from information_schema.SCHEMATA where schema_name='zabbix'"
198377:20201006:155656.916 slow query: 73.657414 sec, "select count(*) from information_schema.`COLUMNS` where table_schema='zabbix' and data_type in ('text','varchar','longtext') and (character_set_name<>'utf8' or collation_name<>'utf8_bin')"
198377:20201006:155921.333 slow query: 67.808078 sec, "select count(*) from information_schema.columns where table_schema='zabbix' and column_type='double' and ((lower(table_name)='trends' and (lower(column_name) in ('value_min', 'value_avg', 'value_max'))) or (lower(table_name)='history' and lower(column_name)='value'))"
198377:20201006:164236.214 slow query: 908.529019 sec, "select configid,instanceid from config order by configid"
198377:20201006:164628.936 server #0 started [main process]
198422:20201006:164739.924 server #1 started [configuration syncer #1]
198422:20201006:170752.994 [Z3001] connection to database 'zabbix' failed: [2013] Lost connection to MySQL server at 'reading authorization packet', system error: 11
198422:20201006:170904.920 database is down: reconnecting in 10 seconds
[root@zabbix ~]#

[dimir]

Something is very wrong with your database.

select configid,instanceid from config order by configid

takes 908 seconds, this is insane. This table has always 1 record.

[Buford]

Hiii,

This type of answer have some wrong content. please you have to correct GarageBand For Android