Ad Widget

Collapse

Ошибка после удаления бинарных логов и оч

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fractal1990
    Senior Member
    • Mar 2016
    • 129

    #1

    Ошибка после удаления бинарных логов и оч

    Ребят, помогите. Решил почистить zabbix

    зашел в mysql сделал use zabbix;

    далее

    Code:
    TRUNCATE TABLE history;
    TRUNCATE TABLE history_str;
    TRUNCATE TABLE history_uint;
    TRUNCATE TABLE history_log;
    потом вручную удалил все бинарные логи и выполнил

    flush logs;

    после сделал apt-get update и apt-get upgrade

    в итоге

    Code:
    Database error
    The frontend does not match Zabbix database. Current database version (mandatory/optional): 0/0. Required mandatory version: 3000000. Contact your system administrator.
    что теперь делать не знаю
  • Fractal1990
    Senior Member
    • Mar 2016
    • 129

    #2
    вот что в логах

    Code:
      1640:20160914:005001.816 Starting Zabbix Server. Zabbix 3.0.4 (revision 61185).
      1640:20160914:005001.816 ****** Enabled features ******
      1640:20160914:005001.816 SNMP monitoring:           YES
      1640:20160914:005001.816 IPMI monitoring:           YES
      1640:20160914:005001.816 Web monitoring:            YES
      1640:20160914:005001.816 VMware monitoring:         YES
      1640:20160914:005001.816 SMTP authentication:       YES
      1640:20160914:005001.816 Jabber notifications:      YES
      1640:20160914:005001.816 Ez Texting notifications:  YES
      1640:20160914:005001.816 ODBC:                      YES
      1640:20160914:005001.816 SSH2 support:              YES
      1640:20160914:005001.816 IPv6 support:              YES
      1640:20160914:005001.816 TLS support:               YES
      1640:20160914:005001.816 ******************************
      1640:20160914:005001.816 using configuration file: /etc/zabbix/zabbix_server.conf
      1640:20160914:005001.821 [Z3005] query failed: [1146] Table 'zabbix.users' doesn't exist [select userid from users limit 1]
      1640:20160914:005001.821 cannot use database "zabbix": database is not a Zabbix database

    Comment

    • Fractal1990
      Senior Member
      • Mar 2016
      • 129

      #3
      расширенный debug

      Code:
        1229:20160914:013458.583 Starting Zabbix Server. Zabbix 3.0.4 (revision 61185).
        1229:20160914:013458.583 ****** Enabled features ******
        1229:20160914:013458.583 SNMP monitoring:           YES
        1229:20160914:013458.583 IPMI monitoring:           YES
        1229:20160914:013458.584 Web monitoring:            YES
        1229:20160914:013458.584 VMware monitoring:         YES
        1229:20160914:013458.584 SMTP authentication:       YES
        1229:20160914:013458.584 Jabber notifications:      YES
        1229:20160914:013458.584 Ez Texting notifications:  YES
        1229:20160914:013458.584 ODBC:                      YES
        1229:20160914:013458.584 SSH2 support:              YES
        1229:20160914:013458.584 IPv6 support:              YES
        1229:20160914:013458.584 TLS support:               YES
        1229:20160914:013458.584 ******************************
        1229:20160914:013458.584 using configuration file: /etc/zabbix/zabbix_server.conf
        1229:20160914:013458.584 In load_modules()
        1229:20160914:013458.584 End of load_modules():SUCCEED
        1229:20160914:013458.584 In init_database_cache()
        1229:20160914:013458.584 In zbx_mem_create() descr:'history cache' param:'HistoryCacheSize' size:268435456
        1229:20160914:013458.584 zbx_shmget() removing existing shm_id:262145
        1229:20160914:013458.584 valid user addresses: [0x7f9085db7170, 0x7f9095db6ff0] total size: 268435072
        1229:20160914:013458.584 End of zbx_mem_create()
        1229:20160914:013458.584 In zbx_mem_create() descr:'history index cache' param:'HistoryIndexCacheSize' size:134217728
        1229:20160914:013458.584 zbx_shmget() removing existing shm_id:294914
        1229:20160914:013458.584 valid user addresses: [0x7f907ddb7180, 0x7f9085db6ff0] total size: 134217328
        1229:20160914:013458.584 End of zbx_mem_create()
        1229:20160914:013458.585 In init_trend_cache()
        1229:20160914:013458.585 In zbx_mem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize'
        1229:20160914:013458.585 End of zbx_mem_required_size() size:422
        1229:20160914:013458.585 In zbx_mem_create() descr:'trend cache' param:'TrendCacheSize' size:134217728
        1229:20160914:013458.585 zbx_shmget() removing existing shm_id:327683
        1229:20160914:013458.585 valid user addresses: [0x7f9075db7170, 0x7f907ddb6ff0] total size: 134217344
        1229:20160914:013458.585 End of zbx_mem_create()
        1229:20160914:013458.585 End of init_trend_cache()
        1229:20160914:013458.585 End of init_database_cache()
        1229:20160914:013458.585 In init_configuration_cache() size:4294967296
        1229:20160914:013458.585 In zbx_mem_create() descr:'configuration cache' param:'CacheSize' size:3650722202
        1229:20160914:013458.585 zbx_shmget() removing existing shm_id:360452
        1229:20160914:013458.585 valid user addresses: [0x7f8f9c41d170, 0x7f9075db6990] total size: 3650721824
        1229:20160914:013458.585 End of zbx_mem_create()
        1229:20160914:013458.585 In zbx_strpool_create()
        1229:20160914:013458.585 In zbx_mem_create() descr:'string pool' param:'CacheSize' size:644245094
        1229:20160914:013458.585 zbx_shmget() removing existing shm_id:393221
        1229:20160914:013458.585 valid user addresses: [0x7f8f75db6168, 0x7f8f9c41c658] total size: 644244720
        1229:20160914:013458.585 End of zbx_mem_create()
        1229:20160914:013458.585 End of zbx_strpool_create()
        1229:20160914:013458.585 End of init_configuration_cache()
        1229:20160914:013458.585 In init_selfmon_collector()
        1229:20160914:013458.586 init_selfmon_collector() size:31096
        1229:20160914:013458.586 zbx_shmget() removing existing shm_id:425990
        1229:20160914:013458.586 End of init_selfmon_collector() collector:0x7f909dbf2000
        1229:20160914:013458.586 In zbx_vc_init()
        1229:20160914:013458.586 In zbx_mem_required_size() size:0 chunks_num:1 descr:'value cache size' param:'ValueCacheSize'
        1229:20160914:013458.586 End of zbx_mem_required_size() size:427
        1229:20160914:013458.586 In zbx_mem_create() descr:'value cache size' param:'ValueCacheSize' size:8388608
        1229:20160914:013458.586 zbx_shmget() removing existing shm_id:458759
        1229:20160914:013458.586 valid user addresses: [0x7f8f755b6170, 0x7f8f75db5ff0] total size: 8388224
        1229:20160914:013458.586 End of zbx_mem_create()
        1229:20160914:013458.586 End of zbx_vc_init()
        1229:20160914:013458.586 In zbx_db_get_database_type()
        1229:20160914:013458.586 In DBconnect() flag:0
        1229:20160914:013458.591 End of DBconnect():0
        1229:20160914:013458.591 query [txnlev:0] [select userid from users limit 1]
        1229:20160914:013458.591 [Z3005] query failed: [1146] Table 'zabbix.users' doesn't exist [select userid from users limit 1]
        1229:20160914:013458.591 cannot select records from "users" table
        1229:20160914:013458.591 End of zbx_db_get_database_type():ZBX_DB_UNKNOWN
        1229:20160914:013458.591 cannot use database "zabbix": database is not a Zabbix database

      Comment

      • Fractal1990
        Senior Member
        • Mar 2016
        • 129

        #4
        Code:
          3914:20160914:122915.011 [Z3005] query failed: [1146] Table 'zabbix.users' doesn't exist [select userid from users limit 1]
          3914:20160914:122915.011 cannot use database "zabbix": database is not a Zabbix database

        Comment

        Working...