pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Error in Access
5+ messages / 3 participants
[nested] [flat]

* Error in Access
@ 2006-05-15 15:09 Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
  2006-05-22 16:40 ` Re: Error in Access Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Xu, Xiaoyi (Rocky) FSM @ 2006-05-15 15:09 UTC (permalink / raw)
  To: pgsql-admin

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.

Rocky Xu

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Error in Access
  2006-05-15 15:09 Error in Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
@ 2006-05-22 16:40 ` Jim C. Nasby <jnasby@pervasive.com>
  2006-05-22 17:56   ` Re: Error in Access Andy Shellam <andy@andycc.net>
  0 siblings, 1 reply; 5+ messages in thread

From: Jim C. Nasby @ 2006-05-22 16:40 UTC (permalink / raw)
  To: Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Error in Access
  2006-05-15 15:09 Error in Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
  2006-05-22 16:40 ` Re: Error in Access Jim C. Nasby <jnasby@pervasive.com>
@ 2006-05-22 17:56   ` Andy Shellam <andy@andycc.net>
  2006-05-22 18:02     ` Re: Error in Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
  2006-05-22 19:58     ` Re: Error in Access Jim C. Nasby <jnasby@pervasive.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Andy Shellam @ 2006-05-22 17:56 UTC (permalink / raw)
  To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: pgsql-admin; xyxu@northwestern.edu

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?
>   

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Error in Access
  2006-05-15 15:09 Error in Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
  2006-05-22 16:40 ` Re: Error in Access Jim C. Nasby <jnasby@pervasive.com>
  2006-05-22 17:56   ` Re: Error in Access Andy Shellam <andy@andycc.net>
@ 2006-05-22 18:02     ` Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
  1 sibling, 0 replies; 5+ messages in thread

From: Xu, Xiaoyi \(Rocky\) FSM @ 2006-05-22 18:02 UTC (permalink / raw)
  To: andy@andycc.net; Jim C. Nasby <jnasby@pervasive.com>; +Cc: pgsql-admin

Thank you both. Yes I was helping others when you two are helping me:) I
appreciate your time and help very much.
 
We rebooted server and recovered the disk space. Also doing vacuum
routinely. So far so good. Thanks again.
 
Rocky
________________________________

From: Andy Shellam [mailto:andy@andycc.net] 
Sent: Monday, May 22, 2006 12:57 PM
To: Jim C. Nasby
Cc: pgsql-admin@postgresql.org; Xu, Xiaoyi (Rocky) FSM
Subject: Re: [ADMIN] Error in Access


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?
	  

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Error in Access
  2006-05-15 15:09 Error in Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
  2006-05-22 16:40 ` Re: Error in Access Jim C. Nasby <jnasby@pervasive.com>
  2006-05-22 17:56   ` Re: Error in Access Andy Shellam <andy@andycc.net>
@ 2006-05-22 19:58     ` Jim C. Nasby <jnasby@pervasive.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Jim C. Nasby @ 2006-05-22 19:58 UTC (permalink / raw)
  To: Andy Shellam <andy@andycc.net>; +Cc: pgsql-admin; xyxu@northwestern.edu

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-05-22 19:58 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-15 15:09 Error in Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-22 16:40 ` Jim C. Nasby <jnasby@pervasive.com>
2006-05-22 17:56   ` Andy Shellam <andy@andycc.net>
2006-05-22 18:02     ` Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-22 19:58     ` Jim C. Nasby <jnasby@pervasive.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox