Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 10 of 12 total |
Error 11282: exceeded MaxConnections |
Mon, Sep 4 2017 8:08 AM | Permanent Link |
Luis Conception Gonzalez | Hi!
I have a customer that is reporting 11282 error in their dbisam *server* application. Server 'MaxConnections' configuration is the default value (max), so this is very weird because he has only 6 or 7 clients connected. I'm using 4.43 Build 4. After some forum search, I found a post from 2008 about this error when using the application with VMWare or similar virtual machines. I asked my customer about this and he confirmed he's using the application under a VMWare environment (don't know why, actually). The 2008 post is here: https://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_cs&page=10&msg=6723#6723 What can cause this error if server MaxConnections config is the default/max allowed? Is there any workaround or something my customer can do to avoid this? Thanks! Luis C. |
Tue, Sep 5 2017 11:42 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Luis,
<< I have a customer that is reporting 11282 error in their dbisam *server* application. Server 'MaxConnections' configuration is the default value (max), so this is very weird because he has only 6 or 7 clients connected. I'm using 4.43 Build 4. After some forum search, I found a post from 2008 about this error when using the application with VMWare or similar virtual machines. I asked my customer about this and he confirmed he's using the application under a VMWare environment (don't know why, actually). The 2008 post is here: https://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_cs&page=10&msg=6723#6723 What can cause this error if server MaxConnections config is the default/max allowed? Is there any workaround or something my customer can do to avoid this? >> Just to confirm: is your customer running the *client* application, the *server* application/service, or both under VMWare ? It sounds like a race condition. Does the customer see the error in a reproducible fashion, or is it fairly random ? Finally, are you performing any administrative connections also ? Tim Young Elevate Software www.elevatesoft.com |
Tue, Sep 5 2017 12:42 PM | Permanent Link |
Luis Conception Gonzalez | Hi, Tim.
Thanks for your reply. I will ask the customer those questions. I'm not performing any administrative connection, but the application can connect to the administrative port in some cases to créate the databases, but only in the first setup process. AFAIK, the database server app is running in a VMWARE machine. Also, the main application is being used in that PC too (connected to 127.0.0.1 or localhost). I don't know if all other clients are also in VMWare machines (don't think so, but will ask). Thanks Luis C. Tim Young [Elevate Software] wrote: Luis, << I have a customer that is reporting 11282 error in their dbisam *server* application. Server 'MaxConnections' configuration is the default value (max), so this is very weird because he has only 6 or 7 clients connected. I'm using 4.43 Build 4. After some forum search, I found a post from 2008 about this error when using the application with VMWare or similar virtual machines. I asked my customer about this and he confirmed he's using the application under a VMWare environment (don't know why, actually). The 2008 post is here: https://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_cs&page=10&msg=6723#6723 What can cause this error if server MaxConnections config is the default/max allowed? Is there any workaround or something my customer can do to avoid this? >> Just to confirm: is your customer running the *client* application, the *server* application/service, or both under VMWare ? It sounds like a race condition. Does the customer see the error in a reproducible fashion, or is it fairly random ? Finally, are you performing any administrative connections also ? Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 6 2017 5:26 AM | Permanent Link |
Luis Conception Gonzalez | Hi Tim.
1. The customer says the error appears *daily* 2. Both client(s) and server applications are running on different VMWare machines. 5 clients and 1 server. Luis C. Tim Young [Elevate Software] wrote: Luis, << I have a customer that is reporting 11282 error in their dbisam *server* application. Server 'MaxConnections' configuration is the default value (max), so this is very weird because he has only 6 or 7 clients connected. I'm using 4.43 Build 4. After some forum search, I found a post from 2008 about this error when using the application with VMWare or similar virtual machines. I asked my customer about this and he confirmed he's using the application under a VMWare environment (don't know why, actually). The 2008 post is here: https://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_cs&page=10&msg=6723#6723 What can cause this error if server MaxConnections config is the default/max allowed? Is there any workaround or something my customer can do to avoid this? >> Just to confirm: is your customer running the *client* application, the *server* application/service, or both under VMWare ? It sounds like a race condition. Does the customer see the error in a reproducible fashion, or is it fairly random ? Finally, are you performing any administrative connections also ? Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 6 2017 11:31 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Luis,
<< 1. The customer says the error appears *daily* 2. Both client(s) and server applications are running on different VMWare machines. 5 clients and 1 server. >> Thanks. Just to be sure, there's no chance that any of the clients are connecting to a different DBISAM Database Server instance that may have smaller max connection settings, correct ? Also, there is a max connections setting per user - did you verify that none of the users are restricted to X number of connections using the Server Administration Utility ? Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 6 2017 1:58 PM | Permanent Link |
Luis Conception Gonzalez | Hi, Tim. Thanks for your reply.
No, there's only a server. Today we have more information: 1. They have a Linux Cloud Server 2. They installed VMWare with 8 virtual machines in that server 3. Each virtual machine runs Windows 10 Pro 4. One of the virtual machine has installed the database server 5. Every client PC (8) has VMware installed too 6. Every client PC connects to their own remote virtual machine I DON'T KNOW W-H-Y << Also, there is a max connections setting per user - did you verify that none of the users are restricted to X number of connections using the Server Administration Utility ? >> How can I check the per-user max connections? Is it posible to get it by code? Thanks! Luis C. Tim Young [Elevate Software] wrote: Luis, << 1. The customer says the error appears *daily* 2. Both client(s) and server applications are running on different VMWare machines. 5 clients and 1 server. >> Thanks. Just to be sure, there's no chance that any of the clients are connecting to a different DBISAM Database Server instance that may have smaller max connection settings, correct ? Also, there is a max connections setting per user - did you verify that none of the users are restricted to X number of connections using the Server Administration Utility ? Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 6 2017 3:22 PM | Permanent Link |
Raul Team Elevate | On 9/6/2017 1:58 PM, Luis Conception Gonzalez wrote:
> How can I check the per-user max connections? Is it posible to get it by code? Use DBISAM server admin utility to log into the DBSRVR and then on "Users" tab you can see "max # of Connections" for each user (i think 100 might be a default). Yes, you can get this programmatically by connecting to admin port of DBSRVR - see the "GetServerUser" method from "Server Administration" section of manual : https://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphiwin32&version=10T&topic=Server_Administration Raul |
Thu, Sep 7 2017 1:22 PM | Permanent Link |
Luis Conception Gonzalez | Hi, Raul.
Yes, user maxconnections is the default value: 100 Raul wrote: On 9/6/2017 1:58 PM, Luis Conception Gonzalez wrote: > How can I check the per-user max connections? Is it posible to get it by code? Use DBISAM server admin utility to log into the DBSRVR and then on "Users" tab you can see "max # of Connections" for each user (i think 100 might be a default). Yes, you can get this programmatically by connecting to admin port of DBSRVR - see the "GetServerUser" method from "Server Administration" section of manual : https://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=rsdelphiwin32&version=10T&topic=Server_Administration Raul |
Thu, Sep 7 2017 6:26 PM | Permanent Link |
Raul Team Elevate | On 9/7/2017 1:22 PM, Luis Conception Gonzalez wrote:
> > Yes, user maxconnections is the default value: 100 > Looks like that both server connection count and user connection counts are high enough. Do they have disconnected sessions hanging around by any chance to cause this ? Earlier you mentioned that they are running all of this on *Windows 10 Pro*. I believe there is a limit as to the maximum number of incoming TCP connections - quick google shows this is either 10 or 20 so any chance that is causing the problem ? Raul |
Mon, Sep 11 2017 8:15 AM | Permanent Link |
Luis Conception Gonzalez | Hi, Raul
> Do they have disconnected sessions hanging around by any chance to cause this ? I asked them for this a few days ago. They are sure no disconnected sessions are hanging, and they close the client application correctly (not powering Windows off directly). I didn't know Windows has a tcp connections limit, but in that case, that would raise a Windows error/warning, not a dbisam one, isn't it? I sent them a new server application release with max user connections setted to 1000 instead of 100, just to know if anything changes. Thanks! Luis C. Raul wrote: On 9/7/2017 1:22 PM, Luis Conception Gonzalez wrote: > > Yes, user maxconnections is the default value: 100 > Looks like that both server connection count and user connection counts are high enough. Do they have disconnected sessions hanging around by any chance to cause this ? Earlier you mentioned that they are running all of this on *Windows 10 Pro*. I believe there is a limit as to the maximum number of incoming TCP connections - quick google shows this is either 10 or 20 so any chance that is causing the problem ? Raul |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |