Edson Carlos Ericksson Richter wrote
>
>I had exactly same problem as you. I solved avoiding a very old bug
>(since SapDB 7.4 days, AFAIK) about recursive triggers.
>
>I already reported this problem (as others did), but it's silent
>ignored. The first time I faced this problem, I have wasted hours and
>hours, changing Linux installation (from Fedora to others), tunning,
>even trying in Windows, changind hard disk (in suspect that it's a
>virtual memory failure), changing and incresing server memory (from
>unknowm 256Mb to Kingstong 1Gb), but nothing helped. To check
>if someone
>will fix (or at least comment this in Manuals or in the list) in near
>future, I've posted to the list a "how-to" crash a MaxDB server: just
>give DBA access to unwarned user, and let him create one recursive
>trigger. Nobody answered or commented.
>
>Revising every trigger on the system, I've found the problem. I had
>something like:
>
>create trigger tb_parc_upd on tb_parc for update as {
>
> update tb_parc where usage = usage +1
> where tb_parc.saldo = :old.saldo - :new.pago
>
>}
>
>(the real case is a little bit different - but concept is the same).
>
>As you can see, the above trigger will fire it self again. If
>we have a
>function "updated" (like MS SQL Server), the trigger could be
>written as:
>
>create trigger tb_parc_upd on tb_parc for update as {
>
> if updated(pago)
> update tb_parc where usage = usage +1
> where tb_parc.saldo = :old.saldo - :new.pago
>
>}
>
>where the recursiveness will be avoided. But there is none
>function like
>"updated".
>
>Well, returning to your problem, I'll suggest you double check your
>triggers and procedures. IMHO, they are the main cause for
>LVM_Allocation errors... Of course, if there is no detectable
>problem in
>them, check memory, hard disks, etc.
>
>I expect this save hours for you...
>
>Best regards,
>
>Edson Richter
>
>
>Alexey Gaidukov escreveu:
>
>> Fedora 4. Kernel 2.6.12
>>
>> Is there the way to prevent this crash? Please help me.
>>
>>
>> 2005-08-22 14:41:12 0 ERR 11330 COREHAND ABORTING due to
>signal 11
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE ----> Emergency Stack
>> Back Trace <----
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (0):0x8222bdb
>> [0xabaf0a74](0x9faa2eec,0xa4531148,0xa453103c,0x891a7d9)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (1):0x83bdad9
>> [0xabaf0a74](0x9faa2eec,0xa4531148,0xa453103c,0x891a7d9)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (3):0x82b0f8e
>> [0xabaf0ad4](0xabaf49dc,0xa4531038,0x40,0xa4531148)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (5):0x82b0b8b
>> [0xabaf0bb4](0xabaf49dc,0x22,0xabaf0ecc,0x1bb)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (7):0x82b0e7b
>> [0xabaf0bf4](0xabaf49dc,0x21,0x3,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (9):0x82b0bfd
>> [0xabaf0c34](0xabaf49dc,0x1a,0x0,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (11):0x82b0025
>> [0xabaf0c74](0xabaf49dc,0x19,0x0,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (13):0x82af4da
>> [0xabaf0dd4](0xabaf49dc,0xabaf0ecc,0x19,0x562)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (15):0x82acc91
>> [0xabaf2174](0xabaf49dc,0xabaf28cc,0x19,0x9faa5988)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (17):0x82a9c1e
>> [0xabaf2884](0xabaf49dc,0xabaf28cc,0xabaf3c2c,0xabaf28ca)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (19):0x82cfaee
>> [0xabaf3c94](0xabaf49dc,0x0,0x101,0x8d20d74)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (21):0x82ce8f3
>> [0xabaf3d34](0xabaf49dc,0x0,0x0,0xabaf3da4)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (23):0x8419023
>> [0xabaf3db4](0xabaf49dc,0x0,0x40,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (25):0x841a654
>> [0xabaf3fa4](0xabaf49dc,0xabaf4000,0xabaf414a,0xabaf412c)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (27):0x841bf83
>> [0xabaf4184](0xabaf49dc,0x0,0x0,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (29):0x8421d64
>> [0xabaf42a4](0xabaf49dc,0x0,0x0,0xabaf4338)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (31):0x841faba
>> [0xabaf4454](0xabaf49dc,0x1,0xabaf44cc,0x1)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (33):0x89abaa6
>> [0xabaf4524](0xabaf49dc,0xabaf49d1,0xabaf454a,0xabaf454b)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (35):0x89ab803
>> [0xabaf4974](0xabaf49dc,0xabaf49d1,0x1,0xb7e03950)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (37):0x8a37aa4
>> [0xabaf5f94](0x5015b460,0x5000b31c,0x8ebb0a0,0x8d20d74)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (39):0x8af50fa
>> [0xabaf5fb4](0x3281,0x3,0x8c3e993,0x8c4a27d)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (41):0x8af5049
>> [0xabaf5fe4](0x500e4320,0x0,0xa95f53a8,0x210b74)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE (43):0x210b74
>> [0xabaf5ff4](0x0,0x0,0x0,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE ----> Register
>Dump <----
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> -------------------------------
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE ds es 0x0000007b
>> 0x0000007b
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE fs gs 0x00000000
>> 0x00000033
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE trap err 0x0000000e
>> 0x00000004
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE efl ss 0x00010297
>> 0x0000007b
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE edi esi 0x00000110
>> 0x00000220
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE eax ebx 0xa4531148
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE ecx edx 0x00000006
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE esp uesp 0xabaf0a2c
>> 0xabaf0a2c
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE ebp eip 0xabaf0a74
>> 0x08222bdb
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE cs cr2 0x00000073
>> 0x2900291b
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> -------------------------------
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE cw - sw - tag
>> 0xffff037f 0xffff0020 0xffffffff
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE ipoff - cssel
>> 0x00000000 0x00000000
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE dataoff-datasel
>> 0x00000000 0x00000000
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE f00 [0xb800 0xcf4e
>> 0xc6e2 0xd251 - 0x4009]
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE f01 [0xb800 0xcf4e
>> 0xc6e2 0xd271 - 0x4009]
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE f02 [0x6823 0xa938
>> 0xf2fb 0x8ad8 - 0x3ff9]
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE f03 [0xb800 0xb63c
>> 0x6822 0xa938 - 0x4008]
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE f04 [0x0000 0x0000
>> 0x0000 0xe400 - 0x4003]
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE f05 [0x0000 0x0000
>> 0x0000 0x8af0 - 0x4011]
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE f06 [0x0000 0x0000
>> 0x7fc0 0xe4ea - 0x4018]
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE f07 [0x0000 0x0000
>> 0xbb80 0x8093 - 0x4017]
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> -------------------------------
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE ----> Module List <----
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE |.text Start
>|.text End
>> | Module File Name
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x001bb000 |
>0x001d5000
>> | /lib/ld-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x001d5000 |
>0x001d6000
>> | /lib/ld-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x001d9000 |
>0x002fd000
>> | /lib/libc-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x002fd000 |
>0x002ff000
>> | /lib/libc-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x00305000 |
>0x00307000
>> | /lib/libdl-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x00307000 |
>0x00308000
>> | /lib/libdl-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x0030b000 |
>0x0032d000
>> | /lib/libm-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x0032d000 |
>0x0032e000
>> | /lib/libm-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x00346000 |
>0x00354000
>> | /lib/libpthread-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x00354000 |
>0x00355000
>> | /lib/libpthread-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x006f2000 |
>0x006fb000
>> | /lib/libgcc_s-4.0.1-20050727.so.1
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x008e1000 |
>0x008e9000
>> | /lib/librt-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x008e9000 |
>0x008ea000
>> | /lib/librt-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x00b69000 |
>0x00c1a000
>> | /usr/lib/libstdc++.so.5.0.7
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x08048000 |
>0x08d1f000
>> | /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0x9c99b000 |
>0x9c9a4000
>> | /opt/V76_00_16/MaxDB_DEV/usr/lib/dbpinstall.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0xa0ce3000 |
>0xa0f0f000
>> | /opt/V76_00_16/MaxDB_DEV/usr/lib/liboms.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0xb7e27000 |
>0xb7e30000
>> | /lib/libnss_files-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE | 0xb7e30000 |
>0xb7e31000
>> | /lib/libnss_files-2.3.5.so
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE ----> Symbolic
>Stack Back
>> Trace <----
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 0: 0x08222bdb
>> a061exist_columnname +0x008b
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf0a74] (0x9faa2eec,0xa4531148,0xa453103c,0x891a7d9)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 1: 0x083bdad9
>> a61_search_table +0x0379
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf0a74] (0x9faa2eec,0xa4531148,0xa453103c,0x891a7d9)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 2: 0x082b0f8e
>> ak262assign_stmt +0x00ce
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf0ad4] (0xabaf49dc,0xa4531038,0x40,0xa4531148)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 3: 0x082b0b8b
>> ak262compile +0x03cb
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf0bb4] (0xabaf49dc,0x22,0xabaf0ecc,0x1bb)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 4: 0x082b0e7b
>> ak262TryCatchBlock +0x010b
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf0bf4] (0xabaf49dc,0x21,0x3,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 5: 0x082b0bfd
>> ak262compile +0x043d
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf0c34] (0xabaf49dc,0x1a,0x0,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 6: 0x082b0025
>> ak262StoreStmtAndComplile +0x04d5
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf0c74] (0xabaf49dc,0x19,0x0,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 7: 0x082af4da
>> ak262trigger_code +0x07da
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf0dd4] (0xabaf49dc,0xabaf0ecc,0x19,0x562)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 8: 0x082acc91
>> ak262create_trigger +0x09a1
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf2174] (0xabaf49dc,0xabaf28cc,0x19,0x9faa5988)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 9: 0x082a9c1e
>> a262trigger_semantic +0x036e
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf2884] (0xabaf49dc,0xabaf28cc,0xabaf3c2c,0xabaf28ca)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 10: 0x082cfaee
>> ak35call_semantik +0x064e
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf3c94] (0xabaf49dc,0x0,0x101,0x8d20d74)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 11: 0x082ce8f3
>> a35_asql_statement2 +0x0543
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf3d34] (0xabaf49dc,0x0,0x0,0xabaf3da4)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 12: 0x08419023
>> ak92not_only_execute +0x0473
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf3db4] (0xabaf49dc,0x0,0x40,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 13: 0x0841a654
>> ak92analyze_messagetype +0x07c4
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf3fa4] (0xabaf49dc,0xabaf4000,0xabaf414a,0xabaf412c)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 14: 0x0841bf83
>> a92_mode_analyzer +0x0263
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf4184] (0xabaf49dc,0x0,0x0,0x0)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 15: 0x08421d64
>> ak93one_command +0x0ea4
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf42a4] (0xabaf49dc,0x0,0x0,0xabaf4338)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 16: 0x0841faba
>> a93_user_commands +0x047a
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf4454] (0xabaf49dc,0x1,0xabaf44cc,0x1)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 17: 0x089abaa6
>> _Z7SQLTaskR20tak_all_command_globRhb +0x0086
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf4524] (0xabaf49dc,0xabaf49d1,0xabaf454a,0xabaf454b)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 18: 0x089ab803
>> _Z11Kernel_MainR13RTETask_ITask +0x0313
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf4974] (0xabaf49dc,0xabaf49d1,0x1,0xb7e03950)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 19: 0x08a37aa4
>> RTETask_TaskMain +0x0064
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf5f94] (0x5015b460,0x5000b31c,0x8ebb0a0,0x8d20d74)
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE 20: 0x08af50fa
>> _Z23en88_CallKernelTaskMainP9TASK_TYPE +0x00aa
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:12 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf5fb4] (0x3281,0x3,0x8c3e993,0x8c4a27d)
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE 21: 0x08af5049
>> en88_CallCoroutineKernelTaskMain +0x0029
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE
>> /opt/V76_00_16/MaxDB_DEV/usr/pgm/kernel
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE Frameinfo
>> [0xabaf5fe4] (0x500e4320,0x0,0xa95f53a8,0x210b74)
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE ----> End of Stack Back
>> Trace <----
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE analysing
>> LVCMem_Allocator_001
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE no problems detected in
>> LVCMem_Allocator_001
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE analysing
>> LVCMem_Allocator_002
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE
>> 2005-08-22 14:41:13 0 ERR 11599 BTRACE no problems detected in
>> LVCMem_Allocator_002
>> 2005-08-22 14:41:14 0 ERR 12006 DBCRASH Kernel exited without
>> core and exit status 0x2f00
>> 2005-08-22 14:41:14 0 ERR 12008 DBCRASH Kernel exited due to
>> reentered signal handler
>> 2005-08-22 14:41:17 ___ Stopping GMT
>> 2005-08-22 05:41:17 7.6.00 Build 016-000-000-
>> 000
>> 2005-08-22 14:42:05 --- Starting GMT
>> 2005-08-22 05:42:05 7.6.00 Build 016-000-000-
>> 000
>>
>>
>
>
>--
>Edson Carlos Ericksson Richter
>MGR Informática Ltda.
>Fones: 3347-0446 / 9259-2993
>
>
>
I don't think that Alexey has the same problem. The problem with recursive
triggers
occurs at runtime of the trigger whereas the crash above happens when the
trigger
is compiled. Besides the trace back above shows that no recursion is involved.
We are currently working on the problem of recursive triggers. The problem is
that
the stack of the task becomes overwritten by the endless recursion. We will
avoid that by a check, that ensures that enough stack is available for the next
recursion. This solution has the disadvantage that the recursion may be stopped
a
little bit too early, but that's much better than a database crash.
Besides in the meantime the 'updated' function has been implemented.
The function is available as isupdatedcolumn(<column name>).
Best Regards,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
