[Bucardo-general] Kid has died, error is: DBD::Pg::st execute failed: ERROR: relation "bucardo.bucardo_truncate_trigger" does not exist

[nikhil raj]

Hi All,

I have installed bucardo 1st time still getting the same error mention in
subject and again deleted the databases and again installed the same
install bucardo there is no error while again reinstalling it.



(21252) [Wed May 24 00:51:57 2023] MCP Starting check_sync_health
(21284) [Wed May 24 00:52:08 2023] KID (dbsync) New kid, sync "dbsync"
alive=1 Parent=21260 PID=21284 kicked=1
(21284) [Wed May 24 00:52:08 2023] KID (dbsync) Kid has died, error is:
DBD::Pg::st execute failed: ERROR:  relation
"bucardo.bucardo_truncate_trigger" does not exist LINE 1: ...ident(tname),
MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bu...
                                   ^ at
/usr/local/share/perl/5.26.1/Bucardo.pm line 3303. Line: 5037 Main DB
state: ? Error: none DB vs1db state: 42P01 Error: 7 DB vs2db state: ?
Error: none
(21284) [Wed May 24 00:52:08 2023] KID (dbsync) Kid 21284 exiting at
cleanup_kid. Sync "dbsync" Reason: DBD::Pg::st execute failed: ERROR:
 relation "bucardo.bucardo_truncate_trigger" does not exist LINE 1:
...ident(tname), MAX(EXTRACT(epoch FROM cdate)) FROM bucardo.bu...
                                                     ^ at
/usr/local/share/perl/5.26.1/Bucardo.pm line 3303. Line: 5037 Main DB
state: ? Error: none DB vs1db state: 42P01 Error: 7 DB vs2db state: ?
Error: none
(21252) [Wed May 24 00:52:08 2023] MCP Starting check_sync_health

OS Ubuntu 18.04
Postgres 15

Install bucardo

Current connection settings:
1. Host:           MTESHSTEST02
2. Port:           5432
3. User:           bucardo
4. Database:       bucardo
5. PID directory:  /var/run/bucardo
Enter a number to change it, P to proceed, or Q to quit: p

Attempting to create and populate the bucardo database and schema
Database creation is complete

Updated configuration setting "piddir"
Installation is now complete.
If you see errors or need help, please email bucardo-general at bucardo.org

You may want to check over the configuration variables next, by running:
bucardo show all
Change any setting by using: bucardo set foo=bar


NEXT STEP:-



bucardo add database vs1db dbname=test host=TEST02 port=5432 user=bucardo
   # src
bucardo add database vs2db dbname=test host=TEST03 port=5432 user=bucardo
    # target
bucardo add dbgroup grp1 vs1db:source vs2db:target


*Please help me from resolve this stuck from a day here. *
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20230524/63a47465/attachment.htm>