[PHOENIX-2696] Major compaction generating wrong guideposts

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.7.0
• Assignee: Ankit Singhal
• Reporter: Mujtaba Chohan
• Created: 19/Feb/16 01:14
• Updated: 20/Feb/16 00:19
• Resolved: 20/Feb/16 00:19

Description

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)

+---------------------+----------------+-----------------+--------------------+--------------------------+------------------------+
|    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                  |
+---------------------+----------------+-----------------+--------------------+--------------------------+------------------------+