Hi all, my MaxDB server (7.5.0 Build 024-123-090-789 on Win2k SP4) seems to have crashed - pls. see the extract of the knldiag.err below - when executing following SQL statement via SQL Studio (7.5.00.18):
alter table TEST_CENTRES modify (PRODUCTION_HOST VARCHAR(15) NOT NULL ,PRODUCTION_DB_NAME VARCHAR(8) NOT NULL) This error is repeatable (so far 3x, always with the same statement). Is this a known bug? Are there any work arounds? kind regards Frank SQL Studio reply: ---- Error ------------------------------- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed General error;800 Implicit SERVERDB restart (connection aborted) alter table TEST_CENTRES modify (PRODUCTION_HOST VARCHAR(15) NOT NULL ,PRODUCTION_DB_NAME VARCHAR(8) NOT NULL) The knldiag.err: 2005-06-07 11:34:42 --- Starting GMT 2005-06-07 11:34:42 7.5.0 Build 024-123-090-789 2005-06-07 11:37:48 0x954 ERR 18006 EXCEPT EXCEPTION:0xc0000005 Addr:0x4d6753 ( 0:0x8:0:0 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SymbolSearchPath: u:\sapdb\db_data\wrk\S_FRANK2;u:\sapdb\svr750024\pgm;u:\sapdb\svr750024\symbols;u:\sapdb\svr7500 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE 24\sap;C:\WINNT;u:\sapdb\svr750024\sap\ 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE ----> Register Dump <---- 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Eax=0x04bf9b01 Ebx=0x04bfe9e4 Ecx=0x00000000 Edx=0x00000000 Esi=0x04bff090 Edi=0x04bfdfc4 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Eip=0x004d6753 Esp=0x04bf99a4 Ebp=0x04bf9b38 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x0038 Gs=0x0000 Efl=0x10202 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE ----> Module List <---- 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE |.text Start |.text End | Module File Name 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x00400000 | 0x009b4000 | u:\sapdb\svr750024\pgm\kernel.exe 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x047e0000 | 0x04895000 | u:\sapdb\svr750024\pgm\dbghelp.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x70a70000 | 0x70ad6000 | C:\WINNT\system32\SHLWAPI.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x71710000 | 0x71794000 | C:\WINNT\system32\COMCTL32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x75020000 | 0x75028000 | C:\WINNT\system32\WS2HELP.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x75030000 | 0x75044000 | C:\WINNT\system32\WS2_32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x75050000 | 0x75058000 | C:\WINNT\system32\WSOCK32.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x75150000 | 0x7515f000 | C:\WINNT\system32\SAMLIB.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x75170000 | 0x751bf000 | C:\WINNT\system32\NETAPI32.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x751c0000 | 0x751c6000 | C:\WINNT\system32\NETRAP.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x759b0000 | 0x759b6000 | C:\WINNT\system32\LZ32.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x76000000 | 0x7600d000 | u:\sapdb\indep_prg\pgm\sqltcp.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x76050000 | 0x760c3000 | u:\sapdb\svr750024\pgm\liboms.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77320000 | 0x77337000 | C:\WINNT\system32\MPRAPI.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77340000 | 0x77353000 | C:\WINNT\system32\iphlpapi.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77360000 | 0x77379000 | C:\WINNT\system32\DHCPCSVC.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77380000 | 0x773a3000 | C:\WINNT\system32\ADSLDPC.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x773b0000 | 0x773df000 | C:\WINNT\system32\ACTIVEDS.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x774c0000 | 0x774d1000 | C:\WINNT\system32\RASMAN.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x774e0000 | 0x77513000 | C:\WINNT\system32\RASAPI32.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77520000 | 0x77525000 | C:\WINNT\system32\ICMP.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77530000 | 0x77552000 | C:\WINNT\system32\TAPI32.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x777f0000 | 0x777f5000 | C:\WINNT\system32\rasadhlp.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77820000 | 0x77827000 | C:\WINNT\system32\VERSION.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77830000 | 0x7783e000 | C:\WINNT\system32\RTUTILS.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77880000 | 0x7790e000 | C:\WINNT\system32\SETUPAPI.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77920000 | 0x77943000 | C:\WINNT\system32\imagehlp.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77950000 | 0x7797a000 | C:\WINNT\system32\WLDAP32.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77980000 | 0x779a4000 | C:\WINNT\system32\DNSAPI.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x779b0000 | 0x77a4b000 | C:\WINNT\system32\OLEAUT32.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77a50000 | 0x77b3f000 | C:\WINNT\system32\ole32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77bf0000 | 0x77c01000 | C:\WINNT\system32\NTDSAPI.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77d30000 | 0x77da1000 | C:\WINNT\system32\RPCRT4.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77e10000 | 0x77e6f000 | C:\WINNT\system32\USER32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77f40000 | 0x77f7b000 | C:\WINNT\system32\GDI32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x77f80000 | 0x77ffd000 | C:\WINNT\system32\ntdll.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x78000000 | 0x78045000 | C:\WINNT\system32\msvcrt.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x782f0000 | 0x78535000 | C:\WINNT\system32\SHELL32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x7c000000 | 0x7c054000 | C:\WINNT\system32\MSVCR70.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x7c0f0000 | 0x7c151000 | C:\WINNT\system32\USERENV.DLL 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x7c2d0000 | 0x7c332000 | C:\WINNT\system32\ADVAPI32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x7c340000 | 0x7c34f000 | C:\WINNT\system32\Secur32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE | 0x7c570000 | 0x7c623000 | C:\WINNT\system32\KERNEL32.dll 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE ----> Stack Back Trace <---- 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!ak13verify_constraint_not_null + 83 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:004d6753 RA:004dd9f9 FP:04bf9b38 SP:04bf9b40 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:01bfe9e4 02:04bfcb28 03:04bfdfdf 04:04bfdf00 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak13.c ( Line: 8772 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!a13_call_semantic + 1241 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:004dd9f9 RA:004c63bb FP:04bfdfd4 SP:04bfdfdc 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:04bfe9e4 02:00000000 03:04bfef28 04:04bfe9e4 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak13.c ( Line: 11253 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!ak35call_semantik + 427 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:004c63bb RA:004c7019 FP:04bfe034 SP:04bfe03c 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:04bfe9e4 02:00000000 03:04bff286 04:04bfe9e4 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak35.c ( Line: 5547 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!a35_asql_statement + 1673 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:004c7019 RA:0058304d FP:04bfe088 SP:04bfe090 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:00bfe9e4 02:00000000 03:04bff286 04:04bfe9e4 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak35.c ( Line: 5231 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!ak92not_only_execute + 1533 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:0058304d RA:00584b21 FP:04bfe1e4 SP:04bfe1ec 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:00bfe9e4 02:04bfe334 03:04bfe34e 04:04bfe30c 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak92.c ( Line: 5286 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!ak92analyze_messagetype + 1377 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:00584b21 RA:00584e57 FP:04bfe340 SP:04bfe348 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:04bfe9e4 02:00000000 03:00000000 04:00000000 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak92.c ( Line: 5670 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!a92_mode_analyzer + 279 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:00584e57 RA:0058a2b8 FP:04bfe420 SP:04bfe428 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:04bfe9e4 02:00000000 03:00000000 04:00000001 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak92.c ( Line: 6344 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!ak93one_command + 1368 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:0058a2b8 RA:0058b476 FP:04bfe52c SP:04bfe534 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:01bfe9e4 02:00000001 03:04bfe590 04:00000001 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak93.c ( Line: 6484 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!a93_user_commands + 1046 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:0058b476 RA:00447766 FP:04bfe5a4 SP:04bfe5ac 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:00bfe9e4 02:04bfe9db 03:04bfe9cf 04:04bfff04 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak93.c ( Line: 5594 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!ak91run_sql_process + 134 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:00447766 RA:00447882 FP:04bfe9d0 SP:04bfe9d8 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:01bfe9e4 02:00000001 03:00000001 04:04ae01a8 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak91.c ( Line: 5397 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!ak91run_user_process + 98 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:00447882 RA:00447919 FP:04bffe7c SP:04bffe84 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:04bfff04 02:00000003 03:7ff300e8 04:04bffeec 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak91.c ( Line: 5425 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!a91mainprogam_with_allocator + 57 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:00447919 RA:006c7e03 FP:04bffe90 SP:04bffe98 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:03bfff04 02:7c578252 03:7feb2960 04:00000000 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak91.c ( Line: 5450 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!gg941CreateAllocatorAndCallMainprog + 211 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:006c7e03 RA:004478b3 FP:04bffeec SP:04bffef4 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:04bfff03 02:04bfff4c 03:0000000c 04:04bfff04 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vgg941.cpp ( Line: 151 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!a91mainprogram + 35 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:004478b3 RA:007b4c6f FP:04bfff78 SP:04bfff80 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:7c578252 02:7c578265 03:7fef6a20 04:00000000 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vak91.c ( Line: 5437 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 191 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:007b4c6f RA:7c57b388 FP:04bfffb4 SP:04bfffbc 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:7fef6a20 02:7c578252 03:7c578265 04:7fef6a20 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Source: vos88k.c ( Line: 437 ) 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE KERNEL32!lstrcmpiW + 183 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:7c57b388 RA:7c57b918 FP:04bfffec SP:04bfffbc 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:007b4bb0 02:7fef6a20 03:00000000 04:00000008 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE KERNEL32!SwitchToFiber + 412 bytes 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:7c57b918 RA:0003a000 FP:04bffee0 SP:04bfffbc 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:00000000 02:04bfff78 03:004478b3 04:04bfff03 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE ?!0003a000 <nosymbols>[rc = 126] 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE SFrame: IP:0003a000 RA:00000000 FP:00000000 SP:04bfffbc 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:00000000 04:00000000 2005-06-07 11:37:48 0x954 ERR 19999 BTRACE No crash dump file 'knlcrash.dmp' written -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
