Hi Guys fresh install on ESXi 6, having all sorts of DB issues.
System log shows (As a sample):
2016:04:01-06:40:06 utm postgres[12420]: [344-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:40:06 utm postgres[12420]: [344-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:42:06 utm postgres[12420]: [345-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:42:06 utm postgres[12420]: [345-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:44:06 utm postgres[12420]: [346-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:44:06 utm postgres[12420]: [346-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:45:01 utm /usr/sbin/cron[8832]: (root) CMD ( /usr/local/bin/rpmdb_backup )
2016:04:01-06:45:01 utm /usr/sbin/cron[8838]: (root) CMD (/sbin/audld.plx --trigger)
2016:04:01-06:45:01 utm /usr/sbin/cron[8841]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2016:04:01-06:46:06 utm postgres[12420]: [347-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:46:06 utm postgres[12420]: [347-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:47:01 utm /usr/sbin/cron[8959]: (root) CMD ( nice -n19 /usr/local/bin/gen_inline_reporting_data.plx)
2016:04:01-06:48:06 utm postgres[12420]: [348-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:48:06 utm postgres[12420]: [348-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:50:01 utm /usr/sbin/cron[9356]: (root) CMD (/usr/local/bin/mg-agent --check_migration)
2016:04:01-06:50:01 utm /usr/sbin/cron[9360]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2016:04:01-06:50:01 utm /usr/sbin/cron[9361]: (root) CMD (/var/mdw/scripts/pmx-blocklist-update)
2016:04:01-06:50:06 utm postgres[12420]: [349-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:50:06 utm postgres[12420]: [349-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:52:06 utm postgres[12420]: [350-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:52:06 utm postgres[12420]: [350-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:54:06 utm postgres[12420]: [351-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:54:06 utm postgres[12420]: [351-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:55:01 utm /usr/sbin/cron[9513]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2016:04:01-06:56:06 utm postgres[12420]: [352-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:56:06 utm postgres[12420]: [352-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-06:58:06 utm postgres[12420]: [353-1] ERROR: relation "m" does not exist at character 15
2016:04:01-06:58:06 utm postgres[12420]: [353-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-07:00:01 utm /usr/sbin/cron[10002]: (root) CMD (/var/mdw/scripts/pmx-blocklist-update)
2016:04:01-07:00:01 utm /usr/sbin/cron[10005]: (root) CMD (/sbin/audld.plx --trigger)
2016:04:01-07:00:01 utm /usr/sbin/cron[10004]: (root) CMD ( /var/chroot-httpd/var/webadmin/extra/httpd_session_cleanup)
2016:04:01-07:00:01 utm /usr/sbin/cron[10006]: (root) CMD ( /var/chroot-http/var/sandboxd/tools/clear_cache_data.plx)
2016:04:01-07:00:01 utm /usr/sbin/cron[10008]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2016:04:01-07:00:01 utm /usr/sbin/cron[10007]: (root) CMD ( /usr/local/bin/rpmdb_backup )
2016:04:01-07:00:06 utm postgres[12420]: [354-1] ERROR: relation "m" does not exist at character 15
2016:04:01-07:00:06 utm postgres[12420]: [354-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-07:02:01 utm /usr/sbin/cron[10154]: (root) CMD ( nice -n19 /usr/local/bin/gen_inline_reporting_data.plx)
2016:04:01-07:02:06 utm postgres[12420]: [355-1] ERROR: relation "m" does not exist at character 15
2016:04:01-07:02:06 utm postgres[12420]: [355-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-07:04:07 utm postgres[12420]: [356-1] ERROR: relation "m" does not exist at character 15
2016:04:01-07:04:07 utm postgres[12420]: [356-2] STATEMENT: SELECT * FROM m WHERE cluster_id = '0' AND location = 'sandbox' AND action = 'pending'
2016:04:01-07:05:01 utm /usr/sbin/cron[10245]: (root) CMD ( /usr/local/bin/reporter/system-reporter.pl)
2016:04:01-07:06:07 utm postgres[12420]: [357-1] ERROR: relation "m" does not exist at character 15
Email protection will not function crashing shortly after boot:
QMGR[8713]: Master is gone, exiting too.
Can anyone point me in the right direction to getting this sorted?
I have performed a DB rebuild with /etc/init.d/postgresql92 rebuild
This is the output:
/etc/init.d/postgresql92 rebuild
Rebuilding PostgreSQL database, all reporting data will be lost!
Enter "yes" to continue...
yes
:: Stopping PostgreSQL done
:: Initializing the PostgreSQL database done
:: Starting PostgreSQL done
:: Restarting SMTP Proxy
:: Stopping SMTP Proxy
cat: /var/chroot-smtp/tmp/ram/pid/master: No such file or directory
cat: /var/chroot-smtp/tmp/ram/pid/master: No such file or directory
[ ok ]
:: Starting SMTP Proxy
mv: cannot stat `/var/chroot-smtp/tmp/smtpd_debug.log': No such file or directory
smtpd.bin already running (can't get lock on binary)
rmtree failed: No such file or directory
[ ok ]
[ ok ]
I have tried all sorts of Hardware versions, I have tried between e1000 nics and VMXNET 3
I am no DB expert. but I am surprised how mangled this VM is right out of the box.
I am using Partner lic, we use UTM hardware appliances all the time at work and this is a home lab for me to get on top of the configuration etc learning.
Thanks
Jason
This thread was automatically locked due to age.
