gdk_bat.c:2861: BATassertHeadProps: Assertion `!b->H->nonil || cmp != 0' failed.

[monetdb-team]

Date: 2014-10-03 16:21:37 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.17.21 (Jan2014-SP3)
CC: @njnes

Last updated: 2014-10-31 14:15:02 +0100

Comment 20237

Date: 2014-10-03 16:21:37 +0200
From: Martin van Dinther <<martin.van.dinther>>

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:32.0) Gecko/20100101 Firefox/32.0
Build Identifier:

assertion failure when computing log() of a negative (double) value

Reproducible: Always

Steps to Reproduce:

1. start mserver5 (MonetDB 5 server v11.17.21 "Jan2014-SP3")
2. start mclient
3. execute SQL commands:
   CREATE TABLE FLOAT8_TBL(f1 double);
   INSERT INTO FLOAT8_TBL(f1) VALUES (' -34.84');
   SELECT '' AS bad, log(f.f1) from FLOAT8_TBL f;

Actual Results:

bash-4.2$ ./start_mserver5.sh
builtin opt gdk_dbpath = /ufs/dinther/MonetDB201408/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 mapi_port = 49000
MonetDB 5 server v11.17.21 "Jan2014-SP3"
Serving database 'demo', using 8 threads
Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
Found 15.356 GiB available main-memory.
Copyright (c) 1993-July 2008 CWI.
Copyright (c) August 2008-2014 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:49000/
MonetDB/GIS module loaded
MonetDB/JAQL module loaded
MonetDB/SQL module loaded

SQL catalog created, loading sql scripts once
loading sql script: 09_like.sql
loading sql script: 10_math.sql
loading sql script: 11_times.sql
loading sql script: 12_url.sql
loading sql script: 13_date.sql
loading sql script: 14_inet.sql
loading sql script: 15_querylog.sql
loading sql script: 16_tracelog.sql
loading sql script: 17_compress.sql
loading sql script: 18_dictionary.sql
loading sql script: 19_cluster.sql
loading sql script: 20_vacuum.sql
loading sql script: 21_dependency_functions.sql
loading sql script: 22_clients.sql
loading sql script: 23_skyserver.sql
loading sql script: 24_zorder.sql
loading sql script: 25_debug.sql
loading sql script: 26_sysmon.sql
loading sql script: 39_analytics.sql
loading sql script: 40_geom.sql
loading sql script: 46_gsl.sql
loading sql script: 75_storagemodel.sql
loading sql script: 80_statistics.sql
loading sql script: 80_udf.sql
loading sql script: 99_system.sql
Bulk operator required for str.stringleft
Bulk operator required for str.stringleft
Bulk operator required for user.columnsize
Bulk operator required for user.heapsize
Bulk operator required for user.indexsize
mserver5: gdk_bat.c:2861: BATassertHeadProps: Assertion `!b->H->nonil || cmp != 0' failed.
23424 Aborted ./MonetDB201408/bin/mserver5 -d10 --set mapi_port=49000

bash-4.2$ mclient -p 49000
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.17.21 (Jan2014-SP3), 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>CREATE TABLE FLOAT8_TBL(f1 double);
operation successful (5.439ms)
sql>INSERT INTO FLOAT8_TBL(f1) VALUES (' -34.84');
1 affected rows (2.200ms)
sql>select * from float8_tbl;
+--------------------------+
| f1 |
+==========================+
| -34.840000000000003 |
+--------------------------+
1 tuple (1.021ms)
sql>SELECT '' AS bad, log(f.f1) from FLOAT8_TBL f;
sql>
bash-4.2$

Expected Results:

no assertion failure

Also reproducable in developers default branch (sources of 3 nov 2014):
mserver5: /ufs/dinther/dev/dev/gdk/gdk_bat.c:2908: BATassertHeadProps: Assertion `!b->H->nonil || cmp != 0' failed.

Comment 20240

Date: 2014-10-03 17:24:02 +0200
From: MonetDB Mercurial Repository <>

Changeset 23cf48780a55 made by Martin van Dinther martin.van.dinther@monetdbsolutions.com in the MonetDB repo, refers to this bug.

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

Changeset description:

Improved float8.sql tests. Could not generate the float8.stable.* files due to Mtest.py aborted (see bug #3594 & 3596)

Comment 20266

Date: 2014-10-08 15:02:39 +0200
From: MonetDB Mercurial Repository <>

Changeset 4237cf8af7d9 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=4237cf8af7d9

Changeset description:

skip whitespace when loading decimals fixes bug #3596

Comment 20268

Date: 2014-10-08 16:01:36 +0200
From: @njnes

should be fixed by the new errors returned from mmath functions

Comment 20403

Date: 2014-10-31 14:15:02 +0100
From: @sjoerdmullender

Oct2014 has been released.