You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select data from "sys"."rejects" returns unexpected error and when next select data from "sys"."sessions" causes an assertion failure in mal_interpreter.c:646.
#3759
Closed
monetdb-team opened this issue
Nov 30, 2020
· 0 comments
bash-4.2$ mclient -p 41000
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.22.0 (unreleased), 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>select COUNT() from "sys"."queue";
+------+
| L1 |
+======+
| 1 |
+------+
1 tuple (1.241ms)
sql>select COUNT() from "sys"."rejects";
No reject table available
sql>select COUNT(*) from "sys"."sessions";
sql>
bash-4.2$
Expected Results:
No error for query: select COUNT(*) from "sys"."rejects";
Also the error msg "No reject table available" is strange as we are querying the rejects table, and not the reject (without an s) table
No assertion failure after query: select COUNT(*) from "sys"."sessions";
Potentially the assertion failure is due to some internal data corruption after executing: select COUNT(*) from "sys"."rejects";
The problem does NOT exist in Oct2014 SP4, but probably does exist in Jul2015 branch also. Please fix it in Jul2015 branch also.
Comment 20982
Date: 2015-07-09 16:10:51 +0200
From: Martin van Dinther <<martin.van.dinther>>
additional info: I compiled sources with configure flags: --enable-assert --disable-debug
Bug fixes
Bug #3759 fixed types of returned bats (ie use timestamps instead of lng) in modules/mal/clients.c
Bug #3769 fixed crash (triggered assert) by properly looking for referenced groupby columns in push aggr down
optimizer in rel_optimizer.c
Bug #3760 fixed correlated subquery handling in rel_select.c, ie merge only distinct expressions.
Bug #3761 fixed by properly adding the zero_or_one aggregation only when needed (ie when the cardinality of
the outer query is a column/table, ie when we expect one value per row for the subquery).
Bug #3364 fixed in sql_privileges.c, ie allow set role when role_id == auth_id (ie default role).
Bug #3365 fixed in sql_privileges.c, the sql_grant_table_privs always added 'all' privileges in one go
in rel_schema.c properly pass the login_id or role_id based on the 'from current_{role/user}'
part of the grant statement
Bug #3476 was already fixed by previous revoke / schema fixes.
in gdk/gdk_select.c fixed problem with anti select and nils (stop before first nil instead of last)
Date: 2015-07-09 15:37:05 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2015-08-28 13:41:25 +0200
Comment 20981
Date: 2015-07-09 15:37:05 +0200
From: Martin van Dinther <<martin.van.dinther>>
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:38.0) Gecko/20100101 Firefox/38.0
Build Identifier:
Reproducible: Always
Steps to Reproduce:
select COUNT() from "sys"."queue";
select COUNT() from "sys"."rejects";
select COUNT(*) from "sys"."sessions";
Actual Results:
bash-4.2$ ./start_INSTALL_mserver5.sh
builtin opt gdk_dbpath = /export/scratch1/dinther/INSTALL/var/monetdb5/dbfarm/demo
builtin opt gdk_debug = 0
builtin opt gdk_vmtrim = no
builtin opt monet_prompt = >
builtin opt monet_daemon = no
builtin opt mapi_port = 50000
builtin opt mapi_open = false
builtin opt mapi_autosense = false
builtin opt sql_optimizer = default_pipe
builtin opt sql_debug = 0
cmdline opt embedded_r = true
cmdline opt mapi_port = 41000
cmdline opt gdk_debug = 10
MonetDB 5 server v11.22.0
This is an unreleased version
Serving database 'demo', using 8 threads
Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit integers dynamically linked
Found 15.590 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Listening for connection requests on mapi:monetdb://127.0.0.1:41000/
MonetDB/GIS module loaded
Start processing logs sql/sql_logs version 52200
Finished processing logs sql/sql_logs
MonetDB/SQL module loaded
MonetDB/R module loaded
bash-4.2$ mclient -p 41000
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.22.0 (unreleased), 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>select COUNT() from "sys"."queue";
+------+
| L1 |
+======+
| 1 |
+------+
1 tuple (1.241ms)
sql>select COUNT() from "sys"."rejects";
No reject table available
sql>select COUNT(*) from "sys"."sessions";
sql>
bash-4.2$
Expected Results:
No error for query: select COUNT(*) from "sys"."rejects";
Also the error msg "No reject table available" is strange as we are querying the rejects table, and not the reject (without an s) table
No assertion failure after query: select COUNT(*) from "sys"."sessions";
Potentially the assertion failure is due to some internal data corruption after executing: select COUNT(*) from "sys"."rejects";
The problem does NOT exist in Oct2014 SP4, but probably does exist in Jul2015 branch also. Please fix it in Jul2015 branch also.
Comment 20982
Date: 2015-07-09 16:10:51 +0200
From: Martin van Dinther <<martin.van.dinther>>
additional info: I compiled sources with configure flags: --enable-assert --disable-debug
Comment 21075
Date: 2015-08-01 15:18:07 +0200
From: MonetDB Mercurial Repository <>
Changeset 30d12a4105a0 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=30d12a4105a0
Changeset description:
Comment 21080
Date: 2015-08-01 16:13:22 +0200
From: MonetDB Mercurial Repository <>
Changeset e431bcfc8a34 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=e431bcfc8a34
Changeset description:
Comment 21081
Date: 2015-08-01 16:14:07 +0200
From: @njnes
Fixed aligned sql with mal/c level types
Comment 21177
Date: 2015-08-28 13:41:25 +0200
From: @sjoerdmullender
Jul2015 has been released.
The text was updated successfully, but these errors were encountered: