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

pt-pg-summary fails for Postgres12

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 3.2.0
    • 3.2.1
    • None
    • None
    • Yes
    • Yes
    • No
    • No
    • 1

    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 

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist