Bugs item #2953215, was opened at 2010-02-17 01:56 Message generated for change (Comment added) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2953215&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: MonetDB5 CVS Head Status: Open Resolution: Fixed Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Stefan Manegold (stmane) Summary: Head results in madvise error Initial Comment: Current head, since this afternoon. sql>select * from kvk where kvk = 1; MALException:!ERROR: madvise(a1d4bfa0, 9572264, 0) on (&b->T->heap) BUF_TO_MMAP[tb] failed OS: Invalid argument ---------------------------------------------------------------------- >Comment By: Stefan de Konink (skinkie) Date: 2010-02-18 02:52 Message: The error doesn't occur anymore. But maybe someone should look at this, especially the time taken for the where part. sql>select max(kvk) from kvk; +--------------+ | L6 | +==============+ | 412657690010 | +--------------+ 1 tuple Timer 27.874 msec 1 rows sql>select kvk from kvk where kvk = 412657690010; +--------------+ | kvk | +==============+ | 412657690010 | +--------------+ 1 tuple Timer 414.478 msec 1 rows sql>select avg(kvk) from kvk; +------------------------+ | L11 | +========================+ | 180371715703.39435 | +------------------------+ 1 tuple Timer 67.727 msec 1 rows ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2010-02-18 02:33 Message: Reports can be closed once Stefan dK & this test http://monetdb.cwi.nl/testing/projects/monetdb/Current/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugTracker-2009/union_leak.SF-2540169.err.00.html confirm the fix. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2010-02-18 02:26 Message: Sjoerd propagated the fix. Please check and report whether it now works for you. ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2010-02-17 03:02 Message: Vielen Dank! ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2010-02-17 02:05 Message: Most probably fixed in the Feb2010 branch by =================================================================== 2010/02/12 - stmane: MonetDB5/src/mal/mal_interpreter.mx,1.337.2.22 undoing the part of " 2010/02/12 - mlkersten: MonetDB5/src/mal/mal_interpreter.mx,1.337.2.21 Clean up of the getMemoryClaim. Debugging. " that added a BATmadvise(), as this seems to cause BATmadvise() errors and segfaults in various tests including TPCH & SSB =================================================================== last propagation to the development trunk happened between the original checkin and the above fix; next propagation to the development trunk will happen once time and SF allow ... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2953215&group_id=56967 ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
