Date: 2019-02-20 16:51:44 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development

Last updated: 2020-06-10 13:46:04 +0200

Comment 26898

Date: 2019-02-20 16:51:44 +0100
From: @PedroTadim

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

Inserting into a replica table crashes the server, just that.

Reproducible: Always

Steps to Reproduce:

1.create replica table t1 (a int);
2. insert into t1 values (1);

Actual Results:

A SIGSEGV.

Expected Results:

An error in the upper case.

Back-trace:

Thread 18 "mserver5" received signal SIGSEGV, Segmentation fault.
0x00007ffff7ec60df in append_col (tr=0x250f650, c=0x7fffac035200, i=0x7fffac06c360, tpe=5) at bat_storage.c:838
838 obat = timestamp_delta(oc->data, tr->stime);
Missing separate debuginfos, use: dnf debuginfo-install libnghttp2-1.34.0-1.fc29.x86_64
(gdb) bt
0 0x00007ffff7ec60df in append_col (tr=0x250f650, c=0x7fffac035200, i=0x7fffac06c360, tpe=5) at bat_storage.c:838
1 0x00007ffff7d01c0a in mvc_append_wrap (cntxt=0x7fffe8c99378, mb=0x7fffac056a30, stk=0x7fffac06bc60, pci=0x7fffac06ada0) at sql.c:1298
2 0x00007ffff78f465a in runMALsequence (cntxt=0x7fffe8c99378, mb=0x7fffac056a30, startpc=1, stoppc=0, stk=0x7fffac06bc60, env=0x0, pcicaller=0x0) at mal_interpreter.c:623
3 0x00007ffff78f3165 in runMAL (cntxt=0x7fffe8c99378, mb=0x7fffac056a30, mbcaller=0x0, env=0x0) at mal_interpreter.c:327
4 0x00007ffff7d1ece2 in SQLrun (c=0x7fffe8c99378, be=0x7fffac0079e0, m=0x7fffac00fb90) at sql_execute.c:374
5 0x00007ffff7d20688 in SQLengineIntern (c=0x7fffe8c99378, be=0x7fffac0079e0) at sql_execute.c:784
6 0x00007ffff7d1cea3 in SQLengine (c=0x7fffe8c99378) at sql_scenario.c:1324
7 0x00007ffff791d380 in runPhase (c=0x7fffe8c99378, phase=4) at mal_scenario.c:510
8 0x00007ffff791d520 in runScenarioBody (c=0x7fffe8c99378, once=0) at mal_scenario.c:538
9 0x00007ffff791d75a in runScenario (c=0x7fffe8c99378, once=0) at mal_scenario.c:569
10 0x00007ffff791f4e9 in MSserveClient (dummy=0x7fffe8c99378) at mal_session.c:520
11 0x00007ffff791efab in MSscheduleClient (command=0x7fffac000b30 "\020w", challenge=0x7fffda25fccb "Ur3Mfydhe4b", fin=0x7fffac006550, fout=0x7fffdc002d60, protocol=PROTOCOL_9, blocksize=8190) at mal_session.c:398
12 0x00007ffff79ce46b in doChallenge (data=0x8c87f0) at mal_mapi.c:270
13 0x00007ffff7673bb4 in THRstarter (a=0x7fffdc004e50) at gdk_utils.c:1465
14 0x00007ffff76ecd47 in thread_starter (arg=0x2714e40) at gdk_system.c:546
15 0x00007ffff688a58e in start_thread (arg=) at pthread_create.c:486
16 0x00007ffff67b96a3 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Comment 26901

Date: 2019-02-20 16:52:37 +0100
From: MonetDB Mercurial Repository <>

Changeset 4f140644347c made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=4f140644347c

Changeset description:

Added tests for bugs 6683 and 6684.

Also bug #6424 requires the netcdf module.

Comment 26906

Date: 2019-02-27 09:37:44 +0100
From: MonetDB Mercurial Repository <>

Changeset a540ef19db1b made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=a540ef19db1b

Changeset description:

Disable any insert/update/delete statements on replica tables. This fixes bug #6684.

Comment 27814

Date: 2020-06-10 13:46:04 +0200
From: MonetDB Mercurial Repository <>

Changeset 272d6813c95d made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=272d6813c95d

Changeset description:

Fix for bug #6684. e_cmp expressions are always bound to the boolean type