Skip site navigation (1) Skip section navigation (2)

BUG #5626: Parallel pg_restore fails with "tuple concurrently updated"

From: "Albert Ullrich" <aullrich(at)blackducksoftware(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5626: Parallel pg_restore fails with "tuple concurrently updated"
Date: 2010-08-18 23:07:14
Message-ID: 201008182307.o7IN7EBf074097@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5626
Logged by:          Albert Ullrich
Email address:      aullrich(at)blackducksoftware(dot)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

Responses

pgsql-bugs by date

Next:From: Steven SchlanskerDate: 2010-08-18 23:11:31
Subject: COPY FROM/TO losing a single byte of a multibyte UTF-8 sequence
Previous:From: Thue Janus KristensenDate: 2010-08-18 23:02:23
Subject: Re: BUG #5622: Query failed: server closed the connection unexpectedly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group