Hello, it's me again! here an extract of the knldiag......hav a look to the delay between: 11:50:15 and 11:52:50
Why does this delay occurs every second start of the machine??? Thanx a lot and thanx Alexander for the hint with the attachment! :-) ============================================ begin of write cycle ================== 2005-02-03 11:50:04 0x420 19686 TASKING Automatic restart, SERVERDB: 'SEETEC' 2005-02-03 11:50:07 0x420 19615 VOLUMEIO Attaching volume 'C:\Programme\SeeTec\sapdb\DISKD0001' 2005-02-03 11:50:08 0x3E0 19613 DBSTATE I/O thread for 'C:\Programme\SeeTec\sapdb\DISKD0001' started 2005-02-03 11:50:08 0x420 19617 VOLUMEIO Single I/O attach, 'C:\Programme\SeeTec\sapdb\DISKD0001', UKT:3 2005-02-03 11:50:08 0x420 19615 VOLUMEIO Attaching volume 'C:\Programme\SeeTec\sapdb\DISKD0002' 2005-02-03 11:50:08 0x3B8 19613 DBSTATE I/O thread for 'C:\Programme\SeeTec\sapdb\DISKD0002' started 2005-02-03 11:50:08 0x420 19617 VOLUMEIO Single I/O attach, 'C:\Programme\SeeTec\sapdb\DISKD0002', UKT:3 2005-02-03 11:50:08 0x420 19615 VOLUMEIO Attaching volume 'C:\Programme\SeeTec\sapdb\DISKD0003' 2005-02-03 11:50:08 0x2E0 19613 DBSTATE I/O thread for 'C:\Programme\SeeTec\sapdb\DISKD0003' started 2005-02-03 11:50:09 0x420 19617 VOLUMEIO Single I/O attach, 'C:\Programme\SeeTec\sapdb\DISKD0003', UKT:3 2005-02-03 11:50:09 0x420 19615 VOLUMEIO Attaching volume 'C:\Programme\SeeTec\sapdb\DISKD0004' 2005-02-03 11:50:09 0x4AC 19613 DBSTATE I/O thread for 'C:\Programme\SeeTec\sapdb\DISKD0004' started 2005-02-03 11:50:09 0x420 19617 VOLUMEIO Single I/O attach, 'C:\Programme\SeeTec\sapdb\DISKD0004', UKT:3 2005-02-03 11:50:09 0x420 19615 VOLUMEIO Attaching volume 'C:\Programme\SeeTec\sapdb\DISKL001' 2005-02-03 11:50:09 0x210 19613 DBSTATE I/O thread for 'C:\Programme\SeeTec\sapdb\DISKL001' started 2005-02-03 11:50:09 0x420 19617 VOLUMEIO Single I/O attach, 'C:\Programme\SeeTec\sapdb\DISKL001', UKT:3 2005-02-03 11:50:10 0x420 12 Pager Start Read Converter 2005-02-03 11:50:15 0x420 13 Pager Stop Read Converter, Pages: 144 IO: 144 2005-02-03 11:50:15 0x420 54003 dynpool DATA_CACHE_REGIONS : 64 2005-02-03 11:50:15 0x420 54003 dynpool B20_DATACACHE_HEAD : 99928 2005-02-03 11:50:15 0x420 54003 dynpool DATACACHE head num item: 12491 2005-02-03 11:50:15 0x420 54003 dynpool DATACACHE head item siz: 8 2005-02-03 11:50:15 0x420 54003 dynpool DATACACHE task queue : 2592 2005-02-03 11:50:15 0x420 54003 dynpool US + SV + DW + 8 : 162 2005-02-03 11:50:15 0x420 54003 dynpool DATACACHE taskq elem : 16 2005-02-03 11:50:15 0x420 54003 dynpool B20_DATACACHE_TASKQ : 102520 2005-02-03 11:50:15 0x420 54003 dynDATA DATA_CACHE_PAGES : 3122 2005-02-03 11:50:15 0x420 54003 dynpool B20_DATACACHE_CB : 224784 2005-02-03 11:50:15 0x420 54003 dynpool DATACACHE num cblocks : 3122 2005-02-03 11:50:15 0x420 54003 dynpool DATACACHE cblock size : 72 2005-02-03 11:52:50 0x420 54003 dynpool DYNP_B20_DATACACHE : 20947456 2005-02-03 11:52:50 0x420 54003 dynDATA DYND_B20_DATACACHE : 199808 2005-02-03 11:52:50 0x420 54003 dynpool TREELOCK_HEAD_LIST all : 800012 2005-02-03 11:52:50 0x420 54003 dynpool DATA_CACHE_PAGES*10/par: 200003 2005-02-03 11:52:50 0x420 54003 dynpool TREELOCK_HEAD_LIST elem: 4 2005-02-03 11:52:50 0x420 54003 dynpool TREELOCK_LIST all : 8832 2005-02-03 11:52:50 0x420 54003 dynpool (USER + SERVER + 2) * 2: 184 2005-02-03 11:52:50 0x420 54003 dynpool TREELOCK_LIST elem : 48 2005-02-03 11:52:50 0x420 54003 dynpool TREE_LOCK region count : 8 2005-02-03 11:52:50 0x420 54003 dynpool DYNP_B77_TREE_LOCK :6470752 2005-02-03 11:52:50 0x420 53022 B*TREE CHECK FILE: 14888 (ROOT) 2005-02-03 11:52:50 0x420 54003 dynpool DYNP_K51_LOCK_LIST :1079760 2005-02-03 11:52:50 0x420 54003 dynpool LOCK maxlocks : 3680 2005-02-03 11:52:50 0x420 54003 dynpool LOCK items : 13500 2005-02-03 11:52:50 0x420 54003 dynpool LOCK Regions : 24 2005-02-03 11:52:50 0x420 54003 dynpool LOCK TransRegions : 8 2005-02-03 11:52:50 0x420 54003 dynpool LOCK RegionGlob+Space : 2688 2005-02-03 11:52:50 0x420 54003 dynpool LOCK TransGlob : 640 2005-02-03 11:52:50 0x420 54003 dynpool LOCK SupplyItemsPerRgn : 100 2005-02-03 11:52:50 0x420 54003 dynpool LOCK SupplySize : 172800 2005-02-03 11:52:50 0x420 54003 dynpool LOCK RowHash entries : 3680 2005-02-03 11:52:50 0x420 54003 dynpool LOCK TabHash entries : 736 2005-02-03 11:52:50 0x420 54003 dynpool LOCK Row+Tab hash size : 17664 2005-02-03 11:52:50 0x420 54003 dynpool LOCK Trans entries : 368 2005-02-03 11:52:50 0x420 54003 dynpool LOCK trans_list size : 61824 2005-02-03 11:52:50 0x420 54003 dynpool LOCK TransPtrList : 1472 2005-02-03 11:52:50 0x420 54003 dynpool LOCK TransHash entries : 368 2005-02-03 11:52:50 0x420 54003 dynpool LOCK TransHash size : 1536 2005-02-03 11:52:50 0x420 54003 dynpool LOCK SupplyPoolSegments: 111 2005-02-03 11:52:50 0x420 54003 dynpool LOCK SupplyPoolSize : 801424 2005-02-03 11:52:50 0x420 54003 dynpool LOCK ObjColl_list size : 11776 2005-02-03 11:52:50 0x420 54003 dynpool LOCK ObjReq_list size : 5888 2005-02-03 11:52:50 0x420 7 Log 1 queues, flushmode is 'MinimizeSpace', devstate is 'HistoryLost' 2005-02-03 11:52:50 0x420 8 Log Oldest not saved is ioseq 7093005 @ off 2345 2005-02-03 11:52:50 0x420 9 Log First known on LogVolume is ioseq 6994163 @ off 2346 2005-02-03 11:52:50 0x420 6 Log Restart from ioseq 7093005 @ off 2345 to ioseq 7093005 @ off 2345 2005-02-03 11:52:50 0x420 11 Log Result after checking the log device: 'Ok' 2005-02-03 11:52:50 0x424 47 Log recovering log from log_volume from IOSeq: '7093005' 2005-02-03 11:52:50 0x424 31 Log normal end of log found at off 2345 lastseq 7093005. 2005-02-03 11:52:50 0x424 49 Log last-redo-read#1:TR-1(3772)[EMAIL PROTECTED]'FinishOpenTrans':20050203:11441 0 2005-02-03 11:52:50 0x420 44 Log Savepoint requested by T4 reason 'Restart' (started). 2005-02-03 11:52:50 0x424 4 Pager SVP(1) Start Write Data 2005-02-03 11:52:50 0x424 5 Pager SVP(1) Stop Data IO, Pages: 0 IO: 0 2005-02-03 11:52:50 0x424 6 Pager SVP(2) Wait for last split, TaskId: 155 2005-02-03 11:52:50 0x424 7 Pager SVP(2) Stop Wait for last split, Pages: 0 IO: 0 2005-02-03 11:52:50 0x424 53070 SAVPOINT B20PREPARE_SVP: 3774 2005-02-03 11:52:50 0x424 8 Pager SVP(3) Start Write Data 2005-02-03 11:52:50 0x424 9 Pager SVP(3) Stop Data IO, Pages: 1 IO: 1 2005-02-03 11:52:50 0x424 10 Pager SVP(3) Start Write Converter 2005-02-03 11:52:50 0x424 11 Pager SVP(3) Stop Converter IO, Pages: 1 IO: 1 2005-02-03 11:52:50 0x424 53071 SAVPOINT B20SVP_COMPLETED: 3774 2005-02-03 11:52:50 0x420 52612 RESTART LOCAL: ready 2005-02-03 11:52:50 0x420 54003 dynpool DYNP_A42_PARSEID : 900 2005-02-03 11:52:50 0x420 54000 OBJECT C:\PROGRAMME\SEETEC\SAPDB\DEPEND\pgm\lib 2005-02-03 11:52:50 0x420 54000 OBJECT oms 2005-02-03 11:52:50 0x420 19602 DBSTATE SERVERDB is in ONLINE state -------------------------------------------- current write position ---------------- -----Urspr�ngliche Nachricht----- Von: Schroeder, Alexander [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. Februar 2005 08:50 An: Christoph Weser; maxdb (E-Mail) Betreff: RE: Delay while startup. Hello Christoph, please put (at least the interesting part) the knldiag into the mail, as the attachment didn't made it through the list ... Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Christoph Weser [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 02, 2005 5:24 PM > To: 'maxdb (E-Mail)' > Subject: Delay while startup. > > Hello Everyone. > > I attached an Knldiag file. > > Here I have one question: When starting the machine, the > instance seems to > do nothing between 16:44:59 und 16:47:34. > Cause it "hangs" for 2,5 minutes my applications connecting > to the database > run into problems. Where comes this delay from? > > The strange thing is, that it only seems to happen every > second restart of > the machine. > > Any ideas on this strange topic? > > Thanx a lot! > > Chris > > <<knldiag_.zip>> > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
