Jeff Lord
2009-Mar-27 22:03 UTC
[Gluster-users] Replicating data files is causing issue with postgres
We are attempting to run a postgres cluster which is composed of two nodes. Each mirroring the data on the other. Gluster config is identical on each node: volume posix type storage/posix option directory /mnt/sdb1 end-volume volume locks type features/locks subvolumes posix end-volume volume brick type performance/io-threads subvolumes locks end-volume volume server type protocol/server option transport-type tcp option auth.addr.brick.allow * subvolumes brick end-volume volume gfs01-hq type protocol/client option transport-type tcp option remote-host gfs01-hq option remote-subvolume brick end-volume volume gfs02-hq type protocol/client option transport-type tcp option remote-host gfs02-hq option remote-subvolume brick end-volume volume replicate type cluster/replicate option favorite-child gfs01-hq subvolumes gfs01-hq gfs02-hq end-volume volume writebehind type performance/write-behind option page-size 128KB option cache-size 1MB subvolumes replicate end-volume volume cache type performance/io-cache option cache-size 512MB subvolumes writebehind end-volume The basic problem is whenever i try to import a database created on a different cluster i am running into these errors. -bash-3.2$ pg_restore -U entitystore -d entitystore --no-owner -n public entitystore pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 1829; 0 147089 TABLE DATA entity_medio-canon-all-0 entitystore pg_restore: [archiver (db)] COPY failed: ERROR: unexpected data beyond EOF in block 77309 of relation "entity_medio-canon-all-0" HINT: This has been seen to occur with buggy kernels; consider updating your system. CONTEXT: COPY entity_medio-canon-all-0, line 1022934: "medio-canon- all-0 1.mut_2572632518437988628 \\340\\000\\000\\001\\0008\\317\ \002ns2.http://schemas.m..." The issue seems to be related to using gluster, as when i attempt the same restore to local (non-replicated disk) it works fine. Is there something amiss in our gluster config? Should we be doing something different? Thanks for taking the time to read. -Jeff
Vikas Gorur
2009-Mar-28 04:57 UTC
[Gluster-users] Replicating data files is causing issue with postgres
2009/3/28 Jeff Lord <jlord at mediosystems.com>:> We are attempting to run a postgres cluster which is composed of two nodes.> Each mirroring the data on the other. Gluster config is identical on each > node: > > The issue seems to be related to using gluster, as when i attempt the same > restore to local (non-replicated disk) it works fine. > Is there something amiss in our gluster config? Should we be doing something > different? >What does the client log say? Which version are you using? If you're using any version < 2.0.0RC7, could you please try with RC7 or later and see if the problem is still there? Vikas -- Engineer - Z Research http://gluster.com/