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

Error Restoring Large Database

From: Mark Rae <m(dot)rae(at)inpharmatica(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Error Restoring Large Database
Date: 2002-01-24 10:12:05
Message-ID: 3C4FDDF5.1CDD2C48@inpharmatica.co.uk (view raw or flat)
Thread:
Lists: pgsql-bugs
System Configuration
---------------------
  Architecture       : Dual AMD Athlon MP 1800+

  Operating System   : Linux dpdev02 2.4.4-64GB-SMP #1 SMP

  PostgreSQL version : PostgreSQL-7.2b4 and PostgreSQL-7.2rc1

  Compiler used      : gcc version 2.95.3 20010315 (SuSE)


Please enter a FULL description of your problem:
------------------------------------------------

When trying to restore from a dump of a 9Gb database the restore fails.
(see below for info)
The same dump/restore procedure has worked succesfully for smaller
databases ~1-2Gb

The relevant error message appears to come from
src/backend/storage/freespace/freespace.c
which says

/* Shouldn't get here given the initial if-test for space available */
        elog(ERROR, "insert_fsm_page_entry: failed to insert entry!");



The database tables total 9.0Gb with associated indexes taking up
10.0Gb.
There is >25G free disk space, and there is no error in the
system logs.

I have tried other variations on the examples below, but the
restore still fails. Apparently _in the same place_ each time.
I also tried rc1 which behaves in the same way.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

The database is dumped using
$ pg_dump -b -Fc core4 > core4.dump

And then restored using
$ pg_restore --dbname=core4 < core4.dump

Which exits with error code 1 and the following message
pg_restore: [archiver (db)] error returned by PQputline

The logfile contains the errors
ERROR:  copy: line 26501638, insert_fsm_page_entry: failed to insert entry!
FATAL 1:  Socket command type 2 unknown


Retrying using an INSERT rather than COPY dump
$ pg_dump --inserts -b -Fc core4 > core4.dump

gives these errors when trying to restore

pg_restore: [archiver (db)] could not execute query: ERROR:  insert_fsm_page_entry: failed to insert entry!

and

ERROR:  insert_fsm_page_entry: failed to insert entry!

in the logfile



    -Mark

-- 
Mark Rae                                       Tel: +44(0)20 7074 4648
Inpharmatica                                   Fax: +44(0)20 7074 4700
m(dot)rae(at)inpharmatica(dot)co(dot)uk                http://www.inpharmatica.co.uk/

Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-01-24 12:26:38
Subject: Bug #567: no way of restricting creation of tables
Previous:From: Stephan SzaboDate: 2002-01-23 16:09:21
Subject: Re: Bug #566: Primary key not working correctly with

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