R
Richard Banville
Guest
This sounds very similar to a bug that is being worked on in development as we speak. In that situation, there is a remote server that was spawned by the broker prior to completion of database initialization that resulted in a dead lock situation (an OpenEdge bug). Identifying and killing the hung remote server allowed the broker to complete the startup processing. This might work in your situation as well. _________________________________ Richard Banville Fellow, OpenEdge Development PROGRESS SOFTWARE CORPORATION 14 Oak Park | Bedford, MA 01730 | USA DIRECT +1 781 280 4875 richb@progress.com From: Stefan Marquardt [mailto:bounce-Marquardt@community.progress.com] Sent: Wednesday, March 12, 2014 8:38 AM To: TU.OE.RDBMS@community.progress.com Subject: 10.2B08 Windows 2008R2: Database not started complete and appserver (every process) hungs which tries to connect this databases 10.2B08 Windows 2008R2: Database not started complete and appserver (every process) hungs which tries to connect this databases Thread created by Stefan Marquardt Hello, databases are started by _mprosrv. If they are started by script at boot (adminserver - appserver - starts db and other appserver) _mprosrv and _proapsv are visible but somes db's never accepts connections. Wed Mar 12 08:46:49 2014 [2014/03/12@08:46:49.466+0100] P-4192 T-4292 I BROKER 0: (333) Multi-user session begin. [2014/03/12@08:46:49.901+0100] P-4192 T-4292 I BROKER 0: (5326) Begin Physical Redo Phase at 0 . [2014/03/12@08:46:52.307+0100] P-4192 T-4292 I BROKER 0: (7161) Physical Redo Phase Completed at blk 119 off 3366 upd 388. [2014/03/12@08:46:52.308+0100] P-4192 T-4292 I BROKER 0: (13547) At end of Physical redo, transaction table size is 128. [2014/03/12@08:46:52.325+0100] P-4192 T-4292 I BROKER 0: (452) Login by winsure on batch. [2014/03/12@08:46:52.326+0100] P-4192 T-4292 I BROKER 0: (4234) Progress OpenEdge Release 10.2B build 1907 SP08 on WINNT . [2014/03/12@08:46:52.327+0100] P-4192 T-4292 I BROKER 0: (4281) Server started by winsure on batch. [2014/03/12@08:46:52.328+0100] P-4192 T-4292 I BROKER 0: (-----) Started using pid: 4192. [2014/03/12@08:46:52.329+0100] P-4192 T-4292 I BROKER 0: (4235) Physical Database Name (-db): C:\ProgramData\Progress\eNora\winsureuk\winprint\db\2014\wp2014. [2014/03/12@08:46:52.331+0100] P-4192 T-4292 I BROKER 0: (4236) Database Type (-dt): PROGRESS. [2014/03/12@08:46:52.332+0100] P-4192 T-4292 I BROKER 0: (4237) Force Access (-F): Not Enabled. [2014/03/12@08:46:52.332+0100] P-4192 T-4292 I BROKER 0: (4238) Direct I/O (-directio): Not Enabled. [2014/03/12@08:46:52.334+0100] P-4192 T-4292 I BROKER 0: (-----) LRU mechanism enabled. [2014/03/12@08:46:52.335+0100] P-4192 T-4292 I BROKER 0: (-----) Number of LRU force skips (-lruskips): 0 [2014/03/12@08:46:52.336+0100] P-4192 T-4292 I BROKER 0: (-----) Number of LRU2 force skips (-lru2skips): 0 [2014/03/12@08:46:52.336+0100] P-4192 T-4292 I BROKER 0: (4239) Number of Database Buffers (-B): 3000. [2014/03/12@08:46:52.337+0100] P-4192 T-4292 I BROKER 0: (-----) Number of Alternate Database Buffers (-B2): 0. [2014/03/12@08:46:52.338+0100] P-4192 T-4292 I BROKER 0: (9422) Maximum private buffers per user (-Bpmax): 64. [2014/03/12@08:46:52.339+0100] P-4192 T-4292 I BROKER 0: (4240) Excess Shared Memory Size (-Mxs): 23. [2014/03/12@08:46:52.340+0100] P-4192 T-4292 I BROKER 0: (10014) The shared memory segment is not locked in memory. [2014/03/12@08:46:52.340+0100] P-4192 T-4292 I BROKER 0: (4241) Current Size of Lock Table (-L): 8192. [2014/03/12@08:46:52.341+0100] P-4192 T-4292 I BROKER 0: (13953) Maximum Area Number (-maxArea): 32000. [2014/03/12@08:46:52.341+0100] P-4192 T-4292 I BROKER 0: (4242) Hash Table Entries (-hash): 887. [2014/03/12@08:46:52.342+0100] P-4192 T-4292 I BROKER 0: (4243) Current Spin Lock Tries (-spin): 24000. [2014/03/12@08:46:52.342+0100] P-4192 T-4292 I BROKER 0: (6526) Number of Semaphore Sets (-semsets): 3. [2014/03/12@08:46:52.343+0100] P-4192 T-4292 I BROKER 0: (13924) Maximum Shared Memory Segment Size (-shmsegsize) 128 Mb. [2014/03/12@08:46:52.343+0100] P-4192 T-4292 I BROKER 0: (4244) Crash Recovery (-i): Enabled. [2014/03/12@08:46:52.344+0100] P-4192 T-4292 I BROKER 0: (6573) Database Blocksize (-blocksize): 8192. [2014/03/12@08:46:52.344+0100] P-4192 T-4292 I BROKER 0: (4245) Delay of Before-Image Flush (-Mf): 3. [2014/03/12@08:46:52.345+0100] P-4192 T-4292 I BROKER 0: (4247) Before-Image File I/O (-r -R): Reliable. [2014/03/12@08:46:52.349+0100] P-4192 T-4292 I BROKER 0: (4249) Before-Image Truncate Interval (-G): 0. [2014/03/12@08:46:52.350+0100] P-4192 T-4292 I BROKER 0: (4250) Before-Image Cluster Size: 524288. [2014/03/12@08:46:52.350+0100] P-4192 T-4292 I BROKER 0: (4251) Before-Image Block Size: 8192. [2014/03/12@08:46:52.351+0100] P-4192 T-4292 I BROKER 0: (4252) Number of Before-Image Buffers (-bibufs): 20. [2014/03/12@08:46:52.351+0100] P-4192 T-4292 I BROKER 0: (-----) Record free chain search depth factor 5 (-recspacesearchdepth) [2014/03/12@08:46:52.352+0100] P-4192 T-4292 I BROKER 0: (9238) BI File Threshold size (-bithold): 0.0 Bytes. [2014/03/12@08:46:52.353+0100] P-4192 T-4292 I BROKER 0: (6552) BI File Threshold Stall (-bistall): Disabled. [2014/03/12@08:46:52.354+0100] P-4192 T-4292 I BROKER 0: (4254) After-Image Stall (-aistall): Not Enabled. [2014/03/12@08:46:52.354+0100] P-4192 T-4292 I BROKER 0: (4255) After-Image Block Size: 8192. [2014/03/12@08:46:52.355+0100] P-4192 T-4292 I BROKER 0: (4256) Number of After-Image Buffers (-aibufs): 20. [2014/03/12@08:46:52.356+0100] P-4192 T-4292 I BROKER 0: (8527) Storage object cache size (-omsize): 1024 [2014/03/12@08:46:52.356+0100] P-4192 T-4292 I BROKER 0: (4257) Maximum Number of Clients Per Server (-Ma): 5. [2014/03/12@08:46:52.357+0100] P-4192 T-4292 I BROKER 0: (4258) Maximum Number of Servers (-Mn): 5. [2014/03/12@08:46:52.359+0100] P-4192 T-4292 I BROKER 0: (4259) Minimum Clients Per Server (-Mi): 1. [2014/03/12@08:46:52.360+0100] P-4192 T-4292 I BROKER 0: (-----) Server network message wait time (-Nmsgwait): 2 [2014/03/12@08:46:52.360+0100] P-4192 T-4292 I BROKER 0: (-----) Use pollset mechanism for client/server (-pollset): Disabled [2014/03/12@08:46:52.361+0100] P-4192 T-4292 I BROKER 0: (-----) Delay first prefetch message (-prefetchDelay): Disabled [2014/03/12@08:46:52.361+0100] P-4192 T-4292 I BROKER 0: (-----) Prefetch message fill percentage (-prefetchFactor): 0 [2014/03/12@08:46:52.362+0100] P-4192 T-4292 I BROKER 0: (-----) Minimum records in prefetch ms (-prefetchNumRecs): 16
Continue reading...
Continue reading...