Ad Widget

Collapse

Problems with zabbix 1.8.2

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • toxot
    Junior Member
    • Jul 2009
    • 13

    #1

    Problems with zabbix 1.8.2

    Good evening.

    I'm install zabbix 1.8.2

    From old version (1.8) i export several templates and config hosts. In attempt to enter to the monitoring-overview and try to see data i see the following error.

    error in query [select distinct h.hostid, h.host,i.itemid, i.key_, i.value_type, i.lastvalue, i.units, i.description, t.priority, i.valuemapid, t.value as tr_value, t.triggerid from hosts h, items i left join functions f on f.itemid=i.itemid left join triggers t on t.triggerid=f.triggerid and t.status=0 where (h.hostid in (10089,10088,10087,10063)) and h.status=0 and h.hostid=i.hostid and i.status=0 order by i.description,i.itemid] [incorrect key file for table '/var/tmp/#sql312_10b_3.myi'; try to repair it]
    mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:544]
    mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/www/zabbix/include/db.inc.php:546]
    I can not understand what the reason of this, base didn't broken.
    I already try to delete templates that i exported. Then situation has not changed. Moreover, this error shows in several groups. Groups haven't difference ( hosts have identical templates).

    I needs help of specialists.

    Thanks in advance
  • toxot
    Junior Member
    • Jul 2009
    • 13

    #2
    Maybe this can help to solve this problem.
    Please anyone answer, why i see this error.

    mysql conf

    Code:
    [mysqld]
    server-id = 1
    big-tables
    set-variable = back_log=150
    default_table_type = INNODB
    log-bin
    default-character-set = utf8
    tmpdir = /tmp
    
    set-variable = expire_logs_days=3
    set-variable = max_binlog_size=1024M
    
    set-variable = max_allowed_packet=32777216
    set-variable = net_buffer_length=32768
    innodb_buffer_pool_size = 400M
    innodb_flush_log_at_trx_commit = 0
    table_cache = 256
    thread_cache = 16
    innodb_file_per_table = 1
    
    [mysqldump]
    set-variable = add-locks=FALSE
    
    [client]
    default-character-set = utf8
    Attached Files

    Comment

    Working...