Hi Brian Thank you for reporting. For clarity, all tables are joined on the primary key only? If not, what is the result of SELECT count(distinct guid) from table{a,b,c} Likewise SELECT count(distinct udp_port) from table... Could you attach gdb to the mserver and collect a stack trace? regards, Martin On 1/27/13 7:59 PM, Brian Hood wrote:
Hi All,
I'm not quite sure if i'm doing something wrong here but what is see if i performing a 2 table join on a primary key field is tablea and tableb work fine yet tablec which has less data crashes the daemon.
SELECT a.ip_dst as ip_dst, b.tcp_dport as tcp_dport, count(*) as num from "myschema".tablea a LEFT JOIN "myschema".tableb b ON (a.guid = b.guid) WHERE b.tcp_dport IS NOT NULL GROUP BY a.ip_dst, b.tcp_dport ORDER BY num DESC LIMIT 20;
This one works fine.
However when i perform the join from tablea to tablec
I get the following.
sql>SELECT a.ip_dst as ip_dst, b.udp_dport as udp_dport, count(*) as num from "myschema".tablea a LEFT JOIN "myschema".tablec b ON (a.guid = b.guid) WHERE b.udp_dport IS NOT NULL GROUP BY a.ip_dst, b.udp_dport ORDER BY num DESC LIMIT 20 more>; Connection terminated
I've added alot more detail to the pastebin link.
I had the same issue with 11.13.5 after upgrading i have run into the same thing also.
If you want to schema information to reproduce please just email me off list.
Regards,
Brian Hood
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list