[Bucardo-general] Replication won't start.

[Donald StDenis]

Hi,

I’ve been trying to set up Bucardo replication from Pg9.2 to Pg9.6 and I can’t seem to make the replication start.

I did this from 9.2->9.2 about 6 months ago with almost no problems as I recall.

The bucardo status error on the slave is: 

bacardi:~$ bucardo status
PID of Bucardo MCP: 28741
 Name       State    Last good    Time    Last I/D    Last bad    Time
==========+========+============+=======+===========+===========+=======
 the_sync | Bad    | none       |       |           | 16:48:44  | 3s
bucardo:~$ bucardo status the_sync
======================================================================
Use of uninitialized value $sourcedb in concatenation (.) or string at /usr/bin/bucardo line 6013.
Last bad                 : Dec 19, 2016 16:48:44 (time until fail: 1s)
Sync name                : the_sync
Current state            : Bad
Source relgroup/database : copying_herd /
Tables in sync           : 0
Status                   : Active
Check time               : None
Overdue time             : 00:00:00
Expired time             : 00:00:00
Stayalive/Kidsalive      : Yes / Yes
Rebuild index            : No
Autokick                 : Yes
Onetimecopy              : No
Post-copy analyze        : Yes
Last error:              : Failed : DBD::Pg::st execute failed: ERROR:  schema "bucardo" does not exist LINE 1: ...ident(tname), MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bu...                                                              ^ at /usr/sh$
======================================================================

The error I see on the master is:

2016-12-19 16:48:44.882 UTC [00000] [12808]: [1] db=[unknown],user=[unknown],host=10.223.160.212(10156) LOG:  connection received: host=10.223.160.212 port=10156
2016-12-19 16:48:44.892 UTC [00000] [12808]: [2] db=good_rails_production,user=bucardo,host=10.223.160.212(10156) LOG:  connection authorized: user=bucardo database=good_rails_production
2016-12-19 16:48:44.903 UTC [3F000] [12808]: [3] db=good_rails_production,user=bucardo,host=10.223.160.212(10156) ERROR:  schema "bucardo" does not exist at character 84
2016-12-19 16:48:44.903 UTC [3F000] [12808]: [4] db=good_rails_production,user=bucardo,host=10.223.160.212(10156) STATEMENT:  SELECT quote_ident(sname), quote_ident(tname), MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bucardo_truncate_trigger  WHERE syn$
c = $1 AND replicated IS NULL GROUP BY 1,2
2016-12-19 16:48:44.911 UTC [00000] [12808]: [5] db=good_rails_production,user=bucardo,host=10.223.160.212(10156) LOG:  disconnection: session time: 0:00:00.028 user=bucardo database=good_rails_production host=10.223.160.212 port=10156

I have installed bacardo and the bacardo database on the slave in 9.6.  plperlu is installed on both the 9.2 databases and the 9.6 databases.

I’m not sure what to try next.  Any help is appreciated. Thank you.

Don.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20161219/986058ca/attachment-0001.html>