Hans Anderson handerson
Sun Aug 1 13:55:23 PDT 2004
Slony, team, you guys are doing magnificent work. Thank you very much.
We've been wrestling with an install of 1.0.1 on rh9 (- Linux version
2.4.20-8 (bhcompile at stripples.devel.redhat.com) (gcc version 3.2.2 20030222
(Red Hat Linux 3.2.2-5)) -postgresql-7.3.2 AND 7.4.3 - slony-I-1.0.1) for a
 number of days. While it's never pleasant to be shown to be idiots, :)  
we'd rather suffer the humiliation and get this working as soon as 
possible.
Our problem is documented in
 http://gborg.postgresql.org/project/slony1/bugs/bugupdate.php?893 but 
we'll
also include details, here: In short, we get the same errors while 
running to
 7.3.2 and 7.4.3 when we prepare and configure as specified in the slony
README. The errors are below (in a clipped form). Obviously, the xxid.v74
is xxid.v73 when we attempt to configure on 7.3.2. We feel this must be 
something
asinine we're overlooking, because so many of you on this list speak of
easily getting slony up and running. Our environment vars are recorded in
the bug. We have 2 dbs, pgbench_node1 & pgbench_node2, userslony has all
privileges on both and on template1. plpgsql is installed for all 3 of those
databases, as well. We've run the configuration manually. We've run it using
the slony_sample1_setup.sh. We've run it using the slony_master_setup.sh
that the slony_setup.pl script creates. We've run each of these as root 
and as
postgres. We've run these options on both 7.3.2 and 7.3.4.
Thanks again.
"
<stdin>:4: Initializing the cluster

<stdin>:6: loading of file /usr/local/pgsql/share/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>:8: Could not initialize the cluster!
"
In postgresql log:
"
Jul 31 17:25:23 elizabeth postgres[23280]: [176-181] ^ICREATE FUNCTION 
"_T1"."xxid_ge_snapshot"(
Jul 31 17:25:23 elizabeth postgres[23280]: [176-182] ^I^I^I"_T1"."xxid",
Jul 31 17:25:23 elizabeth postgres[23280]: [176-183] 
^I^I^I"_T1"."xxid_snapshot")
Jul 31 17:25:23 elizabeth postgres[23280]: [176-184] ^IRETURNS boolean
Jul 31 17:25:23 elizabeth postgres[23280]: [176-185] ^I^IAS 
'$libdir/xxid', '_Slony_I_xxid_ge_snapshot'
Jul 31 17:25:23 elizabeth postgres[23280]: [176-186] ^I^ILANGUAGE C;
Jul 31 17:25:23 elizabeth postgres[23280]: [176-187] ^I
Jul 31 17:25:23 elizabeth postgres[23280]: [176-188] ^I
Jul 31 17:25:23 elizabeth postgres[23280]: [176-189] ^I
Jul 31 17:25:23 elizabeth postgres[23280]: [177-1] DEBUG:  00000: 
AbortCurrentTransaction
Jul 31 17:25:23 elizabeth postgres[23280]: [177-2] LOCATION:  
PostgresMain, postgres.c:2722
Jul 31 17:25:23 elizabeth postgres[23280]: [178-1] DEBUG:  00000: 
StartTransactionCommand
Jul 31 17:25:23 elizabeth postgres[23280]: [178-2] LOCATION:  
start_xact_command, postgres.c:1732
Jul 31 17:25:23 elizabeth postgres[23280]: [178-3] STATEMENT:  select 1;
Jul 31 17:25:23 elizabeth postgres[23280]: [179-1] LOG:  00000: 
statement: select 1;
Jul 31 17:25:23 elizabeth postgres[23280]: [179-2] LOCATION:  
pg_parse_query, postgres.c:464
Jul 31 17:25:23 elizabeth postgres[23280]: [179-3] STATEMENT:  select 1;
Jul 31 17:25:23 elizabeth postgres[23280]: [180-1] ERROR:  25P02: 
current transaction is aborted, commands ignored until end of 
transaction block
Jul 31 17:25:23 elizabeth postgres[23280]: [180-2] LOCATION:  
exec_simple_query, postgres.c:795
Jul 31 17:25:23 elizabeth postgres[23280]: [180-3] STATEMENT:  select 1;
Jul 31 17:25:23 elizabeth postgres[23280]: [181-1] DEBUG:  00000: 
AbortCurrentTransaction
Jul 31 17:25:23 elizabeth postgres[23280]: [181-2] LOCATION:  
PostgresMain, postgres.c:2722
Jul 31 17:25:23 elizabeth postgres[23280]: [182-1] DEBUG:  00000: 
StartTransactionCommand
Jul 31 17:25:23 elizabeth postgres[23280]: [182-2] LOCATION:  
start_xact_command, postgres.c:1732
Jul 31 17:25:23 elizabeth postgres[23280]: [182-3] STATEMENT:  rollback 
transaction;
Jul 31 17:25:23 elizabeth postgres[23280]: [183-1] LOG:  00000: 
statement: rollback transaction;
Jul 31 17:25:23 elizabeth postgres[23280]: [183-2] LOCATION:  
pg_parse_query, postgres.c:464
Jul 31 17:25:23 elizabeth postgres[23280]: [183-3] STATEMENT:  rollback 
transaction;
Jul 31 17:25:23 elizabeth postgres[23280]: [184-1] DEBUG:  00000: parse 
tree:
Jul 31 17:25:23 elizabeth postgres[23280]: [184-2] DETAIL:     {QUERY
Jul 31 17:25:23 elizabeth postgres[23280]: [184-3] ^I   :commandType 5
Jul 31 17:25:23 elizabeth postgres[23280]: [184-4] ^I   :querySource 0
Jul 31 17:25:23 elizabeth postgres[23280]: [184-5] ^I   :canSetTag true
Jul 31 17:25:23 elizabeth postgres[23280]: [184-6] ^I   :utilityStmt ?
Jul 31 17:25:23 elizabeth postgres[23280]: [184-7] ^I   :resultRelation 0
Jul 31 17:25:23 elizabeth postgres[23280]: [184-8] ^I   :into <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-9] ^I   :hasAggs false
Jul 31 17:25:23 elizabeth postgres[23280]: [184-10] ^I   :hasSubLinks false
Jul 31 17:25:23 elizabeth postgres[23280]: [184-11] ^I   :rtable <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-12] ^I   :jointree <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-13] ^I   :rowMarks ()
Jul 31 17:25:23 elizabeth postgres[23280]: [184-14] ^I    
Jul 31 17:25:23 elizabeth postgres[23280]: [184-15] ^I   :targetList <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-16] ^I   :groupClause <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-17] ^I   :havingQual <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-18] ^I   :distinctClause <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-19] ^I   :sortClause <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-20] ^I   :limitOffset <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-21] ^I   :limitCount <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-22] ^I   :setOperations <>
Jul 31 17:25:23 elizabeth postgres[23280]: [184-23] ^I   :resultRelations ()
Jul 31 17:25:23 elizabeth postgres[23280]: [184-24] ^I   }
Jul 31 17:25:23 elizabeth postgres[23280]: [184-25] ^I
"




More information about the Slony1-general mailing list