[
https://issues.apache.org/jira/browse/PHOENIX-808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15425406#comment-15425406
]
Samarth Jain commented on PHOENIX-808:
--------------------------------------
Agreed on not snapshotting the system.sequence table as we could end up losing
increments on sequence values. Any reason why we shouldn't SYSTEM.STATS table?
What if the upgrade for SYSTEM.STATS fails? For ex - when we changed the schema
back in 4.3 for the SYSTEM.STATS table:
{code}
metaConnection = addColumnsIfNotExists(
metaConnection,
SYSTEM_STATS_NAME,
MetaDataProtocol.MIN_SYSTEM_TABLE_TIMESTAMP,
PhoenixDatabaseMetaData.GUIDE_POSTS_ROW_COUNT + " "
+
PLong.INSTANCE.getSqlTypeName());
{code}
> Create snapshot of system tables prior to upgrade and restore on any failure
> ----------------------------------------------------------------------------
>
> Key: PHOENIX-808
> URL: https://issues.apache.org/jira/browse/PHOENIX-808
> Project: Phoenix
> Issue Type: Task
> Reporter: James Taylor
> Assignee: Samarth Jain
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
