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

Metric Writing Blocks Time not returned

    XMLWordPrintable

    Details

    • Needs QA:
      Yes

      Description

      STR:

      Start AWS instance without postgresql pass parameter

      ssh into the host and start postgresql instance
      bash /srv/pmm-qa/pmm-tests/pmm-framework.sh --addclient=pgsql,1 --pmm2 --download
      pmm-admin list

      Connect to the docker instance for postgresql
      docker ps
      docker exec -it PGSQL_10.8__1 /bin/bash

      inside docker run
      psql -U postgres

      After connection is succesful
      ALTER SYSTEM SET track_io_timing=ON;
      SELECT pg_reload_conf();
      \q

      exit from docker too

      Run basic PostgreSQL load
      bash -x /srv/pmm-qa/pmm-tests/pmm-framework.sh --run-load-pmm2

      Run sysbench on one of the DB's created above
      sysbench --db-driver=pgsql --oltp-table-size=100000 --oltp-tables-count=24 --threads=1 --pgsql-db=db1 --pgsql-user=postgres --pgsql-host=localhost /usr/share/sysbench/tests/include/oltp_legacy/parallel_prepare.lua run

      sysbench --db-driver=pgsql --report-interval=2 --oltp-table-size=100000 --oltp-tables-count=24 --threads=32 --time=60 --pgsql-host=localhost --pgsql-port=5432 --pgsql-user=postgres --pgsql-db=db1 /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua run

      Open QAN
      Select insert or update query

      Expected result:
      We should see Writing Blocks Time metric (blk_write_time) 

      Actual result:
      blk_write_time not returned

      Related to https://jira.percona.com/browse/PMM-5839

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              beata.handzelova Beata Handzelova
              Reporter:
              beata.handzelova Beata Handzelova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Smart Checklist