> -----Urspr�ngliche Nachricht----- > Von: Michael J�rgens [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 6. April 2005 12:49 > An: '[email protected]' > 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/[EMAIL PROTECTED]
