on 07-21-2011 8:39 AM
Hello,
we had a repetitive db crash this morning.
I found the following line in knlmsg:
Thread 0x3A9 Task 715 2011-07-21 08:12:18 ERR DIAG 0: SIGNAL 11 (SIGSEGV) caught, PID: 0, thread: <unknown>, addr: (nil), value: 0x11517e4
It seems, that it has something to do with bulk delete operations. If I terminate our deletion job, the db stays online.
Our db version is 7.7.06.09 on rhel 5.4.
can somebody help?
best regards,
Michael
Thank you very much for the fast reply.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
dbanalyser gives some level 1 warnings.
What do you think? Are they relenvant?
1: ===== #0 at 2011-07-21 14:20:06
2: * I
3: * I Database Analyzer configuration check version 1.42, April 04, 2011
4: * I
5: * I General information:
6: * I --------------------
7: * I Instance PROD_R3 (gandalf) is up since 08:14:31
8: * I Kernel version: Kernel 7.7.06 Build 009-123-202-944
9: * I Number of CPUs: 15, processor type: x86_64
10: * I Physical memory 21504 MB, virtual memory 4095 MB, memory allocated from instance: 21024.53 MB
11: * I Operating system: Linux 2.6.18-128.1.6.el5xen #1 SMP Wed Apr 1 09:53:14 EDT 2009
12: * I Configuration of 'MaxCPUs': 14, 'MaxUserTasks': 3000
13: * I Size of data cache 2222534 pages (16.96 GB), size of converter cache 5599 pages (0.04 GB)
14: * I Number of data volumes 2, usable size 11999996 pages (91.55 GB), used size 7295233 pages (55.66 GB), filling level 60%
15: * I
16: * I General checks:
17: * I ---------------
18: * W1 Recommended value for parameter 'IndexlistsMergeThreshold' is 0, current value is 500
19: * W1 Recommended value for parameter 'MaxTaskStackSize' is 1024, current value is 768
20: * W1 Recommended value for parameter 'MaxExclusiveLockCollisionLoops' is 10000, current value is -1
21: * W1 Recommended value for parameter 'UseVectorIOSimulation' is NEVER, current value is IF_OPEN_DIRECT_OR_RAW_DEVICE
22: * W1 Recommended value for parameter 'JoinSearchTableThreshold9' is 8, current value is 5
23: * W1 Recommended value for parameter 'InitialAllocatorSize' is 1024000, current value is 532480
24: * I
25: * I If instance PROD_R3 is used for Data Warehouse applications, the following recommendations are of interest:
26: * I ----------------------------------------------------------------------------------------------------------
27: * W1 Recommended value for parameter 'HashJoinTotalMemorySize' is 24000, current value is 5120
28: * W1 Recommended value for parameter 'HashJoinSingleTableMemorySize' is 4000, current value is 512
29: * W1 Recommended value for parameter 'UseDataCacheScanOptimization' is YES, current value is NO
30: * W1 Recommended value for parameter 'EnableStarJoinOptimization' is NO, current value is YES! MaxDB update to version 7.7.06 >= Build 16 recommended!
31:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
yes , the warnings are relevant. Let me suggest however to first upgrade your database, then rerun the parameter check against the latest MaxDB version and adjust all parameters that are still getting warnings.
The stack back trace itself does not point to a specific error I could find (although there are close matches), so I am hoping this has been fixed in the current 7.7 release tree, but I can confirm that the abort happens during a delete operation (which fits you assumption about a delete job causing this...).
Thorsten
... and this:
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 16: a06lsend_mess_buf(SQLMan_Context&, SQLMan_MessBlock&, bool, short&, SAPDBErr_MessageList&) + 0x59f
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z17a06lsend_mess_bufR14SQLMan_ContextR16SQLMan_MessBlockbRsR20SAPDBErr_MessageList
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x000000000070da9f (0x000000000070d500+0x59f)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 17: a06dml_send_mess_buf(SQLMan_Context&, SQLMan_MessBlock&, SQLMan_DMLStatementContext&, short&) + 0x5d
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z20a06dml_send_mess_bufR14SQLMan_ContextR16SQLMan_MessBlockR26SQLMan_DMLStatementContextRs
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000711ded (0x0000000000711d90+0x5d)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 18: a505most_execute(SQLMan_Context&, SQLMan_DMLStatementContext&, tak_changerecord&, tak_parskey&, tak_exec_rec&, tak_corr_infos&, tak_corr_infos&, tak_systembuffer*, bool) + 0xa31
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z16a505most_executeR14SQLMan_ContextR26SQLMan_DMLStatementContextR16tak_changerecordR11tak_parskeyR12tak_exec_recR14tak_corr_infosSA_P16tak_systembufferb
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x000000000086ca11 (0x000000000086bfe0+0xa31)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 19: a505loop_most_execute(SQLMan_Context&, SQLMan_DMLStatementContext&, tak_changerecord&, tak_exec_rec&, tak_parskey&, tak_systembuffer*, tak_corr_infos&, tak_corr_infos&, bool) + 0x341
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z21a505loop_most_executeR14SQLMan_ContextR26SQLMan_DMLStatementContextR16tak_changerecordR12tak_exec_recR11tak_parskeyP16tak_systembufferR14tak_corr_infosSC_b
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x000000000086e321 (0x000000000086dfe0+0x341)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 20: a501exec_with_change_rec(SQLMan_Context&, SQLMan_DMLStatementContext&, tak_parskey&, tak_changerecord&, bool) + 0x8a6
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z24a501exec_with_change_recR14SQLMan_ContextR26SQLMan_DMLStatementContextR11tak_parskeyR16tak_changerecordb
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000861796 (0x0000000000860ef0+0x8a6)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 21: a501execute(SQLMan_Context&, tak_parsid&) + 0x6ea
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z11a501executeR14SQLMan_ContextR10tak_parsid
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x00000000008621ba (0x0000000000861ad0+0x6ea)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 22: a92_mode_analyzer(SQLMan_Context&, tak_ddl_descriptor_Enum, bool) + 0xe61
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z17a92_mode_analyzerR14SQLMan_Context23tak_ddl_descriptor_Enumb
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000948aa1 (0x0000000000947c40+0xe61)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 23: ak93one_command(SQLMan_Context&, int, int&, bool, bool&) + 0x7d1
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z15ak93one_commandR14SQLMan_ContextiRibRb
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x000000000094af31 (0x000000000094a760+0x7d1)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 24: a93_user_commands(SQLMan_Context&, bool&, bool&) + 0x5d1
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z17a93_user_commandsR14SQLMan_ContextRbS1_
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x000000000094d151 (0x000000000094cb80+0x5d1)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 25: SQLTask(SQLMan_Context&, Kernel_DatabaseContext*, RTETask_ITask&, bool&, bool) + 0x71
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z7SQLTaskR14SQLMan_ContextP22Kernel_DatabaseContextR13RTETask_ITaskRbb
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000001125a31 (0x00000000011259c0+0x71)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 26: Kernel_Main(RTETask_ITask&) + 0x1fd
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z11Kernel_MainR13RTETask_ITask
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000001125e5d (0x0000000001125c60+0x1fd)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 27: RTETask_Task::KernelTaskMain() + 0x140
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _ZN12RTETask_Task14KernelTaskMainEv
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x00000000011f9f60 (0x00000000011f9e20+0x140)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 28: RTETask_Task::Main(RTETask_Task&) + 0x56
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _ZN12RTETask_Task4MainERS_
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x00000000011fa236 (0x00000000011fa1e0+0x56)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 29: en88_CallKernelTaskMain() + 0x71
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z23en88_CallKernelTaskMainv
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x00000000012ff6c1 (0x00000000012ff650+0x71)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 30: _dl_tls_get_addr_soft@@GLIBC_PRIVATE + 0x419c0
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x00000034e6c419c0 (0x00000034e6c00000+0x419c0)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /lib64/libc-2.5.so
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you mean this?:
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: ----> Symbolic stack backtrace <----
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 0: tfind@@GLIBC_2.2.5 + 0xeb10
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x00000034e740eb10 (0x00000034e7400000+0xeb10)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /lib64/libpthread-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 1: cbd600_Node::bd600EvalSepKeyLen(Data_IndexKeyDescription const&, Data_IndexKeyDescription&) const + 0x69
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _ZNK11cbd600_Node18bd600EvalSepKeyLenERK24Data_IndexKeyDescriptionRS0_
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000cbc379 (0x0000000000cbc310+0x69)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 2: cbd500_Tree::bd520_DistributeFromRight(cbd600_Node&, int, int, bool, cbd501_IndexOrders&) + 0x439
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _ZN11cbd500_Tree25bd520_DistributeFromRightER11cbd600_NodeiibR18cbd501_IndexOrders
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000cb4079 (0x0000000000cb3c40+0x439)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 3: cbd500_Tree::bd520_UnderFlow(cbd600_Node&, cbd600_Node&, bool, int&, cbd501_IndexOrders&) + 0x814
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _ZN11cbd500_Tree15bd520_UnderFlowER11cbd600_NodeS1_bRiR18cbd501_IndexOrders
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000cb4934 (0x0000000000cb4120+0x814)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 4: cbd500_Tree::bd520LeafUnderFlow(Data_IndexKeyDescription const&) + 0x29b
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _ZN11cbd500_Tree18bd520LeafUnderFlowERK24Data_IndexKeyDescription
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000cb530b (0x0000000000cb5070+0x29b)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 5: bd400DelFromInvTree(cbd300_InvCurrent&, Data_IndexKeyDescription const&, Data_IndexKeyDescription const&, bool, tbd00_DelInvReason_Enum) + 0x674
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z19bd400DelFromInvTreeR17cbd300_InvCurrentRK24Data_IndexKeyDescriptionS3_b23tbd00_DelInvReason_Enum
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000c7a944 (0x0000000000c7a2d0+0x674)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 6: b03del_inv + 0x882
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000b9e5f2 (0x0000000000b9dd70+0x882)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 7: Log_InvDescMap::DelInv(tgg00_TransContext&, bool, tbd00_DelInvReason_Enum, tgg00_FileId const&, tgg00_LogicalRec const*) const + 0x2f8
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _ZNK14Log_InvDescMap6DelInvER18tgg00_TransContextb23tbd00_DelInvReason_EnumRK12tgg00_FileIdPK16tgg00_LogicalRec
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000d80e48 (0x0000000000d80b50+0x2f8)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 8: k61del_select + 0x28b
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000ae273b (0x0000000000ae24b0+0x28b)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 9: k721result_handle(SQLMan_MessBlock&, tgg07_select_param&, tgg00_SelectFieldsParam&, tgg00_Lkey&, tgg00_FileId&, tsp00_Enum<tgg00_LockReqMode_Enum, 7, unsigned char>) + 0x3f8
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z17k721result_handleR16SQLMan_MessBlockR18tgg07_select_paramR23tgg00_SelectFieldsParamR10tgg00_LkeyR12tgg00_FileId10tsp00_EnumI22tgg00_LockReqMode_EnumLi7EhE
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000b08c78 (0x0000000000b08880+0x3f8)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 10: kb72select_gets(SQLMan_MessBlock&, tgg00_Lkey&, tgg07_select_param&, tgg00_SelectFieldsParam&) + 0x14a
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z15kb72select_getsR16SQLMan_MessBlockR10tgg00_LkeyR18tgg07_select_paramR23tgg00_SelectFieldsParam
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000b1061a (0x0000000000b104d0+0x14a)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 11: k72eq_keyrecord(SQLMan_MessBlock&, tgg07_select_param&, tgg00_SelectFieldsParam&, tgg07_StrategyInfo&) + 0x20
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z15k72eq_keyrecordR16SQLMan_MessBlockR18tgg07_select_paramR23tgg00_SelectFieldsParamR18tgg07_StrategyInfo
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000b106c0 (0x0000000000b106a0+0x20)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 12: k720_select(SQLMan_MessBlock&, tgg07_select_param&) + 0x8aa
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z11k720_selectR16SQLMan_MessBlockR18tgg07_select_param
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000b069da (0x0000000000b06130+0x8aa)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 13: k720_single_select(SQLMan_MessBlock&) + 0x37
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z18k720_single_selectR16SQLMan_MessBlock
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000b06a67 (0x0000000000b06a30+0x37)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 14: k61del_upd_qual + 0xae
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000ae183e (0x0000000000ae1790+0xae)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: 15: k05functions(SQLMan_MessBlock&) + 0xc32
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Symbol: _Z12k05functionsR16SQLMan_MessBlock
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: SFrame: IP: 0x0000000000a90192 (0x0000000000a8f560+0xc32)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Module: /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: -----------------------------------------
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
... and here the scond part:
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: ----> Module List <----
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |.text Start |.text End | Module File Name
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x0000000000400000|0x00000000016c1000| /opt/sdb/7706/pgm/kernel
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034e6800000|0x00000034e681c000| /lib64/ld-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034e6c00000|0x00000034e6d4e000| /lib64/libc-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034e7000000|0x00000034e7002000| /lib64/libdl-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034e7400000|0x00000034e7416000| /lib64/libpthread-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034e7800000|0x00000034e7882000| /lib64/libm-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034e8800000|0x00000034e8807000| /lib64/librt-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034e9000000|0x00000034e90e6000| /usr/lib64/libstdc++.so.6.0.8
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034e9800000|0x00000034e980d000| /lib64/libgcc_s-4.1.2-20080825.so.1
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00000034ec000000|0x00000034ec011000| /lib64/libresolv-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00002aaaacfbd000|0x00002aaaacfc7000| /lib64/libnss_files-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00002aaabbf12000|0x00002aaabbf16000| /lib64/libnss_dns-2.5.so
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: |0x00002aaefc419000|0x00002aaefc723000| /opt/sdb/7706/lib/liboms.so
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
thank you for your reply.
Here is the first part of the stack trace:
Thread 0x3A9 Task 715 2011-07-21 08:12:20 RunTime 3: State changed from ONLINE to ABORT
Thread 0x3A9 Task - 2011-07-21 08:12:20 RTEKernel 60: Kernel aborts
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: ----> Emergency stack backtrace <----
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: Using 'backtrace' for stack tracing
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (0):0x00000034e740eb10
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (1):0x0000000000cbc379
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (2):0x0000000000cb4079
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (3):0x0000000000cb4934
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (4):0x0000000000cb530b
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (5):0x0000000000c7a944
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (6):0x0000000000b9e5f2
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (7):0x0000000000d80e48
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (8):0x0000000000ae273b
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (9):0x0000000000b08c78
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (10):0x0000000000b1061a
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (11):0x0000000000b106c0
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (12):0x0000000000b069da
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (13):0x0000000000b06a67
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (14):0x0000000000ae183e
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (15):0x0000000000a90192
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (16):0x000000000070da9f
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (17):0x0000000000711ded
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (18):0x000000000086ca11
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (19):0x000000000086e321
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (20):0x0000000000861796
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (21):0x00000000008621ba
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (22):0x0000000000948aa1
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (23):0x000000000094af31
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (24):0x000000000094d151
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (25):0x0000000001125a31
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (26):0x0000000001125e5d
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (27):0x00000000011f9f60
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (28):0x00000000011fa236
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (29):0x00000000012ff6c1
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: (30):0x00000034e6c419c0
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: ----> Dump of siginfo contents <----
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: signal: 11(SIGSEGV)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: code: 1(ILL_ILLOPC:illegal opcode)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: errno: 0
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: value(int): 18159588(0x11517e4)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: value(ptr): 0x11517e4
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: pid: 0
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: addr: (nil)
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: ----> Register Dump <----
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: rax: 0x0000000000000100 rbx: 0x00002aaf1e6173b0
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: rcx: 0x0000000000000000 rdx: 0x00002aaf1e6173da
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: rsi: 0x0000000000000000 rdi: 0x000000000000006e
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: rsp: 0x00002aaf1e617330 rbp: 0x00002aab55aa71f4
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: r08: 0x000000530000015b r09: 0x0000000000000000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: r10: 0x00002aab55aa71fa r11: 0x0000000000000000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: r12: 0x00002aaf1e617380 r13: 0x00002aaf1e62b518
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: r14: 0x0000000000000001 r15: 0x0000000000000000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: rip: 0x0000000000cbc379 eflg: 0x0000000000010287
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: cs: 0x0000 gs: 0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fs: 0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: omsk: 0x0000000000000000 cr2: 0x0000000000000000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: trap: 0x000000000000000e err: 0x0000000000000004
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: ----> Floating-point register dump <----
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: foper: 0x0000 frip: 0x00002aaaab586450 fdata: 0x00002aaaab92f090
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: control: 0x0000 status: 0x0000 tag: 0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: mxcsr: 0x0000037f mxcr_mask: 0x00000000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fp[0]: 0x0.0000 0000 0000 0000 * 2^0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fp[1]: 0x0.1fa0 0000 ffff 0000 * 2^0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fp[2]: 0x0.0000 0000 0000 0000 * 2^0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fp[3]: 0x0.0000 0000 0000 0000 * 2^0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fp[4]: 0x0.0000 0000 0000 0000 * 2^0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fp[5]: 0x0.0000 0000 0000 0000 * 2^0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fp[6]: 0x0.0000 0000 0000 0000 * 2^0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: fp[7]: 0x0.0000 0000 0000 0000 * 2^0x0000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[00]: 0x00000000.00000000.e57a4000.d6bf94d5
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[01]: 0x00003fe7.00000000.2f88abd3.41f38055
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[02]: 0x20202020.20202020.00000000.43e00000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[03]: 0x00000000.00000000.3f9e50d8.3fe00000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[04]: 0x00000000.00000000.62762762.40b3b0a7
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[05]: 0x00000000.00000000.00000000.3ff00000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[06]: 0x00000000.00000000.00000000.40080000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[07]: 0x00000000.00000000.00000000.40000000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[08]: 0x00000000.00000000.bd3b2c9e.40c3b7da
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[09]: 0x00000000.00000000.31dbeabb.3fbfec91
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[10]: 0x00000000.00000000.0226d3bd.3d63576c
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[11]: 0x00000000.00000000.01c3f8f0.3fec3f8f
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[12]: 0x00000000.00000000.038035ab.401c3986
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[13]: 0x00000000.00000000.00000000.00000000
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[14]: 0x00000000.00000000.bc5ca07e.3d635816
Thread 0x3A9 Task - 2011-07-21 08:12:20 ERR DIAG 0: xmm[15]: 0x00000000.00000000.00000000.00000000
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
it is a production system but not SAP.
Best regards,
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
three things I would recommend:
1. Usually the database write a stack back trace after aborting with a signal. Please check the knldiag file and let us know the function calls.
2. Use the Database Analyzer parameter checker to verify that all database parameters are set as recommended for your database version (see download link in the 'sticky. section of this forum).
3. MaxDB 7.7.06.09 is quiet old - if possible, schedule an upgrade to the latest version of 7.7 soon (see download link in the 'sticky' section of this forum).
Thorsten
If this is production system and you got the license from SAP then advice to open a sap oss message.
check Note 1345735 - Database crash with signal 11
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.