A client's database went down earlier and now we can't start it. The DB log file is useless, but the admin server logfile is:
[08/09/16 14:39:19] [1] [Database] Starting configuration: l_idx41_pws.defaultconfiguration. User: admin (Fathom)/CMLSQL01$ (system) (7397)
[08/09/16 14:39:20] [2] [Database] Starting process (primary) for configuration: l_idx41_pws.defaultconfiguration (8470)
[08/09/16 14:39:20] [2] [Database] Command = [C:\Progress\OpenEdge\bin\_mprosrv, -classpath, "C:\Progress\OpenEdge/java/ext/jmxri.jar;C:\Progress\OpenEdge/java/ext/mgmt_agent.jar;C:\Progress\OpenEdge/java/ext/mgmt_client.jar;C:\Progress\OpenEdge/java/ext/mgmt_config.jar;C:\Progress\OpenEdge/java/ext/sonic_Client.jar;C:\Progress\OpenEdge/java/progress.jar;C:\Progress\OpenEdge/java/osmetrics.jar;C:\Progress\OpenEdge/java/jdbc.jar;C:\Progress\OpenEdge/java/base.jar;C:\Progress\OpenEdge/java/openedge.jar;C:\Progress\OpenEdge/java/util.jar;C:\Progress\OpenEdge/java/ext/soap.jar;C:\Progress\OpenEdge/java/prorepl.jar;C:\Progress\OpenEdge/java/ext/wsdl4j.jar", -properties, "C:\Progress\OpenEdge\properties\conmgr.properties", -servergroup, l_idx41_pws.defaultconfiguration.defaultservergroup, -adminport, 7842, -pica, 256, -m5] (7402)
[08/09/16 14:39:20] [2] [Database] Config l_idx41_pws.defaultconfiguration - Message from l_idx41_pws.defaultconfiguration.defaultservergroup (primary): [14:39:20 BROKER The startup of this database requires 4072Mb of shared memory. Maximum segment size is 4096Mb.] (ADMMsg057)
[08/09/16 14:39:20] [0] [Database] * Config l_idx41_pws.defaultconfiguration - Error from l_idx41_pws.defaultconfiguration.defaultservergroup (primary): [14:39:20 BROKER Unable to create shared memory Global\sharemem.d.index.databases.live.pws.0, error 0. (1719)] (ADMMsg005)
[08/09/16 14:39:20] [2] [Database] Config l_idx41_pws.defaultconfiguration - Message from l_idx41_pws.defaultconfiguration.defaultservergroup (primary): [14:39:20 BROKER The creation and attachment to shared memory segment 0 of size 4072Mb failed.] (ADMMsg057)
[08/09/16 14:39:20] [0] [Database] * Config l_idx41_pws.defaultconfiguration - Error from l_idx41_pws.defaultconfiguration.defaultservergroup (primary): [14:39:20 BROKER ** This process terminated with exit code 1. (8619)] (ADMMsg005)
Any ideas? Not sure what's changed really.
Windows server 2008 R2.
Progress 10.2B07
Probably cause is too large a -B
Is this a 32-bit executable? Then max shared memory (~ 1700 MB) is less than half of what is being requested (4072 MB)
Is it a fairly large -B ? If yes, set the maximum shared memory size -shmsegsize to something smaller like 256 MB.
My understanding is that Progress tries to allocate one big continuous shared memory segment and won't start if it can't.
Ah yes - 4 GB of shared mem. Thanks Gus!
Thanks chaps. The database had run out of space in a storage area hence the crash. No idea who set the -B to 500k though. Max I could get running is 150k.
Might try to restart the windows server and see if after the restart there is more contiguous memory available.