Re: [Proftpd-user] aborting unclosed fiile handle - DB connection reset

> We recently get a lot of error messages with SFTP stating “aborting 1
> unclosed file handle” in the logfile:

This usually happens when an SFTP client has a file opened for
reading/writing, and the connection is closed "uncleanly", meaning that
the client didn't have a chance to properly send the CLOSE SFTP request
to close that file.

> The server is configured to only provide SFTP protocol version 1-3
> support. Users are stored in a postgresql database where we see a lot of
> matching errors about connections being reset from the client side with
> “could not receive data from client: Connection reset by peer”.
> 
> It seems that the unclosed file handle message correlates with the
> database connection being reset without proper handshaking. The sql trace
> log shows no errors or warnings at all.
> Is there any way to debug this further? 

Do you have an SQLLogFile configured, which might show any
database-related queries/activity and/or errors?

Cheers,
TJ

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
ProFTPD Users List   <[email protected]>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html