From: John Singleton (jsingletjohnsingleton.com)
Date: Mon Nov 01 2004 - 16:40:43 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello All,

Just wanted to report a crash I experienced. I tried to load the
following stored procedure like this:

sqlcli> \i test.sql

the proc:
CREATE DBPROC DBA.test AS
var username varchar(50);
owner varchar(50);
foo int;

TRY
   SELECT * FROM DOMAIN.USERS WHERE USERNAME='DDD';
CATCH
   IF $RC = 100 THEN
   BEGIN
   CONTINUE EXECUTE;
   STOP (-1, 'die');
   END;

During the above slash command, the crash occurred.

Best,
JLS

The dump (7.5.0 BUILD 014-123-073-298)
-----
2004-11-01 17:31:57 0xBC ERR 18006 EXCEPT EXCEPTION:0xc0000005
Addr:0x502628 ( 0x1:0x9513a2aa:0:0 )
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE SymbolSearchPath:
c:\program files\sapdb\indep_data\wrk\CH10;c:\program
files\sapdb\depend\pgm;c:\program files\sa
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE
pdb\depend\symbols;c:\program
files\sapdb\depend\sap;C:\WINDOWS;c:\program files\sapdb\depend\sa
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE p\
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE ----> Register Dump <----
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE Eax=0x0457dd20
Ebx=0x157e9e40 Ecx=0x7f95045c Edx=0x00000037 Esi=0x0457e9e4 Edi=0x7f950738
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE Eip=0x00502628
Esp=0x0457dd10 Ebp=0x0457dd30
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE Cs=0x001b
Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x10202
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE ----> Module List <----
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE |.text Start |.text
End | Module File Name
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x00400000 |
0x00982000 | c:\program files\sapdb\depend\pgm\kernel.exe
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x04790000 |
0x04845000 | c:\program files\sapdb\depend\pgm\dbghelp.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x5d090000 |
0x5d127000 | C:\WINDOWS\system32\comctl32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x71aa0000 |
0x71aa8000 | C:\WINDOWS\system32\WS2HELP.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x71ab0000 |
0x71ac7000 | C:\WINDOWS\system32\WS2_32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x76000000 |
0x7600d000 | c:\program files\sapdb\indep_prog\pgm\sqltcp1.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x76050000 |
0x760b7000 | c:\program files\sapdb\depend\pgm\liboms.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x76c90000 |
0x76cb8000 | C:\WINDOWS\system32\imagehlp.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x76f20000 |
0x76f47000 | C:\WINDOWS\system32\DNSAPI.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x76fc0000 |
0x76fc6000 | C:\WINDOWS\system32\rasadhlp.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x773d0000 |
0x774d2000 |
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE :
: : x-ww_a84f1ff9\comctl32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x774e0000 |
0x7761c000 | C:\WINDOWS\system32\ole32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x77c00000 |
0x77c08000 | C:\WINDOWS\system32\VERSION.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x77c10000 |
0x77c68000 | C:\WINDOWS\system32\msvcrt.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x77d40000 |
0x77dd0000 | C:\WINDOWS\system32\USER32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x77dd0000 |
0x77e6b000 | C:\WINDOWS\system32\ADVAPI32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x77e70000 |
0x77f01000 | C:\WINDOWS\system32\RPCRT4.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x77f10000 |
0x77f56000 | C:\WINDOWS\system32\GDI32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x77f60000 |
0x77fd6000 | C:\WINDOWS\system32\SHLWAPI.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x77fe0000 |
0x77ff1000 | C:\WINDOWS\system32\Secur32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x7c000000 |
0x7c054000 | C:\WINDOWS\system32\MSVCR70.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x7c800000 |
0x7c8f4000 | C:\WINDOWS\system32\kernel32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x7c900000 |
0x7c9b0000 | C:\WINDOWS\system32\ntdll.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE | 0x7c9c0000 |
0x7d1d4000 | C:\WINDOWS\system32\SHELL32.dll
2004-11-01 17:31:57 0xBC ERR 19999 BTRACE ----> Stack Back Trace
<----
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak201CaseStatement + 856 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00502628 RA:005029c2 FP:0457dd30 SP:0457dd38
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0157e9e4 02:00000000 03:00000000 04:00000000
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vak201.c ( Line: 6068 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak201statement + 754 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:005029c2 RA:00503450 FP:0457ddbc SP:0457ddc4
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0157e9e4 02:00000000 03:00000000 04:00000000
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vak201.c ( Line: 5743 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak201statement_list + 64 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00503450 RA:00503574 FP:0457dde0 SP:0457dde8
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0e57e9e4 02:00000000 03:00000000 04:00000000
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vak201.c ( Line: 5555 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak201DbProcBody + 100 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00503574 RA:005038e5 FP:0457de30 SP:0457de38
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0007e9e4 02:7f9504aa 03:00950d64 04:7f950468
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vak201.c ( Line: 6276 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!a201create_dbproc + 869 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:005038e5 RA:005302e5 FP:0457de7c SP:0457de84
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0057e9e4 02:0000006c 03:00000000 04:7f950468
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vak201.c ( Line: 5062 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!a20acreate_statement + 389 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:005302e5 RA:0051a324 FP:0457dec8 SP:0457ded0
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0457e9e4 02:7f950468 03:0000006c 04:00000000
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak20.c
( Line: 5293 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak351create_statement + 196 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:0051a324 RA:0051c9ab FP:0457deec SP:0457def4
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0057e9e4 02:7f950468 03:0457f448 04:0457df4c
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vak351.c ( Line: 5692 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE kernel!a351syntax +
731 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:0051c9ab RA:004c1162 FP:0457df00 SP:0457df08
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0457e9e4 02:00000054 03:00000000 04:0000012f
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vak351.c ( Line: 5100 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!a35_asql_statement + 770 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:004c1162 RA:00462ef9 FP:0457df4c SP:0457df54
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0057e9e4 02:00000000 03:044701a8 04:0457e9e4
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak35.c
( Line: 5082 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak07find_keywords + 953 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00462ef9 RA:00464a58 FP:0457e0d4 SP:0457e0dc
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0457e9e4 02:0457e2bc 03:0457e424 04:0457ec69
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak07.c
( Line: 5828 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!a07_intern_error_put + 1144 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00464a58 RA:005940ca FP:0457e428 SP:0457e430
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0457e9e4 02:00000001 03:00000001 04:0457e9e4
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak07.c
( Line: 5357 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak93one_command + 2890 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:005940ca RA:00594bc6 FP:0457e52c SP:0457e534
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0157e9e4 02:00000001 03:0457e590 04:00000001
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak93.c
( Line: 6661 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!a93_user_commands + 1046 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00594bc6 RA:00442756 FP:0457e5a4 SP:0457e5ac
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0057e9e4 02:0457e9db 03:0457e9cf 04:0457ff04
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak93.c
( Line: 5583 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak91run_sql_process + 134 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00442756 RA:00442872 FP:0457e9d0 SP:0457e9d8
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0157e9e4 02:00000001 03:00000001 04:7f952510
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak91.c
( Line: 5385 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!ak91run_user_process + 98 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00442872 RA:00442909 FP:0457fe7c SP:0457fe84
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0457ff04 02:00000003 03:7fefff48 04:0457feec
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak91.c
( Line: 5413 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!a91mainprogam_with_allocator + 57 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:00442909 RA:006b2173 FP:0457fe90 SP:0457fe98
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0357ff04 02:7c910340 03:7feae328 04:00000000
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak91.c
( Line: 5438 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!gg941CreateAllocatorAndCallMainprog + 211 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:006b2173 RA:004428a3 FP:0457feec SP:0457fef4
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0457ff03 02:0457ff4c 03:0000000c 04:0457ff04
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vgg941.cpp ( Line: 136 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!a91mainprogram + 35 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:004428a3 RA:0079bb6f FP:0457ff78 SP:0457ff80
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:7c910340 02:7c910331 03:7fed8260 04:00000000
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source: vak91.c
( Line: 5425 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel!sql88k_kernel_fiber + 191 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:0079bb6f RA:7c80b50b FP:0457ffb4 SP:0457ffbc
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:7fed8260 02:7c910340 03:7c910331 04:7fed8260
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Source:
vos88k.c ( Line: 430 )
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel32!GetModuleFileNameA + 436 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:7c80b50b RA:7c825bc4 FP:0457ffec SP:0457ffbc
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:0079bab0 02:7fed8260 03:00000000 04:00000000
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE
kernel32!ConvertThreadToFiber + 147 bytes
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:7c825bc4 RA:0003c000 FP:0457fee0 SP:0457ffbc
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:00000000 02:0457ff78 03:004428a3 04:0457ff03
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE ?!0003c000
<nosymbols>[rc = 126]
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE SFrame:
IP:0003c000 RA:00000000 FP:00000000 SP:0457ffbc
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE Params:
01:00000000 02:00000000 03:00000000 04:00000000
2004-11-01 17:31:59 0xBC ERR 19999 BTRACE No crash dump file
'knlcrash.dmp' written

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]