Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1859

pt-pg-summary fails for Postgres12

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 3.2.0
    • Fix Version/s: 3.2.1
    • Component/s: None
    • Labels:
      None
    • Story Points:
      1
    • Epic Link:
    • Sprint:
      Platform Sprint 20
    • Needs Review:
      Yes
    • Needs QA:
      Yes
    • Needs Packaging:
      No
    • Needs Doc:
      No

      Description

      STR:

      1. Install PG 12
      2. try to run pt-pg-summary
        Given result:
         [root@ip-10-178-0-119 ec2-user]# pt-pg-summary --username=postgres
        INFO[0000] Connecting to the database server using: user=postgres sslmode=disable dbname=postgres 
        INFO[0000] Connection OK                                
        FATA[0000] Cannot create a data collector instance: Cannot get databases list: sql: Scan error on column index 0: unsupported Scan, storing driver.Value type <nil> into type *models.Name 

      Expected result: There is no errors, output looks like:

       [ec2-user@ip-10-178-2-48 ~]$ pt-pg-summary --username=postgres
      INFO[0000] Connecting to the database server using: user=postgres sslmode=disable dbname=postgres 
      INFO[0000] Connection OK                                
      INFO[0000] Detected PostgreSQL version: 11.0.8          
      INFO[0000] Getting global information                   
      INFO[0000] Collecting global counters (1st pass)  .....
      .......

      pt-pg-summary for PG11 works ok

       

       

      see  https://jira.percona.com/browse/PT-1868?focusedCommentId=260363&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-260363  for tech investigation 

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                nailya.kutlubaeva Nailya Kutlubaeva
                Votes:
                4 Vote for this issue
                Watchers:
                5 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: