[
https://issues.apache.org/jira/browse/TRAFODION-1644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15026126#comment-15026126
]
Sean Broeder commented on TRAFODION-1644:
-----------------------------------------
I have made changes that are waiting to be merged. The proper way to remove
the TRAFODION._DTM_.* tables is to run the cleanat script in
$MY_SQROOT/sql/scripts.
If run in conjunction with an initialize trafodion, drop, the initialize
trafodion, drop command should be run 1st, then cleanat, then sqstart.
If run as a separate task not in conjunction with an initialize trafodion, drop
- make sure there are no applications altering the database when the command is
issued. As a safety measure cleanat performs an sqstop to ensure there are no
DTM processes running which might expect a TLOG table to be present.
After running cleanat an sqstart is required to restart Trafodion.
> '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)
