We have written a web application using Turbine and Postgresql 7.02. The
version of Turbine I use is 20000908 - Ancient I know, but we couldn't
code against a moving target, so that was the version we used. It has been
reliable enough for us and we are happy with it.
However, we have noticed that after 3 months of testing, the DB server has
got a huge quantity of orphaned xinv and xinx files. These are reference
files used by Postgresql when it deals with Blobs.
In the SQL script for the Visitor table (as it was back then) there are
rules defined:
CREATE RULE Visitor delete_lo AS
ON DELETE TO Visitor
DO SELECT lo_unlink(old.OBJECTDATA);
and
CREATE RULE objectdata_delete_lo AS
ON DELETE TO Visitor
DO SELECT lo_unlink(old.objectdata);
I believe this is an attempt to clear up the orphaned xinv and xinx files
after a delete.
However we have found this is not removing all the xin* files.
In Turbine Snapshot 20010125, the SQL script for the Turbine_user table
does does not specify any 'clean up' rules,
has the orphaned xin* files problem been fixed somewhere - perhaps in the
JDBC driver, or in the current release of Postgresql?
I would be grateful for any help people can give me with this problem.
Thanks Andrew
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
