Wed May 19 12:06:48 PDT 2004
- Previous message: [Slony1-general] Slony example scripts in CVS?
- Next message: [Slony1-general] Trying out the slony_sample1_setup.sh script
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi all,
Just tried running the "slony_sample1_setup.sh" script, but it's giving
errors. Using FreeBSD 4.10-PRERELEASE and PostgreSQL 7.4.2.
Have done some initial investigation, but haven't quite been able to get
it working yet.
As the first step I modified the constants in the
"slony1_sample1.setup.sh" file with the values of the development
servers here:
CLUSTER=test1
DBNAME1=pgbench
DBNAME2=pgbench
HOST1=xena
HOST2=tmp4
SLONY_USER=pgsql
PGBENCH_USER=justin
Then created the pgbench schema on both the master database server
(xena) and the slave database server (tmp4) using using Jan's exact
instruction on the page. I think that in theory things should be ready
at this stage to setup the replication.
Running the "slony_sample1_setup.sh" script at this stage then produced
errors to the console (verbosity is "debug1" level for many things in
the PostgreSQL config file):
***********
bash-2.05b$ ./slony_sample1_setup.sh
<stdin>:20: LOG: statement: begin transaction;
<stdin>:20: LOG: statement: select version();
<stdin>:20: LOG: statement: rollback transaction;
<stdin>:20: LOG: statement: begin transaction;
<stdin>:20: LOG: statement: select 1 from "pg_catalog".pg_namespace N
where N.nspname = '_test1';
<stdin>:20: LOG: statement: create schema "_test1";
<stdin>:20: loading of file /usr/local/share/postgresql/xxid.v74.sql:
PGRES_FATAL_ERROR ERROR: current transaction is aborted, commands
ignored until end of transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
<stdin>:20: LOG: statement: rollback transaction;
bash-2.05b$
***********
Checked for the existence of the xxid.v74.sql file at the location in
the error message, and it's definitely there and readable.
Checking the syslog output shows these PostgreSQL error messages
generated by the running of the slony_sample1_setup.sh script:
***********
May 19 21:55:47 xena postgres[68911]: [9-1] NOTICE: type "_test1.xxid"
is not yet defined
May 19 21:55:47 xena postgres[68911]: [9-2] DETAIL: Creating a shell
type definition.
May 19 21:55:47 xena postgres[68911]: [9-3] STATEMENT: -- ----------
May 19 21:55:47 xena postgres[68911]: [9-4] -- xxid.v73.sql.in
May 19 21:55:47 xena postgres[68911]: [9-5] --
May 19 21:55:47 xena postgres[68911]: [9-6] -- SQL script for
loading the transaction ID compatible datatype
May 19 21:55:47 xena postgres[68911]: [9-7] --
May 19 21:55:47 xena postgres[68911]: [9-8] -- Copyright (c)
2003-2004, PostgreSQL Global Development Group
May 19 21:55:47 xena postgres[68911]: [9-9] -- Author: Jan
Wieck, Afilias USA INC.
May 19 21:55:47 xena postgres[68911]: [9-10] --
May 19 21:55:47 xena postgres[68911]: [9-11] -- $Id: xxid.v73.sql,v
1.1 2004/03/30 17:49:38 wieck Exp $
May 19 21:55:47 xena postgres[68911]: [9-12] -- ----------
May 19 21:55:47 xena postgres[68911]: [9-13]
May 19 21:55:47 xena postgres[68911]: [9-14] --
May 19 21:55:47 xena postgres[68911]: [9-15] -- Type specific input
and output functions
May 19 21:55:47 xena postgres[68911]: [9-16] --
May 19 21:55:47 xena postgres[68911]: [9-17] CREATE FUNCTION
"_test1"."xxidin"(cstring) RETURNS "_test1"."xxid"
May 19 21:55:47 xena postgres[68911]: [9-18] AS
'$libdir/xxid', '_Slony_I_xxidin'
May 19 21:55:47 xena postgres[68911]: [9-19] LANGUAGE C;
May 19 21:55:47 xena postgres[68911]: [9-20] CREATE FUNCTION
"_test1"."xxidout"("_test1"."xxid") RETURNS cstring
May 19 21:55:47 xena postgres[68911]: [9-21] AS
'$libdir/xxid', '_Slony_I_xxidout'
May 19 21:55:47 xena postgres[68911]: [9-22] LANGUAGE C;
May 19 21:55:47 xena postgres[68911]: [9-23]
May 19 21:55:47 xena postgres[68911]: [9-24]
May 19 21:55:47 xena postgres[68911]: [9-25] --
May 19 21:55:47 xena postgres[68911]: [9-26] -- The data type itself
May 19 21:55:47 xena postgres[68911]: [9-27] --
May 19 21:55:47 xena postgres[68911]: [9-28] CREATE TYPE
"_test1"."xxid" (
May 19 21:55:47 xena postgres[68911]: [9-29] INPUT =
"_test1"."xxidin",
May 19 21:55:47 xena postgres[68911]: [9-30] OUTPUT =
"_test1"."xxidout",
May 19 21:55:47 xena postgres[68911]: [9-31] EXTERNALLENGTH = 12,
May 19 21:55:47 xena postgres[68911]: [9-32] INTERNALLENGTH = 4,
May 19 21:55:47 xena postgres[68911]: [9-33] PASSEDBYVALUE,
May 19 21:55:47 xena postgres[68911]: [9-34] ALIGNMENT = int4
May 19 21:55:47 xena postgres[68911]: [9-35] );
May 19 21:55:47 xena postgres[68911]: [9-36]
May 19 21:55:47 xena postgres[68911]: [9-37]
May 19 21:55:47 xena postgres[68911]: [9-38] --
May 19 21:55:47 xena postgres[68911]: [9-39] -- Since our xxid type
has special cases for values 0-3, it
May 19 21:55:47 xena postgres[68911]: [9-40] -- in fact IS xid, so
allow implicit type casting to and from.
May 19 21:55:47 xena postgres[68911]: [9-41] --
May 19 21:55:47 xena postgres[68911]: [9-42] CREATE CAST (xid AS
"_test1".xxid)
May 19 21:55:47 xena postgres[68911]: [9-43] WITHOUT FUNCTION
AS IMPLICIT;
May 19 21:55:47 xena postgres[68911]: [9-44] CREATE CAST
("_test1".xxid AS xid)
May 19 21:55:47 xena postgres[68911]: [9-45] WITHOUT FUNCTION
AS IMPLICIT;
May 19 21:55:47 xena postgres[68911]: [9-46]
May 19 21:55:47 xena postgres[68911]: [9-47]
May 19 21:55:47 xena postgres[68911]: [9-48] --
May 19 21:55:47 xena postgres[68911]: [9-49] -- Comparision functions
for the new datatype
May 19 21:55:47 xena postgres[68911]: [9-74] LANGUAGE C;
May 19 21:55:47 xena postgres[68911]: [9-75] CREATE FUNCTION
"_test1".getMinXid() RETURNS "_test1"."xxid"
May 19 21:55:47 xena postgres[68911]: [9-76] AS
'$libdir/xxid', '_Slony_I_getMinXid'
May 19 21:55:47 xena postgres[68911]: [9-77] LANGUAGE C;
May 19 21:55:47 xena postgres[68911]: [9-78] CREATE FUNCTION
"_test1".getMaxXid() RETURNS "_test1"."xxid"
May 19 21:55:47 xena postgres[68911]: [9-79] AS
'$libdir/xxid', '_Slony_I_getMaxXid'
May 19 21:55:47 xena postgres[68911]: [9-80] LANGUAGE C;
May 19 21:55:47 xena postgres[68911]: [9-81]
May 19 21:55:47 xena postgres[68911]: [9-82]
May 19 21:55:47 xena postgres[68911]: [9-83] --
May 19 21:55:47 xena postgres[68911]: [9-84] -- Operators on these
comparision functions
May 19 21:55:47 xena postgres[68911]: [9-85] --
May 19 21:55:47 xena postgres[68911]: [9-86] CREATE OPERATOR < (
May 19 21:55:47 xena postgres[68911]: [9-87] PROCEDURE =
"_test1"."xxidlt",
May 19 21:55:47 xena postgres[68911]: [9-88] LEFTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-89] RIGHTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-90] COMMUTATOR = >,
NEGATOR = >=,
May 19 21:55:47 xena postgres[68911]: [9-91] RESTRICT =
scalarltsel, JOIN = scalarltjoinsel
May 19 21:55:47 xena postgres[68911]: [9-92] );
May 19 21:55:47 xena postgres[68911]: [9-93] CREATE OPERATOR = (
May 19 21:55:47 xena postgres[68911]: [9-94] PROCEDURE =
"_test1"."xxideq",
May 19 21:55:47 xena postgres[68911]: [9-95] LEFTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-96] RIGHTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-97] COMMUTATOR = =,
NEGATOR = <>,
May 19 21:55:47 xena postgres[68911]: [9-98] RESTRICT =
eqsel, JOIN = eqjoinsel,
May 19 21:55:47 xena postgres[68911]: [9-99] SORT1 = <, SORT2
= <,
May 19 21:55:47 xena postgres[68911]: [9-100] HASHES
May 19 21:55:47 xena postgres[68911]: [9-101] );
May 19 21:55:47 xena postgres[68911]: [9-102] CREATE OPERATOR <> (
May 19 21:55:47 xena postgres[68911]: [9-103] PROCEDURE =
"_test1"."xxidne",
May 19 21:55:47 xena postgres[68911]: [9-104] LEFTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-105] RIGHTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-106] COMMUTATOR = <>,
NEGATOR = =,
May 19 21:55:47 xena postgres[68911]: [9-107] RESTRICT =
neqsel, JOIN = neqjoinsel
May 19 21:55:47 xena postgres[68911]: [9-108] );
May 19 21:55:47 xena postgres[68911]: [9-109] CREATE OPERATOR > (
May 19 21:55:47 xena postgres[68911]: [9-110] PROCEDURE =
"_test1"."xxidgt",
May 19 21:55:47 xena postgres[68911]: [9-111] LEFTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-112] RIGHTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-113] COMMUTATOR = <,
NEGATOR = <=,
May 19 21:55:47 xena postgres[68911]: [9-114] RESTRICT =
scalargtsel, JOIN = scalargtjoinsel
May 19 21:55:47 xena postgres[68911]: [9-115] );
May 19 21:55:47 xena postgres[68911]: [9-116] CREATE OPERATOR <= (
May 19 21:55:47 xena postgres[68911]: [9-117] PROCEDURE =
"_test1"."xxidle",
May 19 21:55:47 xena postgres[68911]: [9-118] LEFTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-119] RIGHTARG =
"_test1"."xxid",
May 19 21:55:47 xena postgres[68911]: [9-120] COMMUTATOR = >=,
NEGATOR = >,
May 19 21:55:47 xena postgres[68911]: [9-122] );
May 19 21:55:47 xena postgres[68911]: [10-2] STATEMENT: -- ----------
May 19 21:55:47 xena postgres[68911]: [12-1] ERROR: current transaction
is aborted, commands ignored until end of transaction block
May 19 21:55:47 xena postgres[68911]: [12-2] STATEMENT: select 1;
***********
In the last CREATE OPERATOR statement, for the "<=" operatot, it looks
like there's supposed to be something after the "NEGATOR = >," bit and
before the closing bracket. Not sure if that's what was really executed
or if it's just the way the logging is showing.
Sorry for the lengthy email, but I felt it best to include everything
just in case. If someone wants me to re-run this with different
options, different PostgreSQL configuration, different verbosity, or
whatever, just let me know.
Hope this is useful.
:-)
Regards and best wishes,
Justin Clift
- Previous message: [Slony1-general] Slony example scripts in CVS?
- Next message: [Slony1-general] Trying out the slony_sample1_setup.sh script
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list