Astaro User Bulletin Board
Go Back   Astaro User Bulletin Board > Astaro Gateway Products > Management, Networking, Logging and Reporting
Reload this Page 7.306 Accounting Problem
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Welcome to the Astaro User Bulletin Board.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-08-2009, 11:14 PM
Junior Member
  
Join Date: Jul 2006
Location: Sydney, Australia
Posts: 6
Exclamation 7.306 Accounting Problem
Hi Everyone,

I installed the 7.306 Up2Date this morning and now my accounting page and executive report are not working.

I've read through a couple of threads and just would like some to confirm if database reinitialization listed in a couple of forums will fix my issue before I try it.

System log:

2009:02:09-10:08:59 (none) postgres[20062]: [3-1] ERROR: schema "_asg_cluster" does not exist
2009:02:09-10:08:59 (none) postgres[20062]: [3-2] STATEMENT: select "_asg_cluster".registerNodeConnection(2); unlisten "_asg_cluster_Event";
2009:02:09-10:09:04 (none) ulogd[9217]: pg1: error allocating keyset: Success
2009:02:09-10:09:08 (none) postgres[20053]: [4-1] LOG: unexpected EOF on client connection
2009:02:09-10:09:08 (none) postgres[20077]: [3-1] ERROR: schema "_asg_cluster" does not exist
2009:02:09-10:09:08 (none) postgres[20077]: [3-2] STATEMENT: select last_value::int4 from "_asg_cluster".sl_local_node_id
2009:02:09-10:09:09 (none) ulogd[9217]: pg1: error allocating keyset: Success
2009:02:09-10:09:09 (none) postgres[20079]: [3-1] ERROR: schema "_asg_cluster" does not exist
2009:02:09-10:09:09 (none) postgres[20079]: [3-2] STATEMENT: select "_asg_cluster".registerNodeConnection(2); unlisten "_asg_cluster_Event";
2009:02:09-10:09:14 (none) ulogd[9217]: pg1: error allocating keyset: Success
2009:02:09-10:09:18 (none) postgres[20077]: [4-1] LOG: unexpected EOF on client connection
2009:02:09-10:09:18 (none) postgres[20086]: [3-1] ERROR: schema "_asg_cluster" does not exist
2009:02:09-10:09:18 (none) postgres[20086]: [3-2] STATEMENT: select last_value::int4 from "_asg_cluster".sl_local_node_id
2009:02:09-10:09:19 (none) ulogd[9217]: pg1: error allocating keyset: Success
2009:02:09-10:09:19 (none) postgres[20088]: [3-1] ERROR: schema "_asg_cluster" does not exist
2009:02:09-10:09:19 (none) postgres[20088]: [3-2] STATEMENT: select "_asg_cluster".registerNodeConnection(2); unlisten "_asg_cluster_Event";
2009:02:09-10:09:24 (none) ulogd[9217]: pg1: error allocating keyset: Success
2009:02:09-10:09:28 (none) postgres[20086]: [4-1] LOG: unexpected EOF on client connection
2009:02:09-10:09:28 (none) postgres[20102]: [3-1] ERROR: schema "_asg_cluster" does not exist
2009:02:09-10:09:28 (none) postgres[20102]: [3-2] STATEMENT: select last_value::int4 from "_asg_cluster".sl_local_node_id
2009:02:09-10:09:29 (none) ulogd[9217]: pg1: error allocating keyset: Success
2009:02:09-10:09:29 (none) postgres[20104]: [3-1] ERROR: schema "_asg_cluster" does not exist
2009:02:09-10:09:29 (none) postgres[20104]: [3-2] STATEMENT: select "_asg_cluster".registerNodeConnection(2); unlisten "_asg_cluster_Event";

Thanks
__________________
--------
AndrewD

Technology: No Place for Wimps!
Reply With Quote
  #2 (permalink)  
Old 02-09-2009, 12:01 AM
Moderator
  
Join Date: Jul 2001
Location: southern California
Posts: 5,140
Default
If accounting was working before the update, then yes, the database is probably corrupted.
I believe the correct re-initialization procedure is at
http://www.astaro.org/98438-post49.html

You will lose all the old accounting data however.

Barry
__________________
http://DealBert.net
Home & business end-user since v1.x
  • ASL 6.3x, HP DL145 Dual Opteron, 1GB RAM, 6 gigE NICs, 50-IP Platinum License
  • ASL 7.3x, Dell PE1550 Dual PIII 1GHz, 1GB RAM, 2 NICs, 50-IP Platinum License
  • ASL 7.5x, 17-watt fanless mini-ITX system: MSI IM-945GSE-A Atom n270, 2GB RAM, Morex T3310 case. 2 Intel GigE, 3 VLANs. 80G 5200rpm 2.5" HD
    Netgear GS108T gigE VLAN switch & Linksys WRT54G WAP
    Total network infrastructure: 27 watts. 100-IP Home User. FiOS 10mb/2mb
Reply With Quote
  #3 (permalink)  
Old 02-09-2009, 11:40 AM
BAlfson's Avatar
Moderator
  
Join Date: Mar 2007
Location: Oklahoma City
Posts: 5,388
Default
Look here for 'reindex' and try that first.

Cheers - Bob
PS I'm 3-for-3 on situations where indexing did not solve the problem and re-initialzation was necessary.
__________________
ACE V7 - Astaro Preferred Partner since V3
Addicted to my iPhone!
Reply With Quote
  #4 (permalink)  
Old 02-10-2009, 09:26 AM
Junior Member
  
Join Date: Jul 2006
Location: Sydney, Australia
Posts: 6
Default
Hi Guys,

Thanks for the input.

The system message log was showing an error with asg_cluster.....

I run in HA mode and during the up2date the systems did switch roles, so out of curiosity I rebooted the master so it went back to the master/slave roles before the update....my accounting works again....

This might be a bug with the HA config?

Andrew
__________________
--------
AndrewD

Technology: No Place for Wimps!
Reply With Quote
  #5 (permalink)  
Old 02-10-2009, 09:49 AM
Moderator
  
Join Date: May 2001
Location: Karlsruhe, Germany
Posts: 925
Default
This indicates that the database on the current slave system is probably hosed. All accounting and reporting is only done on the master and the databases are synchronized to the slave, so if things are working now the master is fine but the slave may not.

Cheers,
andreas
__________________
GPG Key Fingerprint: FB30 CD95 55BF AC02 44A2 D4BC D7BB 9CAB 3725 FA7F
Reply With Quote
Reply

Tags
7.306, accounting

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 07:46 AM.

 
Contact Us - Astaro User Bulletin Board - Archive - Top

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.


These pages are specifically maintained for the discussion of firewall issues within the Open Source community, and might already reflect new alpha/beta releases under development. Please refer to our product specifications for the functionality of the actual release. Discussions of new/enhanced functionality does not constitute a commitment of Astaro, to integrate this functionality into future releases. issues within the Open Source community, and might already reflect new alpha/beta releases under development. Please refer to our product specifications for the functionality of the actual release. Discussions of new/enhanced functionality does not constitute a commitment of Astaro, to integrate this functionality into future releases.