Date: 2013-12-06 14:00:39 +0100
From: @swingbit
To: GDK devs <>
Version: 11.15.19 (Feb2013-SP6)

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

Comment 19394

Date: 2013-12-06 14:00:39 +0100
From: @swingbit

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:

Very difficult to make a reproducible test, but it seems to be happening when committing a large transaction which includes creation of tables + PK, FK, unique constraints. If needed I can provide access to a live gdb session on the database that reached the assertion.

mserver5: /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_bbp.c:3168: do_backup: As
sertion `h->storage == STORE_MMAP' failed.

The actual value for h->storage is STORE_MEM.

The problem seems to occur after changeset aa2e3065be7e

Reproducible: Always

$ mserver5 --version
MonetDB 5 server v11.15.20 (64-bit, 64-bit oids)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 15.6GiB available memory, 8 available cpu cores
Libraries:
libpcre: 8.32 2012-11-30 (compiled with 8.32)
openssl: OpenSSL 1.0.1e 11 Feb 2013 (compiled with OpenSSL 1.0.1e-fips 11 Feb 2013)
libxml2: 2.9.1 (compiled with 2.9.1)
Compiled by: roberto@photon.spinque.com (x86_64-unknown-linux-gnu)
Compilation: gcc -g -Werror -Wall -Wextra -W -Werror-implicit-function-declaration -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wformat=2 -Wno-format-nonliteral -Winit-self -Winvalid-pch -Wmissing-declarations -Wmissing-format-attribute -Wmissing-prototypes -Wold-style-definition -Wpacked -Wunknown-pragmas -Wvariadic-macros -fstack-protector-all -Wstack-protector -Wpacked-bitfield-compat -Wsync-nand -Wjump-misses-init -Wmissing-include-dirs -Wlogical-op -Wunreachable-code
Linking : /usr/bin/ld -m elf_x86_64

Comment 19395

Date: 2013-12-06 14:10:01 +0100
From: @swingbit

Sorry, I should have at least posted the bt:

0 do_backup (srcdir=0x7fc052c48a10 "bat/01/", nme=0x7fc052c48a50 "167", extbase=0x7fc05c29a822 "tail", h=0x2818af8, tp=3, dirty=1,
subcommit=1 '\001') at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_bbp.c:3168
1 0x00007fc05bdab1bd in BBPbackup (b=0x28189c0, subcommit=1 '\001')
at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_bbp.c:3247
2 0x00007fc05bdab51e in BBPsync (cnt=1316, subcommit=0x7fc01cf265a0)
at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_bbp.c:3298
3 0x00007fc05bd8e037 in TMsubcommit_list (subcommit=0x7fc01cf265a0, cnt=1316)
at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_tm.c:198
4 0x00007fc05be7aad6 in bm_subcommit (list_bid=0x2937680, list_nme=0x2937d60, catalog_bid=0x2937680, catalog_nme=0x2937d60,
extra=0x7fc01cef6cc0, debug=0) at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_logger.c:1009
5 0x00007fc05be7fc5a in bm_commit (lg=0x2937500) at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_logger.c:2040
6 0x00007fc05be79bba in logger_commit (lg=0x2937500) at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_logger.c:928
7 0x00007fc05be7cbdd in logger_exit (lg=0x2937500) at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_logger.c:1534
8 0x00007fc05be7cd1b in logger_restart (lg=0x2937500) at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/gdk/gdk_logger.c:1560
9 0x00007fc053dfbea0 in bl_restart () at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/sql/storage/bat/bat_logger.c:271
10 0x00007fc053de3422 in store_manager () at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/sql/storage/store.c:1553
11 0x00007fc053d6b93a in mvc_logmanager () at /opt/spinque/MonetDBServer/MonetDB.Spinque_Feb2013/src/sql/server/sql_mvc.c:149
12 0x0000003476c07c53 in start_thread () from /lib64/libpthread.so.0
13 0x00000034764f5dbd in clone () from /lib64/libc.so.6

Comment 19396

Date: 2013-12-06 15:24:07 +0100
From: MonetDB Mercurial Repository <>

Changeset 593bae62ca1e made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Remove assertion.
I wasn't really sure about the assertion anyway and I guess the
situation can occur that a backup file already exists when a BAT gets
subcommitted.

This fixes bug #3404.

Comment 19397

Date: 2013-12-06 15:24:58 +0100
From: @sjoerdmullender

This particular bug can't occur anymore: the assertion that went off has been removed.

Comment 19604

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

Jan2014 has been released.