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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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