[Bucardo-general] Problem while adding new sync

Christian Gmeiner christian.gmeiner at gmail.com
Tue May 13 14:36:36 UTC 2008 

This happens when I want to add a swap sync:

DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7921/1/0, nestlvl: 1, children: <>
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7921/1/0, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7922/1/0, nestlvl: 1, children: <>
DEBUG:  ProcessQuery
DEBUG:  Starting validate_sync trigger
DEBUG:  Found insert, will call validate_sync
DEBUG:  StartSubTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/4, nestlvl: 1, children: <>
DEBUG:  name: unnamed; blockState:     SUB BEGIN; state: INPROGR,
xid/subid/cid: 0/2/4, nestlvl: 2, children: <>
DEBUG:  Starting validate_sync for test_sync
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/6, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/6, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:     SUB BEGIN; state: INPROGR,
xid/subid/cid: 0/3/6, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/8, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/8, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/3/8, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/9, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/9, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:     SUB BEGIN; state: INPROGR,
xid/subid/cid: 0/4/9, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/11, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/11, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/4/11, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  Got a sourcedb of node0 for herd of full_herd
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/12, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/12, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:     SUB BEGIN; state: INPROGR,
xid/subid/cid: 0/5/12, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/14, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/14, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/5/14, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  Target dbs: node1
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  Validate_table for db node0 public.name, delta=1 ping=1
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/15, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/15, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:     SUB BEGIN; state: INPROGR,
xid/subid/cid: 0/6/15, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartSubTransaction
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/17, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/17, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/6/17, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:     SUB BEGIN; state: INPROGR,
xid/subid/cid: 0/7/17, nestlvl: 4, children: <>
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitSubTransaction
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/19, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/19, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/6/19, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/7/19, nestlvl: 4, children: <>
CONTEXT:  SQL statement "SELECT db_getconn('node0') AS conn"
        SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/20, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/20, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/6/20, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  Connecting to dbi:Pg:dbname=vetmed;host=localhost;port=5432 as
bucardo inside bucardo_validate_sync
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  postgres child[1719]: starting with (
DEBUG:          postgres
DEBUG:          -v196608
DEBUG:          -y
DEBUG:          vetmed
DEBUG:  )
DEBUG:  InitPostgres
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7923/1/0, nestlvl: 1, children: <>
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7923/1/0, nestlvl: 1, children: <>
DEBUG:  InitPostgres
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7923/1/0, nestlvl: 1, children: <>
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7923/1/0, nestlvl: 1, children: <>
DEBUG:  Running SELECT 1 FROM customcode c, customcode_map m WHERE
c.id=m.code AND m.goat=1 AND active IS TRUE AND whenrun = 'conflict'
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/21, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/21, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:     SUB BEGIN; state: INPROGR,
xid/subid/cid: 0/8/21, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitSubTransaction
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/23, nestlvl: 1, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/23, nestlvl: 2, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/8/23, nestlvl: 3, children: <>
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  SQL:
                    SELECT c.oid
                    FROM   pg_catalog.pg_class c, pg_catalog.pg_namespace n
                    WHERE  c.relnamespace = n.oid
                    AND    c.relkind = 'r'
                    AND    n.nspname = ?
                    AND    c.relname = ?
                 Args: public, name
CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7924/1/0, nestlvl: 1, children: <>
DEBUG:  ProcessUtility
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  StartTransaction

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  name: unnamed; blockState:       DEFAULT; state:
INPROGR, xid/subid/cid: 7924/1/0, nestlvl: 1, children: <>

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  ProcessUtility

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  forked new backend, pid=1719 socket=8
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  parse dbdpg_1:
                    SELECT c.oid
                    FROM   pg_catalog.pg_class c, pg_catalog.pg_namespace n
                    WHERE  c.relnamespace = n.oid
                    AND    c.relkind = 'r'
                    AND    n.nspname = $1
                    AND    c.relname = $2

DEBUG:  StartTransactionCommand
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  parse dbdpg_1:
                    SELECT c.oid
                    FROM   pg_catalog.pg_class c, pg_catalog.pg_namespace n
                    WHERE  c.relnamespace = n.oid
                    AND    c.relkind = 'r'
                    AND    n.nspname = $1
                    AND    c.relname = $2


CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  bind <unnamed> to dbdpg_1
DEBUG:  StartTransactionCommand
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  bind <unnamed> to dbdpg_1

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartTransactionCommand
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartTransactionCommand
DEBUG:  ProcessUtility
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  ProcessUtility

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  parse dbdpg_2:
                    SELECT count(*)
                    FROM   pg_catalog.pg_namespace
                    WHERE  nspname = $1

DEBUG:  StartTransactionCommand
NOTICE:  DEBUG:  parse dbdpg_2:
                    SELECT count(*)
                    FROM   pg_catalog.pg_namespace
                    WHERE  nspname = $1


CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  bind <unnamed> to dbdpg_2
DEBUG:  StartTransactionCommand
NOTICE:  DEBUG:  bind <unnamed> to dbdpg_2

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartTransactionCommand
DEBUG:  ProcessUtility
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  ProcessUtility

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  SQL:
        CREATE FUNCTION bucardo.bucardo_triggerkick_test_sync()
        RETURNS TRIGGER
        LANGUAGE plpgsql
        AS $notify$
        BEGIN
            EXECUTE 'NOTIFY bucardo_kick_sync_test_sync';
        RETURN NEW;
        END;
        $notify$;

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartTransactionCommand
DEBUG:  ProcessUtility
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
ERROR:  language "plpgsql" does not exist
HINT:  Use CREATE LANGUAGE to load the language into the database.
STATEMENT:
        CREATE FUNCTION bucardo.bucardo_triggerkick_test_sync()
        RETURNS TRIGGER
        LANGUAGE plpgsql
        AS $notify$
        BEGIN
            EXECUTE 'NOTIFY bucardo_kick_sync_test_sync';
        RETURN NEW;
        END;
        $notify$;

NOTICE:  DEBUG:  ProcessUtility

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartTransactionCommand
DEBUG:  ProcessUtility
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  ProcessUtility

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
NOTICE:  DEBUG:  StartTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7925/1/0, nestlvl: 1, children: <>
NOTICE:  DEBUG:  StartTransaction

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  ProcessUtility
NOTICE:  DEBUG:  name: unnamed; blockState:       DEFAULT; state:
INPROGR, xid/subid/cid: 7925/1/0, nestlvl: 1, children: <>

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitTransactionCommand
NOTICE:  DEBUG:  ProcessUtility

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  CommitTransaction
NOTICE:  DEBUG:  CommitTransactionCommand

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7925/1/0, nestlvl: 1, children: <>
NOTICE:  DEBUG:  CommitTransaction

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  DEBUG:  name: unnamed; blockState:       STARTED; state:
INPROGR, xid/subid/cid: 7925/1/0, nestlvl: 1, children: <>

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
NOTICE:  Issuing rollback() for database handle being DESTROY'd
without explicit disconnect() at line 29.

CONTEXT:  SQL statement "SELECT validate_sync('test_sync')"
DEBUG:  AbortSubTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/24, nestlvl: 1, children: <>
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state: INPROGR,
xid/subid/cid: 0/2/24, nestlvl: 2, children: <>
DEBUG:  CleanupSubTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7922/1/24, nestlvl: 1, children: <>
DEBUG:  name: unnamed; blockState:  SUB INPROGRS; state:   ABORT,
xid/subid/cid: 0/2/24, nestlvl: 2, children: <>
ERROR:  error from Perl trigger function: error from Perl function:
DBD::Pg::db do failed: ERROR:  language "plpgsql" does not exist
        HINT:  Use CREATE LANGUAGE to load the language into the
database. at line 30.
STATEMENT:  INSERT INTO bucardo.sync("name", source, targetdb,
synctype, checktime) VALUES ('test_sync'::text, 'full_herd'::text,
'node1'::text, 'swap'::text, '1 minute'::interval)
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
DEBUG:  reaping dead processes
DEBUG:  server process (PID 1719) exited with exit code 0
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7926/1/0, nestlvl: 1, children: <>
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7926/1/0, nestlvl: 1, children: <>
DEBUG:  forked new backend, pid=1720 socket=8
DEBUG:  postgres child[1720]: starting with (
DEBUG:          postgres
DEBUG:          -v196608
DEBUG:          -y
DEBUG:          bucardo
DEBUG:  )
DEBUG:  InitPostgres
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7927/1/0, nestlvl: 1, children: <>
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7927/1/0, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7928/1/0, nestlvl: 1, children: <>
DEBUG:  ProcessUtility
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7928/1/1, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7929/1/0, nestlvl: 1, children: <>
DEBUG:  ProcessUtility
DEBUG:  CommitTransactionCommand
DEBUG:  CommitTransaction
DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
xid/subid/cid: 7929/1/0, nestlvl: 1, children: <>
DEBUG:  StartTransactionCommand
DEBUG:  StartTransaction
DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
xid/subid/cid: 7930/1/0, nestlvl: 1, children: <>
DEBUG:  ProcessUtility
ERROR:  language "plpgsql" already exists
STATEMENT:  CREATE LANGUAGE plpgsql;


The strange thing: I get 'language "plpgsql" already exists' when i
run CREATE LANGUAGE plpgsql;

I hope someone can help me,
Christian Gmeiner

More information about the Bucardo-general mailing list