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.

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

connections not closed properly? #230

Open
Pomyk opened this issue Aug 17, 2018 · 1 comment
Open

connections not closed properly? #230

Pomyk opened this issue Aug 17, 2018 · 1 comment

Comments

@Pomyk
Copy link

Pomyk commented Aug 17, 2018

On second execution of a prepared statement the connection gets aborted, mysql increases 'Aborted clients' status variable and logs:

180816 13:39:30 [Warning] Aborted connection 3434103 to db: 'xxx' user: 'xxx' host: 'x.x.x.x' (Got an error reading communication packets).

Tested on MariaDB 5.5 and latest 10.3

@Pomyk Pomyk changed the title error on 2nd execution of prepared statement connections not closed properly? Aug 29, 2018
@Pomyk
Copy link
Author

Pomyk commented Aug 29, 2018

After some more debugging I think it isn't tied to prepared statements but to connection pool. Looks like connections that overflow the pool are not closed properly and mysql logs it as aborted connection.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant