AW: Problem with DB Restore

> -----Ursprüngliche Nachricht-----
> Von: Michael Jürgens [mailto:maxdb@xxxxxxxxxxxxx] 
> Gesendet: Mittwoch, 6. April 2005 12:49
> An: 'maxdb@xxxxxxxxxxxxxxx'
> Betreff: Problem with DB Restore
> 
> 
> Hello,
> I´ve a problem restoring a database.
> I´m using a script that is tested an used since several months.
> 
> During
> 
> > db_activate RECOVER dbRestore_PROD_R2
> > ERR
> > -24988,ERR_SQL: sql error
> > -71,connection broken server state 6
> 
> 
> the database shut down and knldiag gives the following:
> 
> > 2005-04-06 12:38:05 9285 11597 IO Open 
> > '/opt/maxdbdata/TEST_R3/TEST_R3_data_004' successfull, fd: 25
> > 2005-04-06 12:38:05 7745 11000 vattach 
> > '/opt/maxdbdata/TEST_R3/TEST_R3_data_004' devno 5 T41 succeeded
> > 2005-04-06 12:38:05 9285 11565 startup DEVi started
> > 2005-04-06 12:38:05 7745 54003 dynpool DATA_CACHE_REGIONS : 16
> > 2005-04-06 12:38:05 7745 54003 dynpool B20_DATACACHE_HEAD : 99976
> > 2005-04-06 12:38:05 7745 54003 dynpool DATACACHE head num 
> item: 12497
> > 2005-04-06 12:38:05 7745 54003 dynpool DATACACHE head item siz: 8
> > 2005-04-06 12:38:05 7745 54003 dynpool DATACACHE task queue : 1984
> > 2005-04-06 12:38:05 7745 54003 dynpool US + SV + DW + 8 : 124
> > 2005-04-06 12:38:05 7745 54003 dynpool DATACACHE taskq elem : 16
> > 2005-04-06 12:38:05 7745 54003 dynpool B20_DATACACHE_TASKQ : 101960
> > 2005-04-06 12:38:05 7745 54003 dynDATA DATA_CACHE_PAGES : 3124
> > 2005-04-06 12:38:05 7745 54003 dynpool B20_DATACACHE_CB : 212432
> > 2005-04-06 12:38:05 7745 54003 dynpool DATACACHE num cblocks : 3124
> > 2005-04-06 12:38:05 7745 54003 dynpool DATACACHE cblock size : 68
> > 2005-04-06 12:38:06 7745 54003 dynpool DYNP_B20_DATACACHE :5030272
> > 2005-04-06 12:38:06 7745 54003 dynDATA DYND_B20_DATACACHE : 49984
> > 2005-04-06 12:38:06 7745 53000 DATACACH Reduce Data Cache 
> (pool): 3124
> > 2005-04-06 12:38:06 7745 53000 DATACACH Reduce Data Cache 
> (pool): 3124
> > 2005-04-06 12:38:06 7745 53000 DATACACH Reduce Data Cache 
> (pool): 3124
> > 2005-04-06 12:38:06 7745 ERR 8 Admin ERROR 'B_ERR=1' CAUSED 
> EMERGENCY 
> > SHUTDOWN
> > 2005-04-06 12:38:06 7745 12696 DBSTATE Change DbState to 
> 'SHUTDOWN'(25)
> > --------------------------------------- current write position 
> > -----------------
> >
> > +++++++++++++++++++++++++++++++++++++++ Kernel Exit 
> > ++++++++++++++++++++++++++++
> > 2005-04-06 12:38:07 0 12845 DBSTATE Kernel exited normal
> > 2005-04-06 12:38:07 0 12890 DIAGHIST Backup of diagnostic 
> files will 
> > be forced at next restart
> > 2005-04-06 12:38:07 0 12808 DBSTATE Flushing knltrace pages
> > 2005-04-06 12:38:07 0 11560 COMMUNIC Releasing T41
> > 2005-04-06 12:38:07 0 12696 DBSTATE Change DbState to 'OFFLINE '(29)
> > --------------------------------------- current write position 
> > -----------------
> 
> 
> any help?

Hi,

which release do you use. Could you please repeat the recovery using
the so called slow-kernel of the database, which may give more
diagnostic output. You start it with the option -slow (e.g. dbmcli> db_admin 
-slow)

Kind regards, Martin

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx