Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi,

We're running SqlAnywhere 17 (). Sometimes the server crashes and we don't know why.

The database startup string looks like this : -x TCPIP{} -gc 20 -gl all -gp 32768 -ti 0 -c 60p -m -xs HTTPS(FIPS=n;PORT=1234;MaxRequestSize=0;IDENTITY=identity_file.pem;IDENTITY_PASSWORD=****) -ec NONE -nSYBASE_SERVER "D:\DB\database.db" -oe "d:\DB\errorlog.txt"

We've analyzed the crash dumps and they all point to the same point : sapcrypto.dll Here's the dump:

CONTEXT:  (.ecxr)
rax=0000000200000003 rbx=0000000000000000 rcx=00000207e025f6e0
rdx=00007ffe057d4bc0 rsi=00007ffe05727370 rdi=00000207e01c52c0
rip=00007ffe054a15b3 rsp=0000008ef94ced50 rbp=0000008ef94cee50
 r8=0000021649f5a1c0  r9=0000008ef94cee50 r10=0000000000000004
r11=00000207e025f6e0 r12=0000000000000000 r13=0000021649f4b742
r14=00000000000000ff r15=0000000000000100
iopl=0         nv up ei pl nz na pe nc
cs=0033  ss=002b  ds=002b  es=002b  fs=0053  gs=002b             efl=00010202
sapcrypto+0x1215b3:
00007ffe054a15b3 488b4808        mov     rcx,qword ptr [rax+8] ds:000000020000000b=????????????????
Resetting default scope

EXCEPTION_RECORD: (.exr -1) ExceptionAddress: 00007ffe054a15b3 (sapcrypto+0x00000000001215b3) ExceptionCode: c0000005 (Access violation) ExceptionFlags: 00000000 NumberParameters: 2 Parameter[0]: 0000000000000000 Parameter[1]: 000000020000000b Attempt to read from address 000000020000000b

PROCESS_NAME: dbsrv17.exe

READ_ADDRESS: 000000020000000b

ERROR_CODE: (NTSTATUS) 0xc0000005 - The instruction at 0x%p referenced memory at 0x%p. The memory could not be %s.

EXCEPTION_CODE_STR: c0000005

EXCEPTION_PARAMETER1: 0000000000000000

EXCEPTION_PARAMETER2: 000000020000000b

IP_ON_HEAP: 00000207e025abc0

FRAME_ONE_INVALID: 1

STACK_TEXT:
0000008ef94ced50 00000207e025abc0 : 0000008ef94cee50 00007ffe05727370 000000005c1dfc6b 000002164aa1be70 : sapcrypto+0x1215b3 0000008ef94ced58 0000008ef94cee50 : 00007ffe05727370 000000005c1dfc6b 000002164aa1be70 000000000001201f : 0x00000207e025abc0 0000008ef94ced60 00007ffe05727370 : 000000005c1dfc6b 000002164aa1be70 000000000001201f 0000008ef94cedc0 : 0x0000008ef94cee50 0000008ef94ced68 000000005c1dfc6b : 000002164aa1be70 000000000001201f 0000008ef94cedc0 0000000000000018 : sapcrypto+0x3a7370 0000008ef94ced70 000002164aa1be70 : 000000000001201f 0000008ef94cedc0 0000000000000018 00000207e019d1c0 : dbserv17+0x21fc6b 0000008ef94ced78 000000000001201f : 0000008ef94cedc0 0000000000000018 00000207e019d1c0 0000000000000100 : 0x000002164aa1be70 0000008ef94ced80 0000008ef94cedc0 : 0000000000000018 00000207e019d1c0 0000000000000100 00000207e025f6e0 : 0x1201f 0000008ef94ced88 0000000000000018 : 00000207e019d1c0 0000000000000100 00000207e025f6e0 0000000000000000 : 0x0000008ef94cedc0 0000008ef94ced90 00000207e019d1c0 : 0000000000000100 00000207e025f6e0 0000000000000000 0000000000000000 : 0x18 0000008ef94ced98 0000000000000100 : 00000207e025f6e0 0000000000000000 0000000000000000 0000000000000000 : 0x00000207e019d1c0 0000008ef94ceda0 00000207e025f6e0 : 0000000000000000 0000000000000000 0000000000000000 00007ffe05722ca8 : 0x100 0000008ef94ceda8 0000000000000000 : 0000000000000000 0000000000000000 00007ffe05722ca8 0000000200000001 : 0x00000207e025f6e0

SYMBOL_NAME: sapcrypto+1215b3

MODULE_NAME: sapcrypto

IMAGE_NAME: sapcrypto.dll

STACK_COMMAND: ~4s ; .ecxr ; kb

FAILURE_BUCKET_ID: INVALID_POINTER_READ_c0000005_sapcrypto.dll!Unknown

OSPLATFORM_TYPE: x64

OSNAME: Windows 10

FAILURE_ID_HASH: {476ed1b0-646f-066f-efde-40467f36aef6}

Followup: MachineOwner

We think it has something to do with the certificate but there's no evidence for it. No errorlogs are generated when the server crashes, no eventlogs are generated. Only these crashdumps.

Anybody any idea?

Kind regards, Roel Schlijper

asked 30 Oct '19, 04:55

RoelS's gravatar image

RoelS
26335
accept rate: 0%

edited 01 Nov '19, 07:19

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050

Just an assumption: sapcrypto library can be updated to a newer version (it it exists) https://support.sap.com/en/my-support/software-downloads.html

(01 Nov '19, 06:04) Vlad

Vlad's suggestion is probably a lot easier, but if it doesn't help, c0000005 (Access violation) may be a bug and you should call SAP tech support.

Clarification: The above image refers to front line tech support only, not the folks in Waterloo.

(01 Nov '19, 07:23) Breck Carter
Replies hidden

do you have an image of the folks in Waterloo? :)

(03 Nov '19, 04:22) Vlad
Be the first one to answer this question!
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:

×51

question asked: 30 Oct '19, 04:55

question was seen: 1,256 times

last updated: 03 Nov '19, 04:22