Bug #9263: Error on report batch: NULL for non option type & on eventlog - Rudder - Issue Tracker

Actions

Copy link

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 about 8 years ago. Updated about 8 years ago.

Status:

Released

Priority:

1 (highest)

Assignee:

Nicolas CHARLES

Category:

Architecture - Code maintenance

Target version:

4.0.0~rc1

Pull Request:

https://github.com/Normation/rudder/p...

Severity:

UX impact:

User visibility:

Effort required:

Priority:

Name check:

Fix check:

Regression:

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])

Actions

Copy link

Updated by François ARMAND about 8 years ago

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)

Actions

Copy link

Updated by François ARMAND about 8 years ago

Status changed from New to In progress

Actions

Copy link

Updated by François ARMAND about 8 years ago

Description updated (diff)
Status changed from In progress to New

Actions

Copy link

Updated by Nicolas CHARLES about 8 years ago

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.

Actions

Copy link