You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by sa...@apache.org on 2018/09/11 17:57:25 UTC
[1/2] trafodion git commit: Follow on to TRAFODION-3192 that caused
one regression failure on Jenkins alone since the queue resizing caused the
executor/TEST106 that tests cancel to not work as expected. The upsert
subtest was running too fast to get can
Repository: trafodion
Updated Branches:
refs/heads/master c0066859a -> 94f59aceb
Follow on to TRAFODION-3192 that caused one regression failure on Jenkins alone since the queue resizing caused the executor/TEST106 that tests cancel to not work as expected. The upsert subtest was running too fast to get cancelled. So added some CQds to use smaller queue sizes and override dynamic queue resizing.Now it runs long enough to get canceled and give expected results.
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/859f071e
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/859f071e
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/859f071e
Branch: refs/heads/master
Commit: 859f071e7dd962e2c464461c16cc56a56935b72b
Parents: f85ccaa
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Tue Sep 11 07:02:08 2018 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Tue Sep 11 07:02:08 2018 +0000
----------------------------------------------------------------------
core/sql/regress/executor/EXPECTED106 | 451 +++++++++++++++--------------
core/sql/regress/executor/TEST106 | 7 +-
core/sql/sqlcomp/nadefaults.cpp | 2 +-
3 files changed, 241 insertions(+), 219 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/859f071e/core/sql/regress/executor/EXPECTED106
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED106 b/core/sql/regress/executor/EXPECTED106
index efe1966..9c82498 100644
--- a/core/sql/regress/executor/EXPECTED106
+++ b/core/sql/regress/executor/EXPECTED106
@@ -79,7 +79,7 @@ End of MXCI Session
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:06:19.088376
+FUNKY_OPT_UNIQUE 2018-09-11 06:33:58.000451
--- 1 row(s) selected.
>>
@@ -94,7 +94,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:06:19.088376
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:06:19.593994
+FUNKY_OPT_UNIQUE 2018-09-11 06:34:02.000806
--- 1 row(s) selected.
>>
@@ -109,7 +109,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:06:19.593994
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:06:25.701964
+FUNKY_OPT_UNIQUE 2018-09-11 06:34:06.000900
--- 1 row(s) selected.
>>
@@ -124,7 +124,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:06:25.701964
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:06:27.328307
+FUNKY_OPT_UNIQUE 2018-09-11 06:34:07.000032
--- 1 row(s) selected.
>>
@@ -197,7 +197,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:06:27.328307
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:06:27.705202
+subject launch canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:34:07.000305
--- 1 row(s) selected.
>>
@@ -215,7 +215,7 @@ subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:06:27.705202
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:06:28.699544
+subject synch cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:34:08.000400
--- 1 row(s) selected.
>>
@@ -242,7 +242,7 @@ subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:06:28.699544
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.788316
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:34:15.000481
--- 1 row(s) selected.
>>log;
@@ -254,7 +254,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.788316
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.813948
+subject execute s1 - FUNKY_OPT_UNIQUE 2018-09-11 06:34:15.000508
--- 1 row(s) selected.
>>
@@ -277,7 +277,7 @@ subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.813948
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.861646
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000500
--- 1 row(s) selected.
>>
@@ -304,7 +304,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.861646
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.912524
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000539
--- 1 row(s) selected.
>>log;
@@ -329,7 +329,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.912524
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.714664
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:34:15.000384
--- 1 row(s) selected.
>>
@@ -341,7 +341,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.714664
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.735687
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000405
--- 1 row(s) selected.
>>
@@ -358,7 +358,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_183_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_415_S1;
--- SQL operation complete.
>>
@@ -373,7 +373,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.817032
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000496
--- 1 row(s) selected.
>>log;
@@ -441,7 +441,7 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.817032
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:03.399656
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:34:37.000537
--- 1 row(s) selected.
>>log;
@@ -467,7 +467,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:03.399656
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.484716
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:34:53.000589
--- 1 row(s) selected.
>>
@@ -494,7 +494,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.484716
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.521981
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:34:53.000623
--- 1 row(s) selected.
>>log;
@@ -519,7 +519,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.521981
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:07:03.311535
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:34:37.000479
--- 1 row(s) selected.
>>
@@ -531,7 +531,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:07:03.311535
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.361158
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:34:50.000499
--- 1 row(s) selected.
>>
@@ -548,7 +548,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_222_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_473_S1;
--- SQL operation complete.
>>
@@ -563,7 +563,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.472310
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:34:53.000582
--- 1 row(s) selected.
>>log;
@@ -594,7 +594,7 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.472310
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:07:18.686506
+subject launch canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:34:55.000817
--- 1 row(s) selected.
>>
@@ -612,7 +612,7 @@ subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:07:18.686506
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:18.705866
+subject synch cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:34:55.000839
--- 1 row(s) selected.
>>
@@ -639,7 +639,7 @@ subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:18.705866
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.373358
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:35:02.000687
--- 1 row(s) selected.
>>log;
@@ -651,7 +651,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.373358
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.394035
+subject execute s1 - FUNKY_OPT_UNIQUE 2018-09-11 06:35:02.000710
--- 1 row(s) selected.
>>
@@ -672,7 +672,7 @@ subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.394035
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:07:48.064685
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:35:26.000940
--- 1 row(s) selected.
>>
@@ -699,7 +699,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:07:48.064685
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:48.096812
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:35:26.000980
--- 1 row(s) selected.
>>log;
@@ -724,7 +724,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:48.096812
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.302277
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:35:02.000666
--- 1 row(s) selected.
>>
@@ -736,7 +736,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.302277
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:07:41.320811
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:35:15.000685
--- 1 row(s) selected.
>>
@@ -753,7 +753,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_237_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_488_S1;
--- SQL operation complete.
>>
@@ -768,7 +768,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:07:41.407319
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:35:15.000794
--- 1 row(s) selected.
>>log;
@@ -791,7 +791,7 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:07:41.407319
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:07:50.195393
+subject launch canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:35:29.000124
--- 1 row(s) selected.
>>
@@ -809,7 +809,7 @@ subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:07:50.195393
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:50.215880
+subject synch cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:35:29.000143
--- 1 row(s) selected.
>>
@@ -836,7 +836,7 @@ subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:50.215880
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.487739
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:35:35.000996
--- 1 row(s) selected.
>>log;
@@ -848,7 +848,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.487739
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.508758
+subject execute s1 - FUNKY_OPT_UNIQUE 2018-09-11 06:35:36.000017
--- 1 row(s) selected.
>>
@@ -869,7 +869,7 @@ subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.508758
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:08:25.759995
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:35:58.000197
--- 1 row(s) selected.
>>
@@ -896,7 +896,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:08:25.759995
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:25.795455
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:35:58.000238
--- 1 row(s) selected.
>>log;
@@ -921,7 +921,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:25.795455
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.486860
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:35:35.000921
--- 1 row(s) selected.
>>
@@ -933,7 +933,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.486860
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:08:12.509301
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:35:48.000940
--- 1 row(s) selected.
>>
@@ -950,7 +950,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_253_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_504_S1;
--- SQL operation complete.
>>
@@ -965,7 +965,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:08:12.606156
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:35:49.000030
--- 1 row(s) selected.
>>log;
@@ -987,7 +987,7 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:08:12.606156
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:08:29.298685
+subject launch canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:36:01.000614
--- 1 row(s) selected.
>>
@@ -1005,7 +1005,7 @@ subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:08:29.298685
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:29.318388
+subject synch cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:36:01.000635
--- 1 row(s) selected.
>>
@@ -1032,7 +1032,7 @@ subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:29.318388
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.782601
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:36:08.000598
--- 1 row(s) selected.
>>log;
@@ -1044,7 +1044,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.782601
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.800701
+subject execute s1 - FUNKY_OPT_UNIQUE 2018-09-11 06:36:08.000621
--- 1 row(s) selected.
>>
@@ -1065,7 +1065,7 @@ subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.800701
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:08:56.574479
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:36:26.000066
--- 1 row(s) selected.
>>
@@ -1092,7 +1092,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:08:56.574479
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:56.608716
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:36:26.000099
--- 1 row(s) selected.
>>log;
@@ -1117,7 +1117,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:56.608716
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.771967
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:36:08.000507
--- 1 row(s) selected.
>>
@@ -1129,7 +1129,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.771967
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:08:51.799087
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:36:21.000532
--- 1 row(s) selected.
>>
@@ -1146,7 +1146,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_268_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_519_S1;
--- SQL operation complete.
>>
@@ -1161,7 +1161,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:08:54.940529
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:36:24.000621
--- 1 row(s) selected.
>>log;
@@ -1201,7 +1201,7 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:08:54.940529
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:08:59.019859
+subject launch canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:36:28.000327
--- 1 row(s) selected.
>>
@@ -1219,7 +1219,7 @@ subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:08:59.019859
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:59.038540
+subject synch cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:36:28.000355
--- 1 row(s) selected.
>>
@@ -1246,7 +1246,7 @@ subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:08:59.038540
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.728176
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:36:36.000161
--- 1 row(s) selected.
>>log;
@@ -1258,7 +1258,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.728176
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.748097
+subject execute s1 - FUNKY_OPT_UNIQUE 2018-09-11 06:36:36.000183
--- 1 row(s) selected.
>>
@@ -1279,7 +1279,7 @@ subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.748097
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:09:25.863895
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:36:53.000319
--- 1 row(s) selected.
>>
@@ -1306,7 +1306,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:09:25.863895
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:25.898587
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:36:53.000352
--- 1 row(s) selected.
>>log;
@@ -1331,7 +1331,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:25.898587
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.679253
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:36:36.000131
--- 1 row(s) selected.
>>
@@ -1343,7 +1343,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.679253
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:09:21.705227
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:36:49.000152
--- 1 row(s) selected.
>>
@@ -1360,7 +1360,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_306_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_578_S1;
--- SQL operation complete.
>>
@@ -1375,7 +1375,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:09:24.803186
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:36:52.000247
--- 1 row(s) selected.
>>log;
@@ -1383,6 +1383,15 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:09:24.803186
>>
>>
>>obey TEST106(upsert_test1);
+>>cqd DYN_QUEUE_RESIZE_OVERRIDE 'ON';
+
+--- SQL operation complete.
+>>cqd GEN_TRSP_SIZE_DOWN '16';
+
+--- SQL operation complete.
+>>cqd GEN_TRSP_SIZE_UP '16';
+
+--- SQL operation complete.
>>
>>prepare s1 from
+>upsert using load into t106c
@@ -1416,7 +1425,7 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:09:24.803186
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:09:28.259737
+subject launch canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:36:55.000602
--- 1 row(s) selected.
>>
@@ -1434,7 +1443,7 @@ subject launch canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:09:28.259737
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:28.282876
+subject synch cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:36:55.000634
--- 1 row(s) selected.
>>
@@ -1461,7 +1470,7 @@ subject synch cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:28.282876
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.705479
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:37:02.000489
--- 1 row(s) selected.
>>log;
@@ -1473,7 +1482,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.705479
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.727412
+subject execute s1 - FUNKY_OPT_UNIQUE 2018-09-11 06:37:02.000512
--- 1 row(s) selected.
>>
@@ -1494,7 +1503,7 @@ subject execute s1 - FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.727412
(EXPR) (EXPR)
------------------------------------------ --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.821321
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000544
--- 1 row(s) selected.
>>
@@ -1521,7 +1530,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.821321
(EXPR) (EXPR)
------------------------------------------ --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.952650
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000581
--- 1 row(s) selected.
>>log;
@@ -1546,7 +1555,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.952650
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.708310
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:37:02.000440
--- 1 row(s) selected.
>>
@@ -1558,7 +1567,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.708310
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:09:50.732984
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000459
--- 1 row(s) selected.
>>
@@ -1575,7 +1584,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_321_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_596_S1;
--- SQL operation complete.
>>
@@ -1590,12 +1599,20 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.825816
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000546
--- 1 row(s) selected.
>>log;
>>
->>
+>>cqd DYN_QUEUE_RESIZE_OVERRIDE reset;
+
+--- SQL operation complete.
+>>cqd GEN_TRSP_SIZE_DOWN reset;
+
+--- SQL operation complete.
+>>cqd GEN_TRSP_SIZE_UP reset;
+
+--- SQL operation complete.
>>
>>obey TEST106(cpu_bound_esps);
>>
@@ -1643,10 +1660,10 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.825816
>>select 'done with synch_cancel - FUNKY_OPT_UNIQUE',
+> CURRENT_TIMESTAMP (6) from (values (1)) as t1;
-(EXPR) (EXPR)
------------------------------------------- --------------------------
+(EXPR) (EXPR)
+----------------------------------------- --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:10:06.471498
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:37:24.000952
--- 1 row(s) selected.
>>log;
@@ -1668,10 +1685,10 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:10:06.471498
>>
>>select 'subject - FUNKY_OPT_UNIQUE', CURRENT_TIMESTAMP (6) from (values (1)) as t1;
-(EXPR) (EXPR)
------------------------------------------- --------------------------
+(EXPR) (EXPR)
+----------------------------------------- --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:10:30.700079
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:37:52.000240
--- 1 row(s) selected.
>>
@@ -1695,10 +1712,10 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:10:30.700079
>>select 'done with synch_cancel - FUNKY_OPT_UNIQUE',
+> CURRENT_TIMESTAMP (6) from (values (1)) as t1;
-(EXPR) (EXPR)
------------------------------------------- --------------------------
+(EXPR) (EXPR)
+----------------------------------------- --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:10:30.735707
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:37:52.000293
--- 1 row(s) selected.
>>log;
@@ -1723,7 +1740,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:10:30.735707
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:10:06.408419
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:37:24.000927
--- 1 row(s) selected.
>>
@@ -1735,7 +1752,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:10:06.408419
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:10:19.430779
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:37:37.000947
--- 1 row(s) selected.
>>
@@ -1752,7 +1769,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_337_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_615_S1;
--- SQL operation complete.
>>
@@ -1767,7 +1784,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:10:19.515222
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:37:41.000047
--- 1 row(s) selected.
>>log;
@@ -1830,7 +1847,7 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:10:19.515222
(EXPR) (EXPR)
----------------------------------------- --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:10:42.359509
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:38:01.000517
--- 1 row(s) selected.
>>log;
@@ -1855,7 +1872,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:10:42.359509
(EXPR) (EXPR)
----------------------------------------- --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:11:06.522144
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:38:28.000772
--- 1 row(s) selected.
>>
@@ -1882,7 +1899,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:11:06.522144
(EXPR) (EXPR)
----------------------------------------- --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:11:06.564411
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:38:28.000814
--- 1 row(s) selected.
>>log;
@@ -1907,7 +1924,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:11:06.564411
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:10:42.305768
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:38:01.000478
--- 1 row(s) selected.
>>
@@ -1919,7 +1936,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:10:42.305768
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:10:55.328810
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:38:14.000502
--- 1 row(s) selected.
>>
@@ -1936,7 +1953,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_352_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_630_S1;
--- SQL operation complete.
>>
@@ -1951,7 +1968,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:10:55.406493
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:38:17.000590
--- 1 row(s) selected.
>>log;
@@ -2110,7 +2127,7 @@ CONTROL_RUNNING_QUERY ===================== SEQ_NO 1 NO CHILDREN
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:11:17.016966
+FUNKY_OPT_UNIQUE 2018-09-11 06:38:39.000193
--- 1 row(s) selected.
>>
@@ -2126,7 +2143,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:11:17.016966
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:11:47.131046
+FUNKY_OPT_UNIQUE 2018-09-11 06:39:09.000721
--- 1 row(s) selected.
>>
@@ -2142,7 +2159,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:11:47.131046
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:11:48.077070
+FUNKY_OPT_UNIQUE 2018-09-11 06:39:40.000544
--- 1 row(s) selected.
>>
@@ -2158,7 +2175,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:11:48.077070
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:12:18.192873
+FUNKY_OPT_UNIQUE 2018-09-11 06:39:43.000151
--- 1 row(s) selected.
>>
@@ -2174,7 +2191,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:12:18.192873
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:12:19.105450
+FUNKY_OPT_UNIQUE 2018-09-11 06:40:17.000355
--- 1 row(s) selected.
>>
@@ -2190,7 +2207,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:12:19.105450
(EXPR) (EXPR)
---------------- --------------------------
-FUNKY_OPT_UNIQUE 2015-07-10 17:12:49.225497
+FUNKY_OPT_UNIQUE 2018-09-11 06:40:48.000240
--- 1 row(s) selected.
>>
@@ -2204,9 +2221,9 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:12:49.225497
>>log;
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_611_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_934_S1;
-*** ERROR[8031] Server declined cancel request for query ID MXID11000021348212303307894875569000000000206U3333300_611_S1. The query is not in OPEN or FETCH or EXECUTE state.
+*** ERROR[8031] Server declined cancel request for query ID MXID11000020942212403407567430015000000000206U3333300_934_S1. The query is not in OPEN or FETCH or EXECUTE state.
--- SQL operation failed with errors.
>>
@@ -2348,7 +2365,7 @@ FUNKY_OPT_UNIQUE 2015-07-10 17:12:49.225497
(EXPR) (EXPR)
----------------------------------------- --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:13:47.314100
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:41:17.000817
--- 1 row(s) selected.
>>log;
@@ -2373,7 +2390,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:13:47.314100
(EXPR) (EXPR)
----------------------------------------- --------------------------
-subject - FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.677443
+subject - FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000938
--- 1 row(s) selected.
>>
@@ -2400,7 +2417,7 @@ subject - FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.677443
(EXPR) (EXPR)
----------------------------------------- --------------------------
-done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.717696
+done with synch_cancel - FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000975
--- 1 row(s) selected.
>>log;
@@ -2425,7 +2442,7 @@ done with synch_cancel - FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.717696
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:13:47.295281
+canceler going to sleep - FUNKY_OPT_UNIQUE 2018-09-11 06:41:17.000801
--- 1 row(s) selected.
>>
@@ -2437,7 +2454,7 @@ canceler going to sleep - FUNKY_OPT_UNIQUE 2015-07-10 17:13:47.295281
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler woke up - FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.323547
+canceler woke up - FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000824
--- 1 row(s) selected.
>>
@@ -2454,7 +2471,7 @@ Execute End Time -1
--- 1 row(s) inserted.
>>
>>obey cancel_cmd;
->>control query cancel qid MXID11000021348212303307894875569000000000206U3333300_616_S1;
+>>control query cancel qid MXID11000020942212403407567430015000000000206U3333300_939_S1;
--- SQL operation complete.
>>
@@ -2469,7 +2486,7 @@ Execute End Time -1
(EXPR) (EXPR)
------------------------------------------ --------------------------
-canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.465200
+canceler - FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000907
--- 1 row(s) selected.
>>log;
@@ -2484,116 +2501,116 @@ canceler - FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.465200
MSG (EXPR) TS
------------------------------------------------------------ ---------------- --------------------------
-positive_test1, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:06:28.605534
-positive_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2015-07-10 17:06:28.702813
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:06:28.712618
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.626473
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.804751
-positive_test1, execute, start FUNKY_OPT_UNIQUE 2015-07-10 17:06:38.816899
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.795368
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.811123
-positive_test1, execute, finished FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.865571
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.881210
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:06:51.925973
-positive_test2, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:06:54.121258
-positive_test2, launch canceler, finished FUNKY_OPT_UNIQUE 2015-07-10 17:06:54.135947
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:06:54.144872
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:07:03.218202
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:03.414289
-positive_test2, execute s1, start FUNKY_OPT_UNIQUE 2015-07-10 17:07:03.421669
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.425344
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.465426
-positive_test2, execute s1, finished FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.489121
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.500205
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:16.558636
-update_test1, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:07:18.691347
-update_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2015-07-10 17:07:18.710009
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:18.718706
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.214420
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.388345
-update_test1, execute, start FUNKY_OPT_UNIQUE 2015-07-10 17:07:28.397823
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:41.385593
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:07:41.400965
-update_test1, execute, finished FUNKY_OPT_UNIQUE 2015-07-10 17:07:48.069219
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:48.078175
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:48.109026
-delete_test1, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:07:50.200100
-delete_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2015-07-10 17:07:50.221685
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:50.230056
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.371817
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.504170
-delete_test1, execute, start FUNKY_OPT_UNIQUE 2015-07-10 17:07:59.512807
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:12.579070
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:08:12.595650
-delete_test1, execute, finished FUNKY_OPT_UNIQUE 2015-07-10 17:08:25.765256
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:25.774591
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:25.809037
-insert_test1, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:08:29.303373
-insert_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2015-07-10 17:08:29.322696
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:29.330814
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.663779
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.796777
-insert_test1, execute, start FUNKY_OPT_UNIQUE 2015-07-10 17:08:38.804614
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:54.896102
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:08:54.930493
-insert_test1, execute, finished FUNKY_OPT_UNIQUE 2015-07-10 17:08:56.579137
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:56.589386
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:56.622206
-insert_test2, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:08:59.024743
-insert_test2, launch canceler, finish FUNKY_OPT_UNIQUE 2015-07-10 17:08:59.042423
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:08:59.050281
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.564653
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.742892
-insert_test2, execute, start FUNKY_OPT_UNIQUE 2015-07-10 17:09:08.751928
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:24.776254
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:09:24.795329
-insert_test2, execute, finished FUNKY_OPT_UNIQUE 2015-07-10 17:09:25.871938
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:25.880384
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:25.911426
-upsert_test1, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:09:28.265459
-upsert_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2015-07-10 17:09:28.287050
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:28.294726
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.613861
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.723289
-upsert_test1, execute, start FUNKY_OPT_UNIQUE 2015-07-10 17:09:37.731436
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.801878
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.819783
-upsert_test1, execute, finished FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.825158
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.832495
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:53.970360
-cpu_bound_esps, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:09:56.333247
-cpu_bound_esps, launch canceler, finished FUNKY_OPT_UNIQUE 2015-07-10 17:09:56.347915
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:09:56.355395
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:10:06.308852
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:10:06.491893
-cpu_bound_esps, execute s1, start FUNKY_OPT_UNIQUE 2015-07-10 17:10:06.499750
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:10:19.492506
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:10:19.508940
-cpu_bound_esps, execute s1, finished FUNKY_OPT_UNIQUE 2015-07-10 17:10:30.705276
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:10:30.716871
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:10:30.748949
-escalation1, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:10:33.132692
-escalation1, launch canceler, finished FUNKY_OPT_UNIQUE 2015-07-10 17:10:33.149281
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:10:33.158984
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:10:42.217942
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:10:42.376461
-escalation1, execute s1, start FUNKY_OPT_UNIQUE 2015-07-10 17:10:42.381161
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:10:55.385636
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:10:55.400533
-escalation1, execute s1, finished FUNKY_OPT_UNIQUE 2015-07-10 17:11:06.526582
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:11:06.539511
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:11:06.580843
-ustats_test, launch canceler, start FUNKY_OPT_UNIQUE 2015-07-10 17:13:38.014277
-ustats_test, launch canceler, finished FUNKY_OPT_UNIQUE 2015-07-10 17:13:38.035897
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:13:38.045217
-do_cancel has begun FUNKY_OPT_UNIQUE 2015-07-10 17:13:47.211662
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:13:47.339719
-ustats_test, execute s1, start FUNKY_OPT_UNIQUE 2015-07-10 17:13:47.345734
-do_cancel will cancel FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.422546
-do_cancel has canceled FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.458124
-ustats_test, execute s1, finished FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.681401
-foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.693030
-foreground finished synch_cancel FUNKY_OPT_UNIQUE 2015-07-10 17:14:00.731016
+positive_test1, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:34:08.000319
+positive_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2018-09-11 06:34:08.000404
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:08.000422
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:34:15.000320
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:15.000500
+positive_test1, execute, start FUNKY_OPT_UNIQUE 2018-09-11 06:34:15.000512
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000478
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000490
+positive_test1, execute, finished FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000504
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000517
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:28.000556
+positive_test2, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:34:30.000773
+positive_test2, launch canceler, finished FUNKY_OPT_UNIQUE 2018-09-11 06:34:30.000790
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:30.000803
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:34:37.000416
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:37.000552
+positive_test2, execute s1, start FUNKY_OPT_UNIQUE 2018-09-11 06:34:37.000558
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:53.000562
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:34:53.000575
+positive_test2, execute s1, finished FUNKY_OPT_UNIQUE 2018-09-11 06:34:53.000593
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:53.000603
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:53.000639
+update_test1, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:34:55.000820
+update_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2018-09-11 06:34:55.000842
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:34:55.000854
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:35:02.000598
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:02.000704
+update_test1, execute, start FUNKY_OPT_UNIQUE 2018-09-11 06:35:02.000714
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:15.000766
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:35:15.000785
+update_test1, execute, finished FUNKY_OPT_UNIQUE 2018-09-11 06:35:26.000947
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:26.000957
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:26.000997
+delete_test1, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:35:29.000127
+delete_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2018-09-11 06:35:29.000146
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:29.000155
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:35:35.000856
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:36.000012
+delete_test1, execute, start FUNKY_OPT_UNIQUE 2018-09-11 06:35:36.000020
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:49.000012
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:35:49.000023
+delete_test1, execute, finished FUNKY_OPT_UNIQUE 2018-09-11 06:35:58.000200
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:58.000214
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:35:58.000267
+insert_test1, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:36:01.000618
+insert_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2018-09-11 06:36:01.000638
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:01.000648
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:36:08.000437
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:08.000616
+insert_test1, execute, start FUNKY_OPT_UNIQUE 2018-09-11 06:36:08.000623
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:24.000600
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:36:24.000613
+insert_test1, execute, finished FUNKY_OPT_UNIQUE 2018-09-11 06:36:26.000068
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:26.000078
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:26.000116
+insert_test2, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:36:28.000332
+insert_test2, launch canceler, finish FUNKY_OPT_UNIQUE 2018-09-11 06:36:28.000359
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:28.000371
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:36:36.000054
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:36.000178
+insert_test2, execute, start FUNKY_OPT_UNIQUE 2018-09-11 06:36:36.000187
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:52.000227
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:36:52.000239
+insert_test2, execute, finished FUNKY_OPT_UNIQUE 2018-09-11 06:36:53.000322
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:53.000331
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:53.000367
+upsert_test1, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:36:55.000615
+upsert_test1, launch canceler, finish FUNKY_OPT_UNIQUE 2018-09-11 06:36:55.000637
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:36:55.000646
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:37:02.000376
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:02.000505
+upsert_test1, execute, start FUNKY_OPT_UNIQUE 2018-09-11 06:37:02.000514
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000529
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000540
+upsert_test1, execute, finished FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000547
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000556
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:15.000598
+cpu_bound_esps, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:37:17.000965
+cpu_bound_esps, launch canceler, finished FUNKY_OPT_UNIQUE 2018-09-11 06:37:17.000989
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:17.000998
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:37:24.000862
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:24.000972
+cpu_bound_esps, execute s1, start FUNKY_OPT_UNIQUE 2018-09-11 06:37:24.000977
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:41.000023
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:37:41.000039
+cpu_bound_esps, execute s1, finished FUNKY_OPT_UNIQUE 2018-09-11 06:37:52.000257
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:52.000268
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:52.000309
+escalation1, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:37:54.000648
+escalation1, launch canceler, finished FUNKY_OPT_UNIQUE 2018-09-11 06:37:54.000667
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:37:54.000677
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:38:01.000406
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:38:01.000537
+escalation1, execute s1, start FUNKY_OPT_UNIQUE 2018-09-11 06:38:01.000541
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:38:17.000572
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:38:17.000584
+escalation1, execute s1, finished FUNKY_OPT_UNIQUE 2018-09-11 06:38:28.000785
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:38:28.000793
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:38:28.000835
+ustats_test, launch canceler, start FUNKY_OPT_UNIQUE 2018-09-11 06:41:10.000830
+ustats_test, launch canceler, finished FUNKY_OPT_UNIQUE 2018-09-11 06:41:10.000847
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:41:10.000857
+do_cancel has begun FUNKY_OPT_UNIQUE 2018-09-11 06:41:17.000715
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:41:17.000844
+ustats_test, execute s1, start FUNKY_OPT_UNIQUE 2018-09-11 06:41:17.000849
+do_cancel will cancel FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000889
+do_cancel has canceled FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000901
+ustats_test, execute s1, finished FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000942
+foreground awaits synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000951
+foreground finished synch_cancel FUNKY_OPT_UNIQUE 2018-09-11 06:41:30.000991
--- 110 row(s) selected.
>>
http://git-wip-us.apache.org/repos/asf/trafodion/blob/859f071e/core/sql/regress/executor/TEST106
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST106 b/core/sql/regress/executor/TEST106
index dca40fd..28c9c25 100755
--- a/core/sql/regress/executor/TEST106
+++ b/core/sql/regress/executor/TEST106
@@ -515,6 +515,9 @@ obey TEST106(synch_cancel);
obey TEST106(append_cancel_log);
?section upsert_test1
+cqd DYN_QUEUE_RESIZE_OVERRIDE 'ON';
+cqd GEN_TRSP_SIZE_DOWN '16';
+cqd GEN_TRSP_SIZE_UP '16';
prepare s1 from
upsert using load into t106c
@@ -574,7 +577,9 @@ insert into T106_interleaved_log values
obey TEST106(synch_cancel);
obey TEST106(append_cancel_log);
-
+cqd DYN_QUEUE_RESIZE_OVERRIDE reset;
+cqd GEN_TRSP_SIZE_DOWN reset;
+cqd GEN_TRSP_SIZE_UP reset;
?section cpu_bound_esps
-- Test cancel when esps are CPU-bound.
http://git-wip-us.apache.org/repos/asf/trafodion/blob/859f071e/core/sql/sqlcomp/nadefaults.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp
index b5aea4a..73ab57c 100644
--- a/core/sql/sqlcomp/nadefaults.cpp
+++ b/core/sql/sqlcomp/nadefaults.cpp
@@ -1329,7 +1329,7 @@ SDDkwd__(EXE_DIAGNOSTIC_EVENTS, "OFF"),
DDui1__(GEN_ONLJ_RIGHT_SIDE_QUEUE_UP, "2048"),
DDkwd__(GEN_ONLJ_SET_QUEUE_LEFT, "ON"),
DDkwd__(GEN_ONLJ_SET_QUEUE_RIGHT, "ON"),
- DDui1__(GEN_ONLJ_SIZE_DOWN, "8"),
+ DDui1__(GEN_ONLJ_SIZE_DOWN, "2048"),
DDui1__(GEN_ONLJ_SIZE_UP, "2048"),
DDipcBu(GEN_PA_BUFFER_SIZE, "31000"),
DDui1__(GEN_PA_NUM_BUFFERS, "5"),
[2/2] trafodion git commit: Merge remote branch 'origin/pr/1712/head'
into merge_1712
Posted by sa...@apache.org.
Merge remote branch 'origin/pr/1712/head' into merge_1712
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/94f59ace
Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/94f59ace
Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/94f59ace
Branch: refs/heads/master
Commit: 94f59aceb2a25fe4d1198399002f2263dc6a2f09
Parents: c006685 859f071
Author: Sandhya Sundaresan <sa...@apache.org>
Authored: Tue Sep 11 17:57:02 2018 +0000
Committer: Sandhya Sundaresan <sa...@apache.org>
Committed: Tue Sep 11 17:57:02 2018 +0000
----------------------------------------------------------------------
core/sql/regress/executor/EXPECTED106 | 451 +++++++++++++++--------------
core/sql/regress/executor/TEST106 | 7 +-
core/sql/sqlcomp/nadefaults.cpp | 2 +-
3 files changed, 241 insertions(+), 219 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/trafodion/blob/94f59ace/core/sql/sqlcomp/nadefaults.cpp
----------------------------------------------------------------------