Jason T Marcotte wrote: > > Running DBMServer 7.4.3 Build 017-123-039-277 on Windows > XP, I receive > the following error when performing any select against a given table. > Interestingly enough, this seems very similar to an issue I raised a > couple months ago..... > http://listserv.sap.com/pipermail/sapdb.general/2003-July/0222 46.html .
It would be a good idea to use the newest kernel 7.4.3.25 and check if this error occurs there, too. We fixed bugs which may result in the error described. Please let us know, if in that new version this error is still there. If yes, please provide table definition/index/view definition and the full select. Elke SAP Labs Berlin > After applying the fix from my previous problem (reducing the > number of > Data and Log files to 1), this problem has come up - and the kernel > crashes when selecting against the same table as before. > There's nothing > unusual about this table - I'm guessing it is simply the > placement on the > disk or in memory that has remained unchanged. > > 2003-07-24 13:36:53 --- Starting GMT > 2003-07-24 13:36:53 7.4.3 Build 017-123-039-277 > 2003-07-24 13:42:19 0x410 ERR 18006 EXCEPT > EXCEPTION:0xc0000005 > Addr:0x454527 ( 0:0x52430a54:0:0 ) > 2003-07-24 13:42:19 0x410 ERR 19999 BTRACE SymbolSearchPath: > c:\Program Files\sapdb\indep_data\wrk\ECLIPSE;C:\PROGRAM > FILES\SAPDB\DEPEND\pgm;C:\PROGRAM FILES > 2003-07-24 13:42:19 0x410 ERR 19999 BTRACE > \SAPDB\DEPEND\symbols;C:\PROGRAM > FILES\SAPDB\DEPEND\sap;C:\WINDOWS;C:\PROGRAM FILES\SAPDB\DEPEND > 2003-07-24 13:42:19 0x410 ERR 19999 BTRACE > \sap\ > 2003-07-24 13:42:19 0x410 ERR 19999 BTRACE ----> Register Dump > <---- > 2003-07-24 13:42:19 0x410 ERR 19999 BTRACE Eax=0x52430a54 > Ebx=0x7a76a050 Ecx=0xfffffe0d Edx=0x7f8cd101 Esi=0x7f8cd16c > Edi=0x7a76a050 > 2003-07-24 13:42:19 0x410 ERR 19999 BTRACE Eip=0x00454527 > Esp=0x048c5714 Ebp=0x048c5720 > 2003-07-24 13:42:19 0x410 ERR 19999 BTRACE Cs=0x001b > Ss=0x0023 > Ds=0x0023 Es=0x0023 Fs=0x0038 Gs=0x0000 Efl=0x10282 > 2003-07-24 13:42:19 0x410 ERR 19999 BTRACE ----> > Module List <---- > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE |.text > Start |.text End > | Module File Name > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x00400000 | > 0x008b9000 | C:\PROGRAM FILES\SAPDB\DEPEND\pgm\kernel.exe > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x04ae0000 | > 0x04b34000 | C:\WINDOWS\System32\MSVCR70.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x04b50000 | > 0x04c05000 | C:\PROGRAM FILES\SAPDB\DEPEND\pgm\dbghelp.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x10000000 | > 0x10053000 | C:\PROGRAM FILES\SAPDB\DEPEND\pgm\liboms.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x70a70000 | > 0x70ad4000 | C:\WINDOWS\system32\SHLWAPI.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x71950000 | > 0x71a34000 | > C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b6 > 4144ccf1df_6.0.10.0_x-ww_ > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > | > f7fb5805\comctl32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x71aa0000 | > 0x71aa8000 | C:\WINDOWS\System32\WS2HELP.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x71ab0000 | > 0x71ac5000 | C:\WINDOWS\System32\WS2_32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x76000000 | > 0x7600d000 | c:\Program Files\sapdb\indep_prog\pgm\sqltcp.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x76c90000 | > 0x76cb2000 | C:\WINDOWS\system32\imagehlp.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x76f20000 | > 0x76f45000 | C:\WINDOWS\System32\DNSAPI.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x76f90000 | > 0x76fa0000 | C:\WINDOWS\System32\Secur32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x76fc0000 | > 0x76fc5000 | C:\WINDOWS\System32\rasadhlp.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x771b0000 | > 0x772d1000 | C:\WINDOWS\system32\ole32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x77340000 | > 0x773cb000 | C:\WINDOWS\system32\comctl32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x773d0000 | > 0x77bc7000 | C:\WINDOWS\system32\SHELL32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x77c00000 | > 0x77c07000 | C:\WINDOWS\system32\VERSION.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x77c10000 | > 0x77c63000 | C:\WINDOWS\system32\msvcrt.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x77c70000 | > 0x77cb0000 | C:\WINDOWS\system32\GDI32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x77d40000 | > 0x77dcc000 | C:\WINDOWS\system32\USER32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x77dd0000 | > 0x77e5d000 | C:\WINDOWS\system32\ADVAPI32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x77e60000 | > 0x77f46000 | C:\WINDOWS\system32\kernel32.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x77f50000 | > 0x77ff7000 | C:\WINDOWS\System32\ntdll.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE | 0x78000000 | > 0x78086000 | C:\WINDOWS\system32\RPCRT4.dll > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE ----> Stack > Back Trace > <---- > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a06find_colinfo + > 71 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:00454527 RA:005cc66c FP:048c5720 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:7f8cd16c 02:7a76a050 03:048c5f4c 04:048c87c0 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_ak723analyze_output + 508 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:005cc66c RA:005cc8ee FP:048c5f5c SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048de1a0 02:048cc688 03:048c87c0 04:048cbfdc > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a723analyse_used_cols + 30 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:005cc8ee RA:005b8eae FP:048c5f90 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048de1a0 02:048cc688 03:048c87c0 04:048cbfdc > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a70strategy + > 702 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:005b8eae RA:005b7f8f FP:048cbfa0 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048de1a0 02:048cc688 03:048cbfdc 04:048cc204 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a70_strategy_search + 1359 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:005b7f8f RA:00577fc4 FP:048cc22c SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048de1a0 02:048cc688 03:048cc584 04:048cc65c > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a67_sel2_second_part + 644 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:00577fc4 RA:00578d1f FP:048cc26c SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048de1a0 02:048cc688 03:048cc584 04:00000001 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a67_s_sel_second_part + 143 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:00578d1f RA:00592a1f FP:048cc29c SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048de1a0 02:048cc688 03:008cc584 04:048cc65c > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a660_query_execute > + 5807 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:00592a1f RA:00592f7e FP:048cc618 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:00000000 02:048cc688 03:00000020 04:00000001 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a660select + > 478 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:00592f7e RA:00593335 FP:048cc664 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048de1a0 02:00000001 03:048cc688 04:048dd9da > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a660_select + > 773 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:00593335 RA:004b4a67 FP:048dd9dc SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:008de1a0 02:00000001 03:00000000 04:048de1a0 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_ak35call_semantik > + 1255 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:004b4a67 RA:004b5f64 FP:048dda14 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:008de1a0 02:003f0200 03:ffffe49d 04:048de1a0 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a35_asql_statement > + 3636 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:004b5f64 RA:0056a487 FP:048dda60 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:008de1a0 02:003f01c8 03:00000001 04:048de1a0 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_ak92not_only_execute + 1687 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:0056a487 RA:0056b6bf FP:048ddb18 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:008de1a0 02:048ddc28 03:048ddc3e 04:048ddc08 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_ak92analyze_messagetype + 1103 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:0056b6bf RA:0056b8fd FP:048ddc30 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048de1a0 02:00000000 03:00000000 04:00000000 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a92_mode_analyzer > + 205 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:0056b8fd RA:0057e5f6 FP:048ddc78 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:028de1a0 02:00000000 03:00000000 04:00000001 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_ak93one_command + > 982 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:0057e5f6 RA:0057f356 FP:048ddce0 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:008de1a0 02:00000001 03:003f01c8 04:00000001 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a93_user_commands > + 758 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:0057f356 RA:004342e5 FP:048ddd6c SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:008de1a0 02:048de18f 03:048de19b 04:048dff14 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_ak91run_sql_process + 85 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:004342e5 RA:004343f1 FP:048de190 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:008de1a0 02:048dff14 03:003f01a8 04:003f02b0 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_ak91run_user_process + 225 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:004343f1 RA:00434439 FP:048df7b8 SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:048dff14 02:00000003 03:048dff14 04:048dfefc > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE > kernel!_a91mainprogam_with_allocator + 57 bytes > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE SFrame: > IP:00434439 RA:0069e44c FP:048df7cc SP:048c5714 > 2003-07-24 13:42:20 0x410 ERR 19999 BTRACE Params: > 01:038dff14 02:77f5150c 03:7fee4dd8 04:007b3900 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE > kernel!_gg941CreateAllocatorAndCallMainprog + 124 bytes > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE SFrame: > IP:0069e44c RA:00434468 FP:048dfefc SP:048c5714 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE Params: > 01:048dff03 02:048dff5c 03:0000000c 04:048dff14 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE > kernel!_a91mainprogram > + 40 bytes > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE SFrame: > IP:00434468 RA:006ee08f FP:048dff78 SP:048c5714 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE Params: > 01:77f5150c 02:77f51502 03:7ff6ad58 04:00000000 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE > [EMAIL PROTECTED] + 191 bytes > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE SFrame: > IP:006ee08f RA:77e7d33b FP:048dffb4 SP:048c5714 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE Params: > 01:7ff6ad58 02:77f5150c 03:77f51502 04:7ff6ad58 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE > kernel32!RegisterWaitForInputIdle + 67 bytes > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE SFrame: > IP:77e7d33b RA:77e746cf FP:048dffec SP:048c5714 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE Params: > 01:006edfd0 02:7ff6ad58 03:00000000 04:00000000 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE > kernel32!ConvertThreadToFiber + 137 bytes > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE SFrame: > IP:77e746cf RA:7ff6ad58 FP:048dfef0 SP:048c5714 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE Params: > 01:77f5150c 02:048dff78 03:00434468 04:048dff03 > > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE > SymGetModuleInfo() > failed, rc = 126 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE > ?!7ff6ad58 <nosymbols> > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE SFrame: > IP:7ff6ad58 RA:00000000 FP:00000101 SP:048c5714 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE Params: > 01:00000000 02:00000000 03:00000000 04:00000000 > 2003-07-24 13:42:21 0x410 ERR 19999 BTRACE > SymGetLineFromAddr() > failed, rc = 126 > 2003-07-24 13:42:21 0x410 ERR 20000 INFO No crash dump file > 'knlcrash.dmp' written > 2003-07-24 13:44:50 --- Starting GMT > 2003-07-24 13:44:50 7.4.3 Build 017-123-039-277 > 2003-07-24 13:50:23 --- Starting GMT > 2003-07-24 13:50:23 7.4.3 Build 017-123-039-277 > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
