Bugs item #2892548, was opened at 2009-11-05 12:56 Message generated for change (Settings changed) made by vzzzbx You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2892548&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: MonetDB Common "stable" >Status: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) Assigned to: Nobody/Anonymous (nobody) Summary: SQL: concurrency triggers gdk assertion Initial Comment: Version: Yesterday's Nov2009 cvs. similar to [bug 2890035] When running 20 simultaneous jdbc connections, the mserver5 crashes (after a while) with the error below. If running the same amount of queries through 10 jdbc connections, the mserver5 instance does not crash. $ ~/opt/MonetDB-stable/bin/mserver5 --dbinit="include sql;" --set mapi_port=50259 --dbfarm=/export/scratch0/roberto/wouter/dbfarm/ --dbname=db1 # MonetDB server v5.14.3, based on kernel v1.32.3 # Serving database 'db1', using 4 threads # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked # 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 #warning: please don't forget to set your vault key! #(see /home/alink/opt/MonetDB-stable/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50259/ # MonetDB/SQL module v2.32.3 loaded >mserver5: >/export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB/src/gdk/gdk_bbp.mx:1759: > incref: Assertion >`BBP[(((int)(i))>0?((int)(i)):-((int)(i)))].refs+BBP[(((int)(i))>0?((int)(i)):-((int)(i)))].lrefs > || BBP[(((int)(i))>0?((int)(i)):-((int)(i)))].status&16' failed. Aborted ---------------------------------------------------------------------- >Comment By: Wouter Alink (vzzzbx) Date: 2009-11-15 16:44 Message: as the someone might have noticed... I messed up versions. The mserver5 in the bug-report says '5.14', which is the Aug2009 release. I cannot reproduce this one with the actual Nov2009 branch. Closing without bugreport, as it is difficult to reproduce the circumstances (database itself is too large for actual inclusion in the testweb). ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2009-11-06 15:33 Message: additional info: also happens when starting server with "--set gdk_nr_threads=1" option ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2009-11-06 10:30 Message: (gdb) bt #0 0x00000036efa32f05 in raise () from /lib64/libc.so.6 #1 0x00000036efa34a73 in abort () from /lib64/libc.so.6 #2 0x00000036efa2bef9 in __assert_fail () from /lib64/libc.so.6 #3 0x00007f2c0a0d0dc1 in incref (i=1477, logical=1, lock=0) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB/src/gdk/gdk_bbp.mx:1759 #4 0x00007f2c0a0d1962 in decref (i=1477, logical=1, releaseShare=0) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB/src/gdk/gdk_bbp.mx:1837 #5 0x00007f2c0a0d1163 in BBPdecref (i=1477, logical=1) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB/src/gdk/gdk_bbp.mx:1873 #6 0x00007f2c0aa34e1e in runMALsequence (cntxt=0x607580, mb=0x46a44a8, startpc=1, stoppc=0, stk=0x488f998, env=0x0, pcicaller=0x0) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_interpreter.mx:1590 #7 0x00007f2c0aa2d07b in callMAL (cntxt=0x607580, mb=0x46a44a8, env=0x7f2bb38a3da8, argv=0x7f2bb38a3df0, debug=0 '\0') at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_interpreter.mx:400 #8 0x00007f2bf5c66a52 in SQLexecutePrepared (c=0x607580, be=0x44b3198, q=0x47bfde8) at /export/scratch0/roberto/wouter/workspace/MonetDB/sql/src/backends/monet5/sql_scenario.mx:1206 #9 0x00007f2bf5c66cc1 in SQLengineIntern (c=0x607580, be=0x44b3198) at /export/scratch0/roberto/wouter/workspace/MonetDB/sql/src/backends/monet5/sql_scenario.mx:1259 #10 0x00007f2bf5c6718b in SQLengine (c=0x607580) at /export/scratch0/roberto/wouter/workspace/MonetDB/sql/src/backends/monet5/sql_scenario.mx:1369 #11 0x00007f2c0aa7032d in runPhase (c=0x607580, phase=4) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:602 #12 0x00007f2c0aa704ba in runScenarioBody (c=0x607580) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:647 #13 0x00007f2c0aa70651 in runScenario (c=0x607580) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:672 #14 0x00007f2c0aa2af8d in MSserveClient (dummy=0x607580) at /export/scratch0/roberto/wouter/workspace/MonetDB/MonetDB5/src/mal/mal_session.mx:496 #15 0x00000036f06073da in start_thread () from /lib64/libpthread.so.0 #16 0x00000036efae62bd in clone () from /lib64/libc.so.6 (gdb) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2892548&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
