Operation System: CentOS 7.7
Foreman Version: 1.22.2
Description:
I created an Ansible job template with several input parameters:
SID** : TESTDB01
sga_target_mb** : 2048
pga_target_mb** : 256
redo_memsize** : 50
redo_grpcount** : 3
data_gb** : 200
reco_gb** : 100
nls_characterset** : AL32UTF8
nslnchar_characterset** : AL16UTF16
tarballname** : dbHome_19.6.0.0.tgz
installtype** : DBINTERN
I run this Job against a server, the Ansible Job finished but Status remained by “running 100%”. I looked at the Job Task page and found a MySQL Error:
Mysql2::Error: Data too long for column ‘message’ at row 1: INSERT INTO `notifications …
Indeed i found that the field messages in table notifications is declared as VARCHAR(255), the message was 320 characters. I modified the column to VARCHAR(8192) and this error went away, the problem with “running 1oo%” still persists.
So i took a look on various tables in Foreman and found out that i have to modify all of these columns:
ALTER TABLE foreman_tasks_tasks MODIFY action VARCHAR(8192);
ALTER TABLE job_invocations MODIFY description VARCHAR(8192);
ALTER TABLE notifications MODIFY message VARCHAR(8192);
I think this is a bug, can you please fix it?
Thank you,
Thomas (Germany)