PROTECTED]
To: Stefan Kaltenbrunner [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; pgsql-bugs@postgresql.org
Sent: Tuesday, April 08, 2008 12:37 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
The df was made while the error messages occured and the scripts were
).
- Original Message -
From: Stefan Kaltenbrunner [EMAIL PROTECTED]
To: J6M [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; pgsql-bugs@postgresql.org
Sent: Monday, April 07, 2008 8:31 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
J6M wrote:
OK. So why did
The following bug has been logged online:
Bug reference: 4096
Logged by:
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: Linux
Description:PG 8.3.1. confused about remaining disk space
Details:
I ran today a legacy application with PG
[EMAIL PROTECTED] napsal(a):
I ran today a legacy application with PG 8.3.1 on a test machine.
The DB is some ~30 MB. Default tables do have OIDs and BLCKSZ is set
system-wide to 16384 (because of another DB).
Can you tried your application with standard BLKSZ? Or Can you send testcase?
Zdenek Kotala [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] napsal(a):
relation 1663/19693/634162: No space left on device
...
Disk saturation, you think ? No at all, as in the meantime :
FilesystemSize Used Avail Use% Mounted on
/dev/sda3 9.9G 8.5G 874M 91% /
- Original Message -
From: Zdenek Kotala [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: pgsql-bugs@postgresql.org
Sent: Monday, April 07, 2008 12:51 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
[EMAIL PROTECTED] napsal(a):
I ran today a legacy
- Original Message -
From: Gregory Stark [EMAIL PROTECTED]
To: Zdenek Kotala [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; pgsql-bugs@postgresql.org
Sent: Monday, April 07, 2008 1:14 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
Also check df -i
[EMAIL PROTECTED] writes:
A lot of messages like these do appear wich tend to indicate PG 8.3.1 is
confused. This set of SQL scripts used to run from PG 7.0.3 to PG 8.2.6 with
no problem.
WARNING: could not create relation-cache initialization file
base/19693/pg_internal.init.29329: No
-bugs@postgresql.org
Sent: Monday, April 07, 2008 4:09 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
[EMAIL PROTECTED] writes:
A lot of messages like these do appear wich tend to indicate PG 8.3.1 is
confused. This set of SQL scripts used to run from PG 7.0.3
Linux estp-intranet 2.6.22.5-31-default #1 SMP 2007/09/21 22:29:00 UTC i686
i686 i386 GNU/Linux
How can I precisely answer to the reiserfs version question ?
(Although I presume the 2005 fix mentioned in the link you provided has been
applied, as OpenSuSE 10.3 was published on the 4th of
:
Set flags in SB:
ATTRIBUTES CLEAN
- Original Message -
From: J6M [EMAIL PROTECTED]
To: Gregory Stark [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; pgsql-bugs@postgresql.org
Sent: Monday, April 07, 2008 5:50 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining
Sorry, this is the URL I meant to send:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg19905.html
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To
J6M wrote:
OK. So why did this not occur when I was running 8.2.6 ?
I would advise to install some very detailed monitoring on your
diskspace usage and look for spikes that correlate with your database
errors -. I have seen this issue with bad queries that are resulting in
enormous on-disk
13 matches
Mail list logo