Ad Widget

Collapse

Zabbix 6.2.3 PGSQL DB error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dissmissed
    Junior Member
    • Mar 2021
    • 11

    #1

    Zabbix 6.2.3 PGSQL DB error

    hi everyone, i apoligies for my bad english..

    we create a new zabbix server and follow logs ;

    [select i.itemid,a.name from applications a,items_applications i where a.applicationid=i.applicationid and i.itemid=23274]
    265:20221202:081655.092 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: relation "applications" does not exist
    LINE 1: select i.itemid,a.name from applications a,items_application...

    when i compare zabbix server v5 web ui it's seen there Click image for larger version

Name:	image.png
Views:	188
Size:	4.1 KB
ID:	455341

    and in zabbix 6.2.3 not there Click image for larger version

Name:	image.png
Views:	176
Size:	4.0 KB
ID:	455342

    how to fix this error?​
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    yes.. Applications were converted to tags.
    I suppose that is a frontend query... are you trying to use v5 frontend with v6 DB? Otherwise I would not see any case to have such query...

    Comment

    • dissmissed
      Junior Member
      • Mar 2021
      • 11

      #3
      hi.. no,there are we installed the zabbix server 6.2.3postgresql and 6.2.3 proxy postgresql

      Comment

      • cyber
        Senior Member
        Zabbix Certified SpecialistZabbix Certified Professional
        • Dec 2006
        • 4807

        #4
        Running frontend on same host? Also installed zabbix-web-pgsql package?

        Comment

        • dissmissed
          Junior Member
          • Mar 2021
          • 11

          #5
          Hello, yes the infrastructure build with docker and the packages like in the following line;

          timescaledb-pg13:2.7.2
          zabbix-server-pgsql:ubuntu-6.2.3
          zabbix-web-apache-pgsql:6.2.3​

          Here is a full log line;

          [select i.itemid,a.name from applications a,items_applications i where a.applicationid=i.applicationid and i.itemid=50999]
          266:20221206:121600.638 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: relation "applications" does not exist
          LINE 1: select i.itemid,a.name from applications a,items_application...

          It's a fresh installation and we know in zabbix 6 there is no more applications.

          This log occurs a few times in just a one second. So disks are quickly getting bigger..

          Need your help​

          Comment

          Working...