Skip to content

fix(Notification): increase 'message' field size to allow storing comments content

Nicolas.Rod requested to merge rodn-1395-increase-notification-message-field-size into 1.0-maintenance

En regardant le fameux problème des commentaires pas présents dans les emails, j'ai remarqué que les notifications pour ces commentaires n'étaient pas créées. Et voici ce que j'ai trouvé dans les logs de prod:

2022-09-06 16:18:24.153  INFO 1 --- [task-1906] c.u.aou.business.NotificationService     : will create notifications to validators for a new comment on Publication '8a6bf237-acc7-4ed7-9ec7-d2398c4cb7ef'
2022-09-06 16:18:24.610  INFO 1 --- [task-1906] c.u.aou.business.NotificationService     : notifications for new validators comments on publication created
2022-09-06 16:18:24.612  WARN 1 --- [task-1906] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 1406, SQLState: 22001
2022-09-06 16:18:24.612 ERROR 1 --- [task-1906] o.h.engine.jdbc.spi.SqlExceptionHelper   : (conn=1420488) Data too long for column 'message' at row 1
2022-09-06 16:18:24.613 ERROR 1 --- [task-1906] .a.i.SimpleAsyncUncaughtExceptionHandler : Unexpected exception occurred invoking async method: public void ch.unige.aou.business.NotificationService.listenToNewEventCreation(ch.unige.aou.model.notification.EventMessage)

Merge request reports