Hellu
After updating to MySQL 5.7 we get the mentionned error, at least it didn’t happen using 5.6 
And isActive is set to 0 and it never gets executed again.
Setup
- mysql:5.7.34
- xibosignage/xibo-cms:release-2.3.10
- xibosignage/xibo-xmr:release-0.8
- ianw/quickchart:v1.4.3
Error
mysql> SELECT * FROM task WHERE taskId=6;
+--------+-----------------------+----------------------------------+--------+------+---------+---------------+------------+----------------+---------------------------------------------------------------------------------------------------------------------+---------------+-----------------+-----------------+----------+--------+----------------------------+
| taskId | name | class | status | pid | options | schedule | lastRunDt | lastRunStartDt | lastRunMessage | lastRunStatus | lastRunDuration | lastRunExitCode | isActive | runNow | configFile |
+--------+-----------------------+----------------------------------+--------+------+---------+---------------+------------+----------------+---------------------------------------------------------------------------------------------------------------------+---------------+-----------------+-----------------+----------+--------+----------------------------+
| 6 | Fetch Remote DataSets | \Xibo\XTR\RemoteDataSetFetchTask | 3 | 0 | [] | */5 * * * * * | 1624394402 | 1624394700 | Fatal Error: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'lastRunMessage' at row 1 | 4 | 2 | 0 | 0 | 0 | /tasks/remote-dataset.task |
+--------+-----------------------+----------------------------------+--------+------+---------+---------------+------------+----------------+---------------------------------------------------------------------------------------------------------------------+---------------+-----------------+-----------------+----------+--------+----------------------------+
1 row in set (0.00 sec)
Database logs
2021-06-22 20:02:07+02:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.34-1debian10 started.
2021-06-22 20:02:07+02:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2021-06-22 20:02:07+02:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.34-1debian10 started.
2021-06-22T18:02:07.954124Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-22T18:02:07.959802Z 0 [Note] mysqld (mysqld 5.7.34) starting as process 1 ...
2021-06-22T18:02:07.965586Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-06-22T18:02:07.965627Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-22T18:02:07.965635Z 0 [Note] InnoDB: Uses event mutexes
2021-06-22T18:02:07.965641Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-06-22T18:02:07.965652Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-22T18:02:07.965659Z 0 [Note] InnoDB: Using Linux native AIO
2021-06-22T18:02:07.966395Z 0 [Note] InnoDB: Number of pools: 1
2021-06-22T18:02:07.966786Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2021-06-22T18:02:07.972031Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-22T18:02:07.992603Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-22T18:02:07.997125Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-06-22T18:02:08.018950Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-06-22T18:02:08.087036Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-06-22T18:02:08.087168Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-06-22T18:02:08.147100Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-06-22T18:02:08.147893Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-06-22T18:02:08.147931Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-06-22T18:02:08.153813Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 278583894420
2021-06-22T18:02:08.158087Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-06-22T18:02:08.158509Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-06-22T18:02:08.176459Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-06-22T18:02:08.176526Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-06-22T18:02:08.177972Z 0 [Warning] CA certificate ca.pem is self signed.
2021-06-22T18:02:08.178095Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-06-22T18:02:08.179378Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-06-22T18:02:08.179484Z 0 [Note] IPv6 is available.
2021-06-22T18:02:08.179520Z 0 [Note] - '::' resolves to '::';
2021-06-22T18:02:08.179551Z 0 [Note] Server socket created on IP: '::'.
2021-06-22T18:02:08.181564Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2021-06-22T18:02:08.184989Z 0 [Warning] 'proxies_priv' entry '@ root@cb98ca0f000d' ignored in --skip-name-resolve mode.
2021-06-22T18:02:08.221224Z 0 [Note] Event Scheduler: Loaded 0 events
2021-06-22T18:02:08.221637Z 0 [Note] mysqld: ready for connections.