[EMAIL PROTECTED] wrote: > >>I am using SAPDB 7.3.0 build 024-000-000-000 on a Windows > 2000 Server. > >>From time to time, my database instance goes into offline > modus without > >>clear reason. > >>My JDBC Connections receive the following error message: > >> > >> Message:[-807] Connection down, session released > State:08000 No:-807 > > it looks like the "sudden death" phenomenia came out of > sight, but I still > hope for an answer. > Here again is the instances's error log. Do you need more > informations? > > Best Regards, > > R�diger Wei� > > ---------------------- > > 2003-12-02 13:42:56 0x16EC ERR 18006 EXCEPT > EXCEPTION:0xc0000005 > Addr:0x647114 ( 0x1:0x42193037:0:0 ) > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE SymbolSearchPath: > C:\Programme\sapdb\indep_data\wrk\TISADM;C:\PROGRAMME\SAPDB\DE > PEND\pgm;C:\PROGRAMME\SAPDB\DEPEND > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE > \symbols;C:\WINNT;C:\PROGRAMME\SAPDB\DEPEND\sap\ > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE ------> Module List > <------- > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 00400000 > 4710400 > kernel.exe C:\PROGRAMME\SAPDB\DEPEND\pgm\kernel.exe > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77880000 > 528384 > ntdll.dll C:\WINNT\system32\ntdll.dll > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77E00000 > 413696 > USER32.dll C:\WINNT\system32\USER32.dll > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77E70000 > 811008 > KERNEL32.DLL C:\WINNT\system32\KERNEL32.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77F40000 > 245760 > GDI32.DLL C:\WINNT\system32\GDI32.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 79350000 > 401408 > ADVAPI32.dll C:\WINNT\system32\ADVAPI32.dll > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77D20000 > 450560 > RPCRT4.DLL C:\WINNT\system32\RPCRT4.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77580000 > 2416640 > SHELL32.dll C:\WINNT\system32\SHELL32.dll > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 63180000 > 294912 > SHLWAPI.DLL C:\WINNT\system32\SHLWAPI.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 71780000 > 565248 > COMCTL32.DLL C:\WINNT\system32\COMCTL32.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77A40000 > 966656 > ole32.dll C:\WINNT\system32\ole32.dll > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 76000000 > 53248 > sqltcp.dll C:\Programme\sapdb\indep_prog\pgm\sqltcp.dll > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 74FC0000 > 36864 > WSOCK32.dll C:\WINNT\system32\WSOCK32.dll > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 74FA0000 > 81920 > WS2_32.DLL C:\WINNT\system32\WS2_32.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 78000000 > 282624 > MSVCRT.DLL C:\WINNT\system32\MSVCRT.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 74F90000 > 32768 > WS2HELP.DLL C:\WINNT\system32\WS2HELP.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77970000 > 147456 > DNSAPI.DLL C:\WINNT\system32\DNSAPI.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77310000 > 77824 > iphlpapi.dll C:\WINNT\system32\iphlpapi.dll > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 774F0000 > 20480 > ICMP.DLL C:\WINNT\system32\ICMP.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 772F0000 > 94208 > MPRAPI.DLL C:\WINNT\system32\MPRAPI.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 750C0000 > 61440 > SAMLIB.DLL C:\WINNT\system32\SAMLIB.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 750E0000 > 323584 > NETAPI32.DLL C:\WINNT\system32\NETAPI32.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 79430000 > 61440 > SECUR32.DLL C:\WINNT\system32\SECUR32.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 75130000 > 24576 > NETRAP.DLL C:\WINNT\system32\NETRAP.DLL > 2003-12-02 13:42:56 0x16EC ERR 19999 BTRACE 77940000 > 176128 > WLDAP32.DLL C:\WINNT\system32\WLDAP32.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 779A0000 > 634880 > OLEAUT32.DLL C:\WINNT\system32\OLEAUT32.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 77380000 > 196608 > ACTIVEDS.DLL C:\WINNT\system32\ACTIVEDS.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 77350000 > 143360 > ADSLDPC.DLL C:\WINNT\system32\ADSLDPC.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 77820000 > 57344 > RTUTILS.DLL C:\WINNT\system32\RTUTILS.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 78310000 > 593920 > SETUPAPI.DLL C:\WINNT\system32\SETUPAPI.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 791A0000 > 405504 > USERENV.DLL C:\WINNT\system32\USERENV.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 774B0000 > 208896 > RASAPI32.DLL C:\WINNT\system32\RASAPI32.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 77490000 > 69632 > RASMAN.DLL C:\WINNT\system32\RASMAN.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 77500000 > 139264 > TAPI32.DLL C:\WINNT\system32\TAPI32.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 77330000 > 102400 > DHCPCSVC.DLL C:\WINNT\system32\DHCPCSVC.DLL > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 777E0000 > 20480 > rasadhlp.dll C:\WINNT\system32\rasadhlp.dll > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 197F0000 > 299008 > liboms.dll C:\PROGRAMME\SAPDB\DEPEND\pgm\liboms.dll > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 77910000 > 143360 > imagehlp.dll C:\WINNT\system32\imagehlp.dll > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE 72970000 > 184320 > DBGHELP.dll C:\WINNT\system32\DBGHELP.dll > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE module file > name |.text > > start |.text end > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE kernel.exe | > 0x00400000 | 0x0087e000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE liboms.dll | > 0x197f0000 | 0x19839000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SHLWAPI.DLL | > 0x63180000 | 0x631c8000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE COMCTL32.DLL | > 0x71780000 | 0x7180a000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE DBGHELP.dll | > 0x72970000 | 0x7299d000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE WS2HELP.DLL | > 0x74f90000 | 0x74f98000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE WS2_32.DLL | > 0x74fa0000 | 0x74fb4000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE WSOCK32.dll | > 0x74fc0000 | 0x74fc9000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SAMLIB.DLL | > 0x750c0000 | 0x750cf000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE NETAPI32.DLL | > 0x750e0000 | 0x7512f000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE NETRAP.DLL | > 0x75130000 | 0x75136000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE sqltcp.dll | > 0x76000000 | 0x7600d000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE MPRAPI.DLL | > 0x772f0000 | 0x77307000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE iphlpapi.dll | > 0x77310000 | 0x77323000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE DHCPCSVC.DLL | > 0x77330000 | 0x77349000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE ADSLDPC.DLL | > 0x77350000 | 0x77373000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE ACTIVEDS.DLL | > 0x77380000 | 0x773b0000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE RASMAN.DLL | > 0x77490000 | 0x774a1000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE RASAPI32.DLL | > 0x774b0000 | 0x774e3000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE ICMP.DLL | > 0x774f0000 | 0x774f5000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE TAPI32.DLL | > 0x77500000 | 0x77522000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SHELL32.dll | > 0x77580000 | 0x777ce000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE rasadhlp.dll | > 0x777e0000 | 0x777e5000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE RTUTILS.DLL | > 0x77820000 | 0x7782e000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE ntdll.dll | > 0x77880000 | 0x77901000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE imagehlp.dll | > 0x77910000 | 0x77933000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE WLDAP32.DLL | > 0x77940000 | 0x7796b000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE DNSAPI.DLL | > 0x77970000 | 0x77994000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE OLEAUT32.DLL | > 0x779a0000 | 0x77a3b000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE ole32.dll | > 0x77a40000 | 0x77b2c000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE RPCRT4.DLL | > 0x77d20000 | 0x77d8e000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE USER32.dll | > 0x77e00000 | 0x77e65000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE KERNEL32.DLL | > 0x77e70000 | 0x77f36000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE GDI32.DLL | > 0x77f40000 | 0x77f7c000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE MSVCRT.DLL | > 0x78000000 | 0x78045000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SETUPAPI.DLL | > 0x78310000 | 0x783a1000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE USERENV.DLL | > 0x791a0000 | 0x79203000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE ADVAPI32.dll | > 0x79350000 | 0x793b2000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SECUR32.DLL | > 0x79430000 | 0x7943f000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE ----> Stack > Back Trace > <---- > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_kb741synchronize_left_rec + 308 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:00647114 RA:00645ac9 FP:09d833b8 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:09da8c58 02:09d938b4 03:09d84a20 04:09d83820 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_kb741inv_direct_search + 1321 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:00645ac9 RA:00644b47 FP:09d83814 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:09da8c58 02:09d84af4 03:09d88b80 04:09d84210 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_k741better_join + > 199 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:00644b47 RA:00601073 FP:09d84084 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:09da8c58 02:0000001f 03:00000002 04:7fffffff > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_kb74do_better_join > > + 499 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:00601073 RA:00602d07 FP:09d84abc SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:09da8c58 02:09d84af4 03:09d88b80 04:0000001f > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_k74_join_select + > 487 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:00602d07 RA:0044285d FP:09d93db0 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:09da8c58 02:09da8a28 03:09da8c58 04:09da8a28 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_a06lsend_mess_buf > + 477 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:0044285d RA:0044212a FP:09d93de4 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:09da8a28 02:09da8c58 03:00000000 04:09d93e30 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_a06dml_send_mess_buf + 90 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:0044212a RA:005b53fb FP:09d93e04 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:09da8a28 02:09da8c58 03:09d96f50 04:09d93e30 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_a682_execute_join > + 955 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:005b53fb RA:005a6c6b FP:09d94f54 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:09da8a28 02:09d96f50 03:09d9678c 04:09d96b84 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > kernel!_a680_join + > 539 bytes > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:005a6c6b RA:0a3155c4 FP:09d96f50 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:00000000 02:00000000 03:00000000 04:00000000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > SymGetModuleInfo() > failed, rc = 126 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > ?!0a3155c4 <nosymbols> > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE SFrame: > IP:0a3155c4 RA:00000000 FP:00000000 SP:09d833a0 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE Params: > 01:00000000 02:00000000 03:00000000 04:00000000 > 2003-12-02 13:42:57 0x16EC ERR 19999 BTRACE > SymGetLineFromAddr() > failed, rc = 126 > 2003-12-02 13:42:58 0x16EC 19820 EXCEPT calling ak > dump for T16 > 2003-12-02 13:42:58 0x16EC 19624 EXCEPT Kernel aborts > 2003-12-02 13:42:58 0x16EC 19684 TASKING Tracewriter > termination > timeout: 1200 sec > 2003-12-02 13:42:58 0x63C 19617 DEVIO Single I/O attach, > 'knltrace', UKT:1 > 2003-12-02 13:43:27 0x63C 19619 TASKING Releasing > tracewriter > 2003-12-02 13:43:27 0x16EC 19600 VERSION 'Kernel > 7.3.0 Build > 024-000-000-000' > 2003-12-02 13:43:27 0x16EC 19654 DBSTATE SERVERDB 'XXX' has > stopped
Somehow I missed your previous message, sorry for that. It's a known bug but only for a short time and I'm still working on a solution. Status will be reported via http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1126059 As a workaround you could try to change the join transition by creating or dropping some indexes on the involved tables. Kind regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
