Dear Souri,

please direct these kind of questions not at the developers-list but at the users-list (users-list@monetdb.org).

Now for the issue at hand.

Which version of monetdb are you using and which operating system?

In order for us to reproduce the error, we need to know the schema of both the main and temp table (you can hide attribute names if it is sensitive information) and also the *exact* query you are using to copy rows from one table to the other.

If you could also share the values of the records would also help.

In general you have to provide us with more information on your setup, and a way to reproduce the problem:)

Also, did you check the merovegnian.log ? no errors there? Maybe you can attach a debugger and see where monetdb fails?

Thank you,

Lefteris

On Tue, Mar 8, 2016 at 6:08 AM, Souri Ratnaparkhi < souri.ratnaparkhi@usain.com> wrote:

Hello monetdb team,

A gentle reminder. We have a main table with 126 columns and approx. 94000 rows. We are trying to load approx 2500 records from temporary table into main table using query “insert into select” query. The database crashes upon query execution. No specific error is created in log file. When tried with 1500 records, it works. We also created another main table with same DDL, that table is empty & inserted all the records from temp successfully without any issue.

What could be the reason? Is 126 cols an issue? Please help. We are stuck.

(btw: We have machine about 200GB of hard disk & 16 GB RAM (14 GB free))

Thank you

Souri Ratnaparkhi United Software Associates Pvt. Ltd. Pune, India Mob: 8975677255 Phone (India Lines): (91) 020-25445550 www.usain.com

-----Original Message----- From: developers-list [mailto:developers-list-bounces+souri.ratnaparkhi=usain.com@monetdb.org] On Behalf Of Stefan Manegold Sent: Tuesday, March 08, 2016 5:05 AM To: Lefteris Cc: Communication channel for developers of the MonetDB Subject: Re: MonetDB: leftmart - trying to fix Windows compilation: do not "i...

My mistake. Sorry!

Stefan

----- On Mar 8, 2016, at 12:12 AM, Lefteris lsidir@gmail.com wrote:

...

Stefan,

this needs to be inlined because it is used many times. I will deal with compilation issues later on. This is a dev branch and we are running different experiments every night. But with this change if measured times are different I would not know if it is because of other changes or because of the inline statement removal.

I would appreciate if you did not make any changes in this branch at the moment.

thank you,

lefteris

On Mon, Mar 7, 2016 at 8:34 PM, Stefan Manegold < commits+Stefan.Manegold=cwi.nl@monetdb.org> wrote:

...

Changeset: ea1aed8beff8 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ea1aed8beff8 Modified Files: gdk/gdk_bloom.c Branch: leftmart Log Message:

trying to fix Windows compilation: do not "inline" BLOOMask()

On Windows, compilation fails with failed invocation: cl -GF -W3 -WX -MD -nologo -Ox -Zi -Oi -I. -I... -I.....\gdk -I..\common\options -I.....\gdk..\common\options -I..\common\stream -I.....\gdk..\common\stream -I..\common\utils -I.....\gdk..\common\utils -I.....\buildtools\conf -DHAVE_ICONV -IC:\Libraries\iconv-1.11.1.win64-vs2010\include -DHAVE_LIBATOMIC_OPS -IC:\Libraries\atomic_ops-7.4.2 -DNDEBUG -LD -Felibbat.dll gdk_batop.obj gdk_select.obj gdk_search.obj gdk_hash.obj gdk_tm.obj gdk_orderidx.obj gdk_align.obj gdk_bbp.obj gdk_heap.obj gdk_utils.obj gdk_atoms.obj gdk_qsort.obj gdk_ssort.obj gdk_storage.obj gdk_bat.obj gdk_delta.obj gdk_cross.obj gdk_system.obj gdk_value.obj gdk_posix.obj gdk_logger.obj gdk_sample.obj gdk_calc.obj gdk_aggr.obj gdk_group.obj gdk_imprints.obj gdk_bloom.obj gdk_join.obj gdk_project.obj gdk_unique.obj gdk_firstn.obj libbat.res /link ..\common\options\monet_options.obj ..\common\stream\libstream.lib ..\common\utils\mutils.obj ..\common\utils\prompt.obj wsock32.lib Ws2_32.l ib C:\Libraries\zlib-1.2.8.win64-vs2010\lib\zdll.lib C:\Libraries\bzip2-1.0.6.win64-vs2010\lib\libbz2.lib psapi.lib Creating library libbat.lib and object libbat.exp gdk_join.obj : error LNK2019: unresolved external symbol BLOOMask referenced in function hashjoin libbat.dll : fatal error LNK1120: 1 unresolved externals

Maybe, the fact that BLOOMask() is "inline"d triggers this problem ...

diffs (11 lines):

diff --git a/gdk/gdk_bloom.c b/gdk/gdk_bloom.c --- a/gdk/gdk_bloom.c +++ b/gdk/gdk_bloom.c @@ -240,7 +240,6 @@ BATbloom(BAT *b) return GDK_SUCCEED; }

-inline int BLOOMask(BUN v, Bloomfilter *bloom) { BUN hv,mv,x,y,z; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | _______________________________________________ developers-list mailing list developers-list@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list