cancel
Showing results for 
Search instead for 
Did you mean: 

query causes [-807] Connection down, session released

Former Member
0 Kudos

Hello all,

The following statements cause a shutdown with MaxDB 7.6:

create table a (aa char(5) key)

-> select * from a order by a.VALUE(aa,1)

Of course the last statement is wrong, but perhaps the DB should handle it different.

Best regards, Gabriel

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

these logs look similar to mine. Fine, then we can be sure to talk about the same problem.

And I like to read your statement about upgrade to 7.7.

Elke

Former Member
0 Kudos

Hallo,

you are definitely right, even funny looking statements should not result in a core.

This will be corrected as soon as possible.

The problem is the schema (or user) name in front of the period.

A problem could be reproduced very easily. But the resulting core looked quite different. A stack overflow could be produced, not your trace back. And that traceback will never be reached with your statement. Therefore I am not really sure if you do not have another problem with your kernel version.

I would recommend using the newest version available (although it will up to now not handle the mentioned statement correctly).

Elke

simon_matter
Participant
0 Kudos

That may be my error not posting the correct logs. Maybe the logs below are what you were asking?

BTW, we are planning the upgrade to 7.7 right now.

Thanks,

Simon

2009-05-14 19:20:13                          --- Starting GMT 2009-05-14 17:20:13           7.6.05   Build 009-123-191-997 
2009-05-14 19:24:20     0 ERR 12006 DBCRASH  Kernel exited without core and exit status 0xb
2009-05-14 19:24:20     0 ERR 12011 DBCRASH  No stack backtrace since signal handler was not called. This indicates a stack overflow
2009-05-14 19:24:20     0 ERR 12009 DBCRASH  Kernel exited due to signal 11(SIGSEGV)
2009-05-14 19:24:20                          ___ Stopping GMT 2009-05-14 17:24:20           7.6.05   Build 009-123-191-997 
2009-05-14 19:26:03                          --- Starting GMT 2009-05-14 17:26:03           7.6.05   Build 009-123-191-997 
2009-05-14 19:27:50     0 ERR 12006 DBCRASH  Kernel exited without core and exit status 0xb
2009-05-14 19:27:50     0 ERR 12011 DBCRASH  No stack backtrace since signal handler was not called. This indicates a stack overflow
2009-05-14 19:27:50     0 ERR 12009 DBCRASH  Kernel exited due to signal 11(SIGSEGV)
2009-05-14 19:27:50                          ___ Stopping GMT 2009-05-14 17:27:50           7.6.05   Build 009-123-191-997

markus_doehr2
Active Contributor
0 Kudos

Please post the last lines of knldiag containing the error.

Markus

simon_matter
Participant
0 Kudos

I have access to the server and found the log below.

Regards,

Simon

2009-05-14 19:18:54     0 ERR 11599 BTRACE   
2009-05-14 19:18:54     0 ERR 11599 BTRACE   ----> Symbolic Stack Back Trace <----
2009-05-14 19:18:54     0 ERR 11599 BTRACE      0: 0x0000000000eec72d eo670_UnixTraceStack +0x01ad
2009-05-14 19:18:54     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:54     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:54     0 ERR 11599 BTRACE      1: 0x0000000000eed0f9 eo670_CTraceContextStackOCB +0x0009
2009-05-14 19:18:54     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:54     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:54     0 ERR 11599 BTRACE      2: 0x0000000000eed117 eo670_CTraceContextStack +0x0017
2009-05-14 19:18:54     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:54     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:54     0 ERR 11599 BTRACE      3: 0x0000000000f30898 en81_CrashSignalHandler +0x00e8
2009-05-14 19:18:54     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:54     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:54     0 ERR 11599 BTRACE      4: 0x000000361ae0e4c0 tfind@@GLIBC_2.2.5 +0xe4c0
2009-05-14 19:18:54     0 ERR 11599 BTRACE          /lib64/libpthread-2.5.so
2009-05-14 19:18:54     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:54     0 ERR 11599 BTRACE      5: 0x000000000075c2f4 ak45one_link_show +0x0c34
2009-05-14 19:18:54     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:54     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:54     0 ERR 11599 BTRACE      6: 0x000000000075c97b ak45link_show +0x019b
2009-05-14 19:18:54     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:54     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:54     0 ERR 11599 BTRACE      7: 0x000000000075dcfa ak45check_one_table +0x020a
2009-05-14 19:18:54     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:54     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE      8: 0x000000000075dfb3 ak45user_table_scan +0x0183
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE      9: 0x000000000075e13b a45show_execute +0x009b
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     10: 0x000000000073fc81 a41execute_show +0x0721
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     11: 0x000000000065bd57 a06dml_send_mess_buf +0x0067
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     12: 0x0000000000782f22 a505most_execute +0x0af2
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     13: 0x0000000000784240 a505loop_most_execute +0x0360
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     14: 0x00000000007789e6 a501exec_with_change_rec +0x05d6
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     15: 0x00000000007798e8 a501execute +0x0518
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     16: 0x000000000083977f ak92analyze_messagetype +0x03cf
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     17: 0x000000000083a15b a92_mode_analyzer +0x009b
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     18: 0x000000000083b1eb ak93one_command +0x049b
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     19: 0x000000000083dd6d a93_user_commands +0x056d
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     20: 0x0000000000df8574 _Z7SQLTaskR20tak_all_command_globRhb +0x0074
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     21: 0x0000000000df8753 _Z11Kernel_MainR13RTETask_ITask +0x01b3
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     22: 0x0000000000e86198 RTETask_TaskMain +0x0038
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     23: 0x0000000000f37737 _Z23en88_CallKernelTaskMainP9TASK_TYPE +0x00c7
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /opt/sdb/7605/pgm/kernel
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE     24: 0x000000361a641820 _dl_tls_get_addr_soft@@GLIBC_PRIVATE +0x41820
2009-05-14 19:18:55     0 ERR 11599 BTRACE          /lib64/libc-2.5.so
2009-05-14 19:18:55     0 ERR 11599 BTRACE         Frameinfo [0x0]
2009-05-14 19:18:55     0 ERR 11599 BTRACE   ----> End of Stack Back Trace <----
2009-05-14 19:18:55     0 ERR 11330 COREHAND dump of siginfo content:
2009-05-14 19:18:55     0 ERR 11330 COREHAND  signal     11 (SIGSEGV)
2009-05-14 19:18:55     0 ERR 11330 COREHAND  code       128 (unknown)
2009-05-14 19:18:55     0 ERR 11330 COREHAND  errno      0
2009-05-14 19:18:55     0 ERR 11330 COREHAND  value(int) 65581
2009-05-14 19:18:55     0 ERR 11330 COREHAND  value(ptr) @10100050001002D
2009-05-14 19:18:55     0 ERR 11330 COREHAND  pid        0
2009-05-14 19:18:55     0 ERR 11330 COREHAND  addr       @0
2009-05-14 19:18:55     0 ERR 11599 BTRACE   analysing LVCMem_Allocator_001
2009-05-14 19:18:55     0 ERR 11599 BTRACE   
2009-05-14 19:18:55     0 ERR 11599 BTRACE   no problems detected in LVCMem_Allocator_001
2009-05-14 19:18:55     0 ERR 11599 BTRACE   analysing LVCMem_Allocator_002
2009-05-14 19:18:55     0 ERR 11599 BTRACE   
2009-05-14 19:18:55     0 ERR 11599 BTRACE   no problems detected in LVCMem_Allocator_002
2009-05-14 19:18:55     0 ERR 11599 BTRACE   analysing LVCMem_Allocator_003
2009-05-14 19:18:55     0 ERR 11599 BTRACE   
2009-05-14 19:18:55     0 ERR 11599 BTRACE   no problems detected in LVCMem_Allocator_003
2009-05-14 19:18:55     0 ERR 11599 BTRACE   analysing LVCMem_Allocator_004
2009-05-14 19:18:55     0 ERR 11599 BTRACE   
2009-05-14 19:18:55     0 ERR 11599 BTRACE   no problems detected in LVCMem_Allocator_004
2009-05-14 19:18:56     0 ERR 12006 DBCRASH  Kernel exited without core and exit status 0x2f00
2009-05-14 19:18:56     0 ERR 12008 DBCRASH  Kernel exited due to reentered signal handler
2009-05-14 19:18:57                          ___ Stopping GMT 2009-05-14 17:18:57           7.6.05   Build 009-123-191-997

Edited by: Simon Matter on May 15, 2009 9:50 AM

Somehow the forum doesn't like my posts