[Bucardo-general] Failed to add sync: DBD::Pg::st execute failed: ERROR: Could not find "account_" inside the "public" schema on database "db"! at line 30.

[Пацев Антон]

Hi.
I understand fail.
Need create/copy table/schema on second server.
And need bucardo start (i dont start bucardo)

2017-05-17 18:50 GMT+06:00 Saiful Muhajir <saifulmuhajir at gmail.com>:

> Maybe you need to verify the tables and relgroups list and see if they are
> correct.
>
> bucardo list relgroups
> bucardo list tables
>
>
> ~
> Saiful
>
>
> On 17 May 2017 19:00, <bucardo-general-request at bucardo.org> wrote:
>
> Send Bucardo-general mailing list submissions to
>         bucardo-general at bucardo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://mail.endcrypt.com/mailman/listinfo/bucardo-general
> or, via email, send a message with subject or body 'help' to
>         bucardo-general-request at bucardo.org
>
> You can reach the person managing the list at
>         bucardo-general-owner at bucardo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Bucardo-general digest..."
>
>
> Today's Topics:
>
>    1. Failed to add sync: DBD::Pg::st execute failed: ERROR: Could
>       not find "account_" inside the "public" schema on database "db"!
>       at line 30. (????? ?????)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 16 May 2017 19:30:20 +0600
> From: ????? ????? <patsev.anton at gmail.com>
> To: bucardo-general at bucardo.org
> Subject: [Bucardo-general] Failed to add sync: DBD::Pg::st execute
>         failed: ERROR: Could not find "account_" inside the "public"
> schema on
>         database "db"! at line 30.
> Message-ID:
>         <CAOx4deorex2mDku5XZb0wRWDKjvFUmBV9HiY3xkWvv5bCBx-PQ at mail.gm
> ail.com>
> Content-Type: text/plain; charset="utf-8"
>
>
> Hello!
> i have error when when try sync
>
> I have script for automation:
>
> cat ./replica_add.sh
> #!/bin/sh
> . ./replica_env.sh
> for dbname in $dbname_list ;do
> dbname_s="`echo $dbname|sed -r 's/\-/_/g'`"
> echo "--------------------------------------------------"
> echo "DBNAME - ${dbname}"
> echo "--------------------------------------------------"
> bucardo add database ${dbname_s}_node1 dbname=${dbname} dbhost=${master}
> dbuser=postgres
> bucardo add database ${dbname_s}_node2 dbname=${dbname} dbhost=${slave}
> dbuser=postgres
> bucardo add table all --db=${dbname_s}_node1 --herd=${dbname_s}_herd
> strict_check=0
> bucardo add sequence all --db=${dbname_s}_node1 --herd=${dbname_s}_herd
> bucardo add dbgroup ${dbname_s}_servers_group ${dbname_s}_node1:source
> bucardo add dbgroup ${dbname_s}_servers_group ${dbname_s}_node2:target
> #bucardo add sync ${dbname_s}_sync herd=${dbname_s}_herd
> dbs=${dbname_s}_servers_group onetimecopy=1 strict_checking=0
> done
> echo "--------------------------------------------------"
> #sudo bucardo restart
> echo "done"
>
> cat ./replica_sync_add.sh
> #!/bin/sh
> . ./replica_env.sh
> for dbname in $dbname_list ;do
> dbname_s="`echo $dbname|sed -r 's/\-/_/g'`"
> echo "--------------------------------------------------"
> echo "DBNAME - ${dbname}"
> echo "--------------------------------------------------"
> bucardo add sync ${dbname_s}_sync herd=${dbname_s}_herd
> dbs=${dbname_s}_servers_group onetimecopy=1 strict_checking=0
> done
> echo "--------------------------------------------------"
> #sudo bucardo restart
> echo "done"
>
> Changed pg_hba.conf for access. Install bucardo install.
> ./replica_add.sh
> --------------------------------------------------
> DBNAME - subs_online_catalogue_dev
> --------------------------------------------------
> Added database "subs_online_catalogue_dev_node1"
> Added database "subs_online_catalogue_dev_node2"
> Creating relgroup: subs_online_catalogue_dev_herd
> Added table public.account_ to relgroup subs_online_catalogue_dev_herd
> .....
> New tables added: 207
> Sorry, no sequences were found
> New sequences added: 0
> Created dbgroup "subs_online_catalogue_dev_servers_group"
> Added database "subs_online_catalogue_dev_node1" to dbgroup
> "subs_online_catalogue_dev_servers_group" as source
> Added database "subs_online_catalogue_dev_node2" to dbgroup
> "subs_online_catalogue_dev_servers_group" as target
>
> ./replica_sync_add.sh
> --------------------------------------------------
> DBNAME - subs_online_catalogue_dev
> --------------------------------------------------
> WARNING:  Issuing rollback() due to DESTROY without explicit disconnect()
> of DBD::Pg::db handle dbname=subs_online_catalogue_dev;host=10.233.4.16 at
> line 1018.
> CONTEXT:  PL/Perl function "validate_sync"
> SQL statement "SELECT validate_sync('subs_online_catalogue_dev_sync')"
> PL/Perl function "validate_sync"
> Failed to add sync: DBD::Pg::st execute failed: ERROR:  Could not find
> "account_" inside the "public" schema on database
> "subs_online_catalogue_dev_node2"! at line 30.
> CONTEXT:  PL/Perl function "validate_sync" at /sbin/bucardo line 4612.
>
> --------------------------------------------------
> done
>
>
> What is wrong?
>
> --
> ? ?????????, ????? ?????.
> Best regards, Anton Patsev.
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachm
> ents/20170516/095a9bf5/attachment-0001.html>
>
> ------------------------------
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
>
> End of Bucardo-general Digest, Vol 114, Issue 8
> ***********************************************
>
>
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
>


-- 
С уважением, Антон Пацев.
Best regards, Anton Patsev.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20170517/920ff242/attachment-0001.html>