Postgres 7.2.2 Segment Error

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Postgres 7.2.2 Segment Error
Date: 2002-09-19 07:16:36
Message-ID: GNELIHDDFBOCMGBFGEFOEEFECEAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I just saw this in my logs:

2002-09-18 12:13:10 ERROR: cannot open segment 1 of relation users_sessions
(target block 1342198864): No such file or directory

This query caused it:

DELETE FROM users_sessions WHERE changed < ('now'::timestamp - '1440
minutes'::interval) AND name = 'fhnid';

However, I cannot repeat the error now. Is this a bug in postgres
somewhere.

Also, what should I do to fix the table properly. I haven't vacuumed it or
anything yet in case someone wants to analyze it.

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB SD 2002-09-19 08:40:46 Re: Proposal for resolving casting issues
Previous Message Wim 2002-09-19 05:57:31 Re: [GENERAL] Still big problems with pg_dump!