I'm running MaxDB 7.6.0.34 (Win32) on Windows 2003. When running a long(ish) series of statements from SQL Studio, the kernel crashes, producing this in knldiagerr:
2007-03-23 14:40:48 0xBA4 ERR 18793 EXCEPT EXCEPTION:'Access violation' (0xc0000005), The program code at IP:0x7d929c attempted to read to/from address:0x1d000000 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SymbolSearchPath: d:\var\sdb\data\wrk\ISQI;C:\Programme\sdb\7600\pgm;C:\Programme\sdb\7600\symbols;C:\Programme\sd 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE b\7600\symbols;C:\Programme\sdb\7600\sap;C:\WINDOWS;C:\Programme\sdb\7600\sap\ 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE ----> Register Dump <---- 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Eax=0x00000003 Ebx=0x00000007 Ecx=0x76795adc Edx=0x11bfd701 Esi=0x1d000000 Edi=0x76795acc 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Eip=0x007d929c Esp=0x11bfaf74 Ebp=0x11bfc418 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x10287 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE ----> Module List <---- 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE |.text Start |.text End | Module File Name 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x00400000 | 0x00b79000 | C:\Programme\sdb\7600\pgm\kernel.exe 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x114f0000 | 0x11617000 | C:\Programme\sdb\7600\pgm\liboms.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x11620000 | 0x11676000 | C:\WINDOWS\system32\MSVCR71.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x11690000 | 0x11790000 | C:\Programme\sdb\7600\pgm\dbghelp.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x11890000 | 0x118b8000 | C:\WINDOWS\system32\imagehlp.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x719c0000 | 0x719ca000 | C:\WINDOWS\system32\WSOCK32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x71a00000 | 0x71a08000 | C:\WINDOWS\system32\WS2HELP.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x71a10000 | 0x71a27000 | C:\WINDOWS\system32\WS2_32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x76180000 | 0x7619d000 | C:\WINDOWS\system32\IMM32.DLL 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x76dc0000 | 0x76deb000 | C:\WINDOWS\system32\DNSAPI.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x76e40000 | 0x76e53000 | C:\WINDOWS\system32\Secur32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x76e70000 | 0x76e75000 | C:\WINDOWS\system32\rasadhlp.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x77340000 | 0x77443000 | C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.3959_ 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE : : : x-ww_D8713E55\comctl32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x774f0000 | 0x77629000 | C:\WINDOWS\system32\ole32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x77b70000 | 0x77bca000 | C:\WINDOWS\system32\msvcrt.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x77bd0000 | 0x77c18000 | C:\WINDOWS\system32\GDI32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x77c20000 | 0x77cbf000 | C:\WINDOWS\system32\RPCRT4.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x77e20000 | 0x77eb2000 | C:\WINDOWS\system32\USER32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x77ec0000 | 0x77f12000 | C:\WINDOWS\system32\SHLWAPI.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x77f30000 | 0x77fdb000 | C:\WINDOWS\system32\ADVAPI32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x7c800000 | 0x7c915000 | C:\WINDOWS\system32\kernel32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x7c920000 | 0x7c9e6000 | C:\WINDOWS\system32\ntdll.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE | 0x7c9f0000 | 0x7d1f8000 | C:\WINDOWS\system32\SHELL32.dll 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE ----> Stack Back Trace <---- 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 1538156 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:007d929c RA:007ae488 FP:11bfc418 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:11bfe8f0 02:11bfd710 03:11bfd96c 04:11bfda98 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 1362520 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:007ae488 RA:007ae921 FP:11bfd980 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:11bfe8f0 02:11bfda60 03:11bfde84 04:11bfdad0 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 1363697 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:007ae921 RA:007aeb9b FP:11bfda6c SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:01bfe8f0 02:11bfda98 03:11bfdc40 04:00000002 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 1364331 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:007aeb9b RA:007aec43 FP:11bfdaa8 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:0100e8f0 02:11bfdc40 03:00000002 04:11bfdc40 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 1364499 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:007aec43 RA:007976ce FP:11bfdb68 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:11bfe8f0 02:0000dc40 03:00000002 04:00000001 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 1268894 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:007976ce RA:0084d3ce FP:11bfdb88 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:11bfe8f0 02:11bfdc40 03:00000002 04:00000001 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2013598 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:0084d3ce RA:0084aa5f FP:11bfdc5c SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00bfe8f0 02:11bfde84 03:00000000 04:00000001 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2002991 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:0084aa5f RA:0084d22e FP:11bfdd14 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:11bfe8f0 02:11bfde84 03:000c00d8 04:00000000 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2013182 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:0084d22e RA:0084fc29 FP:11bfde70 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00bfe8f0 02:11bfde84 03:11bfe8f0 04:20002000 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2023929 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:0084fc29 RA:00829512 FP:11bfe040 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:11bfe8f0 02:11bfe8f0 03:00000000 04:11bfee20 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 1866466 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:00829512 RA:0082a210 FP:11bfe08c SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00bfe8f0 02:00000000 03:00000000 04:11bff224 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 1869792 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:0082a210 RA:008d4270 FP:11bfe0e4 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00bfe8f0 02:00000000 03:11bff186 04:00000000 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2566208 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:008d4270 RA:008d612a FP:11bfe218 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00bfe8f0 02:11bfe374 03:11bfe364 04:11bfe340 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2574074 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:008d612a RA:008d6467 FP:11bfe380 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:11bfe8f0 02:00000000 03:00000000 04:00000000 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2574903 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:008d6467 RA:008cdaa5 FP:11bfe3b0 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00bfe8f0 02:00000000 03:00000000 04:00000001 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2539637 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:008cdaa5 RA:008ced0c FP:11bfe438 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00bfe8f0 02:00000001 03:11bfe498 04:00000001 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 2544348 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:008ced0c RA:009925bb FP:11bfe4b0 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00bfe8f0 02:11bfff67 03:11bfe8db 04:7fd580b8 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!DbpErrorBase::operator= + 35659 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??4DbpErrorBase@@[EMAIL PROTECTED]@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: class DbpErrorBase & __thiscall DbpErrorBase::operator=(class DbpErrorBase const &) 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:009925bb RA:00992863 FP:11bfe8dc SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00000000 02:7fd580b8 03:00000000 04:11ae01b8 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!DbpErrorBase::operator= + 36339 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??4DbpErrorBase@@[EMAIL PROTECTED]@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: class DbpErrorBase & __thiscall DbpErrorBase::operator=(class DbpErrorBase const &) 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:00992863 RA:0068adbc FP:11bfff74 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:7fd580b8 02:7fd21770 03:006d8f9f 04:00000000 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel!OmsObjectId::operator!= + 168844 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Deco. : ??9OmsObjectId@@QBE_NABU0@@Z 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE UDeco.: public: bool __thiscall OmsObjectId::operator!=(struct OmsObjectId const &)const 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:0068adbc RA:7c824829 FP:11bfffbc SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:7ee2a1f8 02:00000000 03:00000000 04:7ee2a1f8 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel32!GetModuleHandleA + 223 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:7c824829 RA:7c812575 FP:11bffff0 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:006d8ee0 02:7ee2a1f8 03:00000000 04:00000000 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE kernel32!GlobalReAlloc + 380 bytes 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE SFrame: IP:7c812575 RA:00000000 FP:00000000 SP:11bfaf74 2007-03-23 14:40:48 0xD44 ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:00000000 04:00000000 2007-03-23 14:40:48 0xCF8 ERR 19999 BTRACE Mini dump file 'KnlMini.dmp' written! 2007-03-23 14:40:48 0xBA4 ERR 7 Messages Begin of dump of registered messages 2007-03-23 14:40:48 0xBA4 ERR 8 Messages End of the message list registry dump 2007-03-23 14:40:49 ___ Stopping GMT 2007-03-23 13:40:49 7.6.00 Build 034-123-134-685 The "address" it tried to read looks to me like an overflow of some sort. In addition to 0x1d000000 as above, I've also seen 0x2c000000. I'll be glad to provide the statements leading to this crash, but I'd like to shorten them a bit towards a minimal example. My problem is that I don't know how far I need to go to "reset" the instance so that the next execution will in fact start with a clean database, with no debris from the crash lying around somewhere. Will it be enough to recover from a complete data backup from before it first crashed? Do I need to drop and recreate the whole instance? -- Christian Ullrich -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
