Hi Christoph, for further analysis you could send me the files: dbm.utl,dbm.prt,knldiag,knldiag.err and knltrace.
Then you should recover your last data backup and if necessary recover log as well to reach your last point in time. regards, Uwe >-----Original Message----- >From: Christoph Weser [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 16, 2004 3:22 PM >To: maxdb (E-Mail) >Subject: Error 530, Part II > > >Sorry, I forgot knldiag output: > > >... >... >... >2004-06-16 15:12:55 17235 54003 dynpool LOCK >SupplyPoolSize : 801424 >2004-06-16 15:12:55 17235 54003 dynpool LOCK ObjColl_list >size : 11776 >2004-06-16 15:12:55 17235 54003 dynpool LOCK ObjReq_list >size : 5888 >2004-06-16 15:12:55 17235 7 Log 1 queues, flushmode is >'MinimizeSpace', devs >tate is 'HistoryLost' >2004-06-16 15:12:55 17235 8 Log Oldest not saved is ioseq >833696 @ off 29 >2004-06-16 15:12:55 17235 10 Log LogVolume not completely >written until now >2004-06-16 15:12:55 17235 6 Log Restart from >ioseq 833696 @ off >29 to ioseq >834184 @ off 61 >2004-06-16 15:12:55 17235 11 Log Result after >checking the log >device: 'Ok' >2004-06-16 15:12:55 17220 47 Log recovering log >from log_volume >from IOSeq: ' >833696' >2004-06-16 15:12:55 17220 31 Log normal end of log >found at off >61 lastseq 83 >4184. >2004-06-16 15:12:55 17220 49 Log >last-redo-read#1661:TR824544(1)[EMAIL PROTECTED] >72'Commit':20040615:183021 >2004-06-16 15:12:55 17233 ERR 69 Log REDO: T824477 (committed) >redoresult: 3, TrE >rror: 530 >2004-06-16 15:12:55 17235 ERR 52608 RESTART LOCAL: failed >2004-06-16 15:12:55 17235 ERR 63 Log RESTART ERROR >'530' => SHUTDOWN >IS FORCED >2004-06-16 15:12:55 17235 12696 DBSTATE Change DbState to >'SHUTDOWN'(24) >--------------------------------------- current write position >----------------- > >+++++++++++++++++++++++++++++++++++++++ Kernel Exit >++++++++++++++++++++++++++++ >2004-06-16 15:12:56 0 12845 DBSTATE Kernel exited normal >2004-06-16 15:12:56 0 12890 DIAGHIST Backup of >diagnostic files will >be forced at > next restart >2004-06-16 15:12:56 0 12808 DBSTATE Flushing knltrace pages >2004-06-16 15:12:56 0 11560 COMMUNIC Releasing T28 >2004-06-16 15:12:56 0 12696 DBSTATE Change DbState to 'OFFLINE >'(28) >--------------------------------------- current write position >----------------- > > > > > > > > > > > > > > > > > > > > > >vmware006:/opt/SeeTec/sapdb/indep_data/wrk/SEETEC # less knldiag >2004-06-16 15:12:55 17235 54003 dynpool LOCK >RegionGlob+Space : 2688 >2004-06-16 15:12:55 17235 54003 dynpool LOCK TransGlob > : 640 >2004-06-16 15:12:55 17235 54003 dynpool LOCK >SupplyItemsPerRgn : 100 >2004-06-16 15:12:55 17235 54003 dynpool LOCK SupplySize > : 172800 >2004-06-16 15:12:55 17235 54003 dynpool LOCK RowHash >entries : 3680 >2004-06-16 15:12:55 17235 54003 dynpool LOCK TabHash >entries : 736 >2004-06-16 15:12:55 17235 54003 dynpool LOCK Row+Tab hash >size : 17664 >2004-06-16 15:12:55 17235 54003 dynpool LOCK Trans >entries : 368 >2004-06-16 15:12:55 17235 54003 dynpool LOCK trans_list >size : 61824 >2004-06-16 15:12:55 17235 54003 dynpool LOCK TransPtrList > : 1472 >2004-06-16 15:12:55 17235 54003 dynpool LOCK TransHash >entries : 368 >2004-06-16 15:12:55 17235 54003 dynpool LOCK TransHash >size : 1536 >2004-06-16 15:12:55 17235 54003 dynpool LOCK >SupplyPoolSegments: 111 >2004-06-16 15:12:55 17235 54003 dynpool LOCK >SupplyPoolSize : 801424 >2004-06-16 15:12:55 17235 54003 dynpool LOCK ObjColl_list >size : 11776 >2004-06-16 15:12:55 17235 54003 dynpool LOCK ObjReq_list >size : 5888 >2004-06-16 15:12:55 17235 7 Log 1 queues, flushmode is >'MinimizeSpace', devs >tate is 'HistoryLost' >2004-06-16 15:12:55 17235 8 Log Oldest not saved is ioseq >833696 @ off 29 >2004-06-16 15:12:55 17235 10 Log LogVolume not completely >written until now >2004-06-16 15:12:55 17235 6 Log Restart from >ioseq 833696 @ off >29 to ioseq >834184 @ off 61 >2004-06-16 15:12:55 17235 11 Log Result after >checking the log >device: 'Ok' >2004-06-16 15:12:55 17220 47 Log recovering log >from log_volume >from IOSeq: ' >833696' >2004-06-16 15:12:55 17220 31 Log normal end of log >found at off >61 lastseq 83 >4184. >2004-06-16 15:12:55 17220 49 Log >last-redo-read#1661:TR824544(1)[EMAIL PROTECTED] >72'Commit':20040615:183021 >2004-06-16 15:12:55 17233 ERR 69 Log REDO: T824477 (committed) >redoresult: 3, TrE >rror: 530 >2004-06-16 15:12:55 17235 ERR 52608 RESTART LOCAL: failed >2004-06-16 15:12:55 17235 ERR 63 Log RESTART ERROR >'530' => SHUTDOWN >IS FORCED >2004-06-16 15:12:55 17235 12696 DBSTATE Change DbState to >'SHUTDOWN'(24) >--------------------------------------- current write position >----------------- > >+++++++++++++++++++++++++++++++++++++++ Kernel Exit >++++++++++++++++++++++++++++ >2004-06-16 15:12:56 0 12845 DBSTATE Kernel exited normal >2004-06-16 15:12:56 0 12890 DIAGHIST Backup of >diagnostic files will >be forced at > next restart >2004-06-16 15:12:56 0 12808 DBSTATE Flushing knltrace pages >2004-06-16 15:12:56 0 11560 COMMUNIC Releasing T28 >2004-06-16 15:12:56 0 12696 DBSTATE Change DbState to 'OFFLINE >'(28) >--------------------------------------- current write position >----------------- > >knldiag lines 581-617/10191 5% > >-- >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]
