Hi Jenny,

No problem I seem have isolated the issue to having the Primary key constraint on the guid column I Dropped the constraints on the remote mserver nodes and then recreated the Merge / Remote tables without the constraint on the master.

Shall I file a bug report.

Regards,

Brian Hood

On Nov 25, 2015 5:09 PM, "Ying Zhang" <Y.Zhang@cwi.nl> wrote:

> On Nov 25, 2015, at 12:02, Brian Hood <brianh6854@googlemail.com> wrote:
>
> Hi Jennie,
>
> I did provide schema in the initial mail that's a collection of the 5 hosts each separated by a comment line.

Hai Brian,

Apologies!  Overlooked the attachment on the small telephone screen.

Best,
Jennie


>
> Regards,
>
> Brian Hood
>
> On Nov 25, 2015 7:39 AM, "Ying Zhang" <Y.Zhang@cwi.nl> wrote:
>
> > On Nov 23, 2015, at 18:36, Brian Hood <brianh6854@googlemail.com> wrote:
> >
> > Hi Guys,
> >
> > I have 1 master and 4 mserver nodes running.
> >
> > I have 4 ippacket and 4 tcppacket schemas identical per table schemas across all nodes.
> >
> > i have 4 remote references on the master to ippacket remote nodes and the same for tcppacket.
> >
> > However when i try and join 2 MERGE tables each containing 4 schemas i get the following.
> >
> > sql>select count(*) from ippacket a, tcppacket b where a.guid = b.guid;
> > (mapi:monetdb://monetdb@172.17.0.5/threatmonitor) GDK reported error.
> > ERROR: BATproject: does not match always
>
> Hai Brian,
>
> Could you please add the schema, incl. the merge/remote tables?  thanks.
>
> Jennie
>
> >
> >
> > Any pointers please ?
> >
> > Regards,
> >
> > Brian Hood
> > <monetdb_remote_tables.sql>_______________________________________________
> > users-list mailing list
> > users-list@monetdb.org
> > https://www.monetdb.org/mailman/listinfo/users-list
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list