Upgrade SAPDB 7.3.0.0.28 to 7.4.3.0.32 - SQL Error

[Former Member]

Hi all,

I'm uprading SAPdb from 7.3.0.0.28 to 7.4.3.0.32 using SDBINST for MiniWAS 6.20

The problem is now I can't bring my DB to warm state, but the cold state is ok. I always get the error message:

ERR

-24988,ERR_SQL: sql error

-8888,connection broken

The db_enum is:

BSP D:\SAPDB\BSP\DB 7.4.3.0 fast offline

and the inst_enum is:

7.4.3.32 d:\sapdb\bsp\db

What do I have to do? Did I missed some steps?

TIA

[roland_mallmann · Accepted solution]

Hi,

please take a look into the knldiag and/or knldiag.err file in your Rundirectiry (<drive>:\sapdb\data\wrk\BSP) to find out mroe about the reason your DB won't come up.

Please also copy the error-output from either of those files into this thread.

Regards,

Roland

[Former Member · Accepted solution]

Dear Roland,

Thank you for your quick reply, here is the knldiag.err

2005-10-21 15:13:04 --- Starting GMT 2005-10-21 15:13:04 7.4.3 Build 032-123-068-842

2005-10-21 15:13:38 0xD30 ERR 0 Kernel Page check failed; algorithm: 12, calculated: 11423, header: 2, trailer: 2

2005-10-21 15:13:39 0xD30 ERR 12 IOMan Bad page on Data volume 1 blockno 0

2005-10-21 15:13:41 0xD30 ERR 0 Kernel Page check failed; algorithm: 12, calculated: 11423, header: 2, trailer: 2

2005-10-21 15:13:41 0xD30 ERR 12 IOMan Bad page on Data volume 1 blockno 0

2005-10-21 15:13:44 0xD30 ERR 0 Kernel Page check failed; algorithm: 12, calculated: 11423, header: 2, trailer: 2

2005-10-21 15:13:44 0xD30 ERR 12 IOMan Bad page on Data volume 1 blockno 0

2005-10-21 15:13:46 0xD30 ERR 25 IOMan Can not read info page from Data volume 1

2005-10-21 15:13:46 0xD30 ERR 18196 DBCRASH vabort:Emergency Shutdown, IOMan_Volume.cpp: 275

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE SymbolSearchPath: D:\sapdb\data\wrk\BSP;D:\SAPDB\BSP\DB\pgm;D:\SAPDB\BSP\DB\symbols;D:\SAPDB\BSP\DB\sap;C:\WINDOWS

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE ;D:\SAPDB\BSP\DB\sap\

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE -

---

> Register Dump <----

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE Eax=0x03fde0b8 Ebx=0x007c0ba0 Ecx=0x000000b7 Edx=0x0085599c Esi=0x00000000 Edi=0x00000004

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE Eip=0x7c81eb33 Esp=0x03fde0b4 Ebp=0x03fde108

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE Cs=0x001b Ss=0x0023 Ds=0x0023 Es=0x0023 Fs=0x003b Gs=0x0000 Efl=0x0246

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE -

---

> Module List <----

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE |.text Start |.text End | Module File Name

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x00400000 | 0x0092d000 | D:\SAPDB\BSP\DB\pgm\kernel.exe

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x040e0000 | 0x04195000 | D:\SAPDB\BSP\DB\pgm\dbghelp.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x5d090000 | 0x5d127000 | C:\WINDOWS\system32\comctl32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x71aa0000 | 0x71aa8000 | C:\WINDOWS\system32\WS2HELP.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x71ab0000 | 0x71ac7000 | C:\WINDOWS\system32\WS2_32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x76000000 | 0x7600d000 | D:\sapdb\programs\pgm\sqltcp1.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x76c90000 | 0x76cb8000 | C:\WINDOWS\system32\imagehlp.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x76f20000 | 0x76f47000 | C:\WINDOWS\system32\DNSAPI.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x76fc0000 | 0x76fc6000 | C:\WINDOWS\system32\rasadhlp.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x773d0000 | 0x774d2000 | C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE : : : x-ww_a84f1ff9\comctl32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x774e0000 | 0x7761c000 | C:\WINDOWS\system32\ole32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x77c00000 | 0x77c08000 | C:\WINDOWS\system32\VERSION.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x77c10000 | 0x77c68000 | C:\WINDOWS\system32\msvcrt.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x77d40000 | 0x77dd0000 | C:\WINDOWS\system32\USER32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x77dd0000 | 0x77e6b000 | C:\WINDOWS\system32\ADVAPI32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x77e70000 | 0x77f01000 | C:\WINDOWS\system32\RPCRT4.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x77f10000 | 0x77f56000 | C:\WINDOWS\system32\GDI32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x77f60000 | 0x77fd6000 | C:\WINDOWS\system32\SHLWAPI.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x77fe0000 | 0x77ff1000 | C:\WINDOWS\system32\Secur32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x7c800000 | 0x7c8f4000 | C:\WINDOWS\system32\kernel32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x7c900000 | 0x7c9b0000 | C:\WINDOWS\system32\ntdll.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE | 0x7c9c0000 | 0x7d1d4000 | C:\WINDOWS\system32\SHELL32.dll

2005-10-21 15:13:46 0xD30 ERR 19999 BTRACE -

---

> Stack Back Trace <----

2005-10-21 15:13:47 0xD30 ERR 19999 BTRACE kernel32!RaiseException + 82 bytes

2005-10-21 15:13:47 0xD30 ERR 19999 BTRACE SFrame: IP:7c81eb33 RA:006d2253 FP:03fde108 SP:03fde0b4

2005-10-21 15:13:47 0xD30 ERR 19999 BTRACE Params: 01:e000aaaa 02:00000000 03:00000000 04:00000000

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!_vabort + 83 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:006d2253 RA:0076ddca FP:03fde124 SP:03fde12c

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:00000001 02:00000113 03:7ff0ad42 04:7fda0b70

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vos50k.c ( Line: 189 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!RTE_Crash + 74 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:0076ddca RA:0070d6f6 FP:03fde13c SP:03fde144

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fde208 02:7fda0b08 03:7fda0bdc 04:7fda0b70

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: rte_crash.cpp ( Line: 126 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!IOMan_Volume::Open + 182 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:0070d6f6 RA:0070ee4f FP:03fde21c SP:03fde224

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:00000004 02:00000001 03:00000004 04:7fda0a94

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: ioman_volume.cpp ( Line: 277 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!IOMan_DataControl::OpenAll + 63 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:0070ee4f RA:007098a3 FP:03fde3b8 SP:03fde3c0

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:00000004 02:03fdf6ec 03:03fdf6ec 04:03fde3dc

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: ioman_datacontrol.cpp ( Line: 259 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!IOMan_Manager::OpenAllDataDevSpaces + 19 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:007098a3 RA:007073c7 FP:03fde3cc SP:03fde3d4

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:00000004 02:03fdf70e 03:03fde3f0 04:00648752

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: ioman_manager.cpp ( Line: 308 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!bd999AttachAllDevices + 23 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:007073c7 RA:00648752 FP:03fde3dc SP:03fde3e4

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fdf6ec 02:03fde4a8 03:03fdf6ec 04:03fde404

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: ioman_wrapper.cpp ( Line: 175 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!b01restart_filesystem + 50 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00648752 RA:00629785 FP:03fde3f0 SP:03fde3f8

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fdf6ec 02:00000001 03:03fdf6ec 04:03fde4b8

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vbd01.c ( Line: 3950 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!kb81filesystem_restart + 21 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00629785 RA:00629a5b FP:03fde404 SP:03fde40c

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fdf6ec 02:7fec1e28 03:00000000 04:00000004

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vkb81.c ( Line: 798 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!k81local_restart + 123 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00629a5b RA:005f479e FP:03fde4b8 SP:03fde4c0

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fdf6ec 02:7f8e8924 03:7f8e892c 04:ffffffff

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vkb81.c ( Line: 605 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!k05cold_functions + 398 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:005f479e RA:0045dc2b FP:03fde4f0 SP:03fde4f8

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fdea90 02:03fde6b8 03:03fde51c 04:004f7749

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vkb05.c ( Line: 1776 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!a06_c_send_mess_buf + 91 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:0045dc2b RA:004f7749 FP:03fde500 SP:03fde508

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fde85c 02:03fde526 03:03ed01c8 04:03fde85c

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak06.c ( Line: 5639 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!ak36restart + 281 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:004f7749 RA:004f7c89 FP:03fde51c SP:03fde524

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fde85c 02:03fde53c 03:03fde6b8 04:03ed01c8

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak36.c ( Line: 7077 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!a36_call_semantic + 441 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:004f7c89 RA:00561612 FP:03fde6e8 SP:03fde6f0

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fde85c 02:03fde700 03:00000000 04:03fde85c

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak36.c ( Line: 7711 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!a30_init_utility + 738 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00561612 RA:005832cb FP:03fde720 SP:03fde728

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:01fde85c 02:03fde79b 03:03fdfbd4 04:03fde85c

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak30.c ( Line: 5006 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!ak94utility + 555 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:005832cb RA:005839b1 FP:03fde79c SP:03fde7a4

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:00fde85c 02:03fde85c 03:03fde7c0 04:00583a90

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak94.c ( Line: 5264 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!ak94mess_type_analysis + 81 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:005839b1 RA:00583a90 FP:03fde7ac SP:03fde7b4

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fde85c 02:00000000 03:03ed01a8 04:03fde828

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak94.c ( Line: 5082 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!ak94one_command + 176 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00583a90 RA:00583c8b FP:03fde7c0 SP:03fde7c8

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fde85c 02:00000000 03:03fde85c 04:00039000

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak94.c ( Line: 5394 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!a94_service_commands + 475 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00583c8b RA:00437431 FP:03fde828 SP:03fde830

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:00fde85c 02:03fde846 03:03fdff14 04:03fdff14

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak94.c ( Line: 5589 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!ak91run_non_sql_process + 65 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00437431 RA:004375c5 FP:03fde848 SP:03fde850

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fde85c 02:00039000 03:03fdff14 04:03ed01a8

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak91.c ( Line: 5260 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!ak91run_user_process + 197 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:004375c5 RA:00437629 FP:03fdfe8c SP:03fdfe94

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fdff14 02:00000001 03:7ff0a5c8 04:03fdfefc

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak91.c ( Line: 5333 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!a91mainprogam_with_allocator + 57 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00437629 RA:006aada3 FP:03fdfea0 SP:03fdfea8

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:01fdff14 02:7c910340 03:7fec1e28 04:00000000

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak91.c ( Line: 5364 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!gg941CreateAllocatorAndCallMainprog + 211 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:006aada3 RA:00437658 FP:03fdfefc SP:03fdff04

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:03fdff01 02:03fdff5c 03:0000000c 04:03fdff14

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vgg941.cpp ( Line: 138 )

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE kernel!a91mainprogram + 40 bytes

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE SFrame: IP:00437658 RA:006fce0f FP:03fdff78 SP:03fdff80

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Params: 01:7c910340 02:7c910331 03:7feddff8 04:00000000

2005-10-21 15:13:50 0xD30 ERR 19999 BTRACE Source: vak91.c ( Line: 5351 )

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE kernel!sql88k_kernel_fiber + 191 bytes

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE SFrame: IP:006fce0f RA:7c80b50b FP:03fdffb4 SP:03fdffbc

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE Params: 01:7feddff8 02:7c910340 03:7c910331 04:7feddff8

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE Source: vos88k.c ( Line: 435 )

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE kernel32!GetModuleFileNameA + 436 bytes

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE SFrame: IP:7c80b50b RA:7c825bc4 FP:03fdffec SP:03fdffbc

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE Params: 01:006fcd50 02:7feddff8 03:00000000 04:00000000

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE kernel32!ConvertThreadToFiber + 147 bytes

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE SFrame: IP:7c825bc4 RA:00000000 FP:03fdff5c SP:03fdffbc

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE Params: 01:7ff0a5c8 02:00000000 03:00000000 04:00000000

2005-10-21 15:13:51 0xD30 ERR 19999 BTRACE No crash dump file 'knlcrash.dmp' written

Regards,

Dian

[roland_mallmann · Accepted solution]

Hi Dian,

this doesn't look too good. These errors normally are a result of a hardware failuer of some kind, often disk related. I suggest you have your hardware checked.

To solve the issue, you would need to perform a recovery.

Did this error occur during the very first restart in version 7.4.3 Build 32?

Have you made any DB backups recently (in version 7.4.3 Build 32)?

Regards,

Roland

[Former Member · Accepted solution]

Hi Roland,

Guess I made a big mistake

Yes, this error occurs from the very first restart in 7.4.3 Build 32 & my last DB backup was in 7.3.0 Build 28 (right before upgrade).

Once I have recover the DB to 7.3.0 Build 28, can I upgrade to MaxDB 7.6.0 Build 12?

Regards,

Dian

[roland_mallmann · Accepted solution]

Hi Dain,

yes, I suggest you go abck to 7.3.00 Build 28. You should be able to migrate directly to 7.6.00 Build 12. This direct migration is only possible to target releases >= 7.6.00 Build 12.

Regards,

Roland

[Former Member · Accepted solution]

Dear Roland,

It still fails to bring DB to warm, even I've already restore the 7.3.0.0.28 DB.

Finally, I've decide to scratch all the system & will try to re-install everything. I'll bring you the update when things are already finished.

Thank you for you support.

Regards,

Dian