[jira] [Created] (TRAFODION-1676) support better runtime error message when a SQL function meet fital error

2015-12-04 Thread liu ming (JIRA)
liu ming created TRAFODION-1676:
---

 Summary: support better runtime error message when a SQL function 
meet fital error
 Key: TRAFODION-1676
 URL: https://issues.apache.org/jira/browse/TRAFODION-1676
 Project: Apache Trafodion
  Issue Type: Improvement
  Components: sql-exe
Reporter: liu ming
Priority: Minor


A sql contains some SQL function, for example UPPER(), when the input data of 
UPPER() contains invalid data, UPPER() will fail. In this case, the whole query 
abort, and the error message cannot tell which row has invalid data, so it is 
very hard to fix the problem.
It will be good to have row id or the real value of the error row in the error 
message to help trouble shooting.



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


[jira] [Created] (TRAFODION-1677) Implement the ROLLUP and CUBE SQL functions in Trafodion

2015-12-04 Thread Qifan Chen (JIRA)
Qifan Chen created TRAFODION-1677:
-

 Summary: Implement the ROLLUP and CUBE SQL functions in Trafodion
 Key: TRAFODION-1677
 URL: https://issues.apache.org/jira/browse/TRAFODION-1677
 Project: Apache Trafodion
  Issue Type: Bug
  Components: sql-general
Reporter: Qifan Chen


I am currently working the high level design for 2nd part of the OLAP function 
RollUp and Cube. The 1st part (the identification of missing OLAP window 
functions in Trafodion and their implementation) is done. 

For RollUp and Cube,  I believe the key is to handle many more # of aggregates 
properly. Note that that number is n for RollUp and 2^n for Cube, where n is 
the # of grouping columns. Parallel computation of these aggregates is the key.

One way to achieve such is to extend the Hash Group By operators so that it can 
do multiple aggregates in a single operator. The requires the following:

1. random partition the data fed into the aggregate operator
2. force the multiple-level group by 
3. pack multiple pairs of groupping and aggregate expressions (both in compiler 
and in executor, and in MapValueIds, GroupByPartialRoot, and 
GroupByPartialLeaf). 



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


[jira] [Commented] (TRAFODION-1655) RMS reports incorrect hbase io time and 0 for OperCpuTime for operators hosted in ESP

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1655:
---

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/205


> RMS reports incorrect hbase io time and  0 for OperCpuTime for operators 
> hosted in ESP
> --
>
> Key: TRAFODION-1655
> URL: https://issues.apache.org/jira/browse/TRAFODION-1655
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-exe
>Reporter: Selvaganesan Govindarajan
> Fix For: 2.0-incubating
>
>
> Breakdown of the time spent in hbase and Trafodion seems to be not correct 
> for all queries. RMS reports 0 operator cpu time for all the operators hosted 
> in ESPs. For non-parallel plans RMS reports Operator CPU time correctly.



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


[jira] [Commented] (TRAFODION-1668) Cannot upload customer SPJ JARs

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1668:
---

Github user robertamarton commented on a diff in the pull request:

https://github.com/apache/incubator-trafodion/pull/203#discussion_r46707402
  
--- Diff: core/conn/spj_init/src/main/resources/init_spj.sql ---
@@ -0,0 +1,156 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+# @@@ END COPYRIGHT @@@
+
+SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar
+CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog
+SQLCI=${MY_SQROOT}/export/bin32/sqlci
+CP=/bin/cp
+MANAGEABILITY_CATALOG=TRAFODION
+CIS_SCHEMA=DEFAULT_SPJ
+
+
+function dropAndCreateSchema {
+echo "Creating Schema for CI Server Component"
+sqlci << sqlciEOF
+
+  cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on';
+  cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on';
+
+  DROP SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA CASCADE;
+  CREATE SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA;
+
+  cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'off';
+  cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'off';
+
+  exit;
+sqlciEOF
+}
+
+function createProcedures {
+
+echo "Creating Procedures in  schema 
'$MANAGEABILITY_CATALOG.$CIS_SCHEMA' "
+sqlci << procEOF
+
+  cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on';
+  cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on';
+
+  -- Creating Procedures 
+  set schema $MANAGEABILITY_CATALOG.$CIS_SCHEMA; 
+
+  DROP LIBRARY SPJMGMT CASCADE;
+  CREATE LIBRARY SPJMGMT FILE '${SERVER_JAR}';
+   
+  CREATE PROCEDURE HELP (
+  INOUT COMMANDNAME VARCHAR(2560) CHARACTER SET ISO88591)
+  EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.help (java.lang.String[])'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE HELP TO PUBLIC;
+  
+  CREATE PROCEDURE PUT (
+  IN FILEDATA VARCHAR(102400) CHARACTER SET ISO88591,
+  IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+  IN CREATEFLAG INTEGER)
+  EXTERNAL NAME 
'com.traf.mgmt.JarFileMgmt.put(java.lang.String,java.lang.String,int)'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE PUT TO PUBLIC;
+  
+  CREATE PROCEDURE LS (
+  IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+  OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
+  EXTERNAL NAME 
'com.traf.mgmt.JarFileMgmt.ls(java.lang.String,java.lang.String[])'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE LS TO PUBLIC;
+  
+  CREATE PROCEDURE LSALL (
+  OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
+  EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.lsAll(java.lang.String[])'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE LSALL TO PUBLIC;
+  
+  CREATE PROCEDURE RM (
+  IN FILENAME VARCHAR(256) CHARACTER SET ISO88591)
+  EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.rm(java.lang.String)'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE RM TO PUBLIC;
+  
+  CREATE PROCEDURE RMREX (
+  IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+  OUT 

[jira] [Commented] (TRAFODION-1668) Cannot upload customer SPJ JARs

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1668:
---

Github user robertamarton commented on a diff in the pull request:

https://github.com/apache/incubator-trafodion/pull/203#discussion_r46707640
  
--- Diff: core/conn/spj_init/src/main/resources/init_spj.sql ---
@@ -0,0 +1,156 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+# @@@ END COPYRIGHT @@@
+
+SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar
+CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog
+SQLCI=${MY_SQROOT}/export/bin32/sqlci
+CP=/bin/cp
+MANAGEABILITY_CATALOG=TRAFODION
+CIS_SCHEMA=DEFAULT_SPJ
+
+
+function dropAndCreateSchema {
+echo "Creating Schema for CI Server Component"
+sqlci << sqlciEOF
+
+  cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on';
+  cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on';
+
+  DROP SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA CASCADE;
+  CREATE SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA;
+
+  cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'off';
+  cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'off';
+
+  exit;
+sqlciEOF
+}
+
+function createProcedures {
+
+echo "Creating Procedures in  schema 
'$MANAGEABILITY_CATALOG.$CIS_SCHEMA' "
+sqlci << procEOF
+
+  cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on';
+  cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on';
+
+  -- Creating Procedures 
+  set schema $MANAGEABILITY_CATALOG.$CIS_SCHEMA; 
+
+  DROP LIBRARY SPJMGMT CASCADE;
+  CREATE LIBRARY SPJMGMT FILE '${SERVER_JAR}';
+   
+  CREATE PROCEDURE HELP (
+  INOUT COMMANDNAME VARCHAR(2560) CHARACTER SET ISO88591)
+  EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.help (java.lang.String[])'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE HELP TO PUBLIC;
+  
+  CREATE PROCEDURE PUT (
+  IN FILEDATA VARCHAR(102400) CHARACTER SET ISO88591,
+  IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+  IN CREATEFLAG INTEGER)
+  EXTERNAL NAME 
'com.traf.mgmt.JarFileMgmt.put(java.lang.String,java.lang.String,int)'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE PUT TO PUBLIC;
+  
+  CREATE PROCEDURE LS (
+  IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+  OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
+  EXTERNAL NAME 
'com.traf.mgmt.JarFileMgmt.ls(java.lang.String,java.lang.String[])'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE LS TO PUBLIC;
+  
+  CREATE PROCEDURE LSALL (
+  OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
+  EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.lsAll(java.lang.String[])'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE LSALL TO PUBLIC;
+  
+  CREATE PROCEDURE RM (
+  IN FILENAME VARCHAR(256) CHARACTER SET ISO88591)
+  EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.rm(java.lang.String)'
+  EXTERNAL SECURITY DEFINER
+  LIBRARY SPJMGMT
+  LANGUAGE JAVA
+  PARAMETER STYLE JAVA
+  READS SQL DATA
+  ;
+  GRANT EXECUTE ON PROCEDURE RM TO PUBLIC;
+  
+  CREATE PROCEDURE RMREX (
+  IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+  OUT 

[jira] [Commented] (TRAFODION-1666) Need a script to update the version of windows odbc

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1666:
---

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/201


> Need a script to update the version of windows odbc
> ---
>
> Key: TRAFODION-1666
> URL: https://issues.apache.org/jira/browse/TRAFODION-1666
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: client-odbc-windows
>Affects Versions: 1.3-incubating
>Reporter: Weiqing Xu
>Priority: Minor
>
> There are too many files need to be updated when we update the version number 
> of windows ODBC Driver. It's better to provider a script to do it.



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


[jira] [Commented] (TRAFODION-1668) Cannot upload customer SPJ JARs

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1668:
---

Github user robertamarton commented on a diff in the pull request:

https://github.com/apache/incubator-trafodion/pull/203#discussion_r46708044
  
--- Diff: core/conn/spj_init/src/main/resources/init_spj.sql ---
@@ -0,0 +1,156 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements.  See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership.  The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License.  You may obtain a copy of the License at
+#
+#   http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied.  See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+# @@@ END COPYRIGHT @@@
+
+SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar
+CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog
+SQLCI=${MY_SQROOT}/export/bin32/sqlci
+CP=/bin/cp
+MANAGEABILITY_CATALOG=TRAFODION
+CIS_SCHEMA=DEFAULT_SPJ
+
+
+function dropAndCreateSchema {
+echo "Creating Schema for CI Server Component"
+sqlci << sqlciEOF
+
+  cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on';
+  cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on';
+
+  DROP SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA CASCADE;
+  CREATE SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA;
+
--- End diff --

This relates to the role comment Hans made below.  We could create a role 
and change the AUTHORIZATION clause to be the role.  But this is only valid 
when authorization is enabled.  So you need logic to handle to set the correct 
authorization clause and code is needed when authorization is enabled and 
disable to change the schema owner.  I would, for simplicity, make DB__ROOT or 
DB__ROOTROLE the owner and require the user to set privileges to whatever role 
or user they want to manage privileges.


> Cannot upload customer SPJ JARs
> ---
>
> Key: TRAFODION-1668
> URL: https://issues.apache.org/jira/browse/TRAFODION-1668
> Project: Apache Trafodion
>  Issue Type: Improvement
>Reporter: Kevin Xu
>Assignee: Kevin Xu
>




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


[jira] [Commented] (TRAFODION-1570) sqvers -u displays as if a UTT is installed even when there is no UTT installed

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1570:
---

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/204


> sqvers -u displays as if a UTT is installed even when there is no UTT 
> installed
> ---
>
> Key: TRAFODION-1570
> URL: https://issues.apache.org/jira/browse/TRAFODION-1570
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: Selvaganesan Govindarajan
>Assignee: Hans Zeller
>
> The version of the jar files and the executables including .so files differ 
> and hence sqvers -u displays the jar files as if a UTT is installed.
> The jar files have Apache_Trafodion release name missing. 
>  
> [gselva@dev02 regress]$ sqvers -u
> MY_SQROOT=/mnt/gselva/incubator-trafodion/core/sqf
> who@host=gselva@dev02
> JAVA_HOME=/usr/lib/jvm/java-1.7.0-openjdk.x86_64
> linux=2.6.32-504.23.4.el6.x86_64
> redhat=6.7
> NO patches
> Most common Apache_Trafodion Release 1.3.0 (Build release [gselva], branch 
> 2578f51-workspace, date 28Oct15)
> UTT count is 1
> [7] Release 1.3.0 (Build release [gselva], branch 2578f51-workspace, date 
> 28Oct15)
> export/lib/hbase-trx-cdh5_3-1.3.0.jar
> export/lib/hbase-trx-hbase_98_4-1.3.0.jar
> export/lib/hbase-trx-hdp2_2-1.3.0.jar
> export/lib/hbase-trx-mapr4_0-1.3.0.jar
> export/lib/sqmanvers.jar
> export/lib/trafodion-dtm-1.3.0.jar
> export/lib/trafodion-sql-1.3.0.jar
>  



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


[jira] [Commented] (TRAFODION-1677) Implement the ROLLUP and CUBE SQL functions in Trafodion

2015-12-04 Thread Qifan Chen (JIRA)

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

Qifan Chen commented on TRAFODION-1677:
---

I checked the work method for hash group by.  Looks like it is very specific to 
a single aggregate expression and would be extra work to alter it for multiple 
aggregates. 

So to handle multiple aggregate expressions with the hash group by operator 
without much code change, we could use threads, each works on one aggregate 
expression, replying on the existing method.  

This would be another requirement to support threads in yet another operator. 


> Implement the ROLLUP and CUBE SQL functions in Trafodion
> 
>
> Key: TRAFODION-1677
> URL: https://issues.apache.org/jira/browse/TRAFODION-1677
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Reporter: Qifan Chen
>
> I am currently working the high level design for 2nd part of the OLAP 
> function RollUp and Cube. The 1st part (the identification of missing OLAP 
> window functions in Trafodion and their implementation) is done. 
> For RollUp and Cube,  I believe the key is to handle many more # of 
> aggregates properly. Note that that number is n for RollUp and 2^n for Cube, 
> where n is the # of grouping columns. Parallel computation of these 
> aggregates is the key.
> One way to achieve such is to extend the Hash Group By operators so that it 
> can do multiple aggregates in a single operator. The requires the following:
> 1. random partition the data fed into the aggregate operator
> 2. force the multiple-level group by 
> 3. pack multiple pairs of groupping and aggregate expressions (both in 
> compiler and in executor, and in MapValueIds, GroupByPartialRoot, and 
> GroupByPartialLeaf). 



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


[jira] [Commented] (TRAFODION-1648) Synchronization issues in TrxRegion* coprocessor code for Region split/balance

2015-12-04 Thread Trina Krug (JIRA)

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

Trina Krug commented on TRAFODION-1648:
---

Will fix/change the following 2 things for this JIRA:

1) Disable all non phase 2 transactional operations earlier in the 
split/rebalance process.  There will be a tiered approach for disabling 
requests with the goal to minimize transaction outage and to allow the region 
operation to go as quickly as possible.  This piece will address :
   -- synchronization issues
   -- the potential of prolonging a split/rebalance indefinitely
   -- missing a transaction changing state due to timing windows

2) Fix data synchronization issues for the active transaction list, commit 
pending list and scanners list at split/rebalance time (should be solved by the 
above, but for completeness sake it will be addressed)

> Synchronization issues in TrxRegion* coprocessor code for Region 
> split/balance 
> ---
>
> Key: TRAFODION-1648
> URL: https://issues.apache.org/jira/browse/TRAFODION-1648
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: dtm
>Reporter: Trina Krug
>Assignee: Trina Krug
>
> --New transactions become disabled in preClose/preSplit, but other requests 
> such as commitRequest are allowed to get through after this point.  This 
> poses an issue when gathering/writing transaction state at flush time.  A 
> slight design modification is required.
> --In addition, detailed review and possible modification of shared lists 
> should be done in this region split/balance area, including those affected 
> above.



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


[jira] [Commented] (TRAFODION-1642) Release 1.3.0 copyrights and license files are incorrect

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1642:
---

GitHub user robertamarton opened a pull request:

https://github.com/apache/incubator-trafodion/pull/208

Release1.3

[TRAFODION-1642] Release 1.3.0 copyrights and license files are incorrect


You can merge this pull request into a Git repository by running:

$ git pull https://github.com/apache/incubator-trafodion release1.3

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/208.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #208


commit 851f2a5d8aa72114be94727d19e6021af0609b02
Author: Roberta Marton 
Date:   2015-11-13T00:16:46Z

Fix for TRAFODION-1623

commit 1ea3e834b6738617164d2a6ed8b090b3ab497946
Author: Roberta Marton 
Date:   2015-11-13T16:46:58Z

Merge [TRAFODION-1623] PR 171 Installation fails

commit 7a085965c36363a3a44f5e85d8cfc5a46280f45f
Author: Roberta Marton 
Date:   2015-11-23T22:59:00Z

TRAFODION-1636 & TRAFODION-1642

TRAFODION-1636: wms and dcs directories contain NOTICE and LICENSE FILES
TRAFODION-1642: Release 1.3.0 copyrights and license files are incorrect

Fixed up copyrights

Removed Apache copyrights (should only have one copyright in file)
  core/sql/common/swscanf.cpp
  core/sql/common/sqsprintf.cpp
  core/sql/parser/ulexer.h

Removed copyright - deemed to be our code and can safely remove
  core/conn/jdbc_type4/src/org/trafodion/jdbc/t4/T4DatabaseMetaData.java
  core/sql/regress/newregr/card/runregr_card.ksh
  dcs/src/main/java/org/trafodion/dcs/util/ByteBufferUtils.java
  dcs/src/main/java/org/trafodion/dcs/util/SqlUtils.java

Replaced Hewlett Packard copyright with Apache copyright
  core/sql/regress/seabase/EXPECTED021
  core/sql/regress/udr/EXPECTED100.SB
  docs/client_install/source/Trafodion_Client_Installation_Guide.xml
  docs/client_install/source/xml-profile.xml
  docs/command_interface/source/Trafodion_Command_Interface_Guide.xml
  docs/command_interface/source/xml-profile.xml
  docs/odb_manual/Trafodion_odb_User_Guide.xml
  docs/sql_reference/source/Trafodion_SQL_Reference_Manual.xml
  docs/sql_reference/source/xml-profile.xml
  wms/build.xml

Removed code/files that are not being used that contain invalid copyrights
  core/sqf/export/lib/Vili/Functions.pm
  core/sqf/export/lib/Vili/Helper.pm
  core/sqf/export/lib/Vili/NoDriftTimer.pm
  core/sql/common/from_GB2312.c
  core/sql/regress/newregr/mvs/BIG/expectedmv215_RU
  core/sql/regress/newregr/mvs/EXPECTEDMV500
  core/sql/regress/newregr/mvs/EXPECTEDMV500A
  core/sql/regress/newregr/mvs/EXPECTEDMV500A_LINUX
  core/sql/regress/newregr/mvs/TPCD/DBGEN_HELP.TXT
  dcs/src/main/resources/dcs-webapps/master/css/stylesheet.css

Removed filters for Hewlett Packard, Tandem, Compaq, and Microsoft.  None of
test software should returns these values
  core/sql/regress/tools/regress-filter
  core/sql/regress-tools/regress-filter-linux

Removed LICENSE and NOTICE files from child directories
  dcs/LICENSE.txt
  dcs/NOTICE.txt
  wms/LICENSE.txt
  wms/NOTICE.txt
  install/README.rst

Reworded comment so Copright would not show up on search
  core/sql/update/CopyrightCheck.py

commit 26031c8a51514ccee3fae58cb644420434f1f416
Author: Roberta Marton 
Date:   2015-11-24T01:43:47Z

updated .rat-excludes and RAT_README.txt to include copyright changes

commit f66141834f102e9af39cf9baf3bc3f9c27118133
Author: Roberta Marton 
Date:   2015-12-01T17:55:29Z

Copied pull request 187 to release1.3 branch

commit 3b27862e0886625ff1e61b97125cc57d50ca7256
Author: Roberta Marton 
Date:   2015-12-02T00:18:25Z

Merge [TRAFODION-1636] and [TRAFODION-1642] PR-185 Copyrights, License, and 
Notice file updates




> Release 1.3.0 copyrights and license files are incorrect
> 
>
> Key: TRAFODION-1642
> URL: https://issues.apache.org/jira/browse/TRAFODION-1642
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: Build Infrastructure
>Reporter: Roberta Marton
>Assignee: Roberta Marton
>
> Apache has very definitive rules about release products which make sure 
> copyrights, notice, and license files are correct.  There are several issues 
> today that need to be addressed:

[jira] [Commented] (TRAFODION-1642) Release 1.3.0 copyrights and license files are incorrect

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1642:
---

GitHub user robertamarton opened a pull request:

https://github.com/apache/incubator-trafodion/pull/209

License

[TRAFODION-1642] Release 1.3.0 copyrights and license files are incorrect, 
part 2


You can merge this pull request into a Git repository by running:

$ git pull https://github.com/robertamarton/incubator-trafodion license

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-trafodion/pull/209.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #209


commit d44f32e7a13cd5a916bdef04a0d0e15448e81d1b
Author: Roberta Marton 
Date:   2015-12-04T18:34:11Z

TRAFODION-1642: Release 1.3.0 copyrights and license files are incorrect

Part 2 of copyright and licensing changes

Removed double copyrights in files
Updated LICENSE, README, RAT_README to reflect latest changes
Added licenses directory to include license text
Added .gitattributes to exclude files from the source tar file
Changed Hewlett Packard copyright to Apache copyrights in win-odbc

commit 30bd43f424ff23ac16329d089522fd38964017ee
Author: Roberta Marton 
Date:   2015-12-04T18:55:11Z

Minor update to .rat-excludes file




> Release 1.3.0 copyrights and license files are incorrect
> 
>
> Key: TRAFODION-1642
> URL: https://issues.apache.org/jira/browse/TRAFODION-1642
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: Build Infrastructure
>Reporter: Roberta Marton
>Assignee: Roberta Marton
>
> Apache has very definitive rules about release products which make sure 
> copyrights, notice, and license files are correct.  There are several issues 
> today that need to be addressed:
> - Missing license information in the LICENSE file
> - Incorrect information in the LICENSE file
> - Multiple copyrights in source files
> - Existing Hewlett Packard and Compaq copyrights that should be removed
> - Image files missing copyrights



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


[jira] [Commented] (TRAFODION-1642) Release 1.3.0 copyrights and license files are incorrect

2015-12-04 Thread ASF GitHub Bot (JIRA)

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

ASF GitHub Bot commented on TRAFODION-1642:
---

Github user robertamarton closed the pull request at:

https://github.com/apache/incubator-trafodion/pull/208


> Release 1.3.0 copyrights and license files are incorrect
> 
>
> Key: TRAFODION-1642
> URL: https://issues.apache.org/jira/browse/TRAFODION-1642
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: Build Infrastructure
>Reporter: Roberta Marton
>Assignee: Roberta Marton
>
> Apache has very definitive rules about release products which make sure 
> copyrights, notice, and license files are correct.  There are several issues 
> today that need to be addressed:
> - Missing license information in the LICENSE file
> - Incorrect information in the LICENSE file
> - Multiple copyrights in source files
> - Existing Hewlett Packard and Compaq copyrights that should be removed
> - Image files missing copyrights



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