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]
