Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

server crashed on simple (malformed) query #3399

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

server crashed on simple (malformed) query #3399

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2013-11-25 18:24:26 +0100
From: @gijzelaerr
To: SQL devs <>
Version: 11.15.17 (Feb2013-SP5)
CC: @mlkersten, @njnes, @drstmane

Last updated: 2014-02-20 15:02:32 +0100

Comment 19357

Date: 2013-11-25 18:24:26 +0100
From: @gijzelaerr

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.57 Safari/537.36
Build Identifier:

$ monetdb create bla
$ monetdb release bla
$ mclient bla
sql>create table bla (id int);
sql>select (select id) from bla;
Connection terminated

$ monetdb status bla
name state health remarks
bla C 55s 0% 0s crashed on 2013-11-25 18:20:36

Reproducible: Always

Steps to Reproduce:

  1. run code in details

Actual Results:

crash

Expected Results:

no crash

11.15.17-20131008 (debian packages)

Comment 19358

Date: 2013-11-25 22:53:37 +0100
From: @mlkersten

thanks, bug confirmed on default.

Comment 19361

Date: 2013-11-29 16:35:11 +0100
From: @drstmane

A first gdb trace (with Feb2013):

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fffee1b1700 (LWP 16055)]
0x00007fffef267548 in rel_groupby (sql=0x7fffe0005470, l=0x0, groupbyexps=0x0) at /ufs/manegold//Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:921
921 rel->nrcols = l->nrcols;
Missing separate debuginfos, use: debuginfo-install bzip2-libs-1.0.6-7.fc18.x86_64 cfitsio-3.300-2.fc18.x86_64 cyrus-sasl-lib-2.1.23-37.fc18.x86_64 geos-3.3.2-3.fc18.x86_64 glibc-2.16-34.fc18.x86_64 keyutils-libs-1.5.6-1.fc18.x86_64 krb5-libs-1.10.3-17.fc18.x86_64 libcom_err-1.42.5-1.fc18.x86_64 libcurl-7.27.0-12.fc18.x86_64 libgcc-4.7.2-8.fc18.x86_64 libidn-1.26-1.fc18.x86_64 libselinux-2.1.12-7.3.fc18.x86_64 libssh2-1.4.3-2.fc18.x86_64 libstdc++-4.7.2-8.fc18.x86_64 libuuid-2.22.2-7.fc18.x86_64 libxml2-2.9.1-1.fc18.1.x86_64 ncurses-libs-5.9-11.20130511.fc18.x86_64 nspr-4.10.1-1.fc18.x86_64 nss-3.15.2-1.fc18.x86_64 nss-softokn-freebl-3.15.2-1.fc18.x86_64 nss-util-3.15.2-1.fc18.x86_64 openldap-2.4.35-4.fc18.1.x86_64 openssl-libs-1.0.1e-30.fc18.x86_64 pcre-8.31-5.fc18.x86_64 readline-6.2-5.fc18.x86_64 xz-libs-5.1.2-2alpha.fc18.x86_64 zlib-1.2.7-9.fc18.x86_64
(gdb) bt
0 0x00007fffef267548 in rel_groupby (sql=0x7fffe0005470, l=0x0, groupbyexps=0x0) at /ufs/manegold/
/Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:921
1 0x00007fffef277217 in rel_value_exp2 (sql=0x7fffe0005470, rel=0x7fffee1b09a0, se=0x7fffe00c50d0, f=2, ek=..., is_last=0x7fffee1b08ac) at /ufs/manegold//Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:4602
2 0x00007fffef277660 in rel_value_exp (sql=0x7fffe0005470, rel=0x7fffee1b09a0, se=0x7fffe00c50d0, f=2, ek=...) at /ufs/manegold/
/Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:4670
3 0x00007fffef277745 in column_exp (sql=0x7fffe0005470, rel=0x7fffee1b09a0, column_e=0x7fffe00c51d0, f=2) at /ufs/manegold//Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:4683
4 0x00007fffef2779a8 in rel_column_exp (sql=0x7fffe0005470, rel=0x7fffee1b09a0, column_e=0x7fffe00c51d0, f=2) at /ufs/manegold/
/Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:4727
5 0x00007fffef278547 in rel_select_exp (sql=0x7fffe0005470, rel=0x7fffe00c56c0, sn=0x7fffe00c5490, ek=...) at /ufs/manegold//Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:4920
6 0x00007fffef27927c in rel_query (sql=0x7fffe0005470, rel=0x0, sq=0x7fffe00c5490, toplevel=1, ek=..., apply=8) at /ufs/manegold/
/Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:5125
7 0x00007fffef27aba7 in rel_subquery (sql=0x7fffe0005470, rel=0x0, sq=0x7fffe00c5490, ek=..., apply=8) at /ufs/manegold//Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:5500
8 0x00007fffef27ac44 in rel_selects (sql=0x7fffe0005470, s=0x7fffe00c5490) at /ufs/manegold/
/Monet/HG/Feb2013/source/MonetDB/sql/server/rel_select.c:5511
9 0x00007fffef264453 in rel_semantic (sql=0x7fffe0005470, s=0x7fffe00c5490) at /ufs/manegold//Monet/HG/Feb2013/source/MonetDB/sql/server/rel_semantic.c:263
10 0x00007fffef1ec34b in sql_symbol2relation (c=0x7fffe0005470, sym=0x7fffe00c5490) at /ufs/manegold/
/Monet/HG/Feb2013/source/MonetDB/sql/backends/monet5/sql.mx:1751
11 0x00007fffef1b8b06 in SQLparser (c=0x627f88) at /ufs/manegold//Monet/HG/Feb2013/source/MonetDB/sql/backends/monet5/sql_scenario.c:1712
12 0x00007ffff7a65bd2 in runPhase (c=0x627f88, phase=1) at /ufs/manegold/
/Monet/HG/Feb2013/source/MonetDB/monetdb5/mal/mal_scenario.c:522
13 0x00007ffff7a65d24 in runScenarioBody (c=0x627f88) at /ufs/manegold//Monet/HG/Feb2013/source/MonetDB/monetdb5/mal/mal_scenario.c:557
14 0x00007ffff7a65ede in runScenario (c=0x627f88) at /ufs/manegold/
/Monet/HG/Feb2013/source/MonetDB/monetdb5/mal/mal_scenario.c:586
15 0x00007ffff7a67054 in MSserveClient (dummy=0x627f88) at /ufs/manegold/_/Monet/HG/Feb2013/source/MonetDB/monetdb5/mal/mal_session.c:446
16 0x0000003e16c07d15 in start_thread () from /lib64/libpthread.so.0
17 0x0000003e160f253d in clone () from /lib64/libc.so.6
(gdb) li
916 }
917 }
918 rel->l = l;
919 rel->r = groupbyexps;
920 rel->exps = aggrs;
921 rel->nrcols = l->nrcols;
922 rel->op = op_groupby;
923 return rel;
924 }
925
(gdb) p l
$1 = (sql_rel *) 0x0
(gdb) p l->nrcols
Cannot access memory at address 0x20

Comment 19363

Date: 2013-12-01 12:08:31 +0100
From: MonetDB Mercurial Repository <>

Changeset b82b64682eb4 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=b82b64682eb4

Changeset description:

fixed bug #3399, if no apply is found/needed we can fallback to an
empty projection.
fixed bug in pqueue.c: handle voids (again)

Comment 19597

Date: 2014-02-20 15:02:32 +0100
From: @sjoerdmullender

Jan2014 has been released.

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants