Joseph S jks at selectacast.net
Thu Jun 17 14:49:30 PDT 2010
I'm having a problem with 2.0.4 but it isn't related to the problem I 
was having with 2.0.3.  I had a table that I kept creating, adding to 
the slony replication set, and then dropping and starting over.  During 
this time I wasn't running slony because of the bugs in 2.0.3.  Now that 
2.0.4 rc2 is running it got stuck in a loop trying to create this table 
and failing because it existed already.  I kept dropping the table from 
my slave until that wasn't a problem anymore but now it is stuck in a 
loop doing this:


ERROR:  Slony-I: alterTableDropTriggers(): Table with id 41 not found
CONTEXT:  SQL statement "SELECT  "_devel".alterTableDropTriggers( $1 )"
         PL/pgSQL function "dropset_int" line 18 at PERFORM
STATEMENT:  select "_devel".dropSet_int(999); insert into 
"_devel".sl_event     (ev_origin, ev_seqno, ev_timestamp, 
ev_snapshot, ev_type , ev_data1    ) values ('1', '5000048246', 
'2010-04-27 18:44:50.666916', '720295:720295:', 'DROP_SET', '999'); 
insert into "_devel".sl_confirm   (con_origin, con_received, con_seqno, 
con_timestamp)    values (1, 2, '5000048246', now()); commit transaction;
LOG:  unexpected EOF on client connection

How can I break it out of this loop?

Steve Singer wrote:
> Joseph S wrote:
>> I can't compile 2.0.4 rc2
>>
>> make[2]: *** [scan.o] Error 1
>> make[2]: Leaving directory 
>> `/local/download/src/slony1-2.0.4.rc2/src/slony_logshipper'
>> make[1]: *** [all] Error 2
>> make[1]: Leaving directory `/local/download/src/slony1-2.0.4.rc2/src'
>> make: *** [all] Error 2
> 
> 
> This is actually a bug in the distclean rule in slony_logshipper.  Our 
> policy has been to require bison/flex for cvs builds but to include the 
> generated files in the tarfiles.  The distclean rule seems to be 
> deleting the scan.l file.
> 
> If you install flex you can avoid that error.   We will include those 
> files in the next tarfile (technically this means we should have a rc3 
> but I'd like to see what else people find)
> 
> Thanks
> 
>>
>> There is a scan.c under src/slonik/
>>
>> Steve Singer wrote:
>>> Joseph S wrote:
>>>> Should I blow away my old slave database and rereplicate from 
>>>> scratch?  Or can I just upgrade slony and start it up?
>>>>
>>>> Steve Singer wrote:
>>>>> I have tagged Slony-I 2.0.4 RC2
>>>>>
>>>>> This is like 2.0.4 RC1 plus the memory leak fixes discussed on the 
>>>>> list.
>>>>>
>>>>> http://lists.slony.info/downloads/2.0/source/slony1-2.0.4.rc2.tar.bz2
>>>>>
>>>>> It would be nice if people could test it and report back to the list.
>>>>>
>>>>>
>>>
>>>
>>> As long as your test database was in a resonable state the upgrade 
>>> from a previous 2.0.x release should work fine.  Please report any 
>>> issues you encounter
>>>
>>>
>>>>>
>>>>>
>>>>>   
>>>> _______________________________________________
>>>> Slony1-general mailing list
>>>> Slony1-general at lists.slony.info
>>>> http://lists.slony.info/mailman/listinfo/slony1-general
>>>
>>>
>>
> 
> 



More information about the Slony1-general mailing list