31480:20200519:153413.458 Starting Zabbix Server. Zabbix 5.0.0 (revision 9665d62db0). 31480:20200519:153413.458 ****** Enabled features ****** 31480:20200519:153413.458 SNMP monitoring: YES 31480:20200519:153413.458 IPMI monitoring: YES 31480:20200519:153413.458 Web monitoring: YES 31480:20200519:153413.458 VMware monitoring: YES 31480:20200519:153413.458 SMTP authentication: YES 31480:20200519:153413.458 ODBC: YES 31480:20200519:153413.458 SSH support: YES 31480:20200519:153413.458 IPv6 support: YES 31480:20200519:153413.458 TLS support: YES 31480:20200519:153413.458 ****************************** 31480:20200519:153413.458 using configuration file: /etc/zabbix/zabbix_server.conf 31480:20200519:153413.465 current database version (mandatory/optional): 04020000/04020000 31480:20200519:153413.465 required mandatory version: 05000000 31480:20200519:153413.465 starting automatic database upgrade 31480:20200519:153413.530 completed 0% of database upgrade 31480:20200519:153413.542 completed 1% of database upgrade 31480:20200519:153413.590 completed 2% of database upgrade 31480:20200519:153416.691 completed 3% of database upgrade 31480:20200519:153434.654 slow query: 17.963495 sec, "alter table items drop column lastlogsize" 31480:20200519:153446.561 slow query: 11.900909 sec, "alter table items drop column state" 31480:20200519:153446.566 completed 4% of database upgrade 31480:20200519:153457.776 slow query: 11.209828 sec, "alter table items drop column mtime" 31480:20200519:153509.371 slow query: 11.589564 sec, "alter table items drop column error" 31480:20200519:153509.376 completed 5% of database upgrade 31480:20200519:153509.395 completed 6% of database upgrade 31480:20200519:153509.418 completed 7% of database upgrade 31480:20200519:153509.436 completed 8% of database upgrade 31480:20200519:153509.447 completed 9% of database upgrade 31480:20200519:153509.464 completed 10% of database upgrade 31480:20200519:153509.478 completed 11% of database upgrade 31480:20200519:153509.498 completed 12% of database upgrade 31480:20200519:153509.533 completed 13% of database upgrade 31480:20200519:153509.542 completed 14% of database upgrade 31480:20200519:153509.557 completed 15% of database upgrade 31480:20200519:153509.568 completed 16% of database upgrade 31480:20200519:153509.572 completed 17% of database upgrade 31480:20200519:153509.582 completed 18% of database upgrade 31480:20200519:153509.596 completed 19% of database upgrade 31480:20200519:153509.636 completed 20% of database upgrade 31480:20200519:153509.663 completed 21% of database upgrade 31480:20200519:153509.724 completed 22% of database upgrade 31480:20200519:153509.743 completed 23% of database upgrade 31480:20200519:153509.763 completed 24% of database upgrade 31480:20200519:153509.772 completed 25% of database upgrade 31480:20200519:153509.800 completed 26% of database upgrade 31480:20200519:153509.885 completed 27% of database upgrade 31480:20200519:153509.906 completed 28% of database upgrade 31480:20200519:153509.927 completed 29% of database upgrade 31480:20200519:153509.941 completed 30% of database upgrade 31480:20200519:153513.929 slow query: 3.972193 sec, "alter table `items` modify `key_` varchar(2048) default '' not null" 31480:20200519:153513.933 completed 31% of database upgrade 31480:20200519:153517.789 slow query: 3.855546 sec, "create index items_1 on items (hostid,key_(1021))" 31480:20200519:153523.607 slow query: 5.809220 sec, "alter table `items` add constraint c_items_1 foreign key (`hostid`) references `hosts` (`hostid`) on delete cascade" 31480:20200519:153523.612 completed 32% of database upgrade 31480:20200519:153525.557 completed 33% of database upgrade 31480:20200519:153525.564 completed 34% of database upgrade 31480:20200519:153525.587 completed 35% of database upgrade 31480:20200519:153525.619 completed 36% of database upgrade 31480:20200519:153525.719 completed 37% of database upgrade 31480:20200519:153525.741 completed 38% of database upgrade 31480:20200519:153525.925 completed 39% of database upgrade 31480:20200519:153526.025 completed 40% of database upgrade 31480:20200519:153526.130 completed 41% of database upgrade 31480:20200519:153526.186 completed 42% of database upgrade 31480:20200519:153526.216 completed 43% of database upgrade 31480:20200519:153526.289 completed 44% of database upgrade 31480:20200519:153526.327 completed 45% of database upgrade 31480:20200519:153526.388 completed 46% of database upgrade 31480:20200519:153527.007 completed 47% of database upgrade 31480:20200519:153530.357 slow query: 3.321729 sec, "alter table auditlog modify `resourceid` bigint unsigned" 31480:20200519:153530.362 completed 48% of database upgrade 31480:20200519:153530.718 completed 49% of database upgrade 31480:20200519:153530.729 completed 50% of database upgrade 31480:20200519:153530.846 completed 51% of database upgrade 31480:20200519:153532.171 completed 52% of database upgrade 31480:20200519:153552.123 slow query: 19.791095 sec, "alter table items drop column snmp_community" 31480:20200519:153552.129 completed 53% of database upgrade 31480:20200519:153604.265 slow query: 12.135348 sec, "alter table items drop column snmpv3_securityname" 31480:20200519:153615.925 slow query: 11.654530 sec, "alter table items drop column snmpv3_securitylevel" 31480:20200519:153615.930 completed 54% of database upgrade 31480:20200519:153627.073 slow query: 11.143146 sec, "alter table items drop column snmpv3_authpassphrase" 31480:20200519:153638.709 slow query: 11.630721 sec, "alter table items drop column snmpv3_privpassphrase" 31480:20200519:153638.714 completed 55% of database upgrade 31480:20200519:153650.073 slow query: 11.359308 sec, "alter table items drop column snmpv3_authprotocol" 31480:20200519:153701.290 slow query: 11.211884 sec, "alter table items drop column snmpv3_privprotocol" 31480:20200519:153701.296 completed 56% of database upgrade 31480:20200519:153712.946 slow query: 11.649866 sec, "alter table items drop column snmpv3_contextname" 31480:20200519:153724.592 slow query: 11.640036 sec, "alter table items drop column port" 31480:20200519:153724.597 completed 57% of database upgrade 31480:20200519:153724.618 completed 58% of database upgrade 31480:20200519:153724.628 completed 59% of database upgrade 31480:20200519:153724.650 completed 60% of database upgrade 31480:20200519:153724.667 completed 61% of database upgrade 31480:20200519:153724.680 completed 62% of database upgrade 31480:20200519:153724.692 completed 63% of database upgrade 31480:20200519:153724.717 completed 64% of database upgrade 31480:20200519:153724.737 completed 65% of database upgrade 31480:20200519:153724.774 completed 66% of database upgrade 31480:20200519:153724.836 completed 67% of database upgrade 31480:20200519:153725.367 completed 68% of database upgrade 31480:20200519:153725.401 completed 69% of database upgrade 31480:20200519:153725.433 completed 70% of database upgrade 31480:20200519:153725.459 completed 71% of database upgrade 31480:20200519:153725.479 completed 72% of database upgrade 31480:20200519:153725.500 completed 73% of database upgrade 31480:20200519:153725.523 completed 74% of database upgrade 31480:20200519:153725.534 completed 75% of database upgrade 31480:20200519:153725.558 completed 76% of database upgrade 31480:20200519:153725.581 completed 77% of database upgrade 31480:20200519:153725.605 completed 78% of database upgrade 31480:20200519:153725.636 completed 79% of database upgrade 31480:20200519:153725.718 completed 80% of database upgrade 31480:20200519:153725.797 completed 81% of database upgrade 31480:20200519:153725.837 completed 82% of database upgrade 31480:20200519:153725.908 completed 83% of database upgrade 31480:20200519:153725.927 completed 84% of database upgrade 31480:20200519:153725.996 completed 85% of database upgrade 31480:20200519:153726.088 completed 86% of database upgrade 31480:20200519:153726.165 completed 87% of database upgrade 31480:20200519:153726.234 completed 88% of database upgrade 31480:20200519:153726.328 completed 89% of database upgrade 31480:20200519:153726.410 completed 90% of database upgrade 31480:20200519:153726.491 completed 91% of database upgrade 31480:20200519:153726.515 completed 92% of database upgrade 31480:20200519:153726.593 completed 93% of database upgrade 31480:20200519:153726.667 completed 94% of database upgrade 31480:20200519:153726.737 completed 95% of database upgrade 31480:20200519:153726.760 completed 96% of database upgrade 31480:20200519:153726.788 completed 97% of database upgrade 31480:20200519:153726.810 completed 98% of database upgrade 31480:20200519:153726.832 completed 99% of database upgrade 31480:20200519:153726.837 completed 100% of database upgrade 31480:20200519:153726.837 database upgrade fully completed 31480:20200519:153726.838 Zabbix supports only "utf8" character set. Database "zabbixdb" has default character set "latin1" 31480:20200519:153726.838 Zabbix supports only "utf8_bin" collation. Database "zabbixdb" has default collation "latin1_swedish_ci" 31480:20200519:153726.841 character set name or collation name that is not supported by Zabbix found in 424 column(s) of database "zabbixdb" 31480:20200519:153726.841 only character set "utf8" and collation "utf8_bin" should be used in database 31480:20200519:153726.843 database is not upgraded to use double precision values 31480:20200519:153726.862 server #0 started [main process] 31698:20200519:153726.862 server #1 started [configuration syncer #1] 31698:20200519:153734.405 slow query: 3.062754 sec, "select distinct t.triggerid,t.description,t.expression,t.error,t.priority,t.type,t.value,t.state,t.lastchange,t.status,t.recovery_mode,t.recovery_expression,t.correlation_mode,t.correlation_tag,opdata from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2" 31698:20200519:153748.143 slow query: 13.610104 sec, "select distinct tt.triggertagid,tt.triggerid,tt.tag,tt.value from trigger_tag tt,triggers t,hosts h,items i,functions f where t.triggerid=tt.triggerid and t.flags<>2 and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=tt.triggerid and h.status in (0,1)" 31717:20200519:153750.081 server #2 started [housekeeper #1] 31718:20200519:153750.081 server #3 started [timer #1] 31719:20200519:153750.082 server #4 started [http poller #1] 31720:20200519:153750.082 server #5 started [http poller #2] 31721:20200519:153750.083 server #6 started [http poller #3] 31722:20200519:153750.083 server #7 started [http poller #4] 31723:20200519:153750.083 server #8 started [http poller #5] 31724:20200519:153750.084 server #9 started [http poller #6] 31725:20200519:153750.085 server #10 started [http poller #7] 31726:20200519:153750.085 server #11 started [http poller #8] 31728:20200519:153750.086 server #13 started [http poller #10]