Skip site navigation (1) Skip section navigation (2)

Re: ERROR: could not read block

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: <icub3d(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org>,<tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: ERROR: could not read block
Date: 2005-11-16 20:24:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Our DBAs reviewed the Microsoft documentation you referenced,
modified the registry, and rebooted the OS.  We've been beating
up on the database without seeing the error so far.  We'll keep at
it for a while.


>>> Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>  >>>

On Wed, 16 Nov 2005, Kevin Grittner wrote:

> Ran with this change.  Didn't take long to hit it.
> [2005-11-16 11:59:29.015 ] 4904 <dtr dtr> LOG:
> read failed on relation 1663/16385/1494810: -1 bytes, 1450
> [2005-11-16 11:59:29.015 ] 4904 <dtr dtr> ERROR:
> could not read block 25447 of relation 1663/16385/1494810: Invalid
> argument

Insufficient system resources exist to complete the requested service

SQL Server 7.0 experienced the same problem before:;en-us;274310

Some registration value tweak to solve it (for backup service):;en-us;304101

I have to go out for a while ... Kevin, can you take a look at the 2nd
thread to see if it is possible to change some reg values to temporarily
solve the problem. A more robust solution will follow a retry style
following thread 1 I guess.


pgsql-admin by date

Next:From: Bruno Wolff IIIDate: 2005-11-16 20:43:15
Subject: Re: md5 collision generator
Previous:From: Flávio BritoDate: 2005-11-16 20:21:31
Subject: Receive a record not a tuple - plpgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group