[jira] [Commented] (TRAFODION-1858) RI predicate generating string should not contain _SALT_ column

2016-02-27 Thread liu ming (JIRA) 

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

liu ming commented on TRAFODION-1858:
-

in core/sql/optimizer/BindRI.cpp
RefConstraint::getPredicateText()
one should check the column name, if it is "_SALT_", ignore it.
I assume there are other 'hidden' column as well. Need to get a list of them.

> RI predicate generating string should not contain _SALT_ column
> ---
>
> Key: TRAFODION-1858
> URL: https://issues.apache.org/jira/browse/TRAFODION-1858
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: liu ming
>Assignee: liu ming
>
> When table created with SALT, it cannot be used in a foreign key reference.
> To reproduce:
> >>CREATE TABLE a ( id int not null, PRIMARY KEY (id))SALT USING 9 PARTITIONS;
> --- SQL operation complete.
> >>CREATE TABLE b ( id int not null, val int,
> +>  PRIMARY KEY (id),
> +>  CONSTRAINT FK FOREIGN KEY (val) REFERENCES a (id))
> +>SALT USING 9 PARTITIONS;
> --- SQL operation complete.
> >>INSERT INTO a values(1);
> --- 1 row(s) inserted.
> >>INSERT INTO b values(1,1);
> *** ERROR[15001] A syntax error occurred at or before: 
> ("NEW@".VAL)=(TRAFODION.SEABASE.A."_SALT_",TRAFODION.SEABASE.A.ID);
>   ^ (43 characters from start of SQL 
> statement)
> *** ERROR[8822] The statement was not prepared.



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

[jira] [Assigned] (TRAFODION-1858) RI predicate generating string should not contain _SALT_ column

2016-02-27 Thread liu ming (JIRA) 

 [ 
https://issues.apache.org/jira/browse/TRAFODION-1858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liu ming reassigned TRAFODION-1858:
---

Assignee: liu ming

> RI predicate generating string should not contain _SALT_ column
> ---
>
> Key: TRAFODION-1858
> URL: https://issues.apache.org/jira/browse/TRAFODION-1858
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: liu ming
>Assignee: liu ming
>
> When table created with SALT, it cannot be used in a foreign key reference.
> To reproduce:
> >>CREATE TABLE a ( id int not null, PRIMARY KEY (id))SALT USING 9 PARTITIONS;
> --- SQL operation complete.
> >>CREATE TABLE b ( id int not null, val int,
> +>  PRIMARY KEY (id),
> +>  CONSTRAINT FK FOREIGN KEY (val) REFERENCES a (id))
> +>SALT USING 9 PARTITIONS;
> --- SQL operation complete.
> >>INSERT INTO a values(1);
> --- 1 row(s) inserted.
> >>INSERT INTO b values(1,1);
> *** ERROR[15001] A syntax error occurred at or before: 
> ("NEW@".VAL)=(TRAFODION.SEABASE.A."_SALT_",TRAFODION.SEABASE.A.ID);
>   ^ (43 characters from start of SQL 
> statement)
> *** ERROR[8822] The statement was not prepared.



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

[jira] [Created] (TRAFODION-1858) RI predicate generating string should not contain _SALT_ column

2016-02-27 Thread liu ming (JIRA) 
liu ming created TRAFODION-1858:
---

 Summary: RI predicate generating string should not contain _SALT_ 
column
 Key: TRAFODION-1858
 URL: https://issues.apache.org/jira/browse/TRAFODION-1858
 Project: Apache Trafodion
  Issue Type: Bug
Reporter: liu ming


When table created with SALT, it cannot be used in a foreign key reference.
To reproduce:

>>CREATE TABLE a ( id int not null, PRIMARY KEY (id))SALT USING 9 PARTITIONS;

--- SQL operation complete.
>>CREATE TABLE b ( id int not null, val int,
+>  PRIMARY KEY (id),
+>  CONSTRAINT FK FOREIGN KEY (val) REFERENCES a (id))
+>SALT USING 9 PARTITIONS;

--- SQL operation complete.
>>INSERT INTO a values(1);

--- 1 row(s) inserted.
>>INSERT INTO b values(1,1);

*** ERROR[15001] A syntax error occurred at or before: 
("NEW@".VAL)=(TRAFODION.SEABASE.A."_SALT_",TRAFODION.SEABASE.A.ID);
  ^ (43 characters from start of SQL 
statement)

*** ERROR[8822] The statement was not prepared.




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

[jira] [Created] (TRAFODION-1857) Unable to connect to Zookeeper over time

2016-02-27 Thread Sean Broeder (JIRA) 
Sean Broeder created TRAFODION-1857:
---

 Summary: Unable to connect to Zookeeper over time
 Key: TRAFODION-1857
 URL: https://issues.apache.org/jira/browse/TRAFODION-1857
 Project: Apache Trafodion
  Issue Type: Bug
  Components: dtm
Affects Versions: 2.0-incubating
Reporter: Sean Broeder
 Fix For: 2.0-incubating


HMASTER process has more than 1000 socket connections in CLOSE_WAIT.  Looks 
like the the TLOG is creating and closing too many connections.



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