Kernel crash with a query

Mon, 25 Sep 2006 01:53:46 -0700 

Turbo Delphi 2006
MaxDB v 7.6.00.12

Good morning,
When testing the following query I realised it made my DB to stop unexpectedly (General error;800 Implicit SERVERDB restart (connection aborted) 

SELECT A.* FROM
   (SELECT IDTIERS,LTRIM(VALUE(NOM,'') &' '& VALUE(PRENOM,'') &
       CASE
           WHEN CIV IS NULL THEN ''
           WHEN CIV IS NOT NULL THEN ' (' & VALUE(CIV,'') & ')'
       END) AS TITRE,
       ADRESSE, CODEPOSTAL, VILLE, LBLPAYS, CAT.LIBELLE AS CATEGORIE, TEL,
       T.IDTYPETIERS AS TTIERS
       FROM DEV.TIERSVIEW AS T
LEFT JOIN DEV.TIERS_CATEGORIES AS CAT ON CAT.IDTIERS_CATEGORIE=T.IDTIERS_CATEGORIE 
       WHERE T.ESTTEMPORAIRE=FALSE ) AS A
AS I can't see any reason to this here his a trace from the Database Error File : 

2006-09-25 10:46:42       0x16 ERR 11330 COREHAND ABORTING due to signal 11
2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ----> Emergency Stack Back Trace <---- 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (0):0xb7e0b88c [0xb0038460](0x5c,0x5c,0x1000000,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (1):0x8229efc [0xb0038460](0x5c,0x5c,0x1000000,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (3):0x822a3cc [0xb0038490](0x1000000,0xb0038538,0x20202020,0x8e96090) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (5):0x83dabaa [0xb00384b0](0x1000000,0xb0038538,0xb0038eac,0x20202020) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (7):0x83db1e0 [0xb00385f0](0xb00409f8,0xb0038ea8,0xb00386d4,0x8f491a0) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (9):0x83dbb92 [0xb0038630](0xb00409f8,0xb0038ea8,0x6,0xb00386d4) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (11):0x83dc06a [0xb0038680](0xb00409f8,0xb0038ea8,0x3,0xb00386d4) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (13):0x8417981 [0xb0038730](0xb00409f8,0xb0038ea8,0x2,0x7) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (15):0x841ba18 [0xb0038a70](0xb00409f8,0xb0038ea8,0x1,0x0) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (17):0x841da79 [0xb0038ae0](0xb00409f8,0xb0038ea8,0xb0038bc8,0xb0038e20) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (19):0x8411ff5 [0xb0038bf0](0xb00409f8,0xb0038ea8,0xb0038e20,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (21):0x8419593 [0xb0038dc0](0xb00409f8,0xb0038ea8,0xb0038e20,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (23):0x8419a1c [0xb0038e60](0xb00409f8,0x1,0xb0038ea8,0xb0038ea7) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (25):0x82deaf1 [0xb003fca0](0xb00409f8,0x1,0x9,0x6) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (27):0x82df967 [0xb003fd20](0xb00409f8,0x0,0x0,0xe96090) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (29):0x84403ef [0xb003fdb0](0xb00409f8,0x0,0x40,0x8a08465) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (31):0x8441f68 [0xb003ffc0](0xb00409f8,0xb004001c,0xb0040166,0xb0040148) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (33):0x844293d [0xb00401a0](0xb00409f8,0x0,0x0,0x0) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (35):0x8443c38 [0xb00402c0](0xb00409f8,0x0,0x0,0xb0040354) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (37):0x84471d6 [0xb0040470](0xb00409f8,0x1,0xb00404f8,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (39):0x89dbbf6 [0xb0040550](0xb00409f8,0xb00409ee,0xb004056f,0x0) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (41):0x89dbf68 [0xb00409a0](0x5005d9d8,0x2,0xb00409f8,0xb7be8b40) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (43):0x8a702f6 [0xb0041fa0](0x5005d9d8,0x5000372c,0xb7cc0448,0x8e96090) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (45):0x8b390e9 [0xb0041fc0](0x3281,0x3,0x8cfd7c2,0x8d08fe8) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE (47):0xb7dd7e54 [0xb0041ff0](0x8af0ce2,0x0,0x0,0x0) 
2006-09-25 10:46:42       0x16 ERR 11599 BTRACE   ----> Register Dump <----
2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ------------------------------- 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ds es 0x0000007b 0x0000007b 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE fs gs 0x00000000 0x00000033 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE trap err 0x0000000e 0x00000004 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE efl ss 0x00010202 0x0000007b 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE edi esi 0xb0038538 0x01000000 
2006-09-25 10:46:42       0x16 ERR 11599 BTRACE   eax  ebx  0x01000001
2006-09-25 10:46:42       0x16 ERR 11599 BTRACE   ecx  edx  0x00000007
2006-09-25 10:46:42 0x16 ERR 11599 BTRACE esp uesp 0xb0037e24 0xb0037e24 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ebp eip 0xb0038460 0xb7e0b88c 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE cs cr2 0x00000073 0x01000000 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ------------------------------- 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE cw - sw - tag 0xffff037f 0xffff0120 0xffffffff 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ipoff - cssel 0x085c15d9 0x01c90073 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE dataoff-datasel 0x08f62908 0x0000007b 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE f00 [0x0000 0x0000 0x0000 0x0000 - 0x0000] 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE f01 [0x0000 0x0000 0x0000 0x0000 - 0x0000] 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE f02 [0x0000 0x0000 0x0000 0x8000 - 0x3fff] 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE f03 [0xa074 0x89d8 0xd89d 0x9d89 - 0x3ffb] 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE f04 [0x0000 0x0000 0x0000 0xc800 - 0x4003] 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE f05 [0x0000 0x0000 0x0000 0x9800 - 0x4003] 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE f06 [0x0000 0x0000 0x0000 0x92c0 - 0x400d] 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE f07 [0x0000 0x0000 0x0000 0xd0e4 - 0x400c] 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ------------------------------- 
2006-09-25 10:46:42       0x16 ERR 11599 BTRACE   ----> Module List <----
2006-09-25 10:46:42 0x16 ERR 11599 BTRACE |.text Start |.text End | Module File Name 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0x08048000 | 0x08d2c000 | /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xad2ba000 | 0xad531000 | /U01/sdb/7500/lib/liboms.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7c8b000 | 0xb7c94000 | /lib/libnss_files-2.3.4.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7da1000 | 0xb7ec4000 | /lib/tls/libc-2.3.4.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7ec5000 | 0xb7ec6000 | /lib/tls/libc-2.3.4.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7ecc000 | 0xb7ed4000 | /lib/libgcc_s-3.4.3.so.1 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7ed5000 | 0xb7ef6000 | /lib/tls/libm-2.3.4.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7ef8000 | 0xb7fae000 | /usr/lib/libstdc++.so.5.0.6 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7fb8000 | 0xb7fc0000 | /lib/tls/librt-2.3.4.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7fcc000 | 0xb7fce000 | /lib/libdl-2.3.4.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7fd0000 | 0xb7fde000 | /lib/tls/libpthread-0.10.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb7fec000 | 0xb8000000 | /lib/ld-2.3.4.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE | 0xb8000000 | 0xb8001000 | /lib/ld-2.3.4.so 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ----> Symbolic Stack Back Trace <---- 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Warning - no ELF string section defined. 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 0: 0x00000000b7e0b88c <symbol lookup failed> 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038460] (0x5c,0x5c,0x1000000,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 1: 0x08229efc a061copy_colinfo +0x005c 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038460] (0x5c,0x5c,0x1000000,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 2: 0x0822a3cc a061colinfo_to_var +0x002c 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038490] (0x1000000,0xb0038538,0x20202020,0x8e96090) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 3: 0x083dabaa ak61all_columns +0x027a 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb00384b0] (0x1000000,0xb0038538,0xb0038eac,0x20202020) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 4: 0x083db1e0 ak61one_star_table_check +0x00d0 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb00385f0] (0xb00409f8,0xb0038ea8,0xb00386d4,0x8f491a0) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 5: 0x083dbb92 ak61select_column_check +0x0592 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038630] (0xb00409f8,0xb0038ea8,0x6,0xb00386d4) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 6: 0x083dc06a a61_check_val_params +0x015a 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038680] (0xb00409f8,0xb0038ea8,0x3,0xb00386d4) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 7: 0x08417981 a660_query_execute +0x0861 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038730] (0xb00409f8,0xb0038ea8,0x2,0x7) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 8: 0x0841ba18 ak661a_norm_sub +0x02a8 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038a70] (0xb00409f8,0xb0038ea8,0x1,0x0) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 9: 0x0841da79 a661a_subquery +0x0259 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038ae0] (0xb00409f8,0xb0038ea8,0xb0038bc8,0xb0038e20) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 10: 0x08411ff5 ak660subquery +0x00a5 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038bf0] (0xb00409f8,0xb0038ea8,0xb0038e20,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 11: 0x08419593 a660select +0x0273 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038dc0] (0xb00409f8,0xb0038ea8,0xb0038e20,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 12: 0x08419a1c a660_select +0x022c 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0038e60] (0xb00409f8,0x1,0xb0038ea8,0xb0038ea7) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 13: 0x082deaf1 ak35call_semantik +0x0371 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb003fca0] (0xb00409f8,0x1,0x9,0x6) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 14: 0x082df967 a35_asql_statement2 +0x0827 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb003fd20] (0xb00409f8,0x0,0x0,0xe96090) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 15: 0x084403ef ak92not_only_execute +0x04af 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb003fdb0] (0xb00409f8,0x0,0x40,0x8a08465) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 16: 0x08441f68 ak92analyze_messagetype +0x0a98 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb003ffc0] (0xb00409f8,0xb004001c,0xb0040166,0xb0040148) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 17: 0x0844293d a92_mode_analyzer +0x032d 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb00401a0] (0xb00409f8,0x0,0x0,0x0) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 18: 0x08443c38 ak93one_command +0x0568 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb00402c0] (0xb00409f8,0x0,0x0,0xb0040354) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 19: 0x084471d6 a93_user_commands +0x0566 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0040470] (0xb00409f8,0x1,0xb00404f8,0x1) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 20: 0x089dbbf6 _Z7SQLTaskR20tak_all_command_globRhb +0x0086 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0040550] (0xb00409f8,0xb00409ee,0xb004056f,0x0) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 21: 0x089dbf68 _Z11Kernel_MainR13RTETask_ITask +0x02c8 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb00409a0] (0x5005d9d8,0x2,0xb00409f8,0xb7be8b40) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 22: 0x08a702f6 RTETask_TaskMain +0x0056 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0041fa0] (0x5005d9d8,0x5000372c,0xb7cc0448,0x8e96090) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 23: 0x08b390e9 en88_CallCoroutineKernelTaskMain +0x0099 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE /U01/sdb/7500/pgm/kernel 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE Frameinfo [0xb0041fc0] (0x3281,0x3,0x8cfd7c2,0x8d08fe8) 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE ----> End of Stack Back Trace <---- 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE analysing LVCMem_Allocator_001 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE no problems detected in LVCMem_Allocator_001 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE analysing LVCMem_Allocator_002 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE 2006-09-25 10:46:42 0x16 ERR 11599 BTRACE no problems detected in LVCMem_Allocator_002 2006-09-25 10:46:43 0x1 ERR 12006 DBCRASH Kernel exited without core and exit status 0x2f00 2006-09-25 10:46:43 0x1 ERR 12008 DBCRASH Kernel exited due to reentered signal handler 2006-09-25 10:46:43 28 MsgOutpu ___ Stopping GMT 2006-09-25 08:46:43 7.6.00 Build 012-121-102-632 2006-09-25 10:47:23 27 MsgOutpu --- Starting GMT 2006-09-25 08:47:23 7.6.00 Build 012-121-102-632 2006-09-25 10:47:23 0x1 ERR 11881 DIAGHIST RTEDiag_MakeCrashHist 'RTEDiag_CreateDirectory' OS error: [[2] No such file or directory, /u01/data/wrk/EVEREST/DIAGHISTOR] -------------------------------------------- current write position ---------------- =========================================== end of write cycle =================== 


Could you please help me to understand why ?

Kind regards
Xavier

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to