Fresh install of UTM 9. Updated it to the latest code available through Up2Date.
I have the machine installed for almost a month now and the executive report was only generated two days. I can generate a report on demand but, the automatically report generation is not working.
I double checked and the daily executive report option is checked and our emails are there.
I am not using SMTP smart host.
I found some postgress erros in my system log.
2012:11:01-00:00:01 GWBNF01 syslog-ng[2670]: Configuration reload request received, reloading configuration;
2012:11:01-00:02:01 GWBNF01 /usr/sbin/cron[17834]: (root) CMD ( nice -n19 /usr/local/bin/gen_inline_reporting_data.plx)
2012:11:01-00:02:41 GWBNF01 daemon-watcher[3689]: Watching selfmonng.plx - running fine
2012:11:01-00:05:01 GWBNF01 /usr/sbin/cron[17925]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2012:11:01-00:10:01 GWBNF01 /usr/sbin/cron[18028]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2012:11:01-00:15:00 GWBNF01 postgres[18122]: [2-1] LOG: unexpected EOF on client connection
2012:11:01-00:15:01 GWBNF01 /usr/sbin/cron[18137]: (root) CMD (nice -n19 /usr/local/bin/create_rrd_graphs.plx)
2012:11:01-00:15:01 GWBNF01 /usr/sbin/cron[18138]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2012:11:01-00:17:01 GWBNF01 /usr/sbin/cron[18705]: (root) CMD ( nice -n19 /usr/local/bin/gen_inline_reporting_data.plx)
2012:11:01-00:20:01 GWBNF01 /usr/sbin/cron[18803]: (root) CMD (/usr/local/bin/report_render.plx --archive --type yesterday --sendmail)
2012:11:01-00:20:01 GWBNF01 /usr/sbin/cron[18804]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2012:11:01-00:20:13 GWBNF01 postgres[3581]: [2-1] LOG: server process (PID 18873) was terminated by signal 6: Aborted
2012:11:01-00:20:13 GWBNF01 postgres[3581]: [3-1] LOG: terminating any other active server processes
2012:11:01-00:20:13 GWBNF01 postgres[18872]: [2-1] WARNING: terminating connection because of crash of another server process
2012:11:01-00:20:13 GWBNF01 postgres[18872]: [2-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2012:11:01-00:20:13 GWBNF01 postgres[18872]: [2-3] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2012:11:01-00:20:13 GWBNF01 postgres[4353]: [2-1] WARNING: terminating connection because of crash of another server process
2012:11:01-00:20:13 GWBNF01 postgres[4353]: [2-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2012:11:01-00:20:13 GWBNF01 postgres[4353]: [2-3] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2012:11:01-00:20:13 GWBNF01 postgres[18274]: [2-1] WARNING: terminating connection because of crash of another server process
2012:11:01-00:20:13 GWBNF01 postgres[18274]: [2-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2012:11:01-00:20:13 GWBNF01 postgres[18274]: [2-3] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2012:11:01-00:20:13 GWBNF01 postgres[4861]: [2-1] WARNING: terminating connection because of crash of another server process
2012:11:01-00:20:13 GWBNF01 postgres[4861]: [2-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2012:11:01-00:20:13 GWBNF01 postgres[4861]: [2-3] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2012:11:01-00:20:13 GWBNF01 postgres[3581]: [4-1] LOG: all server processes terminated; reinitializing
2012:11:01-00:20:14 GWBNF01 ulogd[4338]: pg1: server closed the connection unexpectedly
2012:11:01-00:20:14 GWBNF01 postgres[18879]: [5-1] FATAL: the database system is in recovery mode
2012:11:01-00:20:14 GWBNF01 postgres[18878]: [5-1] LOG: database system was interrupted; last known up at 2012-11-01 00:15:42 BRST
2012:11:01-00:20:14 GWBNF01 postgres[18878]: [6-1] LOG: database system was not properly shut down; automatic recovery in progress
2012:11:01-00:20:14 GWBNF01 postgres[18878]: [7-1] LOG: redo starts at 1/6A899B6C
2012:11:01-00:20:14 GWBNF01 postgres[18878]: [8-1] LOG: record with zero length at 1/6A8FB74C
2012:11:01-00:20:14 GWBNF01 postgres[18878]: [9-1] LOG: redo done at 1/6A8FB720
2012:11:01-00:20:14 GWBNF01 postgres[18878]: [10-1] LOG: last completed transaction was at log time 2012-11-01 02:20:12.076771+00
2012:11:01-00:20:15 GWBNF01 postgres[18886]: [5-1] FATAL: the database system is in recovery mode
2012:11:01-00:20:15 GWBNF01 postgres[3581]: [5-1] LOG: database system is ready to accept connections
2012:11:01-00:20:15 GWBNF01 postgres[18889]: [5-1] LOG: autovacuum launcher started
2012:11:01-00:22:37 GWBNF01 daemon-watcher[3689]: Watching selfmonng.plx - running fine
2012:11:01-00:25:01 GWBNF01 /usr/sbin/cron[18939]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2012:11:01-00:30:01 GWBNF01 /usr/sbin/cron[19032]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2012:11:01-00:30:01 GWBNF01 /usr/sbin/cron[19033]: (root) CMD (nice -n19 /usr/local/bin/create_rrd_graphs.plx)
2012:11:01-00:32:01 GWBNF01 /usr/sbin/cron[19593]: (root) CMD ( nice -n19 /usr/local/bin/gen_inline_reporting_data.plx)
2012:11:01-00:35:01 GWBNF01 /usr/sbin/cron[19675]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2012:11:01-00:40:01 GWBNF01 /usr/sbin/cron[19756]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2012:11:01-00:42:33 GWBNF01 daemon-watcher[3689]: Watching selfmonng.plx - running fine
This thread was automatically locked due to age.