Bugs item #2865631, was opened at 2009-09-24 09:44
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2865631&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 "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Roberto Cornacchia (cornuz)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: incref assertion
Initial Comment:
The following query fails on Aug2009 updated on 23/09/2009, with an assertion
on incref.
It did work before the update, I can't be sure but I think the previous update
was about 2-3 weeks ago.
I can provide the data locally if necessary, it is quite large.
CREATE TABLE docdict_docdict AS
SELECT c.docid as c_docid, s.docid as s_docid
FROM docdict() as c, docDict as s
WHERE c.doc = s.doc
WITH DATA;
where docdict() is a mal function:
create function docdict()
returns table (docID int, doc varchar(1000))
external name sql.docdict;
function docdict{inline}():bat[:str,:bat];
b := bat.new(:str,:bat,2);
col1:bat[:void,:int] := bbp.bind("LHM_docDict_docID");
col2:bat[:void,:str] := bbp.bind("LHM_docDict_doc");
bat.insert(b, "docid", col1);
bat.insert(b, "doc", col2);
return docdict := b;
end docdict;
And the gdb backtrace:
(gdb) run --config=/ufs/roberto/lhm_code/HyServer/console/monetdb5.conf
--dbname=ALPA-406_100000 --dbinit="include sql;" --set monet_daemon=yes --set
mapi_open=false --set mapi_port=50152 --set
monet_vault_key=/export/scratch0/roberto/MonetDB/dbfarm.stable/ALPA-406_100000/.vaultkey
--set gdk_nr_threads=4Starting program:
/ufs/roberto/lhm_code/HyServer/MonetDB/MonetDB.stable/MonetDB/bin/mserver5
--config=/ufs/roberto/lhm_code/HyServer/console/monetdb5.conf
--dbname=ALPA-406_100000 --dbinit="include sql;" --set monet_daemon=yes --set
mapi_open=false --set mapi_port=50152 --set
monet_vault_key=/export/scratch0/roberto/MonetDB/dbfarm.stable/ALPA-406_100000/.vaultkey
--set gdk_nr_threads=4
[Thread debugging using libthread_db enabled]
[New Thread 0x7ffff67cd7b0 (LWP 5881)]
[New Thread 0x7fffec2e7950 (LWP 5890)]
# MonetDB server v5.14.1, based on kernel v1.32.1
# Serving database 'ALPA-406_100000', 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
[New Thread 0x7fffe3450950 (LWP 5891)]
# Listening for connection requests on mapi:monetdb://127.0.0.1:50152/
# MonetDB/SQL module v2.32.1 loaded
[New Thread 0x7fffe2ac2950 (LWP 5892)]
[New Thread 0x7fffe28c1950 (LWP 5980)]
[New Thread 0x7fffe26c0950 (LWP 5982)]
[New Thread 0x7fffe24bf950 (LWP 5983)]
[New Thread 0x7fffe22be950 (LWP 5984)]
[New Thread 0x7fffe20bd950 (LWP 5985)]
mserver5:
/ufs/roberto/lhm_code/HyServer/MonetDB/MonetDB.stable/src/MonetDB/src/gdk/gdk_bbp.mx:1758:
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.
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7fffe26c0950 (LWP 5982)]
0x0000003174432f05 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install
bzip2-libs-1.0.5-3.fc10.x86_64 cyrus-sasl-lib-2.1.22-19.fc10.x86_64
e2fsprogs-libs-1.41.4-6.fc10.x86_64 glibc-2.9-3.x86_64
keyutils-libs-1.2-3.fc9.x86_64 krb5-libs-1.6.3-18.fc10.x86_64
libcurl-7.19.6-1.fc10.x86_64 libidn-0.6.14-8.x86_64
libselinux-2.0.78-1.fc10.x86_64 libssh2-0.18-7.fc9.x86_64
libxml2-2.7.3-2.fc10.x86_64 libxslt-1.1.24-2.fc10.x86_64
ncurses-libs-5.6-20.20080927.fc10.x86_64 nspr-4.7.4-1.fc10.x86_64
nss-3.12.3.99.3-2.10.4.fc10.x86_64 openldap-2.4.12-1.fc10.x86_64
openssl-0.9.8g-14.fc10.x86_64 pcre-7.8-1.fc10.x86_64
raptor-1.4.18-1.fc10.x86_64 readline-5.2-13.fc9.x86_64 zlib-1.2.3-18.fc9.x86_64
(gdb) bt
#0 0x0000003174432f05 in raise () from /lib64/libc.so.6
#1 0x0000003174434a73 in abort () from /lib64/libc.so.6
#2 0x000000317442bef9 in __assert_fail () from /lib64/libc.so.6
#3 0x00007ffff7392dc4 in incref (i=2878, logical=1, lock=0) at
/ufs/roberto/lhm_code/HyServer/MonetDB/MonetDB.stable/src/MonetDB/src/gdk/gdk_bbp.mx:1758
#4 0x00007ffff7393965 in decref (i=2878, logical=1, releaseShare=0)
at
/ufs/roberto/lhm_code/HyServer/MonetDB/MonetDB.stable/src/MonetDB/src/gdk/gdk_bbp.mx:1836
#5 0x00007ffff7393166 in BBPdecref (i=2878, logical=1) at
/ufs/roberto/lhm_code/HyServer/MonetDB/MonetDB.stable/src/MonetDB/src/gdk/gdk_bbp.mx:1872
#6 0x00007ffff7d06aa9 in DFLOWstep (t=0x12ef608, fs=0x7fffe28bdcf0)
at
/ufs/roberto/lhm_code/HyServer/MonetDB/MonetDB.stable/src/MonetDB5/src/mal/mal_interpreter.mx:1590
#7 0x00007ffff7d0e502 in runDFLOWworker (t=0x12ef608) at
/ufs/roberto/lhm_code/HyServer/MonetDB/MonetDB.stable/src/MonetDB5/src/mal/mal_interpreter.mx:845
#8 0x00000031750073da in start_thread () from /lib64/libpthread.so.0
#9 0x00000031744e62bd in clone () from /lib64/libc.so.6
(gdb)
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-09-28 19:00
Message:
I cannot reproduce the problem.Maybe related to the missing data. ie could
we get the data of these tables?
----------------------------------------------------------------------
Comment By: Roberto Cornacchia (cornuz)
Date: 2009-09-24 11:45
Message:
Update: the problem seems related to using the function docdict(), which
binds two bats, in the join.
By first materialising this virtual table in a standard sql table, the
problem disappears:
CREATE TABLE c_docdict AS
SELECT *
FROM docdict()
WITH DATA;
CREATE TABLE docdict_docdict AS
SELECT c.docid as c_docid, s.docid as s_docid
FROM c_docdict as c, docDict as s
WHERE c.doc = s.doc
WITH DATA;
----------------------------------------------------------------------
Comment By: Roberto Cornacchia (cornuz)
Date: 2009-09-24 09:49
Message:
I forgot to describe the second table in input for this query:
sql>\d docdict
CREATE TABLE "lhm"."docdict" (
"docid" int NOT NULL,
"doc" varchar(1000),
"type" varchar(255),
"prob" double DEFAULT 1.000000,
CONSTRAINT "docdict_docid_pkey" PRIMARY KEY ("docid")
);
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2865631&group_id=56967
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
