SQL Anywhere database - Clients loose connection to database and can't reconnect! HELP!

Author

Clients loose connection to database and can't reconnect! HELP!

Manney

2005-05-19, 3:23 am

Got a really strange problem with a site that has started happening about
2-3 weeks ago. Our client swears that no new software has been installed on
the server for over a year. Our software has been using sybase ASA 7.0.4
for the last 4 years and we have found it to be an exceptional database
engine and this is the first quirk we have had with it.

What seems to happen, is all the client apps hang and the applications
cannot be restarted because they cannot see the database anymore. if we
hook up to the server there database service is still running but there is
no way to connect to it. There are no errors that appear in the window
events log that point to any kind of problem with asa or anything else for
that matter.

If the SERVICE is stopped and then restarted every thing is fine until the
next time it happens. We have unloaded the database, uninstalled sybase
completely reinstalled and reloaded but it is still happening. This
particular customer is running sybase on a win2k server. We have over 50
other sites installed exactly the same way that are not having any problems
at all.

Can anyone point me in the right direction as I have no idea where to start
looking

Manney

2005-05-19, 3:23 am

Sorry I said that the database was running on a Win2K Server it is acctually
a Windows 2003 Server. Sorry :-)

Justin Willey

2005-05-19, 9:23 am

Hi - are you using Java in the database?

We had similar problems where the max number of threads was being exhausted,
because each connection was using one thread + another for java processing.
It was fixed by increasing the max number of threads to (max number of
connections x 2) + 1 with the -gn server parameter.

Justin Willey

"Manney" <nospam@mycompany.com> wrote in message
news:428c4963$1@foru
ms-1-dub...
> Sorry I said that the database was running on a Win2K Server it is
acctually
> a Windows 2003 Server. Sorry :-)
>
>

Manney

2005-05-19, 9:23 am

Thanks for the reply Justin but I have a feeling this is not going to work.

Reason is the documentation says the -gn switch has a default value of 20
for a network server. If this is the case the site has only 8 concurent
licences, which would mean, using your formula, I would setting the value
lower than its default.

regards

Manney

"Justin Willey" <gjw@nospamatall.iqx.co.uk> wrote in message
news:428c8e85$1@foru
ms-2-dub...
> Hi - are you using Java in the database?
>
> We had similar problems where the max number of threads was being
> exhausted,
> because each connection was using one thread + another for java
> processing.
> It was fixed by increasing the max number of threads to (max number of
> connections x 2) + 1 with the -gn server parameter.
>
> Justin Willey
>
>
>
> "Manney" <nospam@mycompany.com> wrote in message
> news:428c4963$1@foru
ms-1-dub...
> acctually
>
>

Justin Willey

2005-05-23, 7:24 am

No, it doesn't look like this is relevant in your case (unless your app is
using more than 1 java thread per connection, which isn't impossible). We
came accross it with around 300 concurerent users.

Good luck

Justin

"Manney" <nospam@mycompany.com> wrote in message
news:428c9d94$1@foru
ms-2-dub...
> Thanks for the reply Justin but I have a feeling this is not going to
work.
>
>
> Reason is the documentation says the -gn switch has a default value of 20
> for a network server. If this is the case the site has only 8 concurent
> licences, which would mean, using your formula, I would setting the value
> lower than its default.
>
>
> regards
>
> Manney
>
>
> "Justin Willey" <gjw@nospamatall.iqx.co.uk> wrote in message
> news:428c8e85$1@foru
ms-2-dub...
>
>

Sponsored Links