Обсуждение: Error in Access
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
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
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:
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?
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
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?
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