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 -- 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 -- 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]
