From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Michael J Schout <mschout(at)gkg(dot)net> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: The lightbulb just went on... |
Date: | 2000-10-18 15:52:35 |
Message-ID: | 5002.971884355@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Michael J Schout <mschout(at)gkg(dot)net> writes:
> ERROR: RelationClearRelation: relation 1668325 modified while in use
> relation 1668325 is a view named "sessions".
Hm. This message is coming out of the relation cache code when it sees
an invalidate-your-cache-for-this-relation message from another backend
and the relation in question has already been locked during the current
transaction. Probably, what is happening is that the vacuum process is
vacuuming the view (not too much to do there ;-) but it does it anyway)
and sending out the cache inval message for it after the other client
process has already started parsing of a query using the view.
This is a fairly subtle problem that I don't think we will be able to
fix as a backpatch for 7.0.*. It's on the to-fix list for 7.1 though.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-10-18 16:07:59 | Re: toast operations while locking a buffer |
Previous Message | Michael J Schout | 2000-10-18 15:42:38 | Re: The lightbulb just went on... |