[jira] [Commented] (TRAFODION-1643) instantiation of ScanInfo changed after hbase-0.98.8
[ https://issues.apache.org/jira/browse/TRAFODION-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15033131#comment-15033131 ] ASF GitHub Bot commented on TRAFODION-1643: --- GitHub user mashengchen opened a pull request: https://github.com/apache/incubator-trafodion/pull/197 TRAFODION-1643 after hbase-0.98.8(include 0.98.8), the instantiation process of ScanInfo(class) is different from before, which need KeepDeletedCells(enum) as parameter instead of boolean. You can merge this pull request into a Git repository by running: $ git pull https://github.com/mashengchen/incubator-trafodion master Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/197.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 #197 commit e2d32a510bc29e25962604073d486fc355601a37 Author: mashengchen Date: 2015-12-01T05:28:25Z TRAFODION-1643 > instantiation of ScanInfo changed after hbase-0.98.8 > > > Key: TRAFODION-1643 > URL: https://issues.apache.org/jira/browse/TRAFODION-1643 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming > > after hbase-0.98.8(include 0.98.8), the instantiation process of > ScanInfo(class) is different from before, which need KeepDeletedCells(enum) > as parameter instead of boolean. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1643) instantiation of ScanInfo changed after hbase-0.98.8
[ https://issues.apache.org/jira/browse/TRAFODION-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15033127#comment-15033127 ] ASF GitHub Bot commented on TRAFODION-1643: --- Github user mashengchen closed the pull request at: https://github.com/apache/incubator-trafodion/pull/193 > instantiation of ScanInfo changed after hbase-0.98.8 > > > Key: TRAFODION-1643 > URL: https://issues.apache.org/jira/browse/TRAFODION-1643 > Project: Apache Trafodion > Issue Type: Bug >Reporter: liu ming > > after hbase-0.98.8(include 0.98.8), the instantiation process of > ScanInfo(class) is different from before, which need KeepDeletedCells(enum) > as parameter instead of boolean. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1558) Tableau returns to tables or data
[
https://issues.apache.org/jira/browse/TRAFODION-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15033105#comment-15033105
]
ASF GitHub Bot commented on TRAFODION-1558:
---
Github user selvaganesang commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/192#discussion_r46240887
--- Diff: win-odbc64/odbcclient/drvr35/cstmt.cpp ---
@@ -3389,7 +3389,7 @@ BOOL CStmt::setFetchOutputPerf(long rowsFetched,
SQL_DataValue_def*& outputDataV
m_FetchDataValue.numberOfRows = rowsFetched;
if(rowsFetched > 0)
{
-m_FetchDataValue.rowAddress = new unsigned long[rowsFetched];
+m_FetchDataValue.rowAddress = new LONG_PTR[rowsFetched];
--- End diff --
Thanks for your prompt response. Use of LONG_PTR is justified very well. No
need to change it to void *
> Tableau returns to tables or data
> -
>
> Key: TRAFODION-1558
> URL: https://issues.apache.org/jira/browse/TRAFODION-1558
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-windows
>Affects Versions: 1.2-incubating
> Environment: Windows 10 with latest Tableau version.
>Reporter: Gunnar Tapper
>Assignee: Weiqing Xu
>Priority: Critical
> Fix For: 1.2-incubating
>
>
> Used driver connection with TCP:/. Connection succeeded but no
> schemas or tables are listed.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (TRAFODION-1558) Tableau returns to tables or data
[
https://issues.apache.org/jira/browse/TRAFODION-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032964#comment-15032964
]
ASF GitHub Bot commented on TRAFODION-1558:
---
Github user xwq commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/192#discussion_r46234065
--- Diff: win-odbc64/odbcclient/drvr35/cstmt.cpp ---
@@ -3389,7 +3389,7 @@ BOOL CStmt::setFetchOutputPerf(long rowsFetched,
SQL_DataValue_def*& outputDataV
m_FetchDataValue.numberOfRows = rowsFetched;
if(rowsFetched > 0)
{
-m_FetchDataValue.rowAddress = new unsigned long[rowsFetched];
+m_FetchDataValue.rowAddress = new LONG_PTR[rowsFetched];
--- End diff --
The issue here is that the long is 4 bytes in Windows x64. windows can
ensure the LONG_PTR is 8 bytes in x64 system and 4 bytes in x32 system. I use
LONG_PTR because of a lot Windows API use it . There is no VOID_PTR type.
I can use (void *) instead if you insist .
> Tableau returns to tables or data
> -
>
> Key: TRAFODION-1558
> URL: https://issues.apache.org/jira/browse/TRAFODION-1558
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-windows
>Affects Versions: 1.2-incubating
> Environment: Windows 10 with latest Tableau version.
>Reporter: Gunnar Tapper
>Assignee: Weiqing Xu
>Priority: Critical
> Fix For: 1.2-incubating
>
>
> Used driver connection with TCP:/. Connection succeeded but no
> schemas or tables are listed.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (TRAFODION-1647) Trafci on linux shows the banner and copyright is null
[ https://issues.apache.org/jira/browse/TRAFODION-1647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032771#comment-15032771 ] ASF GitHub Bot commented on TRAFODION-1647: --- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/189 > Trafci on linux shows the banner and copyright is null > -- > > Key: TRAFODION-1647 > URL: https://issues.apache.org/jira/browse/TRAFODION-1647 > Project: Apache Trafodion > Issue Type: Bug > Components: client-ci >Affects Versions: 1.3-incubating > Environment: centos6.7 and suse11 >Reporter: Gao, Rui-Xian > > on linux platform, install trafci with trafciinstaller.jar, then execute > trafci.sh from the install dirctory, it shows the banner and copyright is > null > [centos@rachel01 bin]$ ./trafci.sh > Welcome to null Command Interface > Copyright (c) null > Host Name/IP Address: -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1626) DTMCI STATS shows incredibly high transaction counts while sqstart is in progress
[
https://issues.apache.org/jira/browse/TRAFODION-1626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032768#comment-15032768
]
Trina Krug commented on TRAFODION-1626:
---
I followed the model for process_statustm where it simply printed an error in
both cases regardless. IF this is incorrect, I can correct both cases. There
is, however, another case that does it altogether different and simply prints
out null/zero type values in its formatted data (as well as NOTAVILABLE,
etc..). Venkat - I'd like your input as to which way is best/expected.
> DTMCI STATS shows incredibly high transaction counts while sqstart is in
> progress
> -
>
> Key: TRAFODION-1626
> URL: https://issues.apache.org/jira/browse/TRAFODION-1626
> Project: Apache Trafodion
> Issue Type: Bug
> Components: dtm
>Reporter: Venkat Muthuswamy
>Assignee: Trina Krug
>
> When 'dtmci stats -j' command is invoked while the trafodion instance is
> still starting up, we see incredibly high numbers for the transaction counts.
> $ dtmci stats -j
> [{"node": 0,"txnStats":{"txnBegins": 140727707549696,"txnAborts":
> 140334087297536,"txnCommits": 0}},{"node": 1,"txnStats":{"txnBegins":
> 140727707549696,"txnAborts": 140334087297536,"txnCommits": 0}},{"node":
> 2,"txnStats":{"txnBegins": 140727707549696,"txnAborts":
> 140334087297536,"txnCommits": 0}}]
> $ dtmci stats -j
> [{"node": 0,"txnStats":{"txnBegins": 140732063999184,"txnAborts":
> 140429416520192,"txnCommits": 0}},{"node": 1,"txnStats":{"txnBegins":
> 140732063999184,"txnAborts": 140429416520192,"txnCommits": 0}},{"node":
> 2,"txnStats":{"txnBegins": 140732063999184,"txnAborts":
> 140429416520192,"txnCommits": 0}}]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (TRAFODION-1626) DTMCI STATS shows incredibly high transaction counts while sqstart is in progress
[
https://issues.apache.org/jira/browse/TRAFODION-1626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032687#comment-15032687
]
ASF GitHub Bot commented on TRAFODION-1626:
---
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/196#discussion_r46218270
--- Diff: core/sqf/src/tm/tools/dtmci.cpp ---
@@ -472,23 +472,22 @@ void process_tmstats_node(bool pv_reset, int32
pv_nid, bool json)
lv_error = TMSTATS(pv_nid, &lv_stats, pv_reset);
-if(json==false) {
-if (lv_error)
-printf("Node %d\t**Error %d.", pv_nid, lv_error);
-else
-{
-printf("Node %d:", pv_nid);
-print_counters(&lv_stats.iv_counts);
-print_txnStats(&lv_stats.iv_txn);
-
-// Pool statistics
-printf("\n Txn Pool:\t");
-print_poolStats(lv_stats.iv_transactionPool_stats);
-printf("\n Thrd Pool:\t");
-print_poolStats(lv_stats.iv_threadPool_stats);
-printf("\n RMMsg Pool:\t");
-print_poolStats(lv_stats.iv_RMMessagePool_stats);
-}
+if (lv_error) {
+printf("Node %d\t**Error %d.\n", pv_nid, lv_error);
--- End diff --
Should the error be reported as a JSON document in the JSON case?
> DTMCI STATS shows incredibly high transaction counts while sqstart is in
> progress
> -
>
> Key: TRAFODION-1626
> URL: https://issues.apache.org/jira/browse/TRAFODION-1626
> Project: Apache Trafodion
> Issue Type: Bug
> Components: dtm
>Reporter: Venkat Muthuswamy
>Assignee: Trina Krug
>
> When 'dtmci stats -j' command is invoked while the trafodion instance is
> still starting up, we see incredibly high numbers for the transaction counts.
> $ dtmci stats -j
> [{"node": 0,"txnStats":{"txnBegins": 140727707549696,"txnAborts":
> 140334087297536,"txnCommits": 0}},{"node": 1,"txnStats":{"txnBegins":
> 140727707549696,"txnAborts": 140334087297536,"txnCommits": 0}},{"node":
> 2,"txnStats":{"txnBegins": 140727707549696,"txnAborts":
> 140334087297536,"txnCommits": 0}}]
> $ dtmci stats -j
> [{"node": 0,"txnStats":{"txnBegins": 140732063999184,"txnAborts":
> 140429416520192,"txnCommits": 0}},{"node": 1,"txnStats":{"txnBegins":
> 140732063999184,"txnAborts": 140429416520192,"txnCommits": 0}},{"node":
> 2,"txnStats":{"txnBegins": 140732063999184,"txnAborts":
> 140429416520192,"txnCommits": 0}}]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (TRAFODION-1626) DTMCI STATS shows incredibly high transaction counts while sqstart is in progress
[
https://issues.apache.org/jira/browse/TRAFODION-1626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032615#comment-15032615
]
ASF GitHub Bot commented on TRAFODION-1626:
---
GitHub user trinakrug opened a pull request:
https://github.com/apache/incubator-trafodion/pull/196
TRAFODION-1626 fix for dtmci statis -j
Errors were not being checked after the TMSTATS call for the "json" case.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/trinakrug/incubator-trafodion tktraf_fixes
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/196.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 #196
commit ef04905e245cf072014c8f005ee3b7962a01bba8
Author: Trina Krug
Date: 2015-11-30T22:27:28Z
TRAFODION-1626 fix for dtmci statis -j
> DTMCI STATS shows incredibly high transaction counts while sqstart is in
> progress
> -
>
> Key: TRAFODION-1626
> URL: https://issues.apache.org/jira/browse/TRAFODION-1626
> Project: Apache Trafodion
> Issue Type: Bug
> Components: dtm
>Reporter: Venkat Muthuswamy
>Assignee: Trina Krug
>
> When 'dtmci stats -j' command is invoked while the trafodion instance is
> still starting up, we see incredibly high numbers for the transaction counts.
> $ dtmci stats -j
> [{"node": 0,"txnStats":{"txnBegins": 140727707549696,"txnAborts":
> 140334087297536,"txnCommits": 0}},{"node": 1,"txnStats":{"txnBegins":
> 140727707549696,"txnAborts": 140334087297536,"txnCommits": 0}},{"node":
> 2,"txnStats":{"txnBegins": 140727707549696,"txnAborts":
> 140334087297536,"txnCommits": 0}}]
> $ dtmci stats -j
> [{"node": 0,"txnStats":{"txnBegins": 140732063999184,"txnAborts":
> 140429416520192,"txnCommits": 0}},{"node": 1,"txnStats":{"txnBegins":
> 140732063999184,"txnAborts": 140429416520192,"txnCommits": 0}},{"node":
> 2,"txnStats":{"txnBegins": 140732063999184,"txnAborts":
> 140429416520192,"txnCommits": 0}}]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (TRAFODION-1626) DTMCI STATS shows incredibly high transaction counts while sqstart is in progress
[
https://issues.apache.org/jira/browse/TRAFODION-1626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032597#comment-15032597
]
Trina Krug commented on TRAFODION-1626:
---
Error checking is not being done in the "json" case for the TMSTATS call.
Moved the error checking outside the (json == false) case.
> DTMCI STATS shows incredibly high transaction counts while sqstart is in
> progress
> -
>
> Key: TRAFODION-1626
> URL: https://issues.apache.org/jira/browse/TRAFODION-1626
> Project: Apache Trafodion
> Issue Type: Bug
> Components: dtm
>Reporter: Venkat Muthuswamy
>Assignee: Trina Krug
>
> When 'dtmci stats -j' command is invoked while the trafodion instance is
> still starting up, we see incredibly high numbers for the transaction counts.
> $ dtmci stats -j
> [{"node": 0,"txnStats":{"txnBegins": 140727707549696,"txnAborts":
> 140334087297536,"txnCommits": 0}},{"node": 1,"txnStats":{"txnBegins":
> 140727707549696,"txnAborts": 140334087297536,"txnCommits": 0}},{"node":
> 2,"txnStats":{"txnBegins": 140727707549696,"txnAborts":
> 140334087297536,"txnCommits": 0}}]
> $ dtmci stats -j
> [{"node": 0,"txnStats":{"txnBegins": 140732063999184,"txnAborts":
> 140429416520192,"txnCommits": 0}},{"node": 1,"txnStats":{"txnBegins":
> 140732063999184,"txnAborts": 140429416520192,"txnCommits": 0}},{"node":
> 2,"txnStats":{"txnBegins": 140732063999184,"txnAborts":
> 140429416520192,"txnCommits": 0}}]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Assigned] (TRAFODION-1618) Row count estimation method used in Update stats can be improved
[ https://issues.apache.org/jira/browse/TRAFODION-1618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall reassigned TRAFODION-1618: --- Assignee: David Wayne Birdsall > Row count estimation method used in Update stats can be improved > > > Key: TRAFODION-1618 > URL: https://issues.apache.org/jira/browse/TRAFODION-1618 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Reporter: Qifan Chen >Assignee: David Wayne Birdsall > > For a customer table, the row count is estimated as 2343750004, while the > actual row account is 25055150. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (TRAFODION-1591) Need a better way to pick ports for install_local_hadoop
[ https://issues.apache.org/jira/browse/TRAFODION-1591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wayne Birdsall resolved TRAFODION-1591. - Resolution: Fixed Fix Version/s: 2.0-incubating > Need a better way to pick ports for install_local_hadoop > > > Key: TRAFODION-1591 > URL: https://issues.apache.org/jira/browse/TRAFODION-1591 > Project: Apache Trafodion > Issue Type: Improvement > Components: sql-general >Affects Versions: 2.0-incubating >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall >Priority: Minor > Fix For: 2.0-incubating > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Reopened] (TRAFODION-736) LP Bug: 1389010 - ODBC API SQLColAttributes returns wrong column numbers of table in GBK Unicode mode
[
https://issues.apache.org/jira/browse/TRAFODION-736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Varnau reopened TRAFODION-736:
Re-opened on behalf of Rachel (Rui-Xian) Gao.
> LP Bug: 1389010 - ODBC API SQLColAttributes returns wrong column numbers of
> table in GBK Unicode mode
> -
>
> Key: TRAFODION-736
> URL: https://issues.apache.org/jira/browse/TRAFODION-736
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-linux
>Reporter: JiepingZhang
>Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> Table below has total of 29 columns, but somehow SQLColAttributes only
> returns 26 as the total column number of the table. This only happens in
> Unicode test, it can be reproduced via Coast SQLColumnAttribute tests.
> >> create table "ÃÃõÃô÷Ãë¹Ã1"("ÃÂAR(10) CHARACTER SET
> >> ISO88591,"á2" VARCHAR(10) CHARACTER SET ISO88591,"á3"
> >> DECIMAL(10,5),"4" DECIMAL(5,2) UNSIGNED,"á5" NUMERIC(10,5),"á6"
> >> NUMERIC(5,2) UNSIGNED,"á7" SMALLINT,"ÃÂSMALLINT UNSIGNED,"á9"
> >> INTEGER,"á10" INTEGER UNSIGNED,"á11" REAL,"á12" FLOAT,"á13" D
> >> PRECISION,"á14" DATE,"á15" TIME,"á16" TIMESTAMP,"á17"
> >> BIGINT,"á18" LONG VARCHAR CHAR SET ISO88591,"á19"
> >> NUMERIC(19,0),"á20" NUMERIC(19,6),"á21" NUMERIC(128,0),"á22"
> >> NUME128,128),"á23" NUMERIC(128,64),"á24" NUMERIC(10,5)
> >> UNSIGNED,"á25" NUMERIC(18,5) UNSIGNED¡26" NUMERIC(30,10)
> >> UNSIGNED,"á27" CHAR(10) CHARACTER SET utf8,"á28" VARCHAR(10)
> >> CHARACTEET utf8,"á29" LONG VARCHAR CHARACTER SET utf8) NO PARTITION;
> Test failed at:
> 18:12:32 SQLColAttributes: Positive test for column 1
> 2
> ***ERROR: Column C1 & ColAtt SQL_COLUMN_COUNT, Line = 316
> ***ERROR: rgbDesc Expected: '' Actual: '', Line = 317
> ***ERROR: pcbDesc Expected: 0 Actual: 0, Line = 318
> ***ERROR: pfDesc Expected: 29 Actual: 26, Line = 320
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (TRAFODION-1655) RMS reports incorrect hbase io time and 0 for OperCpuTime for operators hosted in ESP
Selvaganesan Govindarajan created TRAFODION-1655: Summary: 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-1558) Tableau returns to tables or data
[
https://issues.apache.org/jira/browse/TRAFODION-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15031898#comment-15031898
]
ASF GitHub Bot commented on TRAFODION-1558:
---
Github user selvaganesang commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/192#discussion_r46152896
--- Diff: win-odbc64/odbcclient/drvr35/cstmt.cpp ---
@@ -3389,7 +3389,7 @@ BOOL CStmt::setFetchOutputPerf(long rowsFetched,
SQL_DataValue_def*& outputDataV
m_FetchDataValue.numberOfRows = rowsFetched;
if(rowsFetched > 0)
{
-m_FetchDataValue.rowAddress = new unsigned long[rowsFetched];
+m_FetchDataValue.rowAddress = new LONG_PTR[rowsFetched];
--- End diff --
Should it be VOID_PTR or (void *) instead.
> Tableau returns to tables or data
> -
>
> Key: TRAFODION-1558
> URL: https://issues.apache.org/jira/browse/TRAFODION-1558
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-windows
>Affects Versions: 1.2-incubating
> Environment: Windows 10 with latest Tableau version.
>Reporter: Gunnar Tapper
>Assignee: Weiqing Xu
>Priority: Critical
> Fix For: 1.2-incubating
>
>
> Used driver connection with TCP:/. Connection succeeded but no
> schemas or tables are listed.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Created] (TRAFODION-1654) Need to check the UECs on predicate-less key columns when consider MDAM
Qifan Chen created TRAFODION-1654: - Summary: Need to check the UECs on predicate-less key columns when consider MDAM Key: TRAFODION-1654 URL: https://issues.apache.org/jira/browse/TRAFODION-1654 Project: Apache Trafodion Issue Type: Bug Components: sql-cmp Reporter: Qifan Chen When some key columns are predicate less, the current heuristics does not consider the UECs of these key columns, especially when the UECs are high. A better heuristics is to compute the product of all such UECs and assure the product is within a threshold. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Work started] (TRAFODION-1654) Need to check the UECs on predicate-less key columns when consider MDAM
[ https://issues.apache.org/jira/browse/TRAFODION-1654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on TRAFODION-1654 started by Qifan Chen. - > Need to check the UECs on predicate-less key columns when consider MDAM > --- > > Key: TRAFODION-1654 > URL: https://issues.apache.org/jira/browse/TRAFODION-1654 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Reporter: Qifan Chen >Assignee: Qifan Chen > Labels: performance > > When some key columns are predicate less, the current heuristics does not > consider the UECs of these key columns, especially when the UECs are high. > A better heuristics is to compute the product of all such UECs and assure the > product is within a threshold. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (TRAFODION-1653) coast tests core dumped at 'operator new' when Multithread DCS is on
[ https://issues.apache.org/jira/browse/TRAFODION-1653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gao, Rui-Xian updated TRAFODION-1653: - Affects Version/s: 2.0-incubating > coast tests core dumped at 'operator new' when Multithread DCS is on > > > Key: TRAFODION-1653 > URL: https://issues.apache.org/jira/browse/TRAFODION-1653 > Project: Apache Trafodion > Issue Type: Bug > Components: client-odbc-linux >Affects Versions: 2.0-incubating > Environment: suse11 >Reporter: Gao, Rui-Xian > > When MTDCS is on, several tests will run into segmentation fault. Here is the > stack trace -- > Core was generated by `./coast -d TRAF_ANSI_176 -u trafodion -p traf123 -c > ASCII -m linux64 -f API SQLSetCursorName' > (gdb) bt > #0 0x7f31ea0d4885 in raise () from /lib64/libc.so.6 > #1 0x7f31ea0d5e61 in abort () from /lib64/libc.so.6 > #2 0x7f31ea9128ad in __gnu_cxx::__verbose_terminate_handler() () from > /usr/lib64/libstdc++.so.6 > #3 0x7f31ea910986 in ?? () from /usr/lib64/libstdc++.so.6 > #4 0x7f31ea9109b3 in std::terminate() () from /usr/lib64/libstdc++.so.6 > #5 0x7f31ea910bf3 in __cxa_throw () from /usr/lib64/libstdc++.so.6 > #6 0x7f31ea9110ed in operator new(unsigned long) () from > /usr/lib64/libstdc++.so.6 > #7 0x7f31ea911189 in operator new[](unsigned long) () from > /usr/lib64/libstdc++.so.6 > #8 0x7f31ec3a2a97 in copy_ERROR_DESC_LIST (pname=0x7ffee1597e20, > curptr=@0x7ffee1597d78: 0x7cf430 "", msg_total_len=@0x7ffee1597d84: 12, > swap=78 'N') > at ./Interface/odbcs_drvr.cpp:537 > #9 0x7f31ec3a40a2 in odbc_SQLDrvr_EndTransaction_pst_ (tag_=0x7aa6e0, > dialogueId=1621953250, > transactionOpt=0, exception_=0x7ffee1597e30, sqlWarning=0x7ffee1597e20) > at ./Interface/odbcs_drvr.cpp:1239 > #10 0x7f31ec3df80f in ENDTRANSACT (srvrCallContext=0x7aa6e0) at > ./cli/netconnect.cpp:827 > #11 0x7f31ec3dd63f in ThreadControlProc (pParam=0x7aa6e0) at > ./cli/drvrnet.cpp:166 > #12 0x7f31ec3add16 in CConnect::EndTran (this=0x7aa390, CompletionType=0) > at ./cli/cconnect.cpp:2607 > #13 0x7f31ec3eccd3 in ODBC::EndTran (HandleType=2, Handle=0x7aa390, > CompletionType=0) > at ./cli/sqlhandle.cpp:187 > #14 0x7f31ec3e455e in NeoEndTran (HandleType=2, Handle=0x7aa390, > CompletionType=0) > at ./cli/neofunc.cpp:225 > #15 0x7f31ec420d17 in ODBC::fun_transact (hdbc=0x7aa390, fType=0) > at ./DrvrManager/dmfunctions.cpp:594 > #16 0x7f31ec429b7b in SQLTransact (henv=0x7ccc40, hdbc=0x7aa390, fType=0) > at ./DrvrManager/dmmapping.cpp:989 > #17 0x004ca7e4 in TestSQLSetCursorName (pTestInfo=0x7a9ad0, > MX_MP_SPECIFIC=0) > at ../../../../src/coast/coast_unified/src/setgetcu.c:1204 > #18 0x004338f4 in Run21Tests () at > ../../../../src/coast/coast_unified/src/COAST.cpp:748 > ---Type to continue, or q to quit--- > #19 0x0043453d in main (argc=14, argv=0x7ffee159a398) > at ../../../../src/coast/coast_unified/src/COAST.cpp:452 > (gdb) frame 8 > #8 0x7f31ec3a2a97 in copy_ERROR_DESC_LIST (pname=0x7ffee1597e20, > curptr=@0x7ffee1597d78: 0x7cf430 "", msg_total_len=@0x7ffee1597d84: 12, > swap=78 'N') > at ./Interface/odbcs_drvr.cpp:537 > 537 ./Interface/odbcs_drvr.cpp: No such file or directory. > (gdb) p pname->_length > $1 = 1193297228 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (TRAFODION-1653) coast tests core dumped at 'operator new' when Multithread DCS is on
Gao, Rui-Xian created TRAFODION-1653: Summary: coast tests core dumped at 'operator new' when Multithread DCS is on Key: TRAFODION-1653 URL: https://issues.apache.org/jira/browse/TRAFODION-1653 Project: Apache Trafodion Issue Type: Bug Components: client-odbc-linux Environment: suse11 Reporter: Gao, Rui-Xian When MTDCS is on, several tests will run into segmentation fault. Here is the stack trace -- Core was generated by `./coast -d TRAF_ANSI_176 -u trafodion -p traf123 -c ASCII -m linux64 -f API SQLSetCursorName' (gdb) bt #0 0x7f31ea0d4885 in raise () from /lib64/libc.so.6 #1 0x7f31ea0d5e61 in abort () from /lib64/libc.so.6 #2 0x7f31ea9128ad in __gnu_cxx::__verbose_terminate_handler() () from /usr/lib64/libstdc++.so.6 #3 0x7f31ea910986 in ?? () from /usr/lib64/libstdc++.so.6 #4 0x7f31ea9109b3 in std::terminate() () from /usr/lib64/libstdc++.so.6 #5 0x7f31ea910bf3 in __cxa_throw () from /usr/lib64/libstdc++.so.6 #6 0x7f31ea9110ed in operator new(unsigned long) () from /usr/lib64/libstdc++.so.6 #7 0x7f31ea911189 in operator new[](unsigned long) () from /usr/lib64/libstdc++.so.6 #8 0x7f31ec3a2a97 in copy_ERROR_DESC_LIST (pname=0x7ffee1597e20, curptr=@0x7ffee1597d78: 0x7cf430 "", msg_total_len=@0x7ffee1597d84: 12, swap=78 'N') at ./Interface/odbcs_drvr.cpp:537 #9 0x7f31ec3a40a2 in odbc_SQLDrvr_EndTransaction_pst_ (tag_=0x7aa6e0, dialogueId=1621953250, transactionOpt=0, exception_=0x7ffee1597e30, sqlWarning=0x7ffee1597e20) at ./Interface/odbcs_drvr.cpp:1239 #10 0x7f31ec3df80f in ENDTRANSACT (srvrCallContext=0x7aa6e0) at ./cli/netconnect.cpp:827 #11 0x7f31ec3dd63f in ThreadControlProc (pParam=0x7aa6e0) at ./cli/drvrnet.cpp:166 #12 0x7f31ec3add16 in CConnect::EndTran (this=0x7aa390, CompletionType=0) at ./cli/cconnect.cpp:2607 #13 0x7f31ec3eccd3 in ODBC::EndTran (HandleType=2, Handle=0x7aa390, CompletionType=0) at ./cli/sqlhandle.cpp:187 #14 0x7f31ec3e455e in NeoEndTran (HandleType=2, Handle=0x7aa390, CompletionType=0) at ./cli/neofunc.cpp:225 #15 0x7f31ec420d17 in ODBC::fun_transact (hdbc=0x7aa390, fType=0) at ./DrvrManager/dmfunctions.cpp:594 #16 0x7f31ec429b7b in SQLTransact (henv=0x7ccc40, hdbc=0x7aa390, fType=0) at ./DrvrManager/dmmapping.cpp:989 #17 0x004ca7e4 in TestSQLSetCursorName (pTestInfo=0x7a9ad0, MX_MP_SPECIFIC=0) at ../../../../src/coast/coast_unified/src/setgetcu.c:1204 #18 0x004338f4 in Run21Tests () at ../../../../src/coast/coast_unified/src/COAST.cpp:748 ---Type to continue, or q to quit--- #19 0x0043453d in main (argc=14, argv=0x7ffee159a398) at ../../../../src/coast/coast_unified/src/COAST.cpp:452 (gdb) frame 8 #8 0x7f31ec3a2a97 in copy_ERROR_DESC_LIST (pname=0x7ffee1597e20, curptr=@0x7ffee1597d78: 0x7cf430 "", msg_total_len=@0x7ffee1597d84: 12, swap=78 'N') at ./Interface/odbcs_drvr.cpp:537 537 ./Interface/odbcs_drvr.cpp: No such file or directory. (gdb) p pname->_length $1 = 1193297228 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (TRAFODION-1652) SQLDriverConnect can't get catalog name
Gao, Rui-Xian created TRAFODION-1652: Summary: SQLDriverConnect can't get catalog name Key: TRAFODION-1652 URL: https://issues.apache.org/jira/browse/TRAFODION-1652 Project: Apache Trafodion Issue Type: Bug Components: client-odbc-windows Affects Versions: 2.0-incubating Environment: windows7 windows8 Reporter: Gao, Rui-Xian SQLDriverConnect returned empty catalog name returncode = SQLDriverConnect(hdbc,NULL,(SQLCHAR*)ConnectStringIn,sizeof(ConnectStringIn), (SQLCHAR*)ConnectStringOut,sizeof(ConnectStringOut),&ConnStrLengthOut, SQL_DRIVER_NOPROMPT); LogMsg(SHORTTIMESTAMP + LINEAFTER, "ConnectStringOut is :%s\n", ConnectStringOut); output -- ConnectStringOut is :DSN=TRAF_DSN145_W7;SERVER=TCP:10.10.10.145/23400;UID=trafodion;PWD=traf123;CATALOG=;SCHEMA=RACHEL_ODBCTEST_W7; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1649) Do not know which row has error while there is PrepareStatement.executeBatch() error
[ https://issues.apache.org/jira/browse/TRAFODION-1649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15031512#comment-15031512 ] ASF GitHub Bot commented on TRAFODION-1649: --- Github user kevinxu021 closed the pull request at: https://github.com/apache/incubator-trafodion/pull/190 > Do not know which row has error while there is > PrepareStatement.executeBatch() error > > > Key: TRAFODION-1649 > URL: https://issues.apache.org/jira/browse/TRAFODION-1649 > Project: Apache Trafodion > Issue Type: Bug > Components: client-jdbc-t4 >Reporter: Kevin Xu > > int[] rs = ps.executeStatement(); > there is an exception while some error occurs, then it cant get returned array -- This message was sent by Atlassian JIRA (v6.3.4#6332)
