[Bucardo-general] Bucardo Sync Fail

[Hiram Walker]

Hi Guys,

  I found the script on bucardo Schema.. so I create manually the table.

CREATE TABLE bucardo.bucardo_truncate_trigger (
                        tablename   OID         NOT NULL,
                        sname       TEXT        NOT NULL,
                        tname       TEXT        NOT NULL,
                        sync        TEXT        NOT NULL,
                        replicated  TIMESTAMPTZ     NULL,
                        cdate       TIMESTAMPTZ NOT NULL DEFAULT now()
                    );

CREATE INDEX bucardo_truncate_trigger_index ON
bucardo.bucardo_truncate_trigger (sync, tablename) WHERE replicated IS NULL

I restart the server, then I try ./bucardo status and I got this.

[root at spd-psgre-ndb01 Bucardo-5.4.1]# ./bucardo status

 Name           State    Last good               Time         Last I/D
Last bad                Time
==============+========+=======================+============+===========+=======================+=============
 sync_dbpmis1 | Good   | Dec 04, 2017 17:23:29 | 23h 52m 0s | 0/0       |
none                  |
 sync_dbpmis2 | Bad    | none                  |            |           |
Dec 04, 2017 21:38:11 | 19h 37m 19s
[root at spd-psgre-ndb01 Bucardo-5.4.1]#

 What else can I do?

Regards,
Hiram W.


Saludos cordiales,

Hiram Walker O.
+56965824408



2017-12-05 16:25 GMT-03:00 Hiram Walker <hiramwalker at gmail.com>:

> Greg,
>
>   I try to find in bucardo file where is the create table
> "bucardo.bucardo_truncate_trigger " to create it manually but I do not
> find it.. can you send me the script please?
>
> Regards,
>
> Hiram
>
> Saludos cordiales,
>
> Hiram Walker O.
> +56965824408 <+56%209%206582%204408>
>
>
>
> 2017-12-04 18:20 GMT-03:00 Hiram Walker <hiramwalker at gmail.com>:
>
>> Hi Greg,
>>
>>   The last time we talk I have trouble with Bucardo over postgres 10, so
>> I uninstall it and install Postgres version 9.4, Bucardo installs very well.
>>
>>  The Scenario is:
>>  I have to PG Servers under RHEL 6
>>  I add in pg_hba.conf file the host name and IP to get access (in both PG
>> servers)
>>  I reconfigured postgresql.config file to listen on any  address
>> (listen_addresses = '*' ) and to use port 5432... At these moment all ok.
>>
>>  Bucardo is installed with out errors..
>>
>>  I add 2 Server with Servername on bucardo database
>>
>>   But when I check status on Sync I can see that databases are no
>> synchorize, what did I miss my friends?
>>
>>
>>
>> [postgres at spd-psgre-ndb01 Bucardo-5.4.1]$ ./bucardo status sync_dbpmis2
>> ======================================================================
>> Use of uninitialized value $sourcedb in concatenation (.) or string at
>> ./bucardo line 6013.
>> Last bad                 : Dec 04, 2017 17:59:49 (time until fail: 1s)
>> Sync name                : sync_dbpmis2
>> Current state            : Bad   --> Why?
>> Source relgroup/database : dbtest2_dbtest1 /
>> 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:
>> no existe la relación «bucardo.bucardo_truncate_trigger» L�NEA 1:
>> ...ident(tname), MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bu...
>>                                                      ^ at
>> /usr/local/share/perl5/Bucardo.pm line 3299. Line: 5041 Main DB state: ?
>> Error: none DB dbtest1 state: ? Error: none DB dbtest2 state: 42P01 Error:
>> 7  (KID 17793)
>> ======================================================================
>>   What can I do?
>>
>>
>> Kind Regards!
>>
>> Hiram Walker O.
>>
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20171205/70d73902/attachment-0001.html>