[freeside] Output from freeside-daily

[ivan at 420.am]

On Tue, Dec 03, 2002 at 03:13:51AM -0500, Timothy M. Butkiewicz wrote:
> 
> Anyone have any idea what this might mean?
> 
> Output from command /usr/bin/freeside-daily freeside ..
> 
> NOTICE:  Skipping "pg_type" --- only table owner can VACUUM it

I guess I wouldn't worry about these.  The freeside database user is not
goint to be able to VACUUM system tables.

> NOTICE:  RegisterSharedInvalid: SI buffer overflow
> NOTICE:  InvalidateSharedInvalid: cache state reset

I wouldn't worry about this either.  Despite the alarming-sounding
"buffer overflow" name, this is apparantly a normal PostgreSQL
condition.  I believe the gratuitous message has been removed in current
versions.

> NOTICE:  Skipping "part_svc" --- only table owner can VACUUM it
> NOTICE:  Skipping "svc_acct_sm" --- only table owner can VACUUM it
> NOTICE:  Skipping "cust_bill_event" --- only table owner can VACUUM it
> NOTICE:  Skipping "radreply" --- only table owner can VACUUM it
> NOTICE:  Skipping "part_svc" --- only table owner can VACUUM it
> NOTICE:  Skipping "svc_acct_sm" --- only table owner can VACUUM it
> NOTICE:  Skipping "cust_bill_event" --- only table owner can VACUUM it
> NOTICE:  Skipping "radreply" --- only table owner can VACUUM it

These seem to indicate you've been making changes to your database and
have somehow caused these tables to not be owned by the freeside user
anymore.  In PostgreSQL, If tables aren't VACUUMed periodically,
performace will degrade.

-- 
_ivan