sql>select * from kbms_logserver_msg t where  command = 'CmdWxInfo' and logdate = '2013-08-06' and functionret <> '0' and servertime > '1375757230' limit 10; 
+------------+-----------+--------------+-------------+----------+------------+---------------+------------+----------------+------------+------------+
| logdate    | command   | commandtype  | functionret | costtime | servertime | serverip      | serverport | clientip       | clientport | clienttype |
+============+===========+==============+=============+==========+============+===============+============+================+============+============+
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |     3032 | 1375757231 | 10.187.143.80 | 7000       | 10.153.130.228 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |     3032 | 1375757244 | 10.187.143.80 | 7000       | 10.153.130.228 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |     3030 | 1375757257 | 10.187.143.80 | 7000       | 10.153.130.229 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |     3032 | 1375757962 | 10.187.143.80 | 7000       | 10.153.130.229 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |     3030 | 1375757970 | 10.187.143.80 | 7000       | 10.153.130.228 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |       60 | 1375760693 | 10.187.143.80 | 7000       | 10.153.130.229 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |       60 | 1375760693 | 10.187.143.80 | 7000       | 10.153.130.228 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |       59 | 1375760693 | 10.187.143.80 | 7000       | 10.153.130.229 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |       63 | 1375760872 | 10.187.143.80 | 7000       | 10.153.130.229 |            |            |
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |       54 | 1375760872 | 10.187.143.80 | 7000       | 10.153.130.229 |            |            |
+------------+-----------+--------------+-------------+----------+------------+---------------+------------+----------------+------------+------------+
10 tuples (55.709ms)

sql>select * from kbms_logserver_msg t where  command = 'CmdWxInfo' and logdate = '2013-08-06' and functionret <> '0' and servertime = '1375757231' limit 10; 
+------------+-----------+--------------+-------------+----------+------------+---------------+------------+----------------+------------+------------+
| logdate    | command   | commandtype  | functionret | costtime | servertime | serverip      | serverport | clientip       | clientport | clienttype |
+============+===========+==============+=============+==========+============+===============+============+================+============+============+
| 2013-08-06 | CmdWxInfo | getwxinfoall |        -535 |     3032 | 1375757231 | 10.187.143.80 | 7000       | 10.153.130.228 | 44328      |            |
+------------+-----------+--------------+-------------+----------+------------+---------------+------------+----------------+------------+------------+
1 tuple (52.761ms)

in the first query,when servertime > '1375757230' limit 10;clientport are all NULL.

while in the second query, servertime = '1375757231' ,clientport appeard again.

it proves that the clientport exist but just didn't appear in the query.

------------------ Original ------------------

From:  "357416268"<357416268@qq.com>;

Date:  Thu, Aug 8, 2013 02:47 PM

To:  "users-list"<users-list@monetdb.org>;

Subject:  monetdb lost column info when queryring

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

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list