You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anoop Sharma (JIRA)" <ji...@apache.org> on 2015/11/23 17:16:11 UTC
[jira] [Commented] (TRAFODION-1644) 'initialize trafodion,drop'
doesn't drop _DTM_ objects
[ https://issues.apache.org/jira/browse/TRAFODION-1644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15022374#comment-15022374 ]
Anoop Sharma commented on TRAFODION-1644:
-----------------------------------------
This is not a bug but is the intended behavior.
Dtm log files cannot be removed without stopping the instance or
it can cause inconsistencies and recovery issues if a crash occurs.
So the drop code explicitly excludes these files.
In face, we initially used to drop all trafodion.* files during "initialize sql, drop",
but then later changed it to not drop dtm logs.
To remove these log files, one need to stop the instance and then use
hbase to remove them.
Please do not 'fix' it without consulting with dtm folks.
> 'initialize trafodion,drop' doesn't drop _DTM_ objects
> ------------------------------------------------------
>
> Key: TRAFODION-1644
> URL: https://issues.apache.org/jira/browse/TRAFODION-1644
> Project: Apache Trafodion
> Issue Type: Bug
> Components: db-utility-backup-restore, sql-general
> Affects Versions: 2.0-incubating
> Reporter: Gao, Rui-Xian
> Assignee: Suresh Subbiah
> Priority: Minor
>
> currently, 'initialize trafodion, drop' doesn't drop all TRAFODION objects, we need cleanup _DTM_ objects from hbase shell.
> >>initialize trafodion, drop;
> --- SQL operation complete.
> hbase(main):002:0> list 'TRAFODION.*'
> TABLE
> TRAFODION._DTM_.TLOG0_CONTROL_POINT
> TRAFODION._DTM_.TLOG0_LOG_0
> TRAFODION._DTM_.TLOG0_LOG_1
> TRAFODION._DTM_.TLOG0_LOG_2
> TRAFODION._DTM_.TLOG0_LOG_3
> TRAFODION._DTM_.TLOG0_LOG_4
> TRAFODION._DTM_.TLOG0_LOG_5
> TRAFODION._DTM_.TLOG0_LOG_6
> TRAFODION._DTM_.TLOG0_LOG_7
> TRAFODION._DTM_.TLOG0_LOG_8
> TRAFODION._DTM_.TLOG0_LOG_9
> TRAFODION._DTM_.TLOG0_LOG_a
> TRAFODION._DTM_.TLOG0_LOG_b
> TRAFODION._DTM_.TLOG0_LOG_c
> TRAFODION._DTM_.TLOG0_LOG_d
> TRAFODION._DTM_.TLOG0_LOG_e
> TRAFODION._DTM_.TLOG0_LOG_f
> TRAFODION._DTM_.TLOG1_CONTROL_POINT
> TRAFODION._DTM_.TLOG1_LOG_0
> TRAFODION._DTM_.TLOG1_LOG_1
> TRAFODION._DTM_.TLOG1_LOG_2
> TRAFODION._DTM_.TLOG1_LOG_3
> TRAFODION._DTM_.TLOG1_LOG_4
> TRAFODION._DTM_.TLOG1_LOG_5
> TRAFODION._DTM_.TLOG1_LOG_6
> TRAFODION._DTM_.TLOG1_LOG_7
> TRAFODION._DTM_.TLOG1_LOG_8
> TRAFODION._DTM_.TLOG1_LOG_9
> TRAFODION._DTM_.TLOG1_LOG_a
> TRAFODION._DTM_.TLOG1_LOG_b
> TRAFODION._DTM_.TLOG1_LOG_c
> TRAFODION._DTM_.TLOG1_LOG_d
> TRAFODION._DTM_.TLOG1_LOG_e
> TRAFODION._DTM_.TLOG1_LOG_f
> TRAFODION._DTM_.TLOG2_CONTROL_POINT
> TRAFODION._DTM_.TLOG2_LOG_0
> TRAFODION._DTM_.TLOG2_LOG_1
> TRAFODION._DTM_.TLOG2_LOG_2
> TRAFODION._DTM_.TLOG2_LOG_3
> TRAFODION._DTM_.TLOG2_LOG_4
> TRAFODION._DTM_.TLOG2_LOG_5
> TRAFODION._DTM_.TLOG2_LOG_6
> TRAFODION._DTM_.TLOG2_LOG_7
> TRAFODION._DTM_.TLOG2_LOG_8
> TRAFODION._DTM_.TLOG2_LOG_9
> TRAFODION._DTM_.TLOG2_LOG_a
> TRAFODION._DTM_.TLOG2_LOG_b
> TRAFODION._DTM_.TLOG2_LOG_c
> TRAFODION._DTM_.TLOG2_LOG_d
> TRAFODION._DTM_.TLOG2_LOG_e
> TRAFODION._DTM_.TLOG2_LOG_f
> 51 row(s) in 0.0320 seconds
> => ["TRAFODION._DTM_.TLOG0_CONTROL_POINT", "TRAFODION._DTM_.TLOG0_LOG_0", "TRAFODION._DTM_.TLOG0_LOG_1", "TRAFODION._DTM_.TLOG0_LOG_2", "TRAFODION._DTM_.TLOG0_LOG_3", "TRAFODION._DTM_.TLOG0_LOG_4", "TRAFODION._DTM_.TLOG0_LOG_5", "TRAFODION._DTM_.TLOG0_LOG_6", "TRAFODION._DTM_.TLOG0_LOG_7", "TRAFODION._DTM_.TLOG0_LOG_8", "TRAFODION._DTM_.TLOG0_LOG_9", "TRAFODION._DTM_.TLOG0_LOG_a", "TRAFODION._DTM_.TLOG0_LOG_b", "TRAFODION._DTM_.TLOG0_LOG_c", "TRAFODION._DTM_.TLOG0_LOG_d", "TRAFODION._DTM_.TLOG0_LOG_e", "TRAFODION._DTM_.TLOG0_LOG_f", "TRAFODION._DTM_.TLOG1_CONTROL_POINT", "TRAFODION._DTM_.TLOG1_LOG_0", "TRAFODION._DTM_.TLOG1_LOG_1", "TRAFODION._DTM_.TLOG1_LOG_2", "TRAFODION._DTM_.TLOG1_LOG_3", "TRAFODION._DTM_.TLOG1_LOG_4", "TRAFODION._DTM_.TLOG1_LOG_5", "TRAFODION._DTM_.TLOG1_LOG_6", "TRAFODION._DTM_.TLOG1_LOG_7", "TRAFODION._DTM_.TLOG1_LOG_8", "TRAFODION._DTM_.TLOG1_LOG_9", "TRAFODION._DTM_.TLOG1_LOG_a", "TRAFODION._DTM_.TLOG1_LOG_b", "TRAFODION._DTM_.TLOG1_LOG_c", "TRAFODION._DTM_.TLOG1_LOG_d", "TRAFODION._DTM_.TLOG1_LOG_e", "TRAFODION._DTM_.TLOG1_LOG_f", "TRAFODION._DTM_.TLOG2_CONTROL_POINT", "TRAFODION._DTM_.TLOG2_LOG_0", "TRAFODION._DTM_.TLOG2_LOG_1", "TRAFODION._DTM_.TLOG2_LOG_2", "TRAFODION._DTM_.TLOG2_LOG_3", "TRAFODION._DTM_.TLOG2_LOG_4", "TRAFODION._DTM_.TLOG2_LOG_5", "TRAFODION._DTM_.TLOG2_LOG_6", "TRAFODION._DTM_.TLOG2_LOG_7", "TRAFODION._DTM_.TLOG2_LOG_8", "TRAFODION._DTM_.TLOG2_LOG_9", "TRAFODION._DTM_.TLOG2_LOG_a", "TRAFODION._DTM_.TLOG2_LOG_b", "TRAFODION._DTM_.TLOG2_LOG_c", "TRAFODION._DTM_.TLOG2_LOG_d", "TRAFODION._DTM_.TLOG2_LOG_e", "TRAFODION._DTM_.TLOG2_LOG_f"]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)