To whom this may concern,
 
We have difficulties with the updating of our standby database. We're
using MaxDB Version 7.6.00.16 on a Microsoft Windows 2003 Server. The
standby system is identical. We're updating the standby instance on the
standby server with log backups of the original database. We proceed, as
described in the online help. Now the log recovery of the standby
database has been interrupted. The log recovery with the tool dbmcli
aborted with the following error:
 
dbmcli on CGITRMS>ERR
-24895,ERR_SHUTDOWN: shutdown of database occured
-24994,ERR_RTE: Runtime environment error
6,connection broken
 
I was able to restore many logs before the error occurred. I'm also able
to restore the last successful restored log again and again. For detail
I sent an abstract of the KNLDIAG log:
 
006-08-31 10:11:49     0x166C         6 Restart  recovering log from
tape from IOSeq '17596350' until IOSeq: 'NIL'
2006-08-31 10:11:49     0x166C     52024 RESTORE  200 pages <-
"\Cgitrms\LogSicherung.948"
2006-08-31 10:11:53     0x166C     52024 RESTORE  26200 pages <-
"gitrms\LogSicherung.948"
2006-08-31 10:11:58     0x166C     52024 RESTORE  56600 pages <-
"gitrms\LogSicherung.948"
2006-08-31 10:12:03     0x166C     52024 RESTORE  87000 pages <-
"gitrms\LogSicherung.948"
2006-08-31 10:12:07     0x13C0     19626 IO       Async I/O thread
stopped, 'E:\Data\Cgitrms\LogSicherung.948'
2006-08-31 10:12:07     0x166C     52024 RESTORE  109248 pages <-
"itrms\LogSicherung.948"
2006-08-31 10:12:07      0xFD8     52012 RESTORE  new tape required 4300
2006-08-31 10:12:07      0xFD8         2 Backup   Backupmedium #1
(E:\Data\Cgitrms\LogSicherung.948)
2006-08-31 10:12:07      0xFD8         2 Backup    + 2006-08-31 10:11:48
Log Info 20000
2006-08-31 10:12:07      0xFD8         2 Backup    -   no update of
LogInfoPage: DeviceState = Cleared, LogIsEmpty = true
2006-08-31 10:12:07     0x14A4     19625 IO       Async I/O thread
started, 'E:\Data\Cgitrms\LogSicherung.949
2006-08-31 10:12:07     0x166C     52101 RESTORE  Filetype: file
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks SrvTasks_Task.cpp:96
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks 2006-08-31 10:12:07
SrvTasks Error 46
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks After Job execution
the job is still allocating 504 bytes.
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  +
SrvTasks_Task.cpp:375
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  + 2006-08-31 10:12:07
SrvTasks Info 32
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  -   Server T158 Id2
dynamic: ''
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  +
SrvTasks_Job.cpp:123
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  + 2006-08-31 10:12:07
SrvTasks Info 17
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  -   Servertask Info:
because job of task
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  +
SrvTasks_Job.cpp:124
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  + 2006-08-31 10:12:07
SrvTasks Info 10
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  -   Job 1 (RedoLog
Execution Task) [finished] WaitingT1 Result=1
2006-08-31 10:12:07     0x166C     20012 Log
last-redo-read#7:TR38037136(0)[EMAIL PROTECTED]'InsertRecord':20060831
:33148
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks SrvTasks_Task.cpp:96
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks 2006-08-31 10:12:07
SrvTasks Error 46
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks After Job execution
the job is still allocating 1328 bytes.
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  +
SrvTasks_Task.cpp:375
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  + 2006-08-31 10:12:07
SrvTasks Info 32
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  -   Server T87 Id0
dynamic: ''
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  +
SrvTasks_Job.cpp:123
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  + 2006-08-31 10:12:07
SrvTasks Info 17
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  -   Servertask Info:
because job of task
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  +
SrvTasks_Job.cpp:124
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  + 2006-08-31 10:12:07
SrvTasks Info 10
2006-08-31 10:12:07     0x166C ERR    46 SrvTasks  -   Job 0 (RedoLog
Reader) [finished] WaitingT0 Result=OK
2006-08-31 10:12:07     0x166C     52024 RESTORE  200 pages <-
"\Cgitrms\LogSicherung.949"
2006-08-31 10:12:07     0x166C ERR     3 Admin
Kernel_Administration.cpp:606
2006-08-31 10:12:07     0x166C ERR     3 Admin    2006-08-31 10:12:07
Admin Error 3
2006-08-31 10:12:07     0x166C ERR     3 Admin    Database state:
OFFLINE
2006-08-31 10:12:07     0x166C ERR     3 Admin     +
Rst_RedoTrafficControl.cpp:926
2006-08-31 10:12:07     0x166C ERR     3 Admin     + 2006-08-31 10:12:07
Rst Error 2
2006-08-31 10:12:07     0x166C ERR     3 Admin     -   Trans 38037134
failed during redo with 3 (ExecuteError)
2006-08-31 10:12:07     0x166C ERR     3 Admin     +
Rst_RedoTrafficControl.cpp:433
2006-08-31 10:12:07     0x166C ERR     3 Admin     + 2006-08-31 10:12:07
Restart Error 20000
2006-08-31 10:12:07     0x166C ERR     3 Admin     -   Assertion of
state pNext not nil. failed!
2006-08-31 10:12:07     0x166C ERR     3 Admin     +
Log_AfterImage.hpp:212
2006-08-31 10:12:07     0x166C ERR     3 Admin     + 2006-08-31 10:12:07
Log Info 3
2006-08-31 10:12:07     0x166C ERR     3 Admin     -   Log_AfterImage:
type=UpdateBlob/1 isdone=no seq=5 TR38037134
2006-08-31 10:12:07     0x166C ERR     3 Admin     +
Log_ActionUndoRedo.cpp:480
2006-08-31 10:12:07     0x166C ERR     3 Admin     + 2006-08-31 10:12:07
Data Info 43
2006-08-31 10:12:07     0x166C ERR     3 Admin     -
Data_ChainSplitSpaceForwardReadChain::Iterator: space is complete
break=2147483647.0 (ForRead)
 
The log LogSicherung.948 was the last one I could restore. The Recovery
of all Logs since the last complete Backup (this was before
LogSicherung.837) worked fine. The result column in the backup history
of the original database  says "OK" for the log I couldn't restore. This
is LogSicherung.949.
 
Many thanks in advance for your trouble.
 
Christoph Hilden
=========================== 
Christoph Hilden
CG IT-Solutions GmbH 
Hans-Henny-Jahnn-Weg 35
22085 Hamburg 
Tel.: 040 - 2266 07 213
Fax: 040 - 2266 07 219 
E-Mail: [EMAIL PROTECTED] 
===========================
 

 

Reply via email to