Solved

Error: dstartio: I/O request repeatedly delayed

Posted on 1999-01-21
5
1,124 Views
Last Modified: 2012-08-13
Hi,

    Here's a few errors I got from my Sybase's log.
block number: 30451, vdn: 3
00:00000:00000:1999/01/21 13:09:22.39 kernel  dstartio: I/O request repeatedly delayed;
and it's repeated ... many times. It happend mostly when I do some bcp into my database. Could someone point me into the right direction as what might have cause it and the fixe ?
0
Comment
Question by:n0thing
  • 3
5 Comments
 
LVL 9

Expert Comment

by:david_levine
ID: 1098572
I found the following post on DejaNews. It was posted by someone with your issue and is a response from Sybase to that person.

The dstartio error you're seeing is often caused by unequal rates of asynchronous i/o between the server and the operating system.  This is informational, sometimes indicates some small performance degradation, but unless you're seeing a huge amount of them, it can safely be ignored.  In most cases, changing three configuration parameters clears up the problem,
so I'd like you to try this, please:  set to 500 the following parameters:
disk i/o structures, max async i/os per server, and max async i/os perengine.

For reference, there's an excellent writeup (although rather well-hidden) in the back of the Error Messages manual.  It's titled "Dstart I/O Request Repeatedly Delayed", and does have an index entry for the page number.

0
 
LVL 5

Author Comment

by:n0thing
ID: 1098573
I've reconfigure the server with the sync I/O and other parameters. Seems to be working fine right now. I didn't see your
comment. However it points to the right direction. Would you mind posting an empty answer so I could give you the points ??
Regards,
Minh Lai
0
 
LVL 9

Accepted Solution

by:
david_levine earned 50 total points
ID: 1098574
Glad you seem to be running!
0
 

Expert Comment

by:syeats
ID: 1098575
Hi, just joined this site.
I'm having the same problem with the third dataserver on a Sun box
I've set the 3 parameters you mention to 100, but still get the errors.
The Sybase doco says not to configure maxasync i/os per server higher than 200 for versions of Solaris 2.4 or higher.
Why do you recommend 500?
Regards,
Simon Yeats.
0
 
LVL 9

Expert Comment

by:david_levine
ID: 1098576
Sorry, I don't know what you should do in your case. I found the answer I posted by searching the net. It helped the person whose problem seemed to match the one I found.

David
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SyBase SQL Query Syntax 11 471
sql statement error 18 83
SAP HANA use case satisfy OLAP applications only. How true? 7 291
MS SQL 2008 server - system update recommendation 13 110
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question