Relation modified while in use - Mailing list pgsql-jdbc

From Antonio Fiol Bonnín
Subject Relation modified while in use
Date
Msg-id 3BE8EBE5.3C9874FB@w3ping.com
Whole thread Raw
Responses Re: Relation modified while in use  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Hello,

I obtain:

java.sql.SQLException: ERROR:  RelationClearRelation:
relation 94191976 modified while in use

While executing:

select idzone,access_time,access_speed from
results_488131770, zones where ( ((date > '2001-11-07' )
or (date = '2001-11-07' and time >= '03:29:36')) and
((date < '2001-11-07' ) or (date = '2001-11-07' and time
<= '06:29:36')) ) and idhost=idagent;

Sometimes (not always), when a

VACUUM ANALYZE;

is running in parallel.

Is this known as a driver issue? Is it fixed? Is fixed driver compatible
to the old (7.0.3) backend?

Is it a (7.0.3) backend bug? (Probably, the answer is yes.) Is it fixed
on 7.1? If I must update the backend, what is the smoothest way (least
down time) ? (Probably not the right list, I know. Could someone forward
the mail to the right one, or tell me which one is best, please?)

Thank you very much.

Antonio Fiol


pgsql-jdbc by date:

Previous
From: Kovács Péter
Date:
Subject: Deleting records with text fields
Next
From: Peter Wasem
Date:
Subject: Memory exeception