From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Liang Ma <ma(dot)satops(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: errors on restoring postgresql binary dump to glusterfs |
Date: | 2012-05-04 07:58:39 |
Message-ID: | CABUevEwonu0vsFNd5PGy0F=6--7wah3Qdf9ibP4eA3fx_byPzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Apr 30, 2012 at 8:34 PM, Liang Ma <ma(dot)satops(at)gmail(dot)com> wrote:
> Hi There,
>
> While trying to restore a ~700GM binary dump by command
>
> pg_restore -d dbdata < sampledbdata-20120327.pgdump
>
> I encountered following errors repeatedly
>
> pg_restore: [archiver (db)] Error from TOC entry 2882463; 2613
> 10267347 BLOB 10267347 sdmcleod
> pg_restore: [archiver (db)] could not execute query: ERROR:
> unexpected data beyond EOF in block 500 of relation base/16386/11743
> HINT: This has been seen to occur with buggy kernels; consider
> updating your system.
Note the message right here...
There may be further indications in the server log about what's wrong.
> The server runs Ubuntu server 10.04 LTS with postgresql upgraded to
> version 9.1.3-1~lucid. The postgresql data directory is located in a
> glusterfs mounted directory to a replicated volume vol-2
I assume you don't have more than one node actually *accessing* the
data directory at the same time, right?
Even with that said, I haven't heard of anybody running PostgreSQL on
glusterfs, and I'm not sure it fulfills the basic requirements that
PostgreSQL has on a filesystem. In particular, the messages above
about a buggy kernel certainly indicates that there is a problem with
the filesystem.
> I think this may have someting to do with glusterfs, because when I
> restore the same dump to a same ubuntu 10.04 server with postgresql
> upgraded to the same 9.1.3-1~lucid located in a local ext4 filesystem,
> the pg_restore went well without a single error.
Yes, it certainly sounds like that. You probably need to bring it up
with the glusterfs folks...
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-05-04 08:22:52 | Re: spanish locale question |
Previous Message | Geo-x | 2012-05-04 07:34:03 | Re: "OLD." || myColumnNameVar (How to generically access columns in a trigger's OLD or NEW records) |