Sun Aug 1 13:55:23 PDT 2004
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 "
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list