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

Ordinary clickhouse engine should be updated to Atomic after upgrading PMM to version 2.41.0

    XMLWordPrintable

Details

    • Bug
    • Status: Ready for QA
    • Medium
    • Resolution: Unresolved
    • 2.39.0
    • 2.41.1
    • PMM Server
    • Yes
    • 1
    • Yes
    • Yes
    • No
    • No
    • Hide

      run PMM Server older then 2.38.0 or older
      upgrade PMM Server to 2.41.0 or later
      setup clickhouse-client
      run command:

      clickhouse-client --query 'SELECT * FROM system.databases' | grep pmm | tr -s '[:blank:]' '\\n'
      Show
      run PMM Server older then 2.38.0 or older upgrade PMM Server to 2.41.0 or later setup clickhouse-client run command: clickhouse-client --query 'SELECT * FROM system.databases' | grep pmm | tr -s '[:blank:]' '\\n'
    • -

    Description

      1. run PMM Server older then 2.38.0 or older
      2. upgrade PMM Server to 2.41.0 or later
      3. setup clickhouse-client
      4. run command
      clickhouse-client --query 'SELECT * FROM system.databases' | grep pmm | tr -s '[:blank:]' '\\n'

      Expected result:

       

      ┌─name────┬─engine───┬─data_path─────────────────┬─metadata_path───────────────────────────────────────────────────┬─────────────────────────────────uuid─┐
│ pmm     │ Atomic   │ /srv/clickhouse/store/    │ /srv/clickhouse/store/4ec/4ecfeacf-be41-46db-a760-facabc8d2494/ │ 4ecfeacf-be41-46db-a760-facabc8d2494 │

       
      Actual result:

      ┌─name────┬─engine───┬─data_path─────────────────┬─metadata_path───────────────────────────────────────────────────┬─────────────────────────────────uuid─┐
│ pmm     │ Ordinary │ /srv/clickhouse/data/pmm/ │ /srv/clickhouse/metadata/pmm/                                   │ 00000000-0000-0000-0000-000000000000 │

      Note: there might be a delay.

       

      Suggested implementation:
      Create file in /srv/clickouse/flags/
      https://kb.altinity.com/engines/altinity-kb-atomic-database-engine/how-to-convert-ordinary-to-atomic/ 

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. PMM-10391 External clickhouse using version > 22.5.2, not working in PMM

          • Medium - Important issues that need attention but do not significantly disrupt the system's core functionality.
          • Done
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. PMM-12223 Update Clickhouse to v22.8 or later

          • Medium - Important issues that need attention but do not significantly disrupt the system's core functionality.
          • Pending Release

          Activity

            People

              Unassigned Unassigned
              vadym.yarosh Vadym Yarosh
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Smart Checklist