Re: Error in MS Access - Mailing list pgsql-admin

From Xu, Xiaoyi \(Rocky\) FSM
Subject Re: Error in MS Access
Date
Msg-id D225C9E264D67D44AD092DC5683D31E403B2BBFA@medex2k.fsm.northwestern.edu
Whole thread Raw
In response to Re: Error in MS Access  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Responses Re: Error in MS Access  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
Thank you Andy.
 
The server is SunOS 5.8 Generic_117350-29 ultra-250. The db is version 7.
I checked disk (df -k) telling me /home0 is full 100% that has DB on. Former DBA has notes to delete large log files (server.log). But this time I didn't find same file. I saw pg_log file 4.6 MB timestamped May 9.
 
Any suggestions? Thank you again.
 
Rocky

From: Andy Shellam [mailto:andy.shellam@mailnetwork.co.uk]
Sent: Mon 5/15/2006 10:53 AM
To: Xu, Xiaoyi (Rocky) FSM
Cc: pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Error in MS Access

I take it you’ve checked your server?  i.e. disk space, available memory, state of the postgresql service?

 

If you provide some more info, such as the platform you’re running the server on, server version, ODBC driver version etc, we could help more.

 

Andy

 


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Xu, Xiaoyi (Rocky) FSM
Sent: 15 May 2006 4:39 pm
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Error in MS 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 front-end Access. Could anyone shed some light on this? Thank you.

Rocky



!DSPAM:14,4468a0ca34491802220264!

pgsql-admin by date:

Previous
From: Tom Arthurs
Date:
Subject: Re: does wal archiving block the current client connection?
Next
From: Tom Lane
Date:
Subject: Re: does wal archiving block the current client connection?