X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7EFA49F9B01 for ; Mon, 22 May 2006 16:58:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 19854-07 for ; Mon, 22 May 2006 16:58:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id C7F459FA634 for ; Mon, 22 May 2006 16:58:43 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 01CDE5643A; Mon, 22 May 2006 14:58:41 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 22 May 2006 14:58:38 -0500 Date: Mon, 22 May 2006 14:58:37 -0500 From: "Jim C. Nasby" To: Andy Shellam Cc: pgsql-admin@postgresql.org, xyxu@northwestern.edu Subject: Re: Error in Access Message-ID: <20060522195836.GP64371@pervasive.com> References: <20060522164022.GT64371@pervasive.com> <4471FB5D.6030707@andycc.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4471FB5D.6030707@andycc.net> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060522:andy@andycc.net::+3zCyAYVIdTpxuQd:00897D X-Hashcash: 1:20:060522:pgsql-admin@postgresql.org::yftgRD3JjZaaYIU4:00000000000 0000000000000000000000002CRe X-Hashcash: 1:20:060522:xyxu@northwestern.edu::m9x4OmpoF/yDPYoQ:0000000000000000 000000000000000000000000GGFt X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/296 X-Sequence-Number: 21828 I would have thought that when the error message says you might be out of disk space that that's the first thing you would check... :) On Mon, May 22, 2006 at 06:56:45PM +0100, Andy Shellam wrote: > Jim, > > This exact e-mail was also raised a few weeks ago! I advised Rocky to > check the host server, and as it turned out, it's PG data partition was > 100% full! I believe Rocky was covering for a system admin temporarily, > hence the fact it wasn't picked up sooner. I don't know what happened > since - whether he got it sorted. > > Regards > > Andy > > Jim C. Nasby wrote: > >On Mon, May 15, 2006 at 10:09:25AM -0500, Xu, Xiaoyi (Rocky) FSM wrote: > > > >>Hi, > >> > >>My database users are getting following error: > >> > >>ODBC-call failed > >>Error while executing query > >>Error: ItsWriteBlock: failed to write block 1 of temporary file > >>Perhaps out of disk space (#1) > >> > >>This happens in Access. Could anyone shed some light on this? Thank you. > >> > > > >Does the command work if you run it from psql? > > > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461