sa16 database server crash

[former_SQLA_member1694908]

Sometimes database server SA16 crash (build 16.0.0.2344), 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

(...)
I. 12/05 12:51:31. Starting checkpoint of "IMInformatica" (IMInformatica.db) at Mon Dec 05 2016 12:51
I. 12/05 12:51:31. Finished checkpoint of "IMInformatica" (IMInformatica.db) at Mon Dec 05 2016 12:51
I. 12/05 12:51:50. Starting checkpoint of "SGInformatica" (SGInformatica.db) at Mon Dec 05 2016 12:51
I. 12/05 12:51:50. Finished checkpoint of "SGInformatica" (SGInformatica.db) at Mon Dec 05 2016 12:51
I. 12/05 12:52:07. Cache size adjusted to 8817808K
I. 12/05 12:52:16. Starting checkpoint of "GWIInvestments" (GWIInvestments.db) at Mon Dec 05 2016 12:52
I. 12/05 12:52:16. Finished checkpoint of "GWIInvestments" (GWIInvestments.db) at Mon Dec 05 2016 12:52
I. 12/05 12:53:38. Connection terminated abnormally; client socket shut down
I. 12/05 12:53:38. Disconnected TCPIP client's AppInfo: 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=16.0.0.2283;API=OLEDB;TIMEZONEADJUSTMENT=0;APPINFO=FCORE
I. 12/05 12:53:38. Connection terminated abnormally; client socket shut down
I. 12/05 12:53:38. Connection terminated abnormally; client socket shut down
I. 12/05 12:53:38. Disconnected TCPIP client's AppInfo: 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=16.0.0.2283;API=OLEDB;TIMEZONEADJUSTMENT=0;APPINFO=FCORE
I. 12/05 12:53:38. Disconnected TCPIP client's AppInfo: 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=16.0.0.2283;API=OLEDB;TIMEZONEADJUSTMENT=0;APPINFO=FCR_MSG_SRVC

(...)
I. 11/29 11:46:24. Starting checkpoint of "Fapricela" (Fapricela.db) at Tue Nov 29 2016 11:46
I. 11/29 11:46:25. Finished checkpoint of "Fapricela" (Fapricela.db) at Tue Nov 29 2016 11:46
I. 11/29 11:46:29. Starting checkpoint of "Fapricela" (Fapricela.db) at Tue Nov 29 2016 11:46
I. 11/29 11:46:30. Finished checkpoint of "Fapricela" (Fapricela.db) at Tue Nov 29 2016 11:46

(...)
I. 11/17 13:16:19. Starting checkpoint of "FapricelaFR" (FapricelaFR.db) at Thu Nov 17 2016 13:16
I. 11/17 13:16:19. Starting checkpoint of "FapricelaUK" (FapricelaUK.db) at Thu Nov 17 2016 13:16
I. 11/17 13:16:19. Finished checkpoint of "FapricelaFR" (FapricelaFR.db) at Thu Nov 17 2016 13:16
I. 11/17 13:16:19. Finished checkpoint of "FapricelaUK" (FapricelaUK.db) at Thu Nov 17 2016 13:16

Is there anything that i can do to identify the problem?

[VolkerBarth]

no outupt log specified [...]
-o E:\\LogsSQL16\\srvmessages.log -oe E:\\LogsSQL16\\srverrors.log

That seems contradictory to me. So do you use a console log, and if so, what does it contain before/after a crash?

[former_SQLA_member1694908]

no error log is created, only the message log (with the last messages before the crash) that i extracted in the post.

[VolkerBarth]

Well, even if the log does not contain anything when the server crashes, it should certainly contain some lines when the server is restarted (say, the product name and version number) and when the database is started (database name, recovery steps and the like). It would help us if you show these lines...

[former_SQLA_member1694908]

shure, but i create a new log file everytime the service is manually started. Those are the last lines before crash.

I found two files: SA16_20161205_125344_3092.CRASH_LOG_FILE and SA16_20161205_125344_3092.DMP in the SQL Anywhere 16 diagnostics folder, how can i send it?

[Former Member]

You can send those to Product Support if you open up an incident.

Alternatively you can submit those using dbsupport -sa and let us know the submission numbers (if you didn't catch those when submitted you can list them using dbsupport -ls)

[Breck_Carter]

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=16.0.0.2283;
API=OLEDB;
TIMEZONEADJUSTMENT=0;
APPINFO=FCORE

[johnsmirnios]

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.

[former_SQLA_member1694908]

the problem is that the server don't write anything in the log when stops unexpectedly.

the OS Event Viewer is not illustrative (05-12-2016 12:53:49): The SQL Anywhere - SA16 service terminated unexpectedly. It has done this 4 time(s).

[Breck_Carter]

What makes you think the "SA16 service terminated unexpectedly"?

The message says the Fcore.exe program on IP=192.168.69.96 terminated... that's not the SA16 service, is it?