Wed Sep 12 09:12:37 PDT 2007
- Previous message: [Slony1-general] Replicating 1 DB
- Next message: [Slony1-general] init cluster won't work when node id out of range.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi,
I'm trying to create a test cluster in the image of one that already
exists. The script I'm using connects to the existing cluster, then
builds an INIT CLUSTER command based on the current origin node. The id
of the node in question is 40003. The INIT CLUSTER fails with the
following:
/opt/scripts/slonik/cluster/cluster_init.slonik:2: PGRES_FATAL_ERROR
select "_cluster".initializeLocalNode(40003, 'Node 40003'); select
"_cluster".enableNode(40003); - ERROR: bigint out of range
CONTEXT: SQL statement "SELECT setval('"_cluster".sl_rowid_seq', $1
::int8 * '1000000000000000'::int8)"
PL/pgSQL function "initializelocalnode" line 26 at perform
The node in question was added via STORE NODE, and a MOVE SET was done
at some time. If a node id is acceptable to STORE NODE should it not
also be acceptable to INIT CLUSTER? I happened to notice this on a
1.1.5 cluster, but it looks to me that initializeLocalNode() is
identical in v 1.2.
JP
--
JP Fletcher
Database Administrator
Afilias Canada
voice: 416.646.3304 ext. 4123
fax: 416.646.3305
mobile: 416.561.4763
jpfletch at ca.afilias.info
- Previous message: [Slony1-general] Replicating 1 DB
- Next message: [Slony1-general] init cluster won't work when node id out of range.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list