gcc5: initdb produces gigabytes of _fsm files

From: Christoph Berg <cb(at)df7cb(dot)de>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: gcc5: initdb produces gigabytes of _fsm files
Date: 2015-02-12 20:48:37
Message-ID: 20150212204837.GB24224@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

gcc5 is lurking in Debian experimental, and it's breaking initdb.
There's bug reports for 9.1 and 9.4:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=778070 (9.1)
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=778071 (9.4)
but I could reproduce it with 9.5devel (from last week) as well:

gcc (Debian 5-20150205-1) 5.0.0 20150205 (experimental) [trunk revision 220455]

make[2]: Leaving directory '/srv/projects/postgresql/pg/master/src/common'
../../../src/test/regress/pg_regress --inputdir=. --temp-install=./tmp_check --top-builddir=../../.. --dlpath=. --schedule=./parallel_schedule
============== removing existing temp installation ==============
============== creating temporary installation ==============
============== initializing database system ==============

pg_regress: initdb failed
Examine /srv/projects/postgresql/pg/master/src/test/regress/log/initdb.log for the reason.
Command was: "/srv/projects/postgresql/pg/master/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/initdb" -D "/srv/projects/postgresql/pg/master/src/test/regress/./tmp_check/data" -L "/srv/projects/postgresql/pg/master/src/test/regress/./tmp_check/install//usr/local/pgsql/share" --noclean --nosync > "/srv/projects/postgresql/pg/master/src/test/regress/log/initdb.log" 2>&1
GNUmakefile:138: recipe for target 'check' failed

src/test/regress $ cat log/initdb.log
Running in noclean mode. Mistakes will not be cleaned up.
The files belonging to this database system will be owned by user "cbe".
This user must also own the server process.

The database cluster will be initialized with locales
COLLATE: de_DE.utf8
CTYPE: de_DE.utf8
MESSAGES: C
MONETARY: de_DE.utf8
NUMERIC: de_DE.utf8
TIME: de_DE.utf8
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "german".

Data page checksums are disabled.

creating directory /srv/projects/postgresql/pg/master/src/test/regress/./tmp_check/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... sysv
creating configuration files ... ok
creating template1 database in /srv/projects/postgresql/pg/master/src/test/regress/./tmp_check/data/base/1 ... FATAL: could not extend file "base/1/2617_fsm": wrote only 4096 of 8192 bytes at block 46197
HINT: Check free disk space.
PANIC: cannot abort transaction 1, it was already committed
Aborted (core dumped)

src/test/regress $ ls -al tmp_check/data/base/1/
insgesamt 34156376
drwx------ 2 cbe cbe 4096 Feb 12 20:04 ./
drwx------ 3 cbe cbe 4096 Feb 12 19:55 ../
-rw------- 1 cbe cbe 40960 Feb 12 20:04 1247
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1247_fsm
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1247_fsm.1
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1247_fsm.2
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1247_fsm.3
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1247_fsm.4
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1247_fsm.5
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1247_fsm.6
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1247_fsm.7
-rw------- 1 cbe cbe 59138048 Feb 12 20:04 1247_fsm.8
-rw------- 1 cbe cbe 49152 Feb 12 20:04 1249
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1249_fsm
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1249_fsm.1
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1249_fsm.2
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1249_fsm.3
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1249_fsm.4
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1249_fsm.5
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1249_fsm.6
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1249_fsm.7
-rw------- 1 cbe cbe 59138048 Feb 12 20:04 1249_fsm.8
-rw------- 1 cbe cbe 540672 Feb 12 20:03 1255
-rw------- 1 cbe cbe 1073741824 Feb 12 19:55 1255_fsm
-rw------- 1 cbe cbe 1073741824 Feb 12 19:55 1255_fsm.1
-rw------- 1 cbe cbe 1073741824 Feb 12 19:55 1255_fsm.2
-rw------- 1 cbe cbe 1073741824 Feb 12 19:55 1255_fsm.3
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1255_fsm.4
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1255_fsm.5
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1255_fsm.6
-rw------- 1 cbe cbe 1073741824 Feb 12 20:03 1255_fsm.7
-rw------- 1 cbe cbe 59138048 Feb 12 20:03 1255_fsm.8
-rw------- 1 cbe cbe 16384 Feb 12 20:04 1259
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1259_fsm
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1259_fsm.1
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1259_fsm.2
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1259_fsm.3
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1259_fsm.4
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1259_fsm.5
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1259_fsm.6
-rw------- 1 cbe cbe 1073741824 Feb 12 20:04 1259_fsm.7
-rw------- 1 cbe cbe 59138048 Feb 12 20:04 1259_fsm.8
-rw------- 1 cbe cbe 0 Feb 12 20:04 2604
-rw------- 1 cbe cbe 0 Feb 12 20:04 2606
-rw------- 1 cbe cbe 0 Feb 12 20:04 2610
-rw------- 1 cbe cbe 0 Feb 12 20:04 2611
-rw------- 1 cbe cbe 8192 Feb 12 20:04 2617
-rw------- 1 cbe cbe 378449920 Feb 12 20:04 2617_fsm

Program terminated with signal SIGABRT, Aborted.
#0 0x00007f818524c107 in raise () from /lib/x86_64-linux-gnu/libc.so.6
#1 0x00007f818524d4e8 in abort () from /lib/x86_64-linux-gnu/libc.so.6
#2 0x000000000074cf1a in errfinish ()
#3 0x000000000074e9aa in elog_finish ()
#4 0x00000000004bcebd in RecordTransactionAbort ()
#5 0x00000000004bcf79 in AbortTransaction ()
#6 0x00000000004c0175 in AbortOutOfAnyTransaction ()
#7 0x00000000007579d9 in ShutdownPostgres ()
#8 0x000000000065628d in shmem_exit ()
#9 0x000000000065636e in proc_exit_prepare ()
#10 0x00000000006563e8 in proc_exit ()
#11 0x000000000074cf46 in errfinish ()
#12 0x000000000066df18 in mdextend ()
#13 0x0000000000653ad4 in fsm_readbuf ()
#14 0x0000000000653bfe in fsm_set_and_search ()
#15 0x000000000065409d in RecordAndGetPageWithFreeSpace ()
#16 0x00000000004949a2 in RelationGetBufferForTuple ()
#17 0x000000000048eed7 in heap_insert ()
#18 0x00000000004d5981 in InsertOneTuple ()
#19 0x00000000004d4589 in boot_yyparse ()
#20 0x00000000004d5007 in AuxiliaryProcessMain ()
#21 0x00000000004634cb in main ()

Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2015-02-12 20:52:18 Re: assessing parallel-safety
Previous Message Sergey Konoplev 2015-02-12 19:44:05 Re: pg_basebackup -x/X doesn't play well with archive_mode & wal_keep_segments