on 10-27-2008 2:46 PM
MaxDB 7.6.05.09 Kernel aborts - EXCEPTION:'Access violation' (0xc0000005)
Hello
I have been running MaxDB 7.6.05.09 on Windows Server 2003 SP2 for a few weeks with no problems. In the last week the kernel has aborted twice with EXCEPTION:'Access violation' (0xc0000005).
Here is the output from the knldiag.err:
2008-09-12 17:26:56 --- Starting GMT 2008-09-12 15:26:56 7.5.0 Build 026-123-094-430
2008-09-12 17:28:20 ___ Stopping GMT 2008-09-12 15:28:20 7.5.0 Build 026-123-094-430
2008-09-12 17:30:51 --- Starting GMT 2008-09-12 15:30:51 7.5.0 Build 026-123-094-430
2008-09-15 16:30:47 ___ Stopping GMT 2008-09-15 14:30:47 7.5.0 Build 026-123-094-430
2008-09-15 16:57:58 --- Starting GMT 2008-09-15 14:57:58 7.6.05 Build 009-123-191-997
2008-09-19 07:16:16 0x1254 ERR 18431 MESSAGES Could not write to event log, rc = 5
2008-09-19 07:16:17 ___ Stopping GMT 2008-09-19 05:16:17 7.6.05 Build 009-123-191-997
2008-09-19 07:43:58 --- Starting GMT 2008-09-19 05:43:58 7.6.05 Build 009-123-191-997
2008-09-19 14:15:22 ___ Stopping GMT 2008-09-19 12:15:22 7.6.05 Build 009-123-191-997
2008-09-19 14:15:26 --- Starting GMT 2008-09-19 12:15:26 7.6.05 Build 009-123-191-997
2008-10-15 16:49:23 0x90 ERR 18431 MESSAGES Could not write to event log, rc = 5
2008-10-15 16:49:24 ___ Stopping GMT 2008-10-15 14:49:24 7.6.05 Build 009-123-191-997
2008-10-15 17:31:27 --- Starting GMT 2008-10-15 15:31:27 7.6.05 Build 009-123-191-997
2008-10-17 16:41:56 0x4D4 ERR 18431 MESSAGES Could not write to event log, rc = 5
2008-10-17 16:41:57 ___ Stopping GMT 2008-10-17 14:41:57 7.6.05 Build 009-123-191-997
2008-10-17 16:53:09 --- Starting GMT 2008-10-17 14:53:09 7.6.05 Build 009-123-191-997
2008-10-22 16:15:12 0x544 ERR 18431 MESSAGES Could not write to event log, rc = 5
2008-10-22 16:15:13 ___ Stopping GMT 2008-10-22 14:15:13 7.6.05 Build 009-123-191-997
2008-10-22 16:19:03 --- Starting GMT 2008-10-22 14:19:03 7.6.05 Build 009-123-191-997
2008-10-22 17:31:44 0xA10 ERR 18793 EXCEPT EXCEPTION:'Access violation' (0xc0000005), The program code at IP:0x8eadba attempted to read to/from address:0x7c30d000
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE SymbolSearchPath: D:\Program-Files\sapdb\indep_data\wrk\P01;D:\PROGRAM-FILES\SAPDB\DEPEND\pgm;D:\PROGRAM-FILES\SAP
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE DB\DEPEND\symbols;D:\Program-Files\sapdb\depend\symbols;D:\Program-Files\sapdb\depend\sap;C:\WIN
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE DOWS;D:\Program-Files\sapdb\depend\sap\
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE ----> Register Dump <----
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE Eax=0x0a01035c Ebx=0x0a016a4c Ecx=0x00000001 Edx=0x0a01eb5c Esi=0x7c30d000 Edi=0x0a0103ec
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE Eip=0x008eadba Esp=0x0a010350 Ebp=0x0a0103f0
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x10202
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE ----> Module List <----
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE |.text Start |.text End | Module File Name
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x00400000 | 0x00b80000 | D:\PROGRAM-FILES\SAPDB\DEPEND\pgm\kernel.exe
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x0ab20000 | 0x0ab76000 | C:\WINDOWS\system32\MSVCR71.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x0ab90000 | 0x0ac90000 | D:\PROGRAM-FILES\SAPDB\DEPEND\pgm\dbghelp.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x71b20000 | 0x71b61000 | C:\WINDOWS\System32\mswsock.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x71bb0000 | 0x71bb9000 | C:\WINDOWS\system32\WSOCK32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x71bf0000 | 0x71bf8000 | C:\WINDOWS\system32\WS2HELP.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x71c00000 | 0x71c17000 | C:\WINDOWS\system32\WS2_32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x76050000 | 0x76188000 | D:\Program-Files\sapdb\depend\pgm\liboms.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x76c10000 | 0x76c39000 | C:\WINDOWS\system32\imagehlp.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x76ed0000 | 0x76ef9000 | C:\WINDOWS\system32\DNSAPI.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x76f10000 | 0x76f3e000 | C:\WINDOWS\system32\WLDAP32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x76f50000 | 0x76f63000 | C:\WINDOWS\system32\Secur32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x76f70000 | 0x76f77000 | C:\WINDOWS\System32\winrnr.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x76f80000 | 0x76f85000 | C:\WINDOWS\system32\rasadhlp.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77380000 | 0x77412000 | C:\WINDOWS\system32\USER32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77420000 | 0x77523000 | C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.1830_
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE : : : x-ww_7AE38CCF\comctl32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77670000 | 0x777a4000 | C:\WINDOWS\system32\ole32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77ba0000 | 0x77bfa000 | C:\WINDOWS\system32\msvcrt.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77c00000 | 0x77c48000 | C:\WINDOWS\system32\GDI32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77c50000 | 0x77cef000 | C:\WINDOWS\system32\RPCRT4.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77da0000 | 0x77df2000 | C:\WINDOWS\system32\SHLWAPI.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77e40000 | 0x77f42000 | C:\WINDOWS\system32\kernel32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x77f50000 | 0x77fec000 | C:\WINDOWS\system32\ADVAPI32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x7c800000 | 0x7c8c0000 | C:\WINDOWS\system32\ntdll.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE | 0x7c8d0000 | 0x7d0d3000 | C:\WINDOWS\system32\SHELL32.dll
2008-10-22 17:31:45 0x98C ERR 19999 BTRACE ----> Stack Back Trace <----
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!ak505release_longlit_rec + 42 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008eadba RA:008eed5c FP:0a0103f0 SP:0a0103f8
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a01eb5c 04:0a016a4c
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak505.c ( Line: 5896 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a505most_execute + 4876 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008eed5c RA:008ef104 FP:0a010588 SP:0a010590
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:2a01e8ec 02:0a016a4c 03:0a015a28 04:0a01312c
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak505.c ( Line: 6752 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a505loop_most_execute + 852 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008ef104 RA:008c9413 FP:0a010768 SP:0a010770
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a015a28 04:0a012fe4
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak505.c ( Line: 6028 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a501exec_with_change_rec + 931 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008c9413 RA:008d8e87 FP:0a01302c SP:0a013034
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a01312c 04:0a015a28
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak501.c ( Line: 5438 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a502complex_execution + 1031 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008d8e87 RA:008c9309 FP:0a013150 SP:0a013158
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0001e8ec 02:0a016a4c 03:0a015a28 04:0a01e02c
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak502.c ( Line: 5398 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a501exec_with_change_rec + 665 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008c9309 RA:008c96fb FP:0a015a04 SP:0a015a0c
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a01e02c 04:0a015a28
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak501.c ( Line: 5398 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a501do_execute + 75 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008c96fb RA:008e6ed6 FP:0a016a2c SP:0a016a34
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a01e02c 04:00000000
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak501.c ( Line: 5488 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a562_select_insert + 534 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008e6ed6 RA:0084e883 FP:0a01e040 SP:0a01e048
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0001e8ec 02:0a01e8ec 03:00000000 04:0a01ee1c
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak562.c ( Line: 7313 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!ak35call_semantik + 867 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:0084e883 RA:0084f590 FP:0a01e08c SP:0a01e094
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0001e8ec 02:00000000 03:00000000 04:0a01f220
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak35.c ( Line: 5824 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a35_asql_statement2 + 2304 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:0084f590 RA:008fb71c FP:0a01e0e4 SP:0a01e0ec
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0001e8ec 02:00000000 03:0a01f182 04:00000000
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak35.c ( Line: 5412 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!ak92not_only_execute + 1804 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008fb71c RA:008fd529 FP:0a01e218 SP:0a01e220
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0001e8ec 02:0a01e370 03:0a01e360 04:0a01e340
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak92.c ( Line: 5406 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!ak92analyze_messagetype + 1545 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008fd529 RA:008fd887 FP:0a01e37c SP:0a01e384
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0a01e8ec 02:00000000 03:00000000 04:00000000
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak92.c ( Line: 5882 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a92_mode_analyzer + 151 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008fd887 RA:008f4ea5 FP:0a01e3ac SP:0a01e3b4
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0001e8ec 02:00000000 03:00000000 04:00000001
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak92.c ( Line: 6615 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!ak93one_command + 1413 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008f4ea5 RA:008f6151 FP:0a01e434 SP:0a01e43c
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0101e8ec 02:00000001 03:0a01e494 04:00000001
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak93.c ( Line: 6664 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!a93_user_commands + 1073 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:008f6151 RA:009c5d9b FP:0a01e4ac SP:0a01e4b4
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:0001e8ec 02:0a01ff63 03:0a01e8d7 04:7ff39fd8
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vak93.c ( Line: 5720 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!SQLTask + 123 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:009c5d9b RA:009c6043 FP:0a01e8d8 SP:0a01e8e0
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:00000000 02:7ff39fd8 03:00000000 04:00000000
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 109 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!Kernel_Main + 547 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:009c6043 RA:006accfc FP:0a01ff70 SP:0a01ff78
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:7ff39fd8 02:7ff028c8 03:006fc783 04:00000000
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 206 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!RTETask_TaskMain + 76 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:006accfc RA:006fc783 FP:0a01ff7c SP:0a01ff84
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:7fb58af8 04:00000000
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 339 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:006fc783 RA:77e66063 FP:0a01ffbc SP:0a01ffc4
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:7fb58af8 02:00000000 03:00000000 04:7fb58af8
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Source: vos88k.cpp ( Line: 484 )
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel32!GetModuleFileNameA + 235 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:77e66063 RA:77e4d216 FP:0a01fff0 SP:0a01ffc4
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:006fc630 02:7fb58af8 03:00009000 04:00000004
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE kernel32!ConvertFiberToThread + 177 bytes
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE SFrame: IP:77e4d216 RA:00000000 FP:00000000 SP:0a01ffc4
2008-10-22 17:31:47 0x98C ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:00000000 04:00000000
2008-10-22 17:31:47 0x148 ERR 19999 BTRACE Mini dump file 'KnlMini.dmp' written!
2008-10-22 17:31:47 0xA10 ERR 7 Messages Begin of dump of registered messages
2008-10-22 17:31:47 0xA10 ERR 8 Messages End of the message list registry dump
2008-10-22 17:31:48 0xA10 ERR 51105 AK CACHE AK00001.dmp written: 0
2008-10-22 17:31:59 0x9FC ERR 18491 IO file/tape/pipe write error, rc = 112
2008-10-22 17:32:05 ___ Stopping GMT 2008-10-22 15:32:05 7.6.05 Build 009-123-191-997
2008-10-23 08:10:39 --- Starting GMT 2008-10-23 06:10:39 7.6.05 Build 009-123-191-997
2008-10-24 03:03:18 0x678 ERR 18431 MESSAGES Could not write to event log, rc = 5
2008-10-24 03:03:19 ___ Stopping GMT 2008-10-24 01:03:19 7.6.05 Build 009-123-191-997
2008-10-24 03:06:31 --- Starting GMT 2008-10-24 01:06:31 7.6.05 Build 009-123-191-997
2008-10-24 19:49:48 0x80C ERR 18498 IO Error on 'E:\Logs\P01\Offline\Log.11375', not enough space on disk
2008-10-24 19:49:48 0x8C4 ERR 1 Backup Backupmedium #1 (E:\Logs\P01\Offline\Log.11375) not enough space on the disk. [112]
2008-10-24 19:49:48 0x8C4 ERR 6 KernelCo + Backup error occured, Error code 3700 "hostfile_error"
2008-10-25 05:38:19 0x129C ERR 18498 IO Error on 'E:\Logs\P01\Offline\Log.11393', not enough space on disk
2008-10-25 05:38:19 0x8C4 ERR 1 Backup Backupmedium #1 (E:\Logs\P01\Offline\Log.11393) not enough space on the disk. [112]
2008-10-25 05:38:19 0x8C4 ERR 6 KernelCo + Backup error occured, Error code 3700 "hostfile_error"
2008-10-26 05:30:05 0x1450 ERR 18498 IO Error on 'E:\Logs\P01\Offline\Log.11394', not enough space on disk
2008-10-26 05:30:05 0x8D0 ERR 52012 SAVE error occured, basis_err 3700
2008-10-26 05:30:08 0x388 ERR 18498 IO Error on 'E:\Logs\P01\Offline\Log.11395', not enough space on disk
2008-10-26 05:30:08 0x8C4 ERR 1 Backup Backupmedium #1 (E:\Logs\P01\Offline\Log.11395) not enough space on the disk. [112]
2008-10-26 05:30:08 0x8C4 ERR 6 KernelCo + Backup error occured, Error code 3700 "hostfile_error"
2008-10-27 05:30:03 0x113C ERR 18498 IO Error on 'E:\Logs\P01\Offline\Log.11396', not enough space on disk
2008-10-27 05:30:03 0x8D0 ERR 52012 SAVE error occured, basis_err 3700
2008-10-27 05:30:06 0x1538 ERR 18498 IO Error on 'E:\Logs\P01\Offline\Log.11397', not enough space on disk
2008-10-27 05:30:06 0x8C4 ERR 1 Backup Backupmedium #1 (E:\Logs\P01\Offline\Log.11397) not enough space on the disk. [112]
2008-10-27 05:30:06 0x8C4 ERR 6 KernelCo + Backup error occured, Error code 3700 "hostfile_error"
2008-10-27 12:17:35 0x8D0 ERR 18793 EXCEPT EXCEPTION:'Access violation' (0xc0000005), The program code at IP:0x8eadba attempted to read to/from address:0x11a1d000
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE SymbolSearchPath: D:\Program-Files\sapdb\indep_data\wrk\P01;D:\PROGRAM-FILES\SAPDB\DEPEND\pgm;D:\PROGRAM-FILES\SAP
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE DB\DEPEND\symbols;D:\Program-Files\sapdb\depend\symbols;D:\Program-Files\sapdb\depend\sap;C:\WIN
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE DOWS;D:\Program-Files\sapdb\depend\sap\
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE ----> Register Dump <----
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE Eax=0x0a01035c Ebx=0x0a016a4c Ecx=0x00000005 Edx=0x0a01eb5c Esi=0x11a1d000 Edi=0x0a0103dc
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE Eip=0x008eadba Esp=0x0a010350 Ebp=0x0a0103f0
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x10202
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE ----> Module List <----
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE |.text Start |.text End | Module File Name
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x00400000 | 0x00b80000 | D:\PROGRAM-FILES\SAPDB\DEPEND\pgm\kernel.exe
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x0ab20000 | 0x0ab76000 | C:\WINDOWS\system32\MSVCR71.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x0ab90000 | 0x0ac90000 | D:\PROGRAM-FILES\SAPDB\DEPEND\pgm\dbghelp.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x71b20000 | 0x71b61000 | C:\WINDOWS\System32\mswsock.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x71bb0000 | 0x71bb9000 | C:\WINDOWS\system32\WSOCK32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x71bf0000 | 0x71bf8000 | C:\WINDOWS\system32\WS2HELP.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x71c00000 | 0x71c17000 | C:\WINDOWS\system32\WS2_32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x76050000 | 0x76188000 | D:\Program-Files\sapdb\depend\pgm\liboms.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x76c10000 | 0x76c39000 | C:\WINDOWS\system32\imagehlp.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x76ed0000 | 0x76ef9000 | C:\WINDOWS\system32\DNSAPI.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x76f10000 | 0x76f3e000 | C:\WINDOWS\system32\WLDAP32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x76f50000 | 0x76f63000 | C:\WINDOWS\system32\Secur32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x76f70000 | 0x76f77000 | C:\WINDOWS\System32\winrnr.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x76f80000 | 0x76f85000 | C:\WINDOWS\system32\rasadhlp.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77380000 | 0x77412000 | C:\WINDOWS\system32\USER32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77420000 | 0x77523000 | C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.1830_
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE : : : x-ww_7AE38CCF\comctl32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77670000 | 0x777a4000 | C:\WINDOWS\system32\ole32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77ba0000 | 0x77bfa000 | C:\WINDOWS\system32\msvcrt.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77c00000 | 0x77c48000 | C:\WINDOWS\system32\GDI32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77c50000 | 0x77cef000 | C:\WINDOWS\system32\RPCRT4.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77da0000 | 0x77df2000 | C:\WINDOWS\system32\SHLWAPI.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77e40000 | 0x77f42000 | C:\WINDOWS\system32\kernel32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x77f50000 | 0x77fec000 | C:\WINDOWS\system32\ADVAPI32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x7c800000 | 0x7c8c0000 | C:\WINDOWS\system32\ntdll.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE | 0x7c8d0000 | 0x7d0d3000 | C:\WINDOWS\system32\SHELL32.dll
2008-10-27 12:17:35 0xBF4 ERR 19999 BTRACE ----> Stack Back Trace <----
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!ak505release_longlit_rec + 42 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008eadba RA:008eed5c FP:0a0103f0 SP:0a0103f8
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a01eb5c 04:0a016a4c
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak505.c ( Line: 5896 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a505most_execute + 4876 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008eed5c RA:008ef104 FP:0a010588 SP:0a010590
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:2a01e8ec 02:0a016a4c 03:0a015a28 04:0a01312c
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak505.c ( Line: 6752 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a505loop_most_execute + 852 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008ef104 RA:008c9413 FP:0a010768 SP:0a010770
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a015a28 04:0a012fe4
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak505.c ( Line: 6028 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a501exec_with_change_rec + 931 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008c9413 RA:008d8e87 FP:0a01302c SP:0a013034
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a01312c 04:0a015a28
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak501.c ( Line: 5438 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a502complex_execution + 1031 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008d8e87 RA:008c9309 FP:0a013150 SP:0a013158
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0001e8ec 02:0a016a4c 03:0a015a28 04:0a01e02c
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak502.c ( Line: 5398 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a501exec_with_change_rec + 665 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008c9309 RA:008c96fb FP:0a015a04 SP:0a015a0c
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a01e02c 04:0a015a28
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak501.c ( Line: 5398 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a501do_execute + 75 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008c96fb RA:008e6ed6 FP:0a016a2c SP:0a016a34
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0a01e8ec 02:0a016a4c 03:0a01e02c 04:00000000
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak501.c ( Line: 5488 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a562_select_insert + 534 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008e6ed6 RA:0084e883 FP:0a01e040 SP:0a01e048
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0001e8ec 02:0a01e8ec 03:00000000 04:0a01ee1c
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak562.c ( Line: 7313 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!ak35call_semantik + 867 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:0084e883 RA:0084f590 FP:0a01e08c SP:0a01e094
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0001e8ec 02:00000000 03:00000000 04:0a01f220
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak35.c ( Line: 5824 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a35_asql_statement2 + 2304 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:0084f590 RA:008fb71c FP:0a01e0e4 SP:0a01e0ec
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0001e8ec 02:00000000 03:0a01f182 04:00000000
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak35.c ( Line: 5412 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!ak92not_only_execute + 1804 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008fb71c RA:008fd529 FP:0a01e218 SP:0a01e220
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0001e8ec 02:0a01e370 03:0a01e360 04:0a01e340
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak92.c ( Line: 5406 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!ak92analyze_messagetype + 1545 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008fd529 RA:008fd887 FP:0a01e37c SP:0a01e384
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0a01e8ec 02:00000000 03:00000000 04:00000000
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak92.c ( Line: 5882 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a92_mode_analyzer + 151 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008fd887 RA:008f4ea5 FP:0a01e3ac SP:0a01e3b4
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0001e8ec 02:00000000 03:00000000 04:00000001
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak92.c ( Line: 6615 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!ak93one_command + 1413 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008f4ea5 RA:008f6151 FP:0a01e434 SP:0a01e43c
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0101e8ec 02:00000001 03:0a01e494 04:00000001
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak93.c ( Line: 6664 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!a93_user_commands + 1073 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:008f6151 RA:009c5d9b FP:0a01e4ac SP:0a01e4b4
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:0001e8ec 02:0a01ff63 03:0a01e8d7 04:7fd095e0
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vak93.c ( Line: 5720 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!SQLTask + 123 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:009c5d9b RA:009c6043 FP:0a01e8d8 SP:0a01e8e0
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:00000000 02:7fd095e0 03:00000000 04:00000000
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 109 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!Kernel_Main + 547 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:009c6043 RA:006accfc FP:0a01ff70 SP:0a01ff78
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:7fd095e0 02:7ff02b30 03:006fc783 04:00000000
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 206 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!RTETask_TaskMain + 76 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:006accfc RA:006fc783 FP:0a01ff7c SP:0a01ff84
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:7fb5fb30 04:00000000
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 339 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:006fc783 RA:77e66063 FP:0a01ffbc SP:0a01ffc4
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:7fb5fb30 02:00000000 03:00000000 04:7fb5fb30
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Source: vos88k.cpp ( Line: 484 )
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel32!GetModuleFileNameA + 235 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:77e66063 RA:77e4d216 FP:0a01fff0 SP:0a01ffc4
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:006fc630 02:7fb5fb30 03:00009000 04:00000004
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE kernel32!ConvertFiberToThread + 177 bytes
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE SFrame: IP:77e4d216 RA:00000000 FP:00000000 SP:0a01ffc4
2008-10-27 12:17:39 0xBF4 ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:00000000 04:00000000
2008-10-27 12:17:41 0x1734 ERR 19999 BTRACE Mini dump file 'KnlMini.dmp' written!
2008-10-27 12:17:41 0x8D0 ERR 7 Messages Begin of dump of registered messages
2008-10-27 12:17:41 0x8D0 ERR 8 Messages End of the message list registry dump
2008-10-27 12:17:41 0x8D0 ERR 51105 AK CACHE AK00001.dmp written: 0
2008-10-27 12:18:34 ___ Stopping GMT 2008-10-27 10:18:34 7.6.05 Build 009-123-191-997
2008-10-27 12:33:55 --- Starting GMT 2008-10-27 10:33:55 7.6.05 Build 009-123-191-997
Any help in resolving this problem would be appreciated.
Regards
Bradley
Hi Bradley,
do you know the SQL command that causes this problem?
It must be some INSERT...
Also please let us know your parameter setup.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
I have not had a kernel abort since I changed the LONG column in the COMMENTS table to VARCHAR. (See post on Dec 1, 2008).
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Bradley,
I am just wondering if your database issue "EXCEPTION:'Access violation' (0xc0000005)" is resolved or not, coz my database is having the same issue now. So appreciate that you can share your solution with me Thanks in advance!
Regards,
Vivian
Edited by: vivian shi on Feb 16, 2009 5:52 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vivian,
EXCEPTION:'Access violation' (0xc0000005)
is a general Windows error which can be caused by very different root causes.
Is the stack back trace you get the exact same as the one discussed here?
What do you do to 'create' the error?
Are you using the same MaxDB build?
If any of the above questions is answered with NO, you should open your own thread or a support message with SAP (if you're a SAP customer)
regards,
Lars
Hello
FYI.
Kernel aborted again at 2008-11-28 15:43:11.
I have changed the LONG column in the COMMENTS table to VARCHAR:
CREATE TABLE "COMMENTS"
(
"ITID" Varchar (40) ASCII,
"MTID" Varchar (40) ASCII,
"UNI_ID" Integer,
"COMMENT" Varchar (4096) ASCII,
"COMMENT_TIME" Time,
"COMMENT_DATE" Date,
"COMMENT_ID" Integer
)
Output from KNLDIAGERR:
2008-11-28 15:43:11 0xB44 ERR 18793 EXCEPT EXCEPTION:'Access violation' (0xc0000005), The program code at IP:0x8eadba attempted to read to/from address:0xc65d000
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SymbolSearchPath: D:\Program-Files\sapdb\indep_data\wrk\P01;D:\PROGRAM-FILES\SAPDB\DEPEND\pgm;D:\PROGRAM-FILES\SAP
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE DB\DEPEND\symbols;D:\Program-Files\sapdb\depend\symbols;D:\Program-Files\sapdb\depend\sap;C:\WIN
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE DOWS;D:\Program-Files\sapdb\depend\sap\
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ----> Register Dump <----
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Eax=0x0b85035c Ebx=0x0b856a4c Ecx=0x00000003 Edx=0x0b85eb5c Esi=0x0c65d000 Edi=0x0b8503e4
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Eip=0x008eadba Esp=0x0b850350 Ebp=0x0b8503f0
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x10206
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ----> Module List <----
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE |.text Start |.text End | Module File Name
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ----> Stack Back Trace <----
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008eadba <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008eadba RA:008eed5c FP:0b8503f0 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0b85e8ec 02:0b856a4c 03:0b85eb5c 04:0b856a4c
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008eed5c <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008eed5c RA:008ef104 FP:0b850588 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:2a85e8ec 02:0b856a4c 03:0b855a28 04:0b85312c
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008ef104 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008ef104 RA:008c9413 FP:0b850768 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0b85e8ec 02:0b856a4c 03:0b855a28 04:0b852fe4
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008c9413 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008c9413 RA:008d8e87 FP:0b85302c SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0b85e8ec 02:0b856a4c 03:0b85312c 04:0b855a28
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008d8e87 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008d8e87 RA:008c9309 FP:0b853150 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0085e8ec 02:0b856a4c 03:0b855a28 04:0b85e02c
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008c9309 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008c9309 RA:008c96fb FP:0b855a04 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0b85e8ec 02:0b856a4c 03:0b85e02c 04:0b855a28
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008c96fb <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008c96fb RA:008e6ed6 FP:0b856a2c SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0b85e8ec 02:0b856a4c 03:0b85e02c 04:00000000
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008e6ed6 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008e6ed6 RA:0084e883 FP:0b85e040 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0085e8ec 02:0b85e8ec 03:00000000 04:0b85ee1c
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!0084e883 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:0084e883 RA:0084f590 FP:0b85e08c SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0085e8ec 02:00000000 03:00000000 04:0b85f220
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!0084f590 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:0084f590 RA:008fb71c FP:0b85e0e4 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0085e8ec 02:00000000 03:0b85f182 04:00000000
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008fb71c <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008fb71c RA:008fd529 FP:0b85e218 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0085e8ec 02:0b85e370 03:0b85e360 04:0b85e340
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008fd529 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008fd529 RA:008fd887 FP:0b85e37c SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0b85e8ec 02:00000000 03:00000000 04:00000000
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008fd887 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008fd887 RA:008f4ea5 FP:0b85e3ac SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0085e8ec 02:00000000 03:00000000 04:00000001
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008f4ea5 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008f4ea5 RA:008f6151 FP:0b85e434 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0185e8ec 02:00000001 03:0b85e494 04:00000001
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!008f6151 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:008f6151 RA:009c5d9b FP:0b85e4ac SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:0085e8ec 02:0b85ff63 03:0b85e8d7 04:7ff3f438
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!009c5d9b <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:009c5d9b RA:009c6043 FP:0b85e8d8 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:00000000 02:7ff3f438 03:00000000 04:00000000
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!009c6043 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:009c6043 RA:006accfc FP:0b85ff70 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:7ff3f438 02:7ff02b30 03:006fc783 04:00000000
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!006accfc <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:006accfc RA:77e64829 FP:0b85ffbc SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:7fb5eb28 02:00000000 03:00000000 04:7fb5eb28
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!77e64829 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:77e64829 RA:77e52575 FP:0b85fff0 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:006fc630 02:7fb5eb28 03:00009000 04:00000004
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE ?!77e52575 <nosymbols>[rc = 126]
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE SFrame: IP:77e52575 RA:00000000 FP:00000000 SP:0b850350
2008-11-28 15:43:12 0x1780 ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:00000000 04:00000000
2008-11-28 15:43:12 0x1340 ERR 19999 BTRACE Error writing mini dump, rc = -2147024865
2008-11-28 15:43:12 0xB44 ERR 7 Messages Begin of dump of registered messages
2008-11-28 15:43:12 0xB44 ERR 8 Messages End of the message list registry dump
2008-11-28 15:43:12 0xB44 ERR 51105 AK CACHE AK00001.dmp written: 0
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Check data as requested.
#dbmcli -d P01 -u dbm,dbm
dbmcli on P01>db_admin
OK
---
dbmcli on P01>db_execute check data extended with update
OK
PAGES_USED = 0005569265
BLOCKS_RELEASED = 0000129511
---
dbmcli on P01>
dbm.prt output:
2008-11-15 09:48:00 0x00000588 INF 283 DBMSrv Command 'db_execute check data ...' is being executed.
2008-11-15 13:24:18 0x00000588 INF 419 DBMSrv Command 'db_execute' has ended with return code 0.
dbm.utl output:
2008-11-15 09:48:00 491E7EB00001 0000 VER CHECK DATA EXTENDED WITH UPDATE
2008-11-15 13:24:18 491E7EB00001 0001 VER RETURNCODE 0;CHECK DATA EXTENDED WITH UPDATE; 0005569265 PERM PAGES, 0000129511 RELEASED BLOCKS
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
I will CHECK DATA in admin mode on the weekend.
Is it possible to CHECK DATA with the dbmcli?
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Is it possible to CHECK DATA with the dbmcli?
Sure it is:
dbmcli on db760>db_state
OK
State
ONLINE
---
dbmcli on db760>db_admin
OK
---
dbmcli on db760>db_execute check data with update
OK
PAGES_USED = 0000003162
BLOCKS_RELEASED = 0000009233
---
dbmcli on db760>db_execute check data extended with update
OK
PAGES_USED = 0000003160
BLOCKS_RELEASED = 0000000000
---
It's all documented ... [MaxDB Wiki - Check database structure|https://wiki.sdn.sap.com/wiki/x/fSo]
regards,
Lars
Hello
Another kernel abort.
2008-11-14 10:26:41 0xB28 ERR 18793 EXCEPT EXCEPTION:'Access violation' (0xc0000005), The program code at IP:0x8eadba attempted to read to/from address:0x747cd000
2008-11-14 10:26:41 0xB28 19624 EXCEPT Kernel aborts
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE SymbolSearchPath: D:\Program-Files\sapdb\indep_data\wrk\P01;D:\PROGRAM-FILES\SAPDB\DEPEND\pgm;D:\PROGRAM-FILES\SAP
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE DB\DEPEND\symbols;D:\Program-Files\sapdb\depend\symbols;D:\Program-Files\sapdb\depend\sap;C:\WIN
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE DOWS;D:\Program-Files\sapdb\depend\sap\
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE ----> Register Dump <----
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE Eax=0x0a12035c Ebx=0x0a126a4c Ecx=0x00000005 Edx=0x0a12eb5c Esi=0x747cd000 Edi=0x0a1203dc
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE Eip=0x008eadba Esp=0x0a120350 Ebp=0x0a1203f0
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x10202
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE ----> Module List <----
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE |.text Start |.text End | Module File Name
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x00400000 | 0x00b80000 | D:\PROGRAM-FILES\SAPDB\DEPEND\pgm\kernel.exe
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x0ac40000 | 0x0ac96000 | C:\WINDOWS\system32\MSVCR71.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x0acb0000 | 0x0adb0000 | D:\PROGRAM-FILES\SAPDB\DEPEND\pgm\dbghelp.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x71b20000 | 0x71b61000 | C:\WINDOWS\System32\mswsock.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x71bb0000 | 0x71bb9000 | C:\WINDOWS\system32\WSOCK32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x71bf0000 | 0x71bf8000 | C:\WINDOWS\system32\WS2HELP.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x71c00000 | 0x71c17000 | C:\WINDOWS\system32\WS2_32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x76050000 | 0x76188000 | D:\Program-Files\sapdb\depend\pgm\liboms.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x76c10000 | 0x76c38000 | C:\WINDOWS\system32\imagehlp.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x76ed0000 | 0x76efa000 | C:\WINDOWS\system32\DNSAPI.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x76f10000 | 0x76f3e000 | C:\WINDOWS\system32\WLDAP32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x76f50000 | 0x76f63000 | C:\WINDOWS\system32\Secur32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x76f70000 | 0x76f77000 | C:\WINDOWS\System32\winrnr.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x76f80000 | 0x76f85000 | C:\WINDOWS\system32\rasadhlp.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77380000 | 0x77411000 | C:\WINDOWS\system32\USER32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77420000 | 0x77523000 | C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.3959_
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE : : : x-ww_D8713E55\comctl32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77670000 | 0x777a9000 | C:\WINDOWS\system32\ole32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77ba0000 | 0x77bfa000 | C:\WINDOWS\system32\msvcrt.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77c00000 | 0x77c48000 | C:\WINDOWS\system32\GDI32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77c50000 | 0x77cef000 | C:\WINDOWS\system32\RPCRT4.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77da0000 | 0x77df2000 | C:\WINDOWS\system32\SHLWAPI.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77e40000 | 0x77f42000 | C:\WINDOWS\system32\kernel32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x77f50000 | 0x77feb000 | C:\WINDOWS\system32\ADVAPI32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x7c800000 | 0x7c8c0000 | C:\WINDOWS\system32\ntdll.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE | 0x7c8d0000 | 0x7d0ce000 | C:\WINDOWS\system32\SHELL32.dll
2008-11-14 10:26:41 0xEAC ERR 19999 BTRACE ----> Stack Back Trace <----
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!ak505release_longlit_rec + 42 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008eadba RA:008eed5c FP:0a1203f0 SP:0a1203f8
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a12eb5c 04:0a126a4c
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak505.c ( Line: 5896 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a505most_execute + 4876 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008eed5c RA:008ef104 FP:0a120588 SP:0a120590
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:2a12e8ec 02:0a126a4c 03:0a125a28 04:0a12312c
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak505.c ( Line: 6752 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a505loop_most_execute + 852 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008ef104 RA:008c9413 FP:0a120768 SP:0a120770
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a125a28 04:0a122fe4
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak505.c ( Line: 6028 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a501exec_with_change_rec + 931 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008c9413 RA:008d8e87 FP:0a12302c SP:0a123034
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a12312c 04:0a125a28
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak501.c ( Line: 5438 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a502complex_execution + 1031 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008d8e87 RA:008c9309 FP:0a123150 SP:0a123158
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0012e8ec 02:0a126a4c 03:0a125a28 04:0a12e02c
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak502.c ( Line: 5398 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a501exec_with_change_rec + 665 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008c9309 RA:008c96fb FP:0a125a04 SP:0a125a0c
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a12e02c 04:0a125a28
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak501.c ( Line: 5398 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a501do_execute + 75 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008c96fb RA:008e6ed6 FP:0a126a2c SP:0a126a34
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a12e02c 04:00000000
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak501.c ( Line: 5488 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a562_select_insert + 534 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008e6ed6 RA:0084e883 FP:0a12e040 SP:0a12e048
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0012e8ec 02:0a12e8ec 03:00000000 04:0a12ee1c
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak562.c ( Line: 7313 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!ak35call_semantik + 867 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:0084e883 RA:0084f590 FP:0a12e08c SP:0a12e094
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0012e8ec 02:00000000 03:00000000 04:0a12f220
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak35.c ( Line: 5824 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a35_asql_statement2 + 2304 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:0084f590 RA:008fb71c FP:0a12e0e4 SP:0a12e0ec
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0012e8ec 02:00000000 03:0a12f182 04:00000000
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak35.c ( Line: 5412 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!ak92not_only_execute + 1804 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008fb71c RA:008fd529 FP:0a12e218 SP:0a12e220
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0012e8ec 02:0a12e370 03:0a12e360 04:0a12e340
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak92.c ( Line: 5406 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!ak92analyze_messagetype + 1545 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008fd529 RA:008fd887 FP:0a12e37c SP:0a12e384
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0a12e8ec 02:00000000 03:00000000 04:00000000
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak92.c ( Line: 5882 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a92_mode_analyzer + 151 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008fd887 RA:008f4ea5 FP:0a12e3ac SP:0a12e3b4
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0012e8ec 02:00000000 03:00000000 04:00000001
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak92.c ( Line: 6615 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!ak93one_command + 1413 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008f4ea5 RA:008f6151 FP:0a12e434 SP:0a12e43c
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0112e8ec 02:00000001 03:0a12e494 04:00000001
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak93.c ( Line: 6664 )
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE kernel!a93_user_commands + 1073 bytes
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE SFrame: IP:008f6151 RA:009c5d9b FP:0a12e4ac SP:0a12e4b4
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Params: 01:0012e8ec 02:0a12ff63 03:0a12e8d7 04:7ff3c558
2008-11-14 10:26:45 0xEAC ERR 19999 BTRACE Source: vak93.c ( Line: 5720 )
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE kernel!SQLTask + 123 bytes
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE SFrame: IP:009c5d9b RA:009c6043 FP:0a12e8d8 SP:0a12e8e0
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Params: 01:00000000 02:7ff3c558 03:00000000 04:00000000
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 109 )
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE kernel!Kernel_Main + 547 bytes
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE SFrame: IP:009c6043 RA:006accfc FP:0a12ff70 SP:0a12ff78
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Params: 01:7ff3c558 02:7ff028c8 03:006fc783 04:00000000
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 206 )
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE kernel!RTETask_TaskMain + 76 bytes
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE SFrame: IP:006accfc RA:006fc783 FP:0a12ff7c SP:0a12ff84
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:7fb5b5b8 04:00000000
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 339 bytes
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE SFrame: IP:006fc783 RA:77e64829 FP:0a12ffbc SP:0a12ffc4
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Params: 01:7fb5b5b8 02:00000000 03:00000000 04:7fb5b5b8
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Source: vos88k.cpp ( Line: 484 )
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE kernel32!GetModuleHandleA + 223 bytes
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE SFrame: IP:77e64829 RA:77e52575 FP:0a12fff0 SP:0a12ffc4
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Params: 01:006fc630 02:7fb5b5b8 03:00009000 04:00000004
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE kernel32!GlobalReAlloc + 380 bytes
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE SFrame: IP:77e52575 RA:00000000 FP:00000000 SP:0a12ffc4
2008-11-14 10:26:46 0xEAC ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:00000000 04:00000000
2008-11-14 10:26:47 0xA08 ERR 19999 BTRACE Mini dump file 'KnlMini.dmp' written!
2008-11-14 10:26:47 0xB28 ERR 7 Messages Begin of dump of registered messages
2008-11-14 10:26:47 0xB28 ERR 8 Messages End of the message list registry dump
2008-11-14 10:26:47 0xB28 19820 EXCEPT calling ak dump for T79
2008-11-14 10:26:47 0xB28 ERR 51105 AK CACHE AK00001.dmp written: 0
2008-11-14 10:26:47 0xB28 19684 TASKING Tracewriter termination timeout: 1200 sec
2008-11-14 10:26:47 0xB14 20000 Trace Start flush kernel trace
2008-11-14 10:26:47 0xB14 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:1
2008-11-14 10:26:47 0xB14 20001 Trace Stop flush kernel trace
2008-11-14 10:26:47 0xB14 20002 Trace Start flush kernel dump
2008-11-14 10:27:13 0xB14 20003 Trace Stop flush kernel dump
2008-11-14 10:27:22 0xB14 19619 TASKING Releasing tracewriter
2008-11-14 10:27:22 0xB28 19890 DIAGHIST Backup of diagnostic files will be forced at next restart
2008-11-14 10:27:22 0xB28 19600 VERSION 'Kernel 7.6.05 Build 009-123-191-997'
2008-11-14 10:27:22 0xB28 19654 DBSTATE SERVERDB 'P01' has stopped
Last INSERT from the application log at 2008-11-14 10:26:41,309:
INSERT INTO comments VALUES('f6ab52e8-b225-11dd-a2bd-ceaa29b12a7d', '0', 1504408, 'Patiencek Viewed Member 0160111516', time('10:26:41'), date('2008-11-14'), 18)
Here is the dir of indep_data\wrk\P01\DIAGHISTORY\P01_20081114
D:\Program-Files\sapdb\indep_data\wrk\P01\DIAGHISTORY
#dir P01_20081114_10-57-25
Volume in drive D is Programs
Volume Serial Number is D260-7597
Directory of D:\Program-Files\sapdb\indep_data\wrk\P01\DIAGHISTORY\P01_20081114
_10-57-25
14/11/2008 10:57 <DIR> .
14/11/2008 10:57 <DIR> ..
14/11/2008 10:27 739,425 comseg.dump
14/11/2008 10:27 819,200 knldiag
14/11/2008 10:27 1,633,624,064 knldump
14/11/2008 10:26 185,685 KnlMini.dmp
13/11/2008 11:36 7,372,800 knltrace
14/11/2008 10:26 2,166,596 rtedump
6 File(s) 1,644,907,770 bytes
2 Dir(s) 4,012,756,992 bytes free
Please let me know if you would like me to upload any files.
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
I can only find one KnlMini.dmp in indep_data\wrk\P01\DIAGHISTORY\P01_20081113 which I have uploaded.
D:\Program-Files\sapdb\indep_data\wrk\P01\DIAGHISTORY
#dir P01_20081113_11-36-49
Volume in drive D is Programs
Volume Serial Number is D260-7597
Directory of D:\Program-Files\sapdb\indep_data\wrk\P01\DIAGHISTORY\P01_20081113
_11-36-49
13/11/2008 14:12 <DIR> .
13/11/2008 14:12 <DIR> ..
13/11/2008 11:08 1,845,767 comseg.dump
13/11/2008 11:08 819,200 knldiag
13/11/2008 11:07 1,633,501,184 knldump
13/11/2008 11:07 185,967 KnlMini.dmp
11/11/2008 15:03 7,372,800 knltrace
13/11/2008 11:07 2,305,597 rtedump
6 File(s) 1,646,030,515 bytes
2 Dir(s) 4,010,795,008 bytes free
I aslo have
D:\Program-Files\sapdb\indep_data\wrk\P01\DIAGHISTORY
#dir P01_20081111_15-03-39
Volume in drive D is Programs
Volume Serial Number is D260-7597
Directory of D:\Program-Files\sapdb\indep_data\wrk\P01\DIAGHISTORY\P01_20081111
_15-03-39
11/11/2008 15:03 <DIR> .
11/11/2008 15:03 <DIR> ..
11/11/2008 14:36 2,338,034 comseg.dump
11/11/2008 14:36 819,200 knldiag
11/11/2008 14:36 1,634,377,728 knldump
06/11/2008 17:51 7,372,800 knltrace
11/11/2008 14:35 1,039,882 rtedump
5 File(s) 1,645,947,644 bytes
2 Dir(s) 4,015,702,016 bytes free
and
D:\Program-Files\sapdb\indep_data\wrk
#dir AK* /s
Volume in drive D is Programs
Volume Serial Number is D260-7597
Directory of D:\Program-Files\sapdb\indep_data\wrk\P01
13/11/2008 11:07 294,912 AK00001.dmp
1 File(s) 294,912 bytes
Total Files Listed:
1 File(s) 294,912 bytes
0 Dir(s) 4,015,632,384 bytes free
Please let me know if you would like me to upload any other files.
Kind regards
Bradley
Edited by: Bradley Patchett on Nov 13, 2008 1:28 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Datbase kernel aborted again. No changes have been made since the server was rebooted after the last kernel abort on 2008-11-11 14:35:26.
2008-11-13 11:07:35 0xB38 ERR 18793 EXCEPT EXCEPTION:'Access violation' (0xc0000005), The program code at IP:0x8eadba attempted to read to/from address:0x74e3d000
2008-11-13 11:07:36 0xB38 19624 EXCEPT Kernel aborts
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE SymbolSearchPath: D:\Program-Files\sapdb\indep_data\wrk\P01;D:\PROGRAM-FILES\SAPDB\DEPEND\pgm;D:\PROGRAM-FILES\SAP
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE DB\DEPEND\symbols;D:\Program-Files\sapdb\depend\symbols;D:\Program-Files\sapdb\depend\sap;C:\WIN
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE DOWS;D:\Program-Files\sapdb\depend\sap\
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE ----> Register Dump <----
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE Eax=0x0a12035c Ebx=0x0a126a4c Ecx=0x00000005 Edx=0x0a12eb5c Esi=0x74e3d000 Edi=0x0a1203dc
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE Eip=0x008eadba Esp=0x0a120350 Ebp=0x0a1203f0
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x10202
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE ----> Module List <----
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE |.text Start |.text End | Module File Name
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x00400000 | 0x00b80000 | D:\PROGRAM-FILES\SAPDB\DEPEND\pgm\kernel.exe
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x0ac40000 | 0x0ac96000 | C:\WINDOWS\system32\MSVCR71.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x0acb0000 | 0x0adb0000 | D:\PROGRAM-FILES\SAPDB\DEPEND\pgm\dbghelp.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x71b20000 | 0x71b61000 | C:\WINDOWS\System32\mswsock.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x71bb0000 | 0x71bb9000 | C:\WINDOWS\system32\WSOCK32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x71bf0000 | 0x71bf8000 | C:\WINDOWS\system32\WS2HELP.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x71c00000 | 0x71c17000 | C:\WINDOWS\system32\WS2_32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x76050000 | 0x76188000 | D:\Program-Files\sapdb\depend\pgm\liboms.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x76c10000 | 0x76c38000 | C:\WINDOWS\system32\imagehlp.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x76ed0000 | 0x76efa000 | C:\WINDOWS\system32\DNSAPI.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x76f10000 | 0x76f3e000 | C:\WINDOWS\system32\WLDAP32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x76f50000 | 0x76f63000 | C:\WINDOWS\system32\Secur32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x76f70000 | 0x76f77000 | C:\WINDOWS\System32\winrnr.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x76f80000 | 0x76f85000 | C:\WINDOWS\system32\rasadhlp.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77380000 | 0x77411000 | C:\WINDOWS\system32\USER32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77420000 | 0x77523000 | C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.3790.3959_
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE : : : x-ww_D8713E55\comctl32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77670000 | 0x777a9000 | C:\WINDOWS\system32\ole32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77ba0000 | 0x77bfa000 | C:\WINDOWS\system32\msvcrt.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77c00000 | 0x77c48000 | C:\WINDOWS\system32\GDI32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77c50000 | 0x77cef000 | C:\WINDOWS\system32\RPCRT4.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77da0000 | 0x77df2000 | C:\WINDOWS\system32\SHLWAPI.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77e40000 | 0x77f42000 | C:\WINDOWS\system32\kernel32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x77f50000 | 0x77feb000 | C:\WINDOWS\system32\ADVAPI32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x7c800000 | 0x7c8c0000 | C:\WINDOWS\system32\ntdll.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE | 0x7c8d0000 | 0x7d0ce000 | C:\WINDOWS\system32\SHELL32.dll
2008-11-13 11:07:36 0xF18 ERR 19999 BTRACE ----> Stack Back Trace <----
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!ak505release_longlit_rec + 42 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008eadba RA:008eed5c FP:0a1203f0 SP:0a1203f8
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a12eb5c 04:0a126a4c
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak505.c ( Line: 5896 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a505most_execute + 4876 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008eed5c RA:008ef104 FP:0a120588 SP:0a120590
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:2a12e8ec 02:0a126a4c 03:0a125a28 04:0a12312c
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak505.c ( Line: 6752 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a505loop_most_execute + 852 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008ef104 RA:008c9413 FP:0a120768 SP:0a120770
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a125a28 04:0a122fe4
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak505.c ( Line: 6028 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a501exec_with_change_rec + 931 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008c9413 RA:008d8e87 FP:0a12302c SP:0a123034
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a12312c 04:0a125a28
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak501.c ( Line: 5438 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a502complex_execution + 1031 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008d8e87 RA:008c9309 FP:0a123150 SP:0a123158
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0012e8ec 02:0a126a4c 03:0a125a28 04:0a12e02c
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak502.c ( Line: 5398 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a501exec_with_change_rec + 665 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008c9309 RA:008c96fb FP:0a125a04 SP:0a125a0c
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a12e02c 04:0a125a28
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak501.c ( Line: 5398 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a501do_execute + 75 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008c96fb RA:008e6ed6 FP:0a126a2c SP:0a126a34
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0a12e8ec 02:0a126a4c 03:0a12e02c 04:00000000
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak501.c ( Line: 5488 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a562_select_insert + 534 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008e6ed6 RA:0084e883 FP:0a12e040 SP:0a12e048
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0012e8ec 02:0a12e8ec 03:00000000 04:0a12ee1c
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak562.c ( Line: 7313 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!ak35call_semantik + 867 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:0084e883 RA:0084f590 FP:0a12e08c SP:0a12e094
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0012e8ec 02:00000000 03:00000000 04:0a12f220
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak35.c ( Line: 5824 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a35_asql_statement2 + 2304 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:0084f590 RA:008fb71c FP:0a12e0e4 SP:0a12e0ec
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0012e8ec 02:00000000 03:0a12f182 04:00000000
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak35.c ( Line: 5412 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!ak92not_only_execute + 1804 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008fb71c RA:008fd529 FP:0a12e218 SP:0a12e220
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0012e8ec 02:0a12e370 03:0a12e360 04:0a12e340
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak92.c ( Line: 5406 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!ak92analyze_messagetype + 1545 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008fd529 RA:008fd887 FP:0a12e37c SP:0a12e384
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0a12e8ec 02:00000000 03:00000000 04:00000000
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak92.c ( Line: 5882 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a92_mode_analyzer + 151 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008fd887 RA:008f4ea5 FP:0a12e3ac SP:0a12e3b4
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0012e8ec 02:00000000 03:00000000 04:00000001
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak92.c ( Line: 6615 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!ak93one_command + 1413 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008f4ea5 RA:008f6151 FP:0a12e434 SP:0a12e43c
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0112e8ec 02:00000001 03:0a12e494 04:00000001
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak93.c ( Line: 6664 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!a93_user_commands + 1073 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:008f6151 RA:009c5d9b FP:0a12e4ac SP:0a12e4b4
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:0012e8ec 02:0a12ff63 03:0a12e8d7 04:7ff3e628
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vak93.c ( Line: 5720 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!SQLTask + 123 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:009c5d9b RA:009c6043 FP:0a12e8d8 SP:0a12e8e0
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:00000000 02:7ff3e628 03:00000000 04:00000000
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 109 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!Kernel_Main + 547 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:009c6043 RA:006accfc FP:0a12ff70 SP:0a12ff78
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:7ff3e628 02:7ff02b30 03:006fc783 04:00000000
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: kernel_main.cpp ( Line: 206 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!RTETask_TaskMain + 76 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:006accfc RA:006fc783 FP:0a12ff7c SP:0a12ff84
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:7fb5db20 04:00000000
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 339 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:006fc783 RA:77e64829 FP:0a12ffbc SP:0a12ffc4
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:7fb5db20 02:00000000 03:00000000 04:7fb5db20
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Source: vos88k.cpp ( Line: 484 )
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel32!GetModuleHandleA + 223 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:77e64829 RA:77e52575 FP:0a12fff0 SP:0a12ffc4
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:006fc630 02:7fb5db20 03:00009000 04:00000004
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE kernel32!GlobalReAlloc + 380 bytes
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE SFrame: IP:77e52575 RA:00000000 FP:00000000 SP:0a12ffc4
2008-11-13 11:07:40 0xF18 ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:00000000 04:00000000
2008-11-13 11:07:41 0x374 ERR 19999 BTRACE Mini dump file 'KnlMini.dmp' written!
2008-11-13 11:07:41 0xB38 ERR 7 Messages Begin of dump of registered messages
2008-11-13 11:07:41 0xB38 ERR 8 Messages End of the message list registry dump
2008-11-13 11:07:41 0xB38 19820 EXCEPT calling ak dump for T86
2008-11-13 11:07:41 0xB38 ERR 51105 AK CACHE AK00001.dmp written: 0
2008-11-13 11:07:41 0xB20 20000 Trace Start flush kernel trace
2008-11-13 11:07:41 0xB20 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:1
2008-11-13 11:07:41 0xB38 19684 TASKING Tracewriter termination timeout: 1200 sec
2008-11-13 11:07:41 0xB20 20001 Trace Stop flush kernel trace
2008-11-13 11:07:41 0xB20 20002 Trace Start flush kernel dump
2008-11-13 11:07:56 0xB20 20003 Trace Stop flush kernel dump
2008-11-13 11:08:03 0xB20 19619 TASKING Releasing tracewriter
2008-11-13 11:08:03 0xB38 19890 DIAGHIST Backup of diagnostic files will be forced at next restart
2008-11-13 11:08:03 0xB38 19600 VERSION 'Kernel 7.6.05 Build 009-123-191-997'
2008-11-13 11:08:03 0xB38 19654 DBSTATE SERVERDB 'P01' has stopped
Here is the suspect INSERT statement from the application log at 2008-11-13 11:07:35,563:
INSERT INTO comments VALUES('83189344-b162-11dd-8e6e-c3d0bf3d1677', '0', 1564670, 'MISSING INFO - SALARY SLIP - TC', time('11:07:35'), date('2008-11-13'), 4)
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bradley,
do you have a file <indep_data>/wrk/KnlMini.dmp? Not sure about the exact name. If yes, please upload it [here|https://sapmats-de.sap-ag.de/upload/index.cgi?id=5UTMQ2WOTKRNDV78UUY8JKZRK7FMGY28O1B83ANW6ANR4P9UVW]. If you have more than one matching file, please zip them into one and upload that. It might help the kernel developer.
Regards,
Marc-Philip
Hello Marc-Philip
No, not this time. (It's the first thing I check now.
Terminal Server is not installed on this server (TULIP).
#query termserver tulip
This terminal server was not found in the domain.
Terminal Services are install but they are only used for Remoted Desktop Administration.
Whenever I logon to the server I logon directly on the console or via VNC.
I had no problems upgrading from 7.5.0.38 to 7.6.5.09 on this server.
Version 7.5.0.38 ran for many months with the same COMMENTS table structure and the same application doing INSERTs without any problems.
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
One thing that has changed since the last kernel abort is that SP2 was loaded on 2008-11-06.
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
hmm... then a new forum entry might be useful to improve readability...
Sorry I thought that these kernel aborts were related as they all occured right after the same type of insert statement.
OS:
Windows Server 2003 Standard Edition Service Pack 2 (build 3790)
Architecture:
Processor:
3.05 gigahertz Intel Pentium III (2 installed)
8 kilobyte primary memory cache
512 kilobyte secondary memory cache
Memory:
3840 Megabytes Installed Memory
Slot 'DIMM1A' has 1024 MB
Slot 'DIMM1B' has 1024 MB
Slot 'DIMM2A' has 1024 MB
Slot 'DIMM2B' has 1024 MB
Slot 'DIMM3A' is Empty
Slot 'DIMM3B' is Empty
Main circut board:
Board: Intel SE7501HG2 A95718-308
Serial Number: KRH150400708
Bus Clock: 133 megahertz
BIOS: Intel Corporation S7501HG0.86B.0056.P18.0409231600 09/23/2004
I haven't changed anything since the last kernel abort on 2008-10-27.
Here is a dir of the symbols directory.
D:\Program-Files\sapdb
#xinstinfo P01
IndepData : D:\Program-Files\sapdb\indep_data
IndepPrograms : D:\Program-Files\sapdb\indep_prog
InstallationPath : D:\Program-Files\sapdb\depend
Kernelversion : KERNEL 7.6.05 BUILD 009-123-191-997
Rundirectory : D:\Program-Files\sapdb\indep_data\wrk\P01
D:\Program-Files\sapdb
#dir D:\Program-Files\sapdb\depend\symbols
Volume in drive D is Programs
Volume Serial Number is D260-7597
Directory of D:\Program-Files\sapdb\depend\symbols
15/09/2008 16:57 <DIR> .
15/09/2008 16:57 <DIR> ..
15/08/2008 21:51 1,199,104 backint.pdb
15/08/2008 20:10 2,092,032 cons.pdb
15/08/2008 20:10 281,600 cr_param.pdb
15/08/2008 21:53 3,836,928 dbmevtdisp.pdb
15/08/2008 21:53 3,058,688 dbmevthndl_display.pdb
15/08/2008 21:53 3,083,264 dbmevthndl_winlog.pdb
15/08/2008 21:49 2,485,248 dbmshm.pdb
15/08/2008 20:24 8,563,712 dbmsrv-clu.pdb
15/08/2008 21:48 8,391,680 dbmsrv.pdb
15/08/2008 21:49 7,703,552 dbmsrvscd.pdb
16/08/2008 00:15 420,864 dbpinstall.pdb
15/08/2008 20:33 4,803,584 diagnose.pdb
15/08/2008 20:10 338,944 get_page.pdb
15/08/2008 21:48 36,047,872 kernel.pdb
15/08/2008 20:25 470,016 libhsscopy.pdb
16/08/2008 00:11 5,868,544 liboms.pdb
16/08/2008 00:16 1,264,640 libsqlcls.pdb
16/08/2008 00:17 4,713,472 libSQLDBC.pdb
16/08/2008 00:20 5,180,416 libSQLDBC_C.pdb
15/08/2008 22:01 7,171,072 lserver.pdb
16/08/2008 00:15 642,048 lvcbench.pdb
15/08/2008 21:52 1,207,296 pipe2file.pdb
15/08/2008 20:12 3,058,688 sapdbmscsex.pdb
15/08/2008 20:12 1,002,496 sapdbmscsman.pdb
15/08/2008 20:12 330,752 sapdbmscsres.pdb
15/08/2008 20:12 2,739,200 serv-clu.pdb
15/08/2008 20:12 2,141,184 service-clu.pdb
15/08/2008 20:11 1,944,576 service.pdb
15/08/2008 23:35 40,643,584 slowknl.pdb
15/08/2008 20:11 2,321,408 sqlinst.pdb
16/08/2008 00:05 2,075,648 sqlrun.pdb
15/08/2008 19:55 306,176 sqlver.pdb
15/08/2008 19:55 306,176 sqlwhat.pdb
16/08/2008 00:05 248,832 sql_run.pdb
15/08/2008 20:12 2,214,912 start-clu.pdb
15/08/2008 20:12 2,206,720 stop-clu.pdb
15/08/2008 20:25 306,176 sysrc.pdb
15/08/2008 20:11 388,096 systemrc.pdb
15/08/2008 22:11 846,848 TableDefC.pdb
15/08/2008 22:01 887,808 tracesort.pdb
40 File(s) 172,793,856 bytes
2 Dir(s) 4,025,016,320 bytes free
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
The database suffered another kernel abort.
Here is the last insert attempted by the application at 2008-11-11 14:35:26,280:
INSERT INTO comments VALUES('3767c3ce-afed-11dd-8b32-b41baf254de5', '0', 94317, 'saeedas Viewed Member 1020303027', time('14:35:26'), date('2008-11-11'), 18)
The row does not exist in the database when the database is restarted:
#sqlcli -d P01 -u *,* select * from comments where itid = '3767c3ce-afed-11dd-8b32-b41baf254de5'
* 0: SQLSTATE:
Similar inserts have been performed successfully many times since the last kernel abort.
Here is the output from knldiag:
2008-11-11 14:35:26 0x914 ERR 18793 EXCEPT EXCEPTION:'Access violation' (0xc0000005), The program code at IP:0x8eadba attempted to read to/from address:0x71d90000
2008-11-11 14:35:26 0x8CC 13809 RTE System page cache released 2560 pages in 5 blocks
2008-11-11 14:35:26 0x8CC 13810 RTE System page cache still holding 607 pages in 8 splitted blocks
2008-11-11 14:35:26 0x8CC 54000 MEMORY RTEMem_RteAllocator : could not allocat
2008-11-11 14:35:26 0x8CC 54000 MEMORY e memory
2008-11-11 14:35:26 0x8CC 54000 MEMORY required : 7271248
2008-11-11 14:35:26 0x8CC 54000 MEMORY allocated : 3145728
2008-11-11 14:35:26 0x8CC 54000 MEMORY supplement : 7274496
2008-11-11 14:35:26 0x8CC 54000 MEMORY limit : -1
2008-11-11 14:35:26 0x8CC 54000 MEMORY free blocks size 24 : 2
2008-11-11 14:35:26 0x8CC 54000 MEMORY free blocks size 232152 : 1
2008-11-11 14:35:26 0x914 19624 EXCEPT Kernel aborts
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SymbolSearchPath: D:\Program-Files\sapdb\indep_data\wrk\P01;D:\PROGRAM-FILES\SAPDB\DEPEND\pgm;D:\PROGRAM-FILES\SAP
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE DB\DEPEND\symbols;D:\Program-Files\sapdb\depend\symbols;D:\Program-Files\sapdb\depend\sap;C:\WIN
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE DOWS;D:\Program-Files\sapdb\depend\sap\
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ----> Register Dump <----
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Eax=0x0a23035c Ebx=0x0a236a4c Ecx=0x00000005 Edx=0x0a23eb5c Esi=0x71d90000 Edi=0x0a2303dc
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Eip=0x008eadba Esp=0x0a230350 Ebp=0x0a2303f0
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x10202
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ----> Module List <----
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE |.text Start |.text End | Module File Name
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ----> Stack Back Trace <----
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008eadba <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008eadba RA:008eed5c FP:0a2303f0 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0a23e8ec 02:0a236a4c 03:0a23eb5c 04:0a236a4c
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008eed5c <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008eed5c RA:008ef104 FP:0a230588 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:2a23e8ec 02:0a236a4c 03:0a235a28 04:0a23312c
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008ef104 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008ef104 RA:008c9413 FP:0a230768 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0a23e8ec 02:0a236a4c 03:0a235a28 04:0a232fe4
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008c9413 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008c9413 RA:008d8e87 FP:0a23302c SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0a23e8ec 02:0a236a4c 03:0a23312c 04:0a235a28
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008d8e87 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008d8e87 RA:008c9309 FP:0a233150 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0023e8ec 02:0a236a4c 03:0a235a28 04:0a23e02c
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008c9309 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008c9309 RA:008c96fb FP:0a235a04 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0a23e8ec 02:0a236a4c 03:0a23e02c 04:0a235a28
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008c96fb <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008c96fb RA:008e6ed6 FP:0a236a2c SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0a23e8ec 02:0a236a4c 03:0a23e02c 04:00000000
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008e6ed6 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008e6ed6 RA:0084e883 FP:0a23e040 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0023e8ec 02:0a23e8ec 03:00000000 04:0a23ee1c
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!0084e883 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:0084e883 RA:0084f590 FP:0a23e08c SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0023e8ec 02:00000000 03:00000000 04:0a23f220
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!0084f590 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:0084f590 RA:008fb71c FP:0a23e0e4 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0023e8ec 02:00000000 03:0a23f182 04:00000000
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008fb71c <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008fb71c RA:008fd529 FP:0a23e218 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0023e8ec 02:0a23e370 03:0a23e360 04:0a23e340
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008fd529 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008fd529 RA:008fd887 FP:0a23e37c SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0a23e8ec 02:00000000 03:00000000 04:00000000
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008fd887 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008fd887 RA:008f4ea5 FP:0a23e3ac SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0023e8ec 02:00000000 03:00000000 04:00000001
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008f4ea5 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008f4ea5 RA:008f6151 FP:0a23e434 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0123e8ec 02:00000001 03:0a23e494 04:00000001
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!008f6151 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:008f6151 RA:009c5d9b FP:0a23e4ac SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:0023e8ec 02:0a23ff63 03:0a23e8d7 04:7ff3e628
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!009c5d9b <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:009c5d9b RA:009c6043 FP:0a23e8d8 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:00000000 02:7ff3e628 03:00000000 04:00000000
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!009c6043 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:009c6043 RA:006accfc FP:0a23ff70 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:7ff3e628 02:7ff02b30 03:006fc783 04:00000000
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!006accfc <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:006accfc RA:77e64829 FP:0a23ffbc SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:7fb5db20 02:00000000 03:00000000 04:7fb5db20
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!77e64829 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:77e64829 RA:77e52575 FP:0a23fff0 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:006fc630 02:7fb5db20 03:00000000 04:00000000
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE ?!77e52575 <nosymbols>[rc = 126]
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SFrame: IP:77e52575 RA:00000000 FP:00000000 SP:0a230350
2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Params: 01:00000000 02:00000000 03:00000000 04:00000000
2008-11-11 14:35:26 0x53C ERR 19999 BTRACE Error writing mini dump, rc = -2147024865
2008-11-11 14:35:26 0x914 ERR 7 Messages Begin of dump of registered messages
2008-11-11 14:35:26 0x914 ERR 8 Messages End of the message list registry dump
2008-11-11 14:35:26 0x914 19820 EXCEPT calling ak dump for T86
2008-11-11 14:35:26 0x914 ERR 51105 AK CACHE AK00001.dmp written: 0
2008-11-11 14:35:26 0x914 19684 TASKING Tracewriter termination timeout: 1200 sec
2008-11-11 14:35:26 0x8FC 20000 Trace Start flush kernel trace
2008-11-11 14:35:26 0x8FC 19617 VOLUMEIO Single I/O attach, 'knltrace', UKT:1
2008-11-11 14:35:26 0x8FC 20001 Trace Stop flush kernel trace
2008-11-11 14:35:26 0x8FC 20002 Trace Start flush kernel dump
2008-11-11 14:36:17 0x8FC 20003 Trace Stop flush kernel dump
2008-11-11 14:36:23 0x8FC 19619 TASKING Releasing tracewriter
2008-11-11 14:36:23 0x914 19890 DIAGHIST Backup of diagnostic files will be forced at next restart
2008-11-11 14:36:23 0x914 19600 VERSION 'Kernel 7.6.05 Build 009-123-191-997'
2008-11-11 14:36:23 0x914 19654 DBSTATE SERVERDB 'P01' has stopped
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> The database suffered another kernel abort.
hmm... then a new forum entry might be useful to improve readability...
> Here is the last insert attempted by the application at 2008-11-11 14:35:26,280:
>
> INSERT INTO comments VALUES('3767c3ce-afed-11dd-8b32-b41baf254de5', '0', 94317, 'saeedas Viewed Member 1020303027', time('14:35:26'), date('2008-11-11'), 18)
>
>
> The row does not exist in the database when the database is restarted:
>
Of course the row is not present in the database after it crashed!
The DB crashed *before* the commit was done, so it's absolutely correct, that the row is not there after the instance recovery.
> Here is the output from knldiag:
>
> 2008-11-11 14:35:26 0x914 ERR 18793 EXCEPT EXCEPTION:'Access violation' (0xc0000005), The program code at IP:0x8eadba attempted to read to/from address:0x71d90000
> 2008-11-11 14:35:26 0x8CC 13809 RTE System page cache released 2560 pages in 5 blocks
> 2008-11-11 14:35:26 0x8CC 13810 RTE System page cache still holding 607 pages in 8 splitted blocks
> 2008-11-11 14:35:26 0x8CC 54000 MEMORY RTEMem_RteAllocator : could not allocat
> 2008-11-11 14:35:26 0x8CC 54000 MEMORY e memory
> 2008-11-11 14:35:26 0x8CC 54000 MEMORY required : 7271248
> 2008-11-11 14:35:26 0x8CC 54000 MEMORY allocated : 3145728
> 2008-11-11 14:35:26 0x8CC 54000 MEMORY supplement : 7274496
> 2008-11-11 14:35:26 0x8CC 54000 MEMORY limit : -1
> 2008-11-11 14:35:26 0x8CC 54000 MEMORY free blocks size 24 : 2
> 2008-11-11 14:35:26 0x8CC 54000 MEMORY free blocks size 232152 : 1
> 2008-11-11 14:35:26 0x914 19624 EXCEPT Kernel aborts
> 2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE Using 'imagehlp.dll' version: 4.0.5
> 2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE SymbolSearchPath: D:\Program-Files\sapdb\indep_data\wrk\P01;D:\PROGRAM-FILES\SAPDB\DEPEND\pgm;D:\PROGRAM-FILES\SAP
> 2008-11-11 14:35:26 0xAA0 ERR 19999 BTRACE
You're facing a memory problem.
What is the exact platform you're using? Windows 2003 SP xx ? Architecture?
Also notable are the missing function names from the stack back trace.
Did you delete the MaxDB symbols from the installation?
regards,
Lars
Hello
param_checkall and db_restart:
C:\
#dbmcli -d P01 -u , param_checkall
OK
C:\
#dbmcli -d P01 -u , db_restart
OK
knldiag after restart:
--------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2008-10-28 16:32:18 0x1144 20234 RTE Dump of all kernel parameters start
2008-10-28 16:32:18 0x1144 20207 RTE Using mode NORMAL for data volume 4
2008-10-28 16:32:18 0x1144 20235 RTE ADMIN=1
2008-10-28 16:32:18 0x1144 20235 RTE _AK_DUMP_ALLOWED=YES
2008-10-28 16:32:18 0x1144 20235 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO
2008-10-28 16:32:18 0x1144 20235 RTE AUTHENTICATION_ALLOW=
2008-10-28 16:32:18 0x1144 20235 RTE AUTHENTICATION_DENY=
2008-10-28 16:32:18 0x1144 20235 RTE AUTOSAVE=1
2008-10-28 16:32:18 0x1144 20235 RTE AUTO_RECREATE_BAD_INDEXES=NO
2008-10-28 16:32:18 0x1144 20235 RTE BACKUPRESULT=1
2008-10-28 16:32:18 0x1144 20235 RTE BACKUP_BLOCK_CNT=64
2008-10-28 16:32:18 0x1144 20235 RTE _BACKUP_HISTFILE=dbm.knl
2008-10-28 16:32:18 0x1144 20235 RTE _BACKUP_MED_DEF=dbm.mdf
2008-10-28 16:32:18 0x1144 20235 RTE CACHE_SIZE=196608
2008-10-28 16:32:18 0x1144 20235 RTE CALLSTACKLEVEL=0
2008-10-28 16:32:18 0x1144 20235 RTE _CAT_CACHE_MINSIZE=262144
2008-10-28 16:32:18 0x1144 20235 RTE CAT_CACHE_SUPPLY=3264
2008-10-28 16:32:18 0x1144 20235 RTE CHECKDATA=1
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_BACKUP=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_COMMON=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_CONVERTER=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_DATACACHE=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_DATAINDEX=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_DATAPAGELOG=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_FBM=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_HASHED_RESULTSET=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_IOMAN=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_KB_REGIONS=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_LOCK_SUPPLY=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_LOCK=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_LOGHISTORY=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_LOGPAGE=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_LOGTRANS=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_LOGVOLUME=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_QUERYREWRITE=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_REGIONS=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_SRVTASKS=0
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_TABLE_WIDTH=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_TASK_SPECIFIC_CATALOGCACHE=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_TRANSLIST=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_TREE_LOCKS=NO
2008-10-28 16:32:18 0x1144 20235 RTE CHECK_TREE=NO
2008-10-28 16:32:18 0x1144 20235 RTE CLUSTERCOMPRESSIONFILLTHRESHOLD=10
2008-10-28 16:32:18 0x1144 20235 RTE CLUSTERCOMPRESSIONTHRESHOLD=1000
2008-10-28 16:32:18 0x1144 20235 RTE CLUSTERED_LOBS=NO
2008-10-28 16:32:18 0x1144 20235 RTE CLUSTER_WRITE_THRESHOLD=80
2008-10-28 16:32:18 0x1144 20235 RTE COLUMNCOMPRESSION=YES
2008-10-28 16:32:18 0x1144 20235 RTE _COMMENT=
2008-10-28 16:32:18 0x1144 20235 RTE CONTROLPASSWORD=***
2008-10-28 16:32:18 0x1144 20235 RTE CONTROLUSERID=DBM
2008-10-28 16:32:18 0x1144 20235 RTE CONVERTER_REGIONS=16
2008-10-28 16:32:18 0x1144 20235 RTE DATABASEFULL=1
2008-10-28 16:32:18 0x1144 20235 RTE _DATA_CACHE_RGNS=64
2008-10-28 16:32:18 0x1144 20235 RTE DATA_IO_BLOCK_COUNT=64
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_GROUPS=1
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_MODE_0004=NORMAL
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_NAME_0001=H:\Database\P01-data\DiskD0001
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_NAME_0002=H:\Database\P01-data\DiskD0002
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_NAME_0003=H:\Database\P01-data\DiskD0003
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_NAME_0004=H:\Database\P01-data\DiskD0004
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_SIZE_0001=2048001
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_SIZE_0002=2048001
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_SIZE_0003=2048001
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_SIZE_0004=2048001
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_TYPE_0001=F
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_TYPE_0002=F
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_TYPE_0003=F
2008-10-28 16:32:18 0x1144 20235 RTE DATA_VOLUME_TYPE_0004=F
2008-10-28 16:32:18 0x1144 20235 RTE DATE_TIME_FORMAT=INTERNAL
2008-10-28 16:32:18 0x1144 20235 RTE DBFILLINGABOVELIMIT=70L80M85M90H95H96H97H98H99H
2008-10-28 16:32:18 0x1144 20235 RTE DBFILLINGBELOWLIMIT=70L80L85L90L95L
2008-10-28 16:32:18 0x1144 20235 RTE DDLTRIGGER=YES
2008-10-28 16:32:18 0x1144 20235 RTE DEADLOCK_DETECTION=4
2008-10-28 16:32:18 0x1144 20235 RTE DEADLOCK_DUMP_FILENAME=
2008-10-28 16:32:18 0x1144 20235 RTE DEFAULT_CODE=ASCII
2008-10-28 16:32:18 0x1144 20235 RTE _DELAY_COMMIT=NO
2008-10-28 16:32:18 0x1144 20235 RTE _DELAY_LOGWRITER=0
2008-10-28 16:32:18 0x1144 20235 RTE DIAG_HISTORY_NUM=2
2008-10-28 16:32:18 0x1144 20235 RTE DIAG_HISTORY_PATH=D:\Program-Files\sapdb\indep_data\wrk\P01\DIAGHISTORY
2008-10-28 16:32:18 0x1144 20235 RTE _DIAG_SEM=0
2008-10-28 16:32:18 0x1144 20235 RTE _DW_IO_AREA_FLUSH=50
2008-10-28 16:32:18 0x1144 20235 RTE _DW_IO_AREA_SIZE=50
2008-10-28 16:32:18 0x1144 20235 RTE _DW_LRU_TAIL_FLUSH=25
2008-10-28 16:32:18 0x1144 20235 RTE ENABLE_CHECK_INSTANCE=YES
2008-10-28 16:32:18 0x1144 20235 RTE ENABLE_SYSTEM_TRIGGERS=YES
2008-10-28 16:32:18 0x1144 20235 RTE ERROR=3
2008-10-28 16:32:18 0x1144 20235 RTE _EVENTFILE=knldiag.evt
2008-10-28 16:32:18 0x1144 20235 RTE _EVENTSIZE=0
2008-10-28 16:32:18 0x1144 20235 RTE EVENT=1
2008-10-28 16:32:18 0x1144 20235 RTE EXPAND_COM_TRACE=NO
2008-10-28 16:32:18 0x1144 20235 RTE EXTERNAL_DUMP_REQUEST=NO
2008-10-28 16:32:18 0x1144 20235 RTE FBM_CLUSTER_MODE=MIXED
2008-10-28 16:32:18 0x1144 20235 RTE _FBM_LOW_IO_RATE=10
2008-10-28 16:32:18 0x1144 20235 RTE FBM_VOLUME_BALANCE=10
2008-10-28 16:32:18 0x1144 20235 RTE FBM_VOLUME_COMPRESSION=50
2008-10-28 16:32:18 0x1144 20235 RTE FILEDIR_SPINLOCKPOOL_SIZE=10
2008-10-28 16:32:18 0x1144 20235 RTE FORBID_LOAD_BALANCING=NO
2008-10-28 16:32:18 0x1144 20235 RTE FORMATTING_MODE=PARALLEL
2008-10-28 16:32:18 0x1144 20235 RTE FORMAT_DATAVOLUME=YES
2008-10-28 16:32:18 0x1144 20235 RTE HASHED_RESULTSET_CACHESIZE=262144
2008-10-28 16:32:18 0x1144 20235 RTE HASHED_RESULTSET=NO
2008-10-28 16:32:18 0x1144 20235 RTE HEAP_CHECK_LEVEL=0
2008-10-28 16:32:18 0x1144 20235 RTE HIRES_TIMER_TYPE=CPU
2008-10-28 16:32:18 0x1144 20235 RTE HS_STORAGE_DLL=libhsscopy
2008-10-28 16:32:18 0x1144 20235 RTE HS_SYNC_INTERVAL=50
2008-10-28 16:32:18 0x1144 20235 RTE _IDXFILE_LIST_SIZE=2048
2008-10-28 16:32:18 0x1144 20235 RTE INDEX_LEAF_CACHING=2
2008-10-28 16:32:18 0x1144 20235 RTE INIT_ALLOCATORSIZE=249856
2008-10-28 16:32:18 0x1144 20235 RTE INSTANCE_TYPE=OLTP
2008-10-28 16:32:18 0x1144 20235 RTE _IOPROCS_FOR_PRIO=1
2008-10-28 16:32:18 0x1144 20235 RTE _IOPROCS_FOR_READER=0
2008-10-28 16:32:18 0x1144 20235 RTE _IOPROCS_PER_DEV=1
2008-10-28 16:32:18 0x1144 20235 RTE _IOPROCS_SWITCH=200
2008-10-28 16:32:18 0x1144 20235 RTE JOIN_MAXTAB_LEVEL4=16
2008-10-28 16:32:18 0x1144 20235 RTE JOIN_MAXTAB_LEVEL9=5
2008-10-28 16:32:18 0x1144 20235 RTE JOIN_SEARCH_LEVEL=0
2008-10-28 16:32:18 0x1144 20235 RTE JOIN_TABLEBUFFER=128
2008-10-28 16:32:18 0x1144 20235 RTE _KERNELDIAGFILE=knldiag
2008-10-28 16:32:19 0x1144 20235 RTE KERNELDIAGSIZE=800
2008-10-28 16:32:19 0x1144 20235 RTE _KERNELDUMPFILE=knldump
2008-10-28 16:32:19 0x1144 20235 RTE _KERNELTRACEFILE=knltrace
2008-10-28 16:32:19 0x1144 20235 RTE KERNELTRACESIZE=899
2008-10-28 16:32:19 0x1144 20235 RTE KERNELVERSION=KERNEL 7.6.05 BUILD 009-123-191-997
2008-10-28 16:32:19 0x1144 20235 RTE _LM_LOCK_REGIONS=0
2008-10-28 16:32:19 0x1144 20235 RTE _LM_REQUEST_REGIONS=0
2008-10-28 16:32:19 0x1144 20235 RTE _LM_TRANS_REGIONS=0
2008-10-28 16:32:19 0x1144 20235 RTE LOAD_BALANCING_CHK=0
2008-10-28 16:32:19 0x1144 20235 RTE LOAD_BALANCING_DIF=10
2008-10-28 16:32:19 0x1144 20235 RTE LOAD_BALANCING_EQ=5
2008-10-28 16:32:19 0x1144 20235 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0
2008-10-28 16:32:19 0x1144 20235 RTE _LOCKMANAGER_ENABLED=NO
2008-10-28 16:32:19 0x1144 20235 RTE _LOCK_SUPPLY_BLOCK=100
2008-10-28 16:32:19 0x1144 20235 RTE LOGABOVELIMIT=50L75L90M95M96H97H98H99H
2008-10-28 16:32:19 0x1144 20235 RTE LOGFULL=1
2008-10-28 16:32:19 0x1144 20235 RTE LOGSEGMENTFULL=1
2008-10-28 16:32:19 0x1144 20235 RTE LOG_BACKUP_TO_PIPE=NO
2008-10-28 16:32:19 0x1144 20235 RTE LOG_IO_BLOCK_COUNT=4
2008-10-28 16:32:19 0x1144 20235 RTE LOG_IO_QUEUE=50
2008-10-28 16:32:19 0x1144 20235 RTE LOG_MIRRORED=NO
2008-10-28 16:32:19 0x1144 20235 RTE LOG_QUEUE_COUNT=0
2008-10-28 16:32:19 0x1144 20235 RTE LOG_SEGMENT_SIZE=1365
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_NAME_001=H:\Database\P01-logs\LOG_001
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_NAME_002=H:\Database\P01-logs\LOG_002
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_NAME_003=H:\Database\P01-logs\LOG_003
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_NAME_004=H:\Database\P01-logs\LOG_004
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_NAME_005=H:\Database\P01-logs\LOG_005
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_NAME_006=H:\Database\P01-logs\LOG_006
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_SIZE_001=2049
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_SIZE_002=2049
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_SIZE_003=2049
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_SIZE_004=2049
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_SIZE_005=2049
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_SIZE_006=2049
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_TYPE_001=F
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_TYPE_002=F
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_TYPE_003=F
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_TYPE_004=F
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_TYPE_005=F
2008-10-28 16:32:19 0x1144 20235 RTE LOG_VOLUME_TYPE_006=F
2008-10-28 16:32:19 0x1144 20235 RTE LRU_FOR_SCAN=NO
2008-10-28 16:32:19 0x1144 20235 RTE MAXBACKUPDEVS=2
2008-10-28 16:32:19 0x1144 20235 RTE MAXCPU=3
2008-10-28 16:32:19 0x1144 20235 RTE MAXDATAVOLUMES=16
2008-10-28 16:32:19 0x1144 20235 RTE _MAXEVENTS=100
2008-10-28 16:32:19 0x1144 20235 RTE _MAXEVENTTASKS=2
2008-10-28 16:32:19 0x1144 20235 RTE _MAXGARBAGE_COLL=1
2008-10-28 16:32:19 0x1144 20235 RTE MAXLOCKS=4040
2008-10-28 16:32:19 0x1144 20235 RTE MAXLOGVOLUMES=8
2008-10-28 16:32:19 0x1144 20235 RTE MAXPAGER=64
2008-10-28 16:32:19 0x1144 20235 RTE MAXRGN_REQUEST=3000
2008-10-28 16:32:19 0x1144 20235 RTE MAXSERVERTASKS=38
2008-10-28 16:32:19 0x1144 20235 RTE _MAXTASK_STACK=1024
2008-10-28 16:32:19 0x1144 20235 RTE _MAXTRANS=404
2008-10-28 16:32:19 0x1144 20235 RTE MAXUSERTASKS=50
2008-10-28 16:32:19 0x1144 20235 RTE MAXVOLUMES=25
2008-10-28 16:32:19 0x1144 20235 RTE MAX_HASHTABLE_MEMORY=5120
2008-10-28 16:32:19 0x1144 20235 RTE MAX_LOG_QUEUE_COUNT=0
2008-10-28 16:32:19 0x1144 20235 RTE _MAX_MESSAGE_FILES=0
2008-10-28 16:32:19 0x1144 20235 RTE MAX_MESSAGE_LIST_LENGTH=100
2008-10-28 16:32:19 0x1144 20235 RTE MAX_RETENTION_TIME=480
2008-10-28 16:32:19 0x1144 20235 RTE MAX_SERVERTASK_STACK=500
2008-10-28 16:32:19 0x1144 20235 RTE MAX_SINGLE_HASHTABLE_SIZE=512
2008-10-28 16:32:19 0x1144 20235 RTE MAX_SPECIALTASK_STACK=500
2008-10-28 16:32:19 0x1144 20235 RTE _MBLOCK_DATA_SIZE=32768
2008-10-28 16:32:19 0x1144 20235 RTE _MBLOCK_QUAL_SIZE=32768
2008-10-28 16:32:19 0x1144 20235 RTE _MBLOCK_STACK_SIZE=32768
2008-10-28 16:32:19 0x1144 20235 RTE _MBLOCK_STRAT_SIZE=8192
2008-10-28 16:32:19 0x1144 20235 RTE MCOD=NO
2008-10-28 16:32:19 0x1144 20235 RTE MEMORY_ALLOCATION_LIMIT=0
2008-10-28 16:32:19 0x1144 20235 RTE MINI_DUMP=NORMAL
2008-10-28 16:32:19 0x1144 20235 RTE _MINREPLY_SIZE=4096
2008-10-28 16:32:19 0x1144 20235 RTE MINSERVERTASKS=38
2008-10-28 16:32:19 0x1144 20235 RTE MIN_RETENTION_TIME=60
2008-10-28 16:32:19 0x1144 20235 RTE MONITOR_READ=2147483647
2008-10-28 16:32:19 0x1144 20235 RTE MONITOR_ROWNO=0
2008-10-28 16:32:19 0x1144 20235 RTE MONITOR_SELECTIVITY=0
2008-10-28 16:32:19 0x1144 20235 RTE MONITOR_TIME=2147483647
2008-10-28 16:32:19 0x1144 20235 RTE _MP_DISP_LOOPS=1
2008-10-28 16:32:19 0x1144 20235 RTE _MP_DISP_PRIO=YES
2008-10-28 16:32:19 0x1144 20235 RTE _MP_RGN_BUSY_WAIT=YES
2008-10-28 16:32:19 0x1144 20235 RTE _MP_RGN_DIRTY_READ=YES
2008-10-28 16:32:19 0x1144 20235 RTE MP_RGN_LOOP=-1
2008-10-28 16:32:19 0x1144 20235 RTE _MP_RGN_PRIO=YES
2008-10-28 16:32:19 0x1144 20235 RTE _MP_RGN_QUEUE=YES
2008-10-28 16:32:19 0x1144 20235 RTE OFFICIAL_NODE=
2008-10-28 16:32:19 0x1144 20235 RTE OMS_HEAP_BLOCKSIZE=10000
2008-10-28 16:32:19 0x1144 20235 RTE OMS_HEAP_COUNT=3
2008-10-28 16:32:19 0x1144 20235 RTE OMS_HEAP_LIMIT=0
2008-10-28 16:32:19 0x1144 20235 RTE OMS_HEAP_THRESHOLD=100
2008-10-28 16:32:19 0x1144 20235 RTE _OMS_REGIONS=0
2008-10-28 16:32:19 0x1144 20235 RTE _OMS_RGNS=7
2008-10-28 16:32:19 0x1144 20235 RTE OMS_RUN_IN_UDE_SERVER=NO
2008-10-28 16:32:19 0x1144 20235 RTE OMS_STREAM_TIMEOUT=30
2008-10-28 16:32:19 0x1144 20235 RTE OMS_VERS_THRESHOLD=2097152
2008-10-28 16:32:19 0x1144 20235 RTE ONLINE=1
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_AGGREGATION=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_FETCH_REVERSE=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_FIRST_ROWS=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_JOIN_HASHTABLE=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_JOIN_HASH_MINIMAL_RATIO=1
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_JOIN_ONEPHASE=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_JOIN_OUTER=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_JOIN_PARALLEL_MINSIZE=1000000
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_MIN_MAX=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_OPERATOR_JOIN=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_QUAL_ON_INDEX=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_QUERYREWRITE=OPERATOR
2008-10-28 16:32:19 0x1144 20235 RTE OPTIMIZE_STAR_JOIN=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIM_CACHE=NO
2008-10-28 16:32:19 0x1144 20235 RTE OPTIM_INV_ONLY=YES
2008-10-28 16:32:19 0x1144 20235 RTE OPTIM_JOIN_FETCH=0
2008-10-28 16:32:19 0x1144 20235 RTE OPTIM_MAX_MERGE=500
2008-10-28 16:32:19 0x1144 20235 RTE OUTOFSESSIONS=3
2008-10-28 16:32:19 0x1144 20235 RTE _PACKET_SIZE=36864
2008-10-28 16:32:19 0x1144 20235 RTE _PAGE_SIZE=8192
2008-10-28 16:32:19 0x1144 20235 RTE __PARAM_CHANGED___=0
2008-10-28 16:32:19 0x1144 20235 RTE __PARAM_VERIFIED__=2005-06-11 11:30:49
2008-10-28 16:32:19 0x1144 20235 RTE PREALLOCATE_IOWORKER=NO
2008-10-28 16:32:19 0x1144 20235 RTE _PRIO_BASE_COM=10
2008-10-28 16:32:19 0x1144 20235 RTE _PRIO_BASE_IOC=80
2008-10-28 16:32:19 0x1144 20235 RTE _PRIO_BASE_RAV=80
2008-10-28 16:32:19 0x1144 20235 RTE _PRIO_BASE_REX=40
2008-10-28 16:32:19 0x1144 20235 RTE _PRIO_BASE_U2U=100
2008-10-28 16:32:19 0x1144 20235 RTE _PRIO_FACTOR=80
2008-10-28 16:32:19 0x1144 20235 RTE PROTECT_DATACACHE_MEMORY=NO
2008-10-28 16:32:19 0x1144 20235 RTE _READAHEAD_BLOBS=32
2008-10-28 16:32:19 0x1144 20235 RTE READAHEAD_TABLE_THRESHOLD=0
2008-10-28 16:32:19 0x1144 20235 RTE REQUEST_TIMEOUT=5000
2008-10-28 16:32:19 0x1144 20235 RTE RESERVEDSERVERTASKS=21
2008-10-28 16:32:19 0x1144 20235 RTE _RESTART_TIME=600
2008-10-28 16:32:19 0x1144 20235 RTE ROW_LOCKS_PER_TRANSACTION=50
2008-10-28 16:32:19 0x1144 20235 RTE _ROW_RGNS=8
2008-10-28 16:32:19 0x1144 20235 RTE _RTEDUMPFILE=rtedump
2008-10-28 16:32:19 0x1144 20235 RTE RTE_TEST_REGIONS=0
2008-10-28 16:32:19 0x1144 20235 RTE RUNDIRECTORY=D:\Program-Files\sapdb\indep_data\wrk\P01
2008-10-28 16:32:19 0x1144 20235 RTE SEQUENCE_CACHE=1
2008-10-28 16:32:19 0x1144 20235 RTE _SERVERDB_FOR_SAP=NO
2008-10-28 16:32:19 0x1144 20235 RTE SESSION_TIMEOUT=900
2008-10-28 16:32:19 0x1144 20235 RTE SET_VOLUME_LOCK=YES
2008-10-28 16:32:19 0x1144 20235 RTE SHAREDSQL_CLEANUPTHRESHOLD=25
2008-10-28 16:32:19 0x1144 20235 RTE SHAREDSQL_COMMANDCACHESIZE=262144
2008-10-28 16:32:19 0x1144 20235 RTE SHAREDSQL=YES
2008-10-28 16:32:19 0x1144 20235 RTE SHOW_MAX_KB_STACK_USE=NO
2008-10-28 16:32:19 0x1144 20235 RTE SHOW_MAX_STACK_USE=NO
2008-10-28 16:32:19 0x1144 20235 RTE SPINLOCK_BACKOFF_BASE=1
2008-10-28 16:32:19 0x1144 20235 RTE SPINLOCK_BACKOFF_FACTOR=2
2008-10-28 16:32:19 0x1144 20235 RTE SPINLOCK_BACKOFF_MAXIMUM=64
2008-10-28 16:32:19 0x1144 20235 RTE SPINLOCK_LOOP_COUNT=30000
2008-10-28 16:32:19 0x1144 20235 RTE STANDBY=1
2008-10-28 16:32:19 0x1144 20235 RTE SUBTREE_LOCKS=NO
2008-10-28 16:32:19 0x1144 20235 RTE SYMBOL_DEMANGLING=NO
2008-10-28 16:32:19 0x1144 20235 RTE SYMBOL_RESOLUTION=YES
2008-10-28 16:32:19 0x1144 20235 RTE SYSTEMERROR=3
2008-10-28 16:32:19 0x1144 20235 RTE _TAB_RGNS=8
2008-10-28 16:32:19 0x1144 20235 RTE _TASKCLUSTER_01=tw;al;ut;2000*sv,100*bup;10*ev,10*gc;
2008-10-28 16:32:19 0x1144 20235 RTE _TASKCLUSTER_02=ti,100*dw;17*us;
2008-10-28 16:32:19 0x1144 20235 RTE _TASKCLUSTER_03=equalize
2008-10-28 16:32:19 0x1144 20235 RTE TIME_MEASUREMENT=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_AK=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_ALLOCATOR=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_CATALOG=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_CLIENTKERNELCOM=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_COMMON=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_COMMUNICATION=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_CONVERTER=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_DATACACHE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_DATACHAIN=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_DATAINDEX=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_DATAPAM=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_DATATREE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_DBPROC=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_DEFAULT=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_DELETE=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_FBM=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_FILEDIR=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_FRAMECTRL=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_INDEX=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_INSERT=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_IOMAN=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_IPC=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_JOIN=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_KSQL=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_LOCKMANAGER=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_LOCK=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_LOGACTION=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_LOGHISTORY=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_LOGPAGE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_LOGTRANS=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_LOGVOLUME=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_LONG=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_MEMORY=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_MESSAGES=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OBJECTCONTAINER=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OBJECT_ADD=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OBJECT_ALTER=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OBJECT_FREE=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OBJECT_GET=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OBJECT=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_CONTAINERDIR=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_CONTEXT=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_ERROR=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_FLUSHCACHE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_INTERFACE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_KEYRANGE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_KEY=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_LOCK=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_MEMORY=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_NEWOBJ=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_SESSION=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_STREAM=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_VAROBJECT=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OMS_VERSION=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_OPTIMIZE=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_ORDER_STANDARD=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_ORDER=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGER=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_BUP=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_EV=2
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_GC=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_LW=5
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_PG=3
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_SV=5
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_TI=2
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_US=10
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES_UT=5
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PAGES=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_PRIMARY_TREE=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_QUERYREWRITE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_RUNTIME=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_SELECT=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_SHAREDSQL=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_SQLMANAGER=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_SRVTASKS=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_STOP_ERRORCODE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_SYNCHRONISATION=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_SYSVIEW=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_TABLE=0
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_TIME=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_UPDATE=NO
2008-10-28 16:32:19 0x1144 20235 RTE TRACE_VOLUME=0
2008-10-28 16:32:19 0x1144 20235 RTE TRANS_HISTORY_SIZE=0
2008-10-28 16:32:19 0x1144 20235 RTE _TRANS_RGNS=8
2008-10-28 16:32:19 0x1144 20235 RTE TRANS_THRESHOLD_VALUE=60
2008-10-28 16:32:19 0x1144 20235 RTE UKT_CPU_RELATIONSHIP=NONE
2008-10-28 16:32:19 0x1144 20235 RTE _UNICODE=YES
2008-10-28 16:32:19 0x1144 20235 RTE UPDATESTAT_PARALLEL_SERVERS=0
2008-10-28 16:32:19 0x1144 20235 RTE UPDATESTAT_SAMPLE_ALGO=1
2008-10-28 16:32:19 0x1144 20235 RTE UPDSTATWANTED=1
2008-10-28 16:32:19 0x1144 20235 RTE USED_MAX_LOG_QUEUE_COUNT=3
2008-10-28 16:32:19 0x1144 20235 RTE USESELECTFETCH=YES
2008-10-28 16:32:19 0x1144 20235 RTE USEUNICODECOLUMNCOMPRESSION=NO
2008-10-28 16:32:19 0x1144 20235 RTE USEVARIABLEINPUT=NO
2008-10-28 16:32:19 0x1144 20235 RTE _USE_ASYNC_IO=YES
2008-10-28 16:32:19 0x1144 20235 RTE USE_BACKUP_SECURITY_DESCRIPTOR=YES
2008-10-28 16:32:19 0x1144 20235 RTE USE_COROUTINES=YES
2008-10-28 16:32:19 0x1144 20235 RTE USE_FIBERS=YES
2008-10-28 16:32:19 0x1144 20235 RTE _USE_IOPROCS_ONLY=NO
2008-10-28 16:32:19 0x1144 20235 RTE USE_OPEN_DIRECT_FOR_BACKUP=NO
2008-10-28 16:32:19 0x1144 20235 RTE USE_OPEN_DIRECT=NO
2008-10-28 16:32:19 0x1144 20235 RTE USE_SYSTEM_PAGE_CACHE=YES
2008-10-28 16:32:19 0x1144 20235 RTE _UTILITY_PROTFILE=dbm.utl
2008-10-28 16:32:19 0x1144 20235 RTE UTILITY_PROTSIZE=100
2008-10-28 16:32:19 0x1144 20235 RTE VOLUMENO_BIT_COUNT=8
2008-10-28 16:32:19 0x1144 20235 RTE _WORKDATA_SIZE=4096
2008-10-28 16:32:19 0x1144 20235 RTE _WORKSTACK_SIZE=8192
2008-10-28 16:32:19 0x1144 20235 RTE XP_CONVERTER_REGIONS=0
2008-10-28 16:32:19 0x1144 20235 RTE XP_DATA_CACHE_RGNS=0
2008-10-28 16:32:19 0x1144 20235 RTE XP_MAXPAGER=0
2008-10-28 16:32:19 0x1144 20236 RTE Dump of all kernel parameters done
2008-10-28 16:32:19 0x1144 19600 VERSION 'Kernel 7.6.05 Build 009-123-191-997'
2008-10-28 16:32:19 0x1144 19600 VERSION 'W32/INTEL 7.6.05 Build 009-123-191-997'
2008-10-28 16:32:19 0x1144 19769 INFO Starting SERVERDB: 'P01'
2008-10-28 16:32:19 0x1144 19770 INFO SERVERNODE: 'tulip.pha.co.za'
2008-10-28 16:32:19 0x1144 19771 INFO Process ID: 4408
2008-10-28 16:32:19 0x1144 19773 INFO Date: 2008-10-28
2008-10-28 16:32:19 0x1144 19772 INFO Owner: 'SYSTEM'
2008-10-28 16:32:19 0x1144 19774 INFO Product suite: 'Terminal Server'
2008-10-28 16:32:19 0x1144 19806 INFO Machine: 'Intel IA32 level f revision 209'
2008-10-28 16:32:19 0x1144 19783 INFO Processors: 2 ( logical: 4 )
2008-10-28 16:32:19 0x1144 19782 INFO Fiber: 'YES'
2008-10-28 16:32:19 0x1144 19776 INFO Max virtual memory: 2047 MB
2008-10-28 16:32:19 0x1144 19777 INFO Total physical memory: 3839 MB
2008-10-28 16:32:19 0x1144 19778 INFO Available physical memory: 2995 MB
2008-10-28 16:32:19 0x1144 20220 RTE Memory allocation not limited
2008-10-28 16:32:19 0x1144 20221 RTE System page cache usage enabled
2008-10-28 16:32:19 0x1144 19692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;17*us;equalize
2008-10-28 16:32:19 0x1144 19693 TCLUSTER number of 'BUP': 0
2008-10-28 16:32:19 0x1144 19693 TCLUSTER number of ' DW': 64
2008-10-28 16:32:19 0x1144 19693 TCLUSTER number of ' US': 50
2008-10-28 16:32:19 0x1144 19693 TCLUSTER number of ' SV': 38
2008-10-28 16:32:19 0x1144 19693 TCLUSTER number of ' EV': 2
2008-10-28 16:32:19 0x1144 19693 TCLUSTER number of ' GC': 1
2008-10-28 16:32:19 0x1144 19692 TCLUSTER Total Number of UKT 9
2008-10-28 16:32:19 0x1144 19692 TCLUSTER Number of UKT with User Tasks 3
2008-10-28 16:32:19 0x1144 19860 MEMORY I/O buffer cache: 196608 Pages allocated
2008-10-28 16:32:19 0x1144 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages
2008-10-28 16:32:19 0x1144 19812 EVENTING Eventbuffer 100 events 2 tasks
2008-10-28 16:32:19 0x124C 19821 TASKING Thread 4684 starting
2008-10-28 16:32:19 0x1144 19831 TRACE_IO Configured _MAX_MESSAGE_FILES:0
2008-10-28 16:32:19 0x1144 19832 TRACE_IO Disabled: No TraceMessagefiles wanted
2008-10-28 16:32:19 0x1130 19688 THREAD CLOCK thread started
2008-10-28 16:32:19 0xD64 19688 THREAD TIMER thread started
2008-10-28 16:32:19 0x15F4 19688 THREAD ASYNC0 thread started
2008-10-28 16:32:19 0x8DC 19688 THREAD REQUESTOR thread started
2008-10-28 16:32:19 0xEC8 19821 TASKING Thread 3784 starting
2008-10-28 16:32:19 0x1368 19821 TASKING Thread 4968 starting
2008-10-28 16:32:19 0x7E0 20214 RTE CONSOLE thread started
2008-10-28 16:32:19 0x3D4 19821 TASKING Thread 980 starting
2008-10-28 16:32:19 0x650 19821 TASKING Thread 1616 starting
2008-10-28 16:32:19 0x1298 19821 TASKING Thread 4760 starting
2008-10-28 16:32:19 0x117C 19821 TASKING Thread 4476 starting
2008-10-28 16:32:19 0xB80 19821 TASKING Thread 2944 starting
2008-10-28 16:32:19 0xF98 19821 TASKING Thread 3992 starting
2008-10-28 16:32:19 0x1644 19821 TASKING Thread 5700 starting
2008-10-28 16:32:19 0x838 19821 TASKING Thread 2104 starting
2008-10-28 16:32:19 0xC90 19821 TASKING Thread 3216 starting
2008-10-28 16:32:19 0x177C 19627 TASKING UKT started, TID:0x177C
2008-10-28 16:32:19 0x16CC 19627 TASKING UKT started, TID:0x16CC
2008-10-28 16:32:19 0x173C 19627 TASKING UKT started, TID:0x173C
2008-10-28 16:32:19 0x1274 19627 TASKING UKT started, TID:0x1274
2008-10-28 16:32:19 0x140C 19627 TASKING UKT started, TID:0x140C
2008-10-28 16:32:19 0xFB0 19627 TASKING UKT started, TID:0xFB0
2008-10-28 16:32:19 0xE5C 19627 TASKING UKT started, TID:0xE5C
2008-10-28 16:32:19 0x338 19627 TASKING UKT started, TID:0x338
2008-10-28 16:32:19 0x14B0 19627 TASKING UKT started, TID:0x14B0
2008-10-28 16:32:19 0x14B0 19615 VOLUMEIO Attaching volume 'knltrace'
2008-10-28 16:32:19 0xD54 19613 DBSTATE I/O thread for 'knltrace' started
2008-10-28 16:32:20 0x14B0 20040 Admin Kernel state: 'ADMIN' reached
2008-10-28 16:32:20 0x14B0 9 SrvTasks Available Servertasks: 38
2008-10-28 16:32:20 0x14B0 54003 dynpool HIST_DIR item size : 8
2008-10-28 16:32:20 0x14B0 54003 dynpool HIST_DIR num items : 50
2008-10-28 16:32:20 0x14B0 54003 dynpool DYNP_B930_HIST_DIR : 400
2008-10-28 16:32:20 0x14B0 54003 dynDATA DYND_K57_KB_PAGES : 11
2008-10-28 16:32:20 0x14B0 54003 dynDATA BACKUP RESTART REC (8K): 1
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP TASK LIST : 288
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP TAPE LIST : 672
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP DEVSP LIST : 128
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP VOL IDX LIST : 32
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP SRR QUEUE : 896
2008-10-28 16:32:20 0x14B0 54003 dynpool DYNP_K38_SAVE_GLOB : 1888
2008-10-28 16:32:20 0x14B0 54003 dynDATA DYND_K38_SAVE : 2369
2008-10-28 16:32:20 0x14B0 54003 dynDATA BACKUP RESTART REC (8K): 1
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP TASK LIST : 32
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP TAPE LIST : 672
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP DEVSP LIST : 16
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP VOL IDX LIST : 32
2008-10-28 16:32:20 0x14B0 54003 dynpool BACKUP SRR QUEUE : 128
2008-10-28 16:32:20 0x14B0 54003 dynpool DYNP_K38_AUTOSAVE : 864
2008-10-28 16:32:20 0x14B0 54003 dynDATA DYND_K38_AUTOSAVE : 321
2008-10-28 16:32:20 0x14B0 19930 TASKING Kernel initialization completed
If the kernel aborts again I should have a log of the exact SQL INSERT statement that it tried to execute.
Regards
Bradley
Edited by: Bradley Patchett on Oct 29, 2008 7:03 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
No the Transaction_Log doesn't have LOB-columns. I think that is the last successful SQL statement. The very next thing the application does is an INSERT into a table (Comments) that does contain a LOB-column. The corresponding row that should exist in the Comments table does not exist. Not every INSERT creates a kernel abort. Here is the Java string of the SQL that the application attempts to execute (The parse method escapes any single quotes and text is anything that a user types in):
"INSERT INTO comments " +
"VALUES('" + itid + "', " + // ITID
"'0', " + // MTID
memberUniId + ", " + // UNI_ID
"'" + parse(text) + "', " + // COMMENT
"time('" + TIME_FORMAT.format(now) + "'), " + // COMMENT_TIME
"date('" + DATE_FORMAT.format(now) +"'), " + // COMMENT_DATE
commentTypeId + ")"; // COMMENT_ID
And here is the Comments table definition:
CREATE TABLE "TEST"."COMMENTS"
(
ITID varchar(40),
MTID varchar(40),
UNI_ID int,
COMMENT long ascii,
COMMENT_TIME time,
COMMENT_DATE date,
COMMENT_ID int
)
;
CREATE INDEX COMMENT2 ON COMMENTS(COMMENT_ID)
;
CREATE INDEX COMMENT1 ON COMMENTS(UNI_ID)
;
Unfortunately this statement is not logged anywhere by the application before being executed. I will start logging these statements before execution.
I don't know how the parameters were set. I will do the param_checkall and restart the database but I can only do that at the end of the day as the database is a production database.
Regards
Bradley
Edited by: Bradley Patchett on Oct 28, 2008 8:40 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
I have
2008-10-22 17:31:44.835 Updating sql: INSERT INTO Transaction_Log(itid, uni_id, trans_description, start_time) VALUES ('8876995f-a04e-11dd-9c0d-c3e057f5b632', 1142101, 'Save Comments', '2008-10-22 17:31:44.835')
and
2008-10-27 12:17:35.321 Updating sql: INSERT INTO Transaction_Log(itid, uni_id, trans_description, start_time) VALUES ('7957c49d-a410-11dd-a298-a58e024a127d', 1317299, 'Save Comments', '2008-10-27 12:17:35.321')
from the application log. Both rows were created successfully and the times match the kernel abort times. I will find out what the next SQL statement executed immediately after this INSERT is.
In the mean time here are the parameters:
--------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2008-10-24 03:06:31 0xDC 20234 RTE Dump of all kernel parameters start
2008-10-24 03:06:31 0xDC 20207 RTE Using mode NORMAL for data volume 4
2008-10-24 03:06:31 0xDC 20235 RTE ADMIN=1
2008-10-24 03:06:31 0xDC 20235 RTE _AK_DUMP_ALLOWED=YES
2008-10-24 03:06:31 0xDC 20235 RTE ALLOW_MULTIPLE_SERVERTASK_UKTS=NO
2008-10-24 03:06:31 0xDC 20235 RTE AUTHENTICATION_ALLOW=
2008-10-24 03:06:31 0xDC 20235 RTE AUTHENTICATION_DENY=
2008-10-24 03:06:31 0xDC 20235 RTE AUTOSAVE=1
2008-10-24 03:06:31 0xDC 20235 RTE AUTO_RECREATE_BAD_INDEXES=NO
2008-10-24 03:06:31 0xDC 20235 RTE BACKUPRESULT=1
2008-10-24 03:06:31 0xDC 20235 RTE BACKUP_BLOCK_CNT=64
2008-10-24 03:06:31 0xDC 20235 RTE _BACKUP_HISTFILE=dbm.knl
2008-10-24 03:06:31 0xDC 20235 RTE _BACKUP_MED_DEF=dbm.mdf
2008-10-24 03:06:31 0xDC 20235 RTE CACHE_SIZE=196608
2008-10-24 03:06:31 0xDC 20235 RTE CALLSTACKLEVEL=0
2008-10-24 03:06:31 0xDC 20235 RTE _CAT_CACHE_MINSIZE=262144
2008-10-24 03:06:31 0xDC 20235 RTE CAT_CACHE_SUPPLY=3264
2008-10-24 03:06:31 0xDC 20235 RTE CHECKDATA=1
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_BACKUP=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_COMMON=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_CONVERTER=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_DATACACHE=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_DATAINDEX=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_DATAPAGELOG=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_FBM=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_HASHED_RESULTSET=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_IOMAN=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_KB_REGIONS=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_LOCK_SUPPLY=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_LOCK=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_LOGHISTORY=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_LOGPAGE=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_LOGTRANS=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_LOGVOLUME=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_QUERYREWRITE=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_REGIONS=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_SRVTASKS=0
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_TABLE_WIDTH=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_TASK_SPECIFIC_CATALOGCACHE=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_TRANSLIST=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_TREE_LOCKS=NO
2008-10-24 03:06:31 0xDC 20235 RTE CHECK_TREE=NO
2008-10-24 03:06:31 0xDC 20235 RTE CLUSTERCOMPRESSIONFILLTHRESHOLD=10
2008-10-24 03:06:31 0xDC 20235 RTE CLUSTERCOMPRESSIONTHRESHOLD=1000
2008-10-24 03:06:31 0xDC 20235 RTE CLUSTERED_LOBS=NO
2008-10-24 03:06:31 0xDC 20235 RTE CLUSTER_WRITE_THRESHOLD=80
2008-10-24 03:06:31 0xDC 20235 RTE COLUMNCOMPRESSION=YES
2008-10-24 03:06:31 0xDC 20235 RTE _COMMENT=
2008-10-24 03:06:31 0xDC 20235 RTE CONTROLPASSWORD=***
2008-10-24 03:06:31 0xDC 20235 RTE CONTROLUSERID=DBM
2008-10-24 03:06:31 0xDC 20235 RTE CONVERTER_REGIONS=16
2008-10-24 03:06:31 0xDC 20235 RTE DATABASEFULL=1
2008-10-24 03:06:31 0xDC 20235 RTE _DATA_CACHE_RGNS=64
2008-10-24 03:06:31 0xDC 20235 RTE DATA_IO_BLOCK_COUNT=64
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_GROUPS=1
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_MODE_0004=NORMAL
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_NAME_0001=H:\Database\P01-data\DiskD0001
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_NAME_0002=H:\Database\P01-data\DiskD0002
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_NAME_0003=H:\Database\P01-data\DiskD0003
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_NAME_0004=H:\Database\P01-data\DiskD0004
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_SIZE_0001=2048001
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_SIZE_0002=2048001
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_SIZE_0003=2048001
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_SIZE_0004=2048001
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_TYPE_0001=F
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_TYPE_0002=F
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_TYPE_0003=F
2008-10-24 03:06:31 0xDC 20235 RTE DATA_VOLUME_TYPE_0004=F
2008-10-24 03:06:31 0xDC 20235 RTE DATE_TIME_FORMAT=INTERNAL
2008-10-24 03:06:31 0xDC 20235 RTE DBFILLINGABOVELIMIT=70L80M85M90H95H96H97H98H99H
2008-10-24 03:06:31 0xDC 20235 RTE DBFILLINGBELOWLIMIT=70L80L85L90L95L
2008-10-24 03:06:31 0xDC 20235 RTE DDLTRIGGER=YES
2008-10-24 03:06:32 0xDC 20235 RTE DEADLOCK_DETECTION=4
2008-10-24 03:06:32 0xDC 20235 RTE DEADLOCK_DUMP_FILENAME=
2008-10-24 03:06:32 0xDC 20235 RTE DEFAULT_CODE=ASCII
2008-10-24 03:06:32 0xDC 20235 RTE _DELAY_COMMIT=NO
2008-10-24 03:06:32 0xDC 20235 RTE _DELAY_LOGWRITER=0
2008-10-24 03:06:32 0xDC 20235 RTE DIAG_HISTORY_NUM=2
2008-10-24 03:06:32 0xDC 20235 RTE DIAG_HISTORY_PATH=D:\Program-Files\sapdb\indep_data\wrk\P01\DIAGHISTORY
2008-10-24 03:06:32 0xDC 20235 RTE _DIAG_SEM=0
2008-10-24 03:06:32 0xDC 20235 RTE _DW_IO_AREA_FLUSH=50
2008-10-24 03:06:32 0xDC 20235 RTE _DW_IO_AREA_SIZE=50
2008-10-24 03:06:32 0xDC 20235 RTE _DW_LRU_TAIL_FLUSH=25
2008-10-24 03:06:32 0xDC 20235 RTE ENABLE_CHECK_INSTANCE=YES
2008-10-24 03:06:32 0xDC 20235 RTE ENABLE_SYSTEM_TRIGGERS=YES
2008-10-24 03:06:32 0xDC 20235 RTE ERROR=3
2008-10-24 03:06:32 0xDC 20235 RTE _EVENTFILE=knldiag.evt
2008-10-24 03:06:32 0xDC 20235 RTE _EVENTSIZE=0
2008-10-24 03:06:32 0xDC 20235 RTE EVENT=1
2008-10-24 03:06:32 0xDC 20235 RTE EXPAND_COM_TRACE=NO
2008-10-24 03:06:32 0xDC 20235 RTE EXTERNAL_DUMP_REQUEST=NO
2008-10-24 03:06:32 0xDC 20235 RTE FBM_CLUSTER_MODE=MIXED
2008-10-24 03:06:32 0xDC 20235 RTE _FBM_LOW_IO_RATE=10
2008-10-24 03:06:32 0xDC 20235 RTE FBM_VOLUME_BALANCE=10
2008-10-24 03:06:32 0xDC 20235 RTE FBM_VOLUME_COMPRESSION=50
2008-10-24 03:06:32 0xDC 20235 RTE FILEDIR_SPINLOCKPOOL_SIZE=10
2008-10-24 03:06:32 0xDC 20235 RTE FORBID_LOAD_BALANCING=NO
2008-10-24 03:06:32 0xDC 20235 RTE FORMATTING_MODE=PARALLEL
2008-10-24 03:06:32 0xDC 20235 RTE FORMAT_DATAVOLUME=YES
2008-10-24 03:06:32 0xDC 20235 RTE HASHED_RESULTSET_CACHESIZE=262144
2008-10-24 03:06:32 0xDC 20235 RTE HASHED_RESULTSET=NO
2008-10-24 03:06:32 0xDC 20235 RTE HEAP_CHECK_LEVEL=0
2008-10-24 03:06:32 0xDC 20235 RTE HIRES_TIMER_TYPE=CPU
2008-10-24 03:06:32 0xDC 20235 RTE HS_STORAGE_DLL=libhsscopy
2008-10-24 03:06:32 0xDC 20235 RTE HS_SYNC_INTERVAL=50
2008-10-24 03:06:32 0xDC 20235 RTE _IDXFILE_LIST_SIZE=2048
2008-10-24 03:06:32 0xDC 20235 RTE INDEX_LEAF_CACHING=2
2008-10-24 03:06:32 0xDC 20235 RTE INIT_ALLOCATORSIZE=249856
2008-10-24 03:06:32 0xDC 20235 RTE INSTANCE_TYPE=OLTP
2008-10-24 03:06:32 0xDC 20235 RTE _IOPROCS_FOR_PRIO=1
2008-10-24 03:06:32 0xDC 20235 RTE _IOPROCS_FOR_READER=0
2008-10-24 03:06:32 0xDC 20235 RTE _IOPROCS_PER_DEV=1
2008-10-24 03:06:32 0xDC 20235 RTE _IOPROCS_SWITCH=200
2008-10-24 03:06:32 0xDC 20235 RTE JOIN_MAXTAB_LEVEL4=16
2008-10-24 03:06:32 0xDC 20235 RTE JOIN_MAXTAB_LEVEL9=5
2008-10-24 03:06:32 0xDC 20235 RTE JOIN_SEARCH_LEVEL=0
2008-10-24 03:06:32 0xDC 20235 RTE JOIN_TABLEBUFFER=128
2008-10-24 03:06:32 0xDC 20235 RTE _KERNELDIAGFILE=knldiag
2008-10-24 03:06:32 0xDC 20235 RTE KERNELDIAGSIZE=800
2008-10-24 03:06:32 0xDC 20235 RTE _KERNELDUMPFILE=knldump
2008-10-24 03:06:32 0xDC 20235 RTE _KERNELTRACEFILE=knltrace
2008-10-24 03:06:32 0xDC 20235 RTE KERNELTRACESIZE=899
2008-10-24 03:06:32 0xDC 20235 RTE KERNELVERSION=KERNEL 7.6.05 BUILD 009-123-191-997
2008-10-24 03:06:32 0xDC 20235 RTE _LM_LOCK_REGIONS=0
2008-10-24 03:06:32 0xDC 20235 RTE _LM_REQUEST_REGIONS=0
2008-10-24 03:06:32 0xDC 20235 RTE _LM_TRANS_REGIONS=0
2008-10-24 03:06:32 0xDC 20235 RTE LOAD_BALANCING_CHK=0
2008-10-24 03:06:32 0xDC 20235 RTE LOAD_BALANCING_DIF=10
2008-10-24 03:06:32 0xDC 20235 RTE LOAD_BALANCING_EQ=5
2008-10-24 03:06:32 0xDC 20235 RTE LOCAL_REDO_LOG_BUFFER_SIZE=0
2008-10-24 03:06:32 0xDC 20235 RTE _LOCKMANAGER_ENABLED=NO
2008-10-24 03:06:32 0xDC 20235 RTE _LOCK_SUPPLY_BLOCK=100
2008-10-24 03:06:32 0xDC 20235 RTE LOGABOVELIMIT=50L75L90M95M96H97H98H99H
2008-10-24 03:06:32 0xDC 20235 RTE LOGFULL=1
2008-10-24 03:06:32 0xDC 20235 RTE LOGSEGMENTFULL=1
2008-10-24 03:06:32 0xDC 20235 RTE LOG_BACKUP_TO_PIPE=NO
2008-10-24 03:06:32 0xDC 20235 RTE LOG_IO_BLOCK_COUNT=4
2008-10-24 03:06:32 0xDC 20235 RTE LOG_IO_QUEUE=50
2008-10-24 03:06:32 0xDC 20235 RTE LOG_MIRRORED=NO
2008-10-24 03:06:32 0xDC 20235 RTE LOG_QUEUE_COUNT=0
2008-10-24 03:06:32 0xDC 20235 RTE LOG_SEGMENT_SIZE=1365
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_NAME_001=H:\Database\P01-logs\LOG_001
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_NAME_002=H:\Database\P01-logs\LOG_002
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_NAME_003=H:\Database\P01-logs\LOG_003
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_NAME_004=H:\Database\P01-logs\LOG_004
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_NAME_005=H:\Database\P01-logs\LOG_005
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_NAME_006=H:\Database\P01-logs\LOG_006
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_SIZE_001=2049
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_SIZE_002=2049
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_SIZE_003=2049
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_SIZE_004=2049
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_SIZE_005=2049
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_SIZE_006=2049
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_TYPE_001=F
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_TYPE_002=F
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_TYPE_003=F
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_TYPE_004=F
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_TYPE_005=F
2008-10-24 03:06:32 0xDC 20235 RTE LOG_VOLUME_TYPE_006=F
2008-10-24 03:06:32 0xDC 20235 RTE LRU_FOR_SCAN=NO
2008-10-24 03:06:32 0xDC 20235 RTE MAXBACKUPDEVS=2
2008-10-24 03:06:32 0xDC 20235 RTE MAXCPU=3
2008-10-24 03:06:32 0xDC 20235 RTE MAXDATAVOLUMES=16
2008-10-24 03:06:32 0xDC 20235 RTE _MAXEVENTS=100
2008-10-24 03:06:32 0xDC 20235 RTE _MAXEVENTTASKS=2
2008-10-24 03:06:32 0xDC 20235 RTE _MAXGARBAGE_COLL=1
2008-10-24 03:06:32 0xDC 20235 RTE MAXLOCKS=4040
2008-10-24 03:06:32 0xDC 20235 RTE MAXLOGVOLUMES=8
2008-10-24 03:06:32 0xDC 20235 RTE MAXPAGER=64
2008-10-24 03:06:32 0xDC 20235 RTE MAXRGN_REQUEST=3000
2008-10-24 03:06:32 0xDC 20235 RTE MAXSERVERTASKS=38
2008-10-24 03:06:32 0xDC 20235 RTE _MAXTASK_STACK=1024
2008-10-24 03:06:32 0xDC 20235 RTE _MAXTRANS=404
2008-10-24 03:06:32 0xDC 20235 RTE MAXUSERTASKS=50
2008-10-24 03:06:32 0xDC 20235 RTE MAXVOLUMES=25
2008-10-24 03:06:32 0xDC 20235 RTE MAX_HASHTABLE_MEMORY=5120
2008-10-24 03:06:32 0xDC 20235 RTE MAX_LOG_QUEUE_COUNT=0
2008-10-24 03:06:32 0xDC 20235 RTE _MAX_MESSAGE_FILES=0
2008-10-24 03:06:32 0xDC 20235 RTE MAX_MESSAGE_LIST_LENGTH=100
2008-10-24 03:06:32 0xDC 20235 RTE MAX_RETENTION_TIME=480
2008-10-24 03:06:32 0xDC 20235 RTE MAX_SERVERTASK_STACK=500
2008-10-24 03:06:32 0xDC 20235 RTE MAX_SINGLE_HASHTABLE_SIZE=512
2008-10-24 03:06:32 0xDC 20235 RTE MAX_SPECIALTASK_STACK=500
2008-10-24 03:06:32 0xDC 20235 RTE _MBLOCK_DATA_SIZE=32768
2008-10-24 03:06:32 0xDC 20235 RTE _MBLOCK_QUAL_SIZE=32768
2008-10-24 03:06:32 0xDC 20235 RTE _MBLOCK_STACK_SIZE=32768
2008-10-24 03:06:32 0xDC 20235 RTE _MBLOCK_STRAT_SIZE=8192
2008-10-24 03:06:32 0xDC 20235 RTE MCOD=NO
2008-10-24 03:06:32 0xDC 20235 RTE MEMORY_ALLOCATION_LIMIT=0
2008-10-24 03:06:32 0xDC 20235 RTE MINI_DUMP=NORMAL
2008-10-24 03:06:32 0xDC 20235 RTE _MINREPLY_SIZE=4096
2008-10-24 03:06:32 0xDC 20235 RTE MINSERVERTASKS=38
2008-10-24 03:06:32 0xDC 20235 RTE MIN_RETENTION_TIME=60
2008-10-24 03:06:32 0xDC 20235 RTE MONITOR_READ=2147483647
2008-10-24 03:06:32 0xDC 20235 RTE MONITOR_ROWNO=0
2008-10-24 03:06:32 0xDC 20235 RTE MONITOR_SELECTIVITY=0
2008-10-24 03:06:32 0xDC 20235 RTE MONITOR_TIME=2147483647
2008-10-24 03:06:32 0xDC 20235 RTE _MP_DISP_LOOPS=1
2008-10-24 03:06:32 0xDC 20235 RTE _MP_DISP_PRIO=YES
2008-10-24 03:06:32 0xDC 20235 RTE _MP_RGN_BUSY_WAIT=YES
2008-10-24 03:06:32 0xDC 20235 RTE _MP_RGN_DIRTY_READ=YES
2008-10-24 03:06:32 0xDC 20235 RTE MP_RGN_LOOP=-1
2008-10-24 03:06:32 0xDC 20235 RTE _MP_RGN_PRIO=YES
2008-10-24 03:06:32 0xDC 20235 RTE _MP_RGN_QUEUE=YES
2008-10-24 03:06:32 0xDC 20235 RTE OFFICIAL_NODE=
2008-10-24 03:06:32 0xDC 20235 RTE OMS_HEAP_BLOCKSIZE=10000
2008-10-24 03:06:32 0xDC 20235 RTE OMS_HEAP_COUNT=3
2008-10-24 03:06:32 0xDC 20235 RTE OMS_HEAP_LIMIT=0
2008-10-24 03:06:32 0xDC 20235 RTE OMS_HEAP_THRESHOLD=100
2008-10-24 03:06:32 0xDC 20235 RTE _OMS_REGIONS=0
2008-10-24 03:06:32 0xDC 20235 RTE _OMS_RGNS=7
2008-10-24 03:06:32 0xDC 20235 RTE OMS_RUN_IN_UDE_SERVER=NO
2008-10-24 03:06:32 0xDC 20235 RTE OMS_STREAM_TIMEOUT=30
2008-10-24 03:06:32 0xDC 20235 RTE OMS_VERS_THRESHOLD=2097152
2008-10-24 03:06:32 0xDC 20235 RTE ONLINE=1
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_AGGREGATION=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_FETCH_REVERSE=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_FIRST_ROWS=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_JOIN_HASHTABLE=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_JOIN_HASH_MINIMAL_RATIO=1
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_JOIN_ONEPHASE=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_JOIN_OPERATOR_SORT=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_JOIN_OUTER=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_JOIN_PARALLEL_MINSIZE=1000000
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_JOIN_PARALLEL_SERVERS=0
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_MIN_MAX=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_OPERATOR_JOIN_COSTFUNC=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_OPERATOR_JOIN=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_QUAL_ON_INDEX=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_QUERYREWRITE=OPERATOR
2008-10-24 03:06:32 0xDC 20235 RTE OPTIMIZE_STAR_JOIN=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIM_CACHE=NO
2008-10-24 03:06:32 0xDC 20235 RTE OPTIM_INV_ONLY=YES
2008-10-24 03:06:32 0xDC 20235 RTE OPTIM_JOIN_FETCH=0
2008-10-24 03:06:32 0xDC 20235 RTE OPTIM_MAX_MERGE=500
2008-10-24 03:06:32 0xDC 20235 RTE OUTOFSESSIONS=3
2008-10-24 03:06:32 0xDC 20235 RTE _PACKET_SIZE=36864
2008-10-24 03:06:32 0xDC 20235 RTE _PAGE_SIZE=8192
2008-10-24 03:06:32 0xDC 20235 RTE __PARAM_CHANGED___=0
2008-10-24 03:06:32 0xDC 20235 RTE __PARAM_VERIFIED__=2005-06-11 11:30:49
2008-10-24 03:06:32 0xDC 20235 RTE PREALLOCATE_IOWORKER=NO
2008-10-24 03:06:32 0xDC 20235 RTE _PRIO_BASE_COM=10
2008-10-24 03:06:32 0xDC 20235 RTE _PRIO_BASE_IOC=80
2008-10-24 03:06:32 0xDC 20235 RTE _PRIO_BASE_RAV=80
2008-10-24 03:06:32 0xDC 20235 RTE _PRIO_BASE_REX=40
2008-10-24 03:06:32 0xDC 20235 RTE _PRIO_BASE_U2U=100
2008-10-24 03:06:32 0xDC 20235 RTE _PRIO_FACTOR=80
2008-10-24 03:06:32 0xDC 20235 RTE PROTECT_DATACACHE_MEMORY=NO
2008-10-24 03:06:32 0xDC 20235 RTE _READAHEAD_BLOBS=32
2008-10-24 03:06:32 0xDC 20235 RTE READAHEAD_TABLE_THRESHOLD=0
2008-10-24 03:06:32 0xDC 20235 RTE REQUEST_TIMEOUT=5000
2008-10-24 03:06:32 0xDC 20235 RTE RESERVEDSERVERTASKS=21
2008-10-24 03:06:32 0xDC 20235 RTE _RESTART_TIME=600
2008-10-24 03:06:32 0xDC 20235 RTE ROW_LOCKS_PER_TRANSACTION=50
2008-10-24 03:06:32 0xDC 20235 RTE _ROW_RGNS=8
2008-10-24 03:06:32 0xDC 20235 RTE _RTEDUMPFILE=rtedump
2008-10-24 03:06:32 0xDC 20235 RTE RTE_TEST_REGIONS=0
2008-10-24 03:06:32 0xDC 20235 RTE RUNDIRECTORY=D:\Program-Files\sapdb\indep_data\wrk\P01
2008-10-24 03:06:32 0xDC 20235 RTE SEQUENCE_CACHE=1
2008-10-24 03:06:32 0xDC 20235 RTE _SERVERDB_FOR_SAP=NO
2008-10-24 03:06:32 0xDC 20235 RTE SESSION_TIMEOUT=900
2008-10-24 03:06:32 0xDC 20235 RTE SET_VOLUME_LOCK=YES
2008-10-24 03:06:32 0xDC 20235 RTE SHAREDSQL_CLEANUPTHRESHOLD=25
2008-10-24 03:06:32 0xDC 20235 RTE SHAREDSQL_COMMANDCACHESIZE=262144
2008-10-24 03:06:32 0xDC 20235 RTE SHAREDSQL=YES
2008-10-24 03:06:32 0xDC 20235 RTE SHOW_MAX_KB_STACK_USE=NO
2008-10-24 03:06:32 0xDC 20235 RTE SHOW_MAX_STACK_USE=NO
2008-10-24 03:06:32 0xDC 20235 RTE SPINLOCK_BACKOFF_BASE=1
2008-10-24 03:06:32 0xDC 20235 RTE SPINLOCK_BACKOFF_FACTOR=2
2008-10-24 03:06:32 0xDC 20235 RTE SPINLOCK_BACKOFF_MAXIMUM=64
2008-10-24 03:06:32 0xDC 20235 RTE SPINLOCK_LOOP_COUNT=30000
2008-10-24 03:06:32 0xDC 20235 RTE STANDBY=1
2008-10-24 03:06:32 0xDC 20235 RTE SUBTREE_LOCKS=NO
2008-10-24 03:06:32 0xDC 20235 RTE SYMBOL_DEMANGLING=NO
2008-10-24 03:06:32 0xDC 20235 RTE SYMBOL_RESOLUTION=YES
2008-10-24 03:06:32 0xDC 20235 RTE SYSTEMERROR=3
2008-10-24 03:06:32 0xDC 20235 RTE _TAB_RGNS=8
2008-10-24 03:06:32 0xDC 20235 RTE _TASKCLUSTER_01=tw;al;ut;2000*sv,100*bup;10*ev,10*gc;
2008-10-24 03:06:32 0xDC 20235 RTE _TASKCLUSTER_02=ti,100*dw;17*us;
2008-10-24 03:06:32 0xDC 20235 RTE _TASKCLUSTER_03=equalize
2008-10-24 03:06:32 0xDC 20235 RTE TIME_MEASUREMENT=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_AK=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_ALLOCATOR=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_CATALOG=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_CLIENTKERNELCOM=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_COMMON=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_COMMUNICATION=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_CONVERTER=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_DATACACHE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_DATACHAIN=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_DATAINDEX=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_DATAPAM=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_DATATREE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_DBPROC=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_DEFAULT=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_DELETE=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_FBM=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_FILEDIR=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_FRAMECTRL=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_INDEX=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_INSERT=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_IOMAN=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_IPC=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_JOIN=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_KSQL=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_LOCKMANAGER=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_LOCK=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_LOGACTION=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_LOGHISTORY=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_LOGPAGE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_LOGTRANS=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_LOGVOLUME=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_LONG=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_MEMORY=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_MESSAGES=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OBJECTCONTAINER=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OBJECT_ADD=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OBJECT_ALTER=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OBJECT_FREE=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OBJECT_GET=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OBJECT=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_CONTAINERDIR=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_CONTEXT=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_ERROR=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_FLUSHCACHE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_INTERFACE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_KEYRANGE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_KEY=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_LOCK=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_MEMORY=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_NEWOBJ=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_SESSION=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_STREAM=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_VAROBJECT=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OMS_VERSION=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_OPTIMIZE=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_ORDER_STANDARD=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_ORDER=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGER=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_BUP=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_EV=2
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_GC=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_LW=5
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_PG=3
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_SV=5
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_TI=2
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_US=10
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES_UT=5
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PAGES=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_PRIMARY_TREE=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_QUERYREWRITE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_RUNTIME=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_SELECT=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_SHAREDSQL=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_SQLMANAGER=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_SRVTASKS=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_STOP_ERRORCODE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_SYNCHRONISATION=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_SYSVIEW=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_TABLE=0
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_TIME=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_UPDATE=NO
2008-10-24 03:06:32 0xDC 20235 RTE TRACE_VOLUME=0
2008-10-24 03:06:32 0xDC 20235 RTE TRANS_HISTORY_SIZE=0
2008-10-24 03:06:32 0xDC 20235 RTE _TRANS_RGNS=8
2008-10-24 03:06:32 0xDC 20235 RTE TRANS_THRESHOLD_VALUE=60
2008-10-24 03:06:32 0xDC 20235 RTE UKT_CPU_RELATIONSHIP=NONE
2008-10-24 03:06:32 0xDC 20235 RTE _UNICODE=YES
2008-10-24 03:06:32 0xDC 20235 RTE UPDATESTAT_PARALLEL_SERVERS=0
2008-10-24 03:06:32 0xDC 20235 RTE UPDATESTAT_SAMPLE_ALGO=1
2008-10-24 03:06:32 0xDC 20235 RTE UPDSTATWANTED=1
2008-10-24 03:06:32 0xDC 20235 RTE USED_MAX_LOG_QUEUE_COUNT=3
2008-10-24 03:06:32 0xDC 20235 RTE USESELECTFETCH=YES
2008-10-24 03:06:32 0xDC 20235 RTE USEUNICODECOLUMNCOMPRESSION=NO
2008-10-24 03:06:32 0xDC 20235 RTE USEVARIABLEINPUT=NO
2008-10-24 03:06:32 0xDC 20235 RTE _USE_ASYNC_IO=YES
2008-10-24 03:06:32 0xDC 20235 RTE USE_BACKUP_SECURITY_DESCRIPTOR=YES
2008-10-24 03:06:32 0xDC 20235 RTE USE_COROUTINES=YES
2008-10-24 03:06:32 0xDC 20235 RTE USE_FIBERS=YES
2008-10-24 03:06:32 0xDC 20235 RTE _USE_IOPROCS_ONLY=NO
2008-10-24 03:06:32 0xDC 20235 RTE USE_OPEN_DIRECT_FOR_BACKUP=NO
2008-10-24 03:06:32 0xDC 20235 RTE USE_OPEN_DIRECT=NO
2008-10-24 03:06:32 0xDC 20235 RTE USE_SYSTEM_PAGE_CACHE=YES
2008-10-24 03:06:32 0xDC 20235 RTE _UTILITY_PROTFILE=dbm.utl
2008-10-24 03:06:32 0xDC 20235 RTE UTILITY_PROTSIZE=100
2008-10-24 03:06:32 0xDC 20235 RTE VOLUMENO_BIT_COUNT=8
2008-10-24 03:06:32 0xDC 20235 RTE _WORKDATA_SIZE=4096
2008-10-24 03:06:32 0xDC 20235 RTE _WORKSTACK_SIZE=8192
2008-10-24 03:06:32 0xDC 20235 RTE XP_CONVERTER_REGIONS=0
2008-10-24 03:06:32 0xDC 20235 RTE XP_DATA_CACHE_RGNS=0
2008-10-24 03:06:32 0xDC 20235 RTE XP_MAXPAGER=0
2008-10-24 03:06:32 0xDC 20236 RTE Dump of all kernel parameters done
2008-10-24 03:06:32 0xDC 19600 VERSION 'Kernel 7.6.05 Build 009-123-191-997'
2008-10-24 03:06:32 0xDC 19600 VERSION 'W32/INTEL 7.6.05 Build 009-123-191-997'
2008-10-24 03:06:32 0xDC 19769 INFO Starting SERVERDB: 'P01'
2008-10-24 03:06:32 0xDC 19770 INFO SERVERNODE: 'tulip.pha.co.za'
2008-10-24 03:06:32 0xDC 19771 INFO Process ID: 2020
2008-10-24 03:06:32 0xDC 19773 INFO Date: 2008-10-24
2008-10-24 03:06:32 0xDC 19772 INFO Owner: 'SYSTEM'
2008-10-24 03:06:32 0xDC 19774 INFO Product suite: 'Terminal Server'
2008-10-24 03:06:32 0xDC 19806 INFO Machine: 'Intel IA32 level f revision 209'
2008-10-24 03:06:32 0xDC 19783 INFO Processors: 2 ( logical: 4 )
2008-10-24 03:06:32 0xDC 19782 INFO Fiber: 'YES'
2008-10-24 03:06:32 0xDC 19776 INFO Max virtual memory: 2047 MB
2008-10-24 03:06:32 0xDC 19777 INFO Total physical memory: 3839 MB
2008-10-24 03:06:32 0xDC 19778 INFO Available physical memory: 3524 MB
2008-10-24 03:06:32 0xDC 20220 RTE Memory allocation not limited
2008-10-24 03:06:32 0xDC 20221 RTE System page cache usage enabled
2008-10-24 03:06:32 0xDC 19692 TCLUSTER tw;al;ut;2000*sv,100*bup;10*ev,10*gc;ti,100*dw;17*us;equalize
2008-10-24 03:06:32 0xDC 19693 TCLUSTER number of 'BUP': 0
2008-10-24 03:06:32 0xDC 19693 TCLUSTER number of ' DW': 64
2008-10-24 03:06:32 0xDC 19693 TCLUSTER number of ' US': 50
2008-10-24 03:06:32 0xDC 19693 TCLUSTER number of ' SV': 38
2008-10-24 03:06:32 0xDC 19693 TCLUSTER number of ' EV': 2
2008-10-24 03:06:32 0xDC 19693 TCLUSTER number of ' GC': 1
2008-10-24 03:06:32 0xDC 19692 TCLUSTER Total Number of UKT 9
2008-10-24 03:06:32 0xDC 19692 TCLUSTER Number of UKT with User Tasks 3
2008-10-24 03:06:32 0xDC 19860 MEMORY I/O buffer cache: 196608 Pages allocated
2008-10-24 03:06:32 0xDC 19811 EVENTING Suppressing output to 'knldiag.evt' 0 pages
2008-10-24 03:06:32 0xDC 19812 EVENTING Eventbuffer 100 events 2 tasks
2008-10-24 03:06:32 0x838 19821 TASKING Thread 2104 starting
2008-10-24 03:06:32 0xDC 19831 TRACE_IO Configured _MAX_MESSAGE_FILES:0
2008-10-24 03:06:32 0xDC 19832 TRACE_IO Disabled: No TraceMessagefiles wanted
2008-10-24 03:06:32 0x83C 19688 THREAD CLOCK thread started
2008-10-24 03:06:32 0x840 19688 THREAD TIMER thread started
2008-10-24 03:06:32 0x854 19688 THREAD ASYNC0 thread started
2008-10-24 03:06:32 0x85C 19688 THREAD REQUESTOR thread started
2008-10-24 03:06:32 0x864 19821 TASKING Thread 2148 starting
2008-10-24 03:06:32 0x860 19821 TASKING Thread 2144 starting
2008-10-24 03:06:32 0x858 20214 RTE CONSOLE thread started
2008-10-24 03:06:32 0x868 19821 TASKING Thread 2152 starting
2008-10-24 03:06:33 0x890 19821 TASKING Thread 2192 starting
2008-10-24 03:06:33 0x8A8 19821 TASKING Thread 2216 starting
2008-10-24 03:06:33 0x894 19821 TASKING Thread 2196 starting
2008-10-24 03:06:33 0x89C 19821 TASKING Thread 2204 starting
2008-10-24 03:06:33 0x8B4 19821 TASKING Thread 2228 starting
2008-10-24 03:06:33 0x898 19821 TASKING Thread 2200 starting
2008-10-24 03:06:33 0x8B0 19821 TASKING Thread 2224 starting
2008-10-24 03:06:33 0x8AC 19821 TASKING Thread 2220 starting
2008-10-24 03:06:33 0x8C8 19627 TASKING UKT started, TID:0x8C8
2008-10-24 03:06:33 0x8B8 19627 TASKING UKT started, TID:0x8B8
2008-10-24 03:06:33 0x8BC 19627 TASKING UKT started, TID:0x8BC
2008-10-24 03:06:33 0x8CC 19627 TASKING UKT started, TID:0x8CC
2008-10-24 03:06:33 0x8D0 19627 TASKING UKT started, TID:0x8D0
2008-10-24 03:06:33 0x8C0 19627 TASKING UKT started, TID:0x8C0
2008-10-24 03:06:33 0x8D4 19627 TASKING UKT started, TID:0x8D4
2008-10-24 03:06:33 0x8C4 19627 TASKING UKT started, TID:0x8C4
2008-10-24 03:06:33 0x958 19627 TASKING UKT started, TID:0x958
2008-10-24 03:06:33 0x958 19615 VOLUMEIO Attaching volume 'knltrace'
2008-10-24 03:06:33 0x994 19613 DBSTATE I/O thread for 'knltrace' started
2008-10-24 03:06:33 0x958 20040 Admin Kernel state: 'ADMIN' reached
Regards
Bradley
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.