Astaro User Bulletin Board
Go Back   Astaro User Bulletin Board > Astaro Gateway Products > Management, Networking, Logging and Reporting
Reload this Page No logging and corrupt database
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 06-19-2009, 02:36 AM
Junior Member
  
Join Date: Jun 2009
Posts: 2
Default No logging and corrupt database
Hi all

At a customer no executive reports have been send for months and no web or mail statistics are showing at the dashboard or anywhere else.

The log is filling up with messages like this:
2009:06:18-23:31:45 burmeisterfw ulogd[3197]: pg1: unable to connect: FATAL: "pg_tblspc/16519/16520" is not a valid data directory DETAIL: File "pg_tblspc/16519/16520/PG_VERSION" is missing.
2009:06:18-23:31:50 burmeisterfw postgres[7045]: [3-1] FATAL: "pg_tblspc/16519/16520" is not a valid data directory
2009:06:18-23:31:50 burmeisterfw postgres[7045]: [3-2] DETAIL: File "pg_tblspc/16519/16520/PG_VERSION" is missing.

And a: psql -s
reports: psql: FATAL: database "root" does not exist

I looks like the datebase is seriously corrupt.
Do anyone know how to repair or rebuild it.
Old data do not need to be saved.

Regards

Malik Hansen
Greenland
Reply With Quote
  #2 (permalink)  
Old 06-19-2009, 01:16 PM
BAlfson's Avatar
Moderator
  
Join Date: Mar 2007
Location: Oklahoma City
Posts: 4,952
Default
You didn't say what version of Astaro.

http://www.astaro.org/astaro-gateway..._adbs-plx.html

http://www.astaro.org/astaro-gateway...g-problem.html

http://www.astaro.org/astaro-gateway...ve-report.html

Quote:
Originally Posted by andreas
# psql -Upostgres -c"reindex database smtp;" smtp
# psql -Upostgres -c"reindex database pop3;" pop3
# psql -Ureporting -c"reindex database reporting;" reporting
# psql -Upostgres -c"vacuum;" smtp
# psql -Upostgres -c"vacuum;" pop3
# psql -Ureporting -c"vacuum;" reporting
Cheers - Bob
__________________
ACE V7 - Astaro Preferred Partner since V3
Addicted to my iPhone!
Reply With Quote
  #3 (permalink)  
Old 06-21-2009, 04:30 PM
Junior Member
  
Join Date: Jun 2009
Posts: 2
Default
Hi Bob

Right now it's version 7.403 and it's an ASG 110 but the problem appeared while running 7.3xx.
I've tried above commands and reporting fails
psql -Ureporting -c"reindex database reporting;" reporting
psql: FATAL: "pg_tblspc/16519/16520" is not a valid data directory
DETAIL: File "pg_tblspc/16519/16520/PG_VERSION" is missing

The other databases (pop3 and smtp) processes without errors.

Regards

Malik
Reply With Quote
  #4 (permalink)  
Old 06-21-2009, 06:47 PM
BAlfson's Avatar
Moderator
  
Join Date: Mar 2007
Location: Oklahoma City
Posts: 4,952
Default
Your reseller should get Astaro support involved.
__________________
ACE V7 - Astaro Preferred Partner since V3
Addicted to my iPhone!
Reply With Quote
Reply

« 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 10:45 PM.

 
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.