Bugs item #2019349, was opened at 2008-07-16 11:52
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2019349&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 2.24
Status: Open
>Resolution: None
>Priority: 6
Private: No
Submitted By: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: assert fails on algebra version
Initial Comment:
This bug only occurs in the current branch and for mclient -G.
If you run the following sql code you will crash mserver:
create table prop1 (subj int, obj int, prop int);
create table prop2 (subj int, obj int, prop int);
explain WITH A(subj, obj) as (SELECT * FROM prop1 where obj = 14660332)
SELECT prop, obj, cnt from (
( SELECT 'prop14657240_pso' as prop, B.obj, count(*) as cnt
FROM A, prop2 as B
WHERE A.subj = B.subj
GROUP BY B.obj HAVING count(*) > 1
)
) as trip;
drop table prop1;
drop table prop2;
Some debug information:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1107310928 (LWP 32432)]
0x00002aaabe74dddc in sql_ref_dec (r=0x21)
at /ufs/goncalve/MonetDB/current/sql/src/common/sql_mem.mx:50
50 assert(r->refcnt > 0);
Missing separate debuginfos, use: debuginfo-install bzip2.x86_64
e2fsprogs.x86_64 glibc.x86_64 keyutils.x86_64 krb5.x86_64 libselinux.x86_64
ncurses.x86_64 openssl.x86_64 pcre.x86_64 readline.x86_64 zlib.x86_64
(gdb) up
#1 0x00002aaabe6bf89e in stmt_destroy (s=0x21)
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_statement.mx:634
634 if (sql_ref_dec(&s->ref) == 0) {
(gdb) up
#2 0x00002aaabe6bfd23 in stmt_destroy (s=0xde9db8)
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_statement.mx:810
810 stmt_destroy(s->t);
(gdb) bt
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-07-21 12:17
Message:
Logged In: YES
user_id=1498628
Originator: YES
The problem is not resolved. If we change the table prop1 definition
(remove column prop):
create table prop1 (subj int, obj int);
The mserver will not give the error:
Column lists do not match
Instead of that it will crash (now the problem is seen on stable and
current branch):
Program received signal SIGABRT, Aborted.
[Switching to Thread 1107310928 (LWP 19310)]
0x0000003c6d030ec5 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install bzip2.x86_64
e2fsprogs.x86_64 glibc.x86_64 keyutils.x86_64 krb5.x86_64 libselinux.x86_64
ncurses.x86_64 openssl.x86_64 pcre.x86_64 readline.x86_64 zlib.x86_64
(gdb) up
#1 0x0000003c6d032970 in abort () from /lib64/libc.so.6
(gdb) up
#2 0x0000003c6d02a11f in __assert_fail () from /lib64/libc.so.6
(gdb) up
#3 0x00002aaabed042db in set2pivot (c=0x1043ff8, l=0xde58a8)
at /ufs/goncalve/MonetDB/stable/sql/src/server/sql_optimize.mx:1410
1410 assert(n);
(gdb) up
#4 0x00002aaabed04d5e in op_stmt2pivot (c=0x1043ff8, s=0x112f008)
at /ufs/goncalve/MonetDB/stable/sql/src/server/sql_optimize.mx:1633
1633 stmt *ns = set2pivot(c, s->op1.lval);
(gdb) down
#3 0x00002aaabed042db in set2pivot (c=0x1043ff8, l=0xde58a8)
at /ufs/goncalve/MonetDB/stable/sql/src/server/sql_optimize.mx:1410
1410 assert(n);
(gdb) p n
$1 = (node *) 0x0
(gdb)
Note: The tested added already covers this situation.
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-07-21 12:10
Message:
Logged In: YES
user_id=1498628
Originator: YES
The test was added at:
sql/src/test/BugTracker/Tests/assert_fails_on_algebra_version.SF-2019349
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2008-07-21 09:51
Message:
Logged In: YES
user_id=43556
Originator: NO
fixed in stable. Incorrectly used stmt_destroy (exp's != stmt). Also we
now return an error on not matching column lists.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2019349&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
