|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/13/2009
Posts: 4
Location: PARIS
|
Hi all,
I actually use SQL Backup&FTP V3.3.4 and I have some troubles during sending backup on my FTP server, I have this error: "ERROR: Upload failed: The FTP command execution timed-out."
Nothing appears in the FTP server logs "> 226 Transfer OK". All seems to be OK, and sending backups using a FTP client works fine too.
Here is the log of SQL Backup & FTP:
SqlBackupAndFtp 3.3.4.31606 (Free)
SUMMARY:
Database DB: Backup - Success, FTP - Failure
DETAILED LOG:
10/13/2009 11:15:42 AM Creating backup of DB
10/13/2009 11:15:53 AM Backup of DB completed
10/13/2009 11:15:53 AM Zipping C:\WINDOWS\TEMP\xxxxx.may\DB20091013.bak to C:\WINDOWS\TEMP\xxxxx.may\DB20091013.zip
10/13/2009 11:16:44 AM Zip completed (compressed size: 143,286 Kb)
10/13/2009 11:16:44 AM Removing the backup: C:\WINDOWS\TEMP\xxxxx.may\DB20091013.bak
10/13/2009 11:16:44 AM Uploading C:\WINDOWS\TEMP\xxxxx.may\DB20091013.zip to ftp://myftpserver:21
10/13/2009 11:16:44 AM > USER user
10/13/2009 11:16:44 AM < 331 Password required for user
10/13/2009 11:16:44 AM > PASS *****
10/13/2009 11:16:44 AM < 230 Logged on
10/13/2009 11:16:44 AM > TYPE I
10/13/2009 11:16:45 AM < 200 Type set to I
10/13/2009 11:16:45 AM > PASV
10/13/2009 11:16:45 AM < 227 Entering Passive Mode
10/13/2009 11:16:45 AM > STOR DB20091013.zip
10/13/2009 11:16:45 AM Data connection established with myftpserver:3541 on 10/13/2009 @ 11:16:45 AM
10/13/2009 11:16:45 AM < 150 Connection accepted
10/13/2009 11:22:02 AM Disconnected from myftpserver:21 on 10/13/2009 @ 11:22:02 AM
10/13/2009 11:22:02 AM ERROR: Upload failed: The FTP command execution timed-out.
10/13/2009 11:22:02 AM Removing temporary folder C:\WINDOWS\TEMP\xxxxx.may
10/13/2009 11:22:02 AM Cleaning ftp://myftpserver:21/
10/13/2009 11:22:03 AM > USER user
10/13/2009 11:22:03 AM < 331 Password required for user
10/13/2009 11:22:03 AM > PASS *****
10/13/2009 11:22:03 AM < 230 Logged on
10/13/2009 11:22:03 AM > TYPE A
10/13/2009 11:22:03 AM < 200 Type set to A
10/13/2009 11:22:03 AM > PASV
10/13/2009 11:22:03 AM < 227 Entering Passive Mode
10/13/2009 11:22:03 AM > LIST
10/13/2009 11:22:03 AM Data connection established with myftpserver:3845 on 10/13/2009 @ 11:22:03 AM
10/13/2009 11:22:04 AM < 150 Connection accepted
10/13/2009 11:22:04 AM < 226 Transfer OK
10/13/2009 11:22:04 AM > QUIT
10/13/2009 11:22:04 AM < 221 Goodbye
10/13/2009 11:22:04 AM Disconnected from myftpserver:21 on 10/13/2009 @ 11:22:04 AM
Do you have any ideas?
Thanks,
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
At first sight, it resembles a firewall problem.
There are two channels opened when communicating with an FTP server. A command channel, on which all commands are sent and received, and data channel, on which all the actual data (files) are transferred.
The problem comes form the fact that while the file is being transferred on the data channel, nothing is being sent or received on the command channel. If this goes on for a long period of time, the firewall, not seeing any data go through on the command channel, can close it, thinking it is not in use any more. Therefore, when the server or the client wants to communicate on the command channel, it cannot do it since it is closed, thus the exception.
Please try to setup the firewall so its timeout period is long enough, so it does not close the command channel while the transfer is still going on.
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Hi again,
Please try to install and use the new version (3.4.2) of the program.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/13/2009
Posts: 4
Location: PARIS
|
Thanks for your help :)
I have the same problem with the new version.
If it can help, I have this error on my event viewer:
Event Type: Error
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 5000
Date: 19/10/2009
Time: 18:02:08
User: N/A
Computer: MYSERVER
Description:
EventType clr20r3, P1 sqlbackupandftp.exe, P2 3.4.2.28011, P3 4adb0b5d, P4 xceed.ftp, P5 4.1.9480.0, P6 4ac36a4b, P7 49, P8 41, P9 xceed.ftp.ftptimeoutexception, P10 NIL.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
kenji,
do you mean the application crashes writing such a message into the system log? If yes could you tell us what OS do you run the application under?
Mike
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/13/2009
Posts: 4
Location: PARIS
|
Yes,
My server is a Windows 2003 Server R2 Standard SP2.
Kenji
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
It seems we have faced such a problem before and did fix it. Let us contact developers of FTP module.
Thanks
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
hi to all
I also have the same problem. I do not know if aid but only occurs with databases with more than 7 Mb and, until seeing, in windows server 2003. I
already made a test in windows server 2008 and functions well.
I have opened the firewall (for test) without limitations for port 21 and have filezilla server configured with no timeouts.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Also having the sanme issue here, again server 2003 sp2.
The zipped file is 20MB. after sending about 9MB of the file we also get the timed-out error.
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Hi to all,
We need volunteers who will be able to test an experimental build of the program. This build contains fix of "FTP command execution timed-out" problem.
Please send me your email via PM. We will contact you.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 10/13/2009
Posts: 4
Location: PARIS
|
Hi Alex,
I sent you a MP ;)
K.
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Hi guys,
It seems we've fixed the problem of "The FTP command execution timed-out."
Those who got this error are welcome to try version 3.4.3.
Mike
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Hello!
Last version don't correct the error.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Guest wrote:Hello!
Last version don't correct the error. Yes, we're aware. But we're still short of testers. Could you please try 3.4.4 version then? You can get it at http://www.sqlbackupandftp.com/test/SqlBakSetup344.exeMike
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Yes!
Works fine!
But the end of the ftp session is not "elegant":
< 226 Transfer complete.
18/11/2009 17:04:49 > QUIT
18/11/2009 17:04:49 < 500 '�QUIT': command not understood <------- Why?
Thanks, thanks, thanks,... I will purchase soon.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Guest wrote:
< 226 Transfer complete.
18/11/2009 17:04:49 > QUIT
18/11/2009 17:04:49 < 500 '�QUIT': command not understood <------- Why?
Because different FTP servers understand different "QUIT" commands.
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Guys, please try to use version 4.3 Change log: * Fixed bug related to Xceed.Ftp.FtpTimeoutException * Fixed bug related to cleaning of old files (wrong date format) You can download the program from here
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Hi everyone, try to use our new version 4.5. We used a totally new FTP engine in it. You can download it from here http://sqlbackupandftp.com/download/
|
|
|
|
|
