Hi, the error is corrected also in relase 7.5.01
regards, Martin > -----Urspr�ngliche Nachricht----- > Von: Filip Sergeys [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 22. April 2004 10:44 > An: '[EMAIL PROTECTED]' > Betreff: Re: AW: discrepancy between backup history and db_restartinfo > > > Hi, > > What are the plans with version 7.5.00.09? Is this version going to be > released? Is there a timeframe? Or is it a development > version that will > flow into 7.5.01? > > Regards, > > Filip > > > > On Tue, 2004-04-20 at 16:07, Brunzema, Martin wrote: > > Hi Filip, > > > > please send your questions/answers to the mailing list, because > > other people may have the same problems. > > > > The error you found is solved with 7.5.00.09. See > > > http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1127078 > > > > As far as I know, a cancellation of the recovery is done > automatically > > when you execute a util_release. > > > > regards, Martin > > > > > > > > > -----Urspr�ngliche Nachricht----- > > > Von: Filip Sergeys [mailto:[EMAIL PROTECTED] > > > Gesendet: Dienstag, 20. April 2004 14:32 > > > An: Brunzema, Martin > > > Betreff: Re: AW: discrepancy between backup history and > db_restartinfo > > > > > > > > > Hi Martin, > > > > > > Ok, now I understand why there is a difference; the database just > > > stopped and didn't save the savepoint. But why did the > database just > > > stop when doing util_release? > > > I have the output of knldiag.err attached at the end. > > > Importing the fullbackup works, util_release does not crash the > > > database, recovering the incremental works too, it is > after importing > > > the logbackups and then issueing an util_release that the > > > database goes > > > kaboom. > > > > > > Can anybody see what is wrong and how I can prevent it > from happening > > > again? > > > > > > Thanx, > > > > > > Filip > > > > > > > > > -------------------------------------------------------------- > > > ------------------ > > > Date Time TID Typ MsgID Label Message-Text > > > -------------------------------------------------------------- > > > ------------------ > > > 2004-04-20 13:51:27 --- Starting GMT > > > 2004-04-20 > > > 11:51:27 7.5.0 Build 008-121-061-548 > > > 2004-04-20 14:13:45 24220 ERR 0 SAPDBErr Assertion of state > > > Log_Savepoint::CreateOpenTransFile: open redo trans found failed! > > > 2004-04-20 14:13:45 24220 ERR 11196 DBCRASH vabort:Emergency > > > Shutdown, > > > Log_Savepoint.cpp: 802 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE ----> Emergency > > > Stack Back > > > Trace <---- > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (0):0x86526f2 > > > [0x45cb3d64](0x0,0x0,0x4ad5cec8,0xffffffff) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (2):0x866c35d > > > [0x45cb3d84](0x402448d8,0x0,0x4ad5cec8,0x85fe2a4) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (4):0x85fe2b7 > > > > [0x45cb3da4](0x40240001,0x322,0x45cb3dd4,0x85fe23d)2004-04-20 14:13:45 > > > 24220 ERR 11599 BTRACE (6):0x851e2ea > > > [0x45cb3dd4](0x45cb3e50,0x0,0x0,0xffffffff) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (8):0x851cda4 > > > [0x45cb40c4](0x8915560,0x45cb4e0c,0x45cb4348,0x851cd90) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (10):0x83627ef > > > [0x45cb43c4](0x8915560,0x45cb4e0c,0x50009818,0x4ffff) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (12):0x839cb82 > > > [0x45cb43e4](0x45cb4e0c,0x4,0x0,0x45cb444c) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (14):0x839c825 > > > [0x45cb4484](0x45cb44d4,0x0,0x45cb4544,0x839c81c) > 2004-04-20 14:13:45 > > > 24220 ERR 11599 BTRACE (16):0x81475d9 > > > [0x45cb4544](0x45cb4e0c,0x9,0x45cb45d4,0x861b735) > 2004-04-20 14:13:45 > > > 24220 ERR 11599 BTRACE (18):0x8147b1d > > > [0x45cb45c4](0x45cb4e0c,0x9,0x45cb4d74,0x847d46e) > 2004-04-20 14:13:45 > > > 24220 ERR 11599 BTRACE (20):0x847d47d > > > [0x45cb45f4](0x45cb4e0c,0x28,0x8776dc5,0x37) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (22):0x8147ac2 > > > [0x45cb4d74](0x45cb4e0c,0x45cb4dac,0x45cb4eb4,0x864ef8b) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (24):0x8689bc4 > > > [0x45cb4e74](0x5001e534,0x40240bb8,0x40240ba0,0x400312ae) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (26):0x8689eb1 > > > [0x45cb4e94](0x5001e534,0x0,0x45cb4ec4,0x8689e8b) > 2004-04-20 14:13:45 > > > 24220 ERR 11599 BTRACE (28):0x8648d6b > > > [0x45cb4ec4](0x5001e534,0x40240ba0,0x45cb4ef4,0x8648ceb) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE (30):0x4002cf60 > > > [0x45cb4ef4](0x40240b68,0x0,0x89a5198,0x0) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE ----> Module > List <---- > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE |.text Start > > > |.text End | > > > Module File Name > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE | 0x08048000 | > > > 0x087d3000 | > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE | 0x40000000 | > > > 0x40018000 | > > > /lib/ld-2.3.2.so > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE | 0x40027000 | > > > 0x40035000 | > > > /lib/i686/libpthread.so.0 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE | 0x40078000 | > > > 0x4007a000 | > > > /lib/libdl.so.2 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE | 0x4007b000 | > > > 0x40082000 | > > > /lib/librt.so.1 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE | 0x4008e000 | > > > 0x400c7000 | > > > /usr/lib/libstdc++-3-libc6.2-2-2.10.0.so > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE | 0x400dc000 | > > > 0x400fe000 | > > > /lib/i686/libm.so.6 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE | 0x400ff000 | > > > 0x4022b000 | > > > /lib/i686/libc.so.6 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE ----> > Symbolic Stack Back > > > Trace <---- > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 0: 0x086526f2 > > > eo670_CTraceStack +0x0012 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb3d64] (0x0,0x0,0x4ad5cec8,0xffffffff) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 1: > 0x0866c35d vabort > > > +0x002d > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb3d84] (0x402448d8,0x0,0x4ad5cec8,0x85fe2a4) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 2: 0x085fe2b7 > > > RTE_Crash__FRC20SAPDBErr_MessageList +0x00f7 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb3da4] (0x40240001,0x322,0x45cb3dd4,0x85fe23d) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 3: 0x0851e2ea > > > CreateOpenTransFile__13Log_SavepointR18tgg00_TransContextR17tk > > > b00_SaveptParam +0x036a > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb3dd4] (0x45cb3e50,0x0,0x0,0xffffffff) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 4: 0x0851cda4 > > > Coordinator__13Log_SavepointR18tgg00_TransContext +0x06a4 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb40c4] (0x8915560,0x45cb4e0c,0x45cb4348,0x851cd90) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 5: 0x083627ef > > > kb560SavepointCoordinator +0x0017 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb43c4] (0x8915560,0x45cb4e0c,0x50009818,0x4ffff) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 6: 0x0839cb82 > > > kb92_server +0x034e > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb43e4] (0x45cb4e0c,0x4,0x0,0x45cb444c) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 7: 0x0839c825 > > > k92server_process +0x0165 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb4484] (0x45cb44d4,0x0,0x45cb4544,0x839c81c) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 8: 0x081475d9 > > > ak91run_non_user_process +0x0175 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb4544] (0x45cb4e0c,0x9,0x45cb45d4,0x861b735) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 9: 0x08147b1d > > > a91mainprogam_with_allocator +0x0041 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb45c4] (0x45cb4e0c,0x9,0x45cb4d74,0x847d46e) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 10: 0x0847d47d > > > gg941CreateAllocatorAndCallMainprog +0x00fd > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb45f4] (0x45cb4e0c,0x28,0x8776dc5,0x37) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 11: 0x08147ac2 > > > a91mainprogram +0x008e > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb4d74] (0x45cb4e0c,0x45cb4dac,0x45cb4eb4,0x864ef8b) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 12: 0x08689bc4 > > > en88_CallKernelTaskMain__FP9TASK_TYPE +0x0148 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb4e74] (0x5001e534,0x40240bb8,0x40240ba0,0x400312ae) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE 13: 0x08689eb1 > > > en88_RunPthreadTask +0x0035 > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE > > > /var/maxdb/7500/pgm/kernel > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE Frameinfo > > > [0x45cb4e94] (0x5001e534,0x0,0x45cb4ec4,0x8689e8b) > > > 2004-04-20 14:13:45 24220 ERR 11599 BTRACE ----> End of > Stack Back > > > Trace <---- > > > 2004-04-20 14:13:45 24220 ERR 11196 DBCRASH vabort:Emergency > > > Shutdown, > > > Task: 55 > > > 2004-04-20 14:14:13 --- Starting GMT > > > 2004-04-20 > > > 12:14:13 7.5.0 Build 008-121-061-548 > > > > > > > > > > > > On Mon, 2004-04-19 at 13:22, Brunzema, Martin wrote: > > > > Hi Filip, > > > > > > > > during the recovery are savepoints written. Savepoints are bound > > > > to a specific position in the log resp. logbackup. For > continuing > > > > the logrecovery it is necessary to continue at the > position of the > > > > last savepoint. For older releases this may be not the last > > > recovered > > > > logentry, but an older one, which can also be > positioned in another > > > > logbackup. > > > > > > > > The backuphistory is only a porotcol, but does not > gives information > > > > about the actual state of the database. > > > > > > > > In newer releases a savepoint is written, when the > logrecovery has > > > > been cancelled. If you just stop the database, no > savepoint can be > > > > written. > > > > > > > > regards, Martin > > > > > > > > > > > > > -----Urspr�ngliche Nachricht----- > > > > > Von: Filip Sergeys [mailto:[EMAIL PROTECTED] > > > > > Gesendet: Montag, 19. April 2004 11:56 > > > > > An: [EMAIL PROTECTED] > > > > > Betreff: discrepancy between backup history and db_restartinfo > > > > > > > > > > > > > > > Hello, > > > > > > > > > > I previously import all my available log backups with > > > > > recover_start ARCH > > > > > LOG 300 (for the first one) and recover_replace ARCH > > > > > /var/maxdb/logs/arch 301 to 312 for the consequent ones. > > > All went OK, > > > > > but as I want to import newly create log backups starting > > > from 313 it > > > > > fails. The backup history says up to 312 is OK but the > > > used pages of > > > > > db_restartinfo points to log backup 307. > > > > > > > > > > What can be the reason of this difference and how can I > > > > > prevent it from > > > > > happening again? > > > > > > > > > > Thanx, > > > > > > > > > > Filip > > > > > > > > > > > > > > > -- > > > > > *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > > > > > * System Engineer, Verzekeringen NV * > > > > > * www.verzekeringen.be * > > > > > * Oostkaai 23 B-2170 Merksem * > > > > > * 03/6416673 - 0477/340942 * > > > > > *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > > > > > > > > > > > > > > > -- > > > > > MaxDB Discussion Mailing List > > > > > For list archives: http://lists.mysql.com/maxdb > > > > > To unsubscribe: > > > > > http://lists.mysql.com/maxdb?> [EMAIL PROTECTED] > > > > > > > > -- > > > *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > > > * System Engineer, Verzekeringen NV * > > > * www.verzekeringen.be * > > > * Oostkaai 23 B-2170 Merksem * > > > * 03/6416673 - 0477/340942 * > > > *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* > > > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] .be > -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* * System Engineer, Verzekeringen NV * * www.verzekeringen.be * * Oostkaai 23 B-2170 Merksem * * 03/6416673 - 0477/340942 * *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* -- 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]
