SQL Anywhere Mobile - missing transaction log

Author

missing transaction log

Eddy

2005-06-29, 1:25 pm

Have a remote db that has not been synced for about a month.
Now I ran mlsync and have come across this error.

Missing transaction log(s) after file "G:\DB\050528AB.LOG" (ends at offset
0002809929) and the on-line transaction log starts at offset 0003451461

Firstly the db does not get backed up due to it being a remote.
Offline directory is set to "G:\db"
Delete_old_logs is set to ON.
Not sure what happened but there are 3 logs and the actual online trans log in
the directory "G:\db":
050528AA.LOG, 050528AB.LOG, 050530AA.LOG and mont.log.

So obviously this missing log is either gone or deleted so what are my options
to get the sync working again??

ASA9.02

---== Posted via the PFCGuide Web Newsreader ==---
http://www.mcse.ms/_newsgroups/group_list.asp

Reg Domaratzki $iAnywhere Solutions$

2005-06-29, 1:25 pm

Based on the naming convention we use, I would have expected 050530AA.LOG to
come after 050528AB.LOG, yet dbmlsync is complaining that there is a gap
between 050528AB.LOG and the current transaction log.

Can you run dblog against each of the four transactions logs in the
directory (the engine cannot be running when you run dblog against the
current transaction log)? I'm curious as to whether there really is a gap
or not.

Also, what build of v902 are you using on the remote?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Eddy" <none@none.com> wrote in message news:42c2d323$1@foru
ms-1-dub...
> Have a remote db that has not been synced for about a month.
> Now I ran mlsync and have come across this error.
>
> Missing transaction log(s) after file "G:\DB\050528AB.LOG" (ends at offset
> 0002809929) and the on-line transaction log starts at offset 0003451461
>
> Firstly the db does not get backed up due to it being a remote.
> Offline directory is set to "G:\db"
> Delete_old_logs is set to ON.
> Not sure what happened but there are 3 logs and the actual online trans
log in
> the directory "G:\db":
> 050528AA.LOG, 050528AB.LOG, 050530AA.LOG and mont.log.
>
> So obviously this missing log is either gone or deleted so what are my
options
> to get the sync working again??
>
> ASA9.02
>
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.mcse.ms/_newsgroups/group_list.asp

Eddy

2005-06-29, 1:25 pm

Ok version is 9.02 build 2451
I made a mistake in the original post with the date of one trans log.
Here is the output from dblog

050528AA.LOG
Start 0002800219
End 0002804907

050528AB.LOG
Start 0002804907
End 0002809929

050630AA.LOG
Start 0002786021
End 0003451461

TRANS.LOG
Start 003451461
End 003455932

On 29 Jun 2005 10:02:33 -0700,
in sybase.public.sqlanywhere.mobilink
Reg Domaratzki $iAnywhere Solutions$ <FirstName.LastName@ianywhere.com> wrote:
>Based on the naming convention we use, I would have expected 050530AA.LOG to
>come after 050528AB.LOG, yet dbmlsync is complaining that there is a gap
>between 050528AB.LOG and the current transaction log.
>
>Can you run dblog against each of the four transactions logs in the
>directory (the engine cannot be running when you run dblog against the
>current transaction log)? I'm curious as to whether there really is a gap
>or not.
>
>Also, what build of v902 are you using on the remote?
>
>--
>Reg Domaratzki, Sybase iAnywhere Solutions
>Sybase Certified Professional - Sybase ASA Developer Version 8
>Please reply only to the newsgroup
>
>iAnywhere Developer Community : http://www.ianywhere.com/developer
>iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
>ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
>"Eddy" <none@none.com> wrote in message news:42c2d323$1@foru
ms-1-dub...
>log in
>options
>
>

Reg Domaratzki $iAnywhere Solutions$

2005-06-29, 8:25 pm

Are you sure that 050528AA.LOG and 050528AB.LOG belong to this database?
The offsets for those log files seem to be completely contained within
050630AA.LOG. Which offset is dbmlsync trying to scan from? There should
be a line in the dbmlsync output log similar to

I. 06/13 14:00:15. Log scan starting at offset 0000004498

If the log offset reported is less than 2786021, I suspect that 050528AA.LOG
and 050528AB.LOG are from a different database and are confusing the issue.
Try moving (not deleting, don't delete anything you don't have to)
050528AA.LOG and 050528AB.LOG to a different directory and see if
synchronization is successful.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Eddy" <none@none.com> wrote in message news:42c2e8ea$2@foru
ms-1-dub...
>
> Ok version is 9.02 build 2451
> I made a mistake in the original post with the date of one trans log.
> Here is the output from dblog
>
> 050528AA.LOG
> Start 0002800219
> End 0002804907
>
> 050528AB.LOG
> Start 0002804907
> End 0002809929
>
> 050630AA.LOG
> Start 0002786021
> End 0003451461
>
> TRANS.LOG
> Start 003451461
> End 003455932
>
>
> On 29 Jun 2005 10:02:33 -0700,
> in sybase.public.sqlanywhere.mobilink
> Reg Domaratzki $iAnywhere Solutions$ <FirstName.LastName@ianywhere.com>
wrote:[color=darkred
]
to[color=darkred]
gap[color=darkred]
http://www.ianywhere.com/developer/product_manuals[color=darkred]
offset[color=darkred
]

Sponsored Links