Monetdb database crashes

Hannes Mühleisen hannes.muehleisen at cwi.nl
Fri Mar 4 09:23:28 CET 2016


Hello Souri,


Hannes

> On 04 Mar 2016, at 06:02, Souri Ratnaparkhi <souri.ratnaparkhi at usain.com> wrote:
> 
> We have a 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.

we need some more details here. Which version of MonetDB, which operating system, what is the table structure and the query you run, can you share the dataset somehow? Generally, we would appreciate a minimal reproducible example and a bug report at http://bugs.monetdb.org

Best,


> When tried with 1500 records, it works. 
> We also created another 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.
126 columns is no problem. I would be worried from 100,000 columns onwards.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4127 bytes
Desc: not available
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20160304/8ea74faa/attachment.p7s>


More information about the developers-list mailing list