| Nothing to do with this note, but:
You gurus in Sql Services, would you mind putting together a kind of
technical article "How to debug Sql Services problems"? I mean with the
SDA and ANA/PROC and the undocumented debug flags we should know? I am
running out of pages in my notebook putting information like in .1 down...
Or is there an SQl Services internals support book or some such?
Thanks,
Regina
|
| Hello Simon,
I had the customer try $ ana/proc <filename>/image=sys$system:sqlsrv$exe.
I don't think we got the expected results.
Jerry,
I ran the procedure you gave me. I hope it means something to you. Let
me know what you think
Thanks,
Fred
----------------------------------------------------------------------
CEDAR$ ana/proc SQLSRV$EXE.DMP/image=sys$system:sqlsrv$exe
Condition signalled to take dump:
Improperly handled condition, invalid condition handler procedure
value.
Signal arguments: Number = 00000003
Name = 0000043C
7EDB8094
0000001B
Register dump:
R0 = 0000000000000000 R1 = 000000007ED76DD0 R2 =
0000000000000020
R3 = 000000007EDB8000 R4 = 0000000000003FFF R5 =
000000007ED86C43
R6 = 000000007ED87730 R7 = 000000007ED87684 R8 =
000000007ED87170
R9 = 000000007FF9C400 R10 = 000000007FF9D228 R11 =
000000007FFBE3E0
R12 = 0000000000000000 R13 = 000000007ED76F98 R14 =
0000000000000000
R15 = 000000007ED86000 R16 = 0000000001615ED0 R17 =
0000000001615D70
R18 = 0000000001615F00 R19 = 0000000000000000 R20 =
0000000000000000
R21 = 0000000000000002 R22 = 0000000000000000 R23 =
000000007ED76000
R24 = 0000000000000000 R25 = 0000000000000002 R26 =
FFFFFFFFB083A2BC
R27 = 000000007ED76DD0 R28 = FFFFFFFFB0838570 R29 =
0000000001615D00
SP = 0000000001615CF0 PC = 000000007EDB8094 PS =
300000000000001B
%SYSTEM-F-OPCDEC, opcode reserved to Digital fault at PC=00000000,
PS=0000043C
CEDAR$
|
| Hi Jerry,
Unfortunately, you're right, that wasn't the expected result. What you should
get is a DBG> prompt, at which one can do things like SHOW CALLS, EXAMIME, etc,
etc. (Though clearly a map, plus listings are needed, because there's no
debugging info in the image.) I can't explain why they're getting that error,
except to say that ANA/PROC is EXTREMELY touchy - the slightest whiff of a
problem and it'll blow up in all sorts of weird ways, this being a case in
point. A couple of things to try is to give the process ALL privs and make sure
the executor image isn't installed before issuing the ANA/PROC command. In any
event, see if you can get the .DMP file to us somehow - although we've never
tried it before, we might be able to find the stack and figure out what's going
on. FYI, what you should get is something like this:
Kntavn_1 $ ana/proc SQLSRV_TEST:[VMSAPI3]SQLSRV$EXE.DMP;1/ima=sys$system:sqlsrv$
exe
Condition signalled to take dump:
%SYSTEM-F-ACCVIO, access violation, reason mask=04, virtual address=27327978, PC
=0003AE70, PS=0000001B
OpenVMS Alpha AXP DEBUG Version V6.1-000
%DEBUG-I-NOLOCALS, image does not contain local symbols
%DEBUG-I-NOGLOBALS, some or all global symbols not accessible
%DEBUG-I-NOUNIVERSALS, shareable image contains no universal symbols
%SYSTEM-F-ACCVIO, access violation, reason mask=04, virtual address=27327978, PC
=0003AE70, PS=0000001B
break on unhandled exception at SHARE$SQLSRV$EXE+175728
DBG> show call
module name routine name line rel PC abs PC
*SHARE$SQLSRV$EXE 00000000 0003AE70
*SHARE$SQLSRV$EXE 00000000 000399B8
*SHARE$SQLSRV$EXE 00000000 0003687C
*SHARE$SQLSRV$EXE 00000000 00034FB4
*SHARE$SQLSRV$EXE 00000000 00030D34
*SHARE$SQLSRV$EXE 00000000 00030588
*SHARE$SQLSRV$EXE 00000000 00030080
DBG>
Let us know what you find...
Si
|