[jira] [Resolved] (TRAFODION-2592) Give better diagnostics when HBase is not available while Trafodion starts

2017-04-13 Thread Hans Zeller (JIRA)

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

Hans Zeller resolved TRAFODION-2592.

Resolution: Fixed

> Give better diagnostics when HBase is not available while Trafodion starts
> --
>
> Key: TRAFODION-2592
> URL: https://issues.apache.org/jira/browse/TRAFODION-2592
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: foundation
>Affects Versions: 1.1 (pre-incubation)
> Environment: any
>Reporter: Hans Zeller
>Assignee: Hans Zeller
> Fix For: 2.2-incubating
>
>
> When Trafodion gets started with sqstart and HBase is down, Trafodion may 
> hang or fail with difficult to understand error messages. We should give an 
> easy to understand diagnostics that pinpoints the HBase status as the source 
> of the problem.
> Narendra has written a tool that does just that, I'll add a call to this tool 
> to the sqstart method.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Closed] (TRAFODION-2592) Give better diagnostics when HBase is not available while Trafodion starts

2017-04-13 Thread Hans Zeller (JIRA)

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

Hans Zeller closed TRAFODION-2592.
--

> Give better diagnostics when HBase is not available while Trafodion starts
> --
>
> Key: TRAFODION-2592
> URL: https://issues.apache.org/jira/browse/TRAFODION-2592
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: foundation
>Affects Versions: 1.1 (pre-incubation)
> Environment: any
>Reporter: Hans Zeller
>Assignee: Hans Zeller
> Fix For: 2.2-incubating
>
>
> When Trafodion gets started with sqstart and HBase is down, Trafodion may 
> hang or fail with difficult to understand error messages. We should give an 
> easy to understand diagnostics that pinpoints the HBase status as the source 
> of the problem.
> Narendra has written a tool that does just that, I'll add a call to this tool 
> to the sqstart method.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Commented] (TRAFODION-2592) Give better diagnostics when HBase is not available while Trafodion starts

2017-04-13 Thread ASF GitHub Bot (JIRA)

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

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

Github user asfgit closed the pull request at:

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


> Give better diagnostics when HBase is not available while Trafodion starts
> --
>
> Key: TRAFODION-2592
> URL: https://issues.apache.org/jira/browse/TRAFODION-2592
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: foundation
>Affects Versions: 1.1 (pre-incubation)
> Environment: any
>Reporter: Hans Zeller
>Assignee: Hans Zeller
> Fix For: 2.2-incubating
>
>
> When Trafodion gets started with sqstart and HBase is down, Trafodion may 
> hang or fail with difficult to understand error messages. We should give an 
> easy to understand diagnostics that pinpoints the HBase status as the source 
> of the problem.
> Narendra has written a tool that does just that, I'll add a call to this tool 
> to the sqstart method.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Commented] (TRAFODION-1989) after uninstall, and reinstall again, dcscheck report dcs master not up

2017-04-13 Thread ASF GitHub Bot (JIRA)

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

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

GitHub user svarnau opened a pull request:

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

[TRAFODION-1989] Add earlier fix to ambari installer



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

$ git pull https://github.com/svarnau/incubator-trafodion master

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

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


commit 4ce851bceeb0906f34b17edcb245f7234a25fb19
Author: Steve Varnau 
Date:   2017-04-13T22:06:25Z

[TRAFODION-1989] Add earlier fix to ambari installer




> after uninstall, and reinstall again, dcscheck report dcs master not up
> ---
>
> Key: TRAFODION-1989
> URL: https://issues.apache.org/jira/browse/TRAFODION-1989
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: installer
>Reporter: liu ming
>Assignee: Steve Varnau
>
> in the same cluster, one install a trafodion version.
> then use trafodion_uninstaller to remove the installation.
> later at same cluster, install again via trafodion_install
> after the new installation, dcscheck fail.
> jps cannot show related DCS java processes, but those processes are up and 
> running.
> It is due to a legacy /tmp/hsperfdata_trafodion direcotry belong to the 
> previous trafodion user. The new user cannot write into this folder, but jps 
> rely on it to work correct. And dcscheck rely on jps to work correctly.
> Either installer remove that legacy directory, or uninstaller remove it. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Assigned] (TRAFODION-1989) after uninstall, and reinstall again, dcscheck report dcs master not up

2017-04-13 Thread Steve Varnau (JIRA)

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

Steve Varnau reassigned TRAFODION-1989:
---

Assignee: Steve Varnau

> after uninstall, and reinstall again, dcscheck report dcs master not up
> ---
>
> Key: TRAFODION-1989
> URL: https://issues.apache.org/jira/browse/TRAFODION-1989
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: installer
>Reporter: liu ming
>Assignee: Steve Varnau
>
> in the same cluster, one install a trafodion version.
> then use trafodion_uninstaller to remove the installation.
> later at same cluster, install again via trafodion_install
> after the new installation, dcscheck fail.
> jps cannot show related DCS java processes, but those processes are up and 
> running.
> It is due to a legacy /tmp/hsperfdata_trafodion direcotry belong to the 
> previous trafodion user. The new user cannot write into this folder, but jps 
> rely on it to work correct. And dcscheck rely on jps to work correctly.
> Either installer remove that legacy directory, or uninstaller remove it. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Commented] (TRAFODION-2592) Give better diagnostics when HBase is not available while Trafodion starts

2017-04-13 Thread ASF GitHub Bot (JIRA)

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

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

GitHub user zellerh opened a pull request:

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

[TRAFODION-2592] Better error message when HBase is down at startup.

This code was written by Narendra Goyal.

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

$ git pull https://github.com/zellerh/incubator-trafodion bug/cses_jan-17

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

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


commit ebfd515abb947996fe7effe9475dc0be3b1b3db0
Author: Hans Zeller 
Date:   2017-04-13T15:36:31Z

[TRAFODION-2592] Better error message when HBase is down at startup.

This code was written by Narendra Goyal.




> Give better diagnostics when HBase is not available while Trafodion starts
> --
>
> Key: TRAFODION-2592
> URL: https://issues.apache.org/jira/browse/TRAFODION-2592
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: foundation
>Affects Versions: 1.1 (pre-incubation)
> Environment: any
>Reporter: Hans Zeller
>Assignee: Hans Zeller
> Fix For: 2.2-incubating
>
>
> When Trafodion gets started with sqstart and HBase is down, Trafodion may 
> hang or fail with difficult to understand error messages. We should give an 
> easy to understand diagnostics that pinpoints the HBase status as the source 
> of the problem.
> Narendra has written a tool that does just that, I'll add a call to this tool 
> to the sqstart method.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Created] (TRAFODION-2592) Give better diagnostics when HBase is not available while Trafodion starts

2017-04-13 Thread Hans Zeller (JIRA)
Hans Zeller created TRAFODION-2592:
--

 Summary: Give better diagnostics when HBase is not available while 
Trafodion starts
 Key: TRAFODION-2592
 URL: https://issues.apache.org/jira/browse/TRAFODION-2592
 Project: Apache Trafodion
  Issue Type: Bug
  Components: foundation
Affects Versions: 1.1 (pre-incubation)
 Environment: any
Reporter: Hans Zeller
Assignee: Hans Zeller
 Fix For: 2.2-incubating


When Trafodion gets started with sqstart and HBase is down, Trafodion may hang 
or fail with difficult to understand error messages. We should give an easy to 
understand diagnostics that pinpoints the HBase status as the source of the 
problem.

Narendra has written a tool that does just that, I'll add a call to this tool 
to the sqstart method.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Work started] (TRAFODION-2592) Give better diagnostics when HBase is not available while Trafodion starts

2017-04-13 Thread Hans Zeller (JIRA)

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

Work on TRAFODION-2592 started by Hans Zeller.
--
> Give better diagnostics when HBase is not available while Trafodion starts
> --
>
> Key: TRAFODION-2592
> URL: https://issues.apache.org/jira/browse/TRAFODION-2592
> Project: Apache Trafodion
>  Issue Type: Bug
>  Components: foundation
>Affects Versions: 1.1 (pre-incubation)
> Environment: any
>Reporter: Hans Zeller
>Assignee: Hans Zeller
> Fix For: 2.2-incubating
>
>
> When Trafodion gets started with sqstart and HBase is down, Trafodion may 
> hang or fail with difficult to understand error messages. We should give an 
> easy to understand diagnostics that pinpoints the HBase status as the source 
> of the problem.
> Narendra has written a tool that does just that, I'll add a call to this tool 
> to the sqstart method.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Commented] (TRAFODION-2366) odb copy or load with Chinese characters will return gibberish

2017-04-13 Thread JIRA

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

苏锦佩 commented on TRAFODION-2366:


I found that after doing below steps,  odb work well with chinese of utf8 
encoding.
   
1.  Install unixODBC from source with below configure.
$  tar xf unixODBC-2.3.4.tar.gz
$ ./configure --disable-gui --disable-drivers --enable-stats=no --enable-iconv 
--with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE
$ make
$ sudo make install

2.  Config DSN with the option ClientCharSet=UTF8 (Case sensitive, thanks 
for rachel’s reminder), for example:
[TRAF_UTF8]
Description = Default Data Source
Catalog = TRAFODION
Schema  = RACHEL_ODBCTEST_U8
DataLang= 0
FetchBufferSize = SYSTEM_DEFAULT
Server  = TCP:10.10.10.173:23400
ClientCharSet   = UTF8
SQL_ATTR_CONNECTION_TIMEOUT = SYSTEM_DEFAULT
SQL_LOGIN_TIMEOUT   = SYSTEM_DEFAULT

Test Result:

create table test003(id int, name varchar(16) CHARACTER SET UTF8, text 
varchar(256) CHARACTER SET UTF8);

#./odb64luo -u trafodion -p traf123 -d traf -l 
src=/root/trafodion/odb/bin/test:tgt=TRAFODION.QA.TEST003:fs=\|:rows=1000:loadcmd=UL:truncate:parallel=4

#cat /root/trafodion/odb/bin/test

--

1|j|kddd

2|中国|

3|jjd|哪里

4|那到底|的地方

--

trafci:

select * from TEST003; ID NAME TXT

---  


1 j kddd

2 中国 

3 jjd 哪里

4 那到底 的地方

--- 4 row(s) selected.

> odb copy or load with Chinese characters will return gibberish
> --
>
> Key: TRAFODION-2366
> URL: https://issues.apache.org/jira/browse/TRAFODION-2366
> Project: Apache Trafodion
>  Issue Type: Bug
>Reporter: zhangliang
>Assignee: zhangliang
>Priority: Minor
>
> odb cmd is 
> ./odb64luo -u zale -p zale -d gy_poc -l 
> src=sample.csv:tgt=trafodion.odb_copy.load_ch:max=50:rows=5000:parallel=2:loadcmd=UL:fs=,:bad=bad2
> File to load with Chinese characters  is like
> ...
> SW001600,测试,2000/1/29 13:05:00,2.62,
> SW001600,测试,2000/1/29 13:25:00,2.62,
> SW001600,测试,2000/1/29 14:10:00,2.61,
> SW001600,测试,2000/1/29 09:55:00,2.63,
> SW001600,测试,2000/1/29 13:35:00,2.62,
> SW001600,测试,2000/1/29 11:00:00,2.64,
> SW001600,测试,2000/1/29 13:45:00,2.62,
> ...
> While select from sqlci or DB manager, return gibberish, like:
> ST_STATIONIDST_STATIONNAME
>  DT_TIMENM_OUTWATER NM_INWATER
>  
>  
> --- -- 
> HY007415 大戢山
>2000-01-01 10:00:00   0.00 NULL
> HY007415 大戢山
>2000-01-02 10:00:00   0.00 NULL
> PDHFA366 五号沟
>1970-01-01 00:50:00   1.56 NULL
> SW001100罗店
>   2000-01-01 12:00:00   1.56 NULL
> SW001600五号沟 
>   2000-01-29 09:25:00   2.63 NULL
> SW001600五号沟 
>   2000-01-29 09:30:00   2.63 NULL
> SW001600五号沟 
>   2000-01-29 09:35:00   2.63 NULL
> ...
> HY007415  大戢山   946692000   
> HY007415  大戢山   946778400   
> PDHFA366  五号沟   -2580   1.56
> SW001100  罗店  946699201.56
> SW001600  五号沟   949109102.63
> SW001600  五号沟   949109402.63
> The same as copy function.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)