Uploaded image for project: 'Runtime'
  1. Runtime
  2. RUNTIME-4346

Impossible to execute async scripts with lots of characters

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 4.10.0, 4.9.12
    • 4.9.7
    • None
    • None
    • 4.10.1
    • Oui

      Context

      Ametys stores scripts in the JOB_DATA Column within the QRTZ_JOB_DETAILS table.

      By default, this column's data type is "Blob 65535".

      Issue

      If the script contains too many characters (over 64kB), it is not executed properly and the following log is sent:

      Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'JOB_DATA' at row 1
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping#translateException:104
at com.mysql.cj.jdbc.ClientPreparedStatement#executeInternal:916
at com.mysql.cj.jdbc.ClientPreparedStatement#executeUpdateInternal:1061
at com.mysql.cj.jdbc.ClientPreparedStatement#executeUpdateInternal:1009
at com.mysql.cj.jdbc.ClientPreparedStatement#executeLargeUpdate:1320
at com.mysql.cj.jdbc.ClientPreparedStatement#executeUpdate:994
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement#executeUpdate:462
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate#insertJobDetail:624
at org.quartz.impl.jdbcjobstore.JobStoreSupport#storeJob:1117
... 116 more

      Suggestion

      Change the datatype of the column to be more permissive of larger script data

            Unassigned Unassigned
            jhawken James Hawken
            Raphaël Franchet Raphaël Franchet
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: