Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-7316

Many error in pmm-agent log related to wrong PG query

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 2.14.0
    • Fix Version/s: None
    • Component/s: PMM Agent
    • Labels:

      Description

      User impact: User can see many errors in pmm-agent.log

      Steps to reproduce

      1. Add PostgreSQL to monitoring
      2. Connect to PG and execute next queries:
         postgres=# qweqe;
        ERROR:  syntax error at or near "qweqe"
        LINE 1: qweqe;
                ^
        postgres=# sdfsdfdsfdsfsd;
        ERROR:  syntax error at or near "sdfsdfdsfdsfsd"
        LINE 1: sdfsdfdsfdsfsd;
      3. Check pmm-agent.logs
        Actual result: There are many errors like
        ERRO[2021-01-14T10:04:09.001+00:00] syntax error at end of input                  agentID=/agent_id/216c76e6-e979-4975-a6be-357b8f139b47 component=agent-builtin type=qan_postgresql_pgstatmonitor_agent
        ERRO[2021-01-14T10:04:09.002+00:00] syntax error at or near "N"                   agentID=/agent_id/216c76e6-e979-4975-a6be-357b8f139b47 component=agent-builtin type=qan_postgresql_pgstatmonitor_agent
        ERRO[2021-01-14T10:04:09.002+00:00] syntax error at or near "N"                   agentID=/agent_id/216c76e6-e979-4975-a6be-357b8f139b47 component=agent-builtin type=qan_postgresql_pgstatmonitor_agent
        ERRO[2021-01-14T10:04:09.002+00:00] syntax error at or near "N"                   agentID=/agent_id/216c76e6-e979-4975-a6be-357b8f139b47 component=agent-builtin type=qan_postgresql_pgstatmonitor_agent
        ERRO[2021-01-14T10:04:09.002+00:00] syntax error at or near "N"                   agentID=/agent_id/216c76e6-e979-4975-a6be-357b8f139b47 component=agent-builtin type=qan_postgresql_pgstatmonitor_agent
        ERRO[2021-01-14T10:04:09.002+00:00] unterminated quoted string at or near "'in"   agentID=/agent_id/216c76e6-e979-4975-a6be-357b8f139b47 component=agent-builtin type=qan_postgresql_pgstatmonitor_agent
        ERRO[2021-01-14T10:04:09.002+00:00] unterminated quoted string at or near "'in 

        Expected result: There is no such errors

      I checked PG:

       
      postgres=# select query,cpu_sys_time from pg_stat_monitor where query like '%sdfsdfdsfdsfsd%';
            query      | cpu_sys_time 
      -----------------+--------------
       sdfsdfdsfdsfsd; |
      

      It seems all wrong queries are saved in this table

        Attachments

          Activity

            People

            Assignee:
            jiri.ctvrtka Jiří Čtvrtka
            Reporter:
            nailya.kutlubaeva Nailya Kutlubaeva
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Smart Checklist