Date: 2017-02-05 17:29:18 +0100
From: @skinkie
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2017-03-03 10:24:21 +0100

Comment 24974

Date: 2017-02-05 17:29:18 +0100
From: @skinkie

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

I have just upgraded to the default branch of the MonetDB repository and with a clean installation/dbfarm. I am importing tables to restore the functionality. The last table I want to copy into is a file of 11GB. Originally defined by:

create table m152 (ts timestamp, vehiclenumber integer, lon numeric(9,7), lat numeric(8, 6), sat integer);

When trying to import I end up with the error message below. Since there is no mention of what "Leftover data" is, and is ambiguous if there is a table called leftover data that leaves the end user clueless how to proceed.

copy into m152 from '/mnt/volatile/raw/radiolog-new/M152.csv' delimiters '\t', '\n';
Failed to import table Leftover data 'False'

I figured out that the table definition changed, and should be:

create table m152 (ts timestamp, vehiclenumber integer, lon numeric(9,7), lat numeric(8, 6), sat integer, open boolean);

I would suggest to change the error message to:

Failed to import table m152. More columns were found than defined in the table definition. The extra data found is 'False'.

Reproducible: Always

MonetDB 5 server v11.26.0 (64-bit, 128-bit integers)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 62.8GiB available memory, 8 available cpu cores
Libraries:
libpcre: 8.38 2015-11-23 (compiled with 8.38)
openssl: OpenSSL 1.0.2h 3 May 2016 (compiled with OpenSSL 1.0.2h 3 May 2016)
libxml2: 2.9.4 (compiled with 2.9.4)
Compiled by: skinkie@chamechaude (x86_64-pc-linux-gnu)
Compilation: gcc -O3 -pipe -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/x86_64-pc-linux-gnu/bin/ld -m elf_x86_64

p.s. <3 importing 11GB :)
209630281 affected rows (1m 41s)

Comment 25017

Date: 2017-02-13 08:29:13 +0100
From: MonetDB Mercurial Repository <>

Changeset 891a9c0505d5 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=891a9c0505d5

Changeset description:

fix bug #6203, ie improve error message on failed copy into command.

approved errors

Comment 25018

Date: 2017-02-13 08:29:30 +0100
From: @njnes

improved the error message

Comment 25114

Date: 2017-03-03 10:24:21 +0100
From: @sjoerdmullender

Dec2016-SP2 has been released, incorporating the fix.