Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Python version of MySQLConnector seems to leak sockets #225

Closed
jamadden opened this issue May 10, 2019 · 3 comments
Closed

Python version of MySQLConnector seems to leak sockets #225

jamadden opened this issue May 10, 2019 · 3 comments
Labels
DB:MySQL DB:PostgreSQL
Milestone
3.0

Comments

@jamadden
Copy link
Member

This is in the build logs, but only for that particular driver:

checkPackAfterUndoDeletion (relstorage.tests.testmysql.HPMySQLTests) ... /home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36856), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
ok
checkPackAfterUndoManyTimes (relstorage.tests.testmysql.HPMySQLTests) ... /home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36896), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36900), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36904), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36908), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36912), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36916), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36920), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36924), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36928), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
/home/travis/virtualenv/python3.7.1/lib/python3.7/site-packages/transaction/_transaction.py:478: ResourceWarning: unclosed <socket.socket fd=9, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('127.0.0.1', 36932), raddr=('127.0.0.1', 3306)>
  del self._resources[:]
ok
@jamadden
Copy link
Member Author

I also see this for pg8000.

This was referenced May 13, 2019
Merged
Closed
@jamadden
Copy link
Member Author

jamadden commented May 13, 2019 •
edited
Loading

Some of this is due to zopefoundation/ZODB#268

EDIT: Actually, it seems all of this is due to that issue.

@jamadden jamadden added this to the 3.0 milestone May 13, 2019
jamadden added a commit that referenced this issue Jun 24, 2019
@jamadden
Fix another instance of leaking DB connections. cf #225
71aa210
@jamadden
Copy link
Member Author

Fixed by zopefoundation/ZODB#269

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
DB:MySQL DB:PostgreSQL
Projects
None yet
Milestone
3.0
Development

No branches or pull requests
1 participant
@jamadden