From: Christoph Weser (Christoph.WeserSeeTec.de)
Date: Mon Feb 14 2005 - 07:42:00 CST

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

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)[7093005]2345.24'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:alexander.schroedersap.com]
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:Christoph.WeserSeeTec.de]
> 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

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