Discussion:
error code: 1453, Insufficient quota to complete the request
(too old to reply)
Mike
2004-11-02 17:40:04 UTC
Permalink
I'm getting the following error when running a query
"A read failed with error code: (1453), Insufficient quota to complete the
requested service." After I get this error the server must be restarted.

The best I can tell is that this is some sort of IO error, perhaps insufficient
memory.

The DB file is about 25GB, and the query is doing a table scan on one of our
larger tables. I'm running ASA 9.0.1 build 1841 on Win 2003 Server. The
machine has 3.5 GB of RAM. I'm using the following dbsrv9 cache switches for
memory allocation
-c 2560MB
-cw

I have the /3GB switch in the boot.ini and I have specified the "Lock Pages in
Memory" option for the account running the server.

Any ideas?

Thanks Mike

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
John Smirnios
2004-11-09 18:27:49 UTC
Permalink
This is an OS bug that has cropped up a few times in the past and (last
I heard) we have no way to reproduce the problem in-house, we cannot
isolate what causes it and we have found nothing that we can do to
completely avoid its periodic recurrence for those customers who seem to
get it once in a while. The OS bug also affects MS SQL Server (see
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q274310&). Like
MS, we added retries and given that you are running 9.0.1 that means
that we retried the IO 100 times and it failed every time.
--
John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
Post by Mike
I'm getting the following error when running a query
"A read failed with error code: (1453), Insufficient quota to complete the
requested service." After I get this error the server must be restarted.
The best I can tell is that this is some sort of IO error, perhaps insufficient
memory.
The DB file is about 25GB, and the query is doing a table scan on one of our
larger tables. I'm running ASA 9.0.1 build 1841 on Win 2003 Server. The
machine has 3.5 GB of RAM. I'm using the following dbsrv9 cache switches for
memory allocation
-c 2560MB
-cw
I have the /3GB switch in the boot.ini and I have specified the "Lock Pages in
Memory" option for the account running the server.
Any ideas?
Thanks Mike
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
Loading...