Trafodion

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Support cancel for DDL, update stats, and utils

This change propagates parent query ID to queries created

by DDL, update stats and utils. In this way, preexisting

code sets up child query IDs and the preexisting cancel

broker code in RMS cancels the entire query tree below

the indicated parent. Also added is logic to check for a

canceled parent at the time a child query ID is setup in

Statement::execute, to make the scheme more robust and

to support a common scenario where the parent is compiling

a child query at the time of cancel.

This change also makes ex_root_tcb::cancel to wait for

cancel broker message completion. This fixes a problem where

a query (e.g., CREATE INDEX or DROP INDEX) is prepared,

executed once and gets an error, then re-execed. In this

case, sqlci was not closing the statement after the error.

To improve robustness, after an error we will now wait for

message completion, if needed.

Since we do not yet have transaction protection for DDL,

it will usually be required to cleanup canceled DDL

operations by using the CLEANUP command.

Change-Id: I8940f7108906d5d8d1a8aa4574aacf2b9ffcf0b6

    • -92
    • +289
    /sql/regress/executor/EXPECTED106
  1. … 13 more files in changeset.
Merge "Avoid unnecessary memory allocation while logging via log4cpp"

Merge "fix in T4 Driver"

Phase2 - DDL Transactions - create

Changes in TM java side for DDL transactions - create table

Change-Id: Ib5ea64f9fb7d47d0fd45d1d89647d6b8dfc69c7e

Merge "Fix for bug #1414100"

Merge "Fix for updated tpcds_kit file."

Merge "fix t2 catalog api"

Merge "Performance improvement for performScan defect"

Merge "Fixs a problem when local transactions are turned on."

Avoid unnecessary memory allocation while logging via log4cpp

log4cpp.getInstance method takes in std::string argument. Wven the caller

passes in const char *, a std::string instance is created. Changed

code to pass std::string object from all callers to avoid memory

allocation from system heap

Change-Id: Id46e084b8eff8dacd31251a8a23ef013cf886a91

    • -1
    • +2
    /conn/odbc/src/odbc/Common/PubInterface.cpp
Performance improvement for performScan defect

Change-Id: Icf6473b67ff6621bb895e3b705b828678440ffef

Merge "Fix for performScan, new RS memoryUsage and use of hbase config"

Fix for bug #1432703

Removed the support for "query" type from command parameters.

Change-Id: I433efe960236624185dd1219d336083c964d6073

    • -3
    • +1
    /conn/odbc/src/odbc/nsksrvr/SrvrMain.cpp
Fixs a problem when local transactions are turned on.

Change-Id: I61b65b0f29a44583eaf34493015b9c34c1351532

Merge "Patch for logging udf , udr log and hive failures"

Merge "Added additional REST server commands"

Fix for performScan, new RS memoryUsage and use of hbase config

Change-Id: I18ffee46fa8b0286e3f66fe53cbf1414c83afeb0

Merge "Add switch-controlled transaction conflict reinstatement"

Incorporate install of REST server to install_local_hadoop

Change-Id: I5357202098dd582e6ea0ae8fc6955bbb212693fb

    • -1
    • +114
    /sqf/sql/scripts/install_local_hadoop
    • -0
    • +39
    /sqf/sql/scripts/reststart
    • -0
    • +39
    /sqf/sql/scripts/reststop
Merge "Add joining/spare-up notices."

Fix for command line arguments

Now able to use multiple command line arguments at one time.

Edit 1: Correcting $STARTING_NODE to be current hostname

Edit 2: Correcting $STARTING_NODE to be current hostname only for single

node install. Adding checkes to make sure Trafodion and Hadoop are

matching versions.

Edit 3: Correcting $STARTING_NODE

Change-Id: Icb29082d6362614f536cd170a13714ec61c359ba

Merge "Adding makefile changes for Sscc and protobufs"

changes to improve plan quality of OSS queries.

b1 and b2: NJ was not being explored because RHS of NJ was another

join and didn't have index information to check for keyless NJs.

This change helped OSS b1 and b2 queries to get better NJ plans.

b6, b6, and b8: Optimizer chose Hj + MDAM plan where as

NJ + regular scan runs better.

The costing code didn't account for probes being done to get

beginKey for missing _SALT_ column. This change will include

probing cost.

QA:

Regressions completed

performance workloads including HPIT showed no negatvie impact

OSS queries showed significant improvement.

Change-Id: I3f7401a7b8107637bb6016d548cb2fe8bad5077f

Merge "Fix for bug #1430900"

Merge "Corrected TM statistics for use by HPDSM."

Add switch-controlled transaction conflict reinstatement

Change-Id: Ie1a358d82347052f2bf88f6f93a7fb3d5f85f737

Add joining/spare-up notices.

Change-Id: Iec500e83f6910ae1f10c6639b9da07ea6cc709d0

Patch for logging udf , udr log and hive failures

1. Fixed the event log reader udf to read all log files created by

monitor, ssmp,sscp and mxlobsrvr,udr

2. Added a new log file and config file for udrsever . It will be

created when udrserver starts up.

3. Fix for current hive failures.Destructor for ExLob was calling

hdfsDisconnect. This had to be commented out since it caused

closeChannel errors and cores during hive aaccess. LP 1433882 created for a potential leak.

Change-Id: I0613b352248a4d796604346f1a495f7606d21d4c

    • -0
    • +24
    /sqf/conf/log4cpp.trafodion.udr.config
Fix for bug #1414100

1.The queryStartTime is not always equal to prepare time.

2.Only if inState is STMTSTAT_EXECUTE or STMTSTAT_PREPARE,

queryStartTime will be set/updated.

Change-Id: Iaa6498865a213c1f13e2a3294a8b53e2bc80d537

Merge "Add prepare to MS_Mon_Msg (to match monitor)."