Merge remote branch 'origin/pr/1712/head' into merge_1712
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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
>>
>>
>>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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
>>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 @@
>>
>>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 @@
>>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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
>>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 @@
(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 @@
(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 @@
(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 @@
(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 @@
(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 @@
--- 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 @@
(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 @@
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.
>>
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(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 @@
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.
diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp
index 457a096..bd7e334 100644
--- a/core/sql/sqlcomp/nadefaults.cpp
+++ b/core/sql/sqlcomp/nadefaults.cpp
@@ -1329,7 +1329,7 @@
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"),
