S
SteveSaltDanwood
Guest
Interesting ... We have two other DB's running - one is a schema placeholder for our application, because we don't have the source code for this element, we can't do away with this - there were no errors in the log for this, the other (a CRM DB) is used by Webspeed and the Broker connects to both the CRM DB, and our main DB. The CRM log has the following, around the same timeframe (approx. 30 seconds later): [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (49) SYSTEM ERROR: Memory violation. [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (14658) Previous message sent on behalf of user 56, server pid 14722, broker pid 9734. (5512) [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (439) ** Save file named core for analysis by Progress Software Corporation. [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (14658) Previous message sent on behalf of user 56, server pid 14722, broker pid 9734. (5512) [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (1132) Invalid semaphore id [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (10839) SYSTEM ERROR: Unable to set semaphore set : semid = 32, errno = 22. [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (739) Logout usernum 56, userid dba, on WSH-MXP-P-01.danwood.ad batch. [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (1132) Invalid semaphore id [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (10839) SYSTEM ERROR: Unable to get value of semaphore set : semid = -32737, errno = 22. [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (-----) semLockLog_2: semValue val = -1 [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (1132) Invalid semaphore id [2015/12/14@15:28:29.153+0000] P-14722 T-139716379809600 I SRV 1: (10839) SYSTEM ERROR: Unable to set semaphore set : semid = -32735, errno = 22. [2015/12/14@15:28:29.169+0000] P-14722 T-139716379809600 I SRV 1: (2520) Stopped. This one has a memory violation and then a core file generated I then found a procore file with the following: 14/12/15 15:27:51 [9549] Progress Recent Message(s): (723) (1075) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) (1443) ** The server has disconnected. (723) Semaphore id -32739 was removed (1075) Duplicate unique key in database table. (1443) Duplicate unique key in database table. (1443) I don't know if this is related or not ... unfortunately, the error doesn't tell me which Table, or even DB this is related to ... Steve
Continue reading...
Continue reading...