cancel
Showing results for 
Search instead for 
Did you mean: 

MaxDB 7.6.05.09 Kernel aborts - EXCEPTION:'Access violation' (0xc0000005)

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

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

Answers (15)

Answers (15)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello

I will CHECK DATA in admin mode on the weekend.

Is it possible to CHECK DATA with the dbmcli?

Regards

Bradley

lbreddemann
Active Contributor
0 Kudos

> 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

Former Member
0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

Hi Bradley,

I already informed the developer of this code-part, but it seems that currently she's out of office.

Anyhow - just to give it a shot into the blue... please run a CHECK DATA in admin mode. Maybe this problem is due to a corruption...

regards,

Lars

Former Member
0 Kudos

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

Former Member
0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

Hi Bradley,

sorry, but even by looking at the code part where the crash happens, I don't see why it happens.

Maybe the developer of this code has an idea on that.

regards,

Lars

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello

One thing that has changed since the last kernel abort is that SP2 was loaded on 2008-11-06.

Regards

Bradley

Former Member
0 Kudos

Bradley,

is there anything concerning Terminal Services that Lars should know?

SCNR

Marc-Philip

Former Member
0 Kudos

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

Former Member
0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

> 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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

Hmmm... does the table Transaction_Log consist of LOB-Columns?

How did you set the parameters of the database?

> __PARAM_VERIFIED__=2005-06-11 11:30:49

Please perform a param_checkall and restart the database.

Does the error reoccur?

regads,

Lars