search

epuzanov / ZenPacks.community.PgSQLMon

PostgreSQL Database Monitor ZenPack
http://community.zenoss.org/docs/DOC-3497
GNU General Public License v2.0
4 stars 4 forks source link

zenperfsql doesn't seem to honour datasource cycleTime #2

Closed alienth closed 12 years ago

alienth commented 12 years ago

I turned my cycleTime down to 60 seconds for the pgSqlDatabase and pgSqlDatabaseStat templates. However, it appears that zenperfsql isn't honouring this, and it is sticking with a 300 second cycletime.

2012-05-01 21:42:12,810 INFO zen.zenperfsql: 24 devices processed (2116 datapoints)
2012-05-01 21:42:12,812 INFO zen.collector.scheduler: Tasks: 83 Successful_Runs: 128 Failed_Runs: 0 Missed_Runs: 203 Queued_Tasks: 68 Running_Tasks: 1 
2012-05-01 21:47:12,815 INFO zen.zenperfsql: 24 devices processed (4414 datapoints)
2012-05-01 21:47:12,818 INFO zen.collector.scheduler: Tasks: 83 Successful_Runs: 275 Failed_Runs: 0 Missed_Runs: 474 Queued_Tasks: 60 Running_Tasks: 1 
2012-05-01 21:52:12,821 INFO zen.zenperfsql: 24 devices processed (6570 datapoints)
2012-05-01 21:52:12,824 INFO zen.collector.scheduler: Tasks: 83 Successful_Runs: 415 Failed_Runs: 0 Missed_Runs: 744 Queued_Tasks: 60 Running_Tasks: 1

I've remodeled all of my devices, restarted zenoss entirely, and verified that the Database components aren't using a local template. Running on the latest HEAD of all of the related zenpacks.

alienth commented 12 years ago

I should note, on the previous version of this zenpack, I had the same issue. I got around it by manually setting the cycleTime in objects.xml and reinstalling. However, I don't think that should be necessary any longer, since the datasource now has the cycleTime field.

epuzanov commented 12 years ago

can you enable 'debug' logging level by zenperfsql daemon? I'm pretty sure that SqlPerformanceCollectionTasks will be created with a correct scheduleIntervalSeconds values (you can check this by job name).

alienth commented 12 years ago

Despite the debug setting existing in the zenperfsql.xml, I got the following when trying to enable it in zenperfsql.conf:

INFO: Commenting out unknown option 'debug' found on line 105 in config file

Going to try to run it in command-line mode with debug enabled.

alienth commented 12 years ago

Hm, I think this might actually be happening upon 5 minute runs due to Missed_Runs. Going to close this for now while I investigate further.

Thanks, Jason