Select from remote table leaves session open
19 Feb
2018
19 Feb
'18
1:31 p.m.
I have two databases (v11.27.13 both) on two Debian8 machines. One with corrupted table (in my case it got corrupted due to bug in Jul2017-SP1) and another with remote table to the corrupted table. When I run the SELECT query from the remote table I get an error. And the session, opened by this query to the first DB did not close. I see it by querying 'sys.sessions' table. And every time I run this SELECT I get additional record in 'sys.sessions'. This happens only if en error occurs, on successful SELECT the session immediately disappears. How can I force this sessions to close or is it a bug?
2504
Age (days ago)
2504
Last active (days ago)
0 comments
1 participants
participants (1)
-
Николай Чернов