Florian, the reason for signal 11 is fixed with PTS 1135464 in 7.5.0.29.
Regards, Dirk -----Original Message----- From: Florian Schmitz [mailto:[EMAIL PROTECTED] Sent: Dienstag, 10. Mai 2005 14:40 To: Thomsen, Dirk; [email protected] 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: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > Sent: Dienstag, 10. Mai 2005 14:19 > To: [email protected] > 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 > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
