Print Thread
[13.0.4][64 bits] System Error. Code: 1158 Current process uses all handles
#59983 05/02/19 03:27 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
I get this error when opening a larger project. I tried giving PL/SQL Developer (PSD) all available system resources, switched the preferences to single session as well, but still after a long time having the project loading I end up getting this error.

How can I open the project without getting such an error?
Why can


Regards,
Berny
Re: [13.0.4][64 bits] System Error. Code: 1158 Current process uses all handles
Bernhard S #59985 05/03/19 08:38 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
If you have many windows open for a large project, this may be consuming too many resources. Perhaps you can close some windows that you are not working on at the time? The corresponding items will of course remain part of the project, regardless whether they have a window open or not.

If you remove (or rename) the <project>.dsk file you should be able to open the project again. None of the project items will then have a window open.


Marco Kalter
Allround Automations
Re: [13.0.4][64 bits] System Error. Code: 1158 Current process uses all handles
Marco Kalter #59991 05/06/19 01:23 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
The project shouldn't be consuming too many resources now when opening this project when it was once created with PL/SQL Developer like that successfully.
If PL/SQL Developer reaches windows resource limits it should handle those more properly and stop opening further windows as soon as it's risking running into such an error.
Just closing windows in this state is no longer possible! All I can do is close the whole project then.

Sure I can rename the dsk file and start with an empty window list that way. Then however I need to open windows from scratch again which is not the idea of a project. Also I won't know when I approach a limit which eventually will hit me with the same error again.
An application should just not work like this and leave its users to deal themselves with the problems it causes.


Regards,
Berny
Re: [13.0.4][64 bits] System Error. Code: 1158 Current process uses all handles
Bernhard S #59992 05/06/19 03:06 PM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
The project does not consume any resources by itself. Opening more than 100 windows will consume a lot of resources though, regardless whether they are opened in the context of a project, the file browser, the database or any other context that you use to organize your work.


Marco Kalter
Allround Automations
Re: [13.0.4][64 bits] System Error. Code: 1158 Current process uses all handles
Marco Kalter #60002 05/09/19 08:16 AM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
PL/SQL Developer should limit the use of resources itself and stop opening further project windows when it cannot handle those anymore. Opening those anyway and then running into problems makes no sense!
It should be possible to open the same project also when there are less system resources available.
It should not be left to the user but instead be handled by the application to deal with the available resources wisely and still keep the application working acceptably.


Regards,
Berny
Re: [13.0.4][64 bits] System Error. Code: 1158 Current process uses all handles
Bernhard S #60004 05/09/19 09:18 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
We'll consider an option to limit the number of simultaneously opened windows. Perhaps we can implicitly close the oldest (least recently used) window that does not have any modifications.

I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations
Re: [13.0.4][64 bits] System Error. Code: 1158 Current process uses all handles
Marco Kalter #60005 05/09/19 10:26 AM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
Thank you.
Maybe another option would also be to not create DB-connections for windows exceeding resource limits.
Whenever such a window gets activated by the user then, it could automatically or manually reconnect, depending on preferences.

I guess a large part of resources is needed just for DB-connections, but those are not always necessary. Often you just need to look things up in other files and PL/SQL Developer is rather used like just an editor then.


Regards,
Berny

Moderated by  support 

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.034s Queries: 14 (0.011s) Memory: 2.5259 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-11 17:33:07 UTC
Valid HTML 5 and Valid CSS