This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

8.303 pgstat error

I had started this thread here https://community.sophos.com/products/unified-threat-management/astaroorg/f/51/t/21556
But since it is postgresql related I thought it would get more traffic here.
It has already hung up twice since applying the 8.303 Up2Date. By hanging up I mean Webadmin gives a server unavailable error when trying to connect, I can't login via SSH, It refuses to hand out new DHCP addresses. However, addresses with static mappings continue to work.
I keep getting these errors that point to postgresql.
system log2012:05:17-13:00:37 firewall1 postgres[13778]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:00:52 firewall1 postgres[4919]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:00:57 firewall1 postgres[13779]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:01:22 firewall1 postgres[13783]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:01:37 firewall1 postgres[4919]: [3-1] WARNING:  pgstat wait timeout
2012:05:17-13:01:42 firewall1 postgres[13784]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:01:52 firewall1 postgres[4919]: [4-1] WARNING:  pgstat wait timeout
2012:05:17-13:01:57 firewall1 postgres[13785]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:02:01 firewall1 /usr/sbin/cron[13788]: (root) CMD (  nice -n19 /usr/local/bin/gen_inline_reporting_data.plx)
2012:05:17-13:02:07 firewall1 postgres[4919]: [5-1] WARNING:  pgstat wait timeout
2012:05:17-13:02:12 firewall1 postgres[13794]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:02:22 firewall1 postgres[4919]: [6-1] WARNING:  pgstat wait timeout
2012:05:17-13:02:27 firewall1 postgres[13800]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:02:37 firewall1 postgres[4919]: [7-1] WARNING:  pgstat wait timeout
2012:05:17-13:02:42 firewall1 postgres[13801]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:02:52 firewall1 postgres[4919]: [8-1] WARNING:  pgstat wait timeout
2012:05:17-13:02:57 firewall1 postgres[13803]: [2-1] WARNING:  pgstat wait timeout
2012:05:17-13:03:07 firewall1 postgres[4919]: [9-1] WARNING:  pgstat wait timeout

This thread was automatically locked due to age.

0 BAlfson over 13 years ago

Look in the System messages and Selfmonitoring logs to see if you have Table errors. If so, you'll need to rebuild the PostgreSQL data bases at the command line.

Cheers - Bob
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 13 years ago in reply to BAlfson

The only odd entries in the self monitoring logs are these
I check Failed increment httpproxy_running counter 1 - 3
I check Failed increment identd_running counter 1 - 3
I check Failed increment syslogng_running counter 1 - 3

I rebuilt the tables according to this article https://community.sophos.com/products/unified-threat-management/astaroorg/f/53/t/33535
when it first started happening at version 8.301.
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 13 years ago in reply to JimmyM

OK. I ran the reporting DB restore and restarted the machine just to be sure. We'll see. I'm not very hopeful since I had done the restore in the past with no improvement. This is getting tiresome.
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 13 years ago in reply to JimmyM

Well, it just did it again.
I'm fed up with this horse s**t. What the hell happened to ASG? It used to be reliable. I'm going to upgrade to 8.0x from 8.3x. What a train wreck.
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 13 years ago in reply to JimmyM

Third time today.
Cancel
Vote Up 0 Vote Down

Cancel
0 BAlfson over 13 years ago

Jimmy, I'm not seeing this anywhere else. Can you check that hard disk with something like SpinRite?

Cheers - Bob
Cancel
Vote Up 0 Vote Down

Cancel
0 JimmyM over 13 years ago in reply to BAlfson

Jimmy, I'm not seeing this anywhere else. Can you check that hard disk with something like SpinRite?

Cheers - Bob

I have another SATA drive around, maybe I'll do a new install and import the config and see how things go. Now all I need is the time to do it. ;-)
Cancel
Vote Up 0 Vote Down

Cancel