Changeset: 0f8fa1998fee for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0f8fa1998fee
Modified Files:
        sql/sql/15_history.sql
Branch: Aug2011
Log Message:

disable mitosis in 15_history.sql to prevent yet undiscoved deadlock;

this is merely a temporary local work-around for nightly testing
until bug 2865 is eventually fixed


diffs (25 lines):

diff --git a/sql/sql/15_history.sql b/sql/sql/15_history.sql
--- a/sql/sql/15_history.sql
+++ b/sql/sql/15_history.sql
@@ -23,6 +23,13 @@
 -- Whenever a query is compiled and added to the cache, it is also entered
 -- into the 'queryHistory' table using a hardwired call to 'keepQuery'.
 
+-- Temporary and locally disable mitosis to prevent yet undiscoved deadlock;
+-- cf., bug 2865 (http://bugs.monetdb.org/show_bug.cgi?id=2865)
+declare dft_opt string;
+set dft_opt = ( select optimizer );
+set optimizer = 'no_mitosis_pipe';
+-- cf., `set optimizer = dft_opt` at the end of this script
+
 create table queryHistory(
        id wrd primary key,
        defined timestamp,      -- when entered into the cache
@@ -110,4 +117,7 @@ begin
        delete from queryHistory;
 end;
 
+-- cf., top of this script
+set optimizer = dft_opt;
+
 -- set history=true;
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list

Reply via email to