Ad Widget

Collapse

Проблема: History syncer при остановке службы zabbix_server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • eldar2116
    Junior Member
    • Jun 2018
    • 16

    #1

    Проблема: History syncer при остановке службы zabbix_server

    Доброе время суток. Некоторое время назад начались проблемы во время остановки службы zabbix_server. Остановка службы виснет. Начал копать, выяснилось, что при остановке висит родительский процесс с полной загрузкой одного ядра.
    В логах сервера:

    Code:
      9389:20180602:224217.150 syncing history data... 1.806841%
      9389:20180602:224227.186 syncing history data... 1.834461%
      9389:20180602:224237.335 syncing history data... 1.862082%
      9389:20180602:224247.562 syncing history data... 1.889702%
      9389:20180602:224257.645 syncing history data... 1.917323%
      9389:20180602:224307.025 syncing history data... 1.942641%
      9389:20180602:224317.113 syncing history data... 1.970262%
      9389:20180602:224327.384 syncing history data... 1.997882%
      9389:20180602:224337.317 syncing history data... 2.025503%
      9389:20180602:224347.813 syncing history data... 2.053123%
    В логах при старте сервера:

    Code:
      7708:20180602:191904.738 Starting Zabbix Server. Zabbix 3.4.9 (revision 80550).
      7708:20180602:191904.738 ****** Enabled features ******
      7708:20180602:191904.738 SNMP monitoring:           YES
      7708:20180602:191904.738 IPMI monitoring:           YES
      7708:20180602:191904.738 Web monitoring:            YES
      7708:20180602:191904.738 VMware monitoring:         YES
      7708:20180602:191904.738 SMTP authentication:       YES
      7708:20180602:191904.738 Jabber notifications:      YES
      7708:20180602:191904.738 Ez Texting notifications:  YES
      7708:20180602:191904.738 ODBC:                      YES
      7708:20180602:191904.738 SSH2 support:              YES
      7708:20180602:191904.738 IPv6 support:              YES
      7708:20180602:191904.738 TLS support:               YES
      7708:20180602:191904.738 ******************************
      7708:20180602:191904.738 using configuration file: /etc/zabbix/zabbix_server.conf
      7708:20180602:191904.756 current database version (mandatory/optional): 03040000/03040007
      7708:20180602:191904.756 required mandatory version: 03040000
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [7708]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
      7708:20180602:191906.102 server #0 started [main process]
      7710:20180602:191906.103 server #1 started [configuration syncer #1]
      7711:20180602:191906.103 server #2 started [alerter #1]
      7712:20180602:191906.103 server #3 started [alerter #2]
      7713:20180602:191906.104 server #4 started [alerter #3]
    Вот вырезка старта сервера в большей детализации.
    Code:
     12243:20180602:231340.964 Starting Zabbix Server. Zabbix 3.4.9 (revision 80550).
     12243:20180602:231340.964 ****** Enabled features ******
     12243:20180602:231340.964 SNMP monitoring:           YES
     12243:20180602:231340.964 IPMI monitoring:           YES
     12243:20180602:231340.964 Web monitoring:            YES
     12243:20180602:231340.964 VMware monitoring:         YES
     12243:20180602:231340.964 SMTP authentication:       YES
     12243:20180602:231340.964 Jabber notifications:      YES
     12243:20180602:231340.964 Ez Texting notifications:  YES
     12243:20180602:231340.964 ODBC:                      YES
     12243:20180602:231340.964 SSH2 support:              YES
     12243:20180602:231340.964 IPv6 support:              YES
     12243:20180602:231340.965 TLS support:               YES
     12243:20180602:231340.965 ******************************
     12243:20180602:231340.965 using configuration file: /etc/zabbix/zabbix_server.conf
     12243:20180602:231340.965 In zbx_load_modules()
     12243:20180602:231340.965 End of zbx_load_modules():SUCCEED
     12243:20180602:231340.965 In init_database_cache()
     12243:20180602:231340.965 In zbx_mem_create() param:'HistoryCacheSize' size:33554432
     12243:20180602:231340.965 valid user addresses: [0x7fc66359e170, 0x7fc66559dff0] total size: 33554048
     12243:20180602:231340.965 End of zbx_mem_create()
     12243:20180602:231340.965 In zbx_mem_create() param:'HistoryIndexCacheSize' size:8388608
     12243:20180602:231340.965 valid user addresses: [0x7fc662d9e180, 0x7fc66359dff0] total size: 8388208
     12243:20180602:231340.965 End of zbx_mem_create()
     12243:20180602:231340.965 In init_trend_cache()
     12243:20180602:231340.965 In zbx_mem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize'
     12243:20180602:231340.965 End of zbx_mem_required_size() size:422
     12243:20180602:231340.965 In zbx_mem_create() param:'TrendCacheSize' size:33554432
     12243:20180602:231340.965 valid user addresses: [0x7fc660d9e170, 0x7fc662d9dff0] total size: 33554048
     12243:20180602:231340.965 End of zbx_mem_create()
     12243:20180602:231340.965 End of init_trend_cache()
     12243:20180602:231340.965 End of init_database_cache()
     12243:20180602:231340.965 In init_configuration_cache() size:33554432
     12243:20180602:231340.965 In zbx_mem_create() param:'CacheSize' size:28521268
     12243:20180602:231340.966 valid user addresses: [0x7fc65f26a170, 0x7fc660d9d328] total size: 28520888
     12243:20180602:231340.966 End of zbx_mem_create()
     12243:20180602:231340.966 In zbx_strpool_create()
     12243:20180602:231340.966 In zbx_mem_create() param:'CacheSize' size:5033164
     12243:20180602:231340.966 valid user addresses: [0x7fc65ed9d168, 0x7fc65f269cc0] total size: 5032792
     12243:20180602:231340.966 End of zbx_mem_create()
     12243:20180602:231340.966 End of zbx_strpool_create()
     12243:20180602:231340.966 End of init_configuration_cache()
     12243:20180602:231340.966 In init_selfmon_collector()
     12243:20180602:231340.966 init_selfmon_collector() size:54976
     12243:20180602:231340.966 End of init_selfmon_collector() collector:0x7fc66dc12000
     12243:20180602:231340.966 In zbx_vmware_init()
     12243:20180602:231340.966 In zbx_mem_required_size() size:0 chunks_num:1 descr:'vmware cache size' param:'VMwareCacheSize'
     12243:20180602:231340.966 End of zbx_mem_required_size() size:429
     12243:20180602:231340.966 In zbx_mem_create() param:'VMwareCacheSize' size:33554003
     12243:20180602:231340.966 valid user addresses: [0x7fc65cd9d178, 0x7fc65ed9ce48] total size: 33553616
     12243:20180602:231340.966 End of zbx_mem_create()
     12243:20180602:231340.967 End of zbx_vmware_init()
     12243:20180602:231340.967 In zbx_vc_init()
     12243:20180602:231340.967 In zbx_mem_required_size() size:0 chunks_num:1 descr:'value cache size' param:'ValueCacheSize'
     12243:20180602:231340.967 End of zbx_mem_required_size() size:427
     12243:20180602:231340.967 In zbx_mem_create() param:'ValueCacheSize' size:67108864
     12243:20180602:231340.967 valid user addresses: [0x7fc658d9d170, 0x7fc65cd9cff0] total size: 67108480
     12243:20180602:231340.967 End of zbx_mem_create()
     12243:20180602:231340.967 End of zbx_vc_init()
     12243:20180602:231340.967 In zbx_db_get_database_type()
     12243:20180602:231340.967 In DBconnect() flag:0
     12243:20180602:231340.971 query [txnlev:0] [select oid from pg_type where typname='bytea']
     12243:20180602:231340.972 PostgreSQL Server version: 90505
     12243:20180602:231340.972 query without transaction detected
     12243:20180602:231340.972 query [txnlev:0] [set escape_string_warning to off]
     12243:20180602:231340.972 query [txnlev:0] [show standard_conforming_strings]
     12243:20180602:231340.973 query without transaction detected
     12243:20180602:231340.973 query [txnlev:0] [set bytea_output=escape]
     12243:20180602:231340.973 End of DBconnect():0
     12243:20180602:231340.973 query [txnlev:0] [select userid from users limit 1]
     12243:20180602:231340.974 there is at least 1 record in "users" table
     12243:20180602:231340.974 End of zbx_db_get_database_type():ZBX_DB_SERVER
     12243:20180602:231340.974 In DBcheck_version()
     12243:20180602:231340.974 In DBconnect() flag:0
     12243:20180602:231340.977 query [txnlev:0] [select oid from pg_type where typname='bytea']
     12243:20180602:231340.978 PostgreSQL Server version: 90505
     12243:20180602:231340.978 query without transaction detected
     12243:20180602:231340.978 query [txnlev:0] [set escape_string_warning to off]
     12243:20180602:231340.979 query [txnlev:0] [show standard_conforming_strings]
     12243:20180602:231340.979 query without transaction detected
     12243:20180602:231340.979 query [txnlev:0] [set bytea_output=escape]
     12243:20180602:231340.979 End of DBconnect():0
     12243:20180602:231340.979 query [txnlev:0] [select 1 from information_schema.tables where table_name='dbversion' and table_schema='public']
     12243:20180602:231340.983 query [txnlev:0] [select mandatory,optional from dbversion]
     12243:20180602:231340.983 current database version (mandatory/optional): 03040000/03040007
     12243:20180602:231340.983 required mandatory version: 03040000
     12243:20180602:231340.983 End of DBcheck_version():SUCCEED
     12243:20180602:231340.983 In DBconnect() flag:0
     12243:20180602:231340.987 query [txnlev:0] [select oid from pg_type where typname='bytea']
     12243:20180602:231340.988 PostgreSQL Server version: 90505
     12243:20180602:231340.988 query without transaction detected
     12243:20180602:231340.988 query [txnlev:0] [set escape_string_warning to off]
     12243:20180602:231340.989 query [txnlev:0] [show standard_conforming_strings]
     12243:20180602:231340.989 query without transaction detected
     12243:20180602:231340.989 query [txnlev:0] [set bytea_output=escape]
     12243:20180602:231340.989 End of DBconnect():0
     12243:20180602:231340.989 In DCsync_configuration()
     12243:20180602:231340.989 query [txnlev:0] [select refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends,default_inventory_mode from config order by configid]
     12243:20180602:231340.991 In DCsync_config()
     12243:20180602:231340.991 End of DCsync_config()
     12243:20180602:231340.991 query [txnlev:0] [select hostid,templateid from hosts_templates order by hostid]
     12243:20180602:231340.993 query [txnlev:0] [select globalmacroid,macro,value from globalmacro]
     12243:20180602:231340.994 query [txnlev:0] [select hostmacroid,hostid,macro,value from hostmacro]
     12243:20180602:231340.997 In DCsync_htmpls()
     12243:20180602:231340.998 End of DCsync_htmpls()
     12243:20180602:231340.998 In DCsync_gmacros()
     12243:20180602:231340.998 End of DCsync_gmacros()
     12243:20180602:231340.998 In DCsync_hmacros()
     12243:20180602:231341.003 End of DCsync_hmacros()
     12243:20180602:231341.003 query [txnlev:0] [select hostid,proxy_hostid,host,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,maintenance_status,maintenance_type,maintenance_from,errors_from,available,disable_until,snmp_errors_from,snmp_available,snmp_disable_until,ipmi_errors_from,ipmi_available,ipmi_disable_until,jmx_errors_from,jmx_available,jmx_disable_until,status,name,lastaccess,error,snmp_error,ipmi_error,jmx_error,tls_connect,tls_accept,tls_issuer,tls_subject,tls_psk_identity,tls_psk from hosts where status in (0,1,5,6) and flags<>2]
     12243:20180602:231341.010 query [txnlev:0] [select hostid,inventory_mode from host_inventory]
     12243:20180602:231341.012 In DCsync_hosts()
     12243:20180602:231341.015 End of DCsync_hosts()
     12243:20180602:231341.016 In DCsync_host_inventory()
     12243:20180602:231341.016 End of DCsync_host_inventory()
     12243:20180602:231341.016 query [txnlev:0] [select interfaceid,hostid,type,main,useip,ip,dns,port,bulk from interface]
     12243:20180602:231341.019 query [txnlev:0] [select i.itemid,i.hostid,i.status,i.type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.trapper_hosts,i.logtimefmt,i.params,i.state,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.snmpv3_authprotocol,i.snmpv3_privprotocol,i.snmpv3_contextname,i.lastlogsize,i.mtime,i.history,i.trends,i.inventory_link,i.valuemapid,i.units,i.error,i.jmx_endpoint,i.master_itemid from items i,hosts h where i.hostid=h.hostid and h.status in (0,1) and i.flags<>2]
     12243:20180602:231341.358 query [txnlev:0] [select pp.item_preprocid,pp.itemid,pp.type,pp.params,pp.step from item_preproc pp,items i,hosts h where pp.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by pp.itemid]
     12243:20180602:231341.394 In DCsync_interfaces()
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
    zabbix_server [12243]: ERROR [file:dbconfig.c,line:1999] Something impossible has just happened.
     12243:20180602:231341.401 End of DCsync_interfaces()
     12243:20180602:231341.401 In DCsync_items()
     12243:20180602:231342.351 End of DCsync_items()
     12243:20180602:231342.351 In DCsync_item_preproc()
     12243:20180602:231342.357 End of DCsync_item_preproc()
     12243:20180602:231342.357 query [txnlev:0] [select i.itemid,f.functionid,f.function,f.parameter,t.triggerid 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]
     12243:20180602:231342.392 In DCsync_functions()
     12243:20180602:231342.405 End of DCsync_functions()
     12243:20180602:231342.405 query [txnlev:0] [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 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]
     12243:20180602:231342.455 query [txnlev:0] [select distinct d.triggerid_down,d.triggerid_up from trigger_depends d,triggers t,hosts h,items i,functions f where t.triggerid=d.triggerid_down and t.flags<>2 and h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=d.triggerid_down and h.status in (0,1)]
     12243:20180602:231342.459 query [txnlev:0] [select r.name,e.expressionid,e.expression,e.expression_type,e.exp_delimiter,e.case_sensitive from regexps r,expressions e where r.regexpid=e.regexpid]
     12243:20180602:231342.460 query [txnlev:0] [select actionid,eventsource,evaltype,formula from actions where status=0]
     12243:20180602:231342.460 query [txnlev:0] [select a.actionid,o.recovery from actions a left join operations o on a.actionid=o.actionid where a.status=0 group by a.actionid,o.recovery order by a.actionid]
     12243:20180602:231342.461 query [txnlev:0] [select c.conditionid,c.actionid,c.conditiontype,c.operator,c.value,c.value2 from conditions c,actions a where c.actionid=a.actionid and a.status=0]
     12243:20180602:231342.462 query [txnlev:0] [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)]
     12243:20180602:231342.463 query [txnlev:0] [select correlationid,name,evaltype,formula from correlation where status=0]
     12243:20180602:231342.464 query [txnlev:0] [select cc.corr_conditionid,cc.correlationid,cc.type,cct.tag,cctv.tag,cctv.value,cctv.operator, ccg.groupid,ccg.operator,cctp.oldtag,cctp.newtag from correlation c,corr_condition cc left join corr_condition_tag cct on cct.corr_conditionid=cc.corr_conditionid left join corr_condition_tagvalue cctv on cctv.corr_conditionid=cc.corr_conditionid left join corr_condition_group ccg on ccg.corr_conditionid=cc.corr_conditionid left join corr_condition_tagpair cctp on cctp.corr_conditionid=cc.corr_conditionid where c.correlationid=cc.correlationid and c.status=0]
     12243:20180602:231342.465 query [txnlev:0] [select co.corr_operationid,co.correlationid,co.type from correlation c,corr_operation co where c.correlationid=co.correlationid and c.status=0]
     12243:20180602:231342.466 query [txnlev:0] [select groupid,name from groups]
     12243:20180602:231342.466 In DCsync_triggers()
     12243:20180602:231342.493 End of DCsync_triggers()
     12243:20180602:231342.493 In DCsync_trigdeps()
     12243:20180602:231342.493 End of DCsync_trigdeps()
     12243:20180602:231342.493 In DCsync_expressions()
     12243:20180602:231342.494 End of DCsync_expressions()
     12243:20180602:231342.494 In DCsync_actions()
     12243:20180602:231342.494 End of DCsync_actions()
     12243:20180602:231342.494 In DCsync_action_opss()

    И так висит до 16 часов, пока полностью не пройдет. Альтернатива - убить процесс.

    Конфиг БД:
    pgsql 9.5, 4 ядра, 16 ОЗУ

    Конфиг сервера:
    Версия 3.4.9, 4 ядра, 6 ОЗУ.

    zabbix_server.conf:
    Code:
    LogFile=/var/log/zabbix/zabbix_server.log
    LogFileSize=10
    DebugLevel=3
    PidFile=/var/run/zabbix/zabbix_server.pid
    DBHost=*
    DBName=zabbix_db2
    DBUser=zabbix
    DBPassword=*
    DBPort=5432
    
    StartPollers=100
    StartPollersUnreachable=10
    StartPingers=10
    StartHTTPPollers=10
    StartTimers=1
    StartEscalators=10
    StartVMwareCollectors=10
    VMwareCacheSize=32M
    
    SNMPTrapperFile=/var/log/snmptrap/snmptrap.log
    
    HousekeepingFrequency=4
    MaxHousekeeperDelete=10000
    
    CacheSize=32M
    CacheUpdateFrequency=60
    StartDBSyncers=10
    HistoryCacheSize=32M
    HistoryIndexCacheSize=8M
    TrendCacheSize=32M
    ValueCacheSize=64M
    Timeout=5
    
    AlertScriptsPath=/usr/lib/zabbix/alertscripts
    ExternalScripts=/usr/lib/zabbix/externalscripts
    FpingLocation=/usr/sbin/fping
    Fping6Location=/usr/sbin/fping6
    
    LogSlowQueries=3000
    StartProxyPollers=1

    Пробовал увеличивать кеши, уменьшать. Результат один - если сервер проработает больше 10-20 минут, служба висит.
    Есть идеи? Во время history syncing загрузка сервера БД никакая, ни дисков, ни процов. Где-то натыкался на тему того, что тормозит БД, но нет, не мой случай.
Working...