Store PLCnext CommunityPLCnext on LinkedInPLCnext on Instagram  PLCnext on YouTube Github PLCnext CommunityStore PLCnext Community

  1. Arne Smets
  2. PLCnext Technology & PLCnext Controls
  3. Thursday, 20 May 2021
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
Martin PLCnext Team Accepted Answer Pending Moderation
0
Votes
Undo
Hi Arne,
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.
Phoenix Contact Electronics Headquarters - PLCnext Runtime Product Management and Support
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.