insert of negative value for oid column aborts mserver5 process with assertion failure

[monetdb-team]

Date: 2015-02-05 16:01:18 +0100
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2015-05-07 12:38:06 +0200

Comment 20634

Date: 2015-02-05 16:01:18 +0100
From: Martin van Dinther <<martin.van.dinther>>

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

mserver5: ../../dev/gdk/gdk_bat.c:2222: BATseqbase: Assertion `o <= oid_nil' failed.
/export/scratch1/dinther/INSTALL/bin/mserver5 -d10 --set embedded_r=true --set mapi_port=41000

Also it appears that after the abort, a restart of the mserver5 keeps on aborting with the assertion failure. Probably the database is corrupted.
Only a complete removal of the INSTALL/var/monetdb5/dbfarm/demo directory allowed me to restart the mserver5.

Reproducible: Always

Steps to Reproduce:

1. Start mserver5 (MonetDB 5 server v11.20.0, compiled from default branch on 5 febr 2015)
2. Start mclient
3. enter SQL commands:
   sql>CREATE TABLE OID_TBL(f1 oid);
   operation successful (8.883ms)
   sql>INSERT INTO OID_TBL(f1) VALUES (-1040);
   sql>SELECT * FROM OID_TBL;

Actual Results:

bash-4.2$ mclient -p 41000
Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
Database: MonetDB v11.20.0 (unreleased), 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>CREATE TABLE OID_TBL(f1 oid);
operation successful (8.883ms)
sql>INSERT INTO OID_TBL(f1) VALUES (-1040);
sql>SELECT * FROM OID_TBL;
bash-4.2$

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.20.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
MonetDB/SQL module loaded
MonetDB/R 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_temporal.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: 39_analytics_hge.sql
loading sql script: 40_geom.sql
loading sql script: 40_json.sql
loading sql script: 40_json_hge.sql
loading sql script: 41_jsonstore.sql
loading sql script: 45_uuid.sql
loading sql script: 46_gsl.sql
loading sql script: 72_fits.sql
loading sql script: 75_storagemodel.sql
loading sql script: 80_statistics.sql
loading sql script: 80_udf.sql
loading sql script: 80_udf_hge.sql
loading sql script: 85_bam.sql
loading sql script: 89_generator_hge.sql
loading sql script: 90_generator.sql
loading sql script: 99_system.sql
mserver5: ../../dev/gdk/gdk_bat.c:2222: BATseqbase: Assertion `o <= oid_nil' failed.
./start_INSTALL_mserver5.sh: line 5: 9603 Aborted /export/scratch1/dinther/INSTALL/bin/mserver5 -d10 --set embedded_r=true --set mapi_port=41000

When I try to restart the mserver5 I get:
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.20.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
mserver5: ../../dev/gdk/gdk_bat.c:2222: BATseqbase: Assertion `o <= oid_nil' failed.
./start_INSTALL_mserver5.sh: line 5: 9750 Aborted /export/scratch1/dinther/INSTALL/bin/mserver5 -d10 --set embedded_r=true --set mapi_port=41000
bash-4.2$

Expected Results:

no assertion failure
also it appears that after the abort, a restart of the mserver5 keeps on aborting with the assertion failure

negative oid values should not be accepted, an error msg should be returned

Comment 20646

Date: 2015-02-09 22:39:37 +0100
From: @njnes

fixed, added new class of positive numeric types (oid).