On Tue, 17 Oct 2000, Tom Lane wrote:
> > and we have not had a crash on vacuum since that happened. If this
> > sounds consistent with the problem you think Alfred is having,
>
> Yes, it sure does.
>
> The patch I have applies atop a previous change in the REL7_0_PATCHES
> branch, so what I would recommend is that you pull the current state of
> the REL7_0_PATCHES branch from our CVS server, and then you can test
> what will shortly become 7.0.3. There are several other critical bug
> fixes in there since 7.0.2.
Hi Tom.
I have built from the REL7_0_PATCHES tree yesturday and did some testing on the
database. So far no crashes during vacuum like I had been seeing with 7.0.2
:).
I am seeing a different problem (and I have seen this with 7.0.2 as well). If
I run vacuum, sometimes this error pops up in the client appliction during the
vacuum:
ERROR: RelationClearRelation: relation 1668325 modified while in use
relation 1668325 is a view named "sessions".
what happens to sessions is that it does:
SELECT session_data, id
FROM sessions
WHERE id = ?
FOR UPDATE
.... client does some processing ...
UPDATE sesssions set session_data = ? WHERE id = ?;
(this is where the error happens)
I think part of my problem might be that sessions is a view and not a table,
but it is probably a bug that needs to be noted nonetheless. I am going to try
converting "sessions" to a view and see if I can reproduce it that way.
Mike