Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-3492

Application - Postgresql fails to parse the data

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • Community Edition
    • Unix Agent
    • None
    • Ubuntu 18.04 LTS
      PostgreSQL 12

    Description

      Hello,

      I successfully integrated MySQL and MongoDB application monitorings. However, PostgreSQL with Perl script fails.

      1. Parses the wrong version (Ubuntu 7.4.0-1ubuntu1~18.04.1 becomes version?)
      2. Fails to initialize data from PG.

       

      /usr/lib/observium_agent/local# /usr/lib/observium_agent/local/postgresql.pl
      <<<app-postgresql>>>
      version:7.4
      cCount:0
      tDbs:0
      tUsr:0
      tHst:0
      idle:0
      select:0
      update:0
      delete:0
      other:0
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 161.
      xact_commit:
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 162.
      xact_rollback:
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 163.
      blks_read:
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 164.
      blks_hit:
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 166.
      tup_returned:
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 167.
      tup_fetched:
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 168.
      tup_inserted:
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 169.
      tup_updated:
      Use of uninitialized value in concatenation (.) or string at /usr/lib/observium_agent/local/postgresql.pl line 170.
      tup_deleted:

       

      select version()
      PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit
      

       

       

      Attachments

        1. Selection_384.png
          Selection_384.png
          46 kB
        2. Selection_383.png
          Selection_383.png
          35 kB
        3. Selection_382.png
          Selection_382.png
          26 kB

        Activity

          People

            sid3windr Tom Laermans
            prologas Tomas Andriekus
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: