[
https://issues.apache.org/jira/browse/TRAFODION-1018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14717289#comment-14717289
]
Suresh Subbiah commented on TRAFODION-1018:
-------------------------------------------
Julie tells me that this problem happens ONLY WHEN both the Hybrid Query Cache
AND the PCode Expr Cache are enabled. If either one is disabled (via CQD), the
problem does not occur.
James Capps (james-capps) wrote on 2015-02-18: #2
Julie tells me that my comment about 20 minutes ago was not accurate. Once she
narrowed down a reproducible test case, she found that the problem happened
when the PCode Expr Cache was *enabled* and the Hybrid Query Cache was disabled.
Julie Thai (julie-y-thai) wrote on 2015-03-03: #3
Installed pcec_hqc_utt on rhel-qa1. Issue does not reproduce.
Changed in trafodion:
status: New → Incomplete
> LP Bug: 1423307 - PCode Expr Cache: alter-table-rename fails, ERROR[8448]
> HBASE_COPY_ERROR(710).
> --------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1018
> URL: https://issues.apache.org/jira/browse/TRAFODION-1018
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Julie Thai
> Assignee: Apache Trafodion
> Priority: Blocker
> Fix For: 1.1 (pre-incubation)
>
>
> On cluster with PCEC_HQC_UTT build:
> >>alter table tab_emp_original_01 rename to tab_emp_new_01;
> *** ERROR[8448] Unable to access Hbase interface. Call to
> ExpHbaseInterface::copy() returned error HBASE_COPY_ERROR(710). Cause:
> org.apache.hadoop.hbase.TableNotFoundException:
> TRAFODION.JULSCH.TAB_EMP_ORIGINAL_01
> org.apache.hadoop.hbase.client.HBaseAdmin.checkTableExistence(HBaseAdmin.java:1033)
> org.apache.hadoop.hbase.client.HBaseAdmin.isTableDisabled(HBaseAdmin.java:1063)
> org.apache.hadoop.hbase.client.HBaseAdmin.isTableDisabled(HBaseAdmin.java:1072)
> org.trafodion.sql.HBaseAccess.HBaseClient.copy(HBaseClient.java:466)
> .
> --- SQL operation failed with errors.
> With HQC disabled:
> >>alter table tab_emp_original_01 rename to tab_emp_new_01;
> *** ERROR[8448] Unable to access Hbase interface. Call to
> ExpHbaseInterface::copy() returned error HBASE_COPY_ERROR(710). Cause:
> org.apache.hadoop.hbase.TableExistsException: TRAFODION.JULSCH.TAB_EMP_NEW_01
> org.apache.hadoop.hbase.client.HBaseAdmin.cloneSnapshot(HBaseAdmin.java:3004)
> org.apache.hadoop.hbase.client.HBaseAdmin.cloneSnapshot(HBaseAdmin.java:2988)
> org.trafodion.sql.HBaseAccess.HBaseClient.copy(HBaseClient.java:470)
> .
> --- SQL operation failed with errors.
> With PCEC and HQC disabled, system-wide:
> SQL>alter table tab_emp_original_01 rename to tab_emp_new_01;
> --- SQL operation complete.
> ====================================
> To reproduce, in sqlci issue:
> create table tab_emp_original_01
> (
> sbin0_10 Numeric(18) signed,
> char0_2 Character(8),
> udec0_uniq Decimal(9) unsigned,
> ubin0_uniq PIC 9(9) COMP,
> sdec0_500 PIC S9(9),
> varchar0_10 varchar(16),
> varchar1_20 varchar(8),
> sbin1_5000 Numeric(4) signed,
> sdec1_4 Decimal(18) signed,
> char1_4 Character(8)
> )
> no partition
> location $DB0002
> ;
> select * from tab_emp_original_01;
> showddl tab_emp_original_01;
> alter table tab_emp_original_01 rename to tab_emp_new_01;
> Assigned to LaunchPad User James Capps
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
