jmac13
Member
Hi All,
Our Client is using 10.1c and recently they had issue with not being able to get on the system. They reported a message of Server out of Rescources message.
When I've looked in the DB log at the time they reported it I've got the below from one of the 5 databases we connect to.
The Brooker is complaining about No servers available. At first I thought this was to do with hitting the user limit. But then I would of thought they would of got "you have attempted to connect to database with too many users" error.
also the user said all sessions were showing as used but nobody was logged on (on promon). So just wondered what ppl thought? Could the -l message indicate that sessions are getting locked up?
3 of the dbs have number of servers set to 20, Number of clients per server 8 and they is also a separate server for sql connections for each one. 2 Other Db's have 20 and 8 set but no SQL. I dont believe we have sql connections to them and the below log is from a DB that has 4gl server and SQL server.
Thanks in advance
Our Client is using 10.1c and recently they had issue with not being able to get on the system. They reported a message of Server out of Rescources message.
When I've looked in the DB log at the time they reported it I've got the below from one of the 5 databases we connect to.
The Brooker is complaining about No servers available. At first I thought this was to do with hitting the user limit. But then I would of thought they would of got "you have attempted to connect to database with too many users" error.
also the user said all sessions were showing as used but nobody was logged on (on promon). So just wondered what ppl thought? Could the -l message indicate that sessions are getting locked up?
3 of the dbs have number of servers set to 20, Number of clients per server 8 and they is also a separate server for sql connections for each one. 2 Other Db's have 20 and 8 set but no SQL. I dont believe we have sql connections to them and the below log is from a DB that has 4gl server and SQL server.
Thanks in advance
Code:
[2014/02/04@09:29:29.294+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:30:11.638+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:30:23.044+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:31:15.654+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:31:20.060+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:31:28.466+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:31:48.904+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:32:17.451+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:32:44.904+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:32:59.388+0000] P-4128 T-4132 I BROKER 0: (1154) No servers are available. Try again later.
[2014/02/04@09:33:02.216+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 200 to 210.
[2014/02/04@09:33:02.216+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.
[2014/02/04@09:33:02.341+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 210 to 220.
[2014/02/04@09:33:02.341+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.
[2014/02/04@09:33:02.513+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 220 to 230.
[2014/02/04@09:33:02.513+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.
[2014/02/04@09:33:02.669+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 230 to 240.
[2014/02/04@09:33:02.669+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.
[2014/02/04@09:33:02.810+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 240 to 250.
[2014/02/04@09:33:02.810+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.
[2014/02/04@09:33:02.966+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 250 to 260.
[2014/02/04@09:33:02.966+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.
[2014/02/04@09:33:03.060+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 260 to 270.
[2014/02/04@09:33:03.076+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.
[2014/02/04@09:33:03.201+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 270 to 280.
[2014/02/04@09:33:03.201+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.
[2014/02/04@09:33:03.388+0000] P-3656 T-3420 I SRV 18: (5408) WARNING: -l exceeded. Automatically increasing from 280 to 290.
[2014/02/04@09:33:03.388+0000] P-3656 T-3420 I SRV 18: (5512) Previous message sent on behalf of user 128, server pid 3656, broker pid 4128.