Database [mysql] timeout

Ignition
1

Hi all,
I’m working on a transaction group that calls a stored procedure defined on my database. This procedure deletes old records in a huge table and it takes a lot of time (called for example from SQLYog it takes around 4 minutes to finish). This long execution causes a read timeout in ignition after 120,001 ms (com.mysql.jdbc.exceptions.jdbc4.CommunicationsException).

I tried to update Read Timeout and OPC Browse timeout in the project properties, but nothing changed.

Any idea?

Thanks in advance

1 Like
2

Take a look at the “socketTimeout” extra connection property. Even better, modify your process to delete smaller chunks more often.

1 Like