Bugs item #2893247, was opened at 2009-11-06 13:44 Message generated for change (Settings changed) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2893247&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: Core Group: MonetDB5 "stable" >Status: Closed Resolution: None Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) >Assigned to: Martin Kersten (mlkersten) Summary: SQL: QOTupdateStatistics segfaults Initial Comment: Nov2009 I think it can be reproduced by first running a query prefixed with TRACE. Even after restarting the mserver5 instance it segfaults on the first query executed (without TRACE prefix). Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 0x7fcbad3fc950 (LWP 12773)] 0x00007fcbb00ac299 in QOTupdateStatistics (nme=0x7fcbb00b9322 "inline", actions=0, val=2) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/optimizer/opt_statistics.mx:159 159 lp = (lng*) BUNtail(bi,p); (gdb) bt #0 0x00007fcbb00ac299 in QOTupdateStatistics (nme=0x7fcbb00b9322 "inline", actions=0, val=2) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/optimizer/opt_statistics.mx:159 #1 0x00007fcbb00a668c in OPTinline (cntxt=0x604c70, mb=0x2c711f8, stk=0x0, p=0x2c71a28) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/optimizer/opt_inline.mx:222 #2 0x00007fcbb008902b in optimizeMALBlock (cntxt=0x604c70, mb=0x2c711f8) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/optimizer/opt_support.mx:671 #3 0x00007fcbadc700da in addQueryToCache (c=0x604c70) at /export/scratch0/roberto/wouter/workspace/MonetDB/sql/src/backends/monet5/sql_optimizer.mx:623 #4 0x00007fcbadc6e424 in backend_dumpproc (be=0x2c70b68, c=0x604c70, cq=0x2c71018, s=0x2c70e38) at /export/scratch0/roberto/wouter/workspace/MonetDB/sql/src/backends/monet5/sql_gencode.mx:1968 #5 0x00007fcbadc6541b in SQLparser (c=0x604c70) at /export/scratch0/roberto/wouter/workspace/MonetDB/sql/src/backends/monet5/sql_scenario.mx:1065 #6 0x00007fcbc2a6f32d in runPhase (c=0x604c70, phase=1) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:602 #7 0x00007fcbc2a6f424 in runScenarioBody (c=0x604c70) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:638 #8 0x00007fcbc2a6f651 in runScenario (c=0x604c70) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:672 #9 0x00007fcbc2a29f8d in MSserveClient (dummy=0x604c70) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_session.mx:496 #10 0x00000036f06073da in start_thread () from /lib64/libpthread.so.0 #11 0x00000036efae62bd in clone () from /lib64/libc.so.6 (gdb) l ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2009-11-06 19:23 Message: Thanks. The optimizer statistics tables were global and not protected. ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2009-11-06 13:49 Message: additional info: it only happens when multiple queries are tried to be spawned at the same time ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2893247&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
