pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ian Cass <ian.cass@mblox.com>
To: pgsql-sql@postgresql.org
Subject: Another postgres 'file not found' error
Date: Thu, 13 Jun 2002 12:17:00 +0100
Message-ID: <106501c212cb$d6f49750$6602a8c0@salamander> (raw)

This is the second time within a week I've been hit by a peculiar 'file not
found' error. I've been replacing a few existing Oracle servers with
Postgres. I'm wondering if that was a wise decision :/

inbound=# update store set state = 0, timestamp = 'now' where timestamp <
(CURRENT_TIMESTAMP - interval '30 seconds') and accountid = '6';
ERROR:  cannot open segment 1 of relation store_ix1 (target block
1576985508): No such file or directory

--
Ian Cass




view thread (7+ messages)  latest in thread

Message-ID: <106501c212cb$d6f49750$6602a8c0@salamander>
Permalink:  ../106501c212cb$d6f49750$6602a8c0@salamander/
Also on:    postgresql.org/message-id/106501c212cb$d6f49750$6602a8c0@salamander

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ian.cass@mblox.com
  Subject: Re: Another postgres 'file not found' error
  In-Reply-To: <106501c212cb$d6f49750$6602a8c0@salamander>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox