dbTalk Databases Forums  

Clients lost connections to server

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Clients lost connections to server in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sybase.news.spam@elomagic.de
 
Posts: n/a

Default Clients lost connections to server - 08-28-2009 , 06:43 AM






Hello,
i have a problem with one of my SA 10.0.1.3903 installations.
Sometimes, all client connections will be lost. I found in the console
log file many warnings that called like "Dispatch von X benötigte Y
Sekunden". What does it means? You can see a details of the logfile at
the bottom of this news.
I think it is a network problem. May be this warning message will be
helpful for me to find the network problem.
Thanks, Carsten

I. 28.08 11:35:40. Interne Warnung: Dispatch von ATimer benötigte 11
Sekunden
I. 28.08 11:36:41. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.29;HOST=DEKAE00R29;OS='Windows XP Build 2600 Service Pack
1';PID=0x3c0;THREAD=0x3bc;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.6;HOST=DEKAE00RPDW3;OS='Windows XP Build 2600 Service
Pack 2';PID=0xc34;THREAD=0xc38;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.11;HOST=DEKAE00RPDW8;OS='Windows XP Build 2600 Service
Pack 2';PID=0xe74;THREAD=0x120;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.14;HOST=DEKAE00R14;OS='Windows XP Build 2600 Service Pack
2';PID=0x9f4;THREAD=0x9f8;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.25;HOST=DEKAE00RPDW6;OS='Windows XP Build 2600 Service
Pack 3';PID=0xb98;THREAD=0xb9c;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.32;HOST=DEKAE00R32;OS='Windows XP Build 2600 Service Pack
2';PID=0x7e8;THREAD=0xe60;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:46. Interne Warnung: Dispatch von WinSock completion
benötigte 19 Sekunden
I. 28.08 11:36:46. Interne Warnung: Dispatch von SockCompletion Worker
benötigte 56 Sekunden
I. 28.08 11:36:46. Interne Warnung: Dispatch von Request task 11
benötigte 80 Sekunden
I. 28.08 11:36:46. Interne Warnung: Dispatch von Request task 0
benötigte 63 Sekunden

Reply With Quote
  #2  
Old   
Nick Elson [Sybase iAnywhere]
 
Posts: n/a

Default Re: Clients lost connections to server - 08-28-2009 , 10:25 AM






"Dispatch von <X> benötigte <Y> Sekundena"

... or in English ...

"Dispatch of <X> took <Y> seconds "

is a performance warning meaning your Operating System
and/or your Hardware systems is running much slower
than expected. The dispatch in this case is a call to
the operating system ... and that dispatch is usually
something that should only take a few milliseconds ...
but something is preventing your whole machine
from being able to service those dispatches in a
timely fashion.

You'll need to pull the Operating System diagnostic
tools to diagnose these kinds of problems.

Either way, when an overworked machine starts
behaving this way, things like network timeouts
can start to happen and that effect is most likely the
factor related to your dropping of those connections.

<sybase.news.spam (AT) elomagic (DOT) de> wrote

Hello,
i have a problem with one of my SA 10.0.1.3903 installations.
Sometimes, all client connections will be lost. I found in the console
log file many warnings that called like "Dispatch von X benötigte Y
Sekunden". What does it means? You can see a details of the logfile at
the bottom of this news.
I think it is a network problem. May be this warning message will be
helpful for me to find the network problem.
Thanks, Carsten

I. 28.08 11:35:40. Interne Warnung: Dispatch von ATimer benötigte 11
Sekunden
I. 28.08 11:36:41. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.29;HOST=DEKAE00R29;OS='Windows XP Build 2600 Service Pack
1';PID=0x3c0;THREAD=0x3bc;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.6;HOST=DEKAE00RPDW3;OS='Windows XP Build 2600 Service
Pack 2';PID=0xc34;THREAD=0xc38;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.11;HOST=DEKAE00RPDW8;OS='Windows XP Build 2600 Service
Pack 2';PID=0xe74;THREAD=0x120;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.14;HOST=DEKAE00R14;OS='Windows XP Build 2600 Service Pack
2';PID=0x9f4;THREAD=0x9f8;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.25;HOST=DEKAE00RPDW6;OS='Windows XP Build 2600 Service
Pack 3';PID=0xb98;THREAD=0xb9c;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:42. Verbindung wurde abnormal beendet; Client-Socket
deaktiviert
I. 28.08 11:36:42. AppInfo des getrennten TCPIP-Clients:
IP=192.11.20.32;HOST=DEKAE00R32;OS='Windows XP Build 2600 Service Pack
2';PID=0x7e8;THREAD=0xe60;EXE=c:\...
\...exe;VERSION=10.0.1.3903;API=ODBC;TIMEZONEADJUS TMENT=120
I. 28.08 11:36:46. Interne Warnung: Dispatch von WinSock completion
benötigte 19 Sekunden
I. 28.08 11:36:46. Interne Warnung: Dispatch von SockCompletion Worker
benötigte 56 Sekunden
I. 28.08 11:36:46. Interne Warnung: Dispatch von Request task 11
benötigte 80 Sekunden
I. 28.08 11:36:46. Interne Warnung: Dispatch von Request task 0
benötigte 63 Sekunden

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.