pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedError in MS Access
8+ messages / 4 participants
[nested] [flat]
* Error in MS Access
@ 2006-05-15 15:38 Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 15:53 ` Re: Error in MS Access Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-05-15 15:54 ` Re: Error in MS Access Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 2 replies; 8+ messages in thread
From: Xu, Xiaoyi \(Rocky\) FSM @ 2006-05-15 15:38 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 front-end Access. Could anyone shed some light on this?
Thank you.
Rocky
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error in MS Access
2006-05-15 15:38 Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
@ 2006-05-15 15:53 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-05-15 17:56 ` Re: Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
1 sibling, 1 reply; 8+ messages in thread
From: Andy Shellam @ 2006-05-15 15:53 UTC (permalink / raw)
To: 'Xu, Xiaoyi \(Rocky\) FSM' <xyxu@northwestern.edu>; +Cc: pgsql-admin
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!
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error in MS Access
2006-05-15 15:38 Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 15:53 ` Re: Error in MS Access Andy Shellam <andy.shellam@mailnetwork.co.uk>
@ 2006-05-15 17:56 ` Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 19:42 ` Re: Error in MS Access Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 8+ messages in thread
From: Xu, Xiaoyi \(Rocky\) FSM @ 2006-05-15 17:56 UTC (permalink / raw)
To: andy.shellam@mailnetwork.co.uk; +Cc: 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!
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error in MS Access
2006-05-15 15:38 Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 15:53 ` Re: Error in MS Access Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-05-15 17:56 ` Re: Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
@ 2006-05-15 19:42 ` Jim C. Nasby <jnasby@pervasive.com>
2006-05-15 19:55 ` Re: Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 20:16 ` Re: Error in MS Access Joshua D. Drake <jd@commandprompt.com>
0 siblings, 2 replies; 8+ messages in thread
From: Jim C. Nasby @ 2006-05-15 19:42 UTC (permalink / raw)
To: Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>; +Cc: andy.shellam@mailnetwork.co.uk; pgsql-admin
On Mon, May 15, 2006 at 12:56:16PM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
> Thank you Andy.
>
> The server is SunOS 5.8 Generic_117350-29 ultra-250. The db is version 7.
7.what?
> 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.
Be *VERY* careful about deleting anything in $PGDATA. A file called
pg_log is probably safe, but you never know...
4.6MB certainly isn't going to get you very far. How large is /home0?
How large is the database? How often have you been vacuuming?
--
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] 8+ messages in thread
* Re: Error in MS Access
2006-05-15 15:38 Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 15:53 ` Re: Error in MS Access Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-05-15 17:56 ` Re: Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 19:42 ` Re: Error in MS Access Jim C. Nasby <jnasby@pervasive.com>
@ 2006-05-15 19:55 ` Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 20:13 ` Re: Error in MS Access Jim C. Nasby <jnasby@pervasive.com>
1 sibling, 1 reply; 8+ messages in thread
From: Xu, Xiaoyi \(Rocky\) FSM @ 2006-05-15 19:55 UTC (permalink / raw)
To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: andy.shellam@mailnetwork.co.uk; pgsql-admin
Jim,
I will find out the detailed version. Meanwhile /home0 is around 8.6 GB.
I don't know how large the DB is. Which file or which command I should
look for? About vacuuming, I don't know either. Can I do vacuuming while
making DB online? I am helping an internal department whose IT person
left and for 5 months no one ever managed this Solaris box. All of
sudden database users began to experience problems with an in-house
application.
Thank you again and I really appreciate all your help and other's help
from this community.
Rocky
-----Original Message-----
From: Jim C. Nasby [mailto:jnasby@pervasive.com]
Sent: Monday, May 15, 2006 2:42 PM
To: Xu, Xiaoyi (Rocky) FSM
Cc: andy.shellam@mailnetwork.co.uk; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Error in MS Access
On Mon, May 15, 2006 at 12:56:16PM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
> Thank you Andy.
>
> The server is SunOS 5.8 Generic_117350-29 ultra-250. The db is version
7.
7.what?
> 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.
Be *VERY* careful about deleting anything in $PGDATA. A file called
pg_log is probably safe, but you never know...
4.6MB certainly isn't going to get you very far. How large is /home0?
How large is the database? How often have you been vacuuming?
--
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] 8+ messages in thread
* Re: Error in MS Access
2006-05-15 15:38 Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 15:53 ` Re: Error in MS Access Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-05-15 17:56 ` Re: Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 19:42 ` Re: Error in MS Access Jim C. Nasby <jnasby@pervasive.com>
2006-05-15 19:55 ` Re: Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
@ 2006-05-15 20:13 ` Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 0 replies; 8+ messages in thread
From: Jim C. Nasby @ 2006-05-15 20:13 UTC (permalink / raw)
To: Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>; +Cc: andy.shellam@mailnetwork.co.uk; pgsql-admin
On Mon, May 15, 2006 at 02:55:04PM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
> Jim,
>
> I will find out the detailed version. Meanwhile /home0 is around 8.6 GB.
> I don't know how large the DB is. Which file or which command I should
> look for? About vacuuming, I don't know either. Can I do vacuuming while
> making DB online? I am helping an internal department whose IT person
> left and for 5 months no one ever managed this Solaris box. All of
> sudden database users began to experience problems with an in-house
> application.
If it's anything newer than 7.2 (and I really hope it's a *lot* newer
than that), then yes, you can vacuum without locking users out. I know
that at some point you couldn't do that, but I don't know how long ago
that was since I started using PostgreSQL at version 7.2.
I suspect that no one has been vacuuming the database and that it now
has scads of dead rows. It's surprising users haven't been screaming
about it being slow before now if that's the case.
If you search for 'vacuum' at
http://www.pervasivepostgres.com/instantkb13/search.aspx you'll find
some articles that might help you.
--
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] 8+ messages in thread
* Re: Error in MS Access
2006-05-15 15:38 Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 15:53 ` Re: Error in MS Access Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-05-15 17:56 ` Re: Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 19:42 ` Re: Error in MS Access Jim C. Nasby <jnasby@pervasive.com>
@ 2006-05-15 20:16 ` Joshua D. Drake <jd@commandprompt.com>
1 sibling, 0 replies; 8+ messages in thread
From: Joshua D. Drake @ 2006-05-15 20:16 UTC (permalink / raw)
To: Jim C. Nasby <jnasby@pervasive.com>; +Cc: Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>; andy.shellam@mailnetwork.co.uk; pgsql-admin
Jim C. Nasby wrote:
> On Mon, May 15, 2006 at 12:56:16PM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
>> Thank you Andy.
>>
>> The server is SunOS 5.8 Generic_117350-29 ultra-250. The db is version 7.
>
> 7.what?
>
>> 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.
>
> Be *VERY* careful about deleting anything in $PGDATA. A file called
> pg_log is probably safe, but you never know...
Well pg_log is the default logging location of PostgreSQL as of 8.1 (if
it is not logging to syslog), thus anything within there *should* be safe.
However, Jim is correct... be very, very careful in that directory.
>
> 4.6MB certainly isn't going to get you very far. How large is /home0?
> How large is the database? How often have you been vacuuming?
Joshua D. drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Error in MS Access
2006-05-15 15:38 Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
@ 2006-05-15 15:54 ` Jim C. Nasby <jnasby@pervasive.com>
1 sibling, 0 replies; 8+ messages in thread
From: Jim C. Nasby @ 2006-05-15 15:54 UTC (permalink / raw)
To: Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>; +Cc: pgsql-admin
On Mon, May 15, 2006 at 10:38:47AM -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)
Does the command work when you try it from psql?
Someone on the ODBC or interfaces list might be better able to help,
btw.
--
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] 8+ messages in thread
end of thread, other threads:[~2006-05-15 20:16 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-15 15:38 Error in MS Access Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 15:53 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>
2006-05-15 17:56 ` Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 19:42 ` Jim C. Nasby <jnasby@pervasive.com>
2006-05-15 19:55 ` Xu, Xiaoyi (Rocky) FSM <xyxu@northwestern.edu>
2006-05-15 20:13 ` Jim C. Nasby <jnasby@pervasive.com>
2006-05-15 20:16 ` Joshua D. Drake <jd@commandprompt.com>
2006-05-15 15:54 ` 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