Enhancement #9752
Updated by François ARMAND over 4 years ago
After some time, we understood that the problem seems to be that some primary key constraints get dropped during upgrade. So we can have a totally wrong schema!
Logs contains following error:
<pre>
"[2016-11-30 13:59:04] ERROR com.normation.rudder.batch.AutomaticReportLogger$LAAutomaticReportLogger - could not fetch last id, don't log anything, wait next run, cause is Error when parsing property 'reportLoggerLastId'"
</pre>
and indeed, entry is duplicated in database:
<pre>
select value from rudderproperties where name='reportLoggerLastId';
value
-----------
153729188
153729188
</pre>
It occured during an upgrade, with the upgrade script that failed due to invalid db name used