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
_______________________________________________
users-list mailing list
users-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list