The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

In the update process the remote db has the log offset reset. I am getting this error "Subscription id 6: consolidated progress 43303783 and remote progress 43300426" which makes sense because the offset was changed. Just wondering the best way to fix this?

Thanks.

asked 09 Mar '12, 11:13

jimboidaho's gravatar image

jimboidaho
111141422
accept rate: 0%


Please use the procedures to upgrade a remote database that is involved in sync/replication. Please read the following section in the doc: SQL Anywhere 12 - Changes and Upgrading » Upgrading to SQL Anywhere 12 » Upgrading MobiLink » Upgrading SQL Anywhere MobiLink clients

permanent link

answered 09 Mar '12, 11:26

Yufei%20Guo's gravatar image

Yufei Guo
401213
accept rate: 6%

I am upgrading to 11. I have been using the 11 docs but I haven't seen an answer to this one yet.

(09 Mar '12, 11:30) jimboidaho

Sorry, I did not pay much attention to the version. Here is the 11 doc: SQL Anywhere 11 - Changes and Upgrading » Upgrading to SQL Anywhere 11 » Upgrading MobiLink » Upgrading SQL Anywhere MobiLink clients

(09 Mar '12, 11:33) Yufei Guo
Replies hidden

I read the docs again and I can't find anything about how to fix the offset difference between the remote and the consolidated.

(09 Mar '12, 11:38) jimboidaho

It did not tell you how to fix the offset mismatch. However, it does tell you how to upgrade a remote database and then how to zap the log offset after you upgraded the remote database.

(09 Mar '12, 11:45) Yufei Guo

I converted another remote and the offset matched. Not sure what I did the first time. Just in case someone else is reading this, dbunload -ar switch resets the log offset automatically so I could skip that part of the docs. Thanks everyone.

(09 Mar '12, 12:31) jimboidaho
showing 5 of 6 show all flat view
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×265

question asked: 09 Mar '12, 11:13

question was seen: 866 times

last updated: 09 Mar '12, 12:31