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

pmm-agent: warnings on Table not found: sql: no rows in result set

Details

    • Bug
    • Status: Open
    • Low
    • Resolution: Unresolved
    • 2.31.0
    • None
    • PMM Agent
    • Yes
    • Yes
    • No
    • C/S Core

    Description

      User impact:

      Warnings in pmm-agent log

      Steps to reproduce:

      Add pg to monitoring
      Go to QAN
      Select a query and Table tab which gives Table not found: sql: no rows in result set
      Check pmm-agent log

      Actual result:

      pmm-client            | WARN[2022-09-07T11:11:24.085+00:00] Action terminated with error: sql: no rows in result set
      pmm-client            | Table not found
      pmm-client            | github.com/percona/pmm/agent/runner/actions.(*postgresqlShowCreateTableAction).printTableInit
      pmm-client            |     /tmp/go/src/github.com/percona/pmm/agent/runner/actions/postgresql_show_create_table_action.go:171
      pmm-client            | github.com/percona/pmm/agent/runner/actions.(*postgresqlShowCreateTableAction).Run
      pmm-client            |     /tmp/go/src/github.com/percona/pmm/agent/runner/actions/postgresql_show_create_table_action.go:114
      pmm-client            | github.com/percona/pmm/agent/runner.(*Runner).handleAction.func1
      pmm-client            |     /tmp/go/src/github.com/percona/pmm/agent/runner/runner.go:236
      pmm-client            | runtime/pprof.Do
      pmm-client            |     /usr/local/go/src/runtime/pprof/runtime.go:40
      pmm-client            | runtime.goexit
      pmm-client            |     /usr/local/go/src/runtime/asm_amd64.s:1571  component=runner id=/action_id/ede16556-ea99-482d-adee-801b51e50ebb type=postgresql-show-create-table
      pmm-client            | INFO[2022-09-07T11:11:24.086+00:00] Action finished.                              component=runner duration=10.892886ms id=/action_id/ede16556-ea99-482d-adee-801b51e50ebb type=postgresql-show-create-table
      pmm-client            | INFO[2022-09-07T11:11:24.088+00:00] Action finished.                              component=runner duration=13.021661ms id=/action_id/907c302b-edf8-440a-a330-f11dc2565f61 type=postgresql-show-index

      Expected result:

      Better error

      Attachments

        Activity

          People

            Unassigned Unassigned
            beata.handzelova1 Beata Handzelova (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Smart Checklist