SQL Anywhere database replication

Author

unlink problem

Pavel Karady

2006-03-13, 9:23 am

Hella fellas (file replication, 9.0.2.2551),

CONS:
I. 03/13 13:16:26. unlink "D:\repdir\rem02.vk" failure 32: Permission denied

REMOTE:
Messages like "-85 Communication error" or "-101 Not connected to adatabase"
occur occasionally.

I want to understand the reason for cons database unlink failure... might
there be network problems between the cons and remote db machines? The cons
handles 8 more remote databases without any problem.

Could it be that the agent on problematic REMOTE db machine has a message
file locked somehow, so the cons db fails to delete it?

Thanks
Pavel

Pavel Karady

2006-03-13, 11:23 am

After reading the

http://www.ianywhere.com/developer/...ssage_file.html

tech doc, I think this fails into the category
remote-agent-still-writing-while-cons-agent-is-reading.

My question is, what's the behaviour then. Since message file names
mentioned in the unlink error message are always gone, I expect the agent
tries to read + delete the message file a second time, this time with
success (since writing of the remote agent has been finished) and the
message contents are being processed.

Or is the message content somehow lost and not processed?

Pavel

"Pavel Karady" <pavel_ns. ns_karady@ns_kogerus
a.com> wrote in message
news:44157258$1@foru
ms-2-dub...
> Hella fellas (file replication, 9.0.2.2551),
>
> CONS:
> I. 03/13 13:16:26. unlink "D:\repdir\rem02.vk" failure 32: Permission
> denied
>
> REMOTE:
> Messages like "-85 Communication error" or "-101 Not connected to
> adatabase" occur occasionally.
>
> I want to understand the reason for cons database unlink failure... might
> there be network problems between the cons and remote db machines? The
> cons handles 8 more remote databases without any problem.
>
> Could it be that the agent on problematic REMOTE db machine has a message
> file locked somehow, so the cons db fails to delete it?
>
> Thanks
> Pavel
>

Reg Domaratzki $iAnywhere Solutions$

2006-03-13, 1:23 pm

There's no risk of data loss in this situation. The resend request that
will be generated by the receiving side will ask for whatever hasn't been
successfully applied, whether that be the whole message or only part of the
message.

--
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/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Pavel Karady" <pavel_ns. ns_karady@ns_kogerus
a.com> wrote in message
news:4415acda$1@foru
ms-1-dub...
> After reading the
>
> http://www.ianywhere.com/developer/...ssage_file.html
>
> tech doc, I think this fails into the category
> remote-agent-still-writing-while-cons-agent-is-reading.
>
> My question is, what's the behaviour then. Since message file names
> mentioned in the unlink error message are always gone, I expect the agent
> tries to read + delete the message file a second time, this time with
> success (since writing of the remote agent has been finished) and the
> message contents are being processed.
>
> Or is the message content somehow lost and not processed?
>
> Pavel
>
> "Pavel Karady" <pavel_ns. ns_karady@ns_kogerus
a.com> wrote in message
> news:44157258$1@foru
ms-2-dub...
might[color=darkred]

message[color=darkre
d]
>
>

Pavel Karady

2006-03-13, 1:23 pm

Excellent news!

Thanks
Pavel

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:4415c77a$1@foru
ms-1-dub...
> There's no risk of data loss in this situation. The resend request that
> will be generated by the receiving side will ask for whatever hasn't been
> successfully applied, whether that be the whole message or only part of
> the
> message.
>
> --
> 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/swd/base.do
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "Pavel Karady" <pavel_ns. ns_karady@ns_kogerus
a.com> wrote in message
> news:4415acda$1@foru
ms-1-dub...
> might
> message
>
>

Sponsored Links