View Issue Details

IDProjectCategoryView StatusLast Update
0008158VALENTINA STUDIOOtherpublic2018-02-20 10:09
ReporterCarlos FuentesAssigned ToSergey Pashkov 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version7.5.x 
Target Version8.0.xFixed in Version8.0.x 
Summary0008158: Unable to create an additional connection to DB
DescriptionI have a long running query that is inserting many records and I am wanting to run another query in a separate connection to the same DB to check on the progress (how many records have been inserted so far etc). While that query is running, however, any query I run will just wait for the first one to finish.
I tried opening another window thinking at if I opened my bookmark to the DB in the other window it would be a separate connection but it seems to be the same and when I clicked on a table in the schema browser both windows locked up and did not return till the query finished.
Is there no way to run a second connection from the same bookmark so that you can monitor the progress of long running queries?
TagsNo tags attached.
Working with DB:postgreSQL Server
Version of your DBlatest

Activities

Sergey Pashkov

Sergey Pashkov

2018-01-09 17:40

developer   ~0010015

Hello Carlos,

No, currently, bookmark doesn't allow to open the second connection, only manually via connect dialog.

I think we can implement it for the context menu item - "Open Connection" (it clearly states that the connection will be opened).
Carlos Fuentes

Carlos Fuentes

2018-01-09 19:23

reporter   ~0010016

That would be great! Any idea why clicking on a table in the second window locked up the app? (I got the spinning beach ball on the Mac)
Sergey Pashkov

Sergey Pashkov

2018-01-09 19:28

developer   ~0010017

During executing a query in the first window? Yes, the same problem - the connection is locked by the SQL Editor.
Sergey Pashkov

Sergey Pashkov

2018-02-20 10:09

developer   ~0010066

Fix will be available in the version 8.0.1.

A new connection is opened from the context menu of the bookmark.

Also, it was possible to set an option "Open in separate connection" for the bookmark earlier, but it opens a new connection each time the bookmark clicked.

Issue History

Date Modified Username Field Change
2018-01-09 17:24 Carlos Fuentes New Issue
2018-01-09 17:40 Sergey Pashkov Note Added: 0010015
2018-01-09 19:23 Carlos Fuentes Note Added: 0010016
2018-01-09 19:28 Sergey Pashkov Note Added: 0010017
2018-02-20 10:06 Sergey Pashkov Product Version => 7.5.x
2018-02-20 10:06 Sergey Pashkov Target Version => 8.0.x
2018-02-20 10:09 Sergey Pashkov Note Added: 0010066
2018-02-20 10:09 Sergey Pashkov Status new => resolved
2018-02-20 10:09 Sergey Pashkov Fixed in Version => 8.0.x
2018-02-20 10:09 Sergey Pashkov Resolution open => fixed
2018-02-20 10:09 Sergey Pashkov Assigned To => Sergey Pashkov