Sometimes database server SA16 crash (build 220.127.116.114), no outupt log specified
init switchs: -c 77p -ch 80p -ti 600 -gt 4 -gtc 4 -o E:\LogsSQL16\srvmessages.log -oe E:\LogsSQL16\srverrors.log -dt E:\TmpSQL16 -gna 0 -gn 20 -gnl 10 -gnh 100 -gns
Is there anything that i can do to identify the problem?
asked 05 Dec '16, 09:14
The server did not stop, it kept running (see all the normal checkpoint messages).
The server did write several messages that exactly identify the connection that terminated (see the detailed messages starting with "Connection terminated abnormally").
If a client application crashes, that is a completely separate event from the server. The server cannot be expected to know what happened on some other computer somewhere else on the network.
Here is where you should be looking for the problem; i.e., the FCore.exe program running on IP=192.168.69.96:
IP=192.168.69.96; HOST=pccom707; OSUSER=mgois; OS='Windows 7 Build 7601 Service Pack 1'; EXE='\Ns-uf01\app$\Fapricela\CRMSALES\Versão 2\FCore.exe'; PID=0x15dc; THREAD=0x1420; VERSION=18.104.22.1683; API=OLEDB; TIMEZONEADJUSTMENT=0; APPINFO=FCORE
answered 07 Dec '16, 06:57
Nothing in these messages suggests that the server crashed. I see some messages that client apps either crashed or, possibly, terminated normally without disconnecting first.
answered 05 Dec '16, 09:36