[MonetDB-users] mserver5 process locked unkillable

I was testing some queries, and for example this query has made the mserver5 process 100% CPU, which i could not kill and machine could not be rebooted.

running Fedora 8 64 bit.

query like this:

select col1, col2, sum(col3), sum(col4), sum(col5) from thetable group by col1, col2;

there are about 160 columns in the table.

col1 and col2 are "smallint" col3, col4, col5 are "real"

number of distinct values: in col1 is about 120 in col2 about 80

total number of rows in table is about 400M

I tested the query 2 times, simpler queries work ok, like this: select col1, count(*) from thetable group by col1;

this query has crashed mserver5 before, not sure if this already fixed: select col1, count(1) from thetable group col1;