how to troubleshoot aborted connection mysql?

Questionshow to troubleshoot aborted connection mysql?
sethbeckerman5 Staff asked 7 years ago

I keep getting this in my mysql error log.

Combed trough the php code and made sure that am calling mysqli->close on the db resource when my script is about to finish.

My project stack: apache2.4 with php-fpm7.2 and mysql 5.7.25 on ubuntu 18.10.

Is there any way i can get more insight into this issue?

Just checked firewall but it is Inactive

I found the issue for this. I was not clearing all results before closing the db connection so i just clear all results explicitly using php then i make the db->close. The log lines dissapeared from /var/log/mysql/error.log.


View on Stack Overflow