Hi Alexander, Here is a the SELECT -Statement on which den view should be based:
SELECT BUCHUNG.BUCHID, BUCHUNG.ANZAHL, BUCHUNG.NID, BUCHUNG.CATERINGID, BUCHUNG.ERGAENZUNGSTEXT, BUCHUNG.KOMMENTAR, BUCHUNG.CATERINGBEMERKUNG, BUCHUNG.CATERINGKOMMENTAR, BUCHUNG.CATERINGSTATUS, SERVICE.NAME AS CATERINGNAME, LOCATION_KUNDE.LOGENNUMMER, NUTZER.VORNAME&' '&NUTZER.NAME AS NAME, TAGESLOGENDATEN.TLDID, BUCHUNG_TAGESLOGE.BUCHID AS BUCHIDTL, BUCHUNGANSPRECHPARTNER.ANSPRECHPARTNER AS BUCHUNGANSPRECHPARTNER, KINDERMENUE.ANZAHL AS KINDERANZAHL, HHT_BUCHUNG.BUCHUNGSNUMMER, EVENTPREISE.PREIS AS EVENTPREIS, BRAIN.BCATERING, BRAIN.ZEIT, SPLIT_CATERING.ANZAHL_CATERING, SPLIT_CATERING.ANZAHL_GP, REDUZIERTE_CATERINGPREISE.PROZENTSATZ, CATERINGBEGINN.BEGINN AS CATBEGINN, SERVICEKRAFT_ANZAHL.ANZAHL_SK, SERVICEKRAFT_NAME.NAME_SK, SERVICEKRAFT_NAME.NAME_VERTRETUNG, SUSHIBUCHUNG.UHRZEITBEGINN, CATERING_ANRUFER.ANGERUFEN, CATERINGRECHNUNG.ANREDE, CATERINGRECHNUNG.VORNAME, CATERINGRECHNUNG.NAME, CATERINGRECHNUNG.FIRMA, CATERINGRECHNUNG.ABTEILUNG, CATERINGRECHNUNG.STRASSE, CATERINGRECHNUNG.HAUSNUMMER, CATERINGRECHNUNG.PLZ, CATERINGRECHNUNG.ORT, CATERINGRECHNUNG.LAND, CATERINGANSPRECHPARTNER.ANSPRECHPARTNER AS CATERINGANSPRECHPARTNER, CATERINGPREISE_EVENT.PREIS AS LOGENCATPREIS, CATERINGPREISE.PREIS AS CATERINGPREIS FROM BUCHUNG, SERVICE, LOCATION_KUNDE, NUTZER, TAGESLOGENDATEN, BUCHUNG_TAGESLOGE, BUCHUNGANSPRECHPARTNER, KINDERMENUE, HHT_BUCHUNG, EVENTPREISE, BRAIN, SPLIT_CATERING, REDUZIERTE_CATERINGPREISE, CATERINGBEGINN, SERVICEKRAFT_ANZAHL, SERVICEKRAFT_NAME, SUSHIBUCHUNG, CATERING_ANRUFER, CATERINGRECHNUNG, CATERINGANSPRECHPARTNER, CATERINGPREISE_EVENT, CATERINGPREISE, BLKZ WHERE BUCHUNG.CATERINGID=SERVICE.SERVICEID(+) AND BUCHUNG.BUCHID=BLKZ.BUCHID AND BLKZ.LKID=LOCATION_KUNDE.LKID AND NUTZER.NID=BUCHUNG.NID AND TAGESLOGENDATEN.LKID(+)=BLKZ.LKID AND TAGESLOGENDATEN.EVENTID(+)=BUCHUNG.EVENTID AND BUCHUNG_TAGESLOGE.TLDID=TAGESLOGENDATEN.TLDID(+) AND BUCHUNG.BUCHID=BUCHUNG_TAGESLOGE.BUCHID(+) AND BUCHUNGANSPRECHPARTNER.BUCHID(+)=BUCHUNG.BUCHID AND KINDERMENUE.BUCHID(+)=BUCHUNG.BUCHID AND HHT_BUCHUNG.BUCHID(+)=BUCHUNG.BUCHID AND EVENTPREISE.LKID(+)=BLKZ.LKID AND EVENTPREISE.EVENTID(+)=BUCHUNG.EVENTID AND BRAIN.BUCHID(+)=BUCHUNG.BUCHID AND SPLIT_CATERING.BUCHID(+)=BUCHUNG.BUCHID AND REDUZIERTE_CATERINGPREISE.LKID(+)=BLKZ.LKID AND REDUZIERTE_CATERINGPREISE.EVENTID(+)=BUCHUNG.EVENTID AND CATERINGBEGINN.BUCHID(+)=BUCHUNG.BUCHID AND SERVICEKRAFT_ANZAHL.LKID(+)=BLKZ.LKID AND SERVICEKRAFT_ANZAHL.EVENTID(+)=BUCHUNG.EVENTID AND SERVICEKRAFT_NAME.LKID(+)=BLKZ.LKID AND SERVICEKRAFT_NAME.EVENTID(+)=BUCHUNG.EVENTID AND SUSHIBUCHUNG.BUCHID(+)=BUCHUNG.BUCHID AND CATERING_ANRUFER.LKID(+)=BLKZ.LKID AND CATERING_ANRUFER.EVENTID(+)=BUCHUNG.EVENTID AND CATERINGRECHNUNG.LKID(+)=BLKZ.LKID AND CATERINGRECHNUNG.EVENTID(+)=BUCHUNG.EVENTID AND CATERINGANSPRECHPARTNER.BUCHID(+)=BUCHUNG.BUCHID AND CATERINGPREISE_EVENT.LKID(+)=BLKZ.LKID AND CATERINGPREISE_EVENT.EVENTID(+)=BUCHUNG.EVENTID AND CATERINGPREISE.EVENTID(+)=BUCHUNG.EVENTID AND CATERINGPREISE.SERVICEID(+)=BUCHUNG.CATERINGID AND (BUCHUNG.GESAMTSTATUS > 0 AND (BUCHUNG.GESAMTSTATUS <= 10 OR BUCHUNG.GESAMTSTATUS = 100)) Is there an easy way of how to get the definition of all involved tables without having to copy all of them manually? Thanks in advance, jan Am 27.04.2007 13:19 Uhr schrieb "Schroeder, Alexander" unter <[EMAIL PROTECTED]>: > Hello Jan, > > unfortunately, the attached sql script did not survive the mailing list > processing, so would you mind > putting it directly into the text? Also of course we would need an info on the > used version of MaxDB, > and the definitions of the tables that participate in the view statement that > crash the database > server. > > What you see in the knldiag is a stack backtrace of the database kernel with > the > position of the crash ... > > Regards > Alexander Schröder > MaxDB & liveCache > SAP AG > www.sap.com > > Sitz der Gesellschaft/Registered Office: Walldorf, Germany > Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai Agassi, > Léo Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke > Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso > Plattner > Registergericht/Commercial Register Mannheim No HRB 350269 > > Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige > vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich > erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine > Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. > Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen > Dank. > > This e-mail may contain trade secrets or privileged, undisclosed, or otherwise > confidential information. If you have received this e-mail in error, you are > hereby notified that any review, copying, or distribution of it is strictly > prohibited. Please inform us immediately and destroy the original transmittal. > Thank you for your cooperation. > -----Original Message----- > From: Jan-Hendrik Lendholt [mailto:[EMAIL PROTECTED] > Sent: Freitag, 27. April 2007 11:08 > To: maxdb@lists.mysql.com > Subject: MaxDB Crashes on complex statements > > Hi Folks, > > Long time ago I wrote to this list. > > We have a database with about 180 tables. > > Now we want to join some small tables to a view. > > The View-Statement is prettty complex (see attached file script.sql). > > If I execute this script SQL-Studio tells me: General error; 800 implicit > SERVERDB restart. > > The knldiag.err says something I really don't understand. Maybe some of you > guys may help me. > > We're running a debian etch Server. > > > Knldiag.err: > ------------ > > 2007-04-27 10:03:34 19554 ERR 11881 DIAGHIST RTEDiag_MakeCrashHist > 'RTEDiag_CreateDirectory' OS error: [[2] No such file or directory, > /var/opt/sapdb/indep_data/wrk/EV] > 2007-04-27 10:41:02 0 ERR 11330 COREHAND ABORTING due to signal 11 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ----> Emergency Stack Back > Trace <---- > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (0):0x84e2a8f > [0x9b8a1ba8](0x917968c8,0x9395b170,0x16,0x8f21b50) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (1):0x84e260a > [0x9b8a1ba8](0x917968c8,0x9395b170,0x16,0x8f21b50) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (3):0x84e260a > [0x9b8a1c28](0x917768c8,0x9395b170,0x9b8a1c88,0x8bd390f) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (5):0x84e260a > [0x9b8a1ca8](0x917629a8,0x9395b170,0x916e7f68,0x6c) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (7):0x84e260a > [0x9b8a1d28](0x91750028,0x9395b170,0x2,0x9b8a1d48) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (9):0x84e260a > [0x9b8a1da8](0x94930f88,0x9395b170,0x1,0x9b8a1dc8) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (11):0x84e260a > [0x9b8a1e28](0x916b79a8,0x9395b170,0x1,0x9b8a1ea4) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (13):0x84e260a > [0x9b8a1ea8](0x916a5028,0x9395b170,0x9b8a1ee8,0x8b16924) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (15):0x84e260a > [0x9b8a1f28](0x918008c0,0x9395b170,0x0,0x8b2e744) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (17):0x84e260a > [0x9b8a1fa8](0x91703248,0x9395b170,0xffff,0xffffff7f) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (19):0x84e260a > [0x9b8a2028](0x916f08c8,0x9395b170,0x19000007,0x0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (21):0x84e260a > [0x9b8a20a8](0x917409a8,0x9395b170,0x9b8a20d8,0x8b272f9) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (23):0x84e260a > [0x9b8a2128](0x9172e028,0x9395b170,0x0,0x0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (25):0x84e260a > [0x9b8a21a8](0x917de8c0,0x9395b170,0x9b8a21d8,0x84e0694) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (27):0x84e260a > [0x9b8a2228](0x91721400,0x9395b170,0x9b8a2258,0x84e0694) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (29):0x84e260a > [0x9b8a22a8](0x916e1248,0x9395b170,0x9b8a22d8,0x84e0694) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (31):0x84e260a > [0x9b8a2328](0x916ce8c8,0x9395b170,0x9b8a2358,0x84e0694) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (33):0x84e0cb8 > [0x9b8a23a8](0x93967b18,0x9395b170,0x9b8a23d8,0x84e07e0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (35):0x84c6b97 > [0x9b8a23d8](0x93967b18,0x9b8a2458,0x9b8a2480,0x9b8a245c) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (37):0x8494fb9 > [0x9b8a24f8](0x9b8afd60,0x9b8a8500,0x9b8a2620,0x9b8a4c70) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (39):0x84981dd > [0x9b8a25a8](0x9b8afd60,0x9b8a8500,0x9b8a2620,0x9b8a4e20) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (41):0x83a6661 > [0x9b8a4aa8](0x9b8afd60,0x9b8a8500,0x9b8a4c70,0x9b8a4e20) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (43):0x83a798b > [0x9b8a4d38](0x9b8afd60,0x9b8a8500,0x9b8a74f0,0x9b8af4b4) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (45):0x839a215 > [0x9b8a4f88](0x9b8afd60,0x9b8a8500,0x9b8a74f0,0x9b8a73a0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (47):0x839b447 > [0x9b8a74a8](0x9b8afd60,0x9b8a8500,0x9b8af4b4,0x9b8a74f0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (49):0x8476872 > [0x9b8af338](0x9b8afd60,0x9b8af4b0,0x1,0xc) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (51):0x8476eb5 > [0x9b8af518](0x9b8afd60,0x0,0x0,0x0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (53):0x8478282 > [0x9b8af628](0x9b8afd60,0x0,0x0,0x9b8af6bc) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (55):0x847b7d6 > [0x9b8af7d8](0x9b8afd60,0x1,0x9b8af860,0x1) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (57):0x8a89396 > [0x9b8af8b8](0x9b8afd60,0x9b8afd56,0x9b8af8d7,0xb7c7837c) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (59):0x8a89708 > [0x9b8afd08](0x500b3270,0x2,0x9b8afd60,0x9398f340) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (61):0x8b20757 > [0x9b8b13c8](0x500b3270,0x9b8b1b80,0x5001b82c,0x8f21b50) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (63):0x8bf245e > [0x9b8b13e8](0x3281,0x3,0x8d71dee,0x8d7e3ac) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (65):0x8b803fa > [0x9b8b1418](0x5006d91c,0x3,0x8d71dee,0x8d71e51) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE (67):0xb7fa90bd > [0x9b8b1448](0xb7c93d18,0x9b8b1480,0x9b8b1480,0x9b8b1480) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ----> Register Dump <---- > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ------------------------------- > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ds es 0xc010007b 0xc010007b > 2007-04-27 10:41:02 0 ERR 11599 BTRACE fs gs 0x00000000 0x00000033 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE trap err 0x0000000e 0x00000006 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE efl ss 0x00010282 0x0000007b > 2007-04-27 10:41:02 0 ERR 11599 BTRACE edi esi 0x917968c8 0x00000000 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE eax ebx 0x00000024 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ecx edx 0x917a08b0 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE esp uesp 0x9b8a1b30 0x9b8a1b30 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ebp eip 0x9b8a1ba8 0x084e2a8f > 2007-04-27 10:41:02 0 ERR 11599 BTRACE cs cr2 0x00000073 0x00000000 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ------------------------------- > 2007-04-27 10:41:02 0 ERR 11599 BTRACE cw - sw - tag 0xffff037f > 0xffff0020 0xffffffff > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ipoff - cssel 0x085fab41 > 0x017c0073 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE dataoff-datasel 0x08ff08d8 > 0x0000007b > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f00 [0x0000 0x0000 0x0000 > 0x8000 - 0x3fff] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f01 [0x0000 0x0000 0x0000 > 0x8400 - 0x4004] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f02 [0x0000 0x0000 0x0000 > 0x8000 - 0x3ffe] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f03 [0xa000 0x9f9f 0x9f9f > 0xdf9f - 0x4002] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f04 [0x0000 0x0000 0x0000 > 0x9000 - 0x4003] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f05 [0x0000 0x0000 0x0000 > 0xa680 - 0x4009] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f06 [0x0000 0x0000 0xbc80 > 0xc078 - 0x4017] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f07 [0x0000 0x0000 0x5580 > 0x891a - 0x4017] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f06 [0x0000 0x0000 0xbc80 > 0xc078 - 0x4017] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE f07 [0x0000 0x0000 0x5580 > 0x891a - 0x4017] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ------------------------------- > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ----> Module List <---- > 2007-04-27 10:41:02 0 ERR 11599 BTRACE |.text Start |.text End | > Module File Name > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0x08048000 | 0x08da4000 | > /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0x92817000 | 0x92a6b000 | > /opt/sdb/7600/lib/liboms.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7341000 | 0xb7349000 | > /lib/tls/libnss_nis-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb734b000 | 0xb735d000 | > /lib/tls/libnsl-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7361000 | 0xb7368000 | > /lib/tls/libnss_compat-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7c6c000 | 0xb7c75000 | > /lib/tls/libnss_files-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7d7b000 | 0xb7ea3000 | > /lib/tls/libc-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7ea3000 | 0xb7ea8000 | > /lib/tls/libc-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7ead000 | 0xb7eb7000 | > /lib/libgcc_s.so.1 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7eb8000 | 0xb7edb000 | > /lib/tls/libm-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7edd000 | 0xb7f8d000 | > /usr/lib/libstdc++.so.5.0.7 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7f97000 | 0xb7f9d000 | > /lib/tls/librt-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7f9f000 | 0xb7fa1000 | > /lib/tls/libdl-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7fa4000 | 0xb7fb2000 | > /lib/tls/libpthread-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7fbd000 | 0xb7fbe000 | > [vdso] > 2007-04-27 10:41:02 0 ERR 11599 BTRACE | 0xb7fbe000 | 0xb7fd3000 | > /lib/ld-2.3.6.so > 2007-04-27 10:41:02 0 ERR 11599 BTRACE > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ----> Symbolic Stack Back Trace > <---- > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 0: 0x084e2a8f > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x055f > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1ba8] > (0x917968c8,0x9395b170,0x16,0x8f21b50) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 1: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1ba8] > (0x917968c8,0x9395b170,0x16,0x8f21b50) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 2: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1c28] > (0x917768c8,0x9395b170,0x9b8a1c88,0x8bd390f) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 3: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1ca8] > (0x917629a8,0x9395b170,0x916e7f68,0x6c) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 4: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1d28] > (0x91750028,0x9395b170,0x2,0x9b8a1d48) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 5: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1da8] > (0x94930f88,0x9395b170,0x1,0x9b8a1dc8) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 6: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1e28] > (0x916b79a8,0x9395b170,0x1,0x9b8a1ea4) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 7: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1ea8] > (0x916a5028,0x9395b170,0x9b8a1ee8,0x8b16924) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 8: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1f28] > (0x918008c0,0x9395b170,0x0,0x8b2e744) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 9: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a1fa8] > (0x91703248,0x9395b170,0xffff,0xffffff7f) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 10: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a2028] > (0x916f08c8,0x9395b170,0x19000007,0x0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 11: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a20a8] > (0x917409a8,0x9395b170,0x9b8a20d8,0x8b272f9) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 12: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a2128] > (0x9172e028,0x9395b170,0x0,0x0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a2128] > (0x9172e028,0x9395b170,0x0,0x0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 13: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a21a8] > (0x917de8c0,0x9395b170,0x9b8a21d8,0x84e0694) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 14: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a2228] > (0x91721400,0x9395b170,0x9b8a2258,0x84e0694) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 15: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a22a8] > (0x916e1248,0x9395b170,0x9b8a22d8,0x84e0694) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 16: 0x084e260a > _ZN18Join_JoinOperator24nextEPP9tgg00_Rec +0x00da > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a2328] > (0x916ce8c8,0x9395b170,0x9b8a2358,0x84e0694) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 17: 0x084e0cb8 > _ZN18Join_JoinOperator24NextERP9tgg00_Rec +0x0038 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a23a8] > (0x93967b18,0x9395b170,0x9b8a23d8,0x84e07e0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 18: 0x084c6b97 > a686_create_join_result +0x0907 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a23d8] > (0x93967b18,0x9b8a2458,0x9b8a2480,0x9b8a245c) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 19: 0x08494fb9 > a682_execute_join_operator +0x0369 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a24f8] > (0x9b8afd60,0x9b8a8500,0x9b8a2620,0x9b8a4c70) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 20: 0x084981dd > a682_only_ex_join +0x023d > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a25a8] > (0x9b8afd60,0x9b8a8500,0x9b8a2620,0x9b8a4e20) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 21: 0x083a6661 > a505most_execute +0x0d11 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a4aa8] > (0x9b8afd60,0x9b8a8500,0x9b8a4c70,0x9b8a4e20) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 22: 0x083a798b > a505loop_most_execute +0x037b > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a4d38] > (0x9b8afd60,0x9b8a8500,0x9b8a74f0,0x9b8af4b4) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 23: 0x0839a215 > a501exec_with_change_rec +0x0645 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a4f88] > (0x9b8afd60,0x9b8a8500,0x9b8a74f0,0x9b8a73a0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 24: 0x0839b447 a501execute > +0x0697 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8a74a8] > (0x9b8afd60,0x9b8a8500,0x9b8af4b4,0x9b8a74f0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 25: 0x08476872 > ak92analyze_messagetype +0x0b72 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8af338] > (0x9b8afd60,0x9b8af4b0,0x1,0xc) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 26: 0x08476eb5 > a92_mode_analyzer +0x00a5 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8af518] > (0x9b8afd60,0x0,0x0,0x0) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 27: 0x08478282 > ak93one_command +0x05b2 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8af628] > (0x9b8afd60,0x0,0x0,0x9b8af6bc) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 28: 0x0847b7d6 > a93_user_commands +0x0566 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8af7d8] > (0x9b8afd60,0x1,0x9b8af860,0x1) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 29: 0x08a89396 > _Z7SQLTaskR20tak_all_command_globRhb +0x0086 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8af8b8] > (0x9b8afd60,0x9b8afd56,0x9b8af8d7,0xb7c7837c) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 30: 0x08a89708 > _Z11Kernel_MainR13RTETask_ITask +0x02c8 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8afd08] > (0x500b3270,0x2,0x9b8afd60,0x9398f340) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 31: 0x08b20757 > RTETask_TaskMain +0x0047 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8b13c8] > (0x500b3270,0x9b8b1b80,0x5001b82c,0x8f21b50) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE 32: 0x08bf245e > en88_RunPthreadTask +0x009e > 2007-04-27 10:41:02 0 ERR 11599 BTRACE /opt/sdb/7600/pgm/kernel > 2007-04-27 10:41:02 0 ERR 11599 BTRACE Frameinfo [0x9b8b13e8] > (0x3281,0x3,0x8d71dee,0x8d7e3ac) > 2007-04-27 10:41:02 0 ERR 11599 BTRACE ----> End of Stack Back Trace > <---- > 2007-04-27 10:41:02 0 ERR 11330 COREHAND dump of siginfo content: > 2007-04-27 10:41:02 0 ERR 11330 COREHAND signal 11 (SIGSEGV) > 2007-04-27 10:41:02 0 ERR 11330 COREHAND code 1 > (ILL_ILLOPC:illegal opcode) > 2007-04-27 10:41:02 0 ERR 11330 COREHAND errno 0 > 2007-04-27 10:41:02 0 ERR 11330 COREHAND value(int) 0 > 2007-04-27 10:41:02 0 ERR 11330 COREHAND value(ptr) @0 > 2007-04-27 10:41:02 0 ERR 11330 COREHAND pid 0 > 2007-04-27 10:41:02 0 ERR 11330 COREHAND addr @0 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE analysing LVCMem_Allocator_001 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE > 2007-04-27 10:41:02 0 ERR 11599 BTRACE no problems detected in > LVCMem_Allocator_001 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE analysing LVCMem_Allocator_002 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE > 2007-04-27 10:41:02 0 ERR 11599 BTRACE no problems detected in > LVCMem_Allocator_002 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE analysing LVCMem_Allocator_003 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE > 2007-04-27 10:41:02 0 ERR 11599 BTRACE no problems detected in > LVCMem_Allocator_003 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE analysing LVCMem_Allocator_004 > 2007-04-27 10:41:02 0 ERR 11599 BTRACE > 2007-04-27 10:41:02 0 ERR 11599 BTRACE no problems detected in > LVCMem_Allocator_004 > 2007-04-27 10:41:03 0 ERR 12006 DBCRASH Kernel exited without core and > exit status 0x2f00 > 2007-04-27 10:41:03 0 ERR 12008 DBCRASH Kernel exited due to reentered > signal handler > 2007-04-27 10:41:03 ___ Stopping GMT 2007-04-27 > 08:41:03 7.6.00 Build 034-121-134-685 > 2007-04-27 10:41:25 --- Starting GMT 2007-04-27 > 08:41:25 7.6.00 Build 034-121-134-685 > 2007-04-27 10:41:25 22392 ERR 11881 DIAGHIST RTEDiag_MakeCrashHist > 'RTEDiag_CreateDirectory' OS error: [[2] No such file or directory, > /var/opt/sapdb/indep_data/wrk/EV] > > > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]