Print Thread
Execute query "running" but not in database
#63076 02/04/22 09:04 AM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
koja Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
I've now had this issue a couple of times. I execute a rather simple query and PL/sql developer seems to execute this and the execution timer walks, but on the database nothing seems to happen. There is a session on the database, which is not active. When I kill this session or press abort query the timer just keeps walking.

The only way to stop this is by force close PL/SQL Developer.


Certainty of death, small chance of succes,
What are we waiting for... (Gimly)
Re: Execute query "running" but not in database
koja #63087 02/04/22 10:19 AM
Joined: Aug 1999
Posts: 22,204
Member
Offline
Member
Joined: Aug 1999
Posts: 22,204
To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 15 Beta\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 15).


Marco Kalter
Allround Automations
Re: Execute query "running" but not in database
koja #63125 02/07/22 08:43 AM
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
koja Offline OP
Member
OP Offline
Member
Joined: Mar 2007
Posts: 110
Hazerswoude-Dorp, NL
I have sent the requested debug information.


Certainty of death, small chance of succes,
What are we waiting for... (Gimly)

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.168s Queries: 15 (0.066s) Memory: 2.5008 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-26 04:06:54 UTC
Valid HTML 5 and Valid CSS