PCode Expr Cache: alter-table-rename fails, ERROR[8448] HBASE_COPY_ERROR(710).

[Julie Thai]

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;

[James Capps (james-capps)]

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)]

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)]

Installed pcec_hqc_utt on rhel-qa1. Issue does not reproduce.