hi, any chance these data are public? if not, can you test on a separate box and see if the exact same thing happens or if it's hardware-specific?

On Thursday, July 14, 2016, Stefano Fioravanzo <fioravanzos@gmail.com> wrote:

Hello,

I currently have a table with 307524407 rows and 52 columns, it was loaded from a 78GB cvs file, but I do not know how much space the table actually takes on disk.
If I query the table with a simple query like:

select count(*) from big_table where field =1;

mserver5 crashes with ‘segmentation fault'
I tried also the following query (adding the LIMIT statement):
select count(*) from farmap_movimento where farmacia_id =1 limit 10;

and the output from mserver5 was:
mserver5: gdk_select.c:869: fullscan_int: Assertion `cnt < (bn)->S->capacity' failed.
Aborted

Doing a more complex query (the one I am aiming for), with also a group by and a few aggregation functions (sum, min) on the fields, the outputs is:
mserver5: gdk_bat.c:2066: BATsetcount: Assertion `b->S->capacity >= cnt' failed.
Aborted

This seems to be a table size problem, so…is there anything I can do?

I am using MonetDB 5 server v11.22.0
The machine has 30GB of RAM and 60GB of swap.
Available disk space: ~50GB

Any help would be much appreciated,

Regards,

Stefano

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list