Salesforce

Getting errors (748) and (1154) due to -Mpb set too low

« Go Back

Information

 
TitleGetting errors (748) and (1154) due to -Mpb set too low
URL NameP34368
Article Number000171928
EnvironmentProduct: OpenEdge
Version 10.x, 11.x
Product: Progress
Version: 9.x
OS: All supported platforms
Question/Problem Description
Cannot connect anymore remote client sessions to the database error 748
Error 1154 in the database log file coincides with the client error 748

All current client connections are frozen
no Progress commands (promon/proshut etc) can be run against the database
-Mn is sufficient for the product of -n and -Ma database startup parameters
Steps to Reproduce
Clarifying Information
Error MessageThe server or the system has no more resources. Please contact Progress Technical Support. (748)
No servers are available. Try again later. (1154)
Defect Number
Enhancement Number
Cause
-Mpb was set too low, thus the number of servers defined by -Mn could not be reached.
Resolution
Increase the value of -Mpb.

Example

proserve dbname -n 350 -Mn 70 -Ma 5 -Mpb 24 -S ABLService -ServerType ABL
proserve dbname -m3 -Ma 5 -Mpb 5 -S SQLService -ServerType SQL
  • 120 ABL connections are allowed to ABLService. The maximum number of remote servers (-Mpb) limits the maximum number of ABL servers.
  • 25 SQL connections are allowed to SQLService. The maximum number of remote servers (-Mpb) limits the maximum number of SQL servers.
  • 350 maximum concurrent connections (-n) to the database of any connection type are configured (including all shared-memory connections in addition to client/server connections)
  • 70 remote servers (-Mn) in total are configured to start in the minport maxport range, these are currently split between the ABL and SQL login broker with the -Mpb parameter +1 for each secondary login broker (-m3 parameter). Should another secondary login broker need to be started, there are 40 remaining remote server slots available in this example.
For further information refer to Article  How to set the values for the startup parameters -Ma, -Mn and -n  
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:34 AM

Powered by