Jov
I find the problem. My vm-public switch did not assign an ip addr and this make dnsmasq unhappy. I rember this is not a problem when the old bridge0 name?
I can't reproduce this bug on 64fb76fbfb68285c35802b33cdf3da99a293fb95 tree,so I think it is the "Support load of unlimited varying size strings to columnar store using dictionary" commit introduce the bug. in...
wired, on another server with the same data ,all sql above run ok. only difference is on another server the data is fresh loaded(I restart the server today) while the...
some more case: select cs_hash_dup_count(cs_filter(x.revision = cs_const('493383',32),x.uin) ,cs_filter(x.revision = cs_const('493383',32),x.class1)) from crashlog_get(620757031,now()::timestamp - '10 hour'::interval,now()::timestamp) as x where x is not null; run OK select cs_hash_dup_count(cs_filter(x.revision = cs_const('493383',32),x.uin) ,cs_filter(x.revision =...
it looks like memory dirty on this machine: select cs_count(x.class2) c0 ,cs_count(x.uin) as c1 ,cs_count(x.class1) as c2 ,cs_count(cs_filter(x.revision = cs_const('493383',32),x.uin)) as c3 ,cs_count(cs_filter(x.revision = cs_const('493383',32),x.class1)) as c4 from crashlog_get(620757031,'2014-04-14 12:00:00','2014-04-14...
no,restart the pg and reload the data to cs make all sql run ok.
How can I help to debug tihis problem？ it happened again. my usage: I have a partitioned table crashlog and the partition table named crashlog_p_20140101 ,crashlog_p_20140102... I have a cron...
I can repreduce the bug by 2 script concurrent running in 3 sessions: https://github.com/amutu/data/tree/master while the data is constant insert into crashlog table, open first session: while true do ./delete_load.sh...
I just try the new version,unfortunately,it still can be reproduced by the script above.
on the pgsql console,I get error some time(may happen,then disappear,then happen...): ERROR: group by sequence doesn't match values sequence when run sql: select cs_hash_dup_count(x.uin ,x.class1) from wx_version,crashlog_get(clientversion) as x where...