S
Stefan Marquardt
Guest
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 [2014/03/12@08:46:52.362+0100] P-4192 T-4292 I BROKER 0: (-----) Suspension queue poll priority (-prefetchPriority): 0 [2014/03/12@08:46:52.363+0100] P-4192 T-4292 I BROKER 0: (4260) Maximum Number of Users (-n): 21. [2014/03/12@08:46:52.363+0100] P-4192 T-4292 I BROKER 0: (4261) Host Name (-H): Not Enabled. [2014/03/12@08:46:52.364+0100] P-4192 T-4292 I BROKER 0: (4262) Service Name (-S): Not Enabled. [2014/03/12@08:46:52.364+0100] P-4192 T-4292 I BROKER 0: (4263) Network Type (-N): Not Enabled. [2014/03/12@08:46:52.406+0100] P-4192 T-4292 I BROKER 0: (4264) Character Set (-cpinternal): ISO8859-1. [2014/03/12@08:46:52.406+0100] P-4192 T-4292 I BROKER 0: (4282) Parameter File: Not Enabled. [2014/03/12@08:46:52.407+0100] P-4192 T-4292 I BROKER 0: (9426) Large database file access has been enabled. [2014/03/12@08:46:52.407+0100] P-4192 T-4292 I BROKER 0: (9336) Created shared memory with segment_id: 39190528 [2014/03/12@08:46:52.407+0100] P-4192 T-4292 I BROKER 0: (12813) Allowed index cursors (-c): 84. [2014/03/12@08:46:52.408+0100] P-4192 T-4292 I BROKER 0: (12814) Group delay (-groupdelay): 10. [2014/03/12@08:46:52.408+0100] P-4192 T-4292 I BROKER 0: (12815) Lock table hash table size (-lkhash): 1237 [2014/03/12@08:46:52.408+0100] P-4192 T-4292 I BROKER 0: (12818) Message Buffer Size (-Mm): 1024 [2014/03/12@08:46:52.408+0100] P-4192 T-4292 I BROKER 0: (12821) Use muxlatches (-mux): 1 [2014/03/12@08:46:52.409+0100] P-4192 T-4292 I BROKER 0: (12823) Semaphore Sets (-semsets): 3 [2014/03/12@08:46:52.409+0100] P-4192 T-4292 I BROKER 0: (13870) Database Service Manager - IPC Queue Size (-pica) : 64.0 KBytes. [2014/03/12@08:46:52.409+0100] P-4192 T-4292 I BROKER 0: (13896) TXE Commit lock skip limit (-TXESkipLimit): 10000. [2014/03/12@08:46:52.410+0100] P-4192 T-4292 I BROKER 0: (15219) Encryption enabled: 0 [2014/03/12@08:46:52.410+0100] P-4192 T-4292 I BROKER 0: (15218) Encryption cache size (-ecsize): 1000 Then database log finished, at least this [2014/03/12@11:44:58.576+0100] P-12728 T-12564 I BROKER 0: (10471) Database connections have been enabled. is missing. If i try proshut on this "nearly started" db it hungs, mpro hangs too, like the appserver which tries to connect the database through shared memory. Any suggestions?
Continue reading...
Continue reading...