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

[Mattia Marzo]

Hi,
to me is not clear which steps are you following for installing Bucardo.

But I can say that “bucardo.bucardo_truncate_trigger” is a table in the “bucardo” schema, a schema containing the tables used by Bucardo to keep track of every modification to the data that must be replicated from source to target.
These tables are created when you define dbs, dbgroup/relgroup, and syncs.

You have these 3 commands:
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

but I cannot see a “create sync” command; don’t’t know it this is the problem.
For sure, after the creation of db and dbgroup I create also a sync.

My suggestion is:

1.       Check if in the source db exists a schema named “bucardo”, and which tables were there are

2.       Try adding a “create sync” command

3.       If in the source db there is no such schema or the schema is present but there is no table named “bucardo_truncate_trigger” retry installation, and report here ALL installation steps, in order

Ciao,
M.

From: Bucardo-general <bucardo-general-bounces at bucardo.org> On Behalf Of nikhil raj via Bucardo-general
Sent: martedì 23 maggio 2023 21:50
To: bucardo-general at bucardo.org
Subject: [Bucardo-general] Kid has died, error is: DBD::Pg::st execute failed: ERROR: relation "bucardo.bucardo_truncate_trigger" does not exist


CAUTION: This email originated from outside the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
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<mailto: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/54ea7bb1/attachment-0001.htm>