Trafodion

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
add copyright

TRAFODION-2790 jdbc does not implement abort related api

TRAFODION-2789 jdbc does not implement NetworkTimeout related api

Author: selvaganesang <selva.govindarajan@esgyn.com> Date: Sat Oct 28 04:27:49 2017 +0000

[TRAFODION-2785] mxosrvr dumps core generated when loading data from Oracle to Trafodion at times

When there is an error while loading the data, the hexadecimal representation

of character column upto 254 bytes is shown as part of the error message.

The function stringToHex had a subtle bug that can cause buffer overrun resulting in stack corruption.

This closes #1280

Merge PR 1279 [TRAFODION-2420] RMS Enhancements

TRAFODION-2787 jdbc does not implement wrapper related api

TRAFODION-2788 - jdbc does not implement ClinetInfo related api

Trafodion-2705 user has "SHOW" privilege can't do 'showddl user'

Showddl code now checks to see if current user matches the user name specified

in the showddl command. It also verifies that the user has SHOW component

privilege.

Simplified privs1/TEST141 as part of goal to make privilege tests run faster.

    • binary
    /core/sql/regress/privs1/EXPECTED141
    • -50
    • +108
    /core/sql/regress/privs1/TEST141
    • -151
    • +129
    /core/sql/sqlcomp/CmpSeabaseDDLauth.cpp
Statement for metadata should be closed with connection

Statement for metadata should be closed with connection

Merge PR 1277 [TRAFODION-2783] jdbc_test_cdh fails at times with type 2 JDBC driver

[TRAFODION-2420] RMS Enhancements

Refactored the ESP memory management so that all the SQL memory both

heap and space objects are accounted correctly in RMS

With this change, the total SQL memory used by all processes involved

in the query is represented in the counter "SQL Heap WM"

    • -3
    • +3
    /core/sql/executor/ExExeUtilGetStats.cpp
    • -23
    • +18
    /core/sql/executor/ex_esp_frag_dir.cpp
TRAFODION-2784 trafci help has no description for jline

[TRAFODION-2783] jdbc_test_cdh fails at times with type 2 JDBC driver

Reworked the code as per the comment in the git

Merge [TRAFODION-2782] PR 1275 Reverse UDR classloader sequence

Merge [TRAFODION-2714] PR 1270 odb does not load data correctly

Merge [TRAFODION-2773] PR 1272 Fix odb hang when timeout is set

Merge pr 1274 miscellaneous authorization changes

[TRAFODION-2783] jdbc_test_cdh fails at times with type 2 JDBC driver dumping core

Removed recursive inclusion of charinfo.h

[TRAFODION-2783] jdbc_test_cdh fails at times with type 2 JDBC driver dumping core

In case of Type 2 JDBC driver, the Trafodion SQL engine is a library that is dynamic

loaded into the process. Initialization of C++ static objects in the dynamic loaded libraries

are supposed to be done before dlopen returns. But the behavior seems to be nondeterministic when

there are multiple threads or when there are dependent static objects (An static object expects

another to be initialized before it). I think, the order of the initialization is not guaranteed

by the standard.

Refactored the code to initialize static object CharInfo::builtinCollationDB_ as part of the first

CLI call in a thread safe manner.

Merge [TRAFODION-2781] PR 1276 Omit LOB cols from update stats sample tables

[TRAFODION-2781] Omit LOB columns from update stats sample tables

    • -0
    • +26
    /core/sql/parser/ElemDDLLikeOptions.cpp
    • -0
    • +28
    /core/sql/parser/ElemDDLLikeOptions.h
    • -0
    • +16
    /core/sql/parser/ParDDLLikeOpts.cpp
    • -0
    • +14
    /core/sql/parser/ParDDLLikeOptsCreateTable.h
    • -25
    • +25
    /core/sql/regress/compGeneral/EXPECTED023
    • -0
    • +3
    /core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
TRAFODION-2782 reserve UDRs classloader sequence

original code is valid

Merge PR1273 [TRAFODION-2780] The mxosrvr dumps core when connection idle timer expires

[TRAFODION-2780] The mxosrvr dumps core when connection idle timer expires

Changes as per review

Miscellaneous authorization changes:

- Unregister user does not remove component privileges

- Reuse unused entries from the authID ranges

- Add "changeuser" command to update user credentials in place instead of

requiring a new sqlci session to be started. Changed privs1/TEST132 to use

this change and cut about 5 minutes off the test time.

    • -673
    • +268
    /core/sql/regress/privs1/EXPECTED132
    • -59
    • +86
    /core/sql/regress/privs1/TEST132
    • -1
    • +1
    /core/sql/sqlcomp/CmpDDLCatErrorCodes.h
    • -126
    • +225
    /core/sql/sqlcomp/CmpSeabaseDDLauth.cpp
    • -4
    • +14
    /core/sql/sqlcomp/CmpSeabaseDDLauth.h
    • -9
    • +6
    /core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp
    • -0
    • +284
    /core/sql/sqlcomp/PrivMgrComponentDefs.h
  1. … 4 more files in changeset.
[TRAFODION-2780] The mxosrvr dumps core when connection idle timer expires at times

This core is accompanied by mxssmp process core.

Got rid of both connection idle timer and server idle timer, instead use the timeout

mechanism provided by the socket API select. More code removed.

Tested the connection idle timeout mechanism via a sample JDBC T4 program just to ensure

that the mxosrvr is put into available pool after the connection idle timer expires.

Trafci seems to be resetting the connection idle timer periodically from the client.

It looks like even the connection idle timer is Trafodion specific concept because of

a dedicated process for every database connection to Trafodion SQL engine. From JDBC specification,

the connection inactive timeout needs to be implemented in the connection pooling infrastructure.

The default connection idle timer in Trafodion is 10 mins.

    • -2
    • +0
    /core/conn/odbc/src/odbc/Common/Global.h
    • -254
    • +14
    /core/conn/odbc/src/odbc/nsksrvr/SrvrConnect.cpp
    • -6
    • +0
    /core/conn/odbc/src/odbc/nsksrvr/SrvrSMD.cpp
Merge [TRAFODION-2777] PR 1269 Fix latent bug unmasked by TRAF-2765 fix

Merge remote branch 'origin/pr/1271/head' into merge_1271

Updating failing regress tests

    • -0
    • +12
    /core/sql/regress/seabase/DIFF003.KNOWN
    • -400
    • +544
    /core/sql/regress/seabase/EXPECTED010
    • -4
    • +227
    /core/sql/regress/seabase/TEST010