[jira] [Resolved] (TRAFODION-343) LP Bug: 1325716 - TIME(1) default CURRENT_TIME reported wrong values

2015-10-12 Thread Suresh Subbiah (JIRA)

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

Suresh Subbiah resolved TRAFODION-343.
--
Resolution: Fixed

> LP Bug: 1325716 - TIME(1) default CURRENT_TIME reported wrong values
> 
>
> Key: TRAFODION-343
> URL: https://issues.apache.org/jira/browse/TRAFODION-343
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-cmp
>Reporter: Apache Trafodion
>Assignee: liu ming
>Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> expected default CURRENT_TIME ti01 returned -34.07.06.
> not as expected 19:55:28.6
> SQL>create table a05table (
> int1 integer no default not null
>   , vch2 CHAR VARYING(8) 
>   , dt00 DATE
>   , tidf TIME default CURRENT_TIME
>   , tsdf TIMESTAMP(0) default CURRENT_TIMESTAMP
>   , dt01 DATE default CURRENT_DATE
>   , ti01 TIME(1) default CURRENT_TIME
>   , ts01 TIMESTAMP(1) default CURRENT_TIMESTAMP
>   , primary key (int1 asc) not droppable
> )
> store by primary key
> ;
> --- SQL operation complete.
> SQL>insert into a05table (int1, vch2) values (1,'row_1');
> --- 1 row(s) inserted.
> SQL>insert into a05table (int1, tsdf ) values 
>   (13, timestamp '1997-01-31:13:13:13');
> --- 1 row(s) inserted.
> SQL>select * from a05table order by int1;
> INT1VCH2 DT00   TIDF TSDFDT01   TI01  
>  TS01 
> ---  --  --- -- 
> -- -
>   1 row_1NULL   19:55:27 2014-06-02 19:55:27 2014-06-02 
> -34:07:06. 2014-06-02 19:55:27.6
>  13 NULL NULL   19:55:28 1997-01-31 13:13:13 2014-06-02 
> 19:55:28.6 2014-06-02 19:55:28.6
> --- 2 row(s) selected.
> SQL>select int1, dt01, ti01, ts01 from a05table order by int1;
> INT1DT01   TI01   TS01 
> --- -- -- -
>   1 2014-06-02 -34:07:06. 2014-06-02 19:55:27.6
>  13 2014-06-02 19:55:28.6 2014-06-02 19:55:28.6
> --- 2 row(s) selected.
> SQL>insert into a05table (int1, dt01) values
>   (20, date '2005-03-31');
> --- 1 row(s) inserted.
> SQL>select int1, dt01, ti01, ts01 from a05table order by int1;
> INT1DT01   TI01   TS01 
> --- -- -- -
>   1 2014-06-02 -34:07:06. 2014-06-02 19:55:27.6
>  13 2014-06-02 19:55:28.6 2014-06-02 19:55:28.6
>  20 2005-03-31 -34:07:06. 2014-06-02 19:55:28.6
> --- 3 row(s) selected.
> SQL>exit;
> -- test script
> log a09log clear;
> drop schema debug_addt105 cascade;
> create schema debug_addt105;
> set schema debug_addt105;
> drop table a05table;
> -- table start with 2 fixed length field
> create table a05table (
> int1 integer no default not null
>   , vch2 CHAR VARYING(8) 
>   , dt00 DATE
>   , tidf TIME default CURRENT_TIME
>   , tsdf TIMESTAMP(0) default CURRENT_TIMESTAMP
>   , dt01 DATE default CURRENT_DATE
>   , ti01 TIME(1) default CURRENT_TIME
>   , ts01 TIMESTAMP(1) default CURRENT_TIMESTAMP
>   , primary key (int1 asc) not droppable
> )
> store by primary key
> ;
> insert into a05table (int1, vch2) values (1,'row_1');
> insert into a05table (int1, tsdf ) values 
>   (13, timestamp '1997-01-31:13:13:13');
> select * from a05table order by int1;
> select int1, dt01, ti01, ts01 from a05table order by int1;
> insert into a05table (int1, dt01) values
>   (20, date '2005-03-31');
> select int1, dt01, ti01, ts01 from a05table order by int1;
> exit;
>  
> GIT 0530 build. Also failed on 0601 build.
> Assigned to LaunchPad User James Capps



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


[jira] [Closed] (TRAFODION-343) LP Bug: 1325716 - TIME(1) default CURRENT_TIME reported wrong values

2015-10-12 Thread Suresh Subbiah (JIRA)

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

Suresh Subbiah closed TRAFODION-343.


> LP Bug: 1325716 - TIME(1) default CURRENT_TIME reported wrong values
> 
>
> Key: TRAFODION-343
> URL: https://issues.apache.org/jira/browse/TRAFODION-343
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-cmp
>Reporter: Apache Trafodion
>Assignee: liu ming
>Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> expected default CURRENT_TIME ti01 returned -34.07.06.
> not as expected 19:55:28.6
> SQL>create table a05table (
> int1 integer no default not null
>   , vch2 CHAR VARYING(8) 
>   , dt00 DATE
>   , tidf TIME default CURRENT_TIME
>   , tsdf TIMESTAMP(0) default CURRENT_TIMESTAMP
>   , dt01 DATE default CURRENT_DATE
>   , ti01 TIME(1) default CURRENT_TIME
>   , ts01 TIMESTAMP(1) default CURRENT_TIMESTAMP
>   , primary key (int1 asc) not droppable
> )
> store by primary key
> ;
> --- SQL operation complete.
> SQL>insert into a05table (int1, vch2) values (1,'row_1');
> --- 1 row(s) inserted.
> SQL>insert into a05table (int1, tsdf ) values 
>   (13, timestamp '1997-01-31:13:13:13');
> --- 1 row(s) inserted.
> SQL>select * from a05table order by int1;
> INT1VCH2 DT00   TIDF TSDFDT01   TI01  
>  TS01 
> ---  --  --- -- 
> -- -
>   1 row_1NULL   19:55:27 2014-06-02 19:55:27 2014-06-02 
> -34:07:06. 2014-06-02 19:55:27.6
>  13 NULL NULL   19:55:28 1997-01-31 13:13:13 2014-06-02 
> 19:55:28.6 2014-06-02 19:55:28.6
> --- 2 row(s) selected.
> SQL>select int1, dt01, ti01, ts01 from a05table order by int1;
> INT1DT01   TI01   TS01 
> --- -- -- -
>   1 2014-06-02 -34:07:06. 2014-06-02 19:55:27.6
>  13 2014-06-02 19:55:28.6 2014-06-02 19:55:28.6
> --- 2 row(s) selected.
> SQL>insert into a05table (int1, dt01) values
>   (20, date '2005-03-31');
> --- 1 row(s) inserted.
> SQL>select int1, dt01, ti01, ts01 from a05table order by int1;
> INT1DT01   TI01   TS01 
> --- -- -- -
>   1 2014-06-02 -34:07:06. 2014-06-02 19:55:27.6
>  13 2014-06-02 19:55:28.6 2014-06-02 19:55:28.6
>  20 2005-03-31 -34:07:06. 2014-06-02 19:55:28.6
> --- 3 row(s) selected.
> SQL>exit;
> -- test script
> log a09log clear;
> drop schema debug_addt105 cascade;
> create schema debug_addt105;
> set schema debug_addt105;
> drop table a05table;
> -- table start with 2 fixed length field
> create table a05table (
> int1 integer no default not null
>   , vch2 CHAR VARYING(8) 
>   , dt00 DATE
>   , tidf TIME default CURRENT_TIME
>   , tsdf TIMESTAMP(0) default CURRENT_TIMESTAMP
>   , dt01 DATE default CURRENT_DATE
>   , ti01 TIME(1) default CURRENT_TIME
>   , ts01 TIMESTAMP(1) default CURRENT_TIMESTAMP
>   , primary key (int1 asc) not droppable
> )
> store by primary key
> ;
> insert into a05table (int1, vch2) values (1,'row_1');
> insert into a05table (int1, tsdf ) values 
>   (13, timestamp '1997-01-31:13:13:13');
> select * from a05table order by int1;
> select int1, dt01, ti01, ts01 from a05table order by int1;
> insert into a05table (int1, dt01) values
>   (20, date '2005-03-31');
> select int1, dt01, ti01, ts01 from a05table order by int1;
> exit;
>  
> GIT 0530 build. Also failed on 0601 build.
> Assigned to LaunchPad User James Capps



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


[jira] [Created] (TRAFODION-1520) Option to auto-delete existing Trafodion tables on a Restore

2015-10-12 Thread Atanu Mishra (JIRA)
Atanu Mishra created TRAFODION-1520:
---

 Summary: Option to auto-delete existing Trafodion tables on a 
Restore
 Key: TRAFODION-1520
 URL: https://issues.apache.org/jira/browse/TRAFODION-1520
 Project: Apache Trafodion
  Issue Type: Improvement
Affects Versions: 1.1 (pre-incubation)
 Environment: All Trafodion environments and releases
Reporter: Atanu Mishra
Priority: Minor


Trafodion restore works by restoring back all the trafodion tables ( user 
tables and meta tables ) to an environment where trafodion is not initialized.  
Upon restore, trafodion is implicitly initialized (appears initialized because 
of restore of meta tables ).

The script checks to see if there are any trafodion tables(in hbase)  and stops 
with the following error -

[ERROR]: The target HBase has Trafodion objects.

If there are no Trafodion tables, it continues to restore.

This JIRA is to provide an option where restore will auto-delete any existing 
Trafodion tables on the instance (on positive acknowledgement from the user).




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


[jira] [Closed] (TRAFODION-1207) LP Bug: 1449190 - hbase split starvation due to transactions.

2015-10-12 Thread Atanu Mishra (JIRA)

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

Atanu Mishra closed TRAFODION-1207.
---
Resolution: Duplicate

Refer to TRAFODION-34

> LP Bug: 1449190 - hbase split starvation due to transactions.
> -
>
> Key: TRAFODION-1207
> URL: https://issues.apache.org/jira/browse/TRAFODION-1207
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: dtm
>Reporter: Guy Groulx
>Assignee: Oliver Bucaojit
>Priority: Critical
> Fix For: 2.0-incubating
>
>
> We ran a longevity test on a system.Running OE with 512 drivers.
> Our max hfile was set to 10GB.
> After a while it was noticed in some of the hbase regionserver logs 
> 2015-04-27 10:35:06,990 INFO  [regionserver60020-splits-1430121725808] 
> transactional.TrxRegionObserver: Delaying split due to transactions present. 
> Delayed : 153 minute(s) on 
> TRAFODION.JAVABENCH.OE_ORDERLINE_512,\x00\x00\x00\x04\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1430066791987.a1e39f281243d24c45d615c1b950f2a8.
> 2015-04-27 10:35:13,926 INFO  [regionserver60020-splits-1430123472882] 
> transactional.TrxRegionObserver: Delaying split due to transactions present. 
> Delayed : 124 minute(s) on 
> TRAFODION.JAVABENCH.OE_ORDERLINE_512,\x00\x00\x00\x04\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1430066791987.a1e39f281243d24c45d615c1b950f2a8.
> Looking at the hdfs GUI:
> Contents of directory 
> /apps/hbase/data/data/default/TRAFODION.JAVABENCH.OE_ORDERLINE_512/a1e39f281243d24c45d615c1b950f2a8/04ae7ce619d24b0094d85d5c39ebf8a6
> file72.49 MB
> 559232b70b5340ddaa289a30dc4d7d2c  file14.66 GB<== This is over 
> 14.66GB.
> 6c253a61ee344b1bb39d2f3a669103d3  file72.56 MB
> 8837fc13d3a241d493b3ddcbd160d869  file72.49 MB
> 901c5708daa048599de8d1441ed5ea89  file72.48 MB
> b9d4bb1179414f9686f1f3271a2b434b  file72.56 MB
> bbe2057994194a2693897bb5323a89fd  file72.56 MB
> Notice how the 2nd entry is over 10GB.   It can't split because we have 
> active transactions.   And because our 512 drivers are not letting up, the 
> split is starving out.
> Once we killed the drivers, stopping new transactions, the split happened 
> almost instantly.
> Hall, Garywinding down...
>   1:48 PM
> 2015-04-27 17:48:57,235 INFO  [regionserver60020-splits-1430135811050] 
> regionserver.SplitRequest: Region split, hbase:meta updated, and report to 
> master. 
> Parent=TRAFODION.JAVABENCH.OE_ORDERLINE_512,\x00\x00\x00\x0F\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1430066791987.2fb76848eeb9b1516ae7a80500e8870c.,
>  new regions: 
> TRAFODION.JAVABENCH.OE_ORDERLINE_512,\x00\x00\x00\x0F\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1430135811140.4cd059f95ecba06425a5c39592de4157.,
>  
> TRAFODION.JAVABENCH.OE_ORDERLINE_512,\x00\x00\x00\x0F\x80\x00\x00\xE8\x80\x00\x00\x05\x80\x00\x000\x80\x00\x00\x07,1430135811140.62d1d89a34607dfde0ec66d18ad6e91f..
>  Split took 5hrs, 52mins, 6sec
> Above says 5hr 52 mins but it actually took less than a minute once the 
> transactions stopped.
> We understand that split must be delayed until transactions have stopped, but 
> in a high transaction environments, we need to make sure that a window will 
> be given for the splits to actually happen.



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


[jira] [Commented] (TRAFODION-1519) Use free tool to build windows odbc

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

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

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

Github user arvind-narain commented on a diff in the pull request:

https://github.com/apache/incubator-trafodion/pull/116#discussion_r41810575
  
--- Diff: win-odbc64/odbcclient/README.txt ---
@@ -1,84 +1,58 @@
 # @@@ 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.
-#
+#
+# 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 @@@
 
 Prerequisite:
 
 openssl >= 0.9.8
-Microsoft Visual Studio >= 2010
-64bit odbccp32.lib from Microsoft Visual Studio 2008 or previous.
-InstallShield >= 2012
-git > 1.9
+zlib >= 1.2.8
+Microsoft Visual Studio >= 2013
+Inno Setup >= 5
 
 Build steps
 
 1. In order to make the build script able to find these prerequisites,
some variables on the top of build_os.bat and pkg.bat need to be set 
accordingly.
 
-   Set variable OPENSSL_PATH to point to openssl binary folder, for 
example:
-   set OPENSSL_PATH=E:\OpenSSL101e_bin
-   The folder should have structure like this:
-   2013/10/31  18:13  .
-   2013/10/31  18:13  ..
-   2013/10/31  18:13  bin
-   2013/02/11  08:26   435,662 changes.txt
-   2013/10/31  18:13  exp
-   2013/02/11  08:2646,614 faq.txt
-   2013/10/31  18:13  include
-   2013/10/31  18:13  lib
-   2013/02/11  09:59 1,647,616 libeay32.dll
-   2013/02/11  09:59   351,744 libssl32.dll
-   2013/02/11  08:02 6,279 license.txt
-   2013/02/11  08:2627,423 news.txt
-   2004/05/10  16:2330,423 OpenSSLhelp.chm
-   2013/02/11  08:26 9,130 readme.txt
-   2013/02/11  09:59   351,744 ssleay32.dll
-   2013/10/31  18:1320,790 unins000.dat
-   2013/10/31  18:11   715,038 unins000.exe
+   Set variable OPENSSL_LIB_PATH to point to openssl library files folder, 
for example:
+   set OPENSSL_PATH=C:\openssl-1.0.1e\lib
--- End diff --

do please build and test with > 1.0.1f - openssl bug.


> Use free tool to build windows odbc
> ---
>
> Key: TRAFODION-1519
> URL: https://issues.apache.org/jira/browse/TRAFODION-1519
> Project: Apache Trafodion
>  Issue Type: Dependency upgrade
>  Components: client-odbc-windows
>Affects Versions: 1.1 (pre-incubation)
>Reporter: Weiqing Xu
>Priority: Blocker
>  Labels: build, windows
> Fix For: 1.2-incubating
>
>
> 1. Use Visual Studio Community 2013 instead of Visual Studio 2010. Visual 
> Studio Community 2013 is free.
> 2. Use open source tool inno setup to package windows ODBC Driver.



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


[jira] [Commented] (TRAFODION-1519) Use free tool to build windows odbc

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

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

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

Github user arvind-narain commented on a diff in the pull request:

https://github.com/apache/incubator-trafodion/pull/116#discussion_r41809373
  
--- Diff: win-odbc64/odbcclient/build_os.bat ---
@@ -189,4 +153,12 @@ if %ALL_SUCCESS%==1 (
echo=
 )
 cd %SRCDIR%\odbcclient
--- End diff --

These lines should be in the previous if block ( if success )


> Use free tool to build windows odbc
> ---
>
> Key: TRAFODION-1519
> URL: https://issues.apache.org/jira/browse/TRAFODION-1519
> Project: Apache Trafodion
>  Issue Type: Dependency upgrade
>  Components: client-odbc-windows
>Affects Versions: 1.1 (pre-incubation)
>Reporter: Weiqing Xu
>Priority: Blocker
>  Labels: build, windows
> Fix For: 1.2-incubating
>
>
> 1. Use Visual Studio Community 2013 instead of Visual Studio 2010. Visual 
> Studio Community 2013 is free.
> 2. Use open source tool inno setup to package windows ODBC Driver.



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


[jira] [Commented] (TRAFODION-1521) Trafodion build should not require HBase to be installed

2015-10-12 Thread Hans Zeller (JIRA)

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

Hans Zeller commented on TRAFODION-1521:


Note: Once this fix is checked in, users will need to do "sqgen" to update 
their classpath. This is because we need a new jar in the classpath: 
trafodion-dtm-1.2.0.jar.

> Trafodion build should not require HBase to be installed
> 
>
> Key: TRAFODION-1521
> URL: https://issues.apache.org/jira/browse/TRAFODION-1521
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: 1.1 (pre-incubation)
> Environment: Any
>Reporter: Hans Zeller
>  Labels: build
> Fix For: 1.2-incubating
>
>   Original Estimate: 96h
>  Remaining Estimate: 96h
>
> When we build Trafodion in a source tree, it should not be necessary to 
> install HBase first.
> Until now, several build steps relied on an HBase installation:
> 1. Files in core/sql/executor include the libhdfs header file, hdfs.h. This 
> file isn't available in the Trafodion source tree.
> 2. When we link certain executables like mxosrvr and sqlci, we specify 
> -lhdfs, requiring the libhdfs.so DLL as well as the DLLs it depends on, 
> libhadoop.so and libjvm.so.
> 3. Until recently, executor Java (core/sql/executor) files were compiled with 
> javac invocations from a Makefile, requiring the HBase client jar files in 
> the CLASSPATH. This got changed with TRAFODION-1502.
> 4. I missed some more Java files in the fix for TRAFODION-1502: 
> core/sqf/src/seatrans/tm/hbasetmlib2. Those should also be moved to Maven.



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


[jira] [Work started] (TRAFODION-1521) Trafodion build should not require HBase to be installed

2015-10-12 Thread Hans Zeller (JIRA)

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

Work on TRAFODION-1521 started by Hans Zeller.
--
> Trafodion build should not require HBase to be installed
> 
>
> Key: TRAFODION-1521
> URL: https://issues.apache.org/jira/browse/TRAFODION-1521
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: 1.1 (pre-incubation)
> Environment: Any
>Reporter: Hans Zeller
>Assignee: Hans Zeller
>  Labels: build
> Fix For: 1.2-incubating
>
>   Original Estimate: 96h
>  Remaining Estimate: 96h
>
> When we build Trafodion in a source tree, it should not be necessary to 
> install HBase first.
> Until now, several build steps relied on an HBase installation:
> 1. Files in core/sql/executor include the libhdfs header file, hdfs.h. This 
> file isn't available in the Trafodion source tree.
> 2. When we link certain executables like mxosrvr and sqlci, we specify 
> -lhdfs, requiring the libhdfs.so DLL as well as the DLLs it depends on, 
> libhadoop.so and libjvm.so.
> 3. Until recently, executor Java (core/sql/executor) files were compiled with 
> javac invocations from a Makefile, requiring the HBase client jar files in 
> the CLASSPATH. This got changed with TRAFODION-1502.
> 4. I missed some more Java files in the fix for TRAFODION-1502: 
> core/sqf/src/seatrans/tm/hbasetmlib2. Those should also be moved to Maven.



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


[jira] [Commented] (TRAFODION-1519) Use free tool to build windows odbc

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

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

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

Github user arvind-narain commented on a diff in the pull request:

https://github.com/apache/incubator-trafodion/pull/116#discussion_r41810061
  
--- Diff: win-odbc64/odbcclient/Drvr35Res/Drvr35Res_os.vcxproj ---
@@ -1,5 +1,5 @@
 
--- End diff --

Line 122 in this file should be deleted since Drvr35Res.rc2 is removed?
 


> Use free tool to build windows odbc
> ---
>
> Key: TRAFODION-1519
> URL: https://issues.apache.org/jira/browse/TRAFODION-1519
> Project: Apache Trafodion
>  Issue Type: Dependency upgrade
>  Components: client-odbc-windows
>Affects Versions: 1.1 (pre-incubation)
>Reporter: Weiqing Xu
>Priority: Blocker
>  Labels: build, windows
> Fix For: 1.2-incubating
>
>
> 1. Use Visual Studio Community 2013 instead of Visual Studio 2010. Visual 
> Studio Community 2013 is free.
> 2. Use open source tool inno setup to package windows ODBC Driver.



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


[jira] [Created] (TRAFODION-1523) Trafodion expand new node fail due to upgrade installation fail

2015-10-12 Thread liu ming (JIRA)
liu ming created TRAFODION-1523:
---

 Summary: Trafodion expand new node fail due to upgrade 
installation fail
 Key: TRAFODION-1523
 URL: https://issues.apache.org/jira/browse/TRAFODION-1523
 Project: Apache Trafodion
  Issue Type: Bug
  Components: installer
Reporter: liu ming


When we have a 4 nodes cluster up and running for a while, our test engineers 
use 'trafodion' user's VNC to do some testing.   So the HOME directory of user 
‘trafodion’ have many new things created. Like two directories: .cache , 
.mozilla .
When do expand, the installer will work in UPGRADE mode.
The installer will regenerate the ssh key and copy the whole HOME directory to 
workdir and then use PDCP to copy the workdir/HOME to all the nodes. Since 
there are direcoties like ‘.cache’, ‘.mozilla’, it failed. We noticed the 
script traf_add_user will remove the .pulse before do PDCP. We think it also 
needs to remove ‘.cache’ and ‘.mozilla’.




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


[jira] [Created] (TRAFODION-1521) Trafodion build should not require HBase to be installed

2015-10-12 Thread Hans Zeller (JIRA)
Hans Zeller created TRAFODION-1521:
--

 Summary: Trafodion build should not require HBase to be installed
 Key: TRAFODION-1521
 URL: https://issues.apache.org/jira/browse/TRAFODION-1521
 Project: Apache Trafodion
  Issue Type: Bug
  Components: sql-general
Affects Versions: 1.1 (pre-incubation)
 Environment: Any
Reporter: Hans Zeller
 Fix For: 1.2-incubating


When we build Trafodion in a source tree, it should not be necessary to install 
HBase first.

Until now, several build steps relied on an HBase installation:

1. Files in core/sql/executor include the libhdfs header file, hdfs.h. This 
file isn't available in the Trafodion source tree.

2. When we link certain executables like mxosrvr and sqlci, we specify -lhdfs, 
requiring the libhdfs.so DLL as well as the DLLs it depends on, libhadoop.so 
and libjvm.so.

3. Until recently, executor Java (core/sql/executor) files were compiled with 
javac invocations from a Makefile, requiring the HBase client jar files in the 
CLASSPATH. This got changed with TRAFODION-1502.

4. I missed some more Java files in the fix for TRAFODION-1502: 
core/sqf/src/seatrans/tm/hbasetmlib2. Those should also be moved to Maven.



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


[jira] [Commented] (TRAFODION-1521) Trafodion build should not require HBase to be installed

2015-10-12 Thread Hans Zeller (JIRA)

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

Hans Zeller commented on TRAFODION-1521:


The fix will do several things:

To address issue #1, it will add a new script, 
core/sqf/sql/scripts/get_libhdfs_files. The new script will download Google 
Protocol Buffers 2.5.0 and a source tar file for Hadoop and build 
protobuf-2.5.0 and the Hadoop native libraries. It will then copy the libraries 
(libhadoop.so and libhdfs.so) to $MY_SQROOT/export/lib${SQ_MBTYPE}. It will 
also copy the include file hdfs.h to $MY_SQROOG/include. Since this step is 
very time-consuming, it will take a shortcut if Hadoop is installed (e.g. with 
install_local_hadoop), in that case it will copy the existing native libraries.

To address the remaining needs for jar files during the build, the hbasetmlib2 
build will be converted to Maven.

We will also remove the case in sqenvcom.sh where a configuration does not have 
install_local_hadoop, Cloudera, Hortonworks or MapR installed, but has a 
TOOLSDIR. Such cases should use the recently added case for a native Apache 
Hadoop installation or the case where no HBase installation is found. That last 
case will print out a reminder that can be ignored.

> Trafodion build should not require HBase to be installed
> 
>
> Key: TRAFODION-1521
> URL: https://issues.apache.org/jira/browse/TRAFODION-1521
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: sql-general
>Affects Versions: 1.1 (pre-incubation)
> Environment: Any
>Reporter: Hans Zeller
>  Labels: build
> Fix For: 1.2-incubating
>
>   Original Estimate: 96h
>  Remaining Estimate: 96h
>
> When we build Trafodion in a source tree, it should not be necessary to 
> install HBase first.
> Until now, several build steps relied on an HBase installation:
> 1. Files in core/sql/executor include the libhdfs header file, hdfs.h. This 
> file isn't available in the Trafodion source tree.
> 2. When we link certain executables like mxosrvr and sqlci, we specify 
> -lhdfs, requiring the libhdfs.so DLL as well as the DLLs it depends on, 
> libhadoop.so and libjvm.so.
> 3. Until recently, executor Java (core/sql/executor) files were compiled with 
> javac invocations from a Makefile, requiring the HBase client jar files in 
> the CLASSPATH. This got changed with TRAFODION-1502.
> 4. I missed some more Java files in the fix for TRAFODION-1502: 
> core/sqf/src/seatrans/tm/hbasetmlib2. Those should also be moved to Maven.



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