phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-2696) Major compaction generating wrong guideposts
Date Fri, 19 Feb 2016 16:23:18 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-2696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

James Taylor updated PHOENIX-2696:
----------------------------------
    Assignee: Ankit Singhal

> Major compaction generating wrong guideposts
> --------------------------------------------
>
>                 Key: PHOENIX-2696
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2696
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Mujtaba Chohan
>            Assignee: Ankit Singhal
>            Priority: Minor
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-2696.patch
>
>
> With empty stats table. _Update Statistics_ correctly generate no guideposts in SYSTEM.STATS
table for a table containing 0 rows (this table is major compacted after 200K rows upserted/deleted)
> Again with empty stats table, after _major compaction_ of this table, following stats
are generated. These stats are generated even after multiple major compactions (guidepost
width is set to 5M)
> {code}
> +---------------------+----------------+-----------------+--------------------+--------------------------+------------------------+
> |    PHYSICAL_NAME    | COLUMN_FAMILY  | GUIDE_POST_KEY  | GUIDE_POSTS_WIDTH  |  LAST_STATS_UPDATE_TIME
 | GUIDE_POSTS_ROW_COUNT  |
> +---------------------+----------------+-----------------+--------------------+--------------------------+------------------------+
> | PERFORMANCE_200000  |                |                 | null               | 2016-02-19
01:02:50.706  | null                   |
> | PERFORMANCE_200000  | STATS          | [B@21526f6c     | 5000063            |     
                    | 69100                  |
> | PERFORMANCE_200000  | STATS          | [B@49f5c307     | 5000010            |     
                    | 68975                  |
> | PERFORMANCE_200000  | USAGE          | [B@299266e2     | 5000060            |     
                    | 81022                  |
> | PERFORMANCE_200000  | USAGE          | [B@5471388b     | 5000064            |     
                    | 78177                  |
> | PERFORMANCE_200000  | USAGE          | [B@66ea1466     | 5000066            |     
                    | 80568                  |
> | PERFORMANCE_200000  | USAGE          | [B@1601e47      | 5000020            |     
                    | 78600                  |
> | PERFORMANCE_200000  | USAGE          | [B@3bffddff     | 5000019            |     
                    | 80377                  |
> | PERFORMANCE_200000  | USAGE          | [B@66971f6b     | 5000016            |     
                    | 78591                  |
> +---------------------+----------------+-----------------+--------------------+--------------------------+------------------------+
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message