Salesforce

When a PROMON -F session is disconnected the database sometimes becomes connectionless and won't shutdown

« Go Back

Information

 
TitleWhen a PROMON -F session is disconnected the database sometimes becomes connectionless and won't shutdown
URL NameWhen-a-PROMON-F-disconnects-the-database-becomes-connectionless-and-fails-shutdown
Article Number000202064
EnvironmentProduct: OpenEdge
Version: 11.7.6 to 11.7.9, 12.2.1 to 12.2.4, 12.3
OS: All supported platforms
Question/Problem Description
When a PROMON -F session is disconnected the database sometimes becomes connectionless and won't shutdown
Intermittent connection-less database that fails to shutdown after a PROMON -F session logs out
Any new connection hangs including a new promon -F and utilities (proutil, dbtool), then subsequently does not shut down

At this time, the database is currently running without error and data is being read and written to the database
Even though new users cannot connect the database it is still processing transactions

To recover, all processes have to be killed off and eventually the database broker itself.  

promon option latch counts shows the latch owner, if a user is holding a usr latch.
promon dbname -NL -F 
R&D > debghb > 11. Latch counts
Steps to Reproduce
Clarifying Information
Error Message
Defect NumberOCTA-33192
Enhancement Number
Cause
PROMON -F means not taking out USR latch so that in case of other hangs promon is able to login and dump diagnostic data. 
PROMON -F skips the USR latch during login but acquires a USR latch during logout which it should not:
  •  If the USR latch is being held by any other client at the same time, promon -F will appear hung.
  •  If the USR latch is not being held by any other client at the same time, any new connections cannot acquire the USR latch in order to gain database access, including PROSHUT to issue a shutdown.
Resolution
Fixed version(s): OpenEdge 12.4, OpenEdge 11.7.10, OpenEdge 12.2.5
Workaround
Notes
Keyword Phrase
Last Modified Date10/23/2023 12:08 PM

Powered by