|
Home > Archive > Slony1 PostgreSQL Replication > August 2005 > Improper Replication of structure
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Improper Replication of structure
|
|
| Rod Taylor 2005-08-02, 8:25 pm |
| 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?
--
| |
| Hannu Krosing 2005-08-02, 8:25 pm |
| 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-7C/ iILuz2RdeoWH0uzbU5w@
public.gmane.org>
| |
| Rod Taylor 2005-08-02, 8:25 pm |
| On Wed, 2005-08-03 at 00:30 +0300, Hannu Krosing wrote:
> On T, 2005-08-02 at 16:41 -0400, Rod Taylor wrote:
>
> What do you mean by "structures" ?
I intend to completely fry the Slony installation and start from
scratch.
It's obviously corrupted in some way or another.
> Do you have any tables with many triggers (before and after, changing
> tables back and forth) in your replicated set.
The only triggers are internal to PostgreSQL for foreign keys.
--
|
|
|
|
|