we are running a sqlremote replicated setup with FTP as the message type.
SQL Remote Message Agent Version 188.8.131.527
The FTP server is running under linux, the consolidate database also (On the same server) The remote DB is on a windows 2008 r2 server (64Bit) and normally replication works fine.
But about 4-5 times a week the dbremote process on the windows server just stops working. In the service manager I see that it is still running, but it does not consume noticable CPU cycles and also does not respond on a stop service request.
After killing the dbremote service via kill I can restart the service and everything works smotth again for several hours...
In the dbremote logfile it then always hangs after these messages:
I. 2010-07-28 16:22:59. connect I. 2010-07-28 16:22:59. Getting server response: I. 2010-07-28 16:23:04. 150 Opening ASCII mode data connection for file list
So it seems that it can't retrieve a directory listing and for some reason just waits forever....
Any idea how can solve this problem ?
asked 02 Sep '10, 17:47