Resending this mail as I think my previous mail has not reached the alias.

On Jan 30, 2008 4:21 PM, Satya <satya461 at gmail.com> wrote:

> Hi,
>
> I have checked out slony-1 source code from cvs and tried compiling with
> PostgreSQL 8.3 RC2(checkout version). I was able to compile it but slony
> tests are failing.
> Has anyone faced this problem? Is there some issue with Slony code? Please
> let me know if I need to attach any logs.
> All the slony tests are failing but I am attaching the logs for only one
> test(testmergeset).
>
>
>
> SLONY TEST LOG:
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> bash-3.2$ PGBINDIR=3D/space/WORK/postgres/bin/  PGUSER=3Dsatya ./run_test=
.sh
> testmergeset
> test: testmergeset
> ----------------------------------------------------
> $Id: README,v 1.2 2007-10-26 14:47:24 cbbrowne Exp $
>
> testmergeset sets up a series of replication sets, progressively
> merging them together.
>
> This was written based on "testpartition", the difference being that
> in this test, tables are added to replication via explicitly creating
> a set (a temporary set #999), and then merging that set back into the
> main set.
>
> This test also takes a fairly aggressive tack on usage of WAIT FOR
> EVENT; when it gets into the "merge phase," it submits a SYNC followed
> by waiting for that SYNC to be confirmed on all relevant nodes before
> submitting a MERGE SET request to eliminate the extra set.  It does
> not use any SLEEP requests; concurrency control is expected to be
> controlled by WAIT FOR EVENT.
> ----------------------------------------------------
> Test by j.random.luser at example.net to be summarized in /tmp/Slony-
> I-test-results.log
> creating origin DB: satya -h localhost -U satya -p 5432 slonyregress1
> add plpgsql to Origin
> loading origin DB with testmergeset/init_schema.sql
> setting up user satya to have weak access to data
> done
> creating subscriber 2 DB: satya -h localhost -U satya -p 5432
> slonyregress2
> add plpgsql to subscriber
> loading subscriber 2 DB from slonyregress1
> done
> creating subscriber 3 DB: satya -h localhost -U satya -p 5432
> slonyregress3
> add plpgsql to subscriber
> loading subscriber 3 DB from slonyregress1
> done
> creating subscriber 4 DB: satya -h localhost -U satya -p 5432
> slonyregress4
> add plpgsql to subscriber
> loading subscriber 4 DB from slonyregress1
> done
> creating cluster
> done
> storing nodes
> done
> Granting weak access on Slony-I schema
> done
> storing paths
> done
> launching originnode : /space/WORK/postgres/bin//slon  -s500 -g10 -d2
> slony_regress1 "dbname=3Dslonyregress1 host=3Dlocalhost user=3Dsatya port=
=3D5432"
> Archive node:
> Considering node 2
> launching: /space/WORK/postgres/bin//slon -s500 -g10 -d2  slony_regress1
> "dbname=3Dslonyregress2 host=3Dlocalhost user=3Dsatya port=3D5432"
> Considering node 3
> launching: /space/WORK/postgres/bin//slon -s500 -g10 -d2  slony_regress1
> "dbname=3Dslonyregress3 host=3Dlocalhost user=3Dsatya port=3D5432"
> Considering node 4
> launching: /space/WORK/postgres/bin//slon -s500 -g10 -d2  slony_regress1
> "dbname=3Dslonyregress4 host=3Dlocalhost user=3Dsatya port=3D5432"
> subscribing
>
> and HANGS at this stage..
>
> Postgres Log
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> LOG:  database system was shut down at 2008-01-30 16:12:30 IST
> LOG:  autovacuum launcher started
> LOG:  database system is ready to accept connections
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "regions_pkey" for table "regions"
> NOTICE:  CREATE TABLE will create implicit sequence
> "products_product_id_seq" for serial column "products.product_id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "products_pkey" for table "products"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "products_name_key" for table "products"
> NOTICE:  CREATE TABLE will create implicit sequence "sales_txns_id_seq"
> for serial column "sales_txns.id"
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "sales_txns_pkey" for table "sales_txns"
> ERROR:  relation "public.table1" does not exist
> STATEMENT:  grant select on table public.table1 to satya;
> ERROR:  relation "public.table1_id_seq" does not exist
> STATEMENT:  grant select on table public.table1_id_seq to satya;
> ERROR:  relation "public.table2" does not exist
> STATEMENT:  grant select on table public.table2 to satya;
> ERROR:  relation "public.table2_id_seq" does not exist
> STATEMENT:  grant select on table public.table2_id_seq to satya;
> ERROR:  relation "public.table1a" does not exist
> STATEMENT:  grant select on table public.table1a to satya;
> ERROR:  relation "public.table1a_id_seq" does not exist
> STATEMENT:  grant select on table public.table1a_id_seq to satya;
> ERROR:  relation "public.table2a" does not exist
> STATEMENT:  grant select on table public.table2a to satya;
> ERROR:  relation "public.table2a_id_seq" does not exist
> STATEMENT:  grant select on table public.table2a_id_seq to satya;
> ERROR:  Missing sales_txns partition for date 2006-01-15 00:00:00+05:30
> CONTEXT:  SQL statement "INSERT INTO sales_txns (region_code, product_id,
> quantity, amount, trans_on) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
>         PL/pgSQL function "purchase_product" line 11 at SQL statement
> STATEMENT:  select purchase_product( region_code, product_id,
> (random()*5+random()*8+random()*7)::integer, '2006-01-15') from regions,
> products order by random() limit 3;
> ERROR:  Missing sales_txns partition for date 2006-01-16 00:00:00+05:30
> CONTEXT:  SQL statement "INSERT INTO sales_txns (region_code, product_id,
> quantity, amount, trans_on) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
>         PL/pgSQL function "purchase_product" line 11 at SQL statement
> STATEMENT:  select purchase_product( region_code, product_id,
> (random()*5+random()*8+random()*7)::integer, '2006-01-16') from regions,
> products order by random() limit 3;
> ERROR:  Missing sales_txns partition for date 2006-01-17 00:00:00+05:30
> CONTEXT:  SQL statement "INSERT INTO sales_txns (region_code, product_id,
> quantity, amount, trans_on) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
>         PL/pgSQL function "purchase_product" line 11 at SQL statement
> STATEMENT:  select purchase_product( region_code, product_id,
> (random()*5+random()*8+random()*7)::integer, '2006-01-17') from regions,
> products order by random() limit 3;
> ERROR:  Missing sales_txns partition for date 2006-01-18 00:00:00+05:30
> CONTEXT:  SQL statement "INSERT INTO sales_txns (region_code, product_id,
> quantity, amount, trans_on) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
>         PL/pgSQL function "purchase_product" line 11 at SQL statement
> STATEMENT:  select purchase_product( region_code, product_id,
> (random()*5+random()*8+random()*7)::integer, '2006-01-18') from regions,
> products order by random() limit 3;
> ERROR:  Missing sales_txns partition for date 2006-01-19 00:00:00+05:30
> CONTEXT:  SQL statement "INSERT INTO sales_txns (region_code, product_id,
> quantity, amount, trans_on) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
>         PL/pgSQL function "purchase_product" line 11 at SQL statement
> STATEMENT:  select purchase_product( region_code, product_id,
> (random()*5+random()*8+random()*7)::integer, '2006-01-19') from regions,
> products order by random() limit 3;
> ERROR:  Missing sales_txns partition for date 2006-01-20 00:00:00+05:30
> CONTEXT:  SQL statement "INSERT INTO sales_txns (region_code, product_id,
> quantity, amount, trans_on) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
>         PL/pgSQL function "purchase_product" line 11 at SQL statement
> STATEMENT:  select purchase_product( region_code, product_id,
> (random()*5+random()*8+random()*7)::integer, '2006-01-20') from regions,
> products order by random() limit 3;
> ERROR:  language "plpgsql" already exists
> STATEMENT:  CREATE PROCEDURAL LANGUAGE plpgsql;
> NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index
> "products_name_key" for table "products"
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "products_pkey" for table "products"
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "regions_pkey" for table "regions"
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "sales_txns_pkey" for table "sales_txns"
> ERROR:  language "plpgsql" already exists
> STATEMENT:  CREATE PROCEDURAL LANGUAGE plpgsql;
> NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index
> "products_name_key" for table "products"
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "products_pkey" for table "products"
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "regions_pkey" for table "regions"
> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "sales_txns_pkey" for table "sales_txns"
> ERROR:  language "plpgsql" already exists
>
>
> Regards,
> Satya
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080206/=
52ea1b7a/attachment.htm