BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi

From: digoal(at)126(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10013: PostgreSQL 9.4 initdb FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on devi
Date: 2014-04-14 01:44:42
Message-ID: 20140414014442.15385.74268@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 10013
Logged by: digoal.zhou
Email address: digoal(at)126(dot)com
PostgreSQL version: Unsupported/Unknown
Operating system: CentOS 6.4 x64
Description:

I use recent postgresql snapshot from
http://git.postgresql.org/gitweb/?p=postgresql.git;a=snapshot;h=e0c91a7ff015fab0ccbb0f75b6819f29ae00295e;sf=tgz
but when initdb, error reported.

pg94(at)db-172-16-3-150-> df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sdc1 29G 9.0G 19G 33% /
tmpfs 48G 0 48G 0% /dev/shm
/dev/sdc3 98G 29G 64G 31% /opt
/dev/sdd1 183G 32G 143G 19% /ssd1
/dev/sda1 221G 7.5G 202G 4% /ssd3
/dev/sdb1 221G 36G 174G 18% /ssd4
pg94(at)db-172-16-3-150-> df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sdc1 1921360 199173 1722187 11% /
tmpfs 12381887 1 12381886 1% /dev/shm
/dev/sdc3 6479872 442050 6037822 7% /opt
/dev/sdd1 12173312 1479 12171833 1% /ssd1
/dev/sda1 14655488 2313 14653175 1% /ssd3
/dev/sdb1 14655488 2095 14653393 1% /ssd4

pg94(at)db-172-16-3-150-> initdb -D /home/pg94/pg_root --debug
Running in debug mode.
The files belonging to this database system will be owned by user "pg94".
This user must also own the server process.

VERSION=9.4devel
PGDATA=/home/pg94/pg_root
share_path=/home/pg94/pgsql9.4devel/share
PGPATH=/home/pg94/pgsql9.4devel/bin
POSTGRES_SUPERUSERNAME=pg94
POSTGRES_BKI=/home/pg94/pgsql9.4devel/share/postgres.bki
POSTGRES_DESCR=/home/pg94/pgsql9.4devel/share/postgres.description
POSTGRES_SHDESCR=/home/pg94/pgsql9.4devel/share/postgres.shdescription
POSTGRESQL_CONF_SAMPLE=/home/pg94/pgsql9.4devel/share/postgresql.conf.sample
PG_HBA_SAMPLE=/home/pg94/pgsql9.4devel/share/pg_hba.conf.sample
PG_IDENT_SAMPLE=/home/pg94/pgsql9.4devel/share/pg_ident.conf.sample
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /home/pg94/pg_root ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
creating template1 database in /home/pg94/pg_root/base/1 ... DEBUG:
invoking IpcMemoryCreate(size=152027136)
DEBUG: SlruScanDirectory invoking callback on pg_notify/0000
DEBUG: removing file "pg_notify/0000"
DEBUG: dynamic shared memory system will support 288 segments
DEBUG: created dynamic shared memory control segment 1804289383 (2316
bytes)
DEBUG: transaction ID wrap limit is 2147483650, limited by database with
OID 1
DEBUG: MultiXactId wrap limit is 2147483648, limited by database with OID
1
DEBUG: creating and filling new WAL file
FATAL: could not write to file "pg_xlog/xlogtemp.3590": No space left on
device
DEBUG: shmem_exit(1): 0 before_shmem_exit callbacks to make
DEBUG: shmem_exit(1): 4 on_shmem_exit callbacks to make
DEBUG: cleaning up dynamic shared memory control segment with ID
1804289383
DEBUG: proc_exit(1): 3 callbacks to make
DEBUG: exit(1)
DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
DEBUG: proc_exit(-1): 0 callbacks to make
child process exited with exit code 1
initdb: removing data directory "/home/pg94/pg_root"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message kona ajay 2014-04-14 07:49:04 cant insert into a post gre sql table...Can u please help in fixing this
Previous Message John Mudd 2014-04-13 21:00:32 Fwd: [HACKERS] Fwd: Debug strategy for musl Postgres?