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?


asked 09 Mar '12, 11:13

jimboidaho's gravatar image

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
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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 09 Mar '12, 11:13

question was seen: 2,473 times

last updated: 09 Mar '12, 12:31