RE: Corehand Aborting due to Signal 11

[Dirk Thomsen]

Florian,

 the reason for signal 11 is fixed with PTS 1135464 in 7.5.0.29.

Regards, Dirk

-----Original Message-----
From: Florian Schmitz [mailto:fschmitz@stripped] 
Sent: Dienstag, 10. Mai 2005 14:40
To: Thomsen, Dirk; maxdb@stripped
Subject: Re: Corehand Aborting due to Signal 11

Hello Dirk,

thanks for the advice with the HASHED_RESULTSETS. I'll give it a try later on.

See the attached knldiag.err

Flo

Florian Schmitz

______________________
acardo technologies AG
Königswall 18a
44137 Dortmund

fon: +49 (0) 2 31 / 58 44 97 - 0
fax: +49 (0) 2 31 / 58 44 97 - 21
mail: fschmitz@stripped
web: www.acardo.com


Thomsen, Dirk schrieb:
> Florian,
>  could you please send the complete KNLDIAGERR or at least the last 2 or 3 pages
> before the crash occurs? To avoid the crash you should set the kernel parameter
> HASHED_RESULTSET to NO.
> 
> Regards, Dirk
> 
> -----Original Message-----
> From: Florian Schmitz [mailto:fschmitz@stripped] 
> Sent: Dienstag, 10. Mai 2005 14:19
> To: maxdb@stripped
> Subject: Corehand Aborting due to Signal 11
> 
> Hello List,
> 
> we're running on 7.5.0.26, on Linux 2.6 with 4GB of ram.
> When running complex queries with many tables involved, we sometimes get the
> following error, 
> resulting in a crash :
> ######
> 2005-05-10 13:52:47     0 ERR 11330 COREHAND ABORTING due to signal 11
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ----> Emergency Stack Back Trace
> <----
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (0):0x87f37bd 
> [0x41fb22ec](0x46704c30,0x466cd06c,0x41fb2328,0x87f0df2)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (1):0x87f0e67 
> [0x41fb22ec](0x46704c30,0x466cd06c,0x41fb2328,0x87f0df2)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (3):0x837645c 
> [0x41fb232c](0x46704c30,0x466ed648,0x466cd06c,0x41fc8868)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (5):0x8356643 
> [0x41fb236c](0x46704b58,0x466ed648,0x41fb23dc,0x41fb24b6)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (7):0x8332619 
> [0x41fb242c](0x41fc8868,0x41fb643c,0x41fb3d68,0x41fb4758)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (9):0x833159e 
> [0x41fb24dc](0x41fc8868,0x41fb643c,0x41fb3d68,0x41fb4970)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (11):0x82746a0 
> [0x41fb460c](0x41fc8868,0x41fb643c,0x41fb4758,0x41fb4970)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (13):0x827380d 
> [0x41fb47ec](0x41fc8868,0x41fb643c,0x41fb5438,0x41fc8128)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (15):0x826d6ea 
> [0x41fb4aac](0x41fc8868,0x41fb643c,0x41fb5438,0x41fb5318)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (17):0x826dc26 
> [0x41fb53dc](0x41fc8868,0x41fb643c,0x41fc8128,0x41fb5438)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (19):0x831573f 
> [0x41fc7fec](0x41fc8868,0x41fc8124,0x4,0x8315149)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (21):0x83165dd
> [0x41fc813c](0x41fc8868,0x0,0x0,0x0)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (23):0x831aec5
> [0x41fc823c](0x41fc8868,0x0,0x0,0x831aaf4)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (25):0x8319abd
> [0x41fc837c](0x41fc8868,0x1,0x41fc83e4,0x1)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (27):0x813d0d1 
> [0x41fc841c](0x41fc8868,0x41fc8456,0x41fc8457,0x813cfbd)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (29):0x813d375 
> [0x41fc9cec](0x41fc9de0,0x3,0x4023b1bc,0x813d341)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (31):0x8531a69
> [0x41fc9d1c](0x41fc9de0,0x2,0xffffffff,0x65)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (33):0x813d318
> [0x41fc9dac](0x41fc9de0,0x0,0x0,0x813d2ec)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (35):0x87cd772 
> [0x41fc9e4c](0x8af21dc,0x5002e61c,0x40211d10,0x41fc9e80)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (37):0x87cdba5 
> [0x41fc9e7c](0x5002e61c,0x40211cf8,0x41fc9eac,0x87cdb7f)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (39):0x877f6fb 
> [0x41fc9eac](0x5002e61c,0x40211cf8,0x41fc9eec,0x877f669)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   (41):0x40022f71
> [0x41fc9eec](0x40211cc0,0x0,0x2d5f9ad8,0x0)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ----> Register Dump <----
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   -------------------------------
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ds   es   0x0000007b 0x0000007b
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   fs   gs   0x00000000 0x00000033
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   trap err  0x0000000e 0x00000006
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   efl  ss   0x00010246 0x0000007b
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   edi  esi  0x46704c30 0x46704c30
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   eax  ebx  0x00000000
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ecx  edx  0x4dedd7b0
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   esp  uesp 0x41fb2294 0x41fb2294
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ebp  eip  0x41fb22ec 0x087f37bd
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   cs   cr2  0x00000073 0x00000000
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   -------------------------------
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   cw - sw - tag   0xffff037f 0xffff0120
> 0xffffffff
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ipoff - cssel   0x08442ef0 0x01c90073
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   dataoff-datasel 0x41fc9850 0x0000007b
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   f00      [0x0000 0x0000 0x0000 0x0000 -
> 0x0000]
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   f01      [0x0000 0x0000 0x0000 0x0000 -
> 0x0000]
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   f02      [0xef17 0x67cd 0x68b8 0xdf1a -
> 0x3ffc]
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   f03      [0xef17 0x67cd 0x68b8 0xdf1a -
> 0x3ffc]
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   f04      [0xef17 0x67cd 0x68b8 0xdf1a -
> 0x4001]
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   f05      [0xf597 0x76e3 0x8807 0xc906 -
> 0x4003]
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   f06      [0x0000 0x0000 0xdf6c 0x9e2b -
> 0x401c]
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   f07      [0x0000 0x0000 0xc000 0xe7df -
> 0x4012]
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   -------------------------------
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ----> Module List <----
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   |.text Start |.text End   | Module File
> Name
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x08048000 | 0x0895b000 |
> /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x40000000 | 0x40016000 |
> /lib/ld-2.3.3.so
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x4001d000 | 0x4002b000 |
> /lib/i686/libpthread.so.0
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x4006e000 | 0x40070000 |
> /lib/libdl.so.2
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x40072000 | 0x40079000 |
> /lib/librt.so.1
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x40085000 | 0x400bf000 | 
> /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x400d2000 | 0x400f3000 |
> /lib/i686/libm.so.6
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x400f4000 | 0x401fd000 |
> /lib/i686/libc.so.6
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x40b0e000 | 0x40b15000 |
> /lib/libnss_compat.so.2
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x40b16000 | 0x40b28000 |
> /lib/libnsl.so.1
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x40b2b000 | 0x40b33000 |
> /lib/libnss_nis.so.2
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x40b34000 | 0x40b3c000 |
> /lib/libnss_files.so.2
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x4cb90000 | 0x4cc67000 |
> /usr/sapdb/depend/lib/liboms.so
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   | 0x4cca2000 | 0x4ccb1000 | 
> /usr/sapdb/depend/lib/dbpinstall.so
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ----> Symbolic Stack Back Trace
> <----
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      0: 0x087f37bd 
> GetMemForEntry__35Table_FixSizeTempHashTableAggregateR20SAPDBErr_MessageList +0x0049
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb22ec] 
> (0x46704c30,0x466cd06c,0x41fb2328,0x87f0df2)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      1: 0x087f0e67 
> InsertOrReplace__35Table_FixSizeTempHashTableAggregatePUcR20SAPDBErr_MessageList
> +0x0083
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb22ec] 
> (0x46704c30,0x466cd06c,0x41fb2328,0x87f0df2)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      2: 0x0837645c 
> Add__25Join_ResultSetAggregator2R9tgg00_Rec +0x0078
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb232c] 
> (0x46704c30,0x466ed648,0x466cd06c,0x41fc8868)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      3: 0x08356643 a686_create_join_result
> +0x051f
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb236c] 
> (0x46704b58,0x466ed648,0x41fb23dc,0x41fb24b6)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      4: 0x08332619
> a682_execute_join_operator +0x0149
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb242c] 
> (0x41fc8868,0x41fb643c,0x41fb3d68,0x41fb4758)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      5: 0x0833159e a682_only_ex_join
> +0x0316
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb24dc] 
> (0x41fc8868,0x41fb643c,0x41fb3d68,0x41fb4970)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      6: 0x082746a0 a505most_execute
> +0x09fc
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb460c] 
> (0x41fc8868,0x41fb643c,0x41fb4758,0x41fb4970)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      7: 0x0827380d a505loop_most_execute
> +0x03f5
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb47ec] 
> (0x41fc8868,0x41fb643c,0x41fb5438,0x41fc8128)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      8: 0x0826d6ea
> a501exec_with_change_rec +0x0836
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb4aac] 
> (0x41fc8868,0x41fb643c,0x41fb5438,0x41fb5318)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE      9: 0x0826dc26 a501execute +0x0302
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fb53dc] 
> (0x41fc8868,0x41fb643c,0x41fc8128,0x41fb5438)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     10: 0x0831573f ak92analyze_messagetype
> +0x0607
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc7fec] 
> (0x41fc8868,0x41fc8124,0x4,0x8315149)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     11: 0x083165dd a92_mode_analyzer
> +0x01cd
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc813c]
> (0x41fc8868,0x0,0x0,0x0)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     12: 0x0831aec5 ak93one_command
> +0x0779
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc823c]
> (0x41fc8868,0x0,0x0,0x831aaf4)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     13: 0x08319abd a93_user_commands
> +0x047d
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc837c] 
> (0x41fc8868,0x1,0x41fc83e4,0x1)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     14: 0x0813d0d1 ak91run_user_process
> +0x0125
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc841c] 
> (0x41fc8868,0x41fc8456,0x41fc8457,0x813cfbd)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     15: 0x0813d375
> a91mainprogam_with_allocator +0x0041
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc9cec] 
> (0x41fc9de0,0x3,0x4023b1bc,0x813d341)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     16: 0x08531a69
> gg941CreateAllocatorAndCallMainprog 
> +0x01e5
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc9d1c] 
> (0x41fc9de0,0x2,0xffffffff,0x65)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     17: 0x0813d318 a91mainprogram +0x003c
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc9dac]
> (0x41fc9de0,0x0,0x0,0x813d2ec)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     18: 0x087cd772
> en88_CallKernelTaskMain__FP9TASK_TYPE 
> +0x016e
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc9e4c] 
> (0x8af21dc,0x5002e61c,0x40211d10,0x41fc9e80)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE     19: 0x087cdba5 en88_RunPthreadTask
> +0x0041
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE          /usr/sapdb/depend/pgm/kernel
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE         Frameinfo [0x41fc9e7c] 
> (0x5002e61c,0x40211cf8,0x41fc9eac,0x87cdb7f)
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   ----> End of Stack Back Trace
> <----
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   analysing LVCMem_Allocator_1
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE
> 2005-05-10 13:52:47     0 ERR 11599 BTRACE   no problems detected in
> LVCMem_Allocator_1
> 2005-05-10 13:52:48     0 ERR 11979 DBCRASH  Kernel exited without core and exit
> status 0x2f00
> 2005-05-10 13:52:48     0 ERR 11981 DBCRASH  Kernel exited due to reentered signal
> handler
> 
> #####################
> 
> A explain-example of such query :
> 
>           HAENDLER          CUSTOMER_CUSTOMERNO      INDEX SCAN                      
>                30
>                                                      ONLY INDEX ACCESSED
> SCHEMA1  BRANCH            BRANCH_CUSTOMER_UUID     JOIN VIA INDEXED COLUMN          
>              276
> SCHEMA1  ECOUPON_SUMS_CBU  ECOUPON_CBU_BRANCH_UUID  JOIN VIA INDEXED COLUMN          
>            60701
>                                                      PARALLEL INDEX ACCESS
> SCHEMA1  ADDRESS           ADDRESS_BRANCH_UUID      JOIN VIA INDEXED COLUMN          
>              422
> SCHEMA1  COUPON            UUID                     JOIN VIA KEY COLUMN              
>              142
> SCHEMA1  PROMO             UUID                     JOIN VIA KEY COLUMN              
>               78
>                                                      TABLE HASHED
> SCHEMA1  ROLEASSIGN        ROLEASSIGN_PROMO_UUID    JOIN VIA INDEXED COLUMN          
>              304
> SCHEMA1  ROLE              UUID                     JOIN VIA KEY COLUMN              
>                1
>                                                      TABLE HASHED
>           HERSTELLER        UUID                     JOIN VIA KEY COLUMN             
>                30
>                                                           NO TEMPORARY RESULTS
> CREATED
>                                                           RESULT IS COPIED   ,
> COSTVALUE IS     3866760
> 
> ####################
> 
> 
> Any help will be appreciated. If needed, i send on some additional information like
> table-structure 
> and parameter-settings.
> 
> Thanks for your help
> 
> Flo
>