Bugs item #2892548, was opened at 2009-11-05 12:56
Message generated for change (Comment added) 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: Open
Resolution: None
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-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

Reply via email to