Ad Widget

Collapse

no data in graph + event table full

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • BusteR81
    Senior Member
    • Apr 2007
    • 150

    #1

    no data in graph + event table full

    ALL host's graphS reflected no data after 27 July 15:00. however monitoring -> latest data still show that server + agentd is alive and data are still retreived. from graph, after checking on 500 latest values, no entry after 27 july 15:00 (this would explain the empty graph)

    server's mysqld is alive but data are 'suddenly' stopped recording to dB. i disable monitoring on all hosts and wanted to re-able monitoring on all hosts and i discovered the "EVENT table Full"

    URGENT

    Cheers
    CentOS, Mysql4, Zabbix 1.4.1
    Attached Files
    Last edited by BusteR81; 28-07-2007, 19:52.
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    http://dev.mysql.com/doc/refman/4.1/en/full-table.html
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • BusteR81
      Senior Member
      • Apr 2007
      • 150

      #3
      found the problem

      my.cnf

      prev: innodb_data_file_path = ibdata1:10M:autoextend:max:2000M

      now: innodb_data_file_path = ibdata1:10M:autoextend (default 8M)

      my hard disk is 1.9 GB free therefore mysql cannot write in data anymore (needs 2GB to extend)
      however when i change my.cnf to autoextend by 8M...Zabbix start writing the dB again.

      cheers

      Comment

      Working...