Thu Apr 29 11:01:40 PDT 2010
- Previous message: [Slony1-general] [slony-general] autovacuum and slony tables
- Next message: [Slony1-general] [slony1-general] initial copy incomplete when using 2.0.3rc2
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Jaime Casanova wrote: > On Thu, Mar 25, 2010 at 12:43 AM, Jaime Casanova Recall this was an issue where some inherited tables don't seem to have any data in them after the initial set copy. >>> I'm trying to get a sense of if this is a problem that is being triggered by >>> some schemas with inheritance tables or if it is that some of your data is >>> causing things to fail (which still shouldn't happen) >>> >> yeah! i'm trying to figure out what caused the rollback if any >> > > thinking a bit more on this, this should be as many rollbacks as > children has tcom_invitacion (one per month since 200803), and the log > shows that they were copied in 3 groups with other tables (that copied > fine) between those groups. > > so, the one million question is: why "only" those tables? > i have another partitioned table but that was fine I think you will find that the difference is that the inherited table has a lower slony table id (the id in the 'set add table') then the master table. The 'testinherit' test case in the regression tests directory actually reproduces this (if one takes the time to look at the output, which I should have been doing). However, this only seems to be a problem with 8.4, it works fine when I run it against 8.3 I have created bug 118 (http://www.slony.info/bugzilla/show_bug.cgi?id=118) to track this -- Steve Singer Afilias Canada Data Services Developer 416-673-1142
- Previous message: [Slony1-general] [slony-general] autovacuum and slony tables
- Next message: [Slony1-general] [slony1-general] initial copy incomplete when using 2.0.3rc2
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list