D
durgaprasad m
Guest
HI Mark, Sorry for delay response, to resolve this issue we restarted database. Fyi......... once again we faced this issue "server has no more resources" on production database. All Databases up and running fine but application we not able to access. Progress version : 9.1e Os version : Aix 5.3 uptime: 01:06AM up 2 days, 23:03, 95 users, load average: 0.52, 1.66, 1.68 Promon details : 35 Servers, 41 Users (4 Local, 37 Remote, 4 Batch),4 Apws RETURN - show remaining, U - continue uninterrupted, Q - quit: Broker status: Executing BI Writer status: Executing AI Writer status: Executing Watchdog status: Executing Number of page writers: 4 Number of self-service users: 4 Number of remote users: 34 Number of servers: 35 Number of shut-downs: 0 Number of monitors: 1 Active transactions: 1 Lock table entries in use: 103 of 1024000 Lock table high water mark: 2193 Number of servers: 34 (36 allocated) Total users: 38 (1000 allocated) Self-service: 4 Remote: 34 Batch: 4 And also as you mentioned regarding Minport and max port values please find the values for below crn.pf minport 13100 # Min Port Number -maxport 14999 # Max Port Number Both for production and test server has same port number are assigned but they assigned in two different server.Is their any conflict. cat /etc/services prod server crn 13033/tcp # MFG/PRO N9 cat /etc/services test server crn 13033/tcp # MFG/PRO N9 Fyi,,, whenever we are facing this issue we seen connection timed out errors in all database log file for both test and prod servers. 18:41:29 SRV 31: Connection timed out on socket=115 for usernum 1, attempt disconnect. (1280) 18:41:30 SRV 31: Error reading socket=115 ret=-1 errno=22. (795) 18:41:30 SRV 31: Error reading socket=115 ret=-1 errno=22. (795) 18:41:48 SRV 18: Login usernum 970, userid areyes2, on mhlctxqad07a. (742) 18:42:20 SQLSRV2 3: SYSTEM ERROR: Memory violation. (49) 18:42:20 SQLSRV2 4: SYSTEM ERROR: Memory violation. (49) 18:42:50 BROKER 0: Disconnecting dead server 3. (2525) 18:42:50 BROKER 0: Disconnecting dead server 4. (2525) 18:44:24 SRV 10: Logout usernum 1009, userid bjenson, on mhlctxqad07a. (739) 18:44:55 SRV 31: Connection timed out on socket=115 for usernum 1, attempt disconnect. (1280) 18:45:00 SRV 10: Login usernum 1009, userid pgresdba, on p5lp5 batch. (742) 18:45:01 SRV 31: Error reading socket=123 ret=-1 errno=22. (795) 18:45:03 SRV 10: Logout usernum 1009, userid pgresdba, on p5lp5 batch. (739) 18:45:32 SRV 31: Connection timed out on socket=115 for usernum 1, attempt disconnect. (1280) 18:45:37 SRV 31: Error reading socket=117 ret=-1 errno=22. (795) 18:45:37 SRV 31: Error reading socket=123 ret=-1 errno=22. (795) 18:46:07 SRV 31: Connection timed out on socket=115 for usernum 1, attempt disconnect. (1280) 18:46:12 SRV 10: Login usernum 1009, userid marceo, on mhlctxqad07a. (742) 18:46:15 SRV 18: Login usernum 969, userid marceo, on mhlctxqad07a. (742) 18:46:23 SRV 31: Error reading socket=115 ret=-1 errno=22. (795) 18:46:53 SRV 31: Connection timed out on socket=115 for usernum 1, attempt disconnect. (1280) 18:47:23 SRV 31: Connection timed out on socket=115 for usernum 1, attempt disconnect. (1280)
Continue reading...
Continue reading...
