Hi Shahaf,

I have a similar setup, using log shipping. I have noticed that this particular error message is not as helpful as you might want. In fact, the log-shipper may actually want log #46 or #246. Just not the one you gave it (#44). I think the error message just gives you N+1, where N is the number of the log you tried to feed it.

Your log-shipped slave has a table called _shahaf_cluster.sl_archive_tracking. It should have been created by the slony1_dump.sh script. That table will contain one row, and the "at counter" (first field there) is the log number it ingested last. It wants the at_counter + 1. So, in the slavedb, select * from _sharaf_cluster.sl_archive_tracking;

Your slony logs should be numbered, monotonically increasing, and you should have that next log number in the directory where those logs live. If you have that correct log, have you tried applying it?

Which script are you using to apply the logs, anyway?

As to how it got "off" from the correct order, I am not sure. You'd have to check any logging programs you have, whose names are hopefully in the log-application script.

-Jennifer Spencer

Shahaf Abileah wrote:
Hello,

I'm trying to use the slony_logshipper tool to update a log-shipped
slave.  I kicked off the process and monitored the log file.  After a
short time, I noticed this in the log:

ERROR 2008-04-29 13:56:24 > PGRES_FATAL_ERROR: ERROR:  Slony-I: node is
on archive counter 44, this archive log expects 45

Query was: select "_shahaf_cluster".archiveTracking_offline('46',
'2008-04-29 13:41:46.204843');

WARN  2008-04-29 13:56:24 > waiting for resume

I can see the archiveTracking_offline function in the dump file I got
using slony1_dump.sh, the one I used to initialize my logshipped slave.
But I'm not familiar with the details of this replication scheme, so I'm
not sure why the archive counter would have gotten out of sync (whatever
that means).

Can anyone offer suggestions on how to fix this issue or how to analyze
it further?

Thanks,

--S

Shahaf Abileah | Lead Software Developer - Data Team

[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>  | tel: 206.859.2869 |
cell: 206.331.2057 | www.redfin.com <http://www.redfin.com>



------------------------------------------------------------------------

_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to