From: | Antonio Fiol Bonnín <fiol(at)w3ping(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Relation modified while in use |
Date: | 2001-11-07 08:08:05 |
Message-ID: | 3BE8EBE5.3C9874FB@w3ping.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Wasem | 2001-11-07 10:18:35 | Memory exeception |
Previous Message | Kovács Péter | 2001-11-07 07:56:59 | Deleting records with text fields |