Skip to main content

Vertica 7.1.2 Client driver create multiple sessions

  • March 10, 2017
  • 2 replies
  • 16 views

abhi112
Forum|alt.badge.img+1

Hello,

We are using TOAD Data Point to get connected to Vertica.
But we have seen change in the number of sessions getting opened for different version of vertica drivers.

For version, 4.x, number of sessions are expected.
For version 7.1.2 , number of sessions getting opened for a query are multiple.
We dig deeper and found that if we enable the Autocommit option, number of sessions are as expected but if Autocommit is disable, sessions are multiple for a query.

We have tried this with different versions of Toad Data point as well (2.6 and 3.1) .

We want to know if this is bug with TOAD or vertica client driver and why the Autocommit is affecting this when using vertica driver 7.1.2?

Thanks!

2 replies

abhi112
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • March 13, 2017

can someone help here ? Thanks!


ckotsidimos
Forum|alt.badge.img+1
  • Participating Frequently
  • March 13, 2017

Have you tried for example dbeaver?
or another system?