Check connection does not work in Multisession mode which leads to freezing app. - 08/05/21 08:01 AM
Hello,
there were several posts about this issue but it still has not been fixed.
https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showthreaded&Number=62119
https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=59581
https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showthreaded&Number=62490
Sessions are not "checked" (refreshed) as it should be. This finally causes freezing of PLSQL Developer.
There is step-by-step process how to reproduce this bug:
Settings:
Session mode: Multi session
Check connection (checked)
Check all sessions (checked)
Multiple connection:
Allow multiple connection (checked)
Automatically close unused connection (checked)
Steps to reporduce:
Start PLSQL Developer
Connect to some other connection as main connection, just for having some main connection other than "real destination" database we want to work with.
Lets have sqlplus simultaneously running, connected to real "destination" database
Check sessions in destination database using sqlplus:
select s.sid, s.serial#, s.command, s.status, s.program , s.action, s.module, s.client_info, s.sql_hash_value, s.sql_id,
s.logon_time, last_call_et, event,sql.sql_text, s.machine
from v$session s
left join v$sql sql on s.sql_hash_value = sql.hash_value
where program='plsqldev.exe'
and machine = 'mymachine'
No rows returned (that is ok, there's no plsqldev session)
Now open new blank sql window in PL/SQL Developer, connect just this window to our destination database.
Don't run any sql at this window.
Check sessions in destination database using sqlplus:
SID LAST_CALL_ET ACTION SERIAL# COMMAND STATUS PROGRAM MODULE CLIENT_INFO SQL_HASH_VALUE SQL_ID LOGON_TI EVENT SQL_TEXT MACHINE
---------- ------------ ---------------------------------------------------------------- ---------- ---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- -------------- ------------- -------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
1159 10 Primary Session 51936 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client mymachine
There's now one session.
Wait more than one minute.
Check sessions again:
SID LAST_CALL_ET ACTION SERIAL# COMMAND STATUS PROGRAM MODULE CLIENT_INFO SQL_HASH_VALUE SQL_ID LOGON_TI EVENT SQL_TEXT MACHINE
---------- ------------ ---------------------------------------------------------------- ---------- ---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- -------------- ------------- -------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
175 98 Primary Session 39053 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client mymachine
Focus on last_call_et: 98 sec.
This means session has not been refreshed.
Now let's go back to PL/SQL Developer and run (any) query in our (still blank) SQL Window, eg:
SELECT SYSDATE FROM DUAL;
Check sessions again:
SID LAST_CALL_ET ACTION SERIAL# COMMAND STATUS PROGRAM MODULE CLIENT_INFO SQL_HASH_VALUE SQL_ID LOGON_TI EVENT SQL_TEXT MACHINE
---------- ------------ ---------------------------------------------------------------- ---------- ---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- -------------- ------------- -------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
175 17 Primary Session 39053 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client USYS.CZ\DAVID-P50
339 17 SQL Window 46182 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client mymachine
There're two sessions now.
Focus on last_call_et: it's now 17sec for both sessions. So, both sessions has been refreshed, ok.
Wait more than minute.
Check sessions again:
SID LAST_CALL_ET ACTION SERIAL# COMMAND STATUS PROGRAM MODULE CLIENT_INFO SQL_HASH_VALUE SQL_ID LOGON_TI EVENT SQL_TEXT MACHINE
---------- ------------ ---------------------------------------------------------------- ---------- ---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- -------------- ------------- -------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
175 104 Primary Session 39053 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client USYS.CZ\DAVID-P50
339 14 SQL Window 46182 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client mymachine
As you can see, just only "SQL Window" session with SID=339 has been "refreshed", not the "Primary Session".
Last_ET_Call of "Primary session" is increasing continuously, it shows that "Check connection (checked)" nor
"Check all sessions (checked)" dont' affect this session.
This behavior has consequences.
After some while, this session is time-outed, and when user wants to use PL/SQL Developer again, application freezes for a while(30sec), trying to use this connection.
Best regard,
D.
there were several posts about this issue but it still has not been fixed.
https:/
https:/
https:/
Sessions are not "checked" (refreshed) as it should be. This finally causes freezing of PLSQL Developer.
There is step-by-step process how to reproduce this bug:
Settings:
Session mode: Multi session
Check connection (checked)
Check all sessions (checked)
Multiple connection:
Allow multiple connection (checked)
Automatically close unused connection (checked)
Steps to reporduce:
Start PLSQL Developer
Connect to some other connection as main connection, just for having some main connection other than "real destination" database we want to work with.
Lets have sqlplus simultaneously running, connected to real "destination" database
Check sessions in destination database using sqlplus:
select s.sid, s.serial#, s.command, s.status, s.program , s.action, s.module, s.client_info, s.sql_hash_value, s.sql_id,
s.logon_time, last_call_et, event,sql.sql_text, s.machine
from v$session s
left join v$sql sql on s.sql_hash_value = sql.hash_value
where program='plsqldev.exe'
and machine = 'mymachine'
No rows returned (that is ok, there's no plsqldev session)
Now open new blank sql window in PL/SQL Developer, connect just this window to our destination database.
Don't run any sql at this window.
Check sessions in destination database using sqlplus:
SID LAST_CALL_ET ACTION SERIAL# COMMAND STATUS PROGRAM MODULE CLIENT_INFO SQL_HASH_VALUE SQL_ID LOGON_TI EVENT SQL_TEXT MACHINE
---------- ------------ ---------------------------------------------------------------- ---------- ---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- -------------- ------------- -------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
1159 10 Primary Session 51936 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client mymachine
There's now one session.
Wait more than one minute.
Check sessions again:
SID LAST_CALL_ET ACTION SERIAL# COMMAND STATUS PROGRAM MODULE CLIENT_INFO SQL_HASH_VALUE SQL_ID LOGON_TI EVENT SQL_TEXT MACHINE
---------- ------------ ---------------------------------------------------------------- ---------- ---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- -------------- ------------- -------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
175 98 Primary Session 39053 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client mymachine
Focus on last_call_et: 98 sec.
This means session has not been refreshed.
Now let's go back to PL/SQL Developer and run (any) query in our (still blank) SQL Window, eg:
SELECT SYSDATE FROM DUAL;
Check sessions again:
SID LAST_CALL_ET ACTION SERIAL# COMMAND STATUS PROGRAM MODULE CLIENT_INFO SQL_HASH_VALUE SQL_ID LOGON_TI EVENT SQL_TEXT MACHINE
---------- ------------ ---------------------------------------------------------------- ---------- ---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- -------------- ------------- -------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
175 17 Primary Session 39053 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client USYS.CZ\DAVID-P50
339 17 SQL Window 46182 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client mymachine
There're two sessions now.
Focus on last_call_et: it's now 17sec for both sessions. So, both sessions has been refreshed, ok.
Wait more than minute.
Check sessions again:
SID LAST_CALL_ET ACTION SERIAL# COMMAND STATUS PROGRAM MODULE CLIENT_INFO SQL_HASH_VALUE SQL_ID LOGON_TI EVENT SQL_TEXT MACHINE
---------- ------------ ---------------------------------------------------------------- ---------- ---------- -------- ------------------------------------------------ ---------------------------------------------------------------- ---------------------------------------------------------------- -------------- ------------- -------- ---------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
175 104 Primary Session 39053 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client USYS.CZ\DAVID-P50
339 14 SQL Window 46182 0 INACTIVE plsqldev.exe PL/SQL Developer 0 05.08.21 SQL*Net message from client mymachine
As you can see, just only "SQL Window" session with SID=339 has been "refreshed", not the "Primary Session".
Last_ET_Call of "Primary session" is increasing continuously, it shows that "Check connection (checked)" nor
"Check all sessions (checked)" dont' affect this session.
This behavior has consequences.
After some while, this session is time-outed, and when user wants to use PL/SQL Developer again, application freezes for a while(30sec), trying to use this connection.
Best regard,
D.