PCode Expr Cache: alter-table-rename fails, ERROR[8448] HBASE_COPY_ERROR(710).
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Incomplete
|
Critical
|
James Capps |
Bug Description
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 ExpHbaseInterfa
org.apache.
org.apache.
org.apache.
org.apache.
org.trafodion.
.
--- 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 ExpHbaseInterfa
org.apache.
org.apache.
org.apache.
org.trafodion.
.
--- 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_
showddl tab_emp_
alter table tab_emp_original_01 rename to tab_emp_new_01;
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.