Обсуждение: Error in Access

Поиск
Список
Период
Сортировка

Error in Access

От
"Xu, Xiaoyi (Rocky) FSM"
Дата:

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

Re: Error in Access

От
"Jim C. Nasby"
Дата:
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

Re: Error in Access

От
Andy Shellam
Дата:
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? 

Re: Error in Access

От
"Xu, Xiaoyi \(Rocky\) FSM"
Дата:
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? 

Re: Error in Access

От
"Jim C. Nasby"
Дата:
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