Ad Widget

Collapse

Нестабильно работает Zabbix Proxy

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • matrix007
    Junior Member
    • Feb 2016
    • 4

    #1

    Нестабильно работает Zabbix Proxy

    Добрый день!
    Нестабильно работает Zabbix Proxy. Данные на Zabbix Server поступают с потерями.
    В логах Zabbix Proxy следующее:
    Code:
     
      1273:20160208:054930.923 received configuration data from server, datalen 9870
      1272:20160208:055029.163 received configuration data from server, datalen 12513
      1272:20160208:055029.217 failed to update local proxy configuration copy: invalid field name "items.filter"
      1276:20160208:064035.807 executing housekeeper
      1276:20160208:064035.958 housekeeper [deleted 3285 records in 0.150411 sec, idle 3600 sec]
      1273:20160208:064931.659 received configuration data from server, datalen 9870
      1271:20160208:065030.383 received configuration data from server, datalen 12513
      1271:20160208:065030.442 failed to update local proxy configuration copy: invalid field name "items.filter"
      1276:20160208:074038.029 executing housekeeper
      1276:20160208:074038.193 housekeeper [deleted 3287 records in 0.162615 sec, idle 3600 sec]
      1274:20160208:074932.006 received configuration data from server, datalen 9870
      1272:20160208:075030.276 received configuration data from server, datalen 12513
      1272:20160208:075030.337 failed to update local proxy configuration copy: invalid field name "items.filter"
      1276:20160208:084040.158 executing housekeeper
      1276:20160208:084040.274 housekeeper [deleted 3280 records in 0.115113 sec, idle 3600 sec]
      1272:20160208:084932.402 received configuration data from server, datalen 9870
      1273:20160208:085031.004 received configuration data from server, datalen 12513
      1273:20160208:085031.066 failed to update local proxy configuration copy: invalid field name "items.filter"
      1276:20160208:094042.140 executing housekeeper
      1276:20160208:094042.296 housekeeper [deleted 3287 records in 0.154703 sec, idle 3600 sec]
      1274:20160208:094933.500 received configuration data from server, datalen 9870
      1274:20160208:095031.314 received configuration data from server, datalen 12513
      1274:20160208:095031.360 failed to update local proxy configuration copy: invalid field name "items.filter"
    Не могу понять, что ему не нравится? Почему возникает ошибка обновления локальной конфигурации?
    Базу для Zabbix Proxy пересоздавал.
    Версия Zabbix Proxy 2.4.7 (revision 56694)
    Версия Zabbix Server 2.4.7
    Last edited by matrix007; 08-02-2016, 09:52.
  • ableev
    Senior Member
    Zabbix Certified Specialist
    • Oct 2012
    • 276

    #2
    База у прокси на MySQL или SQLite?
    Если MySQL – проверьте, что в таблице items есть поле filter.

    Comment

    • matrix007
      Junior Member
      • Feb 2016
      • 4

      #3
      Originally posted by ableev
      База у прокси на MySQL или SQLite?
      Если MySQL – проверьте, что в таблице items есть поле filter.
      Приветствую! Поля filter нет.
      Code:
      mysql> select * from items;
      
       itemid | type | snmp_community | snmp_oid           | hostid | name | key_               | delay | history | trends | status | value_type | trapper_hosts | units | multiplier | delta | snmpv3_securityname | snmpv3_securitylevel | snmpv3_authpassphrase | snmpv3_privpassphrase | formula | error | lastlogsize | logtimefmt | templateid | valuemapid | delay_flex | params | ipmi_sensor | data_type | authtype | username | password | publickey | privatekey | mtime | flags | interfaceid | port | description | inventory_link | lifetime | snmpv3_authprotocol | snmpv3_privprotocol | state | snmpv3_contextname | evaltype |
      Создавал базу так
      Code:
      # mysql -u root -p zabbix_proxy < /usr/share/doc/zabbix-proxy-mysql-2.4.7/create/schema.sql

      Comment

      • matrix007
        Junior Member
        • Feb 2016
        • 4

        #4
        Originally posted by ableev
        База у прокси на MySQL или SQLite?
        Если MySQL – проверьте, что в таблице items есть поле filter.
        Если смотреть скрипт создания базы, то в скрипте нет поля filter.
        С какими свойствами должно быть это поле?

        Code:
        CREATE TABLE `items` (
        	`itemid`                 bigint unsigned                           NOT NULL,
        	`type`                   integer         DEFAULT '0'               NOT NULL,
        	`snmp_community`         varchar(64)     DEFAULT ''                NOT NULL,
        	`snmp_oid`               varchar(255)    DEFAULT ''                NOT NULL,
        	`hostid`                 bigint unsigned                           NOT NULL,
        	`name`                   varchar(255)    DEFAULT ''                NOT NULL,
        	`key_`                   varchar(255)    DEFAULT ''                NOT NULL,
        	`delay`                  integer         DEFAULT '0'               NOT NULL,
        	`history`                integer         DEFAULT '90'              NOT NULL,
        	`trends`                 integer         DEFAULT '365'             NOT NULL,
        	`status`                 integer         DEFAULT '0'               NOT NULL,
        	`value_type`             integer         DEFAULT '0'               NOT NULL,
        	`trapper_hosts`          varchar(255)    DEFAULT ''                NOT NULL,
        	`units`                  varchar(255)    DEFAULT ''                NOT NULL,
        	`multiplier`             integer         DEFAULT '0'               NOT NULL,
        	`delta`                  integer         DEFAULT '0'               NOT NULL,
        	`snmpv3_securityname`    varchar(64)     DEFAULT ''                NOT NULL,
        	`snmpv3_securitylevel`   integer         DEFAULT '0'               NOT NULL,
        	`snmpv3_authpassphrase`  varchar(64)     DEFAULT ''                NOT NULL,
        	`snmpv3_privpassphrase`  varchar(64)     DEFAULT ''                NOT NULL,
        	`formula`                varchar(255)    DEFAULT ''                NOT NULL,
        	`error`                  varchar(2048)   DEFAULT ''                NOT NULL,
        	`lastlogsize`            bigint unsigned DEFAULT '0'               NOT NULL,
        	`logtimefmt`             varchar(64)     DEFAULT ''                NOT NULL,
        	`templateid`             bigint unsigned                           NULL,
        	`valuemapid`             bigint unsigned                           NULL,
        	`delay_flex`             varchar(255)    DEFAULT ''                NOT NULL,
        	`params`                 text                                      NOT NULL,
        	`ipmi_sensor`            varchar(128)    DEFAULT ''                NOT NULL,
        	`data_type`              integer         DEFAULT '0'               NOT NULL,
        	`authtype`               integer         DEFAULT '0'               NOT NULL,
        	`username`               varchar(64)     DEFAULT ''                NOT NULL,
        	`password`               varchar(64)     DEFAULT ''                NOT NULL,
        	`publickey`              varchar(64)     DEFAULT ''                NOT NULL,
        	`privatekey`             varchar(64)     DEFAULT ''                NOT NULL,
        	`mtime`                  integer         DEFAULT '0'               NOT NULL,
        	`flags`                  integer         DEFAULT '0'               NOT NULL,
        	`interfaceid`            bigint unsigned                           NULL,
        	`port`                   varchar(64)     DEFAULT ''                NOT NULL,
        	`description`            text                                      NOT NULL,
        	`inventory_link`         integer         DEFAULT '0'               NOT NULL,
        	`lifetime`               varchar(64)     DEFAULT '30'              NOT NULL,
        	`snmpv3_authprotocol`    integer         DEFAULT '0'               NOT NULL,
        	`snmpv3_privprotocol`    integer         DEFAULT '0'               NOT NULL,
        	`state`                  integer         DEFAULT '0'               NOT NULL,
        	`snmpv3_contextname`     varchar(255)    DEFAULT ''                NOT NULL,
        	`evaltype`               integer         DEFAULT '0'               NOT NULL,
        	PRIMARY KEY (itemid)

        Comment

        • ableev
          Senior Member
          Zabbix Certified Specialist
          • Oct 2012
          • 276

          #5
          Разобрались в личке.
          Был ещё один сервер, старой версии, который подключался к прокси.
          Решено.

          Comment

          Working...