Hi, we use MAXDB Version 7.5.00.19 with complex triggers and procedures. With lock mechanism we ensure that only one user can do a statement that result in intensiv database actions. One of the complex actions produces sometimes the following databse error
2005-04-29 09:19:50 10606 ERR 51080 SYSERROR -9999 Otherwise unknown errorcode We don't know, where or how to localise the reasen. The DB log also contains the following messages and because of the underlined part we assume an error in one of our triggers. But how can we find it. Any help would be appreciated. Elke 2005-04-28 13:10:45 10605 ERR 53173 B*TREE NOT ftsTemp IN filetype: 0 2005-04-28 13:10:45 10605 ERR 53000 B*TREE 70E3DC592543690880C0B20890010000 2005-04-28 13:10:45 10605 ERR 53000 B*TREE Root 1507649948 2005-04-28 13:10:45 10605 ERR 11599 BTRACE ----> Emergency Stack Back Trace <---- 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (0):0x83fe6bb [0x59dcc100](0x59dce328,0x0,0x59dcc138,0x83fe606) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (2):0x81ca62e [0x59dcc150](0x59dcf954,0x59dce328,0x59525c8c,0x81c9ea5) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (4):0x83174dc [0x59dce370](0x59dce99c,0x3,0x59dce4b0,0x83172e5) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (6):0x8315dcd [0x59dce4b0](0x59dce99c,0x1,0x59dce518,0x1) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (8):0x813b3a1 [0x59dce550](0x59dce99c,0x59dce58a,0x59dce58b,0x813b28d) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (10):0x813b645 [0x59dcfe20](0x59dcff14,0x3,0x40244430,0x813b611) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (12):0x8525169 [0x59dcfe50](0x59dcff14,0x2,0xffffffff,0x24) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (14):0x813b5e8 [0x59dcfee0](0x59dcff14,0x0,0x0,0x813b5bc) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (16):0x87ab992 [0x59dcff80](0x8ac2668,0x40235e30,0x87abe38,0x87abe38) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (18):0x87abe66 [0x59dcffb0](0x40367698,0x8b6ca80,0x0,0x0) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE (20):0x40136004 [0x59dcfff0](0x8775cca,0x0,0x0,0x0) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE ----> Module List <---- 2005-04-28 13:10:45 10605 ERR 11599 BTRACE |.text Start |.text End | Module File Name 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x08048000 | 0x08937000 | /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x40000000 | 0x40014000 | /lib/ld-2.3.2.so 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x4001a000 | 0x40027000 | /lib/libpthread.so.0 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x4006b000 | 0x4006d000 | /lib/libdl.so.2 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x4006e000 | 0x40074000 | /lib/librt.so.1 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x40080000 | 0x400b9000 | /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x400cd000 | 0x400ee000 | /lib/libm.so.6 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x400ef000 | 0x4021e000 | /lib/libc.so.6 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x40328000 | 0x40333000 | /lib/libnss_compat.so.2 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x40334000 | 0x40346000 | /lib/libnsl.so.1 2005-04-28 13:10:45 10605 ERR 11599 BTRACE | 0x6055c000 | 0x60629000 | /opt/sdb/7500/lib/liboms.so 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 2005-04-28 13:10:45 10605 ERR 11599 BTRACE ----> Symbolic Stack Back Trace <---- 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 0: 0x083fe6bb b01destroy_file +0x00c3 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dcc100] (0x59dce328,0x0,0x59dcc138,0x83fe606) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 1: 0x081ca62e a262execute_trigger +0x079a 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dcc150] (0x59dcf954,0x59dce328,0x59525c8c,0x81c9ea5) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 2: 0x083174dc ak93one_command +0x0aa0 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dce370] (0x59dce99c,0x3,0x59dce4b0,0x83172e5) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 3: 0x08315dcd a93_user_commands +0x047d 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dce4b0] (0x59dce99c,0x1,0x59dce518,0x1) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 4: 0x0813b3a1 ak91run_user_process +0x0125 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dce550] (0x59dce99c,0x59dce58a,0x59dce58b,0x813b28d) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 5: 0x0813b645 a91mainprogam_with_allocator +0x0041 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dcfe20] (0x59dcff14,0x3,0x40244430,0x813b611) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 6: 0x08525169 gg941CreateAllocatorAndCallMainprog +0x01e5 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dcfe50] (0x59dcff14,0x2,0xffffffff,0x24) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 7: 0x0813b5e8 a91mainprogram +0x003c 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dcfee0] (0x59dcff14,0x0,0x0,0x813b5bc) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 8: 0x087ab992 en88_CallKernelTaskMain__FP9TASK_TYPE +0x016e 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dcff80] (0x8ac2668,0x40235e30,0x87abe38,0x87abe38) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE 9: 0x087abe66 en88_CallCoroutineKernelTaskMain +0x002e 2005-04-28 13:10:45 10605 ERR 11599 BTRACE /opt/sdb/7500/pgm/kernel 2005-04-28 13:10:45 10605 ERR 11599 BTRACE Frameinfo [0x59dcffb0] (0x40367698,0x8b6ca80,0x0,0x0) 2005-04-28 13:10:45 10605 ERR 11599 BTRACE ----> End of Stack Back Trace <---- -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
