Ad Widget

Collapse

Front end not working!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • monolithic
    Junior Member
    • May 2009
    • 21

    #1

    Front end not working!

    Hello all,

    I left for the day yesterday and the front-end was working fine and dandy. I go back to the address, new browser on a different machine and nothing comes up, just hanging . . .

    I tailed the /tmp/zabbix_server.log and all i see are a bunch of these:
    10047:20090521:125200 [Z3005] Query failed: [1030] Got error 28 from storage engine [select i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.para ms,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype, h.ipmi_privilege,h.ipmi_username,h.ipmi_password,i .ipmi_sensor,i.lastlogsize from hosts h, items i where i.nextcheck<=1242924725 and h.hostid=i.hostid and h.status=0 and i.status in (0,3) and ((h.disable_until<=1242924720 and h.errors_from=0 and i.type in (0,1,4,6)) or i.type in (3,5,8,10,11)) and (h.proxy_hostid=0 or i.type in (5)) and mod(i.itemid,5)=1 and i.key_ not in ('status','icmpping','icmppingsec','zabbix[log]') and h.hostid between 000000000000000 and 099999999999999 order by i.nextcheck]
    messages.

    I restarted apache, but that didn't help, i am able to browse to a test page in my htdocs folder so i know it's running. I'm at a loss of where to go now, can someone please point me in the right direction? Thanks in advanced!!
  • tchjts1
    Senior Member
    • May 2008
    • 1605

    #2
    If it were me, and I had the DB backed up, I would simply restart all components - Zabbix Server, Zabbix agent on the host, and my DB.

    Comment

    • nelsonab
      Senior Member
      Zabbix Certified SpecialistZabbix Certified Professional
      • Sep 2006
      • 1233

      #3
      It looks like it could be a mysql barf, check the database. See if you can connect to it from the machine which hosts your frontend and server.
      RHCE, author of zbxapi
      Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
      Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

      Comment

      • monolithic
        Junior Member
        • May 2009
        • 21

        #4
        Thanks for your replies guys, I ran out of space on my / directory!

        mysql couldn't write any log files etc. I moved the DBs to /export/home/mysql, restarted mysql, zabbix_server and all looks good!!

        I'm learning a heck of a lot doing this though!!

        Comment

        • nelsonab
          Senior Member
          Zabbix Certified SpecialistZabbix Certified Professional
          • Sep 2006
          • 1233

          #5
          heh... yep that would do it. :-)
          RHCE, author of zbxapi
          Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
          Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

          Comment

          Working...