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

On Nov 25, 2015, at 22:56, Brian Hood <brianh6854@googlemail.com> wrote:

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.

Hai Brian, Bug report would be great! I’d try to reproduce your error myself if I could, but several urgent things have popped up… Regards, Jennie

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 _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list