Hello Alejandro,
the log backup has detected that your log volume is corrupt.
You have to detect and correct the hardware problems.
Then you have the following possibilities.
1)
- Re-initialize the log volume.
- All Log which was not backuped before is lost.
- todo:
- db_Admin
- util_execute diagnose devspace enable '<your first log volume path as
defined in the paramater file>'
- Backup your data - for security.
- util_execute clear log
- Start Log recovery with log backups - if you have.
A restart without log recovery will recover the database state
to the last savepoint (normally a savepoint occurs every 10min).
2)
Determine the date/timstamp of the last good logpage and restart up to this
point in time.
Normally this is done by the development support.
If this is the way you want to go, reply to me for more details on how to do
this.
After both variants you have to start your log backup history again with a
complete data backup.
Kind regards
Uwe
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 9. Februar 2006 20:51
To: [email protected]
Subject: Sapdb 7.4.03 stop - emergency shutdown and do not restart
Importance: High
Hi..I am in trouble!... I do not know what happened but after making a
log backup sapdb 7.4.03 stop and do not restart.
I copy knldiag log so Any could help me to understand it and recommend
me a solution.
I will appreciate any help quickless as possible.
Thanks
Alejandro
06-02-09 15:52:05 0x3F8 ERR 0 Kernel Page check failed;
algorithm: 1, calculated: 3109, header: 13801, trailer: 3109
2006-02-09 15:52:05 0x3F8 ERR 12 IOMan Bad page on Log volume
1 blockno 333682
2006-02-09 15:52:07 0x3F8 ERR 0 Kernel Page check failed;
algorithm: 1, calculated: 3109, header: 13801, trailer: 3109
2006-02-09 15:52:07 0x3F8 ERR 12 IOMan Bad page on Log volume
1 blockno 333682
2006-02-09 15:52:09 0x3F8 ERR 0 Kernel Page check failed;
algorithm: 1, calculated: 3109, header: 13801, trailer: 3109
2006-02-09 15:52:09 0x3F8 ERR 12 IOMan Bad page on Log volume
1 blockno 333682
2006-02-09 15:52:11 0x3F8 ERR 34 IOMan Log volume 1 is set to
bad
2006-02-09 15:52:11 0x3F8 ERR 16 IOMan EMERGENCY SHUTDOWN
2006-02-09 15:52:11 0x3F8 ERR 18196 DBCRASH vabort:Emergency
Shutdown, IOMan_LogVolume.cpp: 165
2006-02-09 15:52:11 0x3F8 ERR 19999 BTRACE SymbolSearchPath:
E:\sapdb\data\wrk\DEV;E:\SAPDB\DEV\DB\pgm;E:\SAPDB\DEV\DB\symbols;E:\SAP
DB\DEV\DB\sap;C:\WINNT;E
2006-02-09 15:52:11 0x3F8 ERR 19999 BTRACE
:\SAPDB\DEV\DB\sap\
2006-02-09 15:52:11 0x3F8 ERR 19999 BTRACE ----> Register Dump
<----
2006-02-09 15:52:11 0x3F8 ERR 19999 BTRACE Eax=0x0305f030
Ebx=0x0305f570 Ecx=0x000003e5 Edx=0x007edffc Esi=0x00000000
Edi=0x00000000
2006-02-09 15:52:11 0x3F8 ERR 19999 BTRACE Eip=0x7c59bbf3
Esp=0x0305f028 Ebp=0x0305f080
2006-02-09 15:52:11 0x3F8 ERR 19999 BTRACE Cs=0x001b Ss=0x0023
Ds=0x0023 Es=0x0023 Fs=0x0038 Gs=0x0000 Efl=0x0246
2006-02-09 15:52:11 0x3F8 ERR 19999 BTRACE ----> Module List
<----
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE |.text Start |.text
End | Module File Name
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x00400000 |
0x008c5000 | E:\SAPDB\DEV\DB\pgm\kernel.exe
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x06370000 |
0x063c4000 | C:\WINNT\system32\MSVCR70.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x07b30000 |
0x07be5000 | E:\SAPDB\DEV\DB\pgm\dbghelp.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x10000000 |
0x10055000 | E:\SAPDB\DEV\DB\pgm\liboms.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x75020000 |
0x75028000 | C:\WINNT\system32\WS2HELP.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x75030000 |
0x75044000 | C:\WINNT\system32\WS2_32.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x75050000 |
0x75058000 | C:\WINNT\system32\WSOCK32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x75150000 |
0x7515f000 | C:\WINNT\system32\SAMLIB.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x75170000 |
0x751bf000 | C:\WINNT\system32\NETAPI32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x751c0000 |
0x751c6000 | C:\WINNT\system32\NETRAP.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x759b0000 |
0x759b6000 | C:\WINNT\system32\LZ32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x76000000 |
0x7600d000 | E:\sapdb\programs\pgm\sqltcp.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77320000 |
0x77337000 | C:\WINNT\system32\MPRAPI.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77340000 |
0x77353000 | C:\WINNT\system32\iphlpapi.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77360000 |
0x77379000 | C:\WINNT\system32\DHCPCSVC.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77380000 |
0x773a3000 | C:\WINNT\system32\ADSLDPC.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x773b0000 |
0x773df000 | C:\WINNT\system32\ACTIVEDS.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x774c0000 |
0x774d1000 | C:\WINNT\system32\RASMAN.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x774e0000 |
0x77513000 | C:\WINNT\system32\RASAPI32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77520000 |
0x77525000 | C:\WINNT\system32\ICMP.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77530000 |
0x77552000 | C:\WINNT\system32\TAPI32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x777f0000 |
0x777f5000 | C:\WINNT\system32\rasadhlp.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77820000 |
0x77827000 | C:\WINNT\system32\VERSION.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77830000 |
0x7783e000 | C:\WINNT\system32\RTUTILS.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77880000 |
0x7790e000 | C:\WINNT\system32\SETUPAPI.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77920000 |
0x77943000 | C:\WINNT\system32\imagehlp.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77950000 |
0x7797a000 | C:\WINNT\system32\WLDAP32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77980000 |
0x779a4000 | C:\WINNT\system32\DNSAPI.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x779b0000 |
0x77a4b000 | C:\WINNT\system32\OLEAUT32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77a50000 |
0x77b3f000 | C:\WINNT\system32\ole32.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77b50000 |
0x77bd9000 | C:\WINNT\system32\COMCTL32.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77c70000 |
0x77cb9000 | C:\WINNT\system32\SHLWAPI.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77d30000 |
0x77da1000 | C:\WINNT\system32\RPCRT4.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77e10000 |
0x77e75000 | C:\WINNT\system32\USER32.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77f40000 |
0x77f7b000 | C:\WINNT\system32\GDI32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x77f80000 |
0x77ffb000 | C:\WINNT\system32\ntdll.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x78000000 |
0x78045000 | C:\WINNT\system32\MSVCRT.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x782f0000 |
0x78535000 | C:\WINNT\system32\SHELL32.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x7c0f0000 |
0x7c151000 | C:\WINNT\system32\USERENV.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x7c2d0000 |
0x7c332000 | C:\WINNT\system32\ADVAPI32.dll
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x7c340000 |
0x7c34f000 | C:\WINNT\system32\SECUR32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE | 0x7c570000 |
0x7c623000 | C:\WINNT\system32\KERNEL32.DLL
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE ----> Stack Back Trace
<----
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE
KERNEL32!RaiseException + 86 bytes
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE SFrame:
IP:7c59bbf3 RA:006ca433 FP:0305f080 SP:0305f028
2006-02-09 15:52:12 0x3F8 ERR 19999 BTRACE Params:
01:e000aaaa 02:00000000 03:00000000 04:00000000
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE kernel!_vabort + 83
bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:006ca433 RA:00767e2a FP:0305f09c SP:0305f0a4
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:00000001 02:000000a5 03:7ff74b3a 04:007b9d90
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source:
vos50k.c ( Line: 189 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE kernel!RTE_Crash +
74 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:00767e2a RA:0070e670 FP:0305f0b4 SP:0305f0bc
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:0305f40c 02:00000000 03:00000068 04:00000008
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source:
rte_crash.cpp ( Line: 126 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!IOMan_LogVolume::ReadPages + 832 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:0070e670 RA:00705bc0 FP:0305f430 SP:0305f438
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:00000068 02:7892d738 03:00000000 04:00000000
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source:
ioman_logvolume.cpp ( Line: 166 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!IOMan_Manager::ReadLogPages + 144 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:00705bc0 RA:0072d853 FP:0305f57c SP:0305f584
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:00000068 02:7892d738 03:0305f5ac 04:008b6340
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source:
ioman_manager.cpp ( Line: 619 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!Log_SaveIterator::GetNextLogPages + 1123 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:0072d853 RA:0062211a FP:0305f5c8 SP:0305f5d0
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:00000068 02:7fca0000 03:0305f5e4 04:0305f608
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source:
log_saveiterator.cpp ( Line: 197 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!kb391_ReadNextLogpages + 26 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:0062211a RA:0061842a FP:0305f5dc SP:0305f5e4
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:00000008 02:7892d708 03:7fc90000 04:7fdc67e2
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source:
vkb391.cpp ( Line: 134 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!kb39drt_devsp_read_task + 266 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:0061842a RA:0061a91d FP:0305f608 SP:0305f610
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:0005ff14 02:008b6340 03:00000001 04:0305f690
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source: vkb39.c
( Line: 3975 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!k39run_backup_task + 189 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:0061a91d RA:005dcc58 FP:0305f624 SP:0305f62c
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:008b6340 02:00000000 03:00000009 04:0305ff14
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source: vkb39.c
( Line: 3027 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE kernel!kb92_server +
696 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:005dcc58 RA:005dcf8f FP:0305f6a4 SP:0305f6ac
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:0005f6b8 02:0305ff14 03:00000009 04:00000000
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source: vkb92.c
( Line: 1820 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!k92server_process + 367 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:005dcf8f RA:004371a3 FP:0305f72c SP:0305f734
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:0105ff14 02:0305ff14 03:0305ff14 04:0088f790
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source: vkb92.c
( Line: 1656 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!ak91run_non_user_process + 387 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:004371a3 RA:0043745c FP:0305f790 SP:0305f798
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:0305ff14 02:00000009 03:00000002 04:0305fefc
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source: vak91.c
( Line: 5220 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!a91mainprogam_with_allocator + 44 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:0043745c RA:006a7362 FP:0305f7a4 SP:0305f7ac
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:0905ff14 02:00000000 03:7fed7cf8 04:00000000
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source: vak91.c
( Line: 5360 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!gg941CreateAllocatorAndCallMainprog + 210 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:006a7362 RA:00437498 FP:0305fefc SP:0305ff04
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:0305ff09 02:0305ff5c 03:0000000c 04:0305ff14
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source:
vgg941.cpp ( Line: 133 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!a91mainprogram + 40 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:00437498 RA:006f91ef FP:0305ff78 SP:0305ff80
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:00000000 02:00000000 03:7ff4e580 04:00000000
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source: vak91.c
( Line: 5343 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
kernel!sql88k_kernel_fiber + 191 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:006f91ef RA:7c57b388 FP:0305ffb4 SP:0305ffbc
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:7ff4e580 02:00000000 03:00000000 04:7ff4e580
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Source:
vos88k.c ( Line: 435 )
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE KERNEL32!lstrcmpiW +
183 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:7c57b388 RA:7c57b918 FP:0305ffec SP:0305ffbc
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:006f9130 02:7ff4e580 03:00000000 04:00000000
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE
KERNEL32!SwitchToFiber + 412 bytes
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE SFrame:
IP:7c57b918 RA:00000000 FP:00000000 SP:0305ffbc
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE Params:
01:00000000 02:00000000 03:00000000 04:00000000
2006-02-09 15:52:14 0x3F8 ERR 19999 BTRACE No crash dump file
'knlcrash.dmp' written
2006-02-09 16:06:08 --- Starting GMT
2006-02-09 16:06:08 7.4.3 Build 030-123-057-298
2006-02-09 16:06:13 0x2B0 ERR 61 Log RESTART ERROR '9050'
=> SHUTDOWN IS FORCED
2006-02-09 16:10:57 --- Starting GMT
2006-02-09 16:10:57 7.4.3 Build 030-123-057-298
2006-02-09 16:11:01 0x11E4 ERR 61 Log RESTART ERROR '9050'
=> SHUTDOWN IS FORCED
2006-02-09 16:30:28 --- Starting GMT
2006-02-09 16:30:28 7.4.3 Build 030-123-057-298
2006-02-09 16:30:33 0x4B4 ERR 61 Log RESTART ERROR '9050'
=> SHUTDOWN IS FORCED
2006-02-09 16:34:30 --- Starting GMT
2006-02-09 16:34:30 7.4.3 Build 030-123-057-298
2006-02-09 16:34:33 0xC9C ERR 61 Log RESTART ERROR '9050'
=> SHUTDOWN IS FORCED
2006-02-09 16:36:15 --- Starting GMT
2006-02-09 16:36:15 7.4.3 Build 030-123-057-298
2006-02-09 16:37:09 0xC98 ERR 51080 SYSERROR -9209 Message not
available
2006-02-09 16:38:30 0xC98 ERR 61 Log RESTART ERROR '9050'
=> SHUTDOWN IS FORCED
Error trying to put it online
-24895
shutdown of database occured [db_warm -f]; -71,connection broken
Alejandro D. Elviretti
Tecnología de la Información - Lab. LKM s.a.
e-mail: [EMAIL PROTECTED]
Tel.: 54-11-4896-6100 int. 6143
Fax.: 54-11-4896-6104
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
