You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2016/02/02 21:04:39 UTC

[jira] [Commented] (TRAFODION-1801) Inserting NULL for all key columns in a table causes a failure

    [ https://issues.apache.org/jira/browse/TRAFODION-1801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15128917#comment-15128917 ] 

Suresh Subbiah commented on TRAFODION-1801:
-------------------------------------------

The jstack at the time of failure (manifested as hang which may ebentually fail) is

	at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:147)
	- locked <0x00000000f6074db8> (a org.apache.hadoop.hbase.client.RpcRetryingCaller)
	at org.apache.hadoop.hbase.client.HTable.checkAndPut(HTable.java:1174)
	at org.apache.hadoop.hbase.client.transactional.TransactionalTable.checkAndPut(TransactionalTable.java:833)
	at org.apache.hadoop.hbase.client.transactional.RMInterface.checkAndPut(RMInterface.java:451)
	at org.trafodion.sql.HTableClient.putRow(HTableClient.java:1548)
	at org.trafodion.sql.HBaseClient.insertRow(HBaseClient.java:1634)


> Inserting NULL for all key columns in a table causes a failure
> --------------------------------------------------------------
>
>                 Key: TRAFODION-1801
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1801
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>    Affects Versions: 1.2-incubating
>            Reporter: Suresh Subbiah
>            Assignee: Suresh Subbiah
>             Fix For: 2.0-incubating
>
>
> cqd allow_nullable_unique_key_constraint 'on' ;
> >>create table t1 (a int, b int, primary key (a,b)) ;
> --- SQL operation complete.
> >>showddl t1 ;
> CREATE TABLE TRAFODION.JIRA.T1
>   (
>     A                                INT DEFAULT NULL SERIALIZED
>   , B                                INT DEFAULT NULL SERIALIZED
>   , PRIMARY KEY (A ASC, B ASC)
>   )
> ;
> --- SQL operation complete.
> >>insert into t1(a) values (1);
> --- 1 row(s) inserted.
> >>insert into t1(b) values (2) ;
> --- 1 row(s) inserted.
> >>select * from t1 ;
> A            B          
> -----------  -----------
>           1            ?
>           ?            2
> --- 2 row(s) selected.
> >>insert into t1(a) values(3) ;
> --- 1 row(s) inserted.
> >>select * from t1 ;
> A            B          
> -----------  -----------
>           1            ?
>           3            ?
>           ?            2
> --- 3 row(s) selected.
> -- fails
> >>insert into t1 values (null, null) ;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)