HELP: database crashes with increased frequency on semaphore error - Forum - OpenEdge RDBMS - Progress Community

HELP: database crashes with increased frequency on semaphore error

 Forum

HELP: database crashes with increased frequency on semaphore error

  • This is about Tech support case 00354702.

    We had a first crash last Thurday. at this moment we're down for the 4rd or 5th time today.

    This is the same system mentioned in https://community.progress.com/community_groups/openedge_rdbms/f/18/t/26051

    Following progress tech support we already increased the maximum open file to 65536

    I decreased -Mm backup to it's default of 1024

    We had 2 databases running, stopped one of the databases

    increased kernel.sem from 560        32000   200     2048 to

    kernel.sem = 560        32000   200     4096

    none of these steps helped

    [root@franky-db applprod]# cat /etc/redhat-release
    CentOS Linux release 7.2.1511 (Core)
    [root@franky-db applprod]# cat $DLC/version
    OpenEdge Release 11.6.1 as of Fri Feb 19 18:20:45 EST 2016

    [2016/07/20@19:33:03.387+0200] P-28172      T-140407840053056 I SRV     5: (7129)  Usr 187 set name to magfr.
    [2016/07/20@19:46:25.516+0200] P-18869      T-140677741020992 I APPSRV 91: (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.516+0200] P-18867      T-139917784467264 I APPSRV 87: (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.516+0200] P-18869      T-140677741020992 I APPSRV 91: (10839) SYSTEM ERROR: Unable to set semaphore set : semid = 7, errno = 22.
    [2016/07/20@19:46:25.516+0200] P-18869      T-140677741020992 I APPSRV 91: (453)   Logout by apsrv_agent on batch.
    [2016/07/20@19:46:25.516+0200] P-18869      T-140677741020992 I APPSRV     (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.516+0200] P-18869      T-140677741020992 I APPSRV     (10839) SYSTEM ERROR: Unable to get value of semaphore set : semid = 5, errno = 22.
    [2016/07/20@19:46:25.516+0200] P-18869      T-140677741020992 I APPSRV     (-----) semLockLog_2: semValue val = -1
    [2016/07/20@19:46:25.516+0200] P-18867      T-139917784467264 I APPSRV 87: (10839) SYSTEM ERROR: Unable to set semaphore set : semid = 7, errno = 22.
    [2016/07/20@19:46:25.516+0200] P-18867      T-139917784467264 I APPSRV 87: (453)   Logout by apsrv_agent on batch.
    [2016/07/20@19:46:25.516+0200] P-18867      T-139917784467264 I APPSRV     (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.516+0200] P-18867      T-139917784467264 I APPSRV     (10839) SYSTEM ERROR: Unable to get value of semaphore set : semid = 5, errno = 22.
    [2016/07/20@19:46:25.516+0200] P-18867      T-139917784467264 I APPSRV     (-----) semLockLog_2: semValue val = -1
    [2016/07/20@19:46:25.517+0200] P-18879      T-139704148830016 I APPSRV 93: (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.517+0200] P-18879      T-139704148830016 I APPSRV 93: (10839) SYSTEM ERROR: Unable to set semaphore set : semid = 7, errno = 22.
    [2016/07/20@19:46:25.517+0200] P-18879      T-139704148830016 I APPSRV 93: (453)   Logout by apsrv_agent on batch.
    [2016/07/20@19:46:25.517+0200] P-18879      T-139704148830016 I APPSRV     (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.517+0200] P-18879      T-139704148830016 I APPSRV     (10839) SYSTEM ERROR: Unable to get value of semaphore set : semid = 5, errno = 22.
    [2016/07/20@19:46:25.517+0200] P-18879      T-139704148830016 I APPSRV     (-----) semLockLog_2: semValue val = -1
    [2016/07/20@19:46:25.517+0200] P-18889      T-140682824206144 I APPSRV 94: (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.518+0200] P-18889      T-140682824206144 I APPSRV 94: (10839) SYSTEM ERROR: Unable to set semaphore set : semid = -32762, errno = 22.
    [2016/07/20@19:46:25.518+0200] P-18889      T-140682824206144 I APPSRV 94: (453)   Logout by apsrv_agent on batch.
    [2016/07/20@19:46:25.518+0200] P-18889      T-140682824206144 I APPSRV     (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.518+0200] P-18889      T-140682824206144 I APPSRV     (10839) SYSTEM ERROR: Unable to get value of semaphore set : semid = 5, errno = 22.
    [2016/07/20@19:46:25.518+0200] P-18889      T-140682824206144 I APPSRV     (-----) semLockLog_2: semValue val = -1
    [2016/07/20@19:46:25.518+0200] P-18891      T-139907829344064 I APPSRV 95: (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.519+0200] P-18891      T-139907829344064 I APPSRV 95: (10839) SYSTEM ERROR: Unable to set semaphore set : semid = 7, errno = 22.
    [2016/07/20@19:46:25.519+0200] P-18891      T-139907829344064 I APPSRV 95: (453)   Logout by apsrv_agent on batch.
    [2016/07/20@19:46:25.519+0200] P-18891      T-139907829344064 I APPSRV     (1132)  Invalid semaphore id
    [2016/07/20@19:46:25.519+0200] P-18891      T-139907829344064 I APPSRV     (10839) SYSTEM ERROR: Unable to get value of semaphore set : semid = 5, errno = 22.
    [2016/07/20@19:46:25.519+0200] P-18891      T-139907829344064 I APPSRV     (-----) semLockLog_2: semValue val = -1
    [2016/07/20@19:46:28.335+0200] P-18511      T-139941315757888 I BROKER  0: (2527)  Disconnecting dead user 87.
    [2016/07/20@19:46:28.335+0200] P-18511      T-139941315757888 I BROKER  0: (1132)  Invalid semaphore id
    [2016/07/20@19:46:28.335+0200] P-18511      T-139941315757888 I BROKER  0: (10839) SYSTEM ERROR: Unable to set semaphore set : semid = 7, errno = 22.
    [2016/07/20@19:46:28.335+0200] P-18511      T-139941315757888 I BROKER  0: (1132)  Invalid semaphore id
    [2016/07/20@19:46:28.335+0200] P-18511      T-139941315757888 I BROKER  0: (10839) SYSTEM ERROR: Unable to get value of semaphore set : semid = 5, errno = 22.
    [2016/07/20@19:46:28.335+0200] P-18511      T-139941315757888 I BROKER  0: (-----) semLockLog_2: semValue val = -1
    [2016/07/20@19:46:28.335+0200] P-18511      T-139941315757888 I BROKER  0: (5292)  SYSTEM ERROR: The broker is exiting unexpectedly, beginning Abnormal Shutdown.
    [2016/07/20@19:46:28.335+0200] P-18511      T-139941315757888 I BROKER  0: (-----) drexit: Initiating Abnormal Shutdown

    [2016/07/20@19:17:06.846+0200] P-18511      T-139941315757888 I BROKER  0: (333)   Multi-user session begin.
    [2016/07/20@19:17:06.852+0200] P-18511      T-139941315757888 I BROKER  0: (5326)  Begin Physical Redo Phase at 1344 .
    [2016/07/20@19:17:07.106+0200] P-18511      T-139941315757888 I BROKER  0: (7161)  Physical Redo Phase Completed at blk 1418 off 5425 upd 1870.
    [2016/07/20@19:17:07.106+0200] P-18511      T-139941315757888 I BROKER  0: (13547) At end of Physical redo, transaction table size is 256.
    [2016/07/20@19:17:07.514+0200] P-18511      T-139941315757888 I BROKER  0: (452)   Login by proadmin on /dev/pts/2.
    [2016/07/20@19:17:07.514+0200] P-18511      T-139941315757888 I BROKER  0: (5644)  Started for 11000 using TCP IPV4 address 0.0.0.0, pid 18511.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4234)  Progress OpenEdge Release 11.6 build 1296 SP01 on Linux franky-db 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4281)  Server started by proadmin on /dev/pts/2.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (6574)  Started using pid: 18511.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (15219) Encryption enabled: 0
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (15824) Multi-tenancy enabled: 0
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (15824) Table Partitioning enabled: 0
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (-----) LRU mechanism enabled.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4282)  Parameter File: Not Enabled.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (9336)  Created shared memory with segment_id: 98306
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4250)  Before-Image Cluster Size: 524288.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4251)  Before-Image Block Size: 8192.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (13873) After-image Management Archival Directory List (-aiarcdir): Not Enabled
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (13874) Create After-image Management Archival Directory(s) (-aiarcdircreate): Not Enabled
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (13872) After-image Management Archival Interval (-aiarcinterval): -1
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4256)  Number of After-Image Buffers (-aibufs): 20
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4254)  After-Image Stall (-aistall): Not Enabled
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (17555) Starting index number for statistics range (-baseindex): 1
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (17554) Starting table number for statistics range (-basetable): 1
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4252)  Number of Before-Image Buffers (-bibufs): 20
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (6552)  BI File Threshold Stall (-bistall): Disabled.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (9238)  BI File Threshold size (-bithold): 0.0   Bytes
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (6573)  Database Blocksize (-blocksize): 8192
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (12812) BIW writer delay (-bwdelay): 0
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (12813) Allowed index cursors (-c): 452.
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (12265) SSL Certificate Store Path (-certstorepath): Not Enabled
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4264)  Character Set (-cpinternal): UTF-8
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4235)  Physical Database Name (-db): /usr2/cce/applprod/data/LISA
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4238)  Direct I/O (-directio): Not Enabled
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4236)  Database Type (-dt): PROGRESS
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (15218) Encryption cache size (-ecsize): 1000
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (12814) Group delay (-groupdelay): 10
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4242)  Hash Table Entries (-hash): 1037347
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (4244)  Crash Recovery (-i): Enabled
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (17557) Number of indexes included in statistics collection (-indexrangesize): 2500
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (14268) TCP/IP Version (-ipver): IPV4
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (12263) SSL Key Alias Name (-keyalias): Not Enabled
    [2016/07/20@19:17:08.515+0200] P-18511      T-139941315757888 I BROKER  0: (12815) Lock table hash table size (-lkhash): 25621
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17805) Original Lock Release Algorithm (-lkrela): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17560) Number of LRU force skips (-lruskips): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17561) Number of LRU2 force skips (-lru2skips): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (13953) Maximum Area Number (-maxArea): 32000
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (12540) Size of JTA transaction table (-maxxids):  100
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (5649)  Maximum Port for Auto Servers (-maxport): 12999
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (5648)  Minimum Port for Auto Servers (-minport): 11001
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17564) Multi-tenancy partition cache size (-mtpmsize): 1024
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (12821) Use muxlatches (-mux): 1
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4260)  Maximum Number of Users (-n): 113
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17566) Minimum time to nap at first -spin exhaustion (-nap): 10
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17565) Maximum time to nap at -spin exhaustion (-napmax): 250
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (12273) No SSL Session Cache (-nosessioncache): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17807) Disable LRU mechanism (-nolru): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (16689) Login Governor (-nGovernor): 0 of 113
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (8527)  Storage object cache size (-omsize): 1024
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (13870) Database Service Manager - IPC Queue Size (-pica): 64.0  KBytes
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17802) Shared memory segments locked (-pinshm): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (16953) Use pollset mechanism for client/server (-pollset): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (16955) Delay first prefetch message (-prefetchDelay): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (16956) Prefetch message fill percentage (-prefetchFactor): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (16957) Minimum records in prefetch msg (-prefetchNumRecs): 16
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (16958) Suspension queue poll priority (-prefetchPriority): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17568) APW queue scan cycle time in milliseconds (-pwqdelay): 100
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17569) APW minimum queue length before write (-pwqmin): 1
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17570) APW buffer scan cycle time in seconds (-pwsdelay): 1
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17571) APW maximum number of buffers to scan per cycle (-pwscan): 5000
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17572) APW maximum number of buffers to write per cycle (-pwwmax): 25
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4247)  Before-Image File I/O (-r -R): Reliable
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17563) Record free chain search depth factor (-recspacesearchdepth): 5
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (6526)  Number of Semaphore Sets (-semsets): 3
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (12264) SSL Session Timeout (-sessiontimeout): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (13924) Maximum Shared Memory Segment Size (-shmsegsize): 32768 Mb
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4243)  Current Spin Lock Tries (-spin): 20000
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17803) SSL Encryption for TCP/IP connections (-ssl): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17556) Number of tables included in statistics collection (-tablerangesize): 1000
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (14017) Area block consistency check (-AreaCheck): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4239)  Number of Database Buffers (-B): 3000000
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17562) Number of Alternate Database Buffers (-B2): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (9422)  Maximum private buffers per user (-Bpmax): 64
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (14016) Database block consistency check (-DbCheck): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (13869) Database Service Manager - Service(s) to start (-DBService): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (10535) Enhanced Read-Only mode (-ERO): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4237)  Force Access (-F): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4249)  Before-Image Truncate Interval (-G): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4261)  Host Name (-H): franky-db
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (14018) Index block consistency check (-IndexCheck): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4241)  Current Size of Lock Table (-L): 150016
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (16688) Lock Governor (-LGovernor): 0%
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4257)  Maximum Number of Clients Per Server (-Ma): 1
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (14016) Memory overwrite check (-MemCheck): Not Enabled
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4245)  Delay of Before-Image Flush (-Mf): 3
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4259)  Minimum Clients Per Server (-Mi): 1
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (12818) Message Buffer Size (-Mm): 1024
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4258)  Maximum Number of Servers (-Mn): 80
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (12819) Servers per Protocol (-Mp): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (5647)  Maximum Servers Per Broker (-Mpb): 78
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4240)  Excess Shared Memory Size (-Mxs): 91
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4263)  Network Type (-N): TCP
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (16954) Server network message wait time (-Nmsgwait): 2
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (10357) Pending client connection timeout (-PendConnTimeout): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (4262)  Service Name (-S): 11000
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17804) Broker server group support (-ServerType): ABL
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (10028) SQL Server Max Open Cursors (-SQLCursors): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (10026) SQL Server Stack Size (-SQLStack): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (10027) SQL Server Statement Cache Size (-SQLStmtCache): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (10029) Size [1K byte units] of SQL Server temp table buffer (-SQLTempStoreBuff): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (10030) Size [1K byte units] of SQL Server temp table disk storage (-SQLTempStoreDisk): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (10031) Size [1K byte units] of SQL Server temp table data page (-SQLTempStorePageSize): 0
    [2016/07/20@19:17:08.516+0200] P-18511      T-139941315757888 I BROKER  0: (17955) Authorized data truncation (-SQLTruncateTooLarge): OFF
    [2016/07/20@19:17:08.517+0200] P-18511      T-139941315757888 I BROKER  0: (18156) SQL Autonomous Schema Update (-SQLWidthUpdate): OFF
    [2016/07/20@19:17:08.517+0200] P-18511      T-139941315757888 I BROKER  0: (14019) Record block consistency check (-TableCheck): Not Enabled
    [2016/07/20@19:17:08.517+0200] P-18511      T-139941315757888 I BROKER  0: (17717) TXE Lock retry limit (-TXERetryLimit): 0
    [2016/07/20@19:17:08.517+0200] P-18511      T-139941315757888 I BROKER  0: (13896) TXE Commit lock skip limit (-TXESkipLimit): 10000
    [2016/07/20@19:17:08.517+0200] P-18511      T-139941315757888 I BROKER  0: (10836) Database connections are not allowed at this time.
    [2016/07/20@19:17:08.517+0200] P-18511      T-139941315757888 I BROKER  0: (10471) Database connections have been enabled.
    [2016/07/20@19:17:08.517+0200] P-18525      T-139698275055424 I BIW    80: (-----) Login by proadmin.
    [2016/07/20@19:17:08.518+0200] P-18525      T-139698275055424 I BIW    80: (2518)  Started.
    [2016/07/20@19:17:08.556+0200] P-18529      T-139954100561728 I APW    81: (-----) Login by proadmin.
    [2016/07/20@19:17:08.557+0200] P-18529      T-139954100561728 I APW    81: (2518)  Started.
    [2016/07/20@19:17:08.596+0200] P-18533      T-140212745291584 I APW    82: (-----) Login by proadmin.
    [2016/07/20@19:17:08.597+0200] P-18533      T-140212745291584 I APW    82: (2518)  Started.



  • Extra info

    Windows 2012R2 datacenter HyperV host

    can HyperV Clustering, which is active, cause this ?

  • Did you manage to solve this issue?  We have exactly the same problem, and not getting very far with finding a solution.

  • one possible cause of the invalid semaphore id error is if, some time after the database has been started and it has created its semaphores, the semaphore set has been deleted, for example by using the ipcrm command.

  • > Did you manage to solve this issue?

    community.progress.com/.../26225

  • I have marked it as verified answer on community.progress.com/.../26225