Hi Gerald,

the crash during the extraction of the database is probably due to a bug which bites 
if there is a table with multiple key columns and at least one long column to be 
extracted. It should be fixed with release 7.4.03.32.
(see also http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1124516).

Best wishes,

Martin.
SAP Labs, Berlin.

> -----Original Message-----
> From: Gerald Nowitzky [mailto:[EMAIL PROTECTED]
> Sent: Montag, 26. April 2004 11:02
> To: [EMAIL PROTECTED]
> Subject: system error -9400
> 
> 
> Hi!
> I ran into some strange trouble while trying to migrate a 
> database from 7.4.30 to 7.5.01:
> 
> I created a DBExtract.txt with this content:
> 
> DBEXTRACT CATALOG OUTSTREAM 'catalog.out' DATA OUTSTREAM 'data.out'
> 
> And then executed:
> 
> LOADERCLI -d NSWVORN -u dba,dba -b DBExtract.txt -E 20
> 
> It succeded to export the Table Structure and crashed midway 
> during data extract. kndiag looks like this:
> 
> 2004-04-22 03:05:09                               --- 
> Starting GMT 2004-04-22 03:05:09           7.4.3    Build 
> 030-123-056-274
> 2004-04-22 03:06:06      0x11C ERR 18358          File: 
> 'vgg04.p', Line: 8110, no match in case statement without otherwise!
> 
> 2004-04-22 03:06:06      0x11C ERR 18006 EXCEPT   
> EXCEPTION:0xc0000005 Addr:0x778fc7 ( 0x1:0:0:0 )
> 2004-04-22 03:06:06      0x11C ERR 19999 BTRACE   
> SymbolSearchPath:  
> h:\NSWVORN;C:\PROGRAMME\SAPDB\DEPEND\pgm;C:\PROGRAMME\SAPDB\DE
> PEND\symbols;C:\PROGRAMME\SAPDB\DE
> 2004-04-22 03:06:06      0x11C ERR 19999 BTRACE               
>        PEND\sap;C:\WINDOWS;C:\PROGRAMME\SAPDB\DEPEND\sap\
> 2004-04-22 03:06:06      0x11C ERR 19999 BTRACE   ----> 
> Register Dump <----
> 2004-04-22 03:06:06      0x11C ERR 19999 BTRACE     
> Eax=0x00000000 Ebx=0x06b5bb84 Ecx=0x00000000 Edx=0x007edffc 
> Esi=0x00000079 Edi=0x62070050
> 2004-04-22 03:06:06      0x11C ERR 19999 BTRACE     
> Eip=0x00778fc7 Esp=0x06b5b1d0 Ebp=0x06b5b1fc
> 2004-04-22 03:06:06      0x11C ERR 19999 BTRACE     Cs=0x001b 
>  Ss=0x0023  Ds=0x0023  Es=0x0023  Fs=0x0038  Gs=0x0000  Efl=0x10212
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   ----> 
> Module List <----
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   |.text 
> Start |.text End   | Module File Name
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x00400000 | 0x008c5000 | C:\PROGRAMME\SAPDB\DEPEND\pgm\kernel.exe
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x06770000 | 0x06825000 | C:\PROGRAMME\SAPDB\DEPEND\pgm\dbghelp.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x10000000 | 0x10055000 | C:\PROGRAMME\SAPDB\DEPEND\pgm\liboms.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x70a70000 | 0x70ad5000 | C:\WINDOWS\system32\SHLWAPI.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x71a00000 | 0x71a08000 | C:\WINDOWS\System32\WS2HELP.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x71a10000 | 0x71a25000 | C:\WINDOWS\System32\WS2_32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x76000000 | 0x7600d000 | c:\programme\sapdb\indep_prog\pgm\sqltcp.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x76c50000 | 0x76c72000 | C:\WINDOWS\system32\imagehlp.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x76ee0000 | 0x76f05000 | C:\WINDOWS\System32\DNSAPI.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x76f50000 | 0x76f60000 | C:\WINDOWS\System32\Secur32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x76f80000 | 0x76f85000 | C:\WINDOWS\System32\rasadhlp.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x77310000 | 0x7739b000 | C:\WINDOWS\system32\comctl32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x773a0000 | 0x77b9c000 | C:\WINDOWS\system32\SHELL32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x77bd0000 | 0x77bd7000 | C:\WINDOWS\system32\VERSION.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x77be0000 | 0x77c33000 | C:\WINDOWS\system32\msvcrt.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x77c40000 | 0x77c80000 | C:\WINDOWS\system32\GDI32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x77d10000 | 0x77d9c000 | C:\WINDOWS\system32\USER32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x77da0000 | 0x77e3c000 | C:\WINDOWS\system32\ADVAPI32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x77e40000 | 0x77f38000 | C:\WINDOWS\system32\kernel32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x77f40000 | 0x77fee000 | C:\WINDOWS\System32\ntdll.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x78000000 | 0x78086000 | C:\WINDOWS\system32\RPCRT4.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x78090000 | 0x78174000 | 
> C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b6
> 4144ccf1df_6.0.10.0_x-ww_
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   :           
>  :            :    f7fb5805\comctl32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x7c000000 | 0x7c054000 | C:\WINDOWS\System32\MSVCR70.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   | 
> 0x7ccc0000 | 0x7cde1000 | C:\WINDOWS\system32\ole32.dll
> 2004-04-22 03:06:07      0x11C ERR 19999 BTRACE   ----> Stack 
> Back Trace <----
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!_sql__perrorp + 23 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:00778fc7 RA:00778c24 FP:06b5b1cc SP:06b5b1d0 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:007dfa08 02:007ae1e8 03:00001fae 04:006ac951 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!_sql__caseerr + 20 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:00778c24 RA:006ac951 FP:06b5b1dc SP:06b5b1d0 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:007ae1e8 02:00001fae 03:62070050 04:00000079 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!g04locate_col + 753 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:006ac951 RA:00438828 FP:06b5b1fc SP:06b5b204 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:7f29dffd 02:62070050 03:06b5b2b4 04:06b5bb1c 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vgg04.c ( Line: 2240 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!bd37rewrite_record + 152 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:00438828 RA:00439115 FP:06b5bb38 SP:06b5bb40 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:06b5f008 02:01b5bb84 03:7f29dfbd 04:62070050 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vbd37.c ( Line: 1912 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!b37_unload_rewrite_table + 405 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:00439115 RA:0048d003 FP:06b5dc2c SP:06b5dc34 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:06b5f008 02:067502a0 03:00000000 04:00008de0 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vbd37.c ( Line: 2240 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!a09unload + 115 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:0048d003 RA:005842e1 FP:06b5dc58 SP:06b5dc60 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:067502c8 02:00000001 03:06b5e173 04:06b5e178 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vak09.c ( Line: 5469 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!ak93one_command + 785 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:005842e1 RA:00585116 FP:06b5dcb8 SP:06b5dcc0 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:00b5e178 02:00000001 03:067501c8 04:00000001 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vak93.c ( Line: 6390 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!a93_user_commands + 758 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:00585116 RA:0043730e FP:06b5dd44 SP:06b5dd4c 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:00b5e178 02:06b5e167 03:06b5e173 04:06b5ff14 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vak93.c ( Line: 5558 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!ak91run_sql_process + 94 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:0043730e RA:00437421 FP:06b5e168 SP:06b5e170 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:00b5e178 02:06b5ff14 03:067501a8 04:06750248 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vak91.c ( Line: 5285 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!ak91run_user_process + 225 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:00437421 RA:00437469 FP:06b5f790 SP:06b5f798 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:06b5ff14 02:00000003 03:00000000 04:06b5fefc 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vak91.c ( Line: 5330 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!a91mainprogam_with_allocator + 57 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:00437469 RA:006a7362 FP:06b5f7a4 SP:06b5f7ac 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:03b5ff14 02:77f83996 03:7feb67f0 04:00000000 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vak91.c ( Line: 5356 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!gg941CreateAllocatorAndCallMainprog + 210 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:006a7362 RA:00437498 FP:06b5fefc SP:06b5ff04 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:06b5ff03 02:06b5ff5c 03:0000000c 04:06b5ff14 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vgg941.cpp ( Line: 133 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!a91mainprogram + 40 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:00437498 RA:006f91ef FP:06b5ff78 SP:06b5ff80 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:77f83996 02:77f8398c 03:7fd0c060 04:00000000 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vak91.c ( Line: 5343 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel!sql88k_kernel_fiber + 191 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:006f91ef RA:77e5d33b FP:06b5ffb4 SP:06b5ffbc 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:7fd0c060 02:77f83996 03:77f8398c 04:7fd0c060 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Source:  vos88k.c ( Line: 435 )
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel32!RegisterWaitForInputIdle + 67 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:77e5d33b RA:77e546cf FP:06b5ffec SP:06b5ffbc 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:006f9130 02:7fd0c060 03:00000000 04:00000000 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE     
> kernel32!ConvertThreadToFiber + 137 bytes
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> SFrame:  IP:77e546cf RA:00000000 FP:0684fef0 SP:06b5ffbc 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE         
> Params:  01:00000000 02:00000000 03:00000000 04:00000000 
> 2004-04-22 03:06:09      0x11C ERR 19999 BTRACE   No crash 
> dump file 'knlcrash.dmp' written 
> 2004-04-22 03:18:44                               --- 
> Starting GMT 2004-04-22 03:18:44           7.4.3    Build 
> 030-123-056-274
> 
> Thanks!
> (Gerald)
> 

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to