gcc5: initdb produces gigabytes of _fsm files - Mailing list pgsql-hackers

From Christoph Berg
Subject gcc5: initdb produces gigabytes of _fsm files
Date
Msg-id 20150212204837.GB24224@msg.df7cb.de
Whole thread Raw
Responses Re: gcc5: initdb produces gigabytes of _fsm files  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: gcc5: initdb produces gigabytes of _fsm files  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.utf8NUMERIC:  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:
couldnot 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@df7cb.de | http://www.df7cb.de/



pgsql-hackers by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: pg_basebackup -x/X doesn't play well with archive_mode & wal_keep_segments
Next
From: Amit Kapila
Date:
Subject: Re: assessing parallel-safety