MySQL connection DBFL_SQL_5 not closing properly
Hello all,
I have a database connection with the MySQL_ACCES block in the DBFL_SQL_5 library from the plcnext store.
This works fine, but somehow at night (so after several hours of usage) the host gets blocked.
This is because the MySQL server has reached it's limit of 150 connections. I can expand that number, but then the problem remains but shows up after a longer time.
If there is a connection with the PLCNext, the aborted connections of the server are not increasing and it seems stable, but then after it got blocked by the server it is trying to make a connection every cycle.
Then after a reset of the server (while host is still blocked), it is only trying to connect one time and after it stops. Is this caused by the server or by the PLCNext block? The feedback from the server is the same in both cases in PLCNext Engineer...
After a host flush, it will connect again without any problem. I think it is somehow not closing the connection properly, but I don't know what's causing the connection loss...
Has someone experienced something like this?
Arne
I have a database connection with the MySQL_ACCES block in the DBFL_SQL_5 library from the plcnext store.
This works fine, but somehow at night (so after several hours of usage) the host gets blocked.
This is because the MySQL server has reached it's limit of 150 connections. I can expand that number, but then the problem remains but shows up after a longer time.
If there is a connection with the PLCNext, the aborted connections of the server are not increasing and it seems stable, but then after it got blocked by the server it is trying to make a connection every cycle.
Then after a reset of the server (while host is still blocked), it is only trying to connect one time and after it stops. Is this caused by the server or by the PLCNext block? The feedback from the server is the same in both cases in PLCNext Engineer...
After a host flush, it will connect again without any problem. I think it is somehow not closing the connection properly, but I don't know what's causing the connection loss...
Has someone experienced something like this?
Arne
Comments
I have asked my colleagues in your local PxC subsidiary to contact you about this. They will be able to check your application for errors and advise on a solution.
~ Martin.