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

External clickhouse using version > 22.5.2, not working in PMM

Details

    • Yes
    • Yes
    • 3
    • Yes
    • Yes
    • Yes
    • PMM Core
    • Hide
      1. Setup external ClickHouse server
      2. Run PMM Server configured to use external clickhouse with older version and mounted volume. Gather queries.
      3. Move to latest clickhouse image and mount that volume with already gathered metrics.
      4. Run latest clickhouse without mounted volume.

      Test setup repository
      git checkout to clickhouse tag before use with:

      git checkout tags/clickhouse
      
      Show
      Setup external ClickHouse server Run PMM Server configured to use external clickhouse with older version and mounted volume. Gather queries. Move to latest clickhouse image and mount that volume with already gathered metrics. Run latest clickhouse without mounted volume. Test setup repository git checkout to clickhouse tag before use with: git checkout tags/clickhouse

    Description

      Preconditions:

      STR.

      1. Start PMM server with external clickhouse with version > 22.5.2
      2. Navigate to QAN

      Expected result:
      Query Analytics displayed

      Actual Result:
      Error displayed and no queries are available.{}

      How to test:

      1. Setup external ClickHouse server
      2. Run PMM Server configured to use external clickhouse with older version like for example clickhouse/clickhouse-server:22.6.9.11-alpine and with mounted volume to check that users with old data will not suffer from moving to new clickhouse.
      3. Then wait for around 5 minutes when queries is saved and showed up. Then change clickhouse to newer version for example clickhouse/clickhouse-server:22.8.14.53-alpine and use that old volume. There shouldn't be any errors.
      4. Second case is to check that on newly created environment. Run same latest clickhouse without mounted volume. There are also shouldn't be any errors.

      Attachments

        Issue Links

          There are no Sub-Tasks for this issue.

          Activity

            People

              Unassigned Unassigned
              peter.sirotnak Peter Sirotnak (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist