You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:28 UTC
[jira] [Created] (TRAFODION-279) LP Bug: 1320401 - alter table add
constraint primary key got TMF error 97
Alice Chen created TRAFODION-279:
------------------------------------
Summary: LP Bug: 1320401 - alter table add constraint primary key got TMF error 97
Key: TRAFODION-279
URL: https://issues.apache.org/jira/browse/TRAFODION-279
Project: Apache Trafodion
Issue Type: Bug
Reporter: Apache Trafodion
Assignee: Anoop Sharma
Priority: Critical
>>Create Table t2a011
+> (
+> sbin0_10 Numeric(18) signed not null,
+> char0_2 Character(8) not null,
+> udec0_uniq Decimal(9) unsigned not null,
+> ubin0_uniq PIC 9(9) COMP not null,
+> sdec0_500 PIC S9(9) not null,
+> varchar0_10 varchar(16) not null,
+> varchar1_20 varchar(8) not null,
+> sbin1_5000 Numeric(4) signed not null,
+> sdec1_4 Decimal(18) signed not null,
+> char1_4 Character(8) not null
+>
+> )
+> store by (udec0_uniq)
+>;
--- SQL operation complete.
>>
>>-- got ERROR[8606] Transaction subsystem TMF returned error 97 on a commit tra
>>alter table t2a011 add constraint ca011 primary key (ubin0_uniq );
*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit transaction.
--- SQL operation failed with errors.
>>insert into t2a011 values (1,'2',3,4,5,'6','7',8,9,'10');
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::rowExists returned error HBASE_ACCESS_ERROR(-705). Cause:
org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=10, exceptions:
Fri May 16 23:04:34 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.NotServingRegionException: org.apache.hadoop.hbase.NotServingRegionException: Region is not online: TRAFODION.USR.T2A011,,1400281467720.674fb3ac6bb53d2908998325731fa435.
at org.apache.hadoop.hbase.regionserver.HRegionServer.getRegion(HRegionServer.java:3361)
at org.apache.hadoop.hbase.regionserver.HRegionServer.checkAndPut(HRegionServer.java:2191)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320)
at org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428)
Fri May 16 23:04:35 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:04:36 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:04:37 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:04:39 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:04:41 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:04:45 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:04:49 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:04:57 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:13 UTC 2014, org.apache.hadoop.hbase.client.HTable$9@64b99636, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:183)
org.apache.hadoop.hbase.client.HTable.checkAndPut(HTable.java:922)
org.trafodion.sql.HBaseAccess.HTableClient.checkAndInsertRow(HTableClient.java:572)
.
--- 0 row(s) inserted.
>>select * from t2a011;
*** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::scanOpen returned error HBASE_OPEN_ERROR(-703). Cause:
org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=10, exceptions:
Fri May 16 23:05:13 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:14 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:15 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:16 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:18 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:20 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:24 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:28 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:36 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
Fri May 16 23:05:52 UTC 2014, org.apache.hadoop.hbase.client.ScannerCallable@617085fc, org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.USR.T2A011
org.apache.hadoop.hbase.client.ServerCallable.withRetries(ServerCallable.java:183)
org.apache.hadoop.hbase.client.ClientScanner.nextScanner(ClientScanner.java:205)
org.apache.hadoop.hbase.client.ClientScanner.<init>(ClientScanner.java:120)
org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:680)
org.trafodion.sql.HBaseAccess.HTableClient.startScan(HTableClient.java:220)
.
--- 0 row(s) selected.
>>alter table t2a011 drop constraint ca011 ;
*** ERROR[1005] Constraint TRAFODION.USR.CA011 does not exist.
--- SQL operation failed with errors.
>>showddl t2a011;
CREATE TABLE TRAFODION.USR.T2A011
(
SBIN0_10 NUMERIC(18, 0) NO DEFAULT NOT NULL NOT
DROPPABLE
, CHAR0_2 CHAR(8) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, UDEC0_UNIQ DECIMAL(9, 0) UNSIGNED NO DEFAULT NOT NULL
NOT DROPPABLE
, UBIN0_UNIQ NUMERIC(9, 0) UNSIGNED NO DEFAULT NOT NULL
NOT DROPPABLE
, SDEC0_500 DECIMAL(9, 0) NO DEFAULT NOT NULL NOT
DROPPABLE
, VARCHAR0_10 VARCHAR(16) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, VARCHAR1_20 VARCHAR(8) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
, SBIN1_5000 NUMERIC(4, 0) NO DEFAULT NOT NULL NOT
DROPPABLE
, SDEC1_4 DECIMAL(18, 0) NO DEFAULT NOT NULL NOT
DROPPABLE
, CHAR1_4 CHAR(8) CHARACTER SET ISO88591 COLLATE
DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
)
STORE BY (UDEC0_UNIQ ASC)
;
--- SQL operation complete.
>>log off;
>>exit;
End of MXCI Session
[sqws124] /opt/home/yku/datalake_64_1
$
-------------------------------------------------------------------------------
-- test script
-------------------------------------------------------------------------------
set schema usr;
drop table t2a011 cascade;
Create Table t2a011
(
sbin0_10 Numeric(18) signed not null,
char0_2 Character(8) not null,
udec0_uniq Decimal(9) unsigned not null,
ubin0_uniq PIC 9(9) COMP not null,
sdec0_500 PIC S9(9) not null,
varchar0_10 varchar(16) not null,
varchar1_20 varchar(8) not null,
sbin1_5000 Numeric(4) signed not null,
sdec1_4 Decimal(18) signed not null,
char1_4 Character(8) not null
)
store by (udec0_uniq)
;
-- got ERROR[8606] Transaction subsystem TMF returned error 97 on a commit tra
alter table t2a011 add constraint ca011 primary key (ubin0_uniq );
insert into t2a011 values (1,'2',3,4,5,'6','7',8,9,'10');
select * from t2a011;
alter table t2a011 drop constraint ca011 ;
showddl t2a011;
MY_SQROOT=/opt/home/yku/datalake_64_1
who@host=yku@g4t3017.houston.hp.com
JAVA_HOME=/opt/home/tools/jdk1.7.0_21_64
linux=2.6.32-279.el6.x86_64
redhat=6.3
Release 0.7.0 (Build release [40596], branch 40596-project/datalake_64_1, date 16May14)
SQL>version
Trafodion Platform : Release 0.7.0
Trafodion Connectivity Services : Version 1.0.0 Release 0.7.0 (Build release [40596], date 16May14)
Trafodion JDBC Type 4 Driver : Traf_JDBC_Type4_Build_40594
Trafodion Command Interface : TrafCI_Build_40594
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)