Bug #9263
closed
Architecture #2787: Use Doobie or Slick in place of SpringTemplate / squeryl / pur JDBC
Error on report batch: NULL for non option type & on eventlog
Added by François ARMAND over 7 years ago.
Updated over 7 years ago.
Category:
Architecture - Code maintenance
Description
On real data, when executing the batch for new reports, we get:
[2016-10-07 11:55:19] ERROR report - Could not get node execution reports in the RudderSysEvents table, cause is: could not
get Reports <- Could not fetch the last completed runs from database. <- SQL `NULL` read at column 1 (JDBC type BigInt) but
mapping is to a non-Option type; use Option here.
The culprit seem to be: ReportsJdbcRepository#getRuns
A similar issue arise when looking on event logs in getEventLogByCriteria(criteria : Option[String], optLimit:Option[Int] = None, orderBy:Option[String])
- Subject changed from Error on report batch: NULL for non option type to Error on report batch: NULL for non option type & on eventlog
- Description updated (diff)
- Status changed from New to In progress
- Description updated (diff)
- Status changed from In progress to New
When aplying a directive to a rule, I get the following error:
[2016-10-07 12:05:13] ERROR historization - Error with update rules historization process <- Could not update the rules historization information in base. <- L'élément du batch 0
insert into rulesdirectivesjoin (rulepkeyid, rulesdirectivesjoin)
values (105, '78e7889c-b5f2-41ed-a7af-269e1098d101')
a été annulé. Appeler getNextException pour en connaître la cause.
[2016-10-07 12:05:13] ERROR historization - Root cause was: L'élément du batch 0
insert into rulesdirectivesjoin (rulepkeyid, rulesdirectivesjoin)
values (105, '78e7889c-b5f2-41ed-a7af-269e1098d101')
a été annulé. Appeler getNextException pour en connaître la cause.
[2016-10-07 12:05:13] ERROR com.normation.rudder.batch.AsyncDeploymentAgent$DeployerAgent - Error when updating policy, reason Could not update the rules historization information in base. <- L'élément du batch 0
insert into rulesdirectivesjoin (rulepkeyid, rulesdirectivesjoin)
values (105, '78e7889c-b5f2-41ed-a7af-269e1098d101')
a été annulé. Appeler getNextException pour en connaître la cause.
- Status changed from New to Pending technical review
- Assignee changed from François ARMAND to Nicolas CHARLES
- Pull Request set to https://github.com/Normation/rudder/pull/1243
- Status changed from Pending technical review to Pending release
- % Done changed from 0 to 100
- Target version changed from 4.0.0~rc2 to 318
- Target version changed from 318 to 4.0.0~rc2
- Target version changed from 4.0.0~rc2 to 4.0.0~rc1
- Status changed from Pending release to Released
This bug has been fixed in Rudder 4.0.0 which was released the 10th November 2016.
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by 
Updated by