From: Hahn, Uwe (uwe.hahnsap.com)
Date: Wed Jun 16 2004 - 08:35:25 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:Christoph.WeserSeeTec.de]
>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)[834184]61.2
>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)[834184]61.2
>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/maxdb?unsub=uwe.hahnsap.com
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]