1.4 housekeeper problem

[hannibal20]

Hi,

I'm running 1.4.0 on Solaris 10 + MySQL. I've setup my environment and everything seemed to be running smoothly, but then I noticed a strange thing - my graphs were showing only last hour of data (grpfuncs based on the same data was beeing graphed correctly, with full history). I managed to corelate the missing data with housekeeper runs from the server log.

Then I looked into the 'housekeeper' table in the database. There were some references to my items. I've waited for the next housekeeper run, but the entries in housekeeper table were not deleted (while the data was). Then I deleted the entries manually and from now on my data isn't periodically cleaned. I remember clearing history data once (frontend), so the entries in housekeeper table must have remained in the database since then. The housekeeper didn't remove them.

I'll report some debug info when I have some.

[tronite]

Hi,

I'm running 1.4.0 on Solaris 10 + MySQL. I've setup my environment and everything seemed to be running smoothly, but then I noticed a strange thing - my graphs were showing only last hour of data (grpfuncs based on the same data was beeing graphed correctly, with full history). I managed to corelate the missing data with housekeeper runs from the server log.

Then I looked into the 'housekeeper' table in the database. There were some references to my items. I've waited for the next housekeeper run, but the entries in housekeeper table were not deleted (while the data was). Then I deleted the entries manually and from now on my data isn't periodically cleaned. I remember clearing history data once (frontend), so the entries in housekeeper table must have remained in the database since then. The housekeeper didn't remove them.

I'll report some debug info when I have some.

Have you set your agent to remove them?

[Alexei]

Housekeeper keeps data in the table until all associated data (history, trends) is removed. It make take days for large setups.

[hannibal20]

Housekeeper kept deleting all my time-series data every hour until I deleted the 'clear my data' tags from the database manually.

AFAIK agents have nothing to do with server's database.