Frank Schimmelpfennig wrote: > > 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?
After some private communication we could reproduce the problem. It occurs because the alter table mentioned triggers some trigger. These destroy some info unexpectedly and the alter table afterwards uses this 'destroyed' info with the result: core. A workaround? Get rid of the trigger for the time of the alter table. Mhm, I see, this is no nice workaround, but the only one I know. Sorry. We will fix the bug as soon as possible. Elke SAP Labs Berlin > > 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\ sy > mbols;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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
