Bugs item #2644925, was opened at 2009-02-27 11:49 Message generated for change (Comment added) made by stmane 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; ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-02-27 19:09 Message: Jens, thank you very much for the details. I have not yet been able to have a closer look at the 4 failing queries on a 2 GB Win32 machine, but we plugged some more leaks since yesterday's installer. This afternoon, Sjoerd built new installers which will most probably be the version that we will "officially" release; you find them at http://monetdb.cwi.nl/downloads/Windows/Feb2009/ *Maybe* this already helps with the four failing queries ... Unfortunately we have not yet been able to properly fix the (indeed) "scary" SUM-CASE bug you reported. We'll provide you with an other installer, once also this bug is fixed. Stefan ---------------------------------------------------------------------- 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
