File size and readFileAsBytes function

Ignition
1

What size of file can readFileAsBytes cope with? We are using it to read in files which are then saved as BLOBs in a MySQL database. We have found that if the size of a file goes much beyond 5MB, the save starts and then (after maybe 15 seconds) the client suddenly shuts down without any warning.

The client initial memory limit is set to 32MB and the upper memory limit to 256MB. We are using Ignition 7.2.3. Are there any logs saved on the server or client which would help us pin down what is happening?

2

It probably has to do with the max packet size of MySQL. Check out this page:

dev.mysql.com/doc/refman/5.5/en/ … large.html

3

No, the max. packet size is set to 10MB.

4

Sounds like you’re running out of memory and Jython is exiting. readFileAsBytes doesn’t have any limits, but it does load the whole file into memory. Try upping your max memory for the client.