You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by "Liu, Yuan (Yuan)" <yu...@esgyn.cn> on 2017/05/26 03:27:37 UTC
Initialize trafodion drop will not drop DTM tables
Hi Trafodioners,
I found that when I did 'initialize trafodion, drop' the DTM related tables would not be dropped. Could anyone explain why this happened?
For the feature of 'offline restore', we need to make sure there is no TRAFODION.* table exist in HBase, otherwise the restore will fail. So I am thinking can we have such enhancement that we drop all TRAFODION.* tables when 'initialize trafodion, drop'?
Does that make sense?
[cid:image001.png@01D2D613.12CFB2D0]
[cid:image002.png@01D2D613.12CFB2D0]
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
RE: Initialize trafodion drop will not drop DTM tables
Posted by "Liu, Yuan (Yuan)" <yu...@esgyn.cn>.
Thank you, Prashanth.
TRAFODION-2624 has been created.
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
From: Prashanth Vasudev [mailto:prashanth.vasudev@esgyn.com]
Sent: Friday, May 26, 2017 12:53 PM
To: user@trafodion.incubator.apache.org
Subject: RE: Initialize trafodion drop will not drop DTM tables
Hi Yuan,
Yes, I encourage you to file a JIRA. We have to include TDDL table as well as part of cleanat.
In the mean time as a work around, please drop the table from hbase shell explicitly and you should be able to continue with offline restore.
Regards,
Prashanth
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, May 25, 2017 9:33 PM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: RE: Initialize trafodion drop will not drop DTM tables
Hi Sean,
Thanks for your so quick response. I just tried to use cleanat, it seems that it will only drop DTM LOG. After executing cleanat, there still exists one table: TRAFODION._DTM_.TDDL
So this table will not be dropped by cleanat, right?
[cid:image001.png@01D2D61F.AC84A4B0]
[cid:image002.png@01D2D61F.AC84A4B0]
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, May 26, 2017 11:34 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: RE: Initialize trafodion drop will not drop DTM tables
Hi Yuan,
The reason initialize Trafodion, drop does not drop DTM tables is that the DTM is running and still using them.
I'm not practiced in offline restore. Does it use scripts that don't require Trafodion to be running? Perhaps you can leverage the cleanat script as follows.
initialize Trafodion, drop
sqstop
cleanat
offline restore
sqstart
Regards,
Sean
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, May 25, 2017 8:28 PM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: Initialize trafodion drop will not drop DTM tables
Hi Trafodioners,
I found that when I did 'initialize trafodion, drop' the DTM related tables would not be dropped. Could anyone explain why this happened?
For the feature of 'offline restore', we need to make sure there is no TRAFODION.* table exist in HBase, otherwise the restore will fail. So I am thinking can we have such enhancement that we drop all TRAFODION.* tables when 'initialize trafodion, drop'?
Does that make sense?
[cid:image003.png@01D2D61F.AC84A4B0]
[cid:image004.png@01D2D61F.AC84A4B0]
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
RE: Initialize trafodion drop will not drop DTM tables
Posted by Prashanth Vasudev <pr...@esgyn.com>.
Hi Yuan,
Yes, I encourage you to file a JIRA. We have to include TDDL table as well as part of cleanat.
In the mean time as a work around, please drop the table from hbase shell explicitly and you should be able to continue with offline restore.
Regards,
Prashanth
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, May 25, 2017 9:33 PM
To: user@trafodion.incubator.apache.org
Subject: RE: Initialize trafodion drop will not drop DTM tables
Hi Sean,
Thanks for your so quick response. I just tried to use cleanat, it seems that it will only drop DTM LOG. After executing cleanat, there still exists one table: TRAFODION._DTM_.TDDL
So this table will not be dropped by cleanat, right?
[cid:image002.png@01D2D5A1.30531D50]
[cid:image003.png@01D2D5A1.30531D50]
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, May 26, 2017 11:34 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: RE: Initialize trafodion drop will not drop DTM tables
Hi Yuan,
The reason initialize Trafodion, drop does not drop DTM tables is that the DTM is running and still using them.
I'm not practiced in offline restore. Does it use scripts that don't require Trafodion to be running? Perhaps you can leverage the cleanat script as follows.
initialize Trafodion, drop
sqstop
cleanat
offline restore
sqstart
Regards,
Sean
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, May 25, 2017 8:28 PM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: Initialize trafodion drop will not drop DTM tables
Hi Trafodioners,
I found that when I did 'initialize trafodion, drop' the DTM related tables would not be dropped. Could anyone explain why this happened?
For the feature of 'offline restore', we need to make sure there is no TRAFODION.* table exist in HBase, otherwise the restore will fail. So I am thinking can we have such enhancement that we drop all TRAFODION.* tables when 'initialize trafodion, drop'?
Does that make sense?
[cid:image004.png@01D2D5A1.30531D50]
[cid:image005.png@01D2D5A1.30531D50]
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
RE: Initialize trafodion drop will not drop DTM tables
Posted by "Liu, Yuan (Yuan)" <yu...@esgyn.cn>.
Hi Sean,
Thanks for your so quick response. I just tried to use cleanat, it seems that it will only drop DTM LOG. After executing cleanat, there still exists one table: TRAFODION._DTM_.TDDL
So this table will not be dropped by cleanat, right?
[cid:image003.png@01D2D61B.C142B080]
[cid:image001.png@01D2D61C.3861AF40]
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
From: Sean Broeder [mailto:sean.broeder@esgyn.com]
Sent: Friday, May 26, 2017 11:34 AM
To: user@trafodion.incubator.apache.org
Subject: RE: Initialize trafodion drop will not drop DTM tables
Hi Yuan,
The reason initialize Trafodion, drop does not drop DTM tables is that the DTM is running and still using them.
I'm not practiced in offline restore. Does it use scripts that don't require Trafodion to be running? Perhaps you can leverage the cleanat script as follows.
initialize Trafodion, drop
sqstop
cleanat
offline restore
sqstart
Regards,
Sean
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, May 25, 2017 8:28 PM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: Initialize trafodion drop will not drop DTM tables
Hi Trafodioners,
I found that when I did 'initialize trafodion, drop' the DTM related tables would not be dropped. Could anyone explain why this happened?
For the feature of 'offline restore', we need to make sure there is no TRAFODION.* table exist in HBase, otherwise the restore will fail. So I am thinking can we have such enhancement that we drop all TRAFODION.* tables when 'initialize trafodion, drop'?
Does that make sense?
[cid:image004.png@01D2D61B.C142B080]
[cid:image005.png@01D2D61B.C142B080]
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540
RE: Initialize trafodion drop will not drop DTM tables
Posted by Sean Broeder <se...@esgyn.com>.
Hi Yuan,
The reason initialize Trafodion, drop does not drop DTM tables is that the DTM is running and still using them.
I'm not practiced in offline restore. Does it use scripts that don't require Trafodion to be running? Perhaps you can leverage the cleanat script as follows.
initialize Trafodion, drop
sqstop
cleanat
offline restore
sqstart
Regards,
Sean
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, May 25, 2017 8:28 PM
To: user@trafodion.incubator.apache.org
Subject: Initialize trafodion drop will not drop DTM tables
Hi Trafodioners,
I found that when I did 'initialize trafodion, drop' the DTM related tables would not be dropped. Could anyone explain why this happened?
For the feature of 'offline restore', we need to make sure there is no TRAFODION.* table exist in HBase, otherwise the restore will fail. So I am thinking can we have such enhancement that we drop all TRAFODION.* tables when 'initialize trafodion, drop'?
Does that make sense?
[cid:image001.png@01D2D596.40CC57B0]
[cid:image002.png@01D2D596.40CC57B0]
Best regards,
Yuan
Email: yuan.liu@esgyn.cn<ma...@esgyn.cn>
Cellphone: (+86) 13671935540