You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/24 04:01:45 UTC
[jira] [Closed] (TRAFODION-279) LP Bug: 1320401 - alter table add
constraint primary key got TMF error 97
[ https://issues.apache.org/jira/browse/TRAFODION-279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Atanu Mishra closed TRAFODION-279.
----------------------------------
Resolution: Fixed
Assignee: (was: Anoop Sharma)
Fix Version/s: 1.0 (pre-incubation)
> 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
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> >>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)