Hi All,
Today we faced issue with our mfg/pro application.One of mfg/pro job got failed during that time database up and running fine but users not able to connect to Application.When i try to connect to mfg/pro application also i am faced below issue.
After that we have restarted databases everything came to normal.
"Server or system has no more resources.Please contact progress technical support(748)"
When i checked in database log file i found below errors.But we not found any cpu or memory utilization are high during that time all are normal.
I checked in protrace file not able to find anything same has been attached for your refrence.
What exactly the issue why user are not able to connect to application?
How to monitor Resource count?
Database version : 9.1E
OS version : Aix 5.3 outdated version
DB size is 80GB
Mfg/pro 8.3
-B 70000 # Number of Blocks in database buffer
-bibufs 200 # Number of before-image buffers
-aibufs 300 # Number of after-image buffers
#-Mi 2 # Min processes on a client server
-Ma 15 # Max number of REMOTE clients per db server
-Mn 35 # Max number of REMOTE client servers
-n 1000 # Max number users.
-Mxs 32768 # Shared memory overflow size (override)
-spin 12000 # Number of spin lock retries
-L 1024000 # Lock Table entries
We have checked firewall settings for keep-alive timeout values already set to default.
*p-10001*:/home/pgresdba: no -a | grep tcp_keep
tcp_keepcnt = 8
tcp_keepidle = 14400
tcp_keepinit = 150
tcp_keepintvl = 150
8:58:34 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
18:58:34 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
18:58:34 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:01:43 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:02:17 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:02:17 BROKER 0: Error reading socket=20 ret=-1 errno=22. (795)
19:02:21 BROKER 0: Error reading socket=25 ret=-1 errno=22. (795)
19:02:36 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:03:06 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:03:36 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:04:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:04:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:05:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:05:18 BROKER 0: Server's received count 1 does not equal client(1)'s send count 1414744096. (1055)
19:05:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:05:48 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:06:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:06:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:07:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:07:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:07:59 SRV 2: Connection timed out on socket=19 for usernum 1, attempt disconnect. (1280)
19:07:59 SRV 2: Error reading socket=19 ret=-1 errno=22. (795)
19:07:59 SRV 2: Error reading socket=19 ret=-1 errno=22. (795)
19:08:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:08:18 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:08:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:09:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:09:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:10:20 SRV 2: Connection timed out on socket=19 for usernum 1, attempt disconnect. (1280)
19:10:33 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:10:55 SRV 2: Connection timed out on socket=22 for usernum 4, attempt disconnect. (1280)
19:10:55 SRV 2: Error reading socket=27 ret=-1 errno=22. (795)
19:10:55 SRV 2: Error reading socket=19 ret=-1 errno=22. (795)
Today we faced issue with our mfg/pro application.One of mfg/pro job got failed during that time database up and running fine but users not able to connect to Application.When i try to connect to mfg/pro application also i am faced below issue.
After that we have restarted databases everything came to normal.
"Server or system has no more resources.Please contact progress technical support(748)"
When i checked in database log file i found below errors.But we not found any cpu or memory utilization are high during that time all are normal.
I checked in protrace file not able to find anything same has been attached for your refrence.
What exactly the issue why user are not able to connect to application?
How to monitor Resource count?
Database version : 9.1E
OS version : Aix 5.3 outdated version
DB size is 80GB
Mfg/pro 8.3
-B 70000 # Number of Blocks in database buffer
-bibufs 200 # Number of before-image buffers
-aibufs 300 # Number of after-image buffers
#-Mi 2 # Min processes on a client server
-Ma 15 # Max number of REMOTE clients per db server
-Mn 35 # Max number of REMOTE client servers
-n 1000 # Max number users.
-Mxs 32768 # Shared memory overflow size (override)
-spin 12000 # Number of spin lock retries
-L 1024000 # Lock Table entries
We have checked firewall settings for keep-alive timeout values already set to default.
*p-10001*:/home/pgresdba: no -a | grep tcp_keep
tcp_keepcnt = 8
tcp_keepidle = 14400
tcp_keepinit = 150
tcp_keepintvl = 150
8:58:34 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
18:58:34 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
18:58:34 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:01:43 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:02:17 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:02:17 BROKER 0: Error reading socket=20 ret=-1 errno=22. (795)
19:02:21 BROKER 0: Error reading socket=25 ret=-1 errno=22. (795)
19:02:36 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:03:06 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:03:36 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:04:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:04:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:05:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:05:18 BROKER 0: Server's received count 1 does not equal client(1)'s send count 1414744096. (1055)
19:05:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:05:48 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:06:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:06:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:07:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:07:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:07:59 SRV 2: Connection timed out on socket=19 for usernum 1, attempt disconnect. (1280)
19:07:59 SRV 2: Error reading socket=19 ret=-1 errno=22. (795)
19:07:59 SRV 2: Error reading socket=19 ret=-1 errno=22. (795)
19:08:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:08:18 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:08:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:09:18 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:09:48 BROKER 0: Connection timed out on socket=5 for usernum 1, attempt disconnect. (1280)
19:10:20 SRV 2: Connection timed out on socket=19 for usernum 1, attempt disconnect. (1280)
19:10:33 BROKER 0: Error reading socket=5 ret=-1 errno=22. (795)
19:10:55 SRV 2: Connection timed out on socket=22 for usernum 4, attempt disconnect. (1280)
19:10:55 SRV 2: Error reading socket=27 ret=-1 errno=22. (795)
19:10:55 SRV 2: Error reading socket=19 ret=-1 errno=22. (795)