SQL Anywhere Mobile - Duplicate or partial error syncing when there are several logs (-x 2M)

Author

Duplicate or partial error syncing when there are several logs (-x 2M)

Ignacio Mateos

2005-08-02, 1:24 pm

Hi:

I tried to keep my logs in the remote databases from indefinitely growing by
using the option -x 2M for dbmlsync.

It worked but in some cases I had 2 different 2 M logs plus the actual
opened log and I got the error

"Duplicate or partial transaction found in log file...."

I deleted the first log and then I got an error, that the offset was not
found.

So I had to lose everything from that remote and cut a new one by deleting
the remote user and creating it again.

Where did I go wrong? (This happened to me several times) Do I have to be
looking and make sure to synchronize before the log gets to a size so they
don't accumulate?

What is the right procedure to do this?

Regards

Reg Domaratzki $iAnywhere Solutions$

2005-08-03, 11:24 am

Are you specifying a location for old transaction logs using the
OfflineDirectory extended option or by specifying a directory name as the
last entry on the dbmlsync command line?

Does the directory that holds your offline logs contains log files from
another database? Is it possible that you are also putting log files from a
BACKUP into this directory as well?

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

"Ignacio Mateos" <imateos@telefonica.net> wrote in message
news:42efbe87$1@foru
ms-1-dub...
> Hi:
>
> I tried to keep my logs in the remote databases from indefinitely growing
by
> using the option -x 2M for dbmlsync.
>
> It worked but in some cases I had 2 different 2 M logs plus the actual
> opened log and I got the error
>
> "Duplicate or partial transaction found in log file...."
>
> I deleted the first log and then I got an error, that the offset was not
> found.
>
> So I had to lose everything from that remote and cut a new one by deleting
> the remote user and creating it again.
>
> Where did I go wrong? (This happened to me several times) Do I have to be
> looking and make sure to synchronize before the log gets to a size so they
> don't accumulate?
>
> What is the right procedure to do this?
>
> Regards
>
>

Ignacio Mateos

2005-08-03, 1:26 pm

Thank you for answering:

I am not specifying the location in any way, my database with its log is in
\sc\db and that's where the old logs are going, there is no other file,
neither db backup, nothing else in that directory.

So the only thing in \sc\db is

sc9_cli.db sc9_cli.log and the truncated log files that dbmlsyn creates.

One more comment: I could not do the sync for 1 week, so by the time I got
to do it there were already 2 log files of 2 M each plus the current log
file that was very small.

Regards

Regards

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
escribió en el mensaje news:42f0cd88$1@foru
ms-2-dub...
> Are you specifying a location for old transaction logs using the
> OfflineDirectory extended option or by specifying a directory name as the
> last entry on the dbmlsync command line?
>
> Does the directory that holds your offline logs contains log files from
> another database? Is it possible that you are also putting log files from
> a
> BACKUP into this directory as well?
>
> --
> 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
>
> "Ignacio Mateos" <imateos@telefonica.net> wrote in message
> news:42efbe87$1@foru
ms-1-dub...
> by
>
>

Reg Domaratzki $iAnywhere Solutions$

2005-08-03, 1:26 pm

Can you post the output generated from running dblog against EVERY file
located in \sc\db ?

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

"Ignacio Mateos" <imateos@telefonica.net> wrote in message
news:42f10fa8@forums
-1-dub...
> Thank you for answering:
>
> I am not specifying the location in any way, my database with its log is
in
> \sc\db and that's where the old logs are going, there is no other file,
> neither db backup, nothing else in that directory.
>
> So the only thing in \sc\db is
>
> sc9_cli.db sc9_cli.log and the truncated log files that dbmlsyn creates.
>
> One more comment: I could not do the sync for 1 week, so by the time I got
> to do it there were already 2 log files of 2 M each plus the current log
> file that was very small.
>
> Regards
>
>
>
> Regards
>
>
>
> "Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
> escribió en el mensaje news:42f0cd88$1@foru
ms-2-dub...
the[color=darkred]
from[color=darkred]
growing[color=darkre
d]
not[color=darkred]
be[color=darkred]
>
>

David Fishburn

2005-08-08, 9:24 am

"Reg Domaratzki $iAnywhere Solutions$" <FirstName.LastName@ianywhere.com>
wrote in news:42f1107a@forums
-1-dub
of sybase.public.sqlanywhere.mobilink:

RD> Can you post the output generated from running dblog against EVERY file
RD> located in \sc\db ?

That output looks like this:

c:\>dblog cons.log
Adaptive Server Anywhere Transaction Log Utility Version 9.0.2.3137
File "cons.log" is a transaction log file
File version is 41
Log starts at offset 0000410293
Log ends at offset 0001476777
Log contains 544 pages with a page size of 2048 bytes
1066484 bytes in use (95.73%), 47628 bytes free (4.27%)

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links