Hi all,
looking in to my database table for the SPF-Cache (spfcache), I saw entrys
that are obsolet for a long time. Running the cleanup for the cache shows
me in the log that these records where deleted - but looking in to the
table, they still exists.
The pkey field of those obsolet records contains an IP followed by a space
and it looks like, that this space is removed by Tie::RDBM when the SQL
statement is build. For this reason assp is unable to delete these records
from spfcache. There is no functional issue caused by that obsolet records
- they only need memory and decrease the database performance a little.
If someone has the same problem, there are three possible actions to solve
it:
1. stop assp, drop the table 'spfcache' , start assp
2. delete all obsolet records with a tool of your choice
3. delete all records from that table with a tool of your choice
(2. and 3. can be done while assp is running)
the pkey field of an obsolet record looks like:
'1.1.1.1 '
the pkey field of a valid record looks like:
'1.1.1.1 host.domain.org'
Thomas
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Assp-test mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/assp-test
