On T, 2005-08-02 at 16:41 -0400, Rod Taylor wrote:
> I'm not sure how it happened, but I currently have a synchronization
> error within the data in a structure between 2 databases.
> 
> Out of approx. 1 million entries, the discrepancy includes 8000 tuples.
>         
>         Standard Slony 1.0.5
>         Source DB is PostgreSQL 8.0.3
>         Destination DB is PostgreSQL 7.4.6
> 
> There have been no errors in the the Slony log files. Replication is not
> lagging (0 events behind in both directions), nor are there more than a
> few hundred entries in the sl_log_1 structure.
> 
> Any thoughts before I reset these structures?

What do you mean by "structures" ? 

Slony replicates only data, not structure.

Do you have any tables with many triggers (before and after, changing
tables back and forth) in your replicated set.

We've had problems with complicated trigger paths at some point.

-- 
Hannu Krosing <hannu at skype.net>