Problem gone after VM restart. Sorry.

I will submit the MonetDB profile for DBVisualizer soon.

Gesendet: Mittwoch, 22. April 2015 um 21:18 Uhr
Von: "Robert Koch" <gms_xy@gmx.de>
An: users-list@monetdb.org
Betreff: Aw: Re: Exactly 10 Seconds Delay during JDBC connect to MonetDB

Any idea on this issue? Btw, I am currently building a MonetDB profile for DBVisualizer, in order to have support for many features of MonetDB. After each change I have to do a reconnect. Waiting 10 seconds each time is horrible.

Thanks

Gesendet: Dienstag, 21. April 2015 um 11:26 Uhr
Von: "shamsul hassan" <shamsulbuddy@gmail.com>
An: "Communication channel for MonetDB users" <users-list@monetdb.org>
Betreff: Re: Exactly 10 Seconds Delay during JDBC connect to MonetDB

I do have seen this problem on JDBC, with mclient same query takes 10 secs less. I am not sure why it is happening as from SQL Workbench teh connection should be persistent and it should not connect again on every query.

Does anybody have similar experiences with ODBC & PHP ?? Just wondering how it behaves in that case.

Thank you.

On Tue, Apr 21, 2015 at 9:01 AM, Robert Koch <gms_xy@gmx.de> wrote:

Hi all,

I'm using DBVisualizer to connect via JDBC to MonetDB. There is a delay of very exactly 10 seconds during the connection process. This only happens via JDBC. There are no DNS issues, since the connection is done via IP directly. Connection from the commandline of the server with mclient works perfectly. First step to get closer was to inspect the output of tcpdump. It seems to be on the side of MonetDB, since the last packet is the one sent to MonetDB (192.168.56.102) from my Windows Client (192.168.56.1).

09:33:24.663824 IP 192.168.56.1.57271 > 192.168.56.102.50000: Flags [.], ack 1, win 256, length 0
--- 10 soconds
09:33:34.676884 IP 192.168.56.102.50000 > 192.168.56.1.57271: Flags [P.], seq 1:3, ack 1, win 229, length 2

Additionally, DBVis ist connecting speedy with other databases (PostgreSQL) on the same server.

Using following version:
MonetDB
11.19.9
MonetDB Native Driver
2.14 (Liberica 20150123 based on MCL v1.11)

I did not experience this problem in former versions of MonetDB.

Any idea?

Thank you.
_______________________________________________
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