Bugs item #2644925, was opened at 2009-02-27 11:49 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2644925&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: Yes Submitted By: Jens Oehlschlägel (jens_oehl) Assigned to: Niels Nes (nielsnes) Summary: crash-points with 1.5M Initial Comment: Stefan, attached you find a csv with the forward non-ODBC timings of - 600k version from Feb20 - 600k version from Feb26 - 1.5M version from Feb26 The 1.5M was crashing several times, number of the crashing queries: 875, 983, 987, 999, the four SQLs follow for your convenience. version from Feb26 is MonetDB server v5.10.0 (32-bit), based on kernel v1.28.0 (32-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: C:\Documents and Settings\sjoerd\My Documents\src\stable\vs32\NT32 Libraries: libpcre: 7.7 2008-05-07 libxml2: 2.6.32 Compiled by: sjo...@gans Compilation: cl -GF -W3 -WX -wd4273 -wd4102 -MD -nologo -Ox Linking : cl -GF -W3 -WX -wd4273 -wd4102 -MD -nologo -Ox crashing query SQL: SELECT KX, PostingYear, PostingStep, SUM(num1) as sNum1, SUM(den1) as sDen1 FROM ( SELECT MIN(1) as PostingStep, PostingYear, Min('X') as KX, SUM(DT_D02) as num1, MIN(0) as den1 FROM voc.q_SourceKPIReportsTarget WHERE ((PostingYear>=2005) AND (PostingYear <= 2006)) GROUP BY PostingYear) as sSub3 GROUP BY KX, PostingYear, PostingStep; SELECT KX, PostingYear, PostingStep, SUM(num1) as sNum1, SUM(den1) as sDen1 FROM ( SELECT Postingsemi as PostingStep, PostingYear, Min('X') as KX, SUM(DT_D02) as num1, MIN(0) as den1 FROM voc.q_SourceKPIReports WHERE (((PostingYear>2005 AND PostingYear<2006) OR (PostingYear=2005 AND Postingsemi>=1) OR (PostingYear=2006 AND Postingsemi<=2))) GROUP BY PostingYear, Postingsemi) as sSub3 GROUP BY KX, PostingYear, PostingStep; SELECT KX, PostingYear, PostingStep, SUM(num1) as sNum1, SUM(den1) as sDen1 FROM ( SELECT Postingsemi as PostingStep, PostingYear, Min('X') as KX, SUM(DT_D02) as num1, MIN(0) as den1 FROM voc.q_SourceKPIReportsTarget WHERE (((PostingYear>2005 AND PostingYear<2006) OR (PostingYear=2005 AND Postingsemi>=1) OR (PostingYear=2006 AND Postingsemi<=2))) GROUP BY PostingYear, Postingsemi) as sSub3 GROUP BY KX, PostingYear, PostingStep; SELECT KX, PostingYear, PostingStep, SUM(num1) as sNum1, SUM(den1) as sDen1 FROM ( SELECT Postingsemi as PostingStep, PostingYear, Min('X') as KX, SUM(DT_D04) as num1, MIN(0) as den1 FROM voc.q_SourceKPIReportsTarget WHERE (((PostingYear>2005 AND PostingYear<2006) OR (PostingYear=2005 AND Postingsemi>=1) OR (PostingYear=2006 AND Postingsemi<=2))) GROUP BY PostingYear, Postingsemi) as sSub3 GROUP BY KX, PostingYear, PostingStep; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2644925&group_id=56967 ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
