Ad Widget

Collapse

column i.nextcheck does not exists

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • schuurs
    Junior Member
    • May 2012
    • 4
    #1

    column i.nextcheck does not exists

    Hello,

    I upgraded the zabbix server form version 1.6.9 to 1.8.13 by following the steps from the manual (including the upgrade of the database).

    After installing the web interface, the zabbix server is started. The database however, is not filled with new data. I checked the log file and it is showing the following errors:
    Code:
    22622:20120516:132632 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  column i.nextcheck does not exist
LINE 1: ... i.type=3 and i.status in (0,3) and h.useip=1 and i.nextchec...
    Code:
    22634:20120516:132633 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  column "ip" does not exist
LINE 1: select dhostid,ip,status,lastup,lastdown from dhosts where d...
    Code:
    22634:20120516:132636 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
[select dserviceid,status,lastup,lastdown,value from dservices where dhostid=2 and type=12 and port=0 and key_='']
    Can someone tell me if I forgot a step?

    Some extra information:

    Code:
    $ whereis zabbix_server
zabbix_server: /usr/local/sbin/zabbix_server
$ /usr/local/sbin/zabbix_server --version
Zabbix Server v1.8.13 (revision 27486) (11 May 2012)
Compilation time: May 16 2012 09:08:38
    postgresql 8.4.6 is installed on the system.
    Tags: None
    • richlv
      Senior Member
      Zabbix Certified Trainer
      Zabbix Certified SpecialistZabbix Certified Professional
      • Oct 2005
      • 3112
      #2
      you are running 1.6 server binary
      Zabbix 3.0 Network Monitoring book

        Comment

        • schuurs
          Junior Member
          • May 2012
          • 4
          #3
          column i.nextcheck does not exists [closed]

          Dear richlv,

          Thank you for mentioning it.
          I was sure that I was running 1.8.13, but the log file is also indicating that I was running an old version.

          Code:
          10345:20120516:080834 ZABBIX Server stopped. ZABBIX 1.6.9 (revision 11108).
 22607:20120516:132632 Starting zabbix_server. ZABBIX 1.6.9 (revision 11108).
          The person who installed zabbix the firsttime, used the fedora repository to install it and the /etc/init.d/zabbix-server was pointing to /usr/sbin/zabbix_server_pgsql instead of the /usr/local/sbin/zabbix_server that I was expecting. After correcting this and restarting the zabbix-server service it was ok. Information was written to the database again.

            Comment

            Previous template Next
            Working...