BUG #5626: Parallel pg_restore fails with "tuple concurrently updated" - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      5626
Logged by:          Albert Ullrich
Email address:      aullrich@blackducksoftware.com
PostgreSQL version: 8.4.4
Operating system:   Centos 5.5 64bit
Description:        Parallel pg_restore fails with "tuple concurrently
updated"
Details:

pg_restore -e -v -j 4 -Fc -L /tmp/fp_basic.toc -d fp_basic
/tmp/fp_basic.dump
pg_restore: connecting to database for restore
pg_restore: processing item 5 SCHEMA file_tables
pg_restore: creating SCHEMA file_tables
pg_restore: processing item 7 SCHEMA scratch
pg_restore: creating SCHEMA scratch
pg_restore: processing item 27 FUNCTION get_file_tab_id(text)
pg_restore: creating FUNCTION get_file_tab_id(text)
pg_restore: processing item 1578 TABLE file_table
pg_restore: creating TABLE file_table
pg_restore: processing item 1607 SEQUENCE scratch_table_id
pg_restore: creating SEQUENCE scratch_table_id
pg_restore: processing item 1953 SEQUENCE SET scratch_table_id
pg_restore: executing SEQUENCE SET scratch_table_id
pg_restore: processing item 1608 TABLE scratch_tablespace
pg_restore: creating TABLE scratch_tablespace
pg_restore: entering main parallel loop
pg_restore: launching item 1915 TABLE DATA file_table
pg_restore: launching item 1941 TABLE DATA scratch_tablespace
pg_restore: skipping item 1942 ENCODING ENCODING
pg_restore: skipping item 1943 STDSTRINGS STDSTRINGS
pg_restore: skipping item 1944 DATABASE fp_basic
pg_restore: skipping item 8 SCHEMA public
pg_restore: skipping item 1946 ACL public
pg_restore: launching item 35 FUNCTION removefilefromdb(integer)
pg_restore: launching item 1579 TABLE files
pg_restore: restoring data for table "file_table"
pg_restore: restoring data for table "scratch_tablespace"
pg_restore: creating FUNCTION removefilefromdb(integer)
pg_restore: creating TABLE files
pg_restore: finished item 1579 TABLE files
pg_restore: launching item 1580 TABLE files_0
pg_restore: creating TABLE files_0
pg_restore: finished item 35 FUNCTION removefilefromdb(integer)
pg_restore: launching item 1581 TABLE files_1
pg_restore: creating TABLE files_1
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1581; 1259 153051 TABLE
files_1 blackduck
pg_restore: [archiver (db)] could not execute query: ERROR:  tuple
concurrently updated
    Command was:
CREATE TABLE files_1 (
)
INHERITS (public.files);
pg_restore: *** aborted because of error
pg_restore: finished item 1581 TABLE files_1
pg_restore: [archiver] worker process failed: exit code 1
pg_restore: *** aborted because of error