473,889 Members | 1,674 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

no space left on device

I'm running Postgres 7.1.3, and just started having a problem where my
dynamic site is going down (read-only DB, with no writes happening to the
DB) regularly (every other day). I have no idea whay this is happening,
and my search of the FAQ's and mail list don't bring up anything. i've
attached the error from the log file, at the end of this message.

Here's an output of the disk usage from within the DB dir

[postgres - DB]$ du -k .
1716 ./base/1
1716 ./base/16555
5192 ./base/56048
8628 ./base
116 ./global
32812 ./pg_xlog
11380 ./pg_clog
53192 .

Note that the pg_xlog dir is huge! Here's its contents:

[postgres - DB/pg_xlog]$ ls -al
total 32816
drwx------ 2 postgres admin 4096 Mar 29 2003 .
drwx------ 6 postgres admin 4096 Jan 9 15:04 ..
-rwx------ 1 postgres admin 16777216 Jan 9 15:09 000000000000000 1
-rwx------ 1 postgres admin 16777216 Mar 29 2003 000000000000000 2

What are these files, and what can I do to resolve this issue?

Thx,

Zeb
--
DEBUG: statistics collector process (pid 2523) exited with exit code 1
PGSTAT: Error closing temp stats file
PGSTAT: /usr/local/G101/App/DB/./global/pgstat.tmp.7823 : No space left on
device
PGSTAT: AbDEBUG: statistics collector process (pid 2979) exited with exit
code
1
FATAL 2: write of clog file 43, offset 188416 failed: No space left on
device
DEBUG: server process (pid 3741) exited with exit code 2
DEBUG: terminating any other active server processes
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
DEBUG: all server processes terminated; reinitializing shared memory and
semaph
ores
DEBUG: database system was interrupted at 2004-01-09 05:22:52 EST
DEBUG: checkpoint record is at 0/138CFD4
DEBUG: redo record is at 0/138CFD4; undo record is at 0/0; shutdown FALSE
DEBUG: next transaction id: 45811837; next oid: 65205
DEBUG: database system was not properly shut down; automatic recovery in
progre
ss
DEBUG: redo starts at 0/138D014
FATAL 2: write of clog file 43, offset 188416 failed: No space left on
device
DEBUG: startup process (pid 3785) exited with exit code 2
DEBUG: aborting startup due to startup process failure

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05
27 20076
On Fri, 9 Jan 2004, Tom Lane wrote:
"scott.marl owe" <sc***********@ ihs.com> writes:
[postgres - DB]$ df -m .
Filesystem 1M-blocks Used Available Use% Mounted on
- 63328 55308 4803 93% /

Do you have root access to it? if so, set the reserved space for root to
be 0%, and then try vacuuming. Vacuuming requires some free space, and
since you're pretty much out, it isn't gonna be able to complete.


Look again --- it's showing free space in MB not KB. He's got 4.8GB
free. (Although that might be free-from-root's-point-of-view, rather
than what an unprivileged user can use ...)


Good catch. I'm so used to using raw df output...

Yeah, it looks like root's reserved space is getting him to me, but since
it's the root partition, it's possible it's out of inodes as well.

Aurangzeb, try running df -i to see how many inodes you have left...
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 12 '05 #21
On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote:
Right! Thus my quandry.

Re inodes, how can I check this? But why would this be? Is Postgres
sucking up inodes just sitting there as a read-only DB?


If you are out of inodes, I seriously doubt it is Postgresql's fault, as
you seem to be running everything on the root partition here, it could be
any other process more likely than postgresql is using all the inodes.
Basically, when you make a lot of small files you can run out of inodes.
Since postgresql tends to make a few rather large files, it's usually not
a concern.

df -i shows inode usage.

On linux, you can change the % reserved for root to 1% with tune2fs:

tune2fs -m 1

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #22
I would suspect some *other* service is using the 4G for transient
storage every now and again, and it just so happens that Pg is getting
tripped up.

What else does this machine run ?

regards

Mark

Nigel J. Andrews wrote:
On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote:
Here's the output of "df -m":

[postgres - DB]$ df -m .
Filesystem 1M-blocks Used Available Use% Mounted on
- 63328 55308 4803 93% /


But your du, below, of the postgres data directory shows 53MB in use. That's an
order of magnitude smaller than the 55GB the above appears to be saying is used
in the db.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 12 '05 #23
On Fri, 9 Jan 2004, scott.marlowe wrote:
On Fri, 9 Jan 2004, Aurangzeb M. Agha wrote:
Right! Thus my quandry.

Re inodes, how can I check this? But why would this be? Is Postgres
sucking up inodes just sitting there as a read-only DB?
If you are out of inodes, I seriously doubt it is Postgresql's fault, as
you seem to be running everything on the root partition here, it could be
any other process more likely than postgresql is using all the inodes.
Basically, when you make a lot of small files you can run out of inodes.


And a common culprit is whatever is being used for usenet caching/serving...or
ordinary mail which is just accumulating in /var/mail (or whereever).

Since postgresql tends to make a few rather large files, it's usually not
a concern.

df -i shows inode usage.

On linux, you can change the % reserved for root to 1% with tune2fs:

tune2fs -m 1


--
Nigel J. Andrews
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #24

On Sat, 10 Jan 2004, Nigel J. Andrews wrote:
And a common culprit is whatever is being used for usenet caching/serving...or
ordinary mail which is just accumulating in /var/mail (or whereever).


Sheesh. Did I really put ordinary mailbox mail in the uses up inodes category?
I should taken out and whi....errrr... on the other hand better not might be too
exciting for some and spark off a whole new xxx web site.
Nigel Andrews
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #25
On Sat, Jan 10, 2004 at 00:38:43 +0000,
"Nigel J. Andrews" <na******@inves tsystems.co.uk> wrote:

On Sat, 10 Jan 2004, Nigel J. Andrews wrote:
And a common culprit is whatever is being used for usenet caching/serving...or
ordinary mail which is just accumulating in /var/mail (or whereever).


Sheesh. Did I really put ordinary mailbox mail in the uses up inodes category?
I should taken out and whi....errrr... on the other hand better not might be too
exciting for some and spark off a whole new xxx web site.


While mbox mailboxes only take one inode per mailbox, maildir mailboxes take
one inode per message. So if you are using maildir you could potentially
use a significant number of inodes for email.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 12 '05 #26
na******@invest systems.co.uk ("Nigel J. Andrews") writes:
On Sat, 10 Jan 2004, Nigel J. Andrews wrote:
And a common culprit is whatever is being used for usenet caching/serving...or
ordinary mail which is just accumulating in /var/mail (or whereever).


Sheesh. Did I really put ordinary mailbox mail in the uses up inodes category?
I should taken out and whi....errrr... on the other hand better not might be too
exciting for some and spark off a whole new xxx web site.


Mail accumulating in "mbox" spools shouldn't chew up inodes too badly,
but if you're using "Maildir" to spool mail, whether incoming or
outgoing, it sure can...
--
let name="cbbrowne" and tld="libertyrms .info" in String.concat "@" [name;tld];;
<http://dev6.int.libert yrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)
Nov 12 '05 #27
On Fri, 9 Jan 2004, Tom Lane wrote:

:"scott.marlowe " <sc***********@ ihs.com> writes:
:>> [postgres - DB]$ df -m .
:>> Filesystem 1M-blocks Used Available Use% Mounted on
:>> - 63328 55308 4803 93% /
:
:> Do you have root access to it? if so, set the reserved space for root to
:> be 0%, and then try vacuuming. Vacuuming requires some free space, and
:> since you're pretty much out, it isn't gonna be able to complete.
:
:Look again --- it's showing free space in MB not KB. He's got 4.8GB
:free. (Although that might be free-from-root's-point-of-view, rather
:than what an unprivileged user can use ...)

Tom -- You're right here. This account is running on a virtual server, so
the 4.8GB free is not for this user.

Re i-nodes:

[admin - temp]$ df -i .
Filesystem Inodes IUsed IFree IUse% Mounted on
- 8241152 1819166 6421986 23% /

However, I did just get word from the ISP that they had some sort of error
log rotation error which was keeping logs from being deleted off the
machine, taking up a lot of space (for this user account). So the 93% is
aparently not a good representation of the disk usage, as its not for this
specific user account.

Rgs,

Zeb
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #28

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
7597
by: Yasaswi Pulavarti | last post by:
does a command like, db2 drop table tabschema.tabname when run from the Aix prompt reclaim the disk space? Are there any other options? How can we make sure the disk space is reclaimed? Thanks, Yasaswi
9
1425
by: James Harris | last post by:
I'm wanting to write in C some code in which it is necessary to address a device as I/O space rather than as part of memory. I would like the code to be as standard - and hence as portable - as possible. It's intended to be later ported to other hardware. Options? 1) Set up some inline assembler in a header file. I believe I'd need to use the asm keyword but that this isn't ansi C. Is that correct? 2) Write a separate routine in...
1
2170
by: sir_alex | last post by:
Is there any function to see how much space is left on a device (such as a usb key)? I'm trying to fill in an mp3 reader in a little script, and this information could be very useful! Thanks!
28
1927
by: Alan Silver | last post by:
Hello, Here I am again with another "why does IE do that" question!! Please have a look at http://www.kidsinaction.org.uk/fd/homepage.html and see if you can work out why IE adds a one pixel white space on the left and right side of the links with the light-green backgrounds. It doesn't do it on the header links, which have darker green backgrounds. FF and Opera don't add the pixel at all, which is what I would expect as
8
15019
by: maroger | last post by:
I'm sure this is a common issue, but I haven't come across anything that works for me thusfar. I am trying to fix my header, which works fine in firefox but has extra space in IE. Here are example html and css files that illustrate my problem: http://torch.cs.dal.ca/~mroger/css/ietest.html http://torch.cs.dal.ca/~mroger/css/styles.css I would like to get both browsers to display the page as firefox does. That is, with no space...
4
2348
by: bill_nirl | last post by:
Hi all, can anyone help. i have a spreasheet (set up by a looney) they have in the surname field, the surname then forename. What sort of code would i need to use to sort this out. It looks like this: |Smith Bill |14 Any Street| |Doe John |19 High Stree| and so on (there are 7891 of them). Would make life a lot easier to
12
7236
by: JA | last post by:
Is there a way to remove all the white space in the fields? I have been using Find-and-replace - looking for 2 or 3 or 4 or 10 spaces and replacing them with none. I don't want to replace single spaces, those are the spaces between the words. But most of what is in the fields has been cut-n-pasted from online forms, and the results can be VERY spread out. I could probably save 80% of the space if I could get rid of the extra white space....
5
6239
by: mostro713 | last post by:
Hello all, I would like to write a script in Python to email me when disk space gets below a certain value. My first question (I'm sure of many) is how do get this output into a dictionary or list to index the values? import os os.system("df -x cifs -x iso9660 | grep -E ^/dev | awk '{ print
1
2293
by: ismailc | last post by:
Hi, I've changed an existing xslt file, i found this css file but now the css object is not aligned with the other objects - i checked the other objects they are calling templates. I have added the code in <td align-'left'> but the objects are out by a space to the css object i added: How do i add a space/move the select box up by a space!, not the text of the selectbox but the entire object The CSS File
0
9810
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11203
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10794
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10896
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10443
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7999
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6029
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4650
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3257
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.