[Bucardo-general] Config Problem (WHY CTL Could not add to q sync ?)

Matheus Lima guimapig at gmail.com
Tue Sep 16 16:58:14 UTC 2008


I've installed the bucardo, I would like to know if there is a more detailed
help, so I can figure out a problem Im having.

Neverthelesse I will put here a explanation so anybody could help me.

These are my population:

select name,dbhost,dbname,dbuser,dbpass,status,sourcelimit,targetlimit  from
db;
  name  |   dbhost    |     dbname     |  dbuser  |    dbpass     | status |
sourcelimit | targetlimit
--------+-------------+----------------+----------+---------------+--------+-------------+-------------
 Slave  | 192.168.0.4 | iotechschemerp | postgres | ****************** |
active |           0 |           0
 Master | 192.168.0.4 | altoschemerp   | postgres | ****************** |
active |           0 |           0

select
id,db,schemaname,tablename,reltype,pkey,pkeytype,has_delta,ghost,standard_conflict,analyze_after_copy
from goat;
 id |   db   | schemaname | tablename | reltype | pkey | pkeytype |
has_delta | ghost | standard_conflict | analyze_after_copy
----+--------+------------+-----------+---------+------+----------+-----------+-------+-------------------+--------------------
  1 | Master | public     | pais      | table   | id   | smallint |
f         | f     | source            | t
  3 | Slave  | public     | pais      | table   | id   | smallint |
f         | f     | target            | t

select * from herd;
 name |             cdate
------+-------------------------------
 pais | 2008-09-15 17:54:52.228395-03

select * from herdmap;
 herd | goat | priority |             cdate
------+------+----------+-------------------------------
 pais |    1 |        0 | 2008-09-15 17:56:54.151223-03

WHAT IS THIS TABLE????
select * from q;
 sync | sourcedb | targetdb | ppid | pid | synctype  | updates | inserts |
deletes |            started            |            aborted
|                  whydie                   |            ended
|             cdate
------+----------+----------+------+-----+-----------+---------+---------+---------+-------------------------------+-------------------------------+-------------------------------------------+------------------------------+-------------------------------
 pais | Master   | Slave    | 6244 |     | swap      |         |
|         | 2008-09-15 18:26:03.889172-03 | 2008-09-15 18:26:03.889226-03 |
Controller cleaning out unstarted q entry | 2008-09-15 18:26:03.88924-03 |
2008-09-15 18:02:06.606553-03
 pais | Master   | Slave    | 6528 |     | pushdelta |         |
|         | 2008-09-15 18:45:51.100074-03 | 2008-09-15 18:45:51.100126-03 |
Controller cleaning out unstarted q entry | 2008-09-15 18:45:51.10014-03 |
2008-09-15 18:26:04.411158-03
 pais | Master   | Slave    | 6721 |     | pushdelta |         |
|         |                               |
|                                           |                              |
2008-09-15 18:45:51.623033-03

select * from sync;
 name | source | targetdb | targetgroup | synctype  | stayalive | kidsalive
| usecustomselect | copytype | copyextra | deletemethod | limitdbs | ping |
do_listen | checktime | status | makedelta | rebuild_index | priority |
txnmode    | disable_triggers | disable_rules | analyze_after_copy |
overdue  | expired  |             cdate
------+--------+----------+-------------+-----------+-----------+-----------+-----------------+----------+-----------+--------------+----------+------+-----------+-----------+--------+-----------+---------------+----------+--------------+------------------+---------------+--------------------+----------+----------+-------------------------------
 pais | pais   | Slave    |             | pushdelta | t         | t
| f               | copy     |           | delete       |        0 | t    |
f         | 00:10:00  | active | f         | f             |        0 |
SERIALIZABLE | replica          | replica       | t                  |
00:00:00 | 00:00:00 | 2008-09-15 18:00:06.835946-03


# tail -f /var/log/syslog
Sep 16 13:36:03 garrafa Bucardo[6732]: CTL Timed out - force a sync for
"pais"
Sep 16 13:36:03 garrafa Bucardo[6732]: CTL Could not add to q
sync=pais,source=Master,target=Slave,count=1. Sending manual notification

WHATS WRONG?
There is a more detailed log?

Thanks in advance!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20080916/42b7e0bb/attachment.html 


More information about the Bucardo-general mailing list