No space left on device - Mailing list pgsql-admin

From Veera Sivakumar
Subject No space left on device
Date
Msg-id D8F3C53102701449A7564D2F69EBEB4DAA4D13@ex-mail2.internal.rmplc.net
Whole thread Raw
Responses Re: No space left on device
Re: No space left on device
Re: No space left on device
List pgsql-admin

Hi
I am using Postgres Database  version 7.3.1.
I am getting following error when I am starting postmaster. I could not be able to start the postmaster.
Pl help me

Regard
Shiva Kumar

LOG:  database system was shut down at 2005-02-03 05:35:03 GMTST
LOG:  checkpoint record is at 0/B9C0C0
LOG:  redo record is at 0/B9C0C0; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 11687; next oid: 34453
LOG:  database system is ready
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
WARNING:  ROLLBACK: no transaction in progress
PANIC:  ZeroFill failed to write /usr/share/postgresql/data/pg_xlog/xlogtemp.3452: No space left on device
Stack trace:
Frame     Function  Args
0022CA78  7C4F1B1B  (00000000, 00000001, 00000000, 5C676F6C)
0022CAE8  61073C3B  (00000000, 0022CB20, 0022C000, 61079DD9)
0022CB38  6107109A  (00000D7C, 00000006, 0022CB98, 61073331)
0022CB88  610712B2  (00000D7C, 00000006, 0022CBD8, 610717EA)
0022CB98  6107115C  (00000006, 00000006, 00231378, 0022CDD8)
0022CBD8  610717EA  (610C0370, 0022CC30, 0000006B, 0022CDD8)
0022CDC8  0059BEF2  (00000016, 00427680, 0022EE00, 005C2490)
0022F618  004278B1  (00000000, 00000001, 0022F637, 00000001)
0022F638  00427D2C  (00000000, 00C02598, 00000000, 00002000)
0022F6B8  0042C015  (00000000, 00000000, 00000000, 00000003)
0022F6E8  00430F46  (00000005, 0022F7C0, 00000040, 77F89964)
0022F9D8  0050E975  (00000003, 005FAE00, 00000000, 0022F8A4)
0022FA58  0050BFB5  (00000002, 00000001, 00000000, 0A0467A0)
0022FEB8  0050B327  (00000004, 0A0403E0, 7C4E91AA, 00000001)
0022FEF0  004DBB2E  (00000004, 615E0644, 0A040328, 0022FF24)
0022FF40  61007418  (610C3A28, FFFFFFFE, 000003D4, 610C394C)
End of stack trace (more stack frames may be present)LOG:  server process (pid 3452) was terminated by signal 6
LOG:  terminating any other active server processes
WARNING:  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.
WARNING:  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.
LOG:  all server processes terminated; reinitializing shared memory and semaphores
IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not enough core

This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space.
To reduce the request size (currently 1441792 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).

The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.

LOG:  database system was interrupted at 2004-02-09 12:22:12 GMTST
LOG:  checkpoint record is at 0/C02558
LOG:  redo record is at 0/C02558; undo record is at 0/0; shutdown FALSE
LOG:  next transaction id: 11988; next oid: 42645
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  ReadRecord: record with zero length at 0/C02598
LOG:  redo is not required
0022AAD8  7C4F1B1B  (00000000LOG:  startup process (pid 4608) was terminated by signal 6
LOG:  aborting startup due to startup process failure
LOG:  database system was shut down at 2004-02-09 12:26:17 GMTST
LOG:  checkpoint record is at 0/C02598
LOG:  redo record is at 0/C02598; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 11988; next oid: 42645
PANIC:  ZeroFill failed to write /usr/share/postgresql/data/pg_xlog/xlogtemp.2816: No space left on device
Stack trace:
Frame     Function  Args
0022AAD8  7C4F1B1B  (00000000, 00000001, 00000000, 5C676F6C)
0022AB48  61073C3B  (00000000, 0022AB80, 0022A000, 61079DD9)
0022AB98  6107109A  (00000B00, 00000006, 0022ABF8, 61073331)
0022ABE8  610712B2  (00000B00, 00000006, 0022AC38, 610717EA)
0022ABF8  6107115C  (00000006, 00000006, 00000000, 0022AE38)
0022AC38  610717EA  (610C0370, 0022AC90, 0000006B, 0022AE38)
0022AE28  0059BEF2  (00000016, 00427680, 0022CE60, 005C2490)
0022D678  004278B1  (00000000, 00000001, 0022D697, 00000001)
0022D698  00427D2C  (00000000, 00C025D8, 00001A28, 0000A695)
0022F738  0042B0BC  (00000001, 005FADF0, 00000000, 00000003)
0022F768  00430EE4  (00000005, 0022F840, 00000040, 6107F684)
0022FA58  0050E975  (00000002, 00000001, 00000000, 0A0467A0)
0022FEB8  0050B31D  (00000004, 0A0403E0, 7C4E91AA, 00000001)
0022FEF0  004DBB2E  (00000004, 615E0644, 0A040328, 0022FF24)
0022FF40  61007418  (610C3A28, FFFFFFFE, 000003D4, 610C394C)
0022FF90  610076FD  (00000000, 00000000, FFFFFFFF, 80430D04)
End of stack trace (more stack frames may be present)LOG:  startup process (pid 2816) was terminated by signal 6
LOG:  aborting startup due to startup process failure
LOG:  database system was shut down at 2004-02-09 12:26:17 GMTST
LOG:  checkpoint record is at 0/C02598
LOG:  redo record is at 0/C02598; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 11988; next oid: 42645
FATAL:  The database system is starting up
FATAL:  The database system is starting up
PANIC:  ZeroFill failed to write /usr/share/postgresql/data/pg_xlog/xlogtemp.2704: No space left on device
Stack trace:
Frame     Function  Args
0022AAD8  7C4F1B1B  (00000000, 00000001, 00000000, 5C676F6C)
0022AB48  61073C3B  (00000000, 0022AB80, 0022A000, 61079DD9)
0022AB98  6107109A  (00000A90, 00000006, 0022ABF8, 61073331)
0022ABE8  610712B2  (00000A90, 00000006, 0022AC38, 610717EA)
0022ABF8  6107115C  (00000006, 00000006, 00000000, 0022AE38)
0022AC38  610717EA  (610C0370, 0022AC90, 0000006B, 0022AE38)
0022AE28  0059BEF2  (00000016, 00427680, 0022CE60, 005C2490)
0022D678  004278B1  (00000000, 00000001, 0022D697, 00000001)
0022D698  00427D2C  (00000000, 00C025D8, 00001A28, 0000A695)
0022F738  0042B0BC  (00000001, 005FADF0, 00000000, 00000003)
0022F768  00430EE4  (00000005, 0022F840, 00000040, 6107F684)
0022FA58  0050E975  (00000002, 00000001, 00000000, 0A0467A0)
0022FEB8  0050B31D  (00000004, 0A0403E0, 7C4E91AA, 00000001)
0022FEF0  004DBB2E  (00000004, 615E0644, 0A040328, 0022FF24)
0022FF40  61007418  (610C3A28, FFFFFFFE, 000003D4, 610C394C)
0022FF90  610076FD  (00000000, 00000000, FFFFFFFF, 80430D04)
End of stack trace (more stack frames may be present)LOG:  startup process (pid 2704) was terminated by signal 6
LOG:  aborting startup due to startup process failure
LOG:  database system was shut down at 2004-02-09 12:26:17 GMTST
LOG:  checkpoint record is at 0/C02598
LOG:  redo record is at 0/C02598; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 11988; next oid: 42645
PANIC:  ZeroFill failed to write /usr/share/postgresql/data/pg_xlog/xlogtemp.2056: No space left on device
Stack trace:
Frame     Function  Args
0022AAD8  7C4F1B1B  (00000000, 00000001, 00000000, 5C676F6C)
0022AB48  61073C3B  (00000000, 0022AB80, 0022A000, 61079DD9)
0022AB98  6107109A  (00000808, 00000006, 0022ABF8, 61073331)
0022ABE8  610712B2  (00000808, 00000006, 0022AC38, 610717EA)
0022ABF8  6107115C  (00000006, 00000006, 00000000, 0022AE38)
0022AC38  610717EA  (610C0370, 0022AC90, 0000006B, 0022AE38)
0022AE28  0059BEF2  (00000016, 00427680, 0022CE60, 005C2490)
0022D678  004278B1  (00000000, 00000001, 0022D697, 00000001)
0022D698  00427D2C  (00000000, 00C025D8, 00001A28, 0000A695)
0022F738  0042B0BC  (00000001, 005FADF0, 00000000, 00000003)
0022F768  00430EE4  (00000005, 0022F840, 00000040, 6107F684)
0022FA58  0050E975  (00000002, 00000001, 00000000, 0A0467A0)
0022FEB8  0050B31D  (00000004, 0A0403E0, 7C4E91AA, 00000001)
0022FEF0  004DBB2E  (00000004, 615E0644, 0A040328, 0022FF24)
0022FF40  61007418  (610C3A28, FFFFFFFE, 000003D4, 610C394C)
0022FF90  610076FD  (00000000, 00000000, FFFFFFFF, 80430D04)
End of stack trace (more stack frames may be present)LOG:  startup process (pid 2056) was terminated by signal 6
LOG:  aborting startup due to startup process failure
LOG:  database system was shut down at 2004-02-09 12:26:17 GMTST
LOG:  checkpoint record is at 0/C02598
LOG:  redo record is at 0/C02598; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 11988; next oid: 42645
PANIC:  ZeroFill failed to write /usr/share/postgresql/data/pg_xlog/xlogtemp.2056: No space left on device
Stack trace:
Frame     Function  Args
0022AAD8  7C4F1B1B  (00000000, 00000001, 00000000, 5C676F6C)
0022AB48  61073C3B  (00000000, 0022AB80, 0022A000, 61079DD9)
0022AB98  6107109A  (00000808, 00000006, 0022ABF8, 61073331)
0022ABE8  610712B2  (00000808, 00000006, 0022AC38, 610717EA)
0022ABF8  6107115C  (00000006, 00000006, 00000000, 0022AE38)
0022AC38  610717EA  (610C0370, 0022AC90, 0000006B, 0022AE38)
0022AE28  0059BEF2  (00000016, 00427680, 0022CE60, 005C2490)
0022D678  004278B1  (00000000, 00000001, 0022D697, 00000001)
0022D698  00427D2C  (00000000, 00C025D8, 00001A28, 0000A695)
0022F738  0042B0BC  (00000001, 005FADF0, 00000000, 00000003)
0022F768  00430EE4  (00000005, 0022F840, 00000040, 6107F684)
0022FA58  0050E975  (00000002, 00000001, 00000000, 0A0467A0)
0022FEB8  0050B31D  (00000004, 0A0403E0, 7C4E91AA, 00000001)
0022FEF0  004DBB2E  (00000004, 615E0644, 0A040328, 0022FF24)
0022FF40  61007418  (610C3A28, FFFFFFFE, 000003D4, 610C394C)
0022FF90  610076FD  (00000000, 00000000, FFFFFFFF, 80430D04)
End of stack trace (more stack frames may be present)LOG:  startup process (pid 2056) was terminated by signal 6
LOG:  aborting startup due to startup process failure
LOG:  database system was shut down at 2004-02-09 12:26:17 GMTST
LOG:  checkpoint record is at 0/C02598
LOG:  redo record is at 0/C02598; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 11988; next oid: 42645
PANIC:  ZeroFill failed to write /usr/share/postgresql/data/pg_xlog/xlogtemp.4504: No space left on device
Stack trace:
Frame     Function  Args
0022AAD8  7C4F1B1B  (00000000, 00000001, 00000000, 5C676F6C)
0022AB48  61073C3B  (00000000, 0022AB80, 0022A000, 61079DD9)
0022AB98  6107109A  (00001198, 00000006, 0022ABF8, 61073331)
0022ABE8  610712B2  (00001198, 00000006, 0022AC38, 610717EA)
0022ABF8  6107115C  (00000006, 00000006, 00000000, 0022AE38)
0022AC38  610717EA  (610C0370, 0022AC90, 0000006B, 0022AE38)
0022AE28  0059BEF2  (00000016, 00427680, 0022CE60, 005C2490)
0022D678  004278B1  (00000000, 00000001, 0022D697, 00000001)
0022D698  00427D2C  (00000000, 00C025D8, 00001A28, 0000A695)
0022F738  0042B0BC  (00000001, 005FADF0, 00000000, 00000003)
0022F768  00430EE4  (00000005, 0022F840, 00000040, 6107F684)
0022FA58  0050E975  (00000002, 00000001, 00000000, 0A0467A0)
0022FEB8  0050B31D  (00000004, 0A0403E0, 7C4E91AA, 00000001)
0022FEF0  004DBB2E  (00000004, 615E0644, 0A040328, 0022FF24)
0022FF40  61007418  (610C3A28, FFFFFFFE, 000003D4, 610C394C)
0022FF90  610076FD  (00000000, 00000000, FFFFFFFF, 80430D04)
End of stack trace (more stack frames may be present)LOG:  startup process (pid 4504) was terminated by signal 6
LOG:  aborting startup due to startup process failure

Visit our website at www.rm.com

This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply the information only for the intended purpose. Internet communications are not secure and therefore RM does not accept legal responsibility for the contents of this message. Any views or opinions presented are only those of the author and not those of RM. If this email has come to you in error please delete it and any attachments. Please note that RM may intercept incoming and outgoing e-mail communications.

This email has been scanned for viruses by Trend ScanMail.

pgsql-admin by date:

Previous
From: hehe88hk@yahoo.com.hk (Eric)
Date:
Subject: Showing all groups
Next
From: Ericson Smith
Date:
Subject: Looking for Developer with Postgresql experience