monetdb lost column info when queryring

8 Aug 2013

      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

integrity

integrity

Lefteris

tags

participants (2)