Clone Tools
Constraints: committers
Constraints: files
Constraints: dates
Fix for the failure of testLTrimFunction, testTrimFunction and testRTrimFunction of VariableLengthPKTest in phoenix T4 tests.

When the statement type is TYPE_UNKNOWN, mxosrvr was executing the extra code

to load controls, GetHashInfo etc. GetHashInfo was corrupting the sqlString by

truncating spaces in between the literals.

Removed these code from mxosrvr because it is specific to QueryStatsServer as part of

NeoView and WMS.

1. JULIANTIMESTAMP now uses clock_gettime with CLOCK_REALTIME by default. It can be switched to earlier implementaion via setting env variable USE_LINUX_JULIANTIMESTAMP=0 2. Remove unwanted CQDs set by mxosrvr. GENERATE_EXPLAIN is not turned ON by mxosrvr.

  1. … 13 more files in changeset.
[TRAFODION-3221]support using ipv6 with jdbct4 to connect trafodion

  1. … 1 more file in changeset.
[TRAFODION-3164] Restart mxosrvrs on-demand

This code adds a zookeeper value to signal to mxosrvr processes

when it is time to exit. This allows to phase out processes when

things in the environment change. The process will wait until it

is idle before exiting.

  1. … 1 more file in changeset.
Fix jdbct4 code

  1. … 5 more files in changeset.

  1. … 10 more files in changeset.
[TRAFODION-3041] Addressed review comment

[Trafodion-3041] Support watchdog query cache to improvement performance when every query executed needs to be written into repository. The time when the queries cached will be published into repository is determined by cache time or number of queries. You can configure it in the file conf/dcs-site.xml.

  1. … 3 more files in changeset.
Change some variable. Make the description more detailed.

  1. … 4 more files in changeset.
Merge remote branch 'origin/release2.2' into TRAFODION-3014
















  1. … 10 more files in changeset.
[TRAFODION-3003]Trafodion keepalive support

Keepalive could be configured by modifying file src/main/java/org/trafodion/dcs/


DCS_SERVER_PROGRAM_TCP_KEEPALIVE_STATUS has three value:enable,default,unenable;

Default value is enable,300,3,20(Only effective when value configured is set incorrectly)

The value will be read in when mxosrvr start. Mxosrvr will set the socket after getting a connection.

    • -1
    • +6
  1. … 6 more files in changeset.
Merge [TRAFODION-2886] PR-1380 fix the nullpointer error scanned by TScanCode

  1. … 4 more files in changeset.
Merge [TRAFODION-2891] PR-1394 fix the bufoverrun Critical error checked by TScanCode

  1. … 4 more files in changeset.
fix the bufoverrun Critical error checked by TScanCode

  1. … 20 more files in changeset.
fix the logic Critical error checked by TScanCode

fix the nullpointer error scaned by TScanCode

  1. … 20 more files in changeset.
JIRA TRAFODION-2834 Streamline supported xn access modes

traf DTM only supports 'read committed access' for selects

and 'set transaction ' stmts.

With this checkin, only those 2 options will be allowed.

All other access options will return an error.

Read uncommitted access will be treated as read committed.

  1. … 60 more files in changeset.
[TRAFODION-2780] The mxosrvr dumps core when connection idle timer expires

Changes as per review

[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.

    • -16
    • +63
  1. … 2 more files in changeset.
[TRAFODION-2740]JDBC extract LOB context in chunks

    • -12
    • +36
  1. … 7 more files in changeset.
TRAFODION-2731 CodeCleanup: Remove obsolete, legacy and unused code

This phase handles the following:

-- removal of code that dealt with:

-- mpalias, NSK, MP, mploc, resource fork, rfork

-- ARLIB, DISK, VOLUME, PFS, compiler version info

-- interpretasrow/IAR, AuditImage, ExtractColumns functions

-- ARKCMP_SINGLE_PROCESS and oneProcess()

-- recompControl, remoteDefaults, rtdu, module

-- latebind thru nsk defines, guardian names, nametype nsk

-- SHADOW implementation


-- older sqlcat ReadTableDef


-- internal cli methods no longer used by any caller

Code within the following defines is removed if it is obsolete

or the define itself is removed if that feature is always on:

-- removed NA_EIDPROC

-- removed SQLEXP_LIB_FUNC

-- removed NA_CMPDLL


-- removed SQ_NEW_PHANDLE

-- removed __EID

-- removed ARKFS_OPEN

-- removed STAND_ALONE

-- removed __TANDEM

-- removed NA_C89

-- removed NA_NSK


-- removed SQLCLI_LIB_FUNC

-- removed CLI_PRIV_SRL

-- removed PRIV_SRL

-- removed NA_LINUX

-- removed NA_HSC_LINUX

-- removed NA_UNIX

-- removed NA_WINNT

-- removed HAVE_MMAP

-- removed NA_NO_C_RUNTIME

-- removed NA_DEBUG_C_RUNTIME(replaced with _DEBUG)

-- removed NA_64BIT usage except in sqlcli.h

-- removed dg64

-- removed SQLEXPORT_LIB

-- removed NA_ARKFS

-- removed NA_IEEE_FLOAT

-- removed NA_GUARDIAN_MSG

-- removed NA_HSC


-- removed ERROR

-- removed ERROR_STATE


Contents of these files have been removed.

Next checkin fill remove the files itself from git:


executor/ExMeas.h, ExMeas.cpp

executor/tempfile.h, .cpp


executor/stubs.cpp, stubs2.cpp


cli/rtdu.h, rtdu2.h, rtdu.cpp, rtdu.cpp












sqlcat/ReadTableDef.h, cpp

sqlcat/readRealArk.h, cpp

  1. … 460 more files in changeset.
Merge remote branch 'origin/pr/1167/head' into merge_1167

  1. … 4 more files in changeset.
[TRAFODION-2646]mxosrvr change to AVAILABLE after timeout if no client connect

[TRAFODION-2308]JDBC support insert LOB

    • -2
    • +80
  1. … 34 more files in changeset.
[TRAFODION-2596] Improve the log4j and log4cxx infrastructure in Trafodion

The following changes are made in the way Trafodion logs the messages:

Writes to a log file based on a component or set of components.

C++ part of the code base:

Component Default log file Configuration File

TM tm_<nid>.log

SSCP sscp_<nid>.log log4cxx.trafodion.sscp.config

SSMP ssmp_<nid>.log log4cxx.trafodion.ssmp.config

All SQL processes trafodion.sql_<nid>.log log4cxx.trafodion.sql.config






Java part of the code base

TM trafodion.dtm.log log4j.dtm.config

SQL log4j.sql.config

By default, the log level is set to INFO for most of the cases. When a message

dominates the log file and if doesn't add value in the current level, it will be

changed to the higher level in the hierarchy. This should help to improve the

usefulness of the log file at the default INFO level.

The existence of an environment variable TRAF_MULTIPLE_SQL_LOG_FILE will revert back

to the old way of logging into multiple files. Then, the configuration file

log4cxx.trafodion.masterexe.config will be used.

Currently, RollingFileAppender appender is used for both modes. Different config files

are used to change this appender when the need arises.

log4cxx.trafodion.udr.config and log4cxx.trafodion.lob.config are removed.

log4j.hdfs.config used as the config file for SQL is renamed to log4j.sql.config

Foundation components logging will be revamped later.

This closes #1070

  1. … 19 more files in changeset.
[TRAFODION-2411] Conn aborted when connecting with a reregisterd user

APIs used to clear compiler caches had changed, leading to syntax


[TRAFODION-2314] MXOSRVR sometimes exit abnormally with NAMutex assert

The test suite fails becuase pthread_mutex_unlock returns EPERM error

pthread_mutex_lock and pthread_mutex_unlock always return success when

a program is not linked with -lpthread option. It is linked this way

when a multi-threaded program is run in single thread mode to avoid the

overhead of locking.

The mxosrvr program is now linked with -lpthread. However, it is not

clear how and why it would fix the EPERM error returned from

pthread_mutex_unlock API. But it is good to ensure that mxosrvr .sos and

the binaries are compiled with -lpthread.

Will revisit this issue if the problem persists.

  1. … 1 more file in changeset.
convert all MY_SQROOT to TRAF_HOME

  1. … 294 more files in changeset.
[TRAFODION-2388] there should be only one ENV for Trafodion's root directory instead of many.

  1. … 33 more files in changeset.
Merge Fix for [TRAFODION-2308]JDBC T4 support read LOB

  1. … 1 more file in changeset.