The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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?

asked 05 Dec '16, 09:14

SamuelCosta's gravatar image

SamuelCosta
113
accept rate: 0%

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?

(05 Dec '16, 10:09) Volker Barth

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

(05 Dec '16, 10:14) SamuelCosta
Replies hidden

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...

(05 Dec '16, 10:24) Volker Barth

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?

(05 Dec '16, 10:37) SamuelCosta

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)

(06 Dec '16, 15:48) Nick Elson S...

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
permanent link

answered 07 Dec '16, 06:57

Breck%20Carter's gravatar image

Breck Carter
26.6k418575824
accept rate: 21%

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.

permanent link

answered 05 Dec '16, 09:36

John%20Smirnios's gravatar image

John Smirnios
8.7k377106
accept rate: 40%

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).

(05 Dec '16, 09:58) SamuelCosta
Replies hidden
1

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?

(07 Dec '16, 06:59) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×186
×43

question asked: 05 Dec '16, 09:14

question was seen: 168 times

last updated: 07 Dec '16, 06:59