[jira] [Closed] (TRAFODION-2930) [FIRST N] will cause sqlci core dump.

2018-02-01 Thread Yang, Yongfeng (JIRA) 

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

Yang, Yongfeng closed TRAFODION-2930.
-

> [FIRST N] will cause sqlci core dump.
> -
>
> Key: TRAFODION-2930
> URL: https://issues.apache.org/jira/browse/TRAFODION-2930
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-cmp
>Affects Versions: 2.4
>Reporter: Yang, Yongfeng
>Assignee: Yang, Yongfeng
>Priority: Major
>
> {color:#00}>>create table mytable(id int);{color} 
> {color:#00}    {color} 
> {color:#00}--- SQL operation complete.{color} 
> {color:#00}>>insert into mytable values(1);{color}
> {color:#00}--- 1 row(s) inserted.{color} 
> {color:#00}>>select [first 6000] * from mytable;  {color} 
> {color:#00}*** EXECUTOR ASSERTION FAILURE{color} 
> {color:#00}*** Time: Fri Jan 26 06:48:54 2018{color} 
> {color:#00}*** Process: 13301{color} 
> {color:#00}*** File: ../executor/ExFirstN.cpp{color} 
> {color:#00}*** Line: 383{color} 
> {color:#00}*** Message: ExFirstNTcb::work(): only last 0 and last 1 
> supported.{color} 
> {color:#00}Aborted (core dumped){color}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Work started] (TRAFODION-2930) [FIRST N] will cause sqlci core dump.

2018-02-01 Thread Yang, Yongfeng (JIRA) 

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

Work on TRAFODION-2930 started by Yang, Yongfeng.
-
> [FIRST N] will cause sqlci core dump.
> -
>
> Key: TRAFODION-2930
> URL: https://issues.apache.org/jira/browse/TRAFODION-2930
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-cmp
>Affects Versions: 2.4
>Reporter: Yang, Yongfeng
>Assignee: Yang, Yongfeng
>Priority: Major
>
> {color:#00}>>create table mytable(id int);{color} 
> {color:#00}    {color} 
> {color:#00}--- SQL operation complete.{color} 
> {color:#00}>>insert into mytable values(1);{color}
> {color:#00}--- 1 row(s) inserted.{color} 
> {color:#00}>>select [first 6000] * from mytable;  {color} 
> {color:#00}*** EXECUTOR ASSERTION FAILURE{color} 
> {color:#00}*** Time: Fri Jan 26 06:48:54 2018{color} 
> {color:#00}*** Process: 13301{color} 
> {color:#00}*** File: ../executor/ExFirstN.cpp{color} 
> {color:#00}*** Line: 383{color} 
> {color:#00}*** Message: ExFirstNTcb::work(): only last 0 and last 1 
> supported.{color} 
> {color:#00}Aborted (core dumped){color}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2936) nullpointer error where server return without value

2018-02-01 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1421


> nullpointer error where server return without value
> ---
>
> Key: TRAFODION-2936
> URL: https://issues.apache.org/jira/browse/TRAFODION-2936
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: xiaozhong.wang
>Priority: Critical
>
> we met a bug, when the server return without value, will make a null point 
> error.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2871) Trafodion Security Team and ML

2018-02-01 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1424


> Trafodion Security Team and ML
> --
>
> Key: TRAFODION-2871
> URL: https://issues.apache.org/jira/browse/TRAFODION-2871
> Project: Apache Trafodion
>  Issue Type: Improvement
>  Components: documentation, website
>Reporter: Pierre Smits
>Assignee: Steve Varnau
>Priority: Major
>  Labels: security
>
> Security threats are everywhere. We should have the constructs in place to 
> address these properly, meaning:
> * have a Trafodion security ml
> * etc.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2938) Add *GET PRIVILEGES* for GET Statement in *Trafodion SQL Reference Manual*

2018-02-01 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1426


> Add *GET PRIVILEGES* for GET Statement in *Trafodion SQL Reference Manual*
> --
>
> Key: TRAFODION-2938
> URL: https://issues.apache.org/jira/browse/TRAFODION-2938
> Project: Apache Trafodion
>  Issue Type: Documentation
>Reporter: Liu Yu
>Assignee: Liu Yu
>Priority: Major
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2930) [FIRST N] will cause sqlci core dump.

2018-02-01 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1430


> [FIRST N] will cause sqlci core dump.
> -
>
> Key: TRAFODION-2930
> URL: https://issues.apache.org/jira/browse/TRAFODION-2930
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-cmp
>Affects Versions: 2.4
>Reporter: Yang, Yongfeng
>Assignee: chenyunren
>Priority: Major
>
> {color:#00}>>create table mytable(id int);{color} 
> {color:#00}    {color} 
> {color:#00}--- SQL operation complete.{color} 
> {color:#00}>>insert into mytable values(1);{color}
> {color:#00}--- 1 row(s) inserted.{color} 
> {color:#00}>>select [first 6000] * from mytable;  {color} 
> {color:#00}*** EXECUTOR ASSERTION FAILURE{color} 
> {color:#00}*** Time: Fri Jan 26 06:48:54 2018{color} 
> {color:#00}*** Process: 13301{color} 
> {color:#00}*** File: ../executor/ExFirstN.cpp{color} 
> {color:#00}*** Line: 383{color} 
> {color:#00}*** Message: ExFirstNTcb::work(): only last 0 and last 1 
> supported.{color} 
> {color:#00}Aborted (core dumped){color}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2931) call char_length on Chinese character will cause core dump.

2018-02-01 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1431


> call char_length on Chinese character will cause core dump.
> ---
>
> Key: TRAFODION-2931
> URL: https://issues.apache.org/jira/browse/TRAFODION-2931
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: 2.4
>Reporter: Yang, Yongfeng
>Assignee: chenyunren
>Priority: Major
>
> {color:#00}>>set terminal_charset utf8;{color} 
> {color:#00}>>select char_lentgh('{color}{color:#00}中国人') from 
> (values(1));{color} 
> {color:#00}#{color} 
> {color:#00}# A fatal error has been detected by the Java Runtime 
> Environment:{color} 
> {color:#00}#{color} 
> {color:#00}#  SIGSEGV (0xb) at pc=0x004024ea, pid=13636, 
> tid=140591300516352{color} 
> {color:#00}#{color} 
> {color:#00}# JRE version: OpenJDK Runtime Environment (7.0_161) (build 
> 1.7.0_161-mockbuild_2017_12_06_14_28-b00){color} 
> {color:#00}# Java VM: OpenJDK 64-Bit Server VM (24.161-b00 mixed mode 
> linux-amd64 compressed oops){color} 
> {color:#00}# Derivative: IcedTea 2.6.12{color} 
> {color:#00}# Distribution: CentOS release 6.9 (Final), package 
> rhel-2.6.12.0.el6_9-x86_64 u161-b00{color} 
> {color:#00}# Problematic frame:{color} 
> {color:#00}# C  [sqlci+0x24ea]  folly::fbstring_core::category() 
> const+0xc{color} 
> {color:#00}#{color} 
> {color:#00}# Core dump written. Default location: 
> /home/centos/incubator-trafodion/core or core.13636{color} 
> {color:#00}#{color} 
> {color:#00}# An error report file with more information is saved 
> as:{color} 
> {color:#00}# /tmp/jvm-13636/hs_error.log{color} 
> {color:#00}#{color} 
> {color:#00}# If you would like to submit a bug report, please 
> include{color} 
> {color:#00}# instructions on how to reproduce the bug and visit:{color} 
> {color:#00}#  {color} [http://icedtea.classpath.org/bugzilla] 
> {color:#00}# The crash happened outside the Java Virtual Machine in 
> native code.{color} 
> {color:#00}# See problematic frame for where to report the bug.{color} 
> {color:#00}#{color} 
> {color:#00}Aborted (core dumped){color}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2943) shebang in file core/sqf/sql/scripts/cleanat is broken

2018-02-01 Thread ASF GitHub Bot (JIRA) 

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

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

Github user asfgit closed the pull request at:

https://github.com/apache/trafodion/pull/1432


> shebang in file core/sqf/sql/scripts/cleanat is broken
> --
>
> Key: TRAFODION-2943
> URL: https://issues.apache.org/jira/browse/TRAFODION-2943
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: dev-environment
>Affects Versions: any
>Reporter: Wenjun Zhu
>Priority: Trivial
> Fix For: 2.3
>
>
> In file core/sqf/sql/scripts/cleanat is broken, the shebang should be '#!', 
> but it lacks '#' at present.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Issue Comment Deleted] (TRAFODION-2943) shebang in file core/sqf/sql/scripts/cleanat is broken

2018-02-01 Thread Suresh Subbiah (JIRA) 

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

Suresh Subbiah updated TRAFODION-2943:
--
Comment: was deleted

(was: Whoops, this is not AdvEnt2.3, but Trafodion2.3.  Let me check again.

 )

> shebang in file core/sqf/sql/scripts/cleanat is broken
> --
>
> Key: TRAFODION-2943
> URL: https://issues.apache.org/jira/browse/TRAFODION-2943
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: dev-environment
>Affects Versions: any
>Reporter: Wenjun Zhu
>Priority: Trivial
> Fix For: 2.3
>
>
> In file core/sqf/sql/scripts/cleanat is broken, the shebang should be '#!', 
> but it lacks '#' at present.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Issue Comment Deleted] (TRAFODION-2943) shebang in file core/sqf/sql/scripts/cleanat is broken

2018-02-01 Thread Suresh Subbiah (JIRA) 

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

Suresh Subbiah updated TRAFODION-2943:
--
Comment: was deleted

(was: Can you please help confirmwhere you are seeing this?  I have checked our 
a new branch of AdvEnt2.3 and I see the !.  Git blame shows the source line was 
last modified in May 2016.

[sbroeder@edev05 Adv2.3]$ git blame core/sqf/sql/scripts/cleanat
3024ce7a (Narendra Goyal 2016-05-07 08:44:18 + 1) #!/bin/bash

 )

> shebang in file core/sqf/sql/scripts/cleanat is broken
> --
>
> Key: TRAFODION-2943
> URL: https://issues.apache.org/jira/browse/TRAFODION-2943
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: dev-environment
>Affects Versions: any
>Reporter: Wenjun Zhu
>Priority: Trivial
> Fix For: 2.3
>
>
> In file core/sqf/sql/scripts/cleanat is broken, the shebang should be '#!', 
> but it lacks '#' at present.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (TRAFODION-2650) The SQLite Trafodion Configuration database storage method can become stale.

2018-02-01 Thread ASF GitHub Bot (JIRA) 

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

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

GitHub user zcorrea opened a pull request:

https://github.com/apache/trafodion/pull/1437

[TRAFODION-2650] Restructured Trafodion Configuration code into separate

directory structure.

Move code out of monitor source tree into its own directory structure. Move 
Trafodion Configuration API header file into the export/include/trafconf 
directory.

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

$ git pull https://github.com/zcorrea/trafodion TRAFODION-2650

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

https://github.com/apache/trafodion/pull/1437.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 #1437


commit 87849fcf8199857e0c525d332a061db8744c86cb
Author: Zalo Correa 
Date:   2018-02-02T01:51:35Z

[TRAFODION-2650] Restructured Trafodion Configuration code into separate
directory structure.




> The SQLite Trafodion Configuration database storage method can become stale.
> 
>
> Key: TRAFODION-2650
> URL: https://issues.apache.org/jira/browse/TRAFODION-2650
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: foundation
>Affects Versions: 2.2-incubating
>Reporter: Gonzalo E Correa
>Assignee: Gonzalo E Correa
>Priority: Major
> Fix For: 2.3
>
>
> The SQLite storage method can prevent a node from initializing properly. This 
> is due to the nature of SQLIte, a database in a file. The file is updated 
> locally on each node. In certain failure scenarios, such as Cloudera Manager 
> and potentially Ambari installations, the file will not be updated locally. 
> This happens when the monitor process is not running and changes are made to 
> the configuration, the file in the node where the monitor process is not 
> executing will become stale and on a node up event, may contain old 
> configuration information.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Resolved] (TRAFODION-2881) Multiple node failures occur during HA testing

2018-02-01 Thread Gonzalo E Correa (JIRA) 

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

Gonzalo E Correa resolved TRAFODION-2881.
-
Resolution: Fixed

Changes in: https://github.com/apache/trafodion/pull/1392

> Multiple node failures occur during HA testing
> --
>
> Key: TRAFODION-2881
> URL: https://issues.apache.org/jira/browse/TRAFODION-2881
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: foundation
>Affects Versions: 2.3
>Reporter: Gonzalo E Correa
>Assignee: Gonzalo E Correa
>Priority: Major
> Fix For: 2.3
>
>
> Inflicting server failure in certain modes will cause multiple monitor 
> process to also bring their nodes down along with the intended target of the 
> test.
> Server down modes:
> init 6
> reboot -f
> shutdown -r now
> shell node down command
> In addition, after a server down, the shell 'node up' command will also fail 
> intermittently. This requires a longevity HA test to down and up nodes over a 
> long period of time like 24-48 hours.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (TRAFODION-2947) LOB:Create utility to compact and do GC on LOB data files

2018-02-01 Thread Sandhya Sundaresan (JIRA) 
Sandhya Sundaresan created TRAFODION-2947:
-

 Summary: LOB:Create utility to compact and do GC on LOB data files
 Key: TRAFODION-2947
 URL: https://issues.apache.org/jira/browse/TRAFODION-2947
 Project: Apache Trafodion
  Issue Type: Improvement
  Components: sql-exe
Reporter: Sandhya Sundaresan
Assignee: Sandhya Sundaresan


Need a maintain type of utlity program that will perform GC on LOB data files 
offline. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (TRAFODION-2742) Linux and Windows ODBC need to support LOB

2018-02-01 Thread Sandhya Sundaresan (JIRA) 

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

Sandhya Sundaresan updated TRAFODION-2742:
--
Issue Type: Technical task  (was: Sub-task)

> Linux  and Windows ODBC need to  support LOB
> 
>
> Key: TRAFODION-2742
> URL: https://issues.apache.org/jira/browse/TRAFODION-2742
> Project: Apache Trafodion
>  Issue Type: Technical task
>  Components: client-jdbc-t4, connectivity-mxosrvr, sql-exe
>Reporter: Weiqing Xu
>Assignee: Weiqing Xu
>Priority: Major
> Fix For: 2.3
>
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Closed] (TRAFODION-2876) color control code is output when getting the git branch name

2018-02-01 Thread Wenjun Zhu (JIRA) 

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

Wenjun Zhu closed TRAFODION-2876.
-
Resolution: Fixed

> color control code is output when getting the git branch name
> -
>
> Key: TRAFODION-2876
> URL: https://issues.apache.org/jira/browse/TRAFODION-2876
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: Build Infrastructure
>Affects Versions: any
>Reporter: Wenjun Zhu
>Priority: Minor
> Fix For: 2.3
>
>
> To get the gti branch name in file core/sqf/build-scripts/build.branch,
> 50 branch=$(git branch | grep '^\* ' | sed 's/(no branch)/no_branch/' | 
> awk '{print $2}')
> `git branch` is used.
> But if the configuration color.ui in git is on, the command `git branch` 
> output the color control code, like
> cd build-scripts && ./genverhdr.ksh -major "2" \
> -minor "3" \
> -update "0" \
> -build "adamas" \
> -flavor "debug" \
> *-funbranch 
> "89433fb_dh_^[[32mmaster^[[m" \*
> *-branch "89433fb_^[[32mmaster^[[m" \*
> -date "04Jan18"
> this causes some troubles.
> So I propose to add a option `--no-color` to `git brunch`.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Created] (TRAFODION-2945) remove unused file core/sql/optimizer/RoutineInvocation.h

2018-02-01 Thread Wenjun Zhu (JIRA) 
Wenjun Zhu created TRAFODION-2945:
-

 Summary: remove unused file core/sql/optimizer/RoutineInvocation.h
 Key: TRAFODION-2945
 URL: https://issues.apache.org/jira/browse/TRAFODION-2945
 Project: Apache Trafodion
  Issue Type: Bug
  Components: Build Infrastructure
Affects Versions: 2.3, any
Reporter: Wenjun Zhu
 Fix For: any


After searching , I find that file core/sql/optimizer/RoutineInvocation.h is 
not refered anywhere in Trafodion, so I think this can be removed safely.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)