Aleksander Kmetec aleksander.kmetec at intera.si
Thu Mar 12 13:22:39 PDT 2009
Hi,

I upgraded my slony install to 2.0.1 a couple of hours ago, but I'm still getting this message:
  NOTICE:  Slony-I: log switch to sl_log_1 still in progress - sl_log_2 not truncated
  CONTEXT:  PL/pgSQL function "cleanupevent" line 99 at assignment

I used the following upgrade procedure:
- killed slon daemons on both nodes
- compiled & installed new slony
- executed "update functions" for both nodes (I checked the output of \df+ logswitch_finish and the changes from 2.0.1 
are there)
- started slon daemons

Is there anything else I should do?

test_slony_state script only complains about the size of sl_log_2 (it now contains almost 30 million rows); everything 
else seems fine. Contents of sl_confirm look up to date on both nodes.

Also, a "fetch 500 from LOG;" statement is running at all times, but its xact_start is never older than a minute.

Any help would be appreciated.

Regards,
Aleksander


More information about the Slony1-general mailing list