Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 12 total
Thread Error 11282: exceeded MaxConnections
Mon, Sep 4 2017 8:08 AMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 AMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent Link

Raul

Team Elevate 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 PMPermanent 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 PMPermanent Link

Raul

Team Elevate 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 AMPermanent 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 2Next Page »
Jump to Page:  1 2
Image