some of the column "clientport" is NULL, but if change to another query method, it appeared again.

2. another bug:

sql>select * from t_ivr_result limit 1;
could not allocate space for
HEAPextend: failed to extend to 15096348672 for 02/04/20413.theap

another time:

ERROR: HEAPextend: failed to extend to 23460839424 for 02/21/22122.theap

it seems monetdb applied a heap of 15G ,the RAM is 64G,

root@10.187.22.175:~# free -g
             total       used       free     shared    buffers     cached
Mem:            62         45         16          0          0         43
-/+ buffers/cache:          2         60
Swap:            2          0          2

so the left memory is 16G, but failed to applied 15G heap.

and the table t_ivr_result is only 3G, there is no need to apply such a

large heap.

sql>select count(*) from t_ivr_result;
+----------+
| L1 |
+==========+
| 40299239 |
+----------+
1 tuple (137.023ms)

sometimes the heap is 24G:

ERROR: MALException:mat.pack:could not allocate space for
ERROR: HEAPextend: failed to extend to 23460839424 for 02/21/22122.theap

Thanks,

Meng